Summary: | 16K columns: Show an infobar when there are pre-defined now-invalid range names | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Mike Kaganski <mikekaganski> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | 79045_79045, erack, heiko.tietze |
Priority: | medium | ||
Version: | 7.4.0.3 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=151046 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 83009, 133764 |
Description
Mike Kaganski
2022-09-19 07:28:01 UTC
Valid enhancement, set to NEW UX-team, do you have some additional ideas here? About infobar using in general here About text on the infobar in this case About some button that could open some dialog for change range name etc... Sounds to me as old document always present such an infobar. And I assume it's unlikely that non-developer understand the issue. Is it possible to only show the infobar if something is immediate to break? What exactly would be the warning (or is it an information) and what action would the infobar provide? (In reply to Heiko Tietze from comment #2) > Sounds to me as old document always present such an infobar. Why? > And I assume > it's unlikely that non-developer understand the issue. Why? > Is it possible to only show the infobar if something is immediate to break? The issue is to show the warning when "something is broken", not always. Let me repeat: *Only* when the old spreadsheet already had *user-defined* ranges, and *only* when some of those ranges had names that were valid on older versions, but not in newer versions, *only then* (i.e., when the document *already* has invalid range names, and it only works because we implement a workaround) should a message be shown ... > What exactly would be the warning (or is it an information) and what action > would the infobar provide? ... with something like "Some of the named ranges used in the spreadsheet have invalid names that conflict with row/column names: * num1 * mom2 * kit3 Press this button to open Named ranges dialog and rename these ranges." (In reply to Mike Kaganski from comment #3) > *Only* when the old spreadsheet already had *user-defined* ranges... Makes sense in this case. > "Some of the named ranges used in the spreadsheet have invalid names that > conflict with row/column names: ... Could imagine that this list can be long, too long for the infobar. So perhaps we show it in a special list on click. The infobar level would be warning, not info (makes it yellow, IIRC). (In reply to Heiko Tietze from comment #4) > Could imagine that this list can be long, too long for the infobar. So > perhaps we show it in a special list on click. Just limit it to three entries and ellipsis if more. A click list on an infobar IMHO doesn't make much sense if it isn't actionable. |