I have problems with all versions greater 4.3.7.2. I work with calc and there I have huge tables (more than 50000 rows). I often copy a column to a text editor, work on it and copy it back again to calc. This always worked fine but not with versions greater 4.3.7.2. When I insert such a colum (simply numbers) calc crashes. In the task manager I can see ram is increasing to about 1,5 gb and the it crashes. I tried many new versions, 32bit and 64bit, everywhere the same thing... My files are about 5-15 MBs, 10-30 columns with unformatted text.
Hi @andreas, thanks for reporting. Have you test, pasting as unformatted text?, click on the righ-arrow of the paste icon or trough Menu/Edit/Paste special.
Hi, it happens when I insert a column of numbers in a text column: 10.2 2.5 ... replaced by 10,2 2,5 ... I copy the column, insert it in a text editor, replace dot by comma and then back to calc. If I clear the column first and then insert, there is no problem. But if I try to "overwrite" it, calc crashes...
Sorry, but I don't see an answer to my question. On the other side, you don't need use a text editor for change dot by comma. The simple way is Menu/Data/Text to column, click on the column head and in the column type select English US. With the search and replaee [Ctrl+H] you can replace dot by comma, only verify that regular expression are not marked. Calc documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
(In reply to m.a.riosv from comment #3) > Sorry, but I don't see an answer to my question. > > On the other side, you don't need use a text editor for change dot by comma. > > The simple way is Menu/Data/Text to column, click on the column head and in > the column type select English US. > > With the search and replaee [Ctrl+H] you can replace dot by comma, only > verify that regular expression are not marked. > > Calc documentation: > https://wiki.documentfoundation.org/Documentation/ > Publications#LibreOffice_Calc_Guide Sorry, yes, I tried to paste unformatted text. I know there are other ways but I think it should be possible to paste more than 100000 rows of unformated text and overwrite a text column with numbers (standard). In earlier versions this took a second, now in huge files the whole program crashes. I made a test file with just 2 columns, each 150000 rows and there it really takes some minutes to paste! There must be something calc is doing when you paste numbers over text and I would like to know if I can deactivate this. One thing you can disable is the automatic text correction, but this is not the solution for this problem...
Created attachment 122342 [details] testfile for overwriting I want to overwrite col A or B with numbers (standard)
Created attachment 122343 [details] source file for numbers
So I just uploaded two files: please open the txt-file, copy all data, open the ods-file an try to overwrite col A or B.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team Sun, 11 Sep 2016 21:43:24 +0200
Please @andreas, column B in your sample is formatted as text @. Pasting special as unformatted text, using a language with comma decimal separator, past quick for me. Also not having enable Menu/Tools/Options/Load-Save/HTML configuration - Use English (USA) locale for numbers.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170328
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20170502