AllLangHelp_sdatabase.mk | 2 + AllLangHelp_shared.mk | 2 - source/text/scalc/01/04060183.xhp | 12 +++--- source/text/sdatabase/05000000.xhp | 2 - source/text/sdatabase/05010000.xhp | 45 +++++++++++--------------- source/text/sdatabase/05010100.xhp | 35 ++++++++------------ source/text/shared/guide/data_tabledefine.xhp | 10 ++--- source/text/shared/guide/database_main.xhp | 19 ++++------ 8 files changed, 57 insertions(+), 70 deletions(-)
New commits: commit 5fd683cd1c13cc20d0c7205c895b4e5ca1c39196 Author: Olivier Hallot <[email protected]> AuthorDate: Sun Jan 31 14:10:55 2021 -0300 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Jan 31 21:57:58 2021 +0100 Refactor some database pages Place in sdatabase/ folder Change-Id: Ia787f7634755be2fd4936914cacecded5bee4221 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110208 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/AllLangHelp_sdatabase.mk b/AllLangHelp_sdatabase.mk index 591591974..b40a21138 100644 --- a/AllLangHelp_sdatabase.mk +++ b/AllLangHelp_sdatabase.mk @@ -26,6 +26,8 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sdatabase,\ helpcontent2/source/text/sdatabase/05000000 \ helpcontent2/source/text/sdatabase/05000001 \ helpcontent2/source/text/sdatabase/05000003 \ + helpcontent2/source/text/sdatabase/05010000 \ + helpcontent2/source/text/sdatabase/05010100 \ helpcontent2/source/text/sdatabase/toolbars \ )) diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index 5cf886e06..f29c946fd 100644 --- a/AllLangHelp_shared.mk +++ b/AllLangHelp_shared.mk @@ -861,8 +861,6 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ )) $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ - helpcontent2/source/text/shared/explorer/database/05010000 \ - helpcontent2/source/text/shared/explorer/database/05010100 \ helpcontent2/source/text/shared/explorer/database/05020000 \ helpcontent2/source/text/shared/explorer/database/05020100 \ helpcontent2/source/text/shared/explorer/database/05030000 \ diff --git a/source/text/sdatabase/05000000.xhp b/source/text/sdatabase/05000000.xhp index f542990b7..a68f9ee4b 100644 --- a/source/text/sdatabase/05000000.xhp +++ b/source/text/sdatabase/05000000.xhp @@ -32,7 +32,7 @@ <paragraph role="paragraph" id="par_id3147102" xml-lang="en-US">Table data edit mode allows you to see your data as rows of records, with optional filtering and sorting of that data. In this mode, you can also enter new records, make changes to, and delete existing records.</paragraph> </section> <paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">In the $[officename] Help, you will find further information on the following subjects:</paragraph> -<h2 id="hd_id3152425"><link href="text/shared/explorer/database/05010000.xhp" name="Create new or edit table design">Create new or edit table design</link></h2> +<h2 id="hd_id3152425"><link href="text/sdatabase/05010000.xhp" name="Create new or edit table design">Create new or edit table design</link></h2> <embed href="text/shared/01/05340400.xhp#data_sources"/> <embed href="text/shared/02/12100200.xhp#findrecord"/> <h2 id="hd_id3149095"><link href="text/shared/main0212.xhp" name="Sort and Filter Data">Sort and Filter Data</link></h2> diff --git a/source/text/shared/explorer/database/05010000.xhp b/source/text/sdatabase/05010000.xhp similarity index 76% rename from source/text/shared/explorer/database/05010000.xhp rename to source/text/sdatabase/05010000.xhp index d8c494bfc..faabb59c8 100644 --- a/source/text/shared/explorer/database/05010000.xhp +++ b/source/text/sdatabase/05010000.xhp @@ -1,6 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - <!-- * This file is part of the LibreOffice project. * @@ -18,14 +16,11 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05010000xml" indexer="exclude" status="PUBLISH"> <title id="tit" xml-lang="en-US">Table Design</title> -<filename>/text/shared/explorer/database/05010000.xhp</filename> +<filename>/text/sdatabase/05010000.xhp</filename> </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> @@ -33,7 +28,7 @@ </meta> <body> <section id="table_design"> -<paragraph role="heading" id="hd_id3154228" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05010000.xhp" name="Table Design">Table Design</link></paragraph> +<h1 id="hd_id3154228"><link href="text/sdatabase/05010000.xhp" name="Table Design">Table Design</link></h1> <paragraph role="paragraph" id="par_id3152363" xml-lang="en-US">In the <emph>Table Design</emph> window you define new tables or edit the structure of an existing table.</paragraph> </section> <section id="howtoget"> @@ -41,51 +36,51 @@ </section> <embed href="text/shared/guide/database_main.xhp#database_main"/> <embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/> -<paragraph role="paragraph" id="par_id3146957" xml-lang="en-US">The window has its own menu bar. It also contains the following new command: <link href="text/shared/explorer/database/05010100.xhp" name="Index Design"><emph>Index Design</emph></link></paragraph> +<paragraph role="paragraph" id="par_id3146957" xml-lang="en-US">The window has its own menu bar. It also contains the following new command: <link href="text/sdatabase/05010100.xhp" name="Index Design"><emph>Index Design</emph></link></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_BACKGROUND" id="bm_id3147088" localize="false"/> -<paragraph role="heading" id="hd_id3152551" xml-lang="en-US" level="2">Table definition area</paragraph> +<h2 id="hd_id3152551">Table definition area</h2> <paragraph role="paragraph" id="par_id3153681" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_BACKGROUND">This area is where you define the table structure.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_NAMECELL" id="bm_id3145382" localize="false"/> -<paragraph role="heading" id="hd_id3153031" xml-lang="en-US" level="3">Field Name</paragraph> +<h3 id="hd_id3153031">Field Name</h3> <paragraph role="paragraph" id="par_id3156113" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_NAMECELL">Specifies the name of the data field. The database engine may impose restrictions on the length of the table name, and the use of special characters and spaces within the table name.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_TYPECELL" id="bm_id3148473" localize="false"/> -<paragraph role="heading" id="hd_id3147618" xml-lang="en-US" level="3">Field type</paragraph> +<h3 id="hd_id3147618">Field type</h3> <paragraph role="paragraph" id="par_id3154897" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_TYPECELL">Specifies the field type. The available field types are limited by the database engine being used.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABDESIGN_COMMENTCELL" id="bm_id3149233" localize="false"/> -<paragraph role="heading" id="hd_id3156119" xml-lang="en-US" level="3">Description</paragraph> +<h3 id="hd_id3156119">Description</h3> <paragraph role="paragraph" id="par_id3145315" xml-lang="en-US"><ahelp hid="HID_TABDESIGN_COMMENTCELL">Specifies an optional description for each field.</ahelp></paragraph> <paragraph role="paragraph" id="par_id3155630" xml-lang="en-US">The row headers contain the following context menu commands:</paragraph> -<paragraph role="heading" id="hd_id3156330" xml-lang="en-US" level="3">Cut</paragraph> +<h3 id="hd_id3156330">Cut</h3> <paragraph role="paragraph" id="par_id3159157" xml-lang="en-US">Cuts the selected row to the clipboard.</paragraph> -<paragraph role="heading" id="hd_id3159177" xml-lang="en-US" level="3">Copy</paragraph> +<h3 id="hd_id3159177">Copy</h3> <paragraph role="paragraph" id="par_id3148685" xml-lang="en-US">Copies the selected row to the clipboard.</paragraph> -<paragraph role="heading" id="hd_id3156327" xml-lang="en-US" level="3">Paste</paragraph> +<h3 id="hd_id3156327">Paste</h3> <paragraph role="paragraph" id="par_id3152472" xml-lang="en-US">Pastes the content of the clipboard.</paragraph> -<paragraph role="heading" id="hd_id3144511" xml-lang="en-US" level="3">Delete</paragraph> +<h3 id="hd_id3144511">Delete</h3> <paragraph role="paragraph" id="par_id3148550" xml-lang="en-US"><ahelp hid=".uno:Delete">Deletes the selected row.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_INSERTROWS" id="bm_id3159414" localize="false"/> -<paragraph role="heading" id="hd_id3147303" xml-lang="en-US" level="3">Insert Rows</paragraph> +<h3 id="hd_id3147303">Insert Rows</h3> <paragraph role="paragraph" id="par_id3149456" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_INSERTROWS">Inserts an empty row above the current row, if the table has not been saved. Inserts an empty row at the end of the table if the table has already been saved.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLEDESIGN_TABED_PRIMARYKEY" id="bm_id3150791" localize="false"/> -<paragraph role="heading" id="hd_id3153524" xml-lang="en-US" level="3">Primary Key</paragraph> +<h3 id="hd_id3153524">Primary Key</h3> <paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><ahelp hid="SID_TABLEDESIGN_TABED_PRIMARYKEY">If this command has a check mark, the data field is defined as a primary key.</ahelp> By clicking the command you activate/deactivate the primary key definition of the field. The command is only visible if the data source supports primary keys.</paragraph> -<paragraph role="heading" id="hd_id3153104" xml-lang="en-US" level="2">Field properties</paragraph> +<h2 id="hd_id3153104">Field properties</h2> <paragraph role="paragraph" id="par_id3148922" xml-lang="en-US">Defines the field properties of the currently selected field.</paragraph> -<paragraph role="heading" id="hd_id3150767" xml-lang="en-US" level="3">Length</paragraph> +<h3 id="hd_id3150767">Length</h3> <paragraph role="paragraph" id="par_id3144761" xml-lang="en-US">Specifies the maximum number of characters allowed for data entry of the corresponding data field including any spaces or special characters.</paragraph> -<paragraph role="heading" id="hd_id3154948" xml-lang="en-US" level="3">Decimal places</paragraph> +<h3 id="hd_id3154948">Decimal places</h3> <paragraph role="paragraph" id="par_id3149203" xml-lang="en-US">Specifies the number of decimal places for a numerical field or decimal field.</paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_DEFAULT" id="bm_id3158410" localize="false"/> -<paragraph role="heading" id="hd_id3156422" xml-lang="en-US" level="3">Default value</paragraph> +<h3 id="hd_id3156422">Default value</h3> <paragraph role="paragraph" id="par_id3125863" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_DEFAULT">Specifies the value that is the default in new data records.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT_SAMPLE" id="bm_id3149562" localize="false"/> -<paragraph role="heading" id="hd_id3147289" xml-lang="en-US" level="3">Format example</paragraph> +<h3 id="hd_id3147289">Format example</h3> <paragraph role="paragraph" id="par_id3155131" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT_SAMPLE">Displays the format code to assign to the field value that you can select with the<emph> ... </emph>button.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TAB_ENT_FORMAT" id="bm_id3147319" localize="false"/> -<paragraph role="heading" id="hd_id3154129" xml-lang="en-US" level="3">...</paragraph> +<h3 id="hd_id3154129">...</h3> <paragraph role="paragraph" id="par_id3154146" xml-lang="en-US"><ahelp hid="HID_TAB_ENT_FORMAT">This button opens the <link href="text/shared/01/05340405.xhp" name="Field Format"><emph>Field Format</emph></link> dialog.</ahelp></paragraph> <bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_TABLE_DESIGN_HELP_WINDOW" id="bm_id3152941" localize="false"/> -<paragraph role="heading" id="hd_id3152576" xml-lang="en-US" level="2">Help area</paragraph> +<h2 id="hd_id3152576">Help area</h2> <paragraph role="paragraph" id="par_id3150685" xml-lang="en-US"><ahelp hid="HID_TABLE_DESIGN_HELP_WINDOW">Displays a help string or hint defined by the database designer for the given field.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/shared/explorer/database/05010100.xhp b/source/text/sdatabase/05010100.xhp similarity index 71% rename from source/text/shared/explorer/database/05010100.xhp rename to source/text/sdatabase/05010100.xhp index bb17c6075..a5fff8308 100644 --- a/source/text/shared/explorer/database/05010100.xhp +++ b/source/text/sdatabase/05010100.xhp @@ -1,7 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - - <!-- * This file is part of the LibreOffice project. * @@ -19,48 +16,46 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - - <helpdocument version="1.0"> +<helpdocument version="1.0"> <meta> <topic id="textsharedexplorerdatabase05010100xml" indexer="include" status="PUBLISH"> <title id="tit" xml-lang="en-US">Index design</title> -<filename>/text/shared/explorer/database/05010100.xhp</filename> +<filename>/text/sdatabase/05010100.xhp</filename> </topic> </meta> <body> <section id="index_design"> <bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/IndexDesignDialog" id="bm_id3156410" localize="false"/> -<bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/><paragraph role="heading" id="hd_id3153311" xml-lang="en-US" level="1"><link href="text/shared/explorer/database/05010100.xhp" name="Index design">Index design</link></paragraph> +<bookmark xml-lang="en-US" branch="hid/.uno:DBIndexDesign" id="bm_id3149828" localize="false"/><h1 id="hd_id3153311"><link href="text/sdatabase/05010100.xhp" name="Index design">Index design</link></h1> <paragraph role="paragraph" id="par_id3166460" xml-lang="en-US"><ahelp hid=".uno:DBIndexDesign">The <emph>Index Design </emph>dialog allows you to define and edit the indexes for the current table.</ahelp></paragraph> </section> <section id="howtoget"> <embed href="text/shared/00/00000450.xhp#indexentwurf"/> </section> <embed href="text/shared/guide/data_tabledefine.xhp#data_tabledefine"/> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/INDEX_LIST" id="bm_id3148473" localize="false"/><paragraph role="heading" id="hd_id3149578" xml-lang="en-US" level="2">Index list</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/INDEX_LIST" id="bm_id3148473" localize="false"/><h2 id="hd_id3149578">Index list</h2> <paragraph role="paragraph" id="par_id3155342" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/INDEX_LIST">Displays a list of available indexes. Select an index from the list to edit. The details of the selected index are displayed in the dialog.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_NEW" id="bm_id3158430" localize="false"/><paragraph role="heading" id="hd_id3149795" xml-lang="en-US" level="3">New Index</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_NEW" id="bm_id3158430" localize="false"/><h3 id="hd_id3149795">New Index</h3> <paragraph role="paragraph" id="par_id3150085" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_NEW">Creates a new index.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_DROP" id="bm_id3148642" localize="false"/><paragraph role="heading" id="hd_id3145317" xml-lang="en-US" level="3">Delete Current Index</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_DROP" id="bm_id3148642" localize="false"/><h3 id="hd_id3145317">Delete Current Index</h3> <paragraph role="paragraph" id="par_id3154860" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_DROP">Deletes the current index.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME" id="bm_id3154285" localize="false"/><paragraph role="heading" id="hd_id3150986" xml-lang="en-US" level="3">Rename Current Index</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME" id="bm_id3154285" localize="false"/><h3 id="hd_id3150986">Rename Current Index</h3> <paragraph role="paragraph" id="par_id3148685" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RENAME">Renames the current index.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE" id="bm_id3151245" localize="false"/><paragraph role="heading" id="hd_id3153628" xml-lang="en-US" level="3">Save Current Index</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE" id="bm_id3151245" localize="false"/><h3 id="hd_id3153628">Save Current Index</h3> <paragraph role="paragraph" id="par_id3148563" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_SAVE">Saves the current index in the data source.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RESET" id="bm_id3147265" localize="false"/><paragraph role="heading" id="hd_id3154924" xml-lang="en-US" level="3">Reset Current Index</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/ID_INDEX_RESET" id="bm_id3147265" localize="false"/><h3 id="hd_id3154924">Reset Current Index</h3> <paragraph role="paragraph" id="par_id3154758" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/ID_INDEX_RESET">Resets the current index to the setting that it had when the dialog was started.</ahelp></paragraph> -<paragraph role="heading" id="hd_id3152812" xml-lang="en-US" level="2">Index details</paragraph> +<h2 id="hd_id3152812">Index details</h2> <paragraph role="paragraph" id="par_id3154938" xml-lang="en-US">As soon as you change a detail of the current index and then select another index, the change is immediately passed on to the data source. You can only leave the dialog, or select another index, if the change has been successfully acknowledged by the data source. However, you can undo the change by clicking the <emph>Reset Current Index </emph>icon.</paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/UNIQUE" id="bm_id3145171" localize="false"/><paragraph role="heading" id="hd_id3154138" xml-lang="en-US" level="3">Unique</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/UNIQUE" id="bm_id3145171" localize="false"/><h3 id="hd_id3154138">Unique</h3> <paragraph role="paragraph" id="par_id3156282" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/UNIQUE">Specifies whether the current index allows only unique values.</ahelp> Checking the <emph>Unique </emph>option prevents duplicate data from being entered in the field and ensures data integrity.</paragraph> -<paragraph role="heading" id="hd_id3150448" xml-lang="en-US" level="3">Fields</paragraph> +<h3 id="hd_id3150448">Fields</h3> <paragraph role="paragraph" id="par_id3147085" xml-lang="en-US">The<emph> Fields</emph> area displays a list of fields in the current table. You can also select multiple fields. In order to remove a field from the selection, select the empty entry at the start of the list.</paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/><paragraph role="heading" id="hd_id3149765" xml-lang="en-US" level="3">Index field</paragraph> +<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_FIELD" id="bm_id3147230" localize="false"/><h3 id="hd_id3149765">Index field</h3> <paragraph role="paragraph" id="par_id3158408" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_FIELD">Displays a list of the fields in the current table. You can select more than one field.</ahelp><comment>i73718</comment></paragraph> -<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/><paragraph role="heading" id="hd_id3153192" xml-lang="en-US" level="3">Sort order</paragraph> +<bookmark xml-lang="en-US" branch="hid/DBACCESS_HID_DLGINDEX_INDEXDETAILS_SORTORDER" id="bm_id3154910" localize="false"/><h3 id="hd_id3153192">Sort order</h3> <paragraph role="paragraph" id="par_id3149561" xml-lang="en-US"><ahelp hid="HID_DLGINDEX_INDEXDETAILS_SORTORDER">Determines the sort order of the indexes.</ahelp></paragraph> -<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/close" id="bm_id3145785" localize="false"/><paragraph role="heading" id="hd_id3155132" xml-lang="en-US" level="2">Close</paragraph> +<bookmark xml-lang="en-US" branch="hid/dbaccess/ui/indexdesigndialog/close" id="bm_id3145785" localize="false"/><h2 id="hd_id3155132">Close</h2> <paragraph role="paragraph" id="par_id3154190" xml-lang="en-US"><ahelp hid="dbaccess/ui/indexdesigndialog/close">Closes the dialog.</ahelp></paragraph> </body> </helpdocument> diff --git a/source/text/shared/guide/data_tabledefine.xhp b/source/text/shared/guide/data_tabledefine.xhp index 8c1ed583a..b1f0f1656 100644 --- a/source/text/shared/guide/data_tabledefine.xhp +++ b/source/text/shared/guide/data_tabledefine.xhp @@ -1,6 +1,6 @@ <?xml version="1.0" encoding="UTF-8"?> <helpdocument version="1.0"> - + <!-- * This file is part of the LibreOffice project. * @@ -18,8 +18,8 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - - + + <meta> <topic id="textsharedguidedata_tabledefinexml" indexer="include" status="PUBLISH"> <title xml-lang="en-US" id="tit">Table Design</title> @@ -37,7 +37,7 @@ <paragraph xml-lang="en-US" id="par_id3155448" role="paragraph" localize="false"/> <paragraph xml-lang="en-US" id="hd_id3149798" role="heading" level="1"><variable id="data_tabledefine"><link href="text/shared/guide/data_tabledefine.xhp" name="Table Design">Table Design</link> </variable></paragraph> - <paragraph xml-lang="en-US" id="par_id3155535" role="paragraph">This section contains information about how to create a new database table in the <link href="text/shared/explorer/database/05010000.xhp" name="design view">design view</link>.</paragraph> + <paragraph xml-lang="en-US" id="par_id3155535" role="paragraph">This section contains information about how to create a new database table in the <link href="text/sdatabase/05010000.xhp" name="design view">design view</link>.</paragraph> <paragraph xml-lang="en-US" id="par_id3154288" role="paragraph">Open the database file of the database where you want a new table. Click the <emph>Tables</emph> icon. Choose <emph>Create Table in Design View</emph> to create a new table.</paragraph> <paragraph xml-lang="en-US" id="par_id3146798" role="paragraph">In the Design view, you can now create the fields for your table.</paragraph> <list type="unordered"> @@ -61,4 +61,4 @@ <embed href="text/shared/00/00000004.xhp#related"/> <embed href="text/shared/guide/database_main.xhp#database_main"/> </body> -</helpdocument> \ No newline at end of file +</helpdocument> diff --git a/source/text/shared/guide/database_main.xhp b/source/text/shared/guide/database_main.xhp index d5249088f..e0a3ef64a 100644 --- a/source/text/shared/guide/database_main.xhp +++ b/source/text/shared/guide/database_main.xhp @@ -1,6 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - - <!-- * This file is part of the LibreOffice project. * @@ -18,7 +16,6 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <helpdocument version="1.0"> <meta> <topic id="textsharedguidedatabase_mainxml" indexer="include" status="PUBLISH"> @@ -36,27 +33,27 @@ <bookmark_value>explorer of data sources</bookmark_value> </bookmark> <paragraph role="paragraph" id="par_id3153031" xml-lang="en-US" localize="false"/> -<paragraph role="heading" id="hd_id3148474" xml-lang="en-US" level="1"><variable id="database_main"><link href="text/shared/guide/database_main.xhp" name="Data Source Overview">Database Overview</link> -</variable><comment>remove this file when all links are resolved</comment></paragraph> +<h1 id="hd_id3148474"><variable id="database_main"><link href="text/shared/guide/database_main.xhp" name="Data Source Overview">Database Overview</link> +</variable><comment>remove this file when all links are resolved</comment></h1> <paragraph role="paragraph" id="par_idN105F1" xml-lang="en-US"><link href="text/sdatabase/main.xhp">Working with databases in %PRODUCTNAME</link></paragraph> -<paragraph role="heading" id="hd_id3153821" xml-lang="en-US" level="2">Data Source View</paragraph> +<h2 id="hd_id3153821">Data Source View</h2> <paragraph role="paragraph" id="par_id3149415" xml-lang="en-US">Choose <emph>View - Data Sources</emph> or press <switchinline select="sys"><caseinline select="MAC">Command</caseinline><defaultinline>Ctrl</defaultinline></switchinline> + Shift + F4 keys to call the data source view from a text document or spreadsheet.</paragraph> <paragraph role="paragraph" id="par_id3147531" xml-lang="en-US">On the left you can see the <link href="text/shared/02/12000000.xhp" name="Data source explorer">Data source explorer</link>. If you select a table or query there, you see the contents of this table or query on the right. At the top margin is the <link href="text/shared/main0212.xhp" name="Database bar">Table Data bar</link>.</paragraph> -<paragraph role="heading" id="hd_id3149047" xml-lang="en-US" level="2">Data Sources</paragraph> +<h2 id="hd_id3149047">Data Sources</h2> <paragraph role="paragraph" id="par_id3145069" xml-lang="en-US"><link href="text/shared/guide/data_addressbook.xhp" name="address book as data source">Address book as data source</link></paragraph> <paragraph role="paragraph" id="par_id3150398" xml-lang="en-US"><link href="text/shared/01/04180100.xhp" name="View data source contents">View data source contents</link></paragraph> <paragraph role="paragraph" id="par_idN106A4" xml-lang="en-US"><link href="text/shared/explorer/database/menubar.xhp">Menu bar of a database file</link></paragraph> -<paragraph role="heading" id="hd_id3154123" xml-lang="en-US" level="2">Forms and Reports</paragraph> +<h2 id="hd_id3154123">Forms and Reports</h2> <paragraph role="paragraph" id="par_id3154909" xml-lang="en-US"><link href="text/sdatabase/04030000.xhp" name="Create new form document">Create new form document</link>, <link href="text/shared/02/01170000.xhp" name="edit form functions">edit form controls</link>, <link href="text/shared/autopi/01090000.xhp">Form Wizard</link></paragraph> <paragraph role="paragraph" id="par_id3152920" xml-lang="en-US"><link href="text/shared/02/01170500.xhp" name="entering data versus editing form">Entering data versus editing form</link></paragraph> <paragraph role="paragraph" id="par_id3151380" xml-lang="en-US"><link href="text/shared/autopi/01100000.xhp" name="Report AutoPilot">Report Wizard</link></paragraph> <embed href="text/shared/guide/data_report.xhp#data_report"/> -<paragraph role="heading" id="hd_id3145606" xml-lang="en-US" level="2">Queries</paragraph> +<h2 id="hd_id3145606">Queries</h2> <paragraph role="paragraph" id="par_id3125864" xml-lang="en-US"><link href="text/sdatabase/02000000.xhp" name="Create new query or table view, edit query structure">Create new query or table view, edit query structure</link></paragraph> <paragraph role="paragraph" id="par_idN1072A" xml-lang="en-US"><link href="text/shared/explorer/database/querywizard00.xhp">Query Wizard</link></paragraph> <paragraph role="paragraph" id="par_id3155430" xml-lang="en-US"><link href="text/shared/01/05340400.xhp" name="Enter, edit and copy records">Enter, edit and copy records</link></paragraph> -<paragraph role="heading" id="hd_id3147287" xml-lang="en-US" level="2">Tables</paragraph> -<paragraph role="paragraph" id="par_id3163713" xml-lang="en-US"><link href="text/shared/explorer/database/05010000.xhp" name="Create new table, edit table structure">Create new table, edit table structure</link>, <link href="text/shared/explorer/database/05010100.xhp" name="index">index</link>, <link href="text/shared/explorer/database/05020000.xhp" name="relations">relations</link></paragraph> +<h2 id="hd_id3147287">Tables</h2> +<paragraph role="paragraph" id="par_id3163713" xml-lang="en-US"><link href="text/sdatabase/05010000.xhp" name="Create new table, edit table structure">Create new table, edit table structure</link>, <link href="text/sdatabase/05010100.xhp" name="index">index</link>, <link href="text/shared/explorer/database/05020000.xhp" name="relations">relations</link></paragraph> <paragraph role="paragraph" id="par_idN1078F" xml-lang="en-US"><link href="text/shared/explorer/database/tablewizard00.xhp">Table Wizard</link></paragraph> <paragraph role="paragraph" id="par_id3159196" xml-lang="en-US"><link href="text/shared/01/05340400.xhp" name="Enter, edit and copy records">Enter, edit and copy records</link></paragraph> </body> commit c0f70b871b7a558f5f7de355e6e18636cd90ac93 Author: Steve Fanning <[email protected]> AuthorDate: Sun Jan 31 01:09:50 2021 +0100 Commit: Olivier Hallot <[email protected]> CommitDate: Sun Jan 31 17:33:26 2021 +0100 The syntax given in the Help file for Calc’s LOGNORM.INV function is incorrect (see Bug 137649). Specifically, the second (“Mean”) and third (“StDev”) arguments are optional rather than required in Calc’s current implementation. If omitted the Mean argument defaults to 0.0 and the StDev argument defaults to 1.0. Note: The corresponding Excel function’s three arguments are all required (none are optional) and so one possible outcome of Bug 137649 is for Calc to be updated to match this behaviour for interoperability. However, we do not know if or when this might happen and so, in the meantime, I propose to update the Help to more accurately reflect Calc’s current behaviour. The change affects only one file, 04060183.xhp. Change-Id: I69934a8123d5de41007bc4dfca1cbc478ed963a6 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110150 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/scalc/01/04060183.xhp b/source/text/scalc/01/04060183.xhp index cc5039eef..b4eb4c6f2 100644 --- a/source/text/scalc/01/04060183.xhp +++ b/source/text/scalc/01/04060183.xhp @@ -225,11 +225,11 @@ <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> <paragraph role="code" id="par_id3153049" xml-lang="en-US">LOGINV(Number [; Mean [; StDev]])</paragraph> <paragraph role="paragraph" id="par_id3148390" xml-lang="en-US"> -<emph>Number</emph> is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> +<emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> <paragraph role="paragraph" id="par_id3149538" xml-lang="en-US"> -<emph>Mean</emph> is the arithmetic mean of the standard logarithmic distribution.</paragraph> +<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).</paragraph> <paragraph role="paragraph" id="par_id3145355" xml-lang="en-US"> -<emph>StDev</emph> is the standard deviation of the standard logarithmic distribution.</paragraph> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id3155623" xml-lang="en-US"> <item type="input">=LOGINV(0.05;0;1)</item> returns 0.1930408167.</paragraph> @@ -244,13 +244,13 @@ <paragraph id="par_id290122405814" role="paragraph" xml-lang="en-US">This function is identical to LOGINV and was introduced for interoperability with other office suites.</paragraph> <embed href="text/scalc/00/avail_release.xhp#4.3"/> <embed href="text/scalc/01/common_func.xhp#sectionsyntax"/> -<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number; Mean; StDev)</paragraph> +<paragraph role="code" id="par_id2901049" xml-lang="en-US">LOGNORM.INV(Number [; Mean [; StDev]])</paragraph> <paragraph role="paragraph" id="par_id2901390" xml-lang="en-US"> <emph>Number</emph> (required) is the probability value for which the inverse standard logarithmic distribution is to be calculated.</paragraph> <paragraph role="paragraph" id="par_id2901538" xml-lang="en-US"> -<emph>Mean</emph> (required) is the arithmetic mean of the standard logarithmic distribution.</paragraph> +<emph>Mean</emph> (optional) is the arithmetic mean of the standard logarithmic distribution (defaults to 0 if omitted).</paragraph> <paragraph role="paragraph" id="par_id2901355" xml-lang="en-US"> -<emph>StDev</emph> (required) is the standard deviation of the standard logarithmic distribution.</paragraph> +<emph>StDev</emph> (optional) is the standard deviation of the standard logarithmic distribution (defaults to 1 if omitted).</paragraph> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph role="paragraph" id="par_id2901623" xml-lang="en-US"> <item type="input">=LOGNORM.INV(0.05;0;1)</item> returns 0.1930408167.</paragraph> _______________________________________________ Libreoffice-commits mailing list [email protected] https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
