The point is Bruce, a lot of people subscribe to these threads. Most, I
suspect, race through them looking for situations that apply to them. For
example, I operate on a windows platform. When I read far enough to see
Linux or Mac, I delete and go on. Your tiresome request for reply increase
my time getting through the mail. Please safe your request for a response
for important messages. Someone from the forum will generally try to help.
Don't make people all over the world respond to your request. If we did,
you would be inundated with reply messages, wasting your time.
--------------------------------------------------
From: "Bruce Martin" <[email protected]>
Sent: Wednesday, July 21, 2010 5:31 PM
To: <[email protected]>
Subject: RE: [users] summing cells with different background colors
Dear Neil:
I have not seen this capability, as the colours involved can be far more
than what comes with Oo. Personally I have created a whole set of
additional
custom colours, some custom matched to external samples and each with
special names.
To even start to track this, Oo would have to have all these colours
automatically logged in an internal colour database on the fly, based on
their hexadecimal code, combined with the colour mode being used.
This would have to be that extensive as much to track colours from the
Microsoft world as anything else, as their default colours are different
from Oo.
If someone wanted to do a big programming job and create a "noarch" add-on
to Calc or Oo to handle this, you might be lucky, but I wouldn't hold my
breath!
However if your real need could be resolved by automatically selecting the
last valid line in a sheet, or by specific recognition of one or more text
strings in a particular column, or any Boolean combination of these, that
would be much easier. This is likely if the existing colours were used to
represent some specific condition or conditions relating to the data.
Best Regards,
Bruce Martin
Quebec, Canada
-----Original Message-----
From: Neil Bonine [mailto:[email protected]]
Sent: July 20, 2010 9:18 PM
To: [email protected]
Subject: [users] summing cells with different background colors
I want to get totals of how many cells have a particular background color.
Is this possible in Calc?
N Bo9
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
