Download it now!
Bug 42756 - : formulas in LibreOffice calc don't behave like OpenOffice cal
Summary: : formulas in LibreOffice calc don't behave like OpenOffice cal
Status: RESOLVED DUPLICATE of bug 37860
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.3.4 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Reported: 2011-11-09 12:09 UTC by franky.chambers
Modified: 2012-10-04 09:38 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

SpreadSheet for calcuation of differents parameter of Electric Vehicles (525.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-11-09 12:09 UTC, franky.chambers

Note You need to log in before you can comment on or make changes to this bug.
Description franky.chambers 2011-11-09 12:09:29 UTC
Created attachment 53345 [details]
SpreadSheet for calcuation of differents parameter of Electric Vehicles

Problem description: 
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.

Current behavior:
Lot of cells in sheet "Tables" have error code : "type de donnée incorrect"

Expected behavior:
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
Comment 1 sasha.libreoffice 2012-04-20 05:46:32 UTC
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.
Comment 2 Joel Madero 2012-10-03 16:46:18 UTC
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...
Comment 3 sasha.libreoffice 2012-10-04 05:47:32 UTC
It is not security problem. It is regression. Just I do not know Basic enough for create simplified testcase.
Comment 4 Alex Thurgood 2012-10-04 09:14:00 UTC

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.

Comment 5 Alex Thurgood 2012-10-04 09:17:10 UTC
DUP of bug 37860 ?

Comment 6 GerardF 2012-10-04 09:38:08 UTC
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 ***