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