diff options
| author | Gabor Kelemen <kelemeng@gnome.hu> | 2016-09-15 13:56:20 +0200 |
|---|---|---|
| committer | Michael Stahl <mstahl@redhat.com> | 2016-09-15 14:46:28 +0000 |
| commit | 2251478b3e1440a5a0b1928dc492e15f679fca49 (patch) | |
| tree | 35122ffdadb17a82327d8e8a228e661a031b9f0f /source/text/scalc/01 | |
| parent | eb949d8e2f087ea0358719948e75a4aeacddd74f (diff) | |
Change file extensions in examples: sxw -> odt, sxc -> ods
Some examples still used the old StarOffice extensions.
Change-Id: Id6f7a28f0ff8511181f3641d8ad9f6f5896cef68
Reviewed-on: https://gerrit.libreoffice.org/28925
Reviewed-by: Michael Stahl <mstahl@redhat.com>
Tested-by: Michael Stahl <mstahl@redhat.com>
Diffstat (limited to 'source/text/scalc/01')
| -rw-r--r-- | source/text/scalc/01/04060104.xhp | 8 | ||||
| -rw-r--r-- | source/text/scalc/01/04060109.xhp | 4 |
2 files changed, 6 insertions, 6 deletions
diff --git a/source/text/scalc/01/04060104.xhp b/source/text/scalc/01/04060104.xhp index 943a5caf89..116f54e547 100644 --- a/source/text/scalc/01/04060104.xhp +++ b/source/text/scalc/01/04060104.xhp @@ -723,7 +723,7 @@ <paragraph id="par_id3156054" role="tablecontent" xml-lang="en-US">Returns the absolute address of the referenced cell.</paragraph> <paragraph id="par_id3154136" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("ADDRESS";D2)</item> returns $D$2.</paragraph> <paragraph id="par_id3159198" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("ADDRESS";Sheet3.D2)</item> returns $Sheet3.$D$2.</paragraph> - <paragraph id="par_id3150245" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("ADDRESS";'X:\dr\test.sxc'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.sxc'#$Sheet1.$D$2.</paragraph> + <paragraph id="par_id3150245" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("ADDRESS";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.$D$2.</paragraph> </tablecell> </tablerow> <tablerow> @@ -732,8 +732,8 @@ </tablecell> <tablecell> <paragraph id="par_id3151328" role="tablecontent" xml-lang="en-US">Returns the file name and the sheet number of the referenced cell.</paragraph> - <paragraph id="par_id3148896" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("FILENAME";D2)</item> returns 'file:///X:/dr/own.sxc'#$Sheet1, if the formula in the current document X:\dr\own.sxc is located in Sheet1.</paragraph> - <paragraph id="par_id3155144" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("FILENAME";'X:\dr\test.sxc'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.sxc'#$Sheet1.</paragraph> + <paragraph id="par_id3148896" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("FILENAME";D2)</item> returns 'file:///X:/dr/own.ods'#$Sheet1, if the formula in the current document X:\dr\own.ods is located in Sheet1.</paragraph> + <paragraph id="par_id3155144" role="tablecontent" xml-lang="en-US"><item type="input">=CELL("FILENAME";'X:\dr\test.ods'#$Sheet1.D2)</item> returns 'file:///X:/dr/test.ods'#$Sheet1.</paragraph> </tablecell> </tablerow> <tablerow> @@ -848,4 +848,4 @@ </section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/scalc/01/04060109.xhp b/source/text/scalc/01/04060109.xhp index 3f6442c408..a2d98d34bd 100644 --- a/source/text/scalc/01/04060109.xhp +++ b/source/text/scalc/01/04060109.xhp @@ -156,9 +156,9 @@ <paragraph xml-lang="en-US" id="hd_id3149546" role="heading" level="3" l10n="U" oldref="35">Example</paragraph> <paragraph xml-lang="en-US" id="par_id3148734" role="paragraph" l10n="U" oldref="36"> - <item type="input">=DDE("soffice";"c:\office\document\data1.sxc";"sheet1.A1")</item> reads the contents of cell A1 in sheet1 of the <item type="productname">%PRODUCTNAME</item> Calc spreadsheet data1.sxc.</paragraph> + <item type="input">=DDE("soffice";"c:\office\document\data1.ods";"sheet1.A1")</item> reads the contents of cell A1 in sheet1 of the <item type="productname">%PRODUCTNAME</item> Calc spreadsheet data1.ods.</paragraph> <paragraph xml-lang="en-US" id="par_id3153081" role="paragraph" l10n="U" oldref="37"> - <item type="input">=DDE("soffice";"c:\office\document\motto.sxw";"Today's motto")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.sxw document containing the motto text and define it as the first line of a section named <item type="literal">Today's Motto</item> (in <item type="productname">%PRODUCTNAME</item> Writer under <emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type="productname">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type="productname">%PRODUCTNAME</item> Calc cells in which this DDE link is defined.</paragraph> + <item type="input">=DDE("soffice";"c:\office\document\motto.odt";"Today's motto")</item> returns a motto in the cell containing this formula. First, you must enter a line in the motto.odt document containing the motto text and define it as the first line of a section named <item type="literal">Today's Motto</item> (in <item type="productname">%PRODUCTNAME</item> Writer under <emph>Insert - Section</emph>). If the motto is modified (and saved) in the <item type="productname">%PRODUCTNAME</item> Writer document, the motto is updated in all <item type="productname">%PRODUCTNAME</item> Calc cells in which this DDE link is defined.</paragraph> </section> <section id="Section4"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153114"><bookmark_value>ERRORTYPE function</bookmark_value> |