[Libreoffice-commits] help.git: Branch 'libreoffice-6-0' - 2 commits - AllLangHelp_sbasic.mk source/auxiliary source/media source/text
Olivier Hallot
olivier.hallot at libreoffice.org
Wed Dec 6 12:25:44 UTC 2017
AllLangHelp_sbasic.mk | 1
source/auxiliary/sbasic.tree | 1
source/media/helpimg/sc_data_form01.png |binary
source/text/sbasic/shared/03150002.xhp | 66 +++++++++++++
source/text/sbasic/shared/special_vba_func.xhp | 1
source/text/scalc/01/data_form.xhp | 119 ++++++++++++++-----------
6 files changed, 138 insertions(+), 50 deletions(-)
New commits:
commit 8c1f54ec1d24df174f5af679298b48fccaaeaaba
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date: Wed Dec 6 09:46:35 2017 -0200
tdf#83269 Help page for Calc Data->Form...
Change-Id: If182e61aec29a912faa7af8e3d0791d03fcf1aca
Reviewed-on: https://gerrit.libreoffice.org/45937
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot at libreoffice.org>
(cherry picked from commit 0b1c7e3c53f36b36f304270fd7aa455321dfd8fe)
Reviewed-on: https://gerrit.libreoffice.org/45947
diff --git a/source/media/helpimg/sc_data_form01.png b/source/media/helpimg/sc_data_form01.png
new file mode 100644
index 000000000..8a11d3da9
Binary files /dev/null and b/source/media/helpimg/sc_data_form01.png differ
diff --git a/source/text/scalc/01/data_form.xhp b/source/text/scalc/01/data_form.xhp
index 8b5f6aa05..95dc5442e 100644
--- a/source/text/scalc/01/data_form.xhp
+++ b/source/text/scalc/01/data_form.xhp
@@ -1,55 +1,74 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-<!--
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- *
- * This file incorporates work covered by the following license notice:
- *
- * Licensed to the Apache Software Foundation (ASF) under one or more
- * contributor license agreements. See the NOTICE file distributed
- * with this work for additional information regarding copyright
- * ownership. The ASF licenses this file to you under the Apache
- * License, Version 2.0 (the "License"); you may not use this file
- * 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="textscalc01data_formxml">
- <title id="tit" xml-lang="en-US">Data Form for Spreadsheet</title>
- <filename>/text/scalc/01/data_form.xhp</filename>
- </topic>
-</meta>
-
-<body>
-
-
-<section id="data_form">
- <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataform/DataFormDialog" id="bm_id240920171033409926" localize="false"/>
-<bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
- <bookmark_value>data forms;for spreadsheets</bookmark_value>
- <bookmark_value>data forms;insert data in spreadsheets</bookmark_value>
- <bookmark_value>insert data;data forms for spreadsheets</bookmark_value>
- <bookmark_value>spreadsheet;form to insert data</bookmark_value>
-</bookmark>
-
-
-<paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/data_form.xhp">Data Forms for Spreasheets</link></paragraph>
-<paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Data Forms for Spreasheets</ahelp></paragraph>
-</section>
-
-<section id="howtoget">
-<paragraph id="par_id240920171007389295" role="paragraph" xml-lang="en-US">Menu <item type="menuitem">Data – Form...</item></paragraph>
-</section>
-<embed href="text/shared/need_help.xhp#needhelp"/>
-
-<section id="relatedtopics">
-<paragraph id="par_id240920171007419799" role="paragraph" xml-lang="en-US">Form</paragraph>
-</section>
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ -->
+
+ <meta>
+ <topic id="textscalc01data_formxml">
+ <title id="tit" xml-lang="en-US">Data Entry Form for Spreadsheet</title>
+ <filename>/text/scalc/01/data_form.xhp</filename>
+ </topic>
+ </meta>
+
+ <body>
+
+ <section id="data_form">
+ <bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/dataform/DataFormDialog" id="bm_id240920171033409926" localize="false"/>
+ <bookmark xml-lang="en-US" branch="index" id="bm_id240920171018528200">
+ <bookmark_value>data entry forms;for spreadsheets</bookmark_value>
+ <bookmark_value>data entry forms;insert data in spreadsheets</bookmark_value>
+ <bookmark_value>insert data;data entry forms for spreadsheets</bookmark_value>
+ <bookmark_value>spreadsheet;form for inserting data</bookmark_value>
+ </bookmark>
+
+ <paragraph id="hd_id240920171003006302" role="heading" level="1" xml-lang="en-US"><link href="text/scalc/01/data_form.xhp">Data Entry Forms for Spreasheets</link></paragraph>
+ <paragraph id="par_id240920171003293400" role="paragraph" xml-lang="en-US"><ahelp hid=".">Data Entry Form is a tool to make table data entry easy in spreadsheets.</ahelp> With the Data Entry Form, you can enter, edit and delete records (or rows) of data and avoid horizontal scrolling when the table has many columns or when some columns are very wide.</paragraph>
+ </section>
+
+ <section id="howtoget">
+ <paragraph id="par_id240920171007389295" role="paragraph" xml-lang="en-US">Choose <item type="menuitem">Data – Form...</item></paragraph>
+ </section>
+
+ <paragraph role="heading" id="hd_id291512503277077" level="2" xml-lang="en-US">Preparing the data entry form</paragraph>
+ <paragraph role="paragraph" id="par_id221512503284514" xml-lang="en-US">To be effective, the Calc data table should have a header row, where each cell contents is the label of the column. The header cells contents becomes the label of each data field in the form.</paragraph>
+
+ <paragraph role="heading" id="hd_id531512503300666" level="2" xml-lang="en-US">Activating the form</paragraph>
+ <list type="ordered">
+ <listitem>
+ <paragraph id="par_id551512503358101" role="listitem" xml-lang="en-US">Place the cursor in the header row of the table.</paragraph>
+ </listitem>
+ <listitem>
+ <paragraph id="par_id11512503369875" role="listitem" xml-lang="en-US">Choose <item type="menutiem">Data - Form...</item>.</paragraph>
+ </listitem>
+ </list>
+ <paragraph role="heading" id="hd_id361512503457039" level="2" xml-lang="en-US">Filling the form with data</paragraph>
+ Enter the data in the text fields. Press Enter or click <item type="literal">New</item> to add it to the table.
+ <paragraph role="heading" id="hd_id111512507319306" level="2" xml-lang="en-US">Form dialog buttons</paragraph>
+ <paragraph role="paragraph" id="par_id981512503964001" xml-lang="en-US"><emph>New</emph>: fill the record (table row cells) with the form fields contents and jump to the next record or add a new record in the bottom of the table.</paragraph>
+ <paragraph role="paragraph" id="par_id91512503864256" xml-lang="en-US"><emph>Delete</emph>: deletes the current record.</paragraph>
+ <paragraph role="paragraph" id="par_id11512503887586" xml-lang="en-US"><emph>Restore</emph>: when a form field is edited, restore the record contents to its initial state.</paragraph>
+ <paragraph role="paragraph" id="par_id301512503881314" xml-lang="en-US"><emph>Previous record</emph>: move to the previous record (table row).</paragraph>
+ <paragraph role="paragraph" id="par_id51512503877397" xml-lang="en-US"><emph>Next record</emph>: move to the next record.</paragraph>
+ <paragraph role="paragraph" id="par_id971512503871672" xml-lang="en-US"><emph>Close</emph>: close the form.</paragraph>
+ <br/>
+ <paragraph role="paragraph" id="par_id951512509971073" xml-lang="en-US">
+ <image src="media/helpimg/sc_data_form01.png" id="img_id951512509971073">
+ <alt xml-lang="en-US" id="alt_id951512509971073">The form dialog box and header row cells as field labels</alt>
+ </image>
+ </paragraph>
+ <paragraph role="tip" id="par_id351512558748321" xml-lang="en-US">Use the <item type="input">Tab</item> and <item type="input">Shift-Tab</item> keys to jump forth and back between text boxes of the form dialog.</paragraph>
+ <paragraph role="tip" id="par_id731512558741034" xml-lang="en-US">You also can use the form scroll bar to move between text boxes.</paragraph>
+ <paragraph role="heading" id="hd_id701512558977465" level="2" xml-lang="en-US">Reopening the form dialog</paragraph>
+ <paragraph role="paragraph" id="par_id181512558987528" xml-lang="en-US">To reopen the form dialog, place the cursor on the header row and open the form. The displayed record in the form dialog is the fisrt data record. Move to the last record before entering new data otherwise the current record will be edited.</paragraph>
+ <section id="relatedtopics">
+ <paragraph id="par_id240920171007419799" role="paragraph" xml-lang="en-US"><link href="text/shared/guide/data_forms.xhp" name="Forms">Document Forms</link></paragraph>
+ </section>
</body>
</helpdocument>
commit c2c6256141838e757674882647cd91e8ee8026c6
Author: Olivier Hallot <olivier.hallot at libreoffice.org>
Date: Sun Dec 3 18:20:05 2017 -0200
tdf#84675 Undocumented VBA function: MonthName
Change-Id: I3fa5e80dd94c281bdfd6e076f55e172c52be9ecb
Reviewed-on: https://gerrit.libreoffice.org/45757
Reviewed-by: Olivier Hallot <olivier.hallot at libreoffice.org>
Tested-by: Olivier Hallot <olivier.hallot at libreoffice.org>
(cherry picked from commit 9891e96d1d95c1921cba16c6339c15cf3613da0d)
Reviewed-on: https://gerrit.libreoffice.org/45945
diff --git a/AllLangHelp_sbasic.mk b/AllLangHelp_sbasic.mk
index 5f8df59a0..2ffab07cf 100644
--- a/AllLangHelp_sbasic.mk
+++ b/AllLangHelp_sbasic.mk
@@ -340,6 +340,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,sbasic,\
helpcontent2/source/text/sbasic/shared/03140012 \
helpcontent2/source/text/sbasic/shared/03150000 \
helpcontent2/source/text/sbasic/shared/03150001 \
+ helpcontent2/source/text/sbasic/shared/03150002 \
helpcontent2/source/text/sbasic/shared/03160000 \
helpcontent2/source/text/sbasic/shared/03170000 \
helpcontent2/source/text/sbasic/shared/05060700 \
diff --git a/source/auxiliary/sbasic.tree b/source/auxiliary/sbasic.tree
index b43a18c89..6a3e8aeb9 100644
--- a/source/auxiliary/sbasic.tree
+++ b/source/auxiliary/sbasic.tree
@@ -200,6 +200,7 @@
<topic id="sbasic/text/sbasic/shared/03020411.xhp">MkDir Statement [Runtime]</topic>
<topic id="sbasic/text/sbasic/shared/03070600.xhp">Mod-Operator [Runtime]</topic>
<topic id="sbasic/text/sbasic/shared/03030104.xhp">Month Function [Runtime]</topic>
+<topic id="sbasic/text/sbasic/shared/03150002.xhp">MonthName Function [Runtime - VBA]</topic>
<topic id="sbasic/text/sbasic/shared/03010102.xhp">MsgBox Function [Runtime]</topic>
<topic id="sbasic/text/sbasic/shared/03010101.xhp">MsgBox Statement [Runtime]</topic>
<topic id="sbasic/text/sbasic/shared/03020412.xhp">Name Statement [Runtime]</topic>
diff --git a/source/text/sbasic/shared/03150002.xhp b/source/text/sbasic/shared/03150002.xhp
new file mode 100644
index 000000000..e03cf9b2e
--- /dev/null
+++ b/source/text/sbasic/shared/03150002.xhp
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<helpdocument version="1.0">
+ <!--
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one or more
+ * contributor license agreements. See the NOTICE file distributed
+ * with this work for additional information regarding copyright
+ * ownership. The ASF licenses this file to you under the Apache
+ * License, Version 2.0 (the "License"); you may not use this file
+ * 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="textsbasicshared03150002xml" indexer="include" status="PUBLISH">
+ <title id="tit" xml-lang="en-US">MonthName Function [Runtime - VBA]</title>
+ <filename>/text/sbasic/shared/03150002.xhp</filename>
+ </topic>
+ </meta>
+
+ <body>
+ <section id="MonthName">
+ <bookmark xml-lang="en-US" branch="index" id="bm_id3150499">
+ <bookmark_value>MonthName function</bookmark_value>
+ </bookmark>
+
+ <paragraph id="hd_id3150499" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03150002.xhp" name="MonthName Function [Runtime - VBA]">MonthName Function [Runtime - VBA]</link></paragraph>
+ <paragraph id="par_id3151384" role="paragraph" xml-lang="en-US">The MonthName function returns the localized month name of a specified month number.</paragraph>
+ </section>
+ <embed href="text/sbasic/shared/00000003.xhp#vbasupport"/>
+ <embed href="text/sbasic/shared/00000003.xhp#functsyntax"/>
+ <bascode>
+ <paragraph id="par_id3143267" role="bascode" localize="false" xml-lang="en-US">MonthName(Month as Integer [,Abbreviate as Boolean])</paragraph>
+ </bascode>
+ <embed href="text/sbasic/shared/00000003.xhp#functvalue"/>
+ <paragraph id="par_id3150669" role="paragraph" localize="false" xml-lang="en-US">String</paragraph>
+ <embed href="text/sbasic/shared/00000003.xhp#functparameters"/>
+ <paragraph id="par_id240720170117391741" role="paragraph" xml-lang="en-US"><emph>Month</emph>: Value from 1 to 12, January to December, whose localized month name need to be returned.</paragraph>
+ <paragraph id="par_id24072017011739895" role="paragraph" xml-lang="en-US"><emph>Abbreviate</emph>: Optional. A Boolean value that indicates if the month name is to be abbreviated.</paragraph>
+
+ <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
+ <embed href="text/sbasic/shared/00000003.xhp#err5"/>
+ <embed href="text/sbasic/shared/00000003.xhp#functexample"/>
+ <bascode>
+ <paragraph role="bascode" id="par_id731512155686932" xml-lang="en-US" localize="false">REM ***** BASIC *****</paragraph>
+ <paragraph role="bascode" id="par_id141512155672881" xml-lang="en-US" localize="false">Option VBASupport 1</paragraph>
+ <paragraph role="bascode" id="par_id741512155700026" xml-lang="en-US" localize="false">Sub Example_MonthName</paragraph>
+ <paragraph role="bascode" id="par_id321512155714044" xml-lang="en-US" localize="false"> Dim mBirthday as Integer</paragraph>
+ <paragraph role="bascode" id="par_id1001512155732764" xml-lang="en-US" localize="false"> mBirthday = 1</paragraph>
+ <paragraph role="bascode" id="par_id421512155749762" xml-lang="en-US" localize="false"> print mBirthday &" "& MonthName(mBirthday,False)</paragraph>
+ <paragraph role="bascode" id="par_id891512155760344" xml-lang="en-US" localize="false">End Sub</paragraph>
+ </bascode>
+
+ <section id="relatedtopics">
+ <embed href="text/sbasic/shared/00000003.xhp#VBATimeAndDate"/>
+ </section>
+</body>
+
+</helpdocument>
diff --git a/source/text/sbasic/shared/special_vba_func.xhp b/source/text/sbasic/shared/special_vba_func.xhp
index 42bba51b6..003f3c5eb 100644
--- a/source/text/sbasic/shared/special_vba_func.xhp
+++ b/source/text/sbasic/shared/special_vba_func.xhp
@@ -77,6 +77,7 @@
</bookmark>
<paragraph id="par_id051820170356005357" role="heading" level="2" xml-lang="en-US">Date and time functions</paragraph>
<embed href="text/sbasic/shared/03150000.xhp#FormatDateTime"/>
+<embed href="text/sbasic/shared/03150002.xhp#MonthName"/>
<embed href="text/sbasic/shared/03150001.xhp#WeekdayName"/>
</section>
More information about the Libreoffice-commits
mailing list