Re: [libreoffice-users] Calc Sum cells based on color

Franco, 

What do you do to color the cells in the first place? I'm guessing that you use some conditional 
formatting formula. Just a thought but could you use that same information to derive your sums 
instead of trying to base it on the colors? Cell formatting is primarily (if not solely) designed 
for visual effect -- not programmatic control. You might need to add some hidden columns or rows as 
helpers. 

BTW, for future reference, you originally "hijacked" a thread dealing with some malware by using 
the reply (all?) feature of email and totally changing the subject. This caused the two threads to 
get intertwined and diluted the impact of your Subject. In this case, "What's done is done."
 
-- 
Jim

-----Original Message-----
From: Franco <franco@w4u.it>
To: users@global.libreoffice.org
Sent: Sun, 20 Apr 2014 9:24
Subject: [libreoffice-users] Calc Sum cells based on color

Hm, html stripped away.
Let me retry adding a link to an image explaining what I mean:
http://s30.postimg.org/616qwbcb5/calc_sum_colors.png

----------

Hi all,

I'm looking for a solution to a problem with Calc similar to many 
requests I read googling around.
Here the question:
I have an activity by month table and I want to write in every row the 
hours employed by some people on that job.
I need a way to get a quick look to the entire table so I can visually 
realize the people/day assignments and redistribute the next activities.
There are only few peoples, so I assign a color to everyone and set a 
background color for the day that person made the job.

Example (only 9 days for briefness):
Anna: red
Marco: green
Laura: yellow

See the link at the top.


Any hint please?
Thank you all.

Franco

-- 
To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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