Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Kruno,

Krunoslav Šebetić schrieb:
Hello,

I need to make a Calc table. Table is "structured" verticly. Tables sums
number values from collums in the last row of table. Every collum stands
for itself, and has nothing do do with oder collums.

But values are enterd in collum by different variables. I have set
different cell background color for every variable. Is there a way to
tell Calc to sum, devide or multiply values by the cell style color?

No, there is no build-in function to get the color of a cell. You need to write a macro. The background color is the property "CellBackColor". It is set, when you color the cell directly and when you color it by style as well.

You can use macro functions in nearly the same way as the build-in functions.


I can not enter summed, devidded or multiplied values directly to collum
because I need to initials values summed (for each collum) so I want to
set some kinde of formula to a different place in sheet with modified
values. Maybe it can be done with sumif?

Maybe I am doing it wrong, maybe it can be done different way?

I would not put such information as color to the cell, but I would use a separate, parallel column, which only contains these flags; not as color but as values, which you can use directly in a build-in function.

Kind regards
Regina

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

Context


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.