You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/18 12:57:50 UTC
[Bug 124256] New: Named ranges not imported from Microsoft XLSX file
https://issues.apache.org/ooo/show_bug.cgi?id=124256
Bug ID: 124256
Issue Type: DEFECT
Summary: Named ranges not imported from Microsoft XLSX file
Product: Calc
Version: 4.1.0-dev
Hardware: PC
OS: Linux64
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: mbr@us.ibm.com
CC: issues@openoffice.apache.org
Created attachment 82614
--> https://issues.apache.org/ooo/attachment.cgi?id=82614&action=edit
XLSX file containing a named range
I have an Microsoft Excel XLSX file (attached) that contains a named range.
When I import this file in to Calc, this named range does not show up (Data ->
Select Range).
Possible related issue: https://issues.apache.org/ooo/show_bug.cgi?id=122890
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOT_AN_ISSUE
--- Comment #9 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
I agree with Edwin's Comment 5:
(a) I close this one because it's not an issue, but user error
(b) Submitted new Bug Report for j.nitschke@ok.de's results in Comment 3:
"Bug 124293 - Section Range names truncated from underscore to end
in MSO .XLSX"
@j.nitschke:
Can you please check whether I correctly cited all your results?
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
--- Comment #5 from Edwin Sharp <el...@apache.org> ---
Thank you j.nitschke
IMHO this bug should be used as an enhancement for better wording to reduce
chance for confusion with databases.
The findings of comment 3 should be a new bug.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
--- Comment #7 from j.nitschke@ok.de ---
I digged a bit into the localSheetId feature and checked how it should work:
<definedName name="test" localSheetId="0">Sheet1!$F$1</definedName>
<definedName name="test" localSheetId="1">Sheet1!$L$1</definedName>
<definedName name="test">Sheet1!$A$1</definedName>
If you use the named range "test" in Sheet1 it should use the values in
$Sheet1.$F$1 (sheet1 has localSheetId ="0")
Using "test" in Sheet2 it uses the value $Sheet1.$L$1 (sheet2 has localSheetId
="1")
in all other sheets the value from $Sheet1.$A$1 is used
This works *perfect* thanks to Bug 120478 - Name Scope enhancement for
spreadsheet
there are only 2 problems
* the names are listed more than once (minor problem)
* if you pick a name it always marks the cell without localSheetId
it should check on which sheet you are and show the named range used for this
sheet, else this feature is very confusing
i.e. if you select test from the name box in Sheet1 it should jump to
Sheet1!$F$1
on Sheet2 it jumps to $Sheet1.$L$1 and on Sheet3 it jumps to Sheet1!$A$1
If ODF specs don't have a similar feature i would call this an enhancement.
This said it's not a faulty import and not a regression.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
j.nitschke@ok.de changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |j.nitschke@ok.de
--- Comment #3 from j.nitschke@ok.de ---
I think there is a misunderstanding. Named cells/ranges are not database
ranges.
You can select them with the name box next to the formula bar.
Or Insert -> Names.. -> Define..
but there is indeed an issue:
attachment 82614 seems to have 6 named ranges, dissected:
<definedName name="data" localSheetId="0">Sheet1!$F$2:$J$10</definedName>
<definedName name="data" localSheetId="1">Sheet1!$L$2:$P$10</definedName>
<definedName name="data">Sheet1!$A$2:$D$10</definedName>
<definedName name="test" localSheetId="0">Sheet1!$F$1</definedName>
<definedName name="test" localSheetId="1">Sheet1!$L$1</definedName>
<definedName name="test">Sheet1!$A$1</definedName>
*AOO 3.4.1* imports
data $Sheet1.$F$2:$J$10
data_1 $Sheet1.$L$2:$P$10
data_2 $Sheet1.$A$2:$D$10
test $Sheet1.$F$1
test_1 $Sheet1.$L$1
test_2 $Sheet1.$A$1
which are all available through the name box
*AOO 4.1* (rev. 1568575) imports
data $Sheet1.$A$2:$D$10
data (Sheet1) $Sheet1.$F$2:$J$10
data (Sheet2) $Sheet1.$L$2:$P$10
test $Sheet1.$A$1
test (Sheet1) $Sheet1.$F$1
test_1 (Sheet2) $Sheet1.$L$1
data and test are available through the name box
but data and test are listed 3 times the (Sheetx)-part doesn't show
and it always selects the first range
the original report is not an issue but
the faulty is import is a regression
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oliver.brinzing@gmx.de
--- Comment #6 from brinzing <ol...@gmx.de> ---
.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
--- Comment #1 from Michael Rutherford <mb...@us.ibm.com> ---
Build installed: 17 Feb development snapshot
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
--- Comment #4 from Michael Rutherford <mb...@us.ibm.com> ---
Ahh, yes, I see this now....thanks for the clarification regarding named
ranges. Shall I keep this bug report open for the regression issue you
mention? It would probably make sense to change the one liner description of
we do.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |elish@apache.org
Latest|--- |4.1-dev
Confirmation on| |
Ever confirmed|0 |1
OS|Linux64 |All
--- Comment #2 from Edwin Sharp <el...@apache.org> ---
Data - Select Range... -> empty although Sheet1 F2:J10 is data.
AOO410m1(Build:9750) - Rev. 1565724
Rev.1565724
Win 7
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124256] Named ranges not imported from Microsoft XLSX file
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124256
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Status|CONFIRMED |UNCONFIRMED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Ever confirmed|1 |0
--- Comment #8 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
No Idea what the problem here might be. Do we only have a wrong description of
an existing bug in report? Or in Comment 2? Or are j.nitschke@ok.de's
observations something completely different? Further research required.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.