Bug 164039 - [Request] "Tip of the day 8/225" sample formula to match the figure
Summary: [Request] "Tip of the day 8/225" sample formula to match the figure
Status: ASSIGNED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
24.8.3.2 release
Hardware: All All
: medium normal
Assignee: BogdanB
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Tip-Of-The-Day
  Show dependency treegraph
 
Reported: 2024-11-25 09:01 UTC by nobu
Modified: 2024-11-26 14:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nobu 2024-11-25 09:01:57 UTC
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.
Comment 1 BogdanB 2024-11-25 19:32:22 UTC
Change is in gerrit waiting for review.
https://gerrit.libreoffice.org/c/core/+/177298