https://bugs.freedesktop.org/show_bug.cgi?id=41534
Summary: FILEOPEN: libreoffice silently drops cell value in
.xlsm files if originally on a tab with an embedded
space in the name
Product: LibreOffice
Version: LibO 3.3.3 release
Platform: x86 (IA32)
OS/Version: Linux (All)
Status: NEW
Severity: critical
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=52053)
--> (https://bugs.freedesktop.org/attachment.cgi?id=52053)
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
----------------
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
