Created attachment 99704 [details] example spreadsheet with the 2 sheets - open Calc - enter numbers in sheet 1 - select the area - Data -> Statistics -> Descriptive statistics - now you need to select the position where the statistical formulas are stored - select the position in sheet 2 - click enter or OK - now text + formulas are entered in sheet 2 However the formulas should refer to sheet 1, however this is not done.
Thanks for reporting Luc, I confirm this. And see the problem in 4.2.0alpha1, the oldest version with the statistic functions that I have. Cheers, Cor
Taking it.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0ab538885d818a7b3706df48a625e2523a8ebbdf fdo#79174: Use 3D address when the input and output are on different sheets. 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-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=16e299afa4051affc357fe7990d7632b37c6aea7&h=libreoffice-4-3 fdo#79174: Use 3D address when the input and output are on different sheets. It will be available in LibreOffice 4.3. 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.
4.2 backport: https://gerrit.libreoffice.org/9578
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=bdf33526442f4a601e6d2a80a4ec3c690b12c3fa&h=libreoffice-4-2 fdo#79174: Use 3D address when the input and output are on different sheets. It will be available in LibreOffice 4.2.6. 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.
Fixed in 4.2.