Issue 5932 - Converted Names from Excel documents are wrong
Summary: Converted Names from Excel documents are wrong
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
: 7589 (view as issue list)
Depends on:
Blocks:
 
Reported: 2002-06-17 22:31 UTC by Unknown
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-06-17 22:31:26 UTC
When open an excel's spreadsheet, names are wrongly converted and Error 508 
appears when a cell use that names.

Example:
Original name (Excel):  ='$KJ2002'.$E$16;'$KJ2002'.$E$32;'$KJ2002'.$F$48
Converted name (scalc): (($KJ2002.$E$16;$KJ2002.$E$32);$KJ2002.$F$48)

If you delete all parenthesis from name field spreadsheet properly work.

Example:
Good converted name (scalc): $KJ2002.$E$16;$KJ2002.$E$32;$KJ2002.$F$48
Comment 1 daniel.rentz 2002-06-18 09:17:26 UTC
Yes, that's mine.
Comment 2 daniel.rentz 2002-06-18 09:18:33 UTC
Do not add parentheses around tUnion tokens.
Comment 3 daniel.rentz 2002-07-09 13:05:01 UTC
Fixed with next started 641 build (OOo 1.0.2)
Comment 4 daniel.rentz 2002-09-09 13:14:51 UTC
*** Issue 7589 has been marked as a duplicate of this issue. ***
Comment 5 daniel.rentz 2002-10-17 10:08:41 UTC
Verified in the 643 build
Comment 6 daniel.rentz 2003-01-13 16:33:43 UTC
target->OOo1.0.2
Comment 7 daniel.rentz 2003-01-30 10:36:14 UTC
reopened to change owner
Comment 8 daniel.rentz 2003-01-30 10:36:33 UTC
verified in OOo1.0.2
Comment 9 daniel.rentz 2003-01-30 10:36:44 UTC
fixed
Comment 10 oc 2003-03-06 08:55:16 UTC
Closed because fixed and verified