To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=34093
------- Additional comments from [EMAIL PROTECTED] Fri Jul 14 11:38:53 -0700 2006 ------- @bm hmm, I did not realise this was a cloning issue. I recognise the idea of maximising compatability of import filters but I would have hoped that rather than being a partial clone of a not-too-recent MSO, things like this would be where OpenOffice could distinguish itself as a superior product. The other problem with copying MSO is that users will expect the _same_ false results or else they will complain the OpenOffice does not work correctly, so you will need to guess how they force the false zero. There seem to be too different senarios: the import filter and if/how to add this functionality to Calc UI. In the case of the import filter the idea of a dlg is good. I would favour quite explicit warning that this is included for compatability only and will produce an invalid fit and incorrect slope. Preferably with a help button taking them to some text that explains the limitations of lin.regression and the implications of cheating the fit. Once aware of the choice the user can decide what to do. As a feature for Calc UI, I think ANY attempt at lin. regression should post a warning as to the limitations of the method that will be used and a link to more info (I see that as the duty of the program since the user cannot know how it is done and will assume in good faith that the methodology is valid). @matthias >>Adding a line by hand is not a solution at all, since the whole "idea" of the feature is, that the slope is calculated from the data. That's just the problem, calculating a slope that comes out WROMG is not calculating from the data but gives the impression it is. It's worse than having to do a fit by eye because it has a undue bona fide of having been calculated by a computer. Maybe it would make more sence to provide an easy means to fit a line by eye that will follow any resizing etc. in the same way as an applied regression formula apparently does and then show the formula. I'm thinking of the way that gimp or blender let you create a line or bezier curve and pull it around until it fits. At least for the linear case this would be easy to program. Link it to the chart so that is scales and moves with it. This will allow those interested in bending the truth to fit thier data to do what they need to do and also allow a valid means of fitting a line to data that do not fit the criteria for applying least squares analysis. I'm not suggesting we make the use get out pen and paper here. The human brain is much better at seeing the "best fit" than an incorrectly applied bit of maths. I cannot even imagine the ammount of innocently derived yet spurious "scientific results" caused by inappropriate use of linear regression. One major cause of this (appart from the quality of science education) is spreadsheet software that makes it as easy as clicking a button. I think OpenOffice has a chance to innovate rather than follow here. Thanks for your interest in my comments. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]