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

m.a.riosv miguelangelrv at libreoffice.org
Thu Jan 7 11:49:56 PST 2016

Hi Gerard,

about comment in A4, If I'm not wrong, modify cell format never changes the
cell content. Formatting the cell as text after enter a number or a formula,
it doesn't convert them to text.

about the criteria as number only summing for numbers in the criteria range,
I think in calc interpreting text as number is only done with direct
references, not with ranges, putting in B6: =SUM(B3:B6) results is 2 not 4
how results with =B3+B4+B5+B6. There are some options in
Menu/Tools/Options/LibreOffice calc/Formula - Detailed Calculation Settings
- Details, but I think don't help in this case.

Miguel Ángel.

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

More information about the Libreoffice-qa mailing list