https://bugs.documentfoundation.org/show_bug.cgi?id=165284
Bug ID: 165284
Summary: Calc can't use a cell containing a number with
whitespace after
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 199236
--> https://bugs.documentfoundation.org/attachment.cgi?id=199236&action=edit
Number with whitespace after
Google Sheets handles this XLS fine. Displays the expected 1.564088527 value.
I'll attach the test case.
Easy to reproduce
1. Create a cell with a number, followed by a new line (as is common when
copying and pasting numbers from documents). It's correctly formatted as a
number, but Calc gives the #VALUE! error when it is used.
Expected behaviour
Calc should ignore the whitespace after the number, or before.
Should display the 1.564088527
Maybe it could even trim the whitespace, as Google Sheets does.
I appreciate I am not using the latest release. Could someone confirm in latest
version please.
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.2
Calc: threaded Jumbo
--
You are receiving this mail because:
You are the assignee for the bug.
