I haven't found a good answer yet, but I have figured out a few more symptoms. The reason the formula stops refreshing is because the formatting of the cells is changed halfway through the spreadsheet. Basically the formula set up is matching numbers in column D to numbers in column A and using COUNTIF to total them. The numbers that we're working with are zip codes, so some start with zero. In order to hold that place all cells start with an apostrophe. The formatting change that's occurring is after 175 lines Libre removes the apostrophe. The original Excel document has the cells formatted as "number stored as text". Is there a way to do this in Libre?
-- View this message in context: http://nabble.documentfoundation.org/Calc-stops-refreshing-formula-halway-down-the-spreadsheet-tp3316596p3329767.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted