Hi Daniel,
Daniel Rentz wrote (7-8-2008 11:18)
I have a few Excel versions lying around here, and cannot find any
differences.
Tested Excel versions:
- Excel 3.0a German UI
- Excel 4.0 German UI
- Excel 5.0 German UI
- Excel 2003 German UI
- Excel 2003 English UI
- Excel 2007 English UI
I have made the following test:
A1: 1.5
A2: '1.5
A3: '1.500
A4: '1,500
A5: text
A6: =A1+A2+A3+A4
A7: =SUM(A1,A2,A3,A4)
A8: =SUM(A1:A4)
A9: =1.5+"1.5"+"1.500"+"1,500"
A10: =SUM(1.5,"1.5","1.500","1,500")
A11: =A1+A2+A3+A4+A5
A12: =SUM(A1,A2,A3,A4,A5)
A13: =SUM(A1:A5)
A14: =1.5+"1.5"+"1.500"+"1,500"+"text"
A15: =SUM(1.5,"1.5","1.500","1,500","text")
Using locale "en-US", the results of the formula cells are:
A6 = 1504.5
A7 = 1.5
A8 = 1.5
A9 = 1504.5
A10 = 1504.5
A11 = #VALUE!
A12 = #VALUE!
A13 = 1.5
A14 = 1.5
A15 = #VALUE!
- "1.5" and "1.500" are interpreted as 1.5
- "1,500" is interpreted as 1500
- the addition operator always tries to convert text to numbers
- the SUM function ignores text cells, but converts literal text
Using locale "de-DE", the results of the formula cells are:
A6 = 41072
A7 = 1,5
A8 = 1,5
A9 = 41072
A10 = 41072
A11 = #VALUE!
A12 = #VALUE!
A13 = 1,5
A14 = 1,5
A15 = #VALUE!
- "1.5" is interpreted as 1st of May 2008, resulting in 39569
- "1.500" is interpreted as 1500
- "1,500" is interpreted as 1.5
Do you have other examples that I may test in different Excel versions?
Thanks, that helps a lot.
Clear that an operator treats text numbers different than a function.
Maybe my impression that different Excel-versions behave different,
comes from that situation, while I have not checked most of the input I
hear from users.
Also there seems little reason to think that other Excel-versions (7/95,
8/97, 9/2000, 10/XP) behave different.
Regards,
Cor
--
"The Year of 3" -2008- "Het jaar van 3"
Cor Nouws - Arnhem - Netherlands
> marketing contact - http://nl.OpenOffice.org
> Zeker van OpenOffice.org - www.nouenoff.nl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
