Bug 96158 - EDITING: Inconsistent quote handling entering data into cells
Summary: EDITING: Inconsistent quote handling entering data into cells
Status: RESOLVED DUPLICATE of bug 73377
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-30 15:59 UTC by James Murray
Modified: 2015-12-01 09:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet demonstrating inconsistent quote handling (10.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-30 15:59 UTC, James Murray
Details

Note You need to log in before you can comment on or make changes to this bug.
Description James Murray 2015-11-30 15:59:03 UTC
Created attachment 120898 [details]
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.
Comment 1 Buovjaga 2015-12-01 09:06:37 UTC

*** This bug has been marked as a duplicate of bug 73377 ***