https://bugs.freedesktop.org/show_bug.cgi?id=81757
--- Comment #4 from Ryszard <ry...@iname.com> --- I have attached zip file with 2 versions of this spreadsheet also with shown columns containing K factors used to calculate bend allowance in sheet metal fabricating, one older with less formulas that seems to works correctly even in 4.2.5.2 version of Libreoffice. The newer file contains more formulas that allow enter dimensions of the part and get size of flat layout (cells E20:E28, and F28). There are also formulas that allow me to find K factor that I'm using in SolidWorks to change flat layout for parts given by customers with different radii that we are using to manufacture these parts (cells J12:J14 and N13, N14, O13) At this moment I found something wrong in calculation of cells I8 that it should be equal to I4*F8 and automatically F28 that is using I8. How it should work. Based on bend type (drop down box), thickness of the material radius of bend and bend angle, macro function is calculating value of cell F7(bend allowance), this value is used to calculate F8, up to this everything is fine. Now the I4 cell holds number of bends in part (at this moment 1), based on that the cells I7, I8 should be equal to bend allowance and bend deduction for part. Since there is only one bend the values of I7 should be same as F7 (and is), value of I8 should be same as F7. It is when you open the file, but if you change item in drop down box the value of cell F8 will change, but cell I8 will not. If you select another item in the drop down box, the value of I7 cell will be the previous value of F8. To get correct answer you will have to select item from drop down box twice, or reenter same value to the one of cells. The more strange thing will happen if you will change the radius value let say from 0.010 (value on file open) to 0.0285 (I have used that), somehow the cell I8 shows 0.1222 that I can not relate to anything in the spread sheet. Entering again 0.0285 to the radius will make calculations correct. -- 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