[PATCH] Help updates and changes

Hi,

see attached several micro-patches related to help content.

Greetings,
Stan

From 2c18b646c204535768be1a47e855c325cb75012e Mon Sep 17 00:00:00 2001
From: Stanislav Horacek <stanislav.horacek@gmail.com>
Date: Mon, 2 Jul 2012 21:12:23 +0200
Subject: [PATCH 1/5] Open XML formats can be also saved

---
 .../shared/guide/ms_import_export_limitations.xhp  |    2 +-
 helpcontent2/source/text/shared/guide/ms_user.xhp  |    2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/helpcontent2/source/text/shared/guide/ms_import_export_limitations.xhp 
b/helpcontent2/source/text/shared/guide/ms_import_export_limitations.xhp
index 014ecdb..189600d 100644
--- a/helpcontent2/source/text/shared/guide/ms_import_export_limitations.xhp
+++ b/helpcontent2/source/text/shared/guide/ms_import_export_limitations.xhp
@@ -44,7 +44,7 @@
 <paragraph role="paragraph" id="par_id3149760" xml-lang="en-US" l10n="E" oldref="32" 
localize="false"/>
 <paragraph role="heading" id="hd_id3152425" xml-lang="en-US" level="1" l10n="U" 
oldref="1"><variable id="about"><link href="text/shared/guide/ms_import_export_limitations.xhp" 
name="About Converting Microsoft Office Documents">About Converting Microsoft Office 
Documents</link></variable></paragraph>
 <paragraph role="paragraph" id="par_id3147834" xml-lang="en-US" l10n="U" oldref="2">$[officename] 
can automatically open Microsoft Office 97/2000/XP documents. However, some layout features and 
formatting attributes in more complex Microsoft Office documents are handled differently in 
$[officename] or are unsupported. As a result, converted files require some degree of manual 
reformatting. The amount of reformatting that can be expected is proportional to the complexity of 
the structure and formatting of the source document. $[officename] cannot run Visual Basic Scripts, 
but can load them for you to analyze.</paragraph>
-<paragraph role="note" id="par_id0804200804174819" xml-lang="en-US" l10n="NEW">The most recent 
versions of %PRODUCTNAME can load, but not save, the Microsoft Office Open XML document formats 
with the extensions docx, xlsx, and pptx. The same versions can also run some Excel Visual Basic 
scripts, if you enable this feature at <item type="menuitem"><switchinline select="sys"><caseinline 
select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - Load/Save - VBA Properties</item>.</paragraph>
+<paragraph role="note" id="par_id0804200804174819" xml-lang="en-US" l10n="NEW">The most recent 
versions of %PRODUCTNAME can load and save the Microsoft Office Open XML document formats with the 
extensions docx, xlsx, and pptx. The same versions can also run some Excel Visual Basic scripts, if 
you enable this feature at <item type="menuitem"><switchinline select="sys"><caseinline 
select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - 
Options</defaultinline></switchinline> - Load/Save - VBA Properties</item>.</paragraph>
 <paragraph role="paragraph" id="par_id3155934" xml-lang="en-US" l10n="U" oldref="3">The following 
lists provide a general overview of Microsoft Office features that may cause conversion challenges. 
These will not affect your ability to use or work with the content of the converted 
document.</paragraph>
 <paragraph role="heading" id="hd_id3155892" xml-lang="en-US" level="2" l10n="U" 
oldref="6">Microsoft Word</paragraph>
 <list type="ordered">
diff --git a/helpcontent2/source/text/shared/guide/ms_user.xhp 
b/helpcontent2/source/text/shared/guide/ms_user.xhp
index 4be6b98..300b555 100644
--- a/helpcontent2/source/text/shared/guide/ms_user.xhp
+++ b/helpcontent2/source/text/shared/guide/ms_user.xhp
@@ -46,7 +46,7 @@
 </bookmark>
 <paragraph role="heading" id="hd_id3150789" xml-lang="en-US" level="1" l10n="U" 
