On 6 Jun 2011 at 21:59, Andreas Säger wrote:
To: users@libreoffice.org
From: Andreas Säger <villeroy@t-online.de>
Subject: [libreoffice-users] Re: Multuple rules/conditions to
range of cells
Date sent: Mon, 06 Jun 2011 21:59:48 +0200
Send reply to: users@libreoffice.org
Am 06.06.2011 15:12, Michael D. Setzer II wrote:
I've tried another method that seems to give the results.
Unfortunately, it appears the current() doesn't give the results of
what is before the style when used in a formula?
Difficult to tell without concrete formula.
I had an earlier formula that was working using the reference to a
cell like A1, but when I replaced that with current(), it did not work
correctly. I assuming that since the current() was inside the other
functions that it was giving some other value.
The lookup options is also something I've used, and it is very
useful, but just another option that is available.
=(A1)+STYLE(CHOOSE(MIN(INT(((A1)-((A1)
1000))/1000)+1,6),"Red_bold","red","blue_bold","blue","orange","default"))
I used a single cell for the formula, but the (A1) could be replaced
with the formula (SUM((N151+L152)-(P152+R152))) or
(N151+L152-P152-R152) to give the same results.
Would have been simpler if all the options where< multiples of
1000 or all<=. I also added max and min, so a negative or higher
value would fall into the ranges.
I created styles with the matching names giving the styles.
Looking up the style name has 2 advantages: You can easily modify the
style names in the stylist and in the lookup table and you can modify
the threshold values in one place for all calculations including
conditional formattings. Quite often such a lookup table includes more
than 2 columns. Finding all occurrences of a particular format conditon
can be difficult.
--
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
+----------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:mikes@kuentos.guam.net
mailto:msetzerii@gmail.com
http://www.guam.net/home/mikes
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+
http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned: 19,471
Processing time: 32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)
BOINC@HOME CREDITS
SETI 10840698.799905 | EINSTEIN 5978952.530851
ROSETTA 3215702.700203 | ABC 6158864.767707
--
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
Context
- Re: [libreoffice-users] Multuple rules/conditions to range of cells (continued)
[libreoffice-users] Re: Multuple rules/conditions to range of cells · Andreas Säger
[libreoffice-users] Re: Multuple rules/conditions to range of cells · Andreas Säger
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.