Bug 48309 - Calc fails to suppress '-char for text strings
Summary: Calc fails to suppress '-char for text strings
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.1 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2012-04-04 12:25 UTC by OfficeUser
Modified: 2012-06-30 00:36 UTC (History)
0 users

See Also:
Crash report or crash signature:

issue.xls (6.50 KB, application/vnd.ms-excel)
2012-04-04 12:25 UTC, OfficeUser

Note You need to log in before you can comment on or make changes to this bug.
Description OfficeUser 2012-04-04 12:25:28 UTC
- Please open the attached issue.xls

This spreadsheet contains 'text in cell A1 and '0815 in cell B1.

In Cell B1 the '-char is hidden as expected while in A1 it is displayed.

Expected behaviour: The first "'"-char in a cell should always be displayed, also in text-strings.

The current behaviour of LibO is also not interoperable with Excel. I think it is a regression since former Libo or OOo versions.

Found on
Build-ID: dc9775d-05ecbee-0851ad3-1586698-727bf66
Linux and Windows builds
Comment 1 OfficeUser 2012-04-04 12:25:48 UTC
Created attachment 59488 [details]
Comment 2 OfficeUser 2012-04-04 12:30:10 UTC

Expected behaviour: The first '-char in a cell should NEVER be displayed,
also NOT in text-strings.
Comment 3 Eike Rathke 2012-06-27 17:26:53 UTC
In A1 the ' is part of the cell content, in A2 it is not and only displayed in the input line to not convert the input to number in case it is edited, which would strip the leading 0 in this case.

Loading the document in Excel the display is identical, A1 displays the ' and A2 does not.
Comment 4 OfficeUser 2012-06-30 00:36:02 UTC
You are right. Excel displays the attached file in the same way as Calc.

Excel seems to have different behaviour when typing beginning with "'"...

Maybe this has confused me. I agree closing this report...