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: [email protected]
Reporter: [email protected]
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.
