Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenTue, 08 Dec 2015 17:47:10 +0100What's wrong with this formula?https://ask.libreoffice.org/en/question/61729/whats-wrong-with-this-formula/Hi,
I have a standard filter applied to one or more columns and need to count the resulting **visible** cells in another column that equal a certain value. In Excel this can be done with the following formula:-
=SUMPRODUCT(SUBTOTAL(3,OFFSET(BH10,ROW(BH10:BH1000)-ROW(BH10),0))*(BH10:BH1000="T"))
This counts the number of visible cells in column BH that equal "T". The result happens to be 29, however when I use this same formula in Calc on the same spreadsheet I get 270538 !. Anyone know what could be going on here?. Thanks. p.s. I should add that it makes no difference if the formula is entered as an array formula or not.
LO 4.4.6.3 on Linux.redartTue, 08 Dec 2015 17:47:10 +0100https://ask.libreoffice.org/en/question/61729/calc comments backgroundhttps://ask.libreoffice.org/en/question/61513/calc-comments-background/In Calc, when I mouse over a cell that has a comment in it, the comment will appear but the background is transparent except for the areas immediately behind the text. If there is more than one line of text then a transparent gap shows between each line. The comment box border is also missing. Occasionally the comment will appear as intended - a box with a pale yellow background and a dark border. Any way to correct this behaviour, or is it a known bug?. Thanks. LO 4.4.6.3, Linux.redartWed, 02 Dec 2015 13:30:24 +0100https://ask.libreoffice.org/en/question/61513/