Issue 128309 - FIXED formula bug
Summary: FIXED formula bug
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 4.1.7
Hardware: PC All
: P5 (lowest) Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2020-02-27 08:00 UTC by derlo
Modified: 2020-03-03 08:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

spreadsheet that has FIXED formulas that show the bugs (13.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-02-27 08:00 UTC, derlo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description derlo 2020-02-27 08:00:41 UTC
Created attachment 86861 [details]
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; ...)
Comment 1 Peter 2020-02-27 08:15:10 UTC
Thanks for the finding. I can confirm the behavior. 

As a Workaround change the Formula to =FIXED(-$B7;2) instead of =-FIXED($B7;2).
Comment 2 Peter 2020-02-27 08:15:45 UTC
switching Hardware to all. Since I am on Linux.
Comment 3 jeffooo 2020-03-03 08:53:53 UTC

FIXED give a text, not a number.

You cannot add a text (but concatenate it)