https://bugs.freedesktop.org/show_bug.cgi?id=74538
--- Comment #1 from Dominique Boutry <[email protected]> --- Hi. When studying your worksheet under LiBO 4.2.0.4 on Win7, I noticed number of #values! that don't appear in Excel 97. By working up along formulas with such #values! content, I reached tab "Physical transport" cells HG9:HP9, where : - HH9 is empty in LibO (filled with an expression evaluating to value 3,37E+04 in Excel 97), - HP9 evaluates wrongly the formula =IF(HG9="","",HG9-HH9) to #values! Two other issues : - There is an external file linked to your spreadsheet, that we don't have; trouble ? - the hyperlinks in "Tier 2 Input" tab A31:A34 contain a cell reference (B54, B3, B82, B101) which point to merged cells; there is no such thing in Excel. When I see : - the large size of this application, - the word "random" in the above description, - the probable recalculate on loading (because of the Office 97 format, not 2007) I can not help thinking of a multi-thread synchronisation error (a decision that recalculation is over whereas it isn't). -- 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
