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. _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/
