Insert formula

Questions and answers on how to use XLSSpreadSheet.
Post Reply
odisej
Posts: 34
Joined: Mon Apr 08, 2013 7:42 am

Insert formula

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Insert formula

Post 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.
Lars Arvidsson, Axolot Data
Post Reply