Bernard Marcelly wrote: > 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
Salut Bernard, Yes, you got it one. There is a cell with "mapa" in it. Out of (sadistic) curiosity can you explain why changing the column to another sheet gets rid of the error? I never turned on the "feature" Automatically find column and row labels so I assume it's checked on all new pages by default. In any event you're a bloody genius. I really struck gold on this list. Cheers, Jonathan -- Registerd Linux user #445917 at http://counter.li.org/ Please do not send me copies of list mail. I read the lists. Thanks! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
