Bug 148099

Summary:	"Define Range" / "Define Database Range" help page is duplicated
Product:	LibreOffice	Reporter:	Stéphane Guillou (stragu) <stephane.guillou>
Component:	Documentation	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, olivier.hallot
Priority:	medium
Version:	6.0.0.3 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Stéphane Guillou (stragu) 2022-03-20 19:45:15 UTC

Description:
The two following pages describe the same functionality:

1. https://help.libreoffice.org/7.3/en-GB/text/scalc/guide/database_define.html
2. https://help.libreoffice.org/7.3/en-GB/text/scalc/01/12010000.html

In LO 7.0 and 7.3, going to "Data > Define Range..." and clicking the "Help" button leads to page (2). However, page (1) is linked in the "Contents" menu on the right hand side of the documentation website, whereas (2) is not.

I think page (1) should be deleted (with content transferred to the other if needed) and page (2) should be linked in the Contents menu in place of page (1).

Steps to Reproduce:
1. Look for help on Calc's "Define Range" functionality

Actual Results:
2 different pages on the same topic

Expected Results:
1 single page


Reproducible: Always


User Profile Reset: No



Additional Info:
It seems both pages have existed at least as far back as LibreOffice 6.0:

1. https://help.libreoffice.org/6.0/en-GB/text/scalc/guide/database_define.html
2. https://help.libreoffice.org/6.0/en-GB/text/scalc/01/12010000.html

Comment 1 BogdanB 2022-11-06 19:08:54 UTC

Olivier, I found that the first link (database_define) is used in less places than (12010000). So, I thinks we should be carefull with removing one of them, until one of them will be a full copy of the deleted one.

--------------------------------------------------
git grep 'database_define'
AllLangHelp_scalc.mk:    helpcontent2/source/text/scalc/guide/database_define \
source/auxiliary/scalc.tree:      <topic id="scalc/text/scalc/guide/database_define.xhp">Defining Database Ranges</topic>
source/text/scalc/guide/database_define.xhp:      <topic id="textscalcguidedatabase_definexml" indexer="include" status="PUBLISH">
source/text/scalc/guide/database_define.xhp:         <filename>/text/scalc/guide/database_define.xhp</filename>
source/text/scalc/guide/database_define.xhp:<paragraph xml-lang="en-US" id="hd_id3154758" role="heading" level="1"><variable id="database_define"><link href="text/scalc/guide/database_define.xhp" name="Defining Database Ranges">Defining a Database Range</link>
source/text/scalc/guide/database_filter.xhp:         <embed href="text/scalc/guide/database_define.xhp#database_define"/>
source/text/scalc/guide/database_sort.xhp:         <embed href="text/scalc/guide/database_define.xhp#database_define"/>
source/text/scalc/guide/main.xhp:<embed href="text/scalc/guide/database_define.xhp#database_define"/>
--------------------------------------------------
git grep '12010000'
AllLangHelp_scalc.mk:    helpcontent2/source/text/scalc/01/12010000 \
AllLangHelp_shared.mk:    helpcontent2/source/text/shared/02/12010000 \
helpers/unocmds.txt:.uno:DefineDBName;scalc/01/12010000.xhp
source/text/scalc/01/12010000.xhp:<topic id="textscalc0112010000xml" indexer="include">
source/text/scalc/01/12010000.xhp:<filename>/text/scalc/01/12010000.xhp</filename>
source/text/scalc/01/12010000.xhp:<h1 id="hd_id3157909"><link href="text/scalc/01/12010000.xhp" name="Define Database Range">Define Range</link></h1>
source/text/scalc/01/12020000.xhp:<paragraph role="paragraph" id="par_id3149655" xml-lang="en-US"><variable id="bereichwaehlen"><ahelp hid=".uno:SelectDB">Selects a database range that you defined under <link href="text/scalc/01/12010000.xhp" name="Data - Define Range">Data - Define Range</link>.</ahelp></variable></paragraph>
source/text/scalc/01/12030200.xhp:<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sortoptionspage/outarealb"> Select a named <link href="text/scalc/01/12010000.xhp" name="cell range"> cell range</link> where you want to display the sorted list.</ahelp></paragraph>
source/text/scalc/main0112.xhp:  <embed href="text/shared/02/12010000.xhp#sortascending"/>
source/text/scalc/main0112.xhp:  <embed href="text/scalc/01/12010000.xhp#defineDBrangeheader"/>
source/text/shared/02/01170203.xhp:<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US">The appropriate icons on the <link href="text/shared/main0213.xhp" name="Form Navigation Bar"><emph>Form Navigation</emph> Bar</link> can be used in User mode to sort: <link href="text/shared/02/12010000.xhp" name="Sort Ascending"><emph>Sort Ascending</emph></link>, <link href="text/shared/02/12020000.xhp" name="Sort Descending"><emph>Sort Descending</emph></link>, <link href="text/shared/02/12100100.xhp" name="Sort"><emph>Sort</emph></link>.</paragraph>
source/text/shared/02/12010000.xhp:<topic id="textshared0212010000xml" indexer="include" status="PUBLISH">
source/text/shared/02/12010000.xhp:<filename>/text/shared/02/12010000.xhp</filename>
source/text/shared/02/12010000.xhp:<h1 id="hd_id3152594"><link href="text/shared/02/12010000.xhp" name="Sort Ascending">Sort Ascending</link></h1>
source/text/shared/02/12020000.xhp:<embed href="text/shared/02/12010000.xhp#selektionsortieren"/>
source/text/shared/02/12020000.xhp:<embed href="text/shared/02/12010000.xhp#dialogsortieren"/>
source/text/shared/02/12100100.xhp:<paragraph role="paragraph" id="par_id3149549" xml-lang="en-US">While the functions <link href="text/shared/02/12010000.xhp" name="Sort in Ascending Order"><emph>Sort in Ascending Order</emph></link> and <link href="text/shared/02/12020000.xhp" name="Sort in Descending Order"><emph>Sort in Descending Order</emph></link> sort by one criterion only, you can combine several criteria in the <emph>Sort Order</emph> dialog.</paragraph>
source/text/shared/main0212.xhp:      <embed href="text/shared/02/12010000.xhp#sortascending"/>
source/text/shared/main0213.xhp:    <embed href="text/shared/02/12010000.xhp#sortascending"/>
--------------------------------------------------