I’m running into a series of unexpected issues with LibreOffice that are making it difficult to manage the data pipeline for my Texas Roadhouse menu website. I rely heavily on Calc spreadsheets to maintain menu items, nutrition tables, ingredient lists, pricing history, and category groupings before exporting the data to CSV or JSON. For months this workflow worked flawlessly, but recently Calc has started behaving unpredictably when handling the larger sheets. Basic actions like scrolling, filtering, or applying conditional formatting cause noticeable lag, even though my machine has plenty of free RAM and CPU. It feels like something in the document structure is causing Calc to struggle with operations that were once instant.
Another issue involves conditional formatting rules randomly breaking. I use these rules to color-code certain menu categories steaks, sides, drinks, desserts and to highlight rows when nutritional values cross certain thresholds. Lately, these rules either stop applying or duplicate themselves multiple times in the “Manage Rules” dialog. This causes the sheet to grow in size and become even more sluggish. Even after removing and recreating the rules, the same thing happens again after reopening the file. I’m unsure if this is a corruption issue or a known Calc bug related to conditional formatting on large datasets.
I’m also having trouble with CSV exports. When saving the spreadsheet as a CSV for import into my site’s backend, Calc sometimes changes the delimiter unexpectedly or encodes certain special characters incorrectly. This causes menu names especially those with apostrophes or special formatting to break the parser in my website’s importer. I double-check the options each time I export, but the settings appear to “reset” depending on which sheet I exported last. I’ve tried clearing profiles and reinstalling LibreOffice, but the issue persists and makes it difficult to produce consistent data output.
Another odd behavior appears when using Calc’s built-in search and replace. I use this frequently to update prices, fix formatting, and adjust nutrition values across the document. Recently, the search results have stopped highlighting matches in certain ranges, even though the values clearly exist. In some cases, search works only on a subset of the sheet unless I manually select the entire document first. This makes global updates slower and more error-prone, especially for a dataset as large as the Texas Roadhouse menu structure I’m maintaining.
On top of that, I’ve noticed that styles and formatting sometimes shift or break when reopening the file. Column widths change, borders disappear, and number formats revert to defaults. This is particularly disruptive when preparing menu exports or print-friendly tables for internal documentation. I’ve checked for template issues and style conflicts, but I haven’t found anything conclusive. The same file behaves differently on another machine running the same LibreOffice version, which makes the root cause even harder to understand.
Overall, I’m trying to determine whether this is related to Calc performance limits, document corruption, profile issues, or something misconfigured in my LibreOffice installation. I’d appreciate any suggestions on how to diagnose and stabilize large Calc spreadsheets, especially those used for regular CSV exports and heavy formatting like mine. My Texas Roadhouse menu website depends heavily on this workflow, so I really need to get Calc back to a reliable and predictable state. Sorry for long post!