Bug 34312 - Calc Does Not Display cells Formatted with a hash (US pound) character correctly
Summary: Calc Does Not Display cells Formatted with a hash (US pound) character correctly
Status: RESOLVED DUPLICATE of bug 49976
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: numberformat
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-15 15:20 UTC by junk_2010
Modified: 2013-01-12 18:18 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Excel Example Spreadsheet to enable issue to be repeated (89.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2011-02-15 15:20 UTC, junk_2010
Details
PDF showing display in excel (220.45 KB, application/pdf)
2011-02-15 15:21 UTC, junk_2010
Details
PDF showing display in calc (28.05 KB, application/pdf)
2011-02-15 15:22 UTC, junk_2010
Details

Note You need to log in before you can comment on or make changes to this bug.
Description junk_2010 2011-02-15 15:20:08 UTC
Created attachment 43402 [details]
Excel Example Spreadsheet to enable issue to be repeated

Calc Does Not Display cells Formatted with a hash (US pound) character correctly

hash = # = US "pound"

If you format a cell in excel using the '#' character, the formatting is displayed differently in calc.
Gnumeric formats cells using the '#' character the same as in excel.

I will attach excel spreadsheet and pdfs showing display in excel and calc. The calc pdf is from office 3.2.1, but I have checked on Mac OSX version of libreoffice 3.3.0 that the display is the same.


Requested fix:

Calc to treat format '#' character in the same way as excel and gnumeric.
Comment 1 junk_2010 2011-02-15 15:21:25 UTC
Created attachment 43403 [details]
PDF showing display in excel
Comment 2 junk_2010 2011-02-15 15:22:24 UTC
Created attachment 43404 [details]
PDF showing display in calc
Comment 3 Björn Michaelsen 2011-12-23 11:51:46 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 4 junk_2010 2012-05-23 12:31:00 UTC
I have rechecked this in LibreOffice 3.5.2.2 on Ubuntu 12.04 LTS (32bit) and the issue still remains.
Comment 5 junk_2010 2012-07-24 19:29:29 UTC
Still present in version v3.6.0.2 run on MacOSX.
Comment 6 junk_2010 2013-01-12 18:17:00 UTC
I can confirm that this is still an issue with LibreOffice 4.0.0.1 tested on a macbook running OSX 10.6 (Snow Leopard).
Comment 7 junk_2010 2013-01-12 18:18:05 UTC

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