Created attachment 53345 [details]
SpreadSheet for calcuation of differents parameter of Electric Vehicles
The same spreadsheet in LibreOffice and OpenOffice don't behave the same way.
Testing empty cell, or null cell don't give the same result
Steps to reproduce:
1. load the attached spreadsheet
2. test it with OpenOffice
3. test it with LibreOffice.
Lot of cells in sheet "Tables" have error code : "type de donnée incorrect"
This error is not observed with OpenOffice
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Attachment contains basic macro. If it disabled, most cells in tables contain error "Divide by zero". If enabled, in 3.3.4 all ok. In 3.5.2 many cells contain errors.
I don't have AOO installed but from Sasha's comment I suspect that it's your security settings in LibO vs. AOO that are resulting in differences. In AOO if you allow macros to be enabled by default, you'll see different behavior than from LibO which prevents this by default. Marking as NEEDINFO.
Can you confirm (or deny) that this is the case? Mark as UNCONFIRMED if this isn't the case and I'll go ahead and try to install AOO and reproduce the issue.
Security settings are:
Tools -> Options -> Security -> Macro Security...
It is not security problem. It is regression. Just I do not know Basic enough for create simplified testcase.
There is now a difference in the behaviour of NULL cells between AOO and LO, so Basic macros that test for that condition will not display the same result, or an error, depending on whether the macro is started from within AOO or LO. This is by design as I seem to recall, there have been other reports here on fdo BZ about the change in behaviour, but I think that they have all been dismissed.
DUP of bug 37860 ?
Yes it is the same.
In Motors sheet, column J (for example, not only here) you have =IF(H4;Power;"")
if H4 have the same kind of formula which returns an empty string (""), the formula above returns #VALUE!.
An option to considered empty string as 0 like in OOo is added in the 3.7 branch.
*** This bug has been marked as a duplicate of bug 37860 ***