Search found 3 matches
- Tue Oct 18, 2011 1:41 am
- Forum: XLSReadWriteII 3/4/5
- Topic: AsFormula =#N/A error
- Replies: 4
- Views: 5288
Re: AsFormula =#N/A error
The only way I have found around the problem is the following.... xls.sheets[0].AsFormula[1,1]:='SUM(A1,B1)'; which could also be written as xls.sheets[0].AsFormula[1,1]:='SUM(A1:B1)'; in this case. or in my case xls.sheets[0].AsFormulaRef['H7'] := 'PRODUCT(C7:D7)'; But still haven't found a way to ...
- Fri Oct 14, 2011 12:31 am
- Forum: XLSReadWriteII 3/4/5
- Topic: AsFormula =#N/A error
- Replies: 4
- Views: 5288
Re: AsFormula =#N/A error
I have the same problem with the same trial version using D_2010 when trying: xls.sheets[0].AsFormulaRef['H7'] := 'C7*D7'; Excel version 14.0.4734.1000 (32-bit) ....and still can't find a solution to the previous post about how to set currency formatting: with XLRW.Sheet[0] do begin Range.ItemsRef['...
- Wed Oct 12, 2011 7:06 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Currency format
- Replies: 1
- Views: 5759
Currency format
Hi, I'm testing XLSReadWriteII4 trial version. (First time to use any XLSReadWrite version.) While this software may be intuitive and obvious to many, it's not to me! After searching through the help file and this bulletin board, I can't find any information about formatting a cell to 'currency'. I'...