https://bugs.documentfoundation.org/show_bug.cgi?id=95156
--- Comment #4 from David <[email protected]> --- (In reply to Oliver Brinzing from comment #3) > some remarks: > > - the spreadsheet uses special iteration settings for calulation: > > <table:calculation-settings> > <table:iteration table:status="enable" > table:steps="1000" > table:maximum-difference="0.0001"/> > </table:calculation-settings> > > if have another (confidential) spreadsheet with same issue. it also uses > iterations. > so maybe the root cause is the use of iterations? > > - aoo 4.1.1 has same problem > > - saving as *.xls and calculate with excel 2010 works for me. Yes, I tried both automatic and setting iterations. However, it didn't make any difference. Please set back to automatic and try it and you should still be able to verify the problem persists. The reason I tried that option was because I thought setting the options manually may improve iterative cycles to finish the complex calculations dependant on each other. Yes, I never have this issue in Excel. However, I believe in OS and hopefully this product can be made to compete. Some day I hope to have enough money to help support this effort. I am not alone in working with data in complex ways. That tool is unique and informative for predictions. I am not a programmer, but I do SAS analytics as well as SQL. Thank you! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
