| Summary: | VIEWING: Calculation does'n work or viewing not update correctly | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Jukka Tienhaara <jukka.tienhaara> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | gerard.fargeot, jbfaure, miguelangelrv |
| Priority: | medium | ||
| Version: | 4.0.2.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
The file were is that bug
Picture of situation |
||
Created attachment 82169 [details]
Picture of situation
(In reply to comment #0) > When copying formula to the other cell the formula dosn't work or view not > updated. Just because "Autocalculate" is turned off in Tools > Cells content. Not a bug. Yes in this version of document. But when I turned on again nothin happen?!?!?! Updating does't work. Tools - Cell Contents - AutoCalculate And also pressing F9 - Recalculate doesn't work. Hi Jukka, some formulas need hard calc Ctrl+Shif+F9 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 Sorry, "...The choice of LibO..." above, not "...The choice of AOO..." I do not reproduce with LibreOffice 4.1.4.0.0+ under Ubuntu 13.10 x86-64: I removed the content of cells BL41:BL43 I turned on automatic calculation, then copied cell BL39 in BL41:BL43 ==> the content of BL41:BL43 is filled with new values, different from the content of BL39. So it work as expected. @Jukka: please, could you upgrade your LibreOffice installation the current stable version (ATM: 4.1.3) and try again? To copy the formula you need to proceed as follows: select the cell B39 then hit ctrl+C then select cells BL41:BL43 and hit ctrl+V If you select and copy the formula itself (selcted inside the cell) it will not work as expected because the formula will not be adapted to the new cell. I close the bug report as WorksForMe. Please feel free to set back the status to UNCONFIRMED if you still encounter the same problem after having upgraded to the current stable version. Best regards. JBF |
Created attachment 82168 [details] The file were is that bug When copying formula to the other cell the formula dosn't work or view not updated. The file in attachment The formula from BL39 has been copy to BL41-43. Operating System: Ubuntu Version: 4.0.2.2 release