Bug 144720 - Calc (linux) closes if the rows number range exceed the maximum
Summary: Calc (linux) closes if the rows number range exceed the maximum
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.6.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: P.S.
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-25 14:12 UTC by P.S.
Modified: 2022-12-23 08:14 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Image showing the error dialog (30.63 KB, image/png)
2021-09-25 14:43 UTC, Rafael Lima
Details
Screenshot when the area A1:A9999999 was selected - Calc crashing (22.17 KB, image/jpeg)
2022-12-23 00:30 UTC, P.S.
Details
Error window when the area is selected by scroll down (13.30 KB, image/jpeg)
2022-12-23 00:34 UTC, P.S.
Details

Note You need to log in before you can comment on or make changes to this bug.
Description P.S. 2021-09-25 14:12:14 UTC
Description:
If I select A1:A999999 - Calc unexpectedly closes
(if I try  to select A1:ZZZ1 - the error message appears)

* please add to the error window the information about the maximum value of cell number

Steps to Reproduce:
1. put corsor to the name box
2. type "A1:A9999999" and press Enter


Actual Results:
Calc unexpectedly closing

Expected Results:
Appearing the information window ("You must enter a valid reference or type a valid name for the selected range.") and I recommend to add information of MAXIMUM VALUE OF CELL NUMBER valid for current version of Calc


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.6.2
Build ID: 00(Build:2)
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: x11
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
Calc: threaded
Comment 1 Rafael Lima 2021-09-25 14:43:35 UTC
Created attachment 175268 [details]
Image showing the error dialog

Hi... I tested it on my machine and all is OK (see attached image).

I tested it on the Kf5 plugin.

Version: 7.2.1.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 16; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.1~rc2-0ubuntu0.21.04.1~lo1
Calc: threaded

I also tested in the "gen" VCL plugin and all worked fine.

Let's see if anyone else can confirm this bug.
Comment 2 Roman Kuznetsov 2021-09-25 15:17:41 UTC
no repro in

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 1516711eb7861a08cc9fd19ec867360737a6d070
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

I see just a message about non correct range:

"You must enter a valid reference or type a valid name for the selected range."
Comment 3 raal 2021-09-27 15:04:44 UTC
no repro Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: b63c5ade3554a42def4bce94f9fd67ea66528214
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: x11
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded
Comment 4 raal 2022-06-24 04:17:54 UTC
PLease retest with newer version. Thank you
Comment 5 QA Administrators 2022-12-22 03:36:20 UTC Comment hidden (obsolete)
Comment 6 P.S. 2022-12-23 00:28:20 UTC
After the year of system updates there is no problem with the same LO 7.0.6.2
I couldn't repeat the same situation - now it's work!
Now last cell is AMJ1048576.

So I change status to UNCONFIRMED.
Thanks everyone!
Comment 7 P.S. 2022-12-23 00:30:50 UTC
Created attachment 184322 [details]
Screenshot when the area A1:A9999999 was selected - Calc crashing
Comment 8 P.S. 2022-12-23 00:34:10 UTC
Created attachment 184323 [details]
Error window when the area is selected by scroll down

Now I can't repeat this bug.
Comment 9 Roman Kuznetsov 2022-12-23 08:14:17 UTC
Closed as WFM