https://bugs.documentfoundation.org/show_bug.cgi?id=114406
Bug ID: 114406
Summary: #NAME? error when using a field with percentage
Product: LibreOffice
Version: 5.4.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
See attached example. In cell B1 a value of "100%" is given. In cell C1 the
formula: =A1/B1*100%
The original sheet was opened from an XLSX. Sometimes the error occurs, but
sometimes it does not.
When one tries to enter such a formula, LO replaces 100% with 1 automatically.
Steps to Reproduce:
Open the attached sheet
Actual Results:
The 100% does not work.
Expected Results:
It should be interpreted as 1
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:57.0) Gecko/20100101
Firefox/57.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
