Bug 140394 - There should be a warning, if print range would exceed the maximum number of rows
Summary: There should be a warning, if print range would exceed the maximum number of ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Print-Range
  Show dependency treegraph
 
Reported: 2021-02-13 17:20 UTC by alex
Modified: 2022-02-03 11:28 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description alex 2021-02-13 17:20:28 UTC
Description:
Calc: Print range added to "Named Ranges and Expressions" doesn't show up in the print ranges dialogue if row number has more than 6 digits. If it has 6 digits max it shows up.

Steps to Reproduce:
1. Create empty sheet.
2. Sheet--Named Ranges and Expressions--Manage
3. Create a new range covering $A$1:$A$9999999 and define it as a print range by ticking "Print range" under "Range options".
4. Open Format--Print Ranges--Edit and click at the dropdown menu for adding a range.



Actual Results:
The range doesn't show up in the list of named print ranges.

Expected Results:
The range should show up as a print range, or, if 7 digits row numbers are too much too handle, I'd like an error message when I try to define it so I know.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.6.2
Build ID: 1:6.4.6-0ubuntu0.20.04.1
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: sv-SE (sv_SE.UTF-8); UI-Language: en-GB
Calc: threaded
Comment 1 alex 2021-02-13 17:34:33 UTC
It's not the number of digits that are relevant. It works with 1048576 rows max, anything over that will not work.
Comment 2 [REDACTED] 2021-02-13 23:18:32 UTC
Why do you expect a print range exceeding the maximum number of rows (2^20 = 1048576
) in a calc spreadsheet (neglecting experimental feature "large sheets" in version 7.0 and later) to work? From my perspective this is not a bug, though it is disputable whether there should be a warning about an out-of-boundary named range.
Comment 3 alex 2021-02-14 09:50:26 UTC
(In reply to Uwe Auer from comment #2)
> Why do you expect a print range exceeding the maximum number of rows (2^20 =
> 1048576
> ) in a calc spreadsheet (neglecting experimental feature "large sheets" in
> version 7.0 and later) to work? From my perspective this is not a bug,
> though it is disputable whether there should be a warning about an
> out-of-boundary named range.

What makes it a bug is that there's no error message. If I do something that the program will ignore or that will make the program unstable, I expect to get noticed as to why this is so. This is the behaviour in other cases: For example if I try to SUM a too large area, maybe by a writing typo etc, I get a #NAME? in the cell to tell me that something is wrong with the range.
Comment 4 Heiko Tietze 2022-02-03 11:28:12 UTC
The possibility to enter wrong values need to be checked / prohibited in the UI. Rather than an interrupting message box, the input field should show the error by a different control background via set_message_type(weld::EntryMessageType::Error) and disable the confirmatory action ie. the Okay button.