Page 1 of 1

Insert formula

Posted: Tue Sep 17, 2013 9:40 am
by odisej
I have successfully now compiled new version. I'm waiting for my boss to buy components for me. In the meantime I have few bugs to report.

I compiled XLSSpreadSheetAdvanced. Go to cell A1 and press 2 and then enter. That inserts 2 into cell A1 and puts you into cell A2. Press 3 and then enter. Now you are in cell A3. Press = I get Invalid pointer operation.
Press escape and double click with mouse into A3. Enter =a1+a2 (lower case) and press enter. Result is 0. Go back to cell A3 and check the formula in that cell. It's =AG1+AG2.

Grega

Re: Insert formula

Posted: Wed Sep 18, 2013 11:37 pm
by larsa
Hello

I had no luck reproducing the "Invalid pointer operation" error.

The error with the cell refs is caused by the refs are lowercase. If you enter uppercase text, result is correct. Will fix this in the next update.