Created attachment 96701 [details] 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
issue confirmed under Win7x64 using LibO 4.2.5.2 and 4.4.0.0.alpha0+ Build ID: b9dca968c6fd0ab5ca140c65b0e54d153cd34986 TinderBox: Win-x86@42, Branch:master, Time: 2014-07-18_22:51:20 I add Calc developer to CC list
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.