https://bugs.freedesktop.org/show_bug.cgi?id=76891
Priority: medium
Bug ID: 76891
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: LibreOffice formula and chart issues when importing
Excel 2003 spreadsheet
Severity: normal
Classification: Unclassified
OS: All
Reporter: moosespirit2001-openoff...@yahoo.com.au
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Libreoffice
Product: LibreOffice
Created attachment 96701
--> https://bugs.freedesktop.org/attachment.cgi?id=96701&action=edit
Screen shots and Excel spreadsheet
I have imported an Excel spreadsheet into LibreOffice. The spreadsheet
contains a few worksheets and and formulas summarising and totalling the data
from the various sheets into the main sheet. The main sheet also contains a
bunch of charts.
The software I am using are:
* Excel 2003 (v11.8404.8405) SP3:
* LibreOffice v4.1.3.2
*** Graph / Chart Issues:
* LibreOffice formatting issues - lots of thick vertical lines added to graph
(already changed these to thin 0.01cm dashed lines in the screen shot), tick
mark settings ignored, trend function formula moved, etc.
* LibreOffice has deleted my secondary trend line (level 5 quadratic trend line
has been deleted).
*** Formulas NOT working / NOT returning correct values:
* LibreOffice: from Nov-2007 onwards, ALL formulas are returning incorrect
values.
Here are the formulas from Excel and LibreOffice for one cell: 2008-Jan:
Excel 2003 (v11.8404.8405) SP3:
=IF((SUMIF('Occupancy by
Month'!$A:$A,CONCATENATE(">=1-",C$2,"-",$B8),'Occupancy by Month'!$R:$R) -
SUMIF('Occupancy by Month'!$A:$A,CONCATENATE(">=1-",D$2,"-",$B8),'Occupancy by
Month'!$R:$R)) / C$1 = 0, "-", (SUMIF('Occupancy by
Month'!$A:$A,CONCATENATE(">=1-",C$2,"-",$B8),'Occupancy by Month'!$R:$R) -
SUMIF('Occupancy by Month'!$A:$A,CONCATENATE(">=1-",D$2,"-",$B8),'Occupancy by
Month'!$R:$R)) / C$1)
LibreOffice v4.1.3.2
=IF((SUMIF($'Occupancy by
Month'.$A$1:$A$1048576,CONCATENATE(">=1-",C$2,"-",$B8),$'Occupancy by
Month'.$R$1:$R$1048576)-SUMIF($'Occupancy by
Month'.$A$1:$A$1048576,CONCATENATE(">=1-",D$2,"-",$B8),$'Occupancy by
Month'.$R$1:$R$1048576))/C$1=0,"-",(SUMIF($'Occupancy by
Month'.$A$1:$A$1048576,CONCATENATE(">=1-",C$2,"-",$B8),$'Occupancy by
Month'.$R$1:$R$1048576)-SUMIF($'Occupancy by
Month'.$A$1:$A$1048576,CONCATENATE(">=1-",D$2,"-",$B8),$'Occupancy by
Month'.$R$1:$R$1048576))/C$1)
Attached is a ZIP file containing screen shots and the Excel spreadsheet. I
have drawn red boxes around the values and chart areas that are wrong / have
issues in LibreOffice screen shot.
Hope you can fix this.
Moose
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
