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
View All 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 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 ***