https://bugs.documentfoundation.org/show_bug.cgi?id=92939

--- Comment #3 from Alex <[email protected]> ---
After some subsequent investigation I can report that the order in which sheets
appear in the Excel workbook has some effect on whether local names get
attached to the correct sheet.  If, for example, in the attachments I sent in
the original bug report, one moves SHEET4 and SHEET3 to the end in the Excel
workbook, so that the tab order is SHEET2, SHEET1, SHEET4 and SHEET3, when that
is then opened by Calc the names local to SHEET1 and SHEET2 get attached
correctly.  It seems that if there are sheets in the document which do not have
any local names that are to the left (in the tab order) of those which do, the
local names on those which do get shifted as many sheets to the left as there
are preceeding sheets without local names.  It's hard for me to imagine why
this type of behavior should happen, inasmuch as it shouldn't be too difficult
to look at an Excel name and easily figure out whether it is global or local,
and if local, what sheet it belongs to when the name is converted to Calc. 
Something is not right in that process.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to