| View previous topic :: View next topic |
| Author |
Message |
HendrikPon
Agent
Joined: Jan 18, 2009
Posts: 18
|
 Posted: Wed Jan 21, 2009 12:44 pm Post subject: Problem with formula in Calc |
|
I am trying the example from the NeoWiki site to get unique items
http://neowiki.neooffice.org/index.php/Listing_Unique_Items_in_a_Cell_Range
In NeoOffice 3 Patch 0 (correcting the highlighting/grid line issue)
===========================================
1. fill column C as shown in example
2. enter the formula =IF(COUNTIF(C$1:C1;C1)>1;0;1) in Cell A1
3. this gives Err:508
The formula is shown exactly as above.
4. save the spreadsheet
NeoOffice 2.2.5 Patch 6
=================================
5. open spreadsheet in NeoOffice2.2.5 Patch 6.
The formula now shows as =IF(COUNTIF(C$1:C1|C1)>1|0|1)
Cell A1 shows #NAME?
6. If you enter the formula from item 2 above directly in NeoOffice 2.2.5 then it gives 1 as result which is correct.
Berend
Mac OS X 10.5.6 Intel |
|
| Back to top |
|
 |
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Wed Jan 21, 2009 1:51 pm Post subject: |
|
I can reproduce this and checked that the issue does not occur in OpenOffice.org 3.0, so I have filed bug 3394.
By registering on Bugzilla and adding yourself to the CC: list for that bug, you will get notified of updates (e.g. test patch releases) to that bug. |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Thu Jan 22, 2009 10:51 am Post subject: |
|
I found the Novell Go-oo modification that causes this bug and I have removed it in the test patch that I posted links for in bug 3394.
Please note that the fix will not fix any forumulas that were corrupted in a previous save. It will only prevent corruption of newly entered forumulas or formulas saved in NeoOffice 2.2.5 or OpenOffice.org. For documents that were corrupted in a previous save, you will need to manually edit the formula and resave the document:
Patrick |
|
| Back to top |
|
|
HendrikPon
Agent
Joined: Jan 18, 2009
Posts: 18
|
| Posted: Thu Jan 22, 2009 11:41 am Post subject: |
|
Just before I read your remark, I found that if I use comma's (,) as argument separator in stead of semi-colons ( then the formula evaluates correctly.
Is this connected to the Go-oo modification?
Berend |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Thu Jan 22, 2009 3:56 pm Post subject: |
|
| HendrikPon wrote: | Just before I read your remark, I found that if I use comma's (,) as argument separator in stead of semi-colons ( then the formula evaluates correctly.
Is this connected to the Go-oo modification? |
Probably. The issue as I understand it was caused by the Go-oo code localizing the argument separator so that if you save as Excel, it will be more compatible with Excel (or at least Excel on Windows).
Patrick |
|
| Back to top |
|
|
Macdaddy-o
Red Pill
Joined: Jan 02, 2009
Posts: 9
|
| Posted: Fri Feb 13, 2009 10:16 am Post subject: Using Semi-Colons as Formula Separator |
|
I am a long-time user of Excel...and an old dog...so switching to NeoOffice and using the semi-colon instead of a comma as a separator in formulae takes thought and time when I have to correct my stupid errors. Is there a preference I can set that will allow the use of a comma instead of a semi-colon to separate descriptors in formulae in NeoOffice?
Thanks! |
|
| Back to top |
|
|
|
