To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=91065
Issue #|91065
Summary|Microsoft Excel-Import does not work correctly on work
|sheets named with no. sign #
Component|Spreadsheet
Version|OOo 2.4.1
Platform|PC
URL|
OS/Version|Windows Vista
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|editing
Assigned to|spreadsheet
Reported by|dry_martini
------- Additional comments from [EMAIL PROTECTED] Wed Jun 25 15:45:45 +0000
2008 -------
Hello!
First of all: thank you for this very powerfull tool. However, I just had a
serious problem when I tried to
open a Excel-Workbook containing a lot of worksheets named "#01", "#02" etc.
MS-Excel 2003 SP2 was used
OOo just renamed the worksheets to "_01", "_02" etc. - This might have been
fine if all formulas would
have been converted correctly. Unfortunately I am a very advanced user of
MS-Excel and used the
function "INDIRECT" very often in that particular workbook to calculate cell
reference referring to the
sheets named "#01", "#02", etc.... The reference was created e.g. by entering
#01 in cell E1 on sheet
"Summary", with "=INDIREKT("'"&E$1&"'!BJ"&ZEILE(B3))" (german-translation),
being the same as "=INDIRECT("'"&E$1&"'!BJ"&ROW(B3))".
Problem: the function expects a worksheet named "#01", which has been renamed
to "_01"
Result: Err 502
Hopefully someone could fix this on the import function for
MS-Excel-Spreadsheets
PS: MS-Excel allows to rename a worksheet just by double clicking the tab. In
OOo I have to right click
and choose "rename". Please consider this in any future version of CALC
Kind Regards,
Martin
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
