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.
Created attachment 43403 [details] PDF showing display in excel
Created attachment 43404 [details] PDF showing display in calc
[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
I have rechecked this in LibreOffice 3.5.2.2 on Ubuntu 12.04 LTS (32bit) and the issue still remains.
Still present in version v3.6.0.2 run on MacOSX.
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).
*** This bug has been marked as a duplicate of bug 49976 ***