[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 --- Comment #8 from Ben Elliston --- OK, I understand now (after a bit of experimentation with a trivial spreadsheet). -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 --- Comment #7 from Ben Elliston --- Is the relative vs absolute sheet references explained somewhere in the documentation? I wasn't able to find much beyond the standard cell reference material. Thanks. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 Eike Rathke changed: What|Removed |Added Status|RESOLVED|CLOSED -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #6 from Eike Rathke --- (In reply to Oliver Brinzing from comment #3) > if you open the "Manage Names" dialog (Ctrl+F3) on "Sheet1" the named range > will point to "Sheet1.$A$1:Sheet1.$A$4", if you do same on "Sheet2" it will > point to "Sheet2.$A$1:Sheet2.$A$4". Normal behaviour because the sheet references are relative (not absolute without a leading $) (In reply to Oliver Brinzing from comment #4) > LO will import a *.xlxs spreadsheet with global named range: > =Tabelle1!$A$1:$A$3 to $Tabelle1.$A$1:$A$3. > > and will export "global" named range "Sheet2.$A$1:Sheet2.$A$4" > (defined on Sheet1) to "Sheet1!$A$1:$A$3" Both is expected, because Excel does not know relative sheet references. Nothing we can do about. Not a bug. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 --- Comment #5 from Ben Elliston --- If it is a bit of useful information, I'm almost certain the .ods spreadsheet I am having this problem with was saved from an Excel spreadsheet. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 --- Comment #4 from Oliver Brinzing --- Created attachment 150259 --> https://bugs.documentfoundation.org/attachment.cgi?id=150259=edit simple test case created with excel 2016 created a simple test case with ms excel 2016: LO will import a *.xlxs spreadsheet with global named range: =Tabelle1!$A$1:$A$3 to $Tabelle1.$A$1:$A$3. and will export "global" named range "Sheet2.$A$1:Sheet2.$A$4" (defined on Sheet1) to "Sheet1!$A$1:$A$3" steps to reproduce: - open *.ods attachment "simple testcase" https://bugs.documentfoundation.org/attachment.cgi?id=150256 - save as *.xlsx - open with excel - Sheet2.B5 dropdown list now displays values from cell range: Sheet1!$A$1:$A$3 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 Oliver Brinzing changed: What|Removed |Added Version|6.2.0.3 release |Inherited From OOo --- Comment #3 from Oliver Brinzing --- if you open the "Manage Names" dialog (Ctrl+F3) on "Sheet1" the named range will point to "Sheet1.$A$1:Sheet1.$A$4", if you do same on "Sheet2" it will point to "Sheet2.$A$1:Sheet2.$A$4". this is already reproducible with AOO 4.1.5. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 --- Comment #1 from Ben Elliston --- Created attachment 150250 --> https://bugs.documentfoundation.org/attachment.cgi?id=150250=edit Reproducible test case -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range
https://bugs.documentfoundation.org/show_bug.cgi?id=124307 Oliver Brinzing changed: What|Removed |Added CC||oliver.brinz...@gmx.de --- Comment #2 from Oliver Brinzing --- Created attachment 150256 --> https://bugs.documentfoundation.org/attachment.cgi?id=150256=edit simple testcase the behaviour is reproducible, but i tend to say it is invalid cause the global named range "PHPP_Daten_Ausrichtung_Bauteil" points to cell range "Sheet1.$A$1:Sheet1.$A$4" instead of "$Sheet1.$A$1:$Sheet1.$A$4" or "$Sheet1.$A$1:$A$4" if you enter values in Sheet2.A1 - Sheet2.A4 they will appear in data validity cell Sheet2.B5 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs