Bug 144518 - CALC exceeding perceived limits for pasting doesn't elicit any warning
Summary: CALC exceeding perceived limits for pasting doesn't elicit any warning
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-15 13:29 UTC by Colin
Modified: 2022-09-07 13:06 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Colin 2021-09-15 13:29:25 UTC
Description:
It may be either a "self-imposed limitation" based solely upon the amount of memory available to the application or a failure to paste a single item into exceptionally large blocks of data. If it is indeed self-preservation then perhaps a warning should be given. However, I have managed to force the copy process to continue into the entire sheet causing memory error crashing and total dedication of the processor to interrupt processing.

Steps to Reproduce:
Create a new empty CALC
Select the entire sheet with the cell/space between column and row headers - the "master cell"
Observe the entire sheet is defined in the address box
Observe the text format is identified for the entire matrix
Amend the font or the weight to anything you desire
Focus on a random cell and observe the new characteristics are replicated for every cell.
Clearly, the "master cell" focuses everything

Scenario 1
type a single character into A1 and copy the contents
Select the entire sheet with the "master cell"
Attempt to paste the memory contents by any means available
Nothing happens

Scenario 2
Focus and copy A1 then ctrl+shft+right
Paste and paste special both fill Row 1 with the character

Scenario 3
Having filled row 1 it is still in focus, copy row 1
select the "master cell" - everything is in focus and will accept any command to copy
Whilst it accepts the command it had catastrophic results on my PC

Scenario 4
Clear the sheet and type a single character into A1
Type a single character into AMJ1048576 - the last cell in the sheet
focus either A1 (or AMJ1048576 as you're already there) and copy the cell contents
Select the entire sheet with the "master cell"
Attempt to paste the memory contents to the selected array by any means available
Nothing happens

Scenario 5
Place a character into each of the sheet corner cells
Copy any one of the four populated cells then select the entire sheet with the "master cell"
any attempt to paste will fail

Scenario 6
With data in each of the sheet corner cells
Copy one of the cells then select the entire sheet with the "master cell"
By incrementally editing the matrix address in the address box towards a substantial reduction of the row number, there will eventually be a reaction to a "paste" by confirmation of the desire to overwrite existing data.
I never finalised this copy attempt as I try to avoid too many disaster recoveries and impose a personal limit of one per day.


Actual Results:
Failure to complete all copy processes and system crash
Failure to provide system limitation warning

Expected Results:
faultless copy or warning that the system limits may be breached by this operation


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
i5 3.4Ghz 8GB RAM
Comment 1 Eike Rathke 2021-09-15 13:51:28 UTC
So what. You proudly managed to navigate the application into a DOOM state where your machines memory is exhausted. Now what.
Comment 2 Colin 2021-09-15 14:02:09 UTC
(In reply to Eike Rathke from comment #1)
> So what. You proudly managed to navigate the application into a DOOM state
> where your machines memory is exhausted. Now what.

This resulted from some simple experiments to ascertain why hiding columns is instantaneous but hiding rows challenges the capacity of a CRAYII.

I think not providing a warning is about as amateurish asssss, let's see now.... your response - which says more about you than anything else.
Comment 3 Colin 2021-09-19 05:16:18 UTC
Further experiments have identified that a Microsoft product - "Mouse without Borders" - which has the capacity to permit clipboard pasting across computers, will "reserve" the same amount of memory that is being allocated by LO to the clipboard during LO's "copy-paste" process.

This allocation occurs despite the fact that the "allow pasting across computers" parameter is disabled AND due to a key change, the product has not even recently been "paired" with the other three PCs.

The memory hog is indeed MwB which simply replicated the ever-increasing memory requirements of LO with the re-doubling of the clipboard to increase the speed of "copy-paste".

Yes, MwB has subsequently been reassigned to the RatBin

Presumably, that means SOLVED  NOTABUG