https://bugs.documentfoundation.org/show_bug.cgi?id=96158
Bug ID: 96158
Summary: EDITING: Inconsistent quote handling entering data
into cells
Product: LibreOffice
Version: 5.0.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 120898
--> https://bugs.documentfoundation.org/attachment.cgi?id=120898&action=edit
Spreadsheet demonstrating inconsistent quote handling
Calc doesn't let me force text using the single quote. This is or equivalent
has been standard behaviour in other spreadsheets for many (25+) years.
If I enter an invoice reference that Calc thinks is a date, it will format it
as a date, so I have to put a single quote prefix, the quote doesn't show.
However, if I enter an invoice reference that Calc doesn't think is a date and
I put a single quote prefix, the quote DOES show.
See attached spreadsheet that demonstrates the issue.
UK English on Linux using latest Release 5.0.3.2 version installed a few days
ago. Not a new problem.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
