Bug 130630 - Calc seems to not be able to handle percentages in cell when linking
Summary: Calc seems to not be able to handle percentages in cell when linking
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-13 04:49 UTC by Casey Goodwin
Modified: 2020-02-13 04:51 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Casey Goodwin 2020-02-13 04:49:03 UTC 
When performing an equation that deals with a percentage, say figuring local sales tax into a grocery list, Calc mis-handles the equation. For example, if C14 has a total of 449.98, cell A18 has the tax rate of 10.10%, and cell D14 has the equation "=C14*B18" the total amount of tax owed is displayed. If you then try to add the values of D14 and C14 using the equation "=C14+D14" the cell displays "49542.80%". I copied this exact spreadsheet into my wifes copy of Microsoft Office 365 Student Excel and it displayed the proper value of D14+C14 in the cell.