Search found 3 matches
- Tue Dec 15, 2009 12:44 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Wrong format when both Row and Column format defined
- Replies: 2
- Views: 5580
Re: Wrong format when both Row and Column format defined
I did not explain well. I am setting values into an EXCEL sheet which the end-user created. The end-user creates the formatting, then my code sets the values. Sometimes the user's formatting gets corrupted when TXLSReadWriteII sets the values. To reproduce - In EXCEL, create an empty spreadsheet Sel...
- Fri Dec 11, 2009 12:54 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: How to set the font size of footer
- Replies: 1
- Views: 2845
Re: How to set the font size of footer
From Help for TPrintSettings Footer property
&NN=Set font size to NN points
e.g.
Sheets[0].PrintSettings.Footer := '&L&12A&24B&36C'; // For left footer text, A 12pt / B 24pt / C 36pt
hth
Edward Benson.
&NN=Set font size to NN points
e.g.
Sheets[0].PrintSettings.Footer := '&L&12A&24B&36C'; // For left footer text, A 12pt / B 24pt / C 36pt
hth
Edward Benson.
- Wed Dec 09, 2009 6:29 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: Wrong format when both Row and Column format defined
- Replies: 2
- Views: 5580
Wrong format when both Row and Column format defined
I have an Excel template into which I am writing values using XLSReadWriteII. I am using XLSReadWriteII v3 and Excel 2000. The template has Column Formats, Row Formats, and Cell Formats defined. For cells which have both column and row format defined, when XLSReadWriteII writes data into an empty ce...