Hi Jonathan, Message de Jonathan Kaye date 2008-02-06 06:30 :
I want to set up a column in a spreadsheet containing 18 fields. So in cell T1 I enter the following: =map(b1) and I get the following behaviour: a window opens saying OO Calc found an error in the formula entered it asks if I want to accept correction ='map'*(B2) if I accept, it returns 0 if I don't accept it returns error 509. Now I open I new sheet and copy Column b of the first sheet onto column b of the new sheet. I enter the same formula =map(b2) into, say, cell T2 and it works perfectly.
You are the victim of a supposedly smart feature. There is somewhere in the same column a cell containing the text : map
Solution: Menu Tools > Options > OpenOffice.org Calc > Calculate *uncheck* : Automatically find column and row labels ______ Bernard --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
