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

[Gérard Fargeot]

Hi all,

For Bug 96923 (https://bugs.documentfoundation.org/show_bug.cgi?id=96923),
we need someone with Excel.
The purpose is to check if Excel treat numbers written as text (with '
before) like numeric 1 in SUMIFS.

If it is the case, can somenone provide a short file with mixed value:
1 written as numeric value,
1 with a ' befrore in cell with standard formatting,
1 in a cell formatted as text.

And various calculation within this data:
Simple SUM, COUNTIF, SUMIF, COUNTIFS, SUMIFS.
and (not sure if necessary) some search functions like (V/H)LOOKUP, MATCH)

I don't have any version of Excel myself.

Gérard



--
View this message in context: http://nabble.documentfoundation.org/QA-Need-someone-having-Excel-tp4171047.html
Sent from the QA mailing list archive at Nabble.com.