oldref="30"><variable id="ms_user"><link href="text/shared/guide/ms_user.xhp" name="Using Microsoft 
Office and $[officename]">Using Microsoft Office and $[officename]</link>
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3152801" xml-lang="en-US" l10n="CHG" 
oldref="1">$[officename] can open and save documents in the Microsoft Office file formats. 
Microsoft Office Open XML formats can be read, but not saved.</paragraph>
+<paragraph role="paragraph" id="par_id3152801" xml-lang="en-US" l10n="CHG" 
oldref="1">$[officename] can open and save documents in the Microsoft Office file formats, 
including Microsoft Office Open XML formats.</paragraph>
 <paragraph role="heading" id="hd_id3145345" xml-lang="en-US" level="2" l10n="U" oldref="2">Opening 
a Microsoft Office File</paragraph>
 <list type="ordered">
 <listitem>
-- 
1.7.9.5

From 98b1e88f176707cd4f2baa79281122e800375175 Mon Sep 17 00:00:00 2001
From: Stanislav Horacek <stanislav.horacek@gmail.com>
Date: Mon, 2 Jul 2012 21:20:40 +0200
Subject: [PATCH 2/5] add right-click to edit a comment

---
 helpcontent2/source/text/shared/01/04050000.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/helpcontent2/source/text/shared/01/04050000.xhp 
b/helpcontent2/source/text/shared/01/04050000.xhp
index 1407612..bf36ea7 100644
--- a/helpcontent2/source/text/shared/01/04050000.xhp
+++ b/helpcontent2/source/text/shared/01/04050000.xhp
@@ -91,7 +91,7 @@
       <paragraph xml-lang="en-US" id="hd_id0915200910571612" role="heading" level="2" 
l10n="NEW">Comments in spreadsheets</paragraph>
       <paragraph xml-lang="en-US" id="par_id3166460" role="paragraph" l10n="CHG" oldref="6">When 
you attach a comment to a cell, a callout appears where you can enter your text. A small square in 
the upper right corner of a cell marks the position of a comment. To display the comment 
permanently, right-click the cell, and choose <emph>Show Comment</emph>.</paragraph>
       <paragraph xml-lang="en-US" id="par_id8336741" role="paragraph" l10n="NEW">To change the 
object properties of a comment, for example the background color, choose <emph>Show Comment</emph> 
as above, then right-click the comment (do not double-click the text).</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3155390" role="paragraph" l10n="CHG" oldref="7">To 
edit a shown comment, double-click the comment text. To edit a comment that is not shown 
permanently, click in the cell that contains the comment, and then choose <emph>Insert - 
Comment</emph>. To specify the formatting of the comment text, right-click the comment text in edit 
mode.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id3155390" role="paragraph" l10n="CHG" oldref="7">To 
edit a shown comment, double-click the comment text. To edit a comment that is not shown 
permanently, right-click in the cell that contains the comment, and then choose <emph>Insert - 
Comment</emph>. To specify the formatting of the comment text, right-click the comment text in edit 
mode.</paragraph>
       <paragraph xml-lang="en-US" id="par_idN107A1" role="paragraph" l10n="NEW">To change the 
position or size of a comment, drag a border or corner of the comment.</paragraph>
       <paragraph xml-lang="en-US" id="par_id9499496" role="paragraph" l10n="NEW">To delete a 
comment, right-click the cell, then choose <emph>Delete Comment</emph>.</paragraph>
       <paragraph xml-lang="en-US" id="par_id2036805" role="paragraph" l10n="NEW">You can also 
right-click a comment name in the Navigator window to choose some editing commands.</paragraph>
-- 
1.7.9.5

From 0551219dd5ea6e2023d5ea5923d8639a207dd49c Mon Sep 17 00:00:00 2001
From: Stanislav Horacek <stanislav.horacek@gmail.com>
Date: Mon, 2 Jul 2012 21:33:53 +0200
Subject: [PATCH 3/5] array elements instead of arguments

