This bug was filed from the crash reporting server and is br-e2f4a096-5619-4152-a020-c8cf3eabcdb1. ========================================= Crash occurred when attempting to copy a formula down a column in a large spreadsheet with all rows occupied with a column of data, and several further columns fully occupied with data or formulae.
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
File size is too large for me to upload. Try to create an example as follows:- In an new sheet place =rand() into columns A-F for all rows. In G2 put formula =if(b2>c2,d2,e2) Copy cell G2 over the rest of column G. Crash occurs with "bad allocation" message.
(In reply to Libomark from comment #2) > File size is too large for me to upload. Try to create an example as > follows:- > > In an new sheet place =rand() into columns A-F for all rows. In G2 put > formula =if(b2>c2,d2,e2) > > Copy cell G2 over the rest of column G. > > Crash occurs with "bad allocation" message. I don't get a crash. You are apparently running out of memory. Did you monitor your memory usage? Developers have said that crashing when running out of memory is the only sane thing to do. Arch Linux 64-bit, KDE Plasma 5 Version: 6.0.0.0.alpha0+ Build ID: bf3a87d1ee9106161d26f33c1ccb6b7b0d0aa0b9 CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on September 7th 2017
(In reply to Libomark from comment #2) > File size is too large for me to upload. Try to create an example as > follows:- > > In an new sheet place =rand() into columns A-F for all rows. In G2 put > formula =if(b2>c2,d2,e2) > > Copy cell G2 over the rest of column G. > > Crash occurs with "bad allocation" message. Could you please use another service like dropbox or google drive?
(In reply to Buovjaga from comment #3) > (In reply to Libomark from comment #2) > > File size is too large for me to upload. Try to create an example as > > follows:- > > > > In an new sheet place =rand() into columns A-F for all rows. In G2 put > > formula =if(b2>c2,d2,e2) > > > > Copy cell G2 over the rest of column G. > > > > Crash occurs with "bad allocation" message. > > I don't get a crash. > > You are apparently running out of memory. Did you monitor your memory usage? > > Developers have said that crashing when running out of memory is the only > sane thing to do. > > Arch Linux 64-bit, KDE Plasma 5 > Version: 6.0.0.0.alpha0+ > Build ID: bf3a87d1ee9106161d26f33c1ccb6b7b0d0aa0b9 > CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kde4; > Locale: fi-FI (fi_FI.UTF-8); Calc: group > Built on September 7th 2017 I doubt I am running out of memory. I have 8GB of RAM. When I fill columns A-F as described Win Task Manager reports soffice taking just over 1.6GB. When I try to copy the formula in G2 over the rest of the column, a core of the processor remains dedicated to LO for some tens of seconds with the RAM used increasing to just over 1.7GB before the crash occurs. I can avoid a crash by copying 100,000 rows at a time. I note there is a difference in memory allocation if I enter =rand() in A1..F1 and then copy those cells to all other rows (under 1.4GB), compared with creating a complete column A and then copying the column to columns B-F. I note you are running under Linux: I am running under Win 7.
> I doubt I am running out of memory. I have 8GB of RAM. The x86 build of Libreoffice will crash at some point when using more than 1,2GB. A single process in x86 isn't 'allowed' to use more (even if available). https://stackoverflow.com/questions/14186256/net-out-of-memory-exception-used-1-3gb-but-have-16gb-installed
No crash for me with a Thinkpad T520 with 8 GB of mem. Libomark: please test with 64-bit version Win 7 Pro 64-bit Version: 6.0.0.0.alpha0+ (x64) Build ID: 41b7713334351d7cc455eef5241bd3988b9d1e94 CPU threads: 4; OS: Windows 6.1; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-09-13_22:53:00 Locale: fi-FI (fi_FI); Calc: CL
Confirm that 64 bit avoids the crash. Is there anywhere I can guage how large a sheet I can have under 64 bit? I had already resorted to programming in a compiled language to get round the limitation of the 32 bit version.
(In reply to Libomark from comment #8) > Confirm that 64 bit avoids the crash. Is there anywhere I can guage how > large a sheet I can have under 64 bit? I had already resorted to > programming in a compiled language to get round the limitation of the 32 bit > version. Sorry, I don't know how to gauge that. I guess we should close this..