https://bugs.freedesktop.org/show_bug.cgi?id=66683
--- Comment #5 from Dominique Boutry <[email protected]> --- First of all : - Tools -> Cell Contents -> AutoCalculate (I agree with Gérard) - special care to the origin of date, especialy if Excel is involved (default day 0 is "30/12/1899" for LibO ; "00/01/1900" = "31/12/1899" for Excel 97) The wrong cells contain a datetime format on a large negative number (-41461,375) : - Excel 97 is also unable to process the case, - AOO4 process it correctly. With a positive number, Lib0 (4.1.2.3 on Win7) is OK. To see that : - Ctrl-m on B2 to see the underlying number (41461,375 = 06/07/2013 09:00:00) - modify B2 from "06/07/2013 09:00:00" to "09:00:00" (= 0,375) - the 3 cells BL41-42-43 now display correctly (values are from 0,42 to 0,46) - the application should be redesign to avoid computing an hour be sustracting two timestamp as different as 1900 and 2013 The choice of AOO to silently ignore the recomputing the cells because of the formatting, is very questionnable. Who knows the Ctrl+Shift+F9 ? How do one knows that AutoCalculate or F9 is short, on its own sheet ? BUG in may opinion -- 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
