https://bugs.freedesktop.org/show_bug.cgi?id=87479
--- Comment #3 from aaker <markus.weyerm...@gmx.net> --- (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
