Created attachment 52053 [details] This is the file that illustrates the behavior. We've noticed that with .xlsm files created with Microsoft Office 2010, if there is an embedded space in the tab name, Calc will silently discard that value. I'm attaching a file to illustrate this problem. The first row of numbers are linked to a file named test.xlsm, which you don't need to have around for testing, as office knows to use the last available value and not update the link. test.xlsm has three tabs: tab1, tab_2, and "tab 3". The second row links to a file "test with spaces.xlsm", same idea. Microsoft Office 2010, display user.xlsm: ---------------- link to test: 1 2 3 link to test with spaces 1 2 3 ---------------- Libreoffice 3.3.3, display user.xlsm: ---------------- link to test: 1 2 link to test with spaces 1 2 ----------------
at least in a master build the cell content is still there but not correctly displayed
[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
The problem persists; I tried both 3.5.1.2 and the beta/prerelease 3.5.2.2 (In reply to comment #2) > [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
Has there been any further work on this bug? frank
This bug is no more with LO 4.1.1 on Windows 7 SP1: Calc correctly shows the .xlsm as in Excel 2010, all 3 values are visible. But the bug was reported under Linux: can anyone confirm it's no more?
Works OK for me. Version: 4.3.1.2 Build ID: 4.3.1.2 Arch Linux build-1
Thank you @todventtu. This bug is no more also with LO 4.2.6.2. Set to WORKSFORME.