Bug 80497

Summary: Other: Calculations doesn't work.
Product: LibreOffice Reporter: hisham.o1400
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEEDINFO --- QA Contact:
Severity: normal    
Priority: medium CC: hisham.o1400, raal
Version: 4.2.4.2 release   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
i915 platform: i915 features:

Description hisham.o1400 2014-06-24 20:17:41 UTC 
Problem description: 
Regarding this spreadsheet;
https://drive.google.com/folderview?id=0B2_BBw2VMf2-VUJZNXVTM0M1akE&usp=sharing
The sheet works fine on excel but not on libreoffice. I've enable macros on libreoffice but no hope.

Steps to reproduce:
1. download the sheet, 
2. input some values in the 1st sheet
3. It should show numbers in the others sheets, but it just give errors.

Current behavior:
Calcuations doesn't work on libreoffice even if I save the document in ods format. It works fine on Microsoft excel.

Expected behavior:
It should work as it works on excel.

              
Operating System: Linux (Other)
Version: 4.2.4.2 release
Comment 1 raal 2014-09-08 17:27:21 UTC 
Hello,
your spreadsheet is complex. Please could you provide simple version or upload file with filled values?
I tried to fill random number on first sheet in excel and I have lots of errors on second sheet - #value, # division zero ...
Specify cell where is error.
Thank you

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.