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