You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2020/02/27 08:00:41 UTC
[Issue 128309] New: FIXED formula bug
https://bz.apache.org/ooo/show_bug.cgi?id=128309
Issue ID: 128309
Issue Type: DEFECT
Summary: FIXED formula bug
Product: Calc
Version: 4.1.7
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: programming
Assignee: issues@openoffice.apache.org
Reporter: skoni@onet.eu
Target Milestone: ---
Created attachment 86861
--> https://bz.apache.org/ooo/attachment.cgi?id=86861&action=edit
spreadsheet that has FIXED formulas that show the bugs
Formula "FIXED" bugs :
1. when the formula is 'negative': - FIXED(cell_address; ...) :
If formula's DECIMAL POINTS value is changed from 0 to eg. 2 or when the
argument is greater than 999 then the formula stops working (#VALUE! Error)
2. If a MINUS sign is removed from the formula then the results are ok:
+ FIXED(cell_address; ...)
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128309] FIXED formula bug
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128309
Peter <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |petko@apache.org
Ever confirmed|0 |1
--- Comment #1 from Peter <pe...@apache.org> ---
Thanks for the finding. I can confirm the behavior.
As a Workaround change the Formula to =FIXED(-$B7;2) instead of =-FIXED($B7;2).
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128309] FIXED formula bug
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128309
Peter <pe...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS|Windows XP |All
--- Comment #2 from Peter <pe...@apache.org> ---
switching Hardware to all. Since I am on Linux.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 128309] FIXED formula bug
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=128309
jeffooo <je...@orange.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jeffooo@orange.fr
--- Comment #3 from jeffooo <je...@orange.fr> ---
Hi,
FIXED give a text, not a number.
You cannot add a text (but concatenate it)
--
You are receiving this mail because:
You are the assignee for the issue.