Bug 48309 - Calc fails to suppress '-char for text strings
Summary: Calc fails to suppress '-char for text strings
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.1 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
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:

Attachments
issue.xls (6.50 KB, application/vnd.ms-excel)
2012-04-04 12:25 UTC, OfficeUser 		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 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
LibreOffice 3.5.1.2 
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]
issue.xls
Comment 2 OfficeUser 2012-04-04 12:30:10 UTC 
CORRECTION:

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...