[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