---
 helpcontent2/source/text/scalc/01/04060107.xhp |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/helpcontent2/source/text/scalc/01/04060107.xhp 
b/helpcontent2/source/text/scalc/01/04060107.xhp
index 5987129..ab6a0cb 100644
--- a/helpcontent2/source/text/scalc/01/04060107.xhp
+++ b/helpcontent2/source/text/scalc/01/04060107.xhp
@@ -1198,7 +1198,7 @@ for bug #i31051#</comment></paragraph>
 <paragraph role="heading" id="hd_id3163390" xml-lang="en-US" level="3" l10n="U" 
oldref="180">Syntax</paragraph>
 <paragraph role="code" id="par_id3163404" xml-lang="en-US" l10n="U" oldref="181">SUMX2PY2(ArrayX; 
ArrayY)</paragraph>
 <paragraph role="paragraph" id="par_id3163417" xml-lang="en-US" l10n="U" oldref="182">
-<emph>ArrayX</emph> represents the first array whose arguments are to be squared and 
added.</paragraph>
+<emph>ArrayX</emph> represents the first array whose elements are to be squared and 
added.</paragraph>
 <paragraph role="paragraph" id="par_id3163437" xml-lang="en-US" l10n="U" oldref="183">
 <emph>ArrayY</emph> represents the second array, whose elements are to be squared and 
added.</paragraph>
 <paragraph role="paragraph" id="par_idN11E45" xml-lang="en-US" l10n="NEW">
-- 
1.7.9.5

From f698ab2e3c0987cba3d4923169484bfcbcefd516 Mon Sep 17 00:00:00 2001
From: Stanislav Horacek <stanislav.horacek@gmail.com>
Date: Mon, 2 Jul 2012 21:53:27 +0200
Subject: [PATCH 4/5] fix typos

---
 helpcontent2/source/text/scalc/01/func_datedif.xhp |    6 +++---
 .../source/text/shared/01/xformsdatatab.xhp        |    2 +-
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/helpcontent2/source/text/scalc/01/func_datedif.xhp 
b/helpcontent2/source/text/scalc/01/func_datedif.xhp
index d4194d6..3719022 100644
--- a/helpcontent2/source/text/scalc/01/func_datedif.xhp
+++ b/helpcontent2/source/text/scalc/01/func_datedif.xhp
@@ -69,7 +69,7 @@
 <paragraph role="tablecontent" id="par_id9200109" xml-lang="en-US">"ym"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US">Number of whole months when 
substracting years from the difference of Start date and End date.</paragraph>
+<paragraph role="tablecontent" id="par_id4186223" xml-lang="en-US">Number of whole months when 
subtracting years from the difference of Start date and End date.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
@@ -77,7 +77,7 @@
 <paragraph role="tablecontent" id="par_id5766472" xml-lang="en-US">"md"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id1491134" xml-lang="en-US">Number of whole days when 
substracting years and months from the difference of Start date and End date.</paragraph>
+<paragraph role="tablecontent" id="par_id1491134" xml-lang="en-US">Number of whole days when 
subtracting years and months from the difference of Start date and End date.</paragraph>
 </tablecell>
 </tablerow>
 <tablerow>
@@ -85,7 +85,7 @@
 <paragraph role="tablecontent" id="par_id5866472" xml-lang="en-US">"yd"</paragraph>
 </tablecell>
 <tablecell>
-<paragraph role="tablecontent" id="par_id1591134" xml-lang="en-US">Number of whole days when 
substracting years from the difference of Start date and End date.</paragraph>
+<paragraph role="tablecontent" id="par_id1591134" xml-lang="en-US">Number of whole days when 
subtracting years from the difference of Start date and End date.</paragraph>
 </tablecell>
 </tablerow>
 </table>
