Issue 91065 - Microsoft Excel-Import does not work correctly on worksheets named with no. sign #
Summary: Microsoft Excel-Import does not work correctly on worksheets named with no. s...
Status: CLOSED DUPLICATE of issue 6087
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: PC Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-25 16:45 UTC by dry_martini
Modified: 2008-07-01 12:44 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dry_martini 2008-06-25 16:45:45 UTC 
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
Comment 1 chl207 2008-06-29 10:36:38 UTC 
In version OOo-dev300-m21_en，this defect still exists.
Kind Regards
Comment 2 chl207 2008-07-01 11:01:30 UTC 
validating only on Windows XP(åªåœ¨Winsows Xp中进行了验è¯)
Comment 3 oc 2008-07-01 12:44:08 UTC 
This is duplicate to #i6087# which is fixed with cws_odff04 (will be integrated
into the OOo3.0 codeline)

*** This issue has been marked as a duplicate of 6087 ***
Comment 4 oc 2008-07-01 12:44:59 UTC 
closed because duplicate