Sherlock, Ric wrote:
From the Tara Lab I understand that you are not supposed to write to the
same cell more than once (including formatting). This requires some
gymnastics when trying to format a worksheet with data, but is doable.
Borders are perhaps the most tedious, and drastically increase the
number of cells with distinct formats.
Format in Tara is quite limited. Theoretically it is possible to create complex
formatted sheets but sometimes I rather use ole interface to work on a template
worksheet.
From the lab:
"Setting cell border is troublesome. You cannot specify a block of
cells and set their top border or outline border. Instead your have to
write string/number/blank to each cell individually to set the cell
border and content in the same 'writestring'/'writenumber'."
This might work if you only want to create a block of cells with border like
+-+-+--+--+
|0|1|2 |3 |
+-+-+--+--+
|4|5|6 |7 |
+-+-+--+--+
|8|9|10|11|
+-+-+--+--+
create a format with all 4 (top,bottom,left,right) borders, and write all the
cells with that format. At least it looks ok in excel.
While creating a sheet, I discovered that if the border format has been
previously defined and you use addcolinfo to change the column width,
the border setting of all the cells in the column is set (doesn't seem
to work with addrowinfo & row height). If there are cells in the column
that have already been written then, their border will not be changed,
so unfortunately it isn't a mechanism to specify borders independent of
writestring/writenumber, but still potentially useful as long as it
isn't likely to cause problems with the file format.
Is using addcolinfo to set borders likely to cause problems with the
file or is it "allowed"?
I'm not sure why addcolinfo will change format. Actually addcolinfo record will
be written independent of cell records. May be you also test it against
different spreadsheet programs like openoffice or gnumeric.
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
--
regards,
bill
----------------------------------------------------------------------
For information about J forums see http://www.jsoftware.com/forums.htm
