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

Am 12.09.2011 16:32, Ant Christy wrote:
> 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 makes absolutely no difference in respect of your already 
entered data.
It is guaranteed that no color, border, font and no other formatting 
attribute has any effect on your precious data and since all formula 
results calculate with data, formula results are affected neither.

Enter all your zip codes as text since you will never do any arithmetics 
on these sequences of digits. You enter literal text into a cell when it 
has been _prepared_ with number format code "@" or when you enter the 
numeric expression with a preceeding apostrophe which will not be part 
of the text value (just a tag meaning "do not evaluate this" analog to 
the "=" in front of a formula).

Number 1 is the exact same value as formatted number 0001, 1899-12-31, 
100%, $1.00, TRUE or any other of the thousands of number format options 
which apply to numbers and numbers only.

Text value 1 is a character that happens to be a digit. Text "1" is not 
a number. This text value will never be equal to number 1 nor any of its 
manifestations. In _some_ situations LibO may treat this text "1" as if 
it were number 1 (unfortunately).


--
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