OmnisXL / ExcelFormat : formatting cells after $populatewithlist
I am playing around with Artsman’s ExcelFormat external and I have hit a
Basically, what I would like to do is save an Omnis list as an Excel
file and set the
row height and text wrap properties for all cells. So my code looks like
Do lXLSBook.$addformat() Returns lXLSFormat
Do lXLSFormat.$bordertop.$assign(kXLBorderStyleDouble) ;; ** purely
to visualize the issue
Do lXLSBook.$getsheet(1) Returns lXLSSheet
For lList.$line from 1 to lList.$linecount step 1
The resulting Excel file has all rows with height 20, but the lXLSFormat
applied to the cells that come after my imported list. So if lList has 3
only column D and beyond have text wrap and a border style.
Any idea what I am doing wrong here? It works fine if I do it cell by
But that seems like a bit overkill.
Manage your list subscriptions at lists.omnis-dev.com