[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 Eike Rathke changed: What|Removed |Added See Also|

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 --- Comment #10 from QA Administrators --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 --- Comment #9 from GerardF --- Created attachment 122234 --> https://bugs.documentfoundation.org/attachment.cgi?id=122234=edit Lo Calc test file The expected file. -- You are receiving this mail because:

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 GerardF changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 --- Comment #8 from GerardF --- On AskLibO, Eike wrote : "Apparently Excel treats an array of OFFSET() results differently if it occurs as an argument to SUBTOTAL()." It is not only when OFFSET is inside

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 --- Comment #6 from Winfried Donkers winfrieddonk...@libreoffice.org --- Behaviour in Calc with version 4.4.3.2 is still as mentioned in Description. The behaviour of SUBOTAL in Calc seems to be compliant with the Open Document Format -

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.documentfoundation.org/show_bug.cgi?id=58874 --- Comment #5 from QA Administrators qa-ad...@libreoffice.org --- ** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.freedesktop.org/show_bug.cgi?id=58874 GerardF gerard.farg...@orange.fr changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.freedesktop.org/show_bug.cgi?id=58874 --- Comment #4 from GerardF gerard.farg...@orange.fr --- A workaround for your sample : Add a column with the formula =SUBTOTAL(3;A9) in H9 and drag down (with filter to All) Then =SUMPRODUCT($H$9:$H$260; --($G$9:$G$260=H4)) will gives you the

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.freedesktop.org/show_bug.cgi?id=58874 A stgohi-lob...@yahoo.de changed: What|Removed |Added OS|Linux (All) |All

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.freedesktop.org/show_bug.cgi?id=58874 Jorendc joren.libreoff...@telenet.be changed: What|Removed |Added Attachment #72285|text/plain

[Libreoffice-bugs] [Bug 58874] compatibility with excel formula

https://bugs.freedesktop.org/show_bug.cgi?id=58874 --- Comment #1 from Giovanni ammamm...@tiscali.it --- the formula has been tested both in libreoffice and apache openoffice, no way I just wonder whether there is a more simple function to get what I need, to count precise values in a filtered