[Libreoffice-qa] [QA] Need someone having Excel

Mirosław Zalewski miniopl at poczta.onet.pl
Thu Jan 7 10:42:30 PST 2016


Dnia 2016-01-07, o godz. 11:18:41
Gérard Fargeot <gerard.fargeot at orange.fr> napisał(a):

> Finally, I make a file with LO 5.0.4
> If someone can open it with Excel and check the results...
> Count_Sum_andSearch_withNumbersAsText.xlsx
> <http://nabble.documentfoundation.org/file/n4171083/Count_Sum_andSearch_withNumbersAsText.xlsx>  
> 
> Save the file with Excel and (if you have some FALSE in column D)
> attach the file to the bug report.

Here is screenshot of this file opened in Microsoft Excel 2016 (from
Office 365 package):
http://imgur.com/DmS9V43

FAŁSZ means FALSE, PRAWDA means TRUE. 
Looks like COUNTIF(S) and SUMIF(S) are not working as you expected.

I trust this helps
-- 
Best regards
Mirosław Zalewski


More information about the Libreoffice-qa mailing list