[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 Beluga changed: What|Removed |Added Status|NEEDINFO|RESOLVED CC||todven...@suomi24.fi Resolution|--- |WORKSFORME --- Comment #7 from Beluga --- (In reply to Nathael Pajani from comment #6) > Hi, > > Here are example steps : > > 1: Open File > 2: Move to sheet 'Compte ED3L' (If not openned by default) > 3: Insert "45" in cell E35 > 4: Cell H3 should have been updated For me, it updates immediately and requires no tricks. Closing as WFM. If original reporter objects, they can change to UNCONFIRMED. Tested on three different versions: Win 7 64-bit Version: 4.5.0.0.alpha0+ Build ID: 772befa08f02b08da1ab493896a0744bc73781c7 TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-23_22:39:02 Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+ Build ID: 772befa08f02b08da1ab493896a0744bc73781c7 TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-23_23:25:11 and Version: 4.3.3.2 Build ID: 430m0(Build:2) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 --- Comment #6 from Nathael Pajani --- Hi, Here are example steps : 1: Open File 2: Move to sheet 'Compte ED3L' (If not openned by default) 3: Insert "45" in cell E35 4: Cell H3 should have been updated 5: Press F9 : Still no update (Default shortcut for re-computing cells content) Formula in cell H3 is "=Bilan.D57" 6: Copy formula given above to cell H9 : OK 7: Copy formula from cell H3 to cell H10 : Cell H10 is OK but cell H3 still not OK 8: Move to sheet 'Mars' 9: Insert "45" in cell F22 8: Move to sheet 'Compte ED3L' : Content of cell H3 has been updated with correct value. So long as no other sheet is modified the value in 'Compte ED3L'.H3 is not updated. Thanks -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 Joel Madero changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||jmadero@gmail.com Ever confirmed|0 |1 --- Comment #5 from Joel Madero --- Sorry it's really hard to follow this bug report - can you please give just simple reproducible steps that we can do with the file that you attached. Enumerated always helps: 1. Open file 2. blah blah etc . . .. Easier to follow bugs this way than to read through paragraphs of explanation. Marking as NEEDINFO - once clear reproducible steps are provided please mark as UNCONFIRMED. Also - can you check with 4.2.2.3 as there was a fix for bug 74014 that may have corrected this one -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 m.a.riosv changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 --- Comment #4 from Nathael Pajani --- Hi ! Yes, adding two '=' signs solves the problem too. But I'm not asking for workarounds, I'm reporting a bug, which I think should be fixed (or the use of the single '=' should be deactivated, or the "automatic" or forced re-calculation should be fixed.) I attached the file to the original report, so you can test too. Thanks for this other tip anyway. +++ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 --- Comment #3 from m.a.riosv --- Please try if double equal (==) instead one equal (=) at the beginning of the not recalculated cell solves the issue. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 --- Comment #2 from Nathael Pajani --- Hi, Hard recalc (Shift+Ctrl+F9) does the job, but this is still a bug from my point of view. The user is used to values being updated after every modification, and may take decisions based on the values displayed in the cells (such as moving money from one account to another, paying/buying something ... while they don't have the money). That's not what happened to me, but this or similar situations may happen and will make people angry after LibreOffice :( Thanks for the tip though :) +++ -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||mari...@miguelangel.mobi Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- Hi Nathael, thanks for reporting. Try with a hard recalc Shift+Ctrl+F9 https://help.libreoffice.org/Calc/Recalculate -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 76431] EDITING: computed cells content not refreshed when changing source values
https://bugs.freedesktop.org/show_bug.cgi?id=76431 Nathael Pajani changed: What|Removed |Added Hardware|Other |x86-64 (AMD64) -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs