In the dialog of Statistic > Sampling, the Output Range field only indicate the first selected cell and not the selected range. Using Version: 4.2.0.0.alpha0+ Build ID: 051731bbcaa79b6428c8ebee6c114c9b28220cc8 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2013-10-21_01:09:11 Sophie
Confirmed. New feature so I think it deserves some love on the 4.2 mab list
This is actually how it is meant to be - for output you select only the first cell as the actual output range depends on the sampling parameters (random: first cell + sample size, periodic: first cell + input size / period). The same is also true for every other statistics function. This is not ideal - suggestions how to improve this are welcome.
I thought the same but then when output can be over a range. I think either a) don't allow someone to select a range for output b) allow selecting a range and show this range in the dialog Having a person be able to highlight a range but then one value appears seems confusing
Well in solver you also have "target cell" where you also can select a range but only the first one is the target. Similar in "Multiple Operations" - Row input cell, Column input cell. Looks like you can't just select one cell - at least not with this input box. I will take a look if I can change this.
Add repro status to whiteboard
IMO this is not a bug. As Tomaz said it's working as expected. Since the size of the output range is fixed, and the user cannot specify as it depends on the characteristics of the input parameters, I don't see a point of allowing the user to select a range. The one thing I might suggest changing the wording from "Output Range" to something else that does not give the user an impression that he/she can select a range. Something like "Output Position", "Result to", "Result" etc may flow better? Pivot table, which also outputs a "range" uses "Result to" wording.
(In reply to comment #6) > IMO this is not a bug. As Tomaz said it's working as expected. Since the > size of the output range is fixed, and the user cannot specify as it depends > on the characteristics of the input parameters, I don't see a point of > allowing the user to select a range. > > The one thing I might suggest changing the wording from "Output Range" to > something else that does not give the user an impression that he/she can > select a range. Something like "Output Position", "Result to", "Result" etc > may flow better? Pivot table, which also outputs a "range" uses "Result to" > wording. Thanks Kohei for your input, I think using the same terminology than for Pivot table is good: Result to - And Tomaz thanks for your great work :) - Sophie
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6df78d1a4c9bf5e0e182d5cdc0a300e3c84e6d86 fdo#70989: Change wording from "Output Range" to "Results to". The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=bb4406c326315d3e1864f7dd9aaf286086ea0701&h=libreoffice-4-2 fdo#70989: Change wording from "Output Range" to "Results to". It will be available in LibreOffice 4.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Taking ownership.
I changed all the "Output Range" labels used in the new statistical analysis dialogs to "Results to". I call it fixed.