[Libreoffice-bugs] [Bug 130577] FILEOPEN: XLSX import looses defined range definitions

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Steve Edmonds <steve at edmondsfamily.co.nz> ---
The problem seems to be that excel allows name ranges that Calc does not.
I.e. H_o/t, \delta

Naming Convention for Named Ranges in Excel

There are certain naming rules you need to know while creating Named Ranges in
Excel:

    The first character of a Named Range should be a letter and underscore
character(_), or a backslash(\). If it’s anything else, it will show an error.
The remaining characters can be letters, numbers, special characters, period,
or underscore.
    You can not use names that also represent cell references in Excel. For
example, you can’t use AB1 as it is also a cell reference.
    You can’t use spaces while creating named ranges. For example, you can’t
have Sales Rep as a named range. If you want to combine two words and create a
Named Range, use an underscore, period or uppercase characters to create it.
For example, you can have Sales_Rep, SalesRep, or SalesRep.
        While creating named ranges, Excel treats uppercase and lowercase the
same way. For example, if you create a named range SALES, then you will not be
able to create another named range such as ‘sales’ or ‘Sales’.
    A Named Range can be up to 255 characters long.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200211/f37f8e83/attachment-0001.htm>