3924 Views 12 Replies Latest reply: Jan 30, 2010 11:39 AM by KOENIG Yvan
I recall a post a while ago where Numbers was having a problem with a cell name that had several quotes or apostrophes in it, I can't remember which. It might have the same problem with too many periods (decimal points). I tried the cell name you posted and had no problem but we are probably not using the same localization so your mileage may vary.
thank you very much for trying to replicate.
Yes, your assumption is correct. My setting is German in my system.
For example, one "problem-formula" reads
"=(Zählerstand 16.01.2010-Zählerstand 11.06.2009)*10" I entered it via =(B4-B3)*10.
After pressing return, I get the red triangle and syntax error.
For me, it seems very closely related to the column and row names (something which does not happen in Excel).
So if I enter everything not by clicking on cells in the formula/spreadsheet but by giving the references via keyboard, still Numbers expands them to the "real names" but everything is fine unless I enter that cell again and press return. I can send / upload the file if desired.
Here it behaves flawlessly.
What is the contents of the cells ?
If one of them is empty, the error message is normal.
Which is the error message displayed if you click the red triangle ?
Click my blue name to get my mail address so you will be able to send the document.
Yvan KOENIG (VALLAURIS, France) dimanche 17 janvier 2010 19:27:40
The problem is linked to dates using the period as components delimiter.
If I use the current French format 31/12/1943, the spreadsheet behaves flawlessly without the added column.
As it appears that this format is unavailable in the default Deutsch resource file, two soluces are available :
(1) use an added column (B) storing the true dates and, in the headers of row, build the names with a formula of this kind :
(2) use the script which I re-posted some days ago to add at least one new date format to the Deutsch resource file.
This one must be DD/MM/YYYY
If you use it, you will be able to work without the added column.
Here, Numbers enclose the date with slashes ibetween single quotes.
=(Zählerstand '11/01/2010'-Zählerstand '11/06/2009')*10
Yvan KOENIG (VALLAURIS, France) samedi 30 janvier 2010 20:39:09