https://bugs.documentfoundation.org/show_bug.cgi?id=151049
Bug ID: 151049
Summary: 16K columns: Show an infobar when there are
pre-defined now-invalid range names
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected]
Blocks: 133764
Before increase of column count to 16k, range names like "num1" were valid,
because they didn't conflict with valid cell/range references.
The mentioned increase made those range names invalid, and their definition is
rejected by UI; still, they may come from existing files created in earlier
versions / generators.
Since commit 582fc887f1faafe8ff5f16a13a0208483a93353f
Author Luboš Luňák <[email protected]>
Date Wed Mar 02 17:30:30 2022 +0100
keep conflicting named ranges working with 16k columns
those names are still read and handled as before, to avoid silent document
breakage.
I believe that it would be an improvement if Calc showed an infobar in such an
event, warning users about a possible name conflict. Imagine a user who opened
their older spreadsheet, and started to fill column NUM, referencing NUM1
normally, and not realizing that it had such a named range defined long ago;
they would be confused why doesn't it work correctly, if they aren't informed
promptly. With the infobar, they would be advised to inspect named ranges (or
database ranges?), and then the conflicting names could also be marked there in
the dialog, too.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=133764
[Bug 133764] [META] Very large spreadsheets problem
--
You are receiving this mail because:
You are the assignee for the bug.
