https://bugs.documentfoundation.org/show_bug.cgi?id=86097
--- Comment #6 from Michael Meeks <[email protected]> --- Hard refresh works for me loading the excel file. At least I see this problem in 4.1 as in master. The problem is that this is not really an XLS file - it's an Excel 2003 XML thing: <?xml version='1.0' encoding='UTF-8'?><?mso-application progid='Excel.Sheet'?><Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"; xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel"> <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office"> More amusingly the file contains: <Row ss:AutoFitHeight="0" ss:Height="16.5"> <Cell ss:StyleID="s46"> <Data ss:Type="String">VERKAUFSBERICHT</Data> </Cell> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:StyleID="s47"/> <Cell ss:Formula="=IF(ISERROR(SUM(SA_Amount)),0,SUM(SA_Amount))" ss:StyleID="s48"> <Data ss:Type="Number">4.5</Data> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ :-) <NamedCell ss:Name="SALES"/> <TotalPaymentsKey>SA</TotalPaymentsKey> </Cell> ie. that cell has the data "4.5" inside it. To be sure, Microsoft Excel doesn't appear to trust that data, or even show it - but re-calculates it on-load; but we (it seems) do. So - Thomas - where did you get this file ? ;-) Of course ctrl-alt-F9 forces a nice re-calc that works well. Failing that - we can add a feature to clobber re-calc mode to force it on for these files; since we load via XSLT (IIRC) it is deadly slow anyway so no real perf. loss I suppose [ unless I'm confused wrt. the format ]. Thanks. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
