Description: "Tip of the day 8/225" sample formula to match the figure. Steps to Reproduce: 1. Show Tip of the day. 2. Display tips for summing cell ranges on multiple sheets. In many environments it may be the eighth Tip. Code is https://git.libreoffice.org/core/+/master/cui/inc/tipoftheday.hrc#61 https://opengrok.libreoffice.org/xref/core/cui/inc/tipoftheday.hrc?r=dcea29c2#61 Want to sum a cell through several sheets? Refer to the range of sheets e.g. =SUM(Sheet1.A1:Sheet3.A1). The attached figure is "sum_sheets.png". https://opengrok.libreoffice.org/xref/core/extras/source/tipoftheday/sum_sheets.png?r=c6569b4d Actual Results: 3. The attached figure does not match the sample formula. Expected Results: 3. For simple formulas, it would be better to match the figure. Reproducible: Always User Profile Reset: No Additional Info: If the formula is to be changed, it should look like =SUM(Sheet1.A1:Sheet3.A1) -> =SUM(Sheet1.A1:Sheet2.A3) to match the attached diagram.
Change is in gerrit waiting for review. https://gerrit.libreoffice.org/c/core/+/177298
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/e03a50fb6443fa7da4209ebb981f1c1329aba966 tdf#164039: Improve tip of the day It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
=SUM(Sheet1.A1:Sheet2.A1) -> =SUM(Sheet1.A1:Sheet2.A3) ^^^^
Another change is in gerrit waiting for review. https://gerrit.libreoffice.org/c/core/+/178249
Bogdan Buzea committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/8a1da033c7e1f6c23b502b8f86de1e6e101a57eb tdf#164039: Improve tip of the day (II) It will be available in 25.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Thank you.
Bogdan Buzea committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/7094444732a818bc0127f2baffe002dd3bcf8ece tdf#164039: Improve tip of the day It will be available in 25.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Bogdan Buzea committed a patch related to this issue. It has been pushed to "libreoffice-25-2": https://git.libreoffice.org/core/commit/c4e9732d9b0acabe54fa35140afa65d330b4726d tdf#164039: Improve tip of the day (II) It will be available in 25.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.