| View previous topic :: View next topic |
| Author |
Message |
freddyj1
Blue Pill
Joined: Mar 28, 2009
Posts: 3
|
 Posted: Mon Mar 30, 2009 10:38 am Post subject: Calculation failure on transition from NO2 to NO3 |
|
Interest calculation:
=(A10-A9)*B4*D9 works in Ver 225 but returns a 0 (zero) in Ver 3
A10 and A9 contain dates
B4 contains the daily interest rate
D9 contains the balance as of previous payment.
Day count portion of calculation seems OK.
Has something significant changed in formula entry that I missed? |
|
| Back to top |
|
 |
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Mon Mar 30, 2009 10:56 am Post subject: |
|
I can reproduce same behavior in OpenOffice.org 3.0.1 which is the version that NeoOffice 3.0 is based on.
Fortunately, while OpenOffice.org did change something, I found an easy fix: go into each cell that has a "%" character in it and insert an "=" character at the beginning of the cell.
What appears to have changed in OpenOffice.org 3.0.1 is that a cell with "0.1234%" will be evaluated as text instead of a number. By changing the cell to "=0.1234%", NeoOffice's underlying OpenOffice.org will treat the data as a number like in earlier versions.
Patrick |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Mon Mar 30, 2009 11:37 am Post subject: |
|
Interesting - I tried this in Neo v3, and while it worked for the 5.xxxx% value, it failed for the % value with lots of numerals after the decimal point - the cell contents show the = sign and it still gets parsed as a text value.
*edit* Ah, that's because there's a space in the cell before the first 0! Works fine if the space is deleted.
- padmavyuha |
|
| Back to top |
|
|
Jim
Councilperson
Joined: Jun 21, 2003
Posts: 173
Location: Selmer, Tennessee
|
| Posted: Mon Mar 30, 2009 12:08 pm Post subject: |
|
I tried removing the space in Neo 3.0 and it didn't work. Using Patrick's trick of putting an equal sign in front of the zero (Cell B4) did. I just changed the formula in B4 to =C4/365, which is what it should be anyhow.
Seems as if once Calc gets a format into its little head, it doesn't want to let go of that format. But in this case, even changing the format to a number (not a percent) only made it display zero instead of the numeric value for the daily rate.
_________________
Jim Plante
MacOS X 10.6.34, MacBook 2GHz C2Duo, 2gb, Neo 3.1.1 p 1 |
|
| Back to top |
|
|
Samwise
Captain Naiobi
Joined: Apr 25, 2006
Posts: 2315
Location: Montpellier, France
|
| Posted: Mon Mar 30, 2009 12:53 pm Post subject: |
|
| Jim wrote: | | I tried removing the space in Neo 3.0 and it didn't work. Using Patrick's trick of putting an equal sign in front of the zero (Cell B4) did. |
That's probably because you needed to remove the space and add the equal sign  |
|
| Back to top |
|
|
yoxi
Cipher
Joined: Sep 07, 2004
Posts: 1799
Location: Dawlish, Devon
|
| Posted: Mon Mar 30, 2009 12:54 pm Post subject: |
|
"I tried this in Neo v3" meant I tried what Patrick suggested with the = sign, but it didn't work because of the space between the = and the 0  .
...what he said... |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Mon Mar 30, 2009 6:52 pm Post subject: |
|
I have some interesting news. I opened the sample spreadsheet in OpenOffice.org 2.2.1 and got the same behavior as NeoOffice 3.0 and OpenOffice.org 3.0.1. Since RetroOffice 2.2.5 behaves the same as NeoOffice 2.2.5, that means that the NeoOffice 2.2.5 behavior was a modification to the OpenOffice.org code added by Novell's Go-oo engineers.
I suspect that NeoOffice 3.0 Early Access also had this Go-oo feature and my removal of some Go-oo modifications to fix bug 3427 may have inadvertently removed this Go-oo feature.
I need to find the Go-oo modification that causes bug 3427. While I am working on that bug, I will try adding back some of the Go-oo modifications that I previously removed and see if the NeoOffice 2.2.5 behavior returns.
Patrick |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Thu Apr 02, 2009 9:49 am Post subject: |
|
FYI. I have confirmed that my suspicion was correct: removal of some Go-oo modifications to fix bug 3427 inadvertently removed this Go-oo feature.
I have added back pieces of that Go-oo modification and I think that I have found the combination that restores this feature without causing bug 3427 to reoccur.
I have created bug 3440 to track our investigation of this bug. Please add yourself to the CC: list in the bug if you would like to track its progress and to get automatically notified when we have a test patch available.
Patrick |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Sat Apr 04, 2009 12:53 pm Post subject: |
|
I think that I have fixed this bug and I have posted links to a test patch in my last post in bug 3440.
Can you install the test patch and tell us if the bug is fixed for you?
Patrick |
|
| Back to top |
|
|
pluby
The Architect
Joined: Jun 16, 2003
Posts: 11949
|
| Posted: Tue Apr 14, 2009 12:31 pm Post subject: |
|
FYI. I have included the fix for this bug in NeoOffice 3.0 Patch 1. You can download the patch from the following URL:
http://www.neooffice.org/neojava/patch.php
Patrick |
|
| Back to top |
|
|
|
