[Libreoffice-bugs] [Bug 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=87479 m.a.riosv changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |INVALID -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=87479 --- Comment #5 from m.a.riosv --- Please @SriJanani, is the issue solved? -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.documentfoundation.org/show_bug.cgi?id=87479 --- Comment #4 from QA Administrators --- Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team This NEEDINFO message was generated on: 2015-07-18 -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.freedesktop.org/show_bug.cgi?id=87479 --- Comment #3 from aaker --- (In reply to aaker from comment #2) > SriJanani > > I assume your formula in "AD" is working as expected. Substituting al the > refs by the appropriate values, you will get > "=O4/C4*20*(((C4*(1+E4))*(1+H4))*(1+K4))/20". > Multiplying and subsequent dividing by 20 cancels out: > "=O4/C4*(((C4*(1+E4))*(1+H4))*(1+K4))" > Normalizing with the brackets you will get > "=O4/C4*C4*(1+E4)*(1+H4)*(1+K4)" > Once more dividing and subsequent multiplying by "C4" cancels out. > So changing the value in "C4" will change nothing to the result of your > formula in "AD4". > > cheers > Markus Verify proper calculation of formula by changing value in "O4" -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.freedesktop.org/show_bug.cgi?id=87479 aaker changed: What|Removed |Added CC||markus.weyerm...@gmx.net --- Comment #2 from aaker --- SriJanani I assume your formula in "AD" is working as expected. Substituting al the refs by the appropriate values, you will get "=O4/C4*20*(((C4*(1+E4))*(1+H4))*(1+K4))/20". Multiplying and subsequent dividing by 20 cancels out: "=O4/C4*(((C4*(1+E4))*(1+H4))*(1+K4))" Normalizing with the brackets you will get "=O4/C4*C4*(1+E4)*(1+H4)*(1+K4)" Once more dividing and subsequent multiplying by "C4" cancels out. So changing the value in "C4" will change nothing to the result of your formula in "AD4". cheers Markus -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.freedesktop.org/show_bug.cgi?id=87479 m.a.riosv changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||mari...@miguelangel.mobi Ever confirmed|0 |1 --- Comment #1 from m.a.riosv --- Hello SriJanani, Thank you for reporting the bug. To be certain the reported issue is not related to corruption in the user profile, could you rename this LibreOffice user directory ( see https://wiki.documentfoundation.org/UserProfile#Default_location or http://ask.libreoffice.org/en/question/903/where-are-the-libreoffice-data-profile-files/ ) and re-test? I think works fine for me. if I put 250 in C4, AC4 change to 9. Cells have rounded format so is necessary change in the input cell value enough to change the result. -- 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 87479] Formula not getting calculated in libre office 4.3.4.1
https://bugs.freedesktop.org/show_bug.cgi?id=87479 m.a.riosv changed: What|Removed |Added Attachment #111029|text/plain |application/vnd.oasis.opend mime type||ocument.spreadsheet -- 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