New spreadsheets work fine but after I have attached several worksheets and added data suddenly the system starts pausing between cell entry with the program working away at something for up to 5 seconds. I have tried switching off recalc and all the other commonly discussed issues on the help site, but none get it back up to speed. I use Calc because Excel is still very poor at formatting larger text entries an Calc is brilliant at this. However the long pauses between entry are leading to mistakes and make the system near unusable. What does Calc do as you press enter - whatever it is it takes ages unless you are using a simple single sheet spreadsheet. I use Calc to prepare Bills of Quantities which have a large text element with simple calculations, page totals and summaries. I regularly contribute to your funding and was hoping to make this my main spreadsheet but I am wondering if I have done the right thing
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Please attach your sample file here. Just above the first comment. I think there is no confidential information on it. I can't reproduce the issue. There are conditional formats on the four sheet with bad formulas. Take a look if OpenCL is enabled Menu/Tools/Options/LibreOffice/OpenCL, it speeds up the calculations.
Please don't send private messages, put here them. They are only for special cases when some information, or file contain can not be share in public. You didn't past the information about LibreOffice version and OS, solicited on comment#1. Please test in safe mode, Menu/Help/Restart in Safe Mode.
@Angus, (In reply to m_a_riosv from comment #2) > Please attach your sample file here. With "here", Miguel means please open your web browser and go to: <https://bugs.documentfoundation.org/show_bug.cgi?id=161266> In that web page, look for the link that says "Add an attachment". Click on that link and follow the instructions to attach a file to the report. Please do not reply to the emails, and please don't attach files to emails either. Always use the web page I linked above; not by emails. The emails you receive are only intended to let you know that there is some kind of update or change to the bug report; they are not for you to reply to the emails. Do _not_ reply to these emails. If you have additional comments regarding the bug report, please add a new comment in the web page I linked to above; do not send emails. If you want to use emails, then subscribe and use the User's mailing list, instead of opening bug reports. Even then, when using the mailing list, you have to send messages to the mailing list, not to specific users.