diff --git a/helpcontent2/source/text/shared/01/xformsdatatab.xhp 
b/helpcontent2/source/text/shared/01/xformsdatatab.xhp
index dd2c541..ce7c45d 100644
--- a/helpcontent2/source/text/shared/01/xformsdatatab.xhp
+++ b/helpcontent2/source/text/shared/01/xformsdatatab.xhp
@@ -82,7 +82,7 @@
       <paragraph xml-lang="en-US" id="par_id4071779" role="note" l10n="NEW">The following lists 
all facets that are valid for data types. Some facets are only available for some data 
types.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_XSD_WHITESPACES" id="bm_id7074190" 
localize="false"/>
 <paragraph xml-lang="en-US" id="hd_id4313791" role="heading" level="3" 
l10n="NEW">Whitespaces</paragraph>
-      <paragraph xml-lang="en-US" id="par_id4331797" role="paragraph" l10n="NEW"><ahelp 
hid=".">Specifies how whitespaces are to be handled when a string of the current data type is being 
processed. Possible values are Preserve, Replace, and Collapse. The sematics follow the definition 
at http://www.w3.org/TR/xmlschema-2/#rf-whiteSpace.</ahelp></paragraph>
+      <paragraph xml-lang="en-US" id="par_id4331797" role="paragraph" l10n="NEW"><ahelp 
hid=".">Specifies how whitespaces are to be handled when a string of the current data type is being 
processed. Possible values are Preserve, Replace, and Collapse. The semantics follow the definition 
at http://www.w3.org/TR/xmlschema-2/#rf-whiteSpace.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/EXTENSIONS_HID_PROP_XSD_PATTERN" id="bm_id5452436" 
localize="false"/>
 <paragraph xml-lang="en-US" id="hd_id4191717" role="heading" level="3" 
l10n="NEW">Pattern</paragraph>
       <paragraph xml-lang="en-US" id="par_id2318796" role="paragraph" l10n="NEW"><ahelp 
hid=".">Specifies a regular expression pattern. Strings validated against the data type must 
conform to this pattern to be valid. The XSD data type syntax for regular expressions is different 
from the regular expression syntax used elseswhere in %PRODUCTNAME, for example in the Find &amp; 
Replace dialog.</ahelp></paragraph>
-- 
1.7.9.5

From 0f3a1351f34d2fae597ef2f31361e940e7ffb265 Mon Sep 17 00:00:00 2001
From: Stanislav Horacek <stanislav.horacek@gmail.com>
Date: Mon, 2 Jul 2012 22:00:40 +0200
Subject: [PATCH 5/5] add complete names of areas in pivot table

---
 .../text/scalc/guide/datapilot_createtable.xhp     |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp 
b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp
index 1ef495f..18333e0 100644
--- a/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp
+++ b/helpcontent2/source/text/scalc/guide/datapilot_createtable.xhp
@@ -72,7 +72,7 @@
             <paragraph xml-lang="en-US" id="par_id3153714" role="listitem" l10n="U" 
oldref="14">Remove a button by dragging it back to the area of the other buttons at the right of 
the dialog.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3147338" role="listitem" l10n="U" oldref="15">To 
open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> 
dialog, double-click one of the buttons in the <emph>Row</emph> or <emph>Column</emph> area. Use 
the dialog to select if and to what extent <item type="productname">%PRODUCTNAME</item> calculates 
display subtotals.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3147338" role="listitem" l10n="U" oldref="15">To 
open the <link href="text/scalc/01/12090105.xhp" name="Data Field"><emph>Data Field</emph></link> 
dialog, double-click one of the buttons in the <emph>Row Fields</emph> or <emph>Column 
Fields</emph> area. Use the dialog to select if and to what extent <item 
type="productname">%PRODUCTNAME</item> calculates display subtotals.</paragraph>
          </listitem>
       </list>
       <paragraph xml-lang="en-US" id="par_id3154020" role="paragraph" l10n="CHG" oldref="18">Exit 
the Pivot Table dialog by pressing OK. A <emph>Filter</emph> button will now be inserted, or a page 
button for every data field that you dropped in the <emph>Page Fields</emph> area. The pivot table 
is inserted further down.</paragraph>
-- 
1.7.9.5