Bug 148727 - Help text is incomplete for cell range examples, e.g. for SUM, PRODUCT etc.
Summary: Help text is incomplete for cell range examples, e.g. for SUM, PRODUCT etc.
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
7.4.0.0 alpha0+
Hardware: All All
: medium normal
Assignee: BogdanB
URL:
Whiteboard: target:7.5.0 target:7.4.6
Keywords:
Depends on:
Blocks:
 
Reported: 2022-04-22 15:05 UTC by Xisco Faulí
Modified: 2023-01-24 10:36 UTC (History)
3 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 Xisco Faulí 2022-04-22 15:05:15 UTC
Extracted from https://gerrit.libreoffice.org/c/core/+/133091

Instead of:
"Example: SUM <A2:C2> displays the sum of the values in cells A2 to C2"

the text is messed up this way:

"Example: SUM displays the sum of the values in cells A2 to C2"

(at least on the web: https://help.libreoffice.org/7.4/en-US/text/swriter/02/14020000.html?DbPAR=WRITER#bm_id3149687).
Comment 1 László Németh 2022-04-22 16:12:47 UTC
@Xisco: thanks for the report.
Comment 2 Olivier Hallot 2022-11-09 20:49:21 UTC
This is a regression.

on release 7.3 the page is correct (WRT < and > entities)

https://help.libreoffice.org/7.3/en-US/text/swriter/02/14020000.html?DbPAR=WRITER#bm_id3149687

The issue raised in a change in online_transform.xsl from 7.3 to 7.4.
Comment 3 Olivier Hallot 2022-11-09 20:52:40 UTC
Ugly workaround on the same issue
https://git.libreoffice.org/help/+/dfa442b3d862539a7b10af5281a080acaef7e73d%5E%21/
Comment 4 BogdanB 2022-11-09 20:56:27 UTC
Olivier, in my commit I tried to fix some decimals, and so on, many small things. If you can review it... if not, we can consider this bug a duplicate.
Comment 5 BogdanB 2022-11-10 12:29:39 UTC
Xisco, I remove dots from the examples, and I inserted where was missing in the definitions. To be a consequent help page.
Comment 6 BogdanB 2022-11-10 20:23:44 UTC
Olivier, 2 hours after your update on the regression on help (https://gerrit.libreoffice.org/c/help/+/142555) and the help online is not working well.

At adition example in the first table I see 
Example: + 8

Instead of
Example: <A1> + 8 

https://help.libreoffice.org/latest/en-US/text/swriter/02/14020000.html?DbPAR=WRITER#bm_id3149687
Comment 7 Commit Notification 2022-11-11 10:13:45 UTC
Bogdan B committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/help/commit/ff13d5c7d7014dde45a7712d96596accdb2209e1

tdf#148727 Correct sum example
Comment 8 BogdanB 2022-11-14 04:57:02 UTC
Still not working.

2 possible reasons:
- character for less then should be something else then &lt; and character for greater then should be something else then &gt;
- we still have the regression affecting Help
Comment 9 BogdanB 2022-11-14 18:54:19 UTC
Working well in Help 7.5
https://help.libreoffice.org/7.5/en-US/text/swriter/02/14020000.html?DbPAR=WRITER#bm_id3149687

Bad in latest Help
https://help.libreoffice.org/7.4/en-US/text/swriter/02/14020000.html?DbPAR=WRITER#bm_id3149687

Users are using 7.4, so consider to keep this bug open until 7.4 gets an update similar to 7.5.
Comment 10 Olivier Hallot 2023-01-02 16:28:45 UTC
Patch sent to 7-4 branch

https://gerrit.libreoffice.org/c/help/+/144912
Comment 11 BogdanB 2023-01-02 21:23:12 UTC
Both 7.4 and 7.5 looks good now.
Comment 12 Commit Notification 2023-01-04 08:13:09 UTC
Olivier Hallot committed a patch related to this issue.
It has been pushed to "libreoffice-7-4":

https://git.libreoffice.org/help/commit/a4310b27a37912daa02a104bcd8f834f9be66e13

tdf#148727, fix escaped characters
Comment 13 BogdanB 2023-01-05 16:04:24 UTC
Links from comment 9 work well.
Comment 14 Xisco Faulí 2023-01-24 10:36:14 UTC
7.4.5 was a hotfix release, updating target in status-whiteboard