Source string Source string

Context English Actions
webquery.xhp
par_id3150205
help.text
In the target document open the Navigator.
webquery.xhp
par_id3152990
help.text
In the lower combo box of the Navigator select the source document. The Navigator now shows the range names and database ranges or the tables contained in the source document.
webquery.xhp
par_id3148842
help.text
In the Navigator select the <emph>Insert as link</emph> drag mode <image id="img_id3152985" src="sw/res/sc20238.png" width="0.222inch" height="0.222inch"><alt id="alt_id3152985">Icon</alt></image>.
webquery.xhp
par_id3157978
help.text
Drag the desired external data from the Navigator into the target document.
webquery.xhp
par_id3144768
help.text
If you have loaded an HTML document with the <emph>Web Page Query</emph> filter as the source document, you will find the tables in the Navigator, named continuously from "HTML_table1" onwards, and also two range names that have been created:
webquery.xhp
par_id3152873
help.text
<item type="literal">HTML_all</item> - designates the entire document
webquery.xhp
par_id3149897
help.text
<item type="literal">HTML_tables</item> - designates all HTML tables in the document
webquery.xhp
hd_id3149126
help.text
Editing the external data
webquery.xhp
par_id3159228
help.text
Open <emph>Edit - Links</emph>. Here you can edit the link to the external data.
webquery.xhp
par_id3154650
help.text
<link href="text/scalc/01/04090000.xhp" name="External data dialog">External data dialog</link>
year2000.xhp
tit
help.text
19xx/20xx Years
year2000.xhp
bm_id3150439
help.text
<bookmark_value>years; 2-digits</bookmark_value><bookmark_value>dates; 19xx/20xx</bookmark_value>
year2000.xhp
hd_id3150439
help.text
<variable id="year2000"><link href="text/scalc/guide/year2000.xhp" name="19xx/20xx Years">19xx/20xx Years</link></variable>
year2000.xhp
par_id3151116
help.text
The year in a date entry is often entered as two digits. Internally, the year is managed by $[officename] as four digits, so that in the calculation of the difference from 1/1/99 to 1/1/01, the result will correctly be two years.
year2000.xhp
par_id3154011
help.text
Under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - $[officename] - General</emph> you can define the century that is used when you enter a year with only two digits. The default is 1930 to 2029.
year2000.xhp
par_id3150010
help.text
This means that if you enter a date of 1/1/30 or higher, it will be treated internally as 1/1/1930 or higher. All lower two-digit years apply to the 20xx century. So, for example, 1/1/20 is converted into 1/1/2020.

Loading…

No matching activity found.
Browse all component changes

Glossary

English English
No related strings found in the glossary.

String information

Context
year2000.xhp
par_id3150010
help.text
Source string description
zB3Ff
Flags
read-only
Source string location
year2000.xhp
String age
a year ago
Source string age
a year ago
Translation file
templates/helpcontent2/source/text/scalc/guide.pot, string 1480