http://openoffice.org/bugzilla/show_bug.cgi?id=118157
Issue Type: DEFECT
Summary: calc silently drops cell value in .xlsm files if
originally on a tab with an embedded space in the name
Classification: Application
Product: Spreadsheet
Version: OOO330m20
Platform: PC
OS/Version: Linux
Status: UNCONFIRMED
Severity: enhancement
Priority: P3
Component: editing
AssignedTo: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
Created an attachment (id=76602)
--> (http://openoffice.org/bugzilla/attachment.cgi?id=76602)
File to illustrate the issue.
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
----------------
OpenOffice 3.3.0, display user.xlsm:
----------------
link to test:
1 2
link to test with spaces
1 2
----------------
--
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
