[libreoffice-users] Re: Calc stops refreshing formula halway down the spreadsheet

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+help@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