Issue 128309 - FIXED formula bug
Summary: FIXED formula bug
Status: CONFIRMED
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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 
Hi,

FIXED give a text, not a number.

You cannot add a text (but concatenate it)