https://bugs.freedesktop.org/show_bug.cgi?id=58874
Priority: medium
Bug ID: 58874
Assignee: [email protected]
Summary: compatibility with excel formula
Severity: enhancement
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.5.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 72285
--> https://bugs.freedesktop.org/attachment.cgi?id=72285&action=edit
contains the formula and some data
starting from this link:
Source: Excel Count Functions -- Count Excel Cells Address :
<http://www.contextures.com/xlFunctions04.html#Visible>
=SUMPRODUCT(SUBTOTAL(3,OFFSET(A1:A10,ROW(A1:A10)-MIN(ROW(A1:A10)),,1)), --
(A1:A10=A12))
I applied it on a document: once opened in libreoffice the formula gives an
error while in excel it does work fine.
=MATR.SOMMA.PRODOTTO(SUBTOTALE(3;SCARTO($G$9:$G$260;RIF.RIGA($G$9:$G$260)-MIN(RIF.RIGA($G$9:$G$260));;1));
--($G$9:$G$260=H4))
I attach the small sample file
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
