Created attachment 111029 [details] formula issue Can you help me the issue attached. Attached is the ods sheet Steps to reproduce: *Open the file *Go to sheet FG Capacity *The sheet has all linked formulaes *The problem where values are not getting updated is at column=AD(=AC*M4) *Column C is the input column- for example if we enter value in C column it should auto refresh all the formulas. *Weired thing is except columnAD all the values(cell values) are getting auto refreshed. Steps Tried: * File is in ODS format * Sheet does not have any external link * this particular sheet is created in Libre calc * Recalculate and auto recalculate not work * Hard Recalculate ctrl+shft+f9 also does not work * Deleted and readded the sheet does not work * Deleted/inserted column does not work Please advice. Regards, SriJanani
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.
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
(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"
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.