Created attachment 71599 [details] One of the files this is happening with. Problem description:Open MS office 2010 excel.xlsx document in LibreOffice 4Spreadsheet. Answering either YES or NO to This document was last saved by Excel. Some formula cells may produce different results when recalculated. Do you want to recalculate all formula cells now? Steps to reproduce: 1. ....Start Spreadsheet, or open direct from document 2. .... 3. .... Current behavior:=SUM(E3:E34) cell reads £"0.00 Expected behavior:=SUM(E3:E34) cell should read £0.00 Operating System: Windows 7
Created attachment 71600 [details] How it looks in EXCEL 2010
Created attachment 71601 [details] how it looks in LibreOffice 4
*** This bug has been marked as a duplicate of bug 58179 ***
Created attachment 71609 [details] typescript with some warnings Using a local build of master commit id 7ba2c82, fetched around 2012-12-11 14:00 UTC, configured as --enable-dbgutil --enable-crashdump --disable-build-mozilla --without-system-postgresql --without-myspell-dicts --without-help --with-extra-buildid built and running on ubuntu-natty (11.04) 32-bit ... $ uname -a Linux cougar-natty 2.6.38-16-generic #67-Ubuntu SMP Thu Sep 6 18:00:43 UTC 2012 i686 athlon i386 GNU/Linux $ gcc --version gcc (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2 Copyright (C) 2010 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. $ java -version java version "1.6.0_24" OpenJDK Runtime Environment (IcedTea6 1.11.5) (6b24-1.11.5-0ubuntu1~11.04.1) OpenJDK Client VM (build 20.0-b12, mixed mode, sharing) I see the funny display that RobertG describes. While opening the file, the program produced messages at the console. I shall attach typescript, but it may be of interest that this one happened a few times ... warn:legacy.osl:15569:1:/home/terry/lo_hacking/git/libo2/oox/source/docprop/docprophandler.cxx:319: For now unexpected tags are ignored! The extra quotation marks are evident in the dialog box Format Cells , tab Numbers, category Number, pane Format. Coming soon: screenshots from 3.6.4.3 and 4.0beta. HTH, Terry.
Created attachment 71611 [details] Format cells dialog from 3.643
Created attachment 71613 [details] Format cells dialog from 4.0beta1