Hello Andreas, On Mon, 06 Jun 2011 11:00:26 +0200 (your time) you said:
Second method is much easier but resticted to the formula cells you mentioned. 1. Create your set of cell styles as in the above solution.
2. =SUM((N151+L152)-(P152+R152))+STYLE(VLOOKUP(CURRENT();$X$1:$Y$6;2) Function STYLE returns zero, so the cell value won't be affected.
Thanks. I shall give that a try that later today. :-) -- Si (PLO) #17510. Rho Win Wed Egos? ¶ Auxiliary Information: • LibreOffice 3.4.0 OOO340m1 (Build:12) • Windows XP Pro 5.1.2600 Service Pack 3 -- Unsubscribe instructions: E-mail to users+help@libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted