Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 06 Aug 2013 21:40:21 +0200Function Domains/Conditional Formattinghttps://ask.libreoffice.org/en/question/21177/function-domainsconditional-formatting/I have two questions about LibreOffice Calc:
1. Is there a way to set a variable domain for a function? For example, if I want a function to find the median of all the values in a column, how can I get the function to adjust its domain automatically whenever I add a new piece of data to the column? I want to avoid having to change the function from =MEDIAN(B1:B10) to =MEDIAN(B1:B11) (and so on) every time I add a row. Better yet, is there a way to set the domain to "every cell within the column that contains a value"?
2. If I have a set of reference data in row 1 and actual data in rows 2–10, is it possible to use conditional formatting to set a different formatting style for each cell in rows 2–10 based on the relationship of each piece of data to the reference data in row 1? I'm not sure how to explain this concisely.ajrlegitsTue, 06 Aug 2013 21:40:21 +0200https://ask.libreoffice.org/en/question/21177/Is there a maximal number of arguments for functionshttps://ask.libreoffice.org/en/question/10338/is-there-a-maximal-number-of-arguments-for-functions/I am trying to conduct a simple MEAN function with reference to 75 cells. The problem ist that it only takes reference to the first 30. The 31th and the following are not taken into calculation of the mean.
Does anybody know if there is a maximal number of arguments that the function can take reference to? HannutahWed, 23 Jan 2013 16:07:11 +0100https://ask.libreoffice.org/en/question/10338/