https://bugs.documentfoundation.org/show_bug.cgi?id=170580
--- Comment #3 from ady <[email protected]> --- (In reply to Dan Lewis from comment #2) > (1) If I select the check box to prevent the message from appearing again, > it doesn't seem to have any effect. I assume that may be because of (2) > below. Let's try to separate the potential issues. The message appears on the first save (as xlsx) of the file. If you keep working on the file and then save (again) the same file, the message should not show up again on the same file during the same Calc session. If you don't want the message to show up _ever_ (i.e. not for this file nor for the next time you save any other file as xlsx), then you change the status of that checkbox. So, if you don't ever want the question to be asked – it is up to you, I am not saying that you should do it or not – then I would suggest (but only if you really want this to be your setting) starting a new empty Calc worksheet, save it as xlsx, change the checkbox and confirm that the file was saved as xlsx. Close the newly-created file, close Calc and start over, creating yet another empty new worksheet with a new different name. When you save this second file as xlsx, is the message still showing up? > > (2) Since the spreadsheet is so large, it takes a while to do the save. > However, I believe it actually aborts rather than completing the save > because: > > (a) It leaves a .xlsx# file in the directory, and > (b) When I try to reopen the file after doing the save, it says that the > file is corrupted and puts me into recovery mode. The ".xlsx#" file is there when the xlsx file is still "opened". When you completely and correctly _close_ the xlsx file, then the ".xlsx#" should (eventually) disappear. Perhaps it takes some additional time because of its size? If the xlsx file is indeed closed and the ".xlsx#" remains (indefinitely), then when you re-open the same xlsx file Calc assumes that the xlsx file might be corrupted; the same happens with any other type of file (e.g. ods). > > Maybe it's because the file is too large for Libre or mayCalcbe it's because > almost every cell that has content also has a comment attached. I don't > know, but it means I can't really use LibreCalc for my work in its present > state. This is different than the message issue. Please try to follow the steps I wrote above, in order to separate the "message" issue with the "can't correctly save" issue. I would also suggest allowing more time for Calc to complete the save action, considering the size of the file (whichever that "too large" size might be). Another possible suggestion, just for a test, could be to hide all the comments that are shown (since that's the only special feature that you mentioned). In LO 25.8 there are attempts to improve performance related to xlsx files. Your case might be a base to yet another such attempt. ATM we still don't know whether Calc really has a problem with some specific xlsx feature, or that there is some performance issue when saving this specific file. -- You are receiving this mail because: You are the assignee for the bug.
