Bug 48309

Summary:	Calc fails to suppress '-char for text strings
Product:	LibreOffice	Reporter:	OfficeUser <norbert.notz>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	Keywords:	regression
Priority:	medium
Version:	3.5.1 release
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	issue.xls

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