Commits

Vladimir Glazunov  committed c32522c Merge

CWS-TOOLING: integrate CWS hcshared28

  • Participants
  • Parent commits d2172da, a80d24d

Comments (0)

Files changed (143)

File helpcontent2/source/auxiliary/swriter.tree

 
 			</node>
 		</node>
-		<node id="0203" title="Creating Text Documents">			
+		<node id="0203" title="Creating Text Documents">
 <topic id="swriter/text/swriter/guide/text_nav_keyb.xhp">Navigating and Selecting With the Keyboard</topic>
 <topic id="swriter/text/swriter/guide/text_direct_cursor.xhp">Using the Direct Cursor</topic>
 		</node>
 <topic id="swriter/text/swriter/guide/template_create.xhp">Creating a Document Template</topic>
 <topic id="swriter/text/swriter/guide/template_default.xhp">Changing the Default Template</topic>
 			</node>
+<topic id="swriter/text/swriter/guide/pageorientation.xhp">Landscape or Portrait Pages</topic>
 <topic id="swriter/text/swriter/guide/text_capital.xhp">Changing the Case of Text</topic>
 <topic id="swriter/text/swriter/guide/hidden_text.xhp">Hiding Text</topic>
 <topic id="swriter/text/swriter/guide/header_pagestyles.xhp">Defining Different Headers and Footers</topic>

File helpcontent2/source/text/sbasic/shared/00000003.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsbasicshared00000003xml" indexer="exclude" status="PUBLISH">
 
 </section>
 <section id="errorcode">
-<paragraph role="heading" id="hd_id3152869" xml-lang="en-US" level="2" l10n="U" oldref="37"><variable id="errorcode">Error Codes 
+<paragraph role="heading" id="hd_id3152869" xml-lang="en-US" level="2" l10n="U" oldref="37"><variable id="errorcode">Error Codes
 </variable></paragraph>
 </section>
 <section id="allerrors">
-<paragraph role="paragraph" id="par_id3155095" xml-lang="en-US" l10n="U" oldref="38"><variable id="err2">2 Unspecified syntax error 
+<paragraph role="paragraph" id="par_id315509599" xml-lang="en-US" l10n="NEW"><variable id="err1">1 An exception occurred
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149126" xml-lang="en-US" l10n="U" oldref="39"><variable id="err3">3 Return without Gosub 
+<paragraph role="paragraph" id="par_id3155095" xml-lang="en-US" l10n="CHG" oldref="38"><variable id="err2">2 Syntax error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153976" xml-lang="en-US" l10n="U" oldref="40"><variable id="err4">4 Redo from start 
+<paragraph role="paragraph" id="par_id3149126" xml-lang="en-US" l10n="U" oldref="39"><variable id="err3">3 Return without Gosub
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150891" xml-lang="en-US" l10n="U" oldref="41"><variable id="err5">5 Invalid procedure call 
+<paragraph role="paragraph" id="par_id3153976" xml-lang="en-US" l10n="CHG" oldref="40"><variable id="err4">4 Incorrect entry; please retry
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3159227" xml-lang="en-US" l10n="U" oldref="42"><variable id="err6">6 Overflow 
+<paragraph role="paragraph" id="par_id3150891" xml-lang="en-US" l10n="U" oldref="41"><variable id="err5">5 Invalid procedure call
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154649" xml-lang="en-US" l10n="U" oldref="43"><variable id="err7">7 Out of memory 
+<paragraph role="paragraph" id="par_id3159227" xml-lang="en-US" l10n="U" oldref="42"><variable id="err6">6 Overflow
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150050" xml-lang="en-US" l10n="U" oldref="44"><variable id="err8">8 Array already dimensioned 
+<paragraph role="paragraph" id="par_id3154649" xml-lang="en-US" l10n="CHG" oldref="43"><variable id="err7">7 Not enough memory
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148900" xml-lang="en-US" l10n="U" oldref="45"><variable id="err9">9 Subscript out of range 
+<paragraph role="paragraph" id="par_id3150050" xml-lang="en-US" l10n="U" oldref="44"><variable id="err8">8 Array already dimensioned
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153806" xml-lang="en-US" l10n="U" oldref="46"><variable id="err10">10 Duplicate definition 
+<paragraph role="paragraph" id="par_id3148900" xml-lang="en-US" l10n="CHG" oldref="45"><variable id="err9">9 Index out of defined range
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146963" xml-lang="en-US" l10n="U" oldref="47"><variable id="err11">11 Division by zero 
+<paragraph role="paragraph" id="par_id3153806" xml-lang="en-US" l10n="U" oldref="46"><variable id="err10">10 Duplicate definition
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153013" xml-lang="en-US" l10n="U" oldref="48"><variable id="err12">12 Variable undefined 
+<paragraph role="paragraph" id="par_id3146963" xml-lang="en-US" l10n="U" oldref="47"><variable id="err11">11 Division by zero
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3155593" xml-lang="en-US" l10n="U" oldref="49"><variable id="err13">13 Type mismatch 
+<paragraph role="paragraph" id="par_id3153013" xml-lang="en-US" l10n="CHG" oldref="48"><variable id="err12">12 Variable not defined
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3151197" xml-lang="en-US" l10n="U" oldref="50"><variable id="err14">14 Invalid parameter 
+<paragraph role="paragraph" id="par_id3155593" xml-lang="en-US" l10n="U" oldref="49"><variable id="err13">13 Data type mismatch
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154710" xml-lang="en-US" l10n="U" oldref="51"><variable id="err18">18 User interrupt occurred 
+<paragraph role="paragraph" id="par_id3151197" xml-lang="en-US" l10n="U" oldref="50"><variable id="err14">14 Invalid parameter
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147504" xml-lang="en-US" l10n="U" oldref="52"><variable id="err20">20 Resume without error 
+<paragraph role="paragraph" id="par_id3154710" xml-lang="en-US" l10n="CHG" oldref="51"><variable id="err18">18 Process interrupted by user
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3145319" xml-lang="en-US" l10n="U" oldref="53"><variable id="err28">28 Out of stack space 
+<paragraph role="paragraph" id="par_id3147504" xml-lang="en-US" l10n="U" oldref="52"><variable id="err20">20 Resume without error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146110" xml-lang="en-US" l10n="U" oldref="54"><variable id="err35">35 Sub or Function not defined 
+<paragraph role="paragraph" id="par_id3145319" xml-lang="en-US" l10n="CHG" oldref="53"><variable id="err28">28 Not enough stack memory
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147246" xml-lang="en-US" l10n="U" oldref="55"><variable id="err48">48 Error in loading DLL 
+<paragraph role="paragraph" id="par_id3146110" xml-lang="en-US" l10n="CHG" oldref="54"><variable id="err35">35 Sub-procedure or function procedure not defined
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146101" xml-lang="en-US" l10n="U" oldref="56"><variable id="err49">49 Bad DLL calling convention 
+<paragraph role="paragraph" id="par_id3147246" xml-lang="en-US" l10n="CHG" oldref="55"><variable id="err48">48 Error loading DLL file
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153957" xml-lang="en-US" l10n="U" oldref="57"><variable id="err51">51 Internal error 
+<paragraph role="paragraph" id="par_id3146101" xml-lang="en-US" l10n="CHG" oldref="56"><variable id="err49">49 Wrong DLL call convention
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154404" xml-lang="en-US" l10n="U" oldref="58"><variable id="err52">52 Bad file name or number 
+<paragraph role="paragraph" id="par_id3153957" xml-lang="en-US" l10n="U" oldref="57"><variable id="err51">51 Internal error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3151338" xml-lang="en-US" l10n="U" oldref="59"><variable id="err53">53 File not found 
+<paragraph role="paragraph" id="par_id3154404" xml-lang="en-US" l10n="CHG" oldref="58"><variable id="err52">52 Invalid file name or file number
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147298" xml-lang="en-US" l10n="U" oldref="60"><variable id="err54">54 Bad file mode 
+<paragraph role="paragraph" id="par_id3151338" xml-lang="en-US" l10n="U" oldref="59"><variable id="err53">53 File not found
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148747" xml-lang="en-US" l10n="U" oldref="61"><variable id="err55">55 File already open 
+<paragraph role="paragraph" id="par_id3147298" xml-lang="en-US" l10n="U" oldref="60"><variable id="err54">54 Incorrect file mode
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3145233" xml-lang="en-US" l10n="U" oldref="62"><variable id="err57">57 Device I/O error 
+<paragraph role="paragraph" id="par_id3148747" xml-lang="en-US" l10n="U" oldref="61"><variable id="err55">55 File already open
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3156399" xml-lang="en-US" l10n="U" oldref="63"><variable id="err58">58 File already exists 
+<paragraph role="paragraph" id="par_id3145233" xml-lang="en-US" l10n="U" oldref="62"><variable id="err57">57 Device I/O error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149324" xml-lang="en-US" l10n="U" oldref="64"><variable id="err59">59 Bad record length 
+<paragraph role="paragraph" id="par_id3156399" xml-lang="en-US" l10n="U" oldref="63"><variable id="err58">58 File already exists
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147409" xml-lang="en-US" l10n="U" oldref="65"><variable id="err61">61 Disk full 
+<paragraph role="paragraph" id="par_id3149324" xml-lang="en-US" l10n="CHG" oldref="64"><variable id="err59">59 Incorrect record length
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149146" xml-lang="en-US" l10n="U" oldref="66"><variable id="err62">62 Input past end of file 
+<paragraph role="paragraph" id="par_id3147409" xml-lang="en-US" l10n="CHG" oldref="65"><variable id="err61">61 Disk or hard drive full
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150456" xml-lang="en-US" l10n="U" oldref="67"><variable id="err63">63 Bad record number 
+<paragraph role="paragraph" id="par_id3149146" xml-lang="en-US" l10n="CHG" oldref="66"><variable id="err62">62 Reading exceeds EOF
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146883" xml-lang="en-US" l10n="U" oldref="68"><variable id="err67">67 Too many files 
+<paragraph role="paragraph" id="par_id3150456" xml-lang="en-US" l10n="CHG" oldref="67"><variable id="err63">63 Incorrect record number
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146818" xml-lang="en-US" l10n="U" oldref="69"><variable id="err68">68 Device not available 
+<paragraph role="paragraph" id="par_id3146883" xml-lang="en-US" l10n="U" oldref="68"><variable id="err67">67 Too many files
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3145225" xml-lang="en-US" l10n="U" oldref="70"><variable id="err70">70 Permission denied 
+<paragraph role="paragraph" id="par_id3146818" xml-lang="en-US" l10n="U" oldref="69"><variable id="err68">68 Device not available
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150372" xml-lang="en-US" l10n="U" oldref="71"><variable id="err71">71 Disk not ready 
+<paragraph role="paragraph" id="par_id3145225" xml-lang="en-US" l10n="CHG" oldref="70"><variable id="err70">70 Access denied
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148894" xml-lang="en-US" l10n="U" oldref="72"><variable id="err73">73 Feature not implemented 
+<paragraph role="paragraph" id="par_id3150372" xml-lang="en-US" l10n="U" oldref="71"><variable id="err71">71 Disk not ready
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3152981" xml-lang="en-US" l10n="U" oldref="73"><variable id="err74">74 No rename with different drive 
+<paragraph role="paragraph" id="par_id3148894" xml-lang="en-US" l10n="CHG" oldref="72"><variable id="err73">73 Not implemented
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149355" xml-lang="en-US" l10n="U" oldref="74"><variable id="err75">75 Path/file access error 
+<paragraph role="paragraph" id="par_id3152981" xml-lang="en-US" l10n="CHG" oldref="73"><variable id="err74">74 Renaming on different drives impossible
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150477" xml-lang="en-US" l10n="U" oldref="75"><variable id="err76">76 Path not found 
+<paragraph role="paragraph" id="par_id3149355" xml-lang="en-US" l10n="U" oldref="74"><variable id="err75">75 Path/file access error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154678" xml-lang="en-US" l10n="U" oldref="76"><variable id="err91">91 Object variable not set 
+<paragraph role="paragraph" id="par_id3150477" xml-lang="en-US" l10n="U" oldref="75"><variable id="err76">76 Path not found
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149890" xml-lang="en-US" l10n="U" oldref="77"><variable id="err93">93 Invalid pattern string 
+<paragraph role="paragraph" id="par_id3154678" xml-lang="en-US" l10n="U" oldref="76"><variable id="err91">91 Object variable not set
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146942" xml-lang="en-US" l10n="U" oldref="78"><variable id="err94">94 Invalid use of Null 
+<paragraph role="paragraph" id="par_id3149890" xml-lang="en-US" l10n="CHG" oldref="77"><variable id="err93">93 Invalid string pattern
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150028" xml-lang="en-US" l10n="U" oldref="79"><variable id="err323">323 Can't load module 
+<paragraph role="paragraph" id="par_id3146942" xml-lang="en-US" l10n="CHG" oldref="78"><variable id="err94">94 Use of zero not permitted
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148434" xml-lang="en-US" l10n="U" oldref="80"><variable id="err341">341 Invalid object index 
+<paragraph role="paragraph" id="par_id31469429" xml-lang="en-US" l10n="NEW"><variable id="err250">250 DDE Error
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3143219" xml-lang="en-US" l10n="U" oldref="81"><variable id="err366">366 No active view or document 
+<paragraph role="paragraph" id="par_id31469428" xml-lang="en-US" l10n="NEW"><variable id="err280">280 Awaiting response to DDE connection
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3144744" xml-lang="en-US" l10n="U" oldref="82"><variable id="err380">380 Bad property value 
+<paragraph role="paragraph" id="par_id31469427" xml-lang="en-US" l10n="NEW"><variable id="err281">281 No DDE channels available
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147420" xml-lang="en-US" l10n="U" oldref="83"><variable id="err382">382 Property is read only 
+<paragraph role="paragraph" id="par_id31469426" xml-lang="en-US" l10n="NEW"><variable id="err282">282 No application responded to DDE connect initiation
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3147472" xml-lang="en-US" l10n="U" oldref="84"><variable id="err394">394 Property is write only 
+<paragraph role="paragraph" id="par_id31469425" xml-lang="en-US" l10n="NEW"><variable id="err283">283 Too many applications responded to DDE connect initiation
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148583" xml-lang="en-US" l10n="U" oldref="85"><variable id="err420">420 Invalid object reference 
+<paragraph role="paragraph" id="par_id31469424" xml-lang="en-US" l10n="NEW"><variable id="err284">284 DDE channel locked
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3153329" xml-lang="en-US" l10n="U" oldref="86"><variable id="err423">423 Property or method not found 
+<paragraph role="paragraph" id="par_id31469423" xml-lang="en-US" l10n="NEW"><variable id="err285">285 External application cannot execute DDE operation
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3148738" xml-lang="en-US" l10n="U" oldref="87"><variable id="err424">424 Object required 
+<paragraph role="paragraph" id="par_id31469422" xml-lang="en-US" l10n="NEW"><variable id="err286">286 Timeout while waiting for DDE response
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3159084" xml-lang="en-US" l10n="U" oldref="88"><variable id="err425">425 Invalid use of object 
+<paragraph role="paragraph" id="par_id31469421" xml-lang="en-US" l10n="NEW"><variable id="err287">287 user pressed ESCAPE during DDE operation
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146806" xml-lang="en-US" l10n="U" oldref="89"><variable id="err430">430 Class does not support OLE 
+<paragraph role="paragraph" id="par_id31469420" xml-lang="en-US" l10n="NEW"><variable id="err288">288 External application busy
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146130" xml-lang="en-US" l10n="U" oldref="90"><variable id="err438">438 Object doesn't support method 
+<paragraph role="paragraph" id="par_id31469419" xml-lang="en-US" l10n="NEW"><variable id="err289">289 DDE operation without data
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154374" xml-lang="en-US" l10n="U" oldref="91"><variable id="err440">440 OLE automation error 
+<paragraph role="paragraph" id="par_id31469418" xml-lang="en-US" l10n="NEW"><variable id="err290">290 Data are in wrong format
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149685" xml-lang="en-US" l10n="U" oldref="92"><variable id="err445">445 Object doesn't support this action 
+<paragraph role="paragraph" id="par_id31469417" xml-lang="en-US" l10n="NEW"><variable id="err291">291 External application has been terminated
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150282" xml-lang="en-US" l10n="U" oldref="93"><variable id="err446">446 Object doesn't support named args 
+<paragraph role="paragraph" id="par_id31469416" xml-lang="en-US" l10n="NEW"><variable id="err292">292 DDE connection interrupted or modified
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3150142" xml-lang="en-US" l10n="U" oldref="94"><variable id="err447">447 Object doesn't support current locale setting 
+<paragraph role="paragraph" id="par_id31469415" xml-lang="en-US" l10n="NEW"><variable id="err293">293 DDE method invoked with no channel open
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3152771" xml-lang="en-US" l10n="U" oldref="95"><variable id="err448">448 Named argument not found 
+<paragraph role="paragraph" id="par_id31469414" xml-lang="en-US" l10n="NEW"><variable id="err294">294 Invalid DDE link format
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3145145" xml-lang="en-US" l10n="U" oldref="96"><variable id="err449">449 Argument not optional 
+<paragraph role="paragraph" id="par_id31469413" xml-lang="en-US" l10n="NEW"><variable id="err295">295 DDE message has been lost
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154399" xml-lang="en-US" l10n="U" oldref="97"><variable id="err450">450 Wrong number of arguments 
+<paragraph role="paragraph" id="par_id31469412" xml-lang="en-US" l10n="NEW"><variable id="err296">296 Paste link already performed
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3146137" xml-lang="en-US" l10n="U" oldref="98"><variable id="err451">451 Object not a collection 
+<paragraph role="paragraph" id="par_id31469411" xml-lang="en-US" l10n="NEW"><variable id="err297">297 Link mode cannot be set due to invalid link topic
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="U" oldref="99"><variable id="err452">452 Invalid ordinal 
+<paragraph role="paragraph" id="par_id31469410" xml-lang="en-US" l10n="NEW"><variable id="err298">298 DDE requires the DDEML.DLL file
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3154566" xml-lang="en-US" l10n="U" oldref="100"><variable id="err453">453 Specified DLL function not found 
+<paragraph role="paragraph" id="par_id3150028" xml-lang="en-US" l10n="CHG" oldref="79"><variable id="err323">323 Module cannot be loaded; invalid format
 </variable></paragraph>
-<paragraph role="paragraph" id="par_id3145595" xml-lang="en-US" l10n="U" oldref="101"><variable id="err460">460 Invalid clipboard format 
+<paragraph role="paragraph" id="par_id3148434" xml-lang="en-US" l10n="U" oldref="80"><variable id="err341">341 Invalid object index
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3143219" xml-lang="en-US" l10n="CHG" oldref="81"><variable id="err366">366 Object is not available
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3144744" xml-lang="en-US" l10n="CHG" oldref="82"><variable id="err380">380 Incorrect property value
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147420" xml-lang="en-US" l10n="CHG" oldref="83"><variable id="err382">382 This property is read-only
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3147472" xml-lang="en-US" l10n="CHG" oldref="84"><variable id="err394">394 This property is write-only
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3148583" xml-lang="en-US" l10n="U" oldref="85"><variable id="err420">420 Invalid object reference
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3153329" xml-lang="en-US" l10n="U" oldref="86"><variable id="err423">423 Property or method not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3148738" xml-lang="en-US" l10n="U" oldref="87"><variable id="err424">424 Object required
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3159084" xml-lang="en-US" l10n="CHG" oldref="88"><variable id="err425">425 Invalid use of an object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146806" xml-lang="en-US" l10n="CHG" oldref="89"><variable id="err430">430 OLE Automation is not supported by this object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146130" xml-lang="en-US" l10n="CHG" oldref="90"><variable id="err438">438 This property or method is not supported by the object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154374" xml-lang="en-US" l10n="U" oldref="91"><variable id="err440">440 OLE automation error
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149685" xml-lang="en-US" l10n="CHG" oldref="92"><variable id="err445">445 This action is not supported by given object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150282" xml-lang="en-US" l10n="CHG" oldref="93"><variable id="err446">446 Named arguments are not supported by given object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3150142" xml-lang="en-US" l10n="CHG" oldref="94"><variable id="err447">447 The current locale setting is not supported by the given object
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3152771" xml-lang="en-US" l10n="U" oldref="95"><variable id="err448">448 Named argument not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145145" xml-lang="en-US" l10n="CHG" oldref="96"><variable id="err449">449 Argument is not optional
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154399" xml-lang="en-US" l10n="CHG" oldref="97"><variable id="err450">450 Invalid number of arguments
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3146137" xml-lang="en-US" l10n="CHG" oldref="98"><variable id="err451">451 Object is not a list
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3149507" xml-lang="en-US" l10n="CHG" oldref="99"><variable id="err452">452 Invalid ordinal number
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3154566" xml-lang="en-US" l10n="U" oldref="100"><variable id="err453">453 Specified DLL function not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id3145595" xml-lang="en-US" l10n="U" oldref="101"><variable id="err460">460 Invalid clipboard format
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455951" xml-lang="en-US" l10n="NEW"><variable id="err951">951 Unexpected symbol:
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455952" xml-lang="en-US" l10n="NEW"><variable id="err952">952 Expected:
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455953" xml-lang="en-US" l10n="NEW"><variable id="err953">953 Symbol expected
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455954" xml-lang="en-US" l10n="NEW"><variable id="err954">954 Variable expected
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455955" xml-lang="en-US" l10n="NEW"><variable id="err955">955 Label expected
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455956" xml-lang="en-US" l10n="NEW"><variable id="err956">956 Value cannot be applied
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455957" xml-lang="en-US" l10n="NEW"><variable id="err957">957 Variable already defined
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455958" xml-lang="en-US" l10n="NEW"><variable id="err958">958 Sub procedure or function procedure already defined
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455959" xml-lang="en-US" l10n="NEW"><variable id="err959">959 Label already defined
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455960" xml-lang="en-US" l10n="NEW"><variable id="err960">960 Variable not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455961" xml-lang="en-US" l10n="NEW"><variable id="err961">961 Array or procedure not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455962" xml-lang="en-US" l10n="NEW"><variable id="err962">962 Procedure not found
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455963" xml-lang="en-US" l10n="NEW"><variable id="err963">963 Label undefined
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455964" xml-lang="en-US" l10n="NEW"><variable id="err964">964 Unknown data type
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455965" xml-lang="en-US" l10n="NEW"><variable id="err965">965 Exit expected
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455966" xml-lang="en-US" l10n="NEW"><variable id="err966">966 Statement block still open: missing
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455967" xml-lang="en-US" l10n="NEW"><variable id="err967">967 Parentheses do not match
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455968" xml-lang="en-US" l10n="NEW"><variable id="err968">968 Symbol already defined differently
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455969" xml-lang="en-US" l10n="NEW"><variable id="err969">969 Parameters do not correspond to procedure
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455970" xml-lang="en-US" l10n="NEW"><variable id="err970">970 Invalid character in number
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455971" xml-lang="en-US" l10n="NEW"><variable id="err971">971 Array must be dimensioned
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455972" xml-lang="en-US" l10n="NEW"><variable id="err972">972 Else/Endif without If
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455973" xml-lang="en-US" l10n="NEW"><variable id="err973">973  not allowed within a procedure
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455974" xml-lang="en-US" l10n="NEW"><variable id="err974">974  not allowed outside a procedure
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455975" xml-lang="en-US" l10n="NEW"><variable id="err975">975 Dimension specifications do not match
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455976" xml-lang="en-US" l10n="NEW"><variable id="err976">976 Unknown option:
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455977" xml-lang="en-US" l10n="NEW"><variable id="err977">977 Constant redefined
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455978" xml-lang="en-US" l10n="NEW"><variable id="err978">978 Program too large
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455979" xml-lang="en-US" l10n="NEW"><variable id="err979">979 Strings or arrays not permitted
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455980" xml-lang="en-US" l10n="NEW"><variable id="err1000">1000 Object does not have this property
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455981" xml-lang="en-US" l10n="NEW"><variable id="err1001">1001 Object does not have this method
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455982" xml-lang="en-US" l10n="NEW"><variable id="err1002">1002 Required argument lacking
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455983" xml-lang="en-US" l10n="NEW"><variable id="err1003">1003 Invalid number of arguments
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455984" xml-lang="en-US" l10n="NEW"><variable id="err1004">1004 Error executing a method
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455985" xml-lang="en-US" l10n="NEW"><variable id="err1005">1005 Unable to set property
+</variable></paragraph>
+<paragraph role="paragraph" id="par_id31455986" xml-lang="en-US" l10n="NEW"><variable id="err1006">1006 Unable to determine property
 </variable></paragraph>
 </section>
 </body>

File helpcontent2/source/text/sbasic/shared/01010210.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
 <paragraph role="paragraph" id="par_id3156023" xml-lang="en-US" l10n="U" oldref="14">This section provides the fundamentals for working with $[officename] Basic.</paragraph>
 </section>
 <paragraph role="paragraph" id="par_id3147560" xml-lang="en-US" l10n="U" oldref="2">$[officename] Basic code is based on subroutines and functions that are specified between <emph>sub...end sub</emph> and <emph>function...end function</emph> sections. Each Sub or Function can call other Subs and Functions. If you take care to write generic code for a Sub or Function, you can probably re-use it in other programs. See also <link href="text/sbasic/shared/01020300.xhp" name="Procedures and Functions">Procedures and Functions</link>.</paragraph>
+
+<paragraph role="note" id="par_id314756320" xml-lang="en-US" l10n="NEW">Some restrictions apply for the names of your public variables, subs, and functions. You must not use the same name as one of the modules of the same library.</paragraph>
+
 <paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="2" l10n="U" oldref="3">What is a Sub?</paragraph>
 <paragraph role="paragraph" id="par_id3148797" xml-lang="en-US" l10n="U" oldref="4">
 <emph>Sub</emph> is the short form of <emph>subroutine</emph>, that is used to handle a certain task within a program. Subs are used to split a task into individual procedures. Splitting a program into procedures and sub-procedures enhances readability and reduces the error-proneness. A sub possibly takes some arguments as parameters but does not return any values back to the calling sub or function, for example:</paragraph>

File helpcontent2/source/text/sbasic/shared/01020300.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
 <paragraph role="paragraph" id="par_id3150767" xml-lang="en-US" l10n="U" oldref="2">The following describes the basic use of procedures and functions in $[officename] Basic.</paragraph>
 </section>
 <paragraph role="note" id="par_id3151215" xml-lang="en-US" l10n="U" oldref="56">When you create a new module, $[officename] Basic automatically inserts a SUB called "Main". This default name has nothing to do with the order or the starting point of a $[officename] Basic project. You can also safely rename this SUB.</paragraph>
+
+<paragraph role="note" id="par_id314756320" xml-lang="en-US" l10n="NEW">Some restrictions apply for the names of your public variables, subs, and functions. You must not use the same name as one of the modules of the same library.</paragraph>
+
 <paragraph role="paragraph" id="par_id3154124" xml-lang="en-US" l10n="U" oldref="3">Procedures (SUBS) and functions (FUNCTIONS) help you maintaining a structured overview by separating a program into logical pieces.</paragraph>
 <paragraph role="paragraph" id="par_id3153193" xml-lang="en-US" l10n="CHG" oldref="4">One benefit of procedures and functions is that, once you have developed a program code containing task components, you can use this code in another project.</paragraph>
 <paragraph role="heading" id="hd_id3153770" xml-lang="en-US" level="2" l10n="U" oldref="26">Passing Variables to Procedures (SUB) and Functions (FUNCTION)</paragraph>

File helpcontent2/source/text/sbasic/shared/03050500.xhp

 <title id="tit" xml-lang="en-US">On Error GoTo ... Resume Statement [Runtime]</title>
 <filename>/text/sbasic/shared/03050500.xhp</filename>
 </topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-24T14:11:12">converted from old format - fpe</lastedited>
-</history>
 </meta>
 <body>
 <section id="onerrorgotoresume">
 
 <paragraph role="paragraph" id="par_id3149483" xml-lang="en-US" l10n="U" oldref="9"><emph>Local:</emph> "On error" is global in scope, and remains active until canceled by another "On error" statement. "On Local error" is local to the routine which invokes it. Local error handling overrides any previous global setting. When the invoking routine exits, the local error handling is canceled automatically, and any previous global setting is restored.</paragraph>
 
-<paragraph role="paragraph" id="par_id3148619" xml-lang="en-US" l10n="U" oldref="10">The On Error GoTo statement is used to react to errors that occur in a macro. The statement must be inserted at the start of a procedure (in a local error-handling routine) or at the start of a module.</paragraph>
+<paragraph role="paragraph" id="par_id3148619" xml-lang="en-US" l10n="CGH" oldref="10">The On Error GoTo statement is used to react to errors that occur in a macro.<comment>ufi: see i112231: The statement must be inserted at the start of a procedure (in a local error-handling routine) or at the start of a module.</comment></paragraph>
 <paragraph role="heading" id="hd_id3146985" xml-lang="en-US" level="2" l10n="U" oldref="11">Example:</paragraph>
 <paragraph role="paragraph" id="par_id3152460" xml-lang="en-US" l10n="U" oldref="42">Sub ExampleReset</paragraph>
 <paragraph role="paragraph" id="par_id3163712" xml-lang="en-US" l10n="U" oldref="43">On Error Goto ErrorHandler</paragraph>

File helpcontent2/source/text/sbasic/shared/03080301.xhp

 <!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * for a copy of the LGPLv3 License.
  *
  ************************************************************************-->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsbasicshared03080301xml" indexer="include" status="PUBLISH">
 <title id="tit" xml-lang="en-US">Randomize Statement [Runtime]</title>
 <filename>/text/sbasic/shared/03080301.xhp</filename>
 </topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-24T14:07:35">converted from old format - fpe</lastedited>
-</history>
 </meta>
 <body>
 <section id="randomize">
 <paragraph role="heading" id="hd_id3147573" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph>
 <paragraph role="paragraph" id="par_id3145315" xml-lang="en-US" l10n="U" oldref="4">Randomize [Number]</paragraph>
 <paragraph role="heading" id="hd_id3152456" xml-lang="en-US" level="2" l10n="U" oldref="5">Parameters:</paragraph>
-<paragraph role="paragraph" id="par_id3149670" xml-lang="en-US" l10n="U" oldref="6">
-<emph>Number:</emph> Any integer value that initializes the random-number generator. If Number is omitted, the generator uses the current value of the system timer.</paragraph>
+<paragraph role="paragraph" id="par_id3149670" xml-lang="en-US" l10n="CHG" oldref="6">
+<emph>Number:</emph> Any integer value that initializes the random-number generator.</paragraph>
 <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
 <embed href="text/sbasic/shared/00000003.xhp#err5"/>
 <paragraph role="heading" id="hd_id3149655" xml-lang="en-US" level="2" l10n="U" oldref="7">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3151211" xml-lang="en-US" l10n="U" oldref="8">Sub ExampleRandomize</paragraph>
-<paragraph role="paragraph" id="par_id3147229" xml-lang="en-US" l10n="U" oldref="9">Dim iVar As Integer, sText As String</paragraph>
-<paragraph role="paragraph" id="par_id3150870" xml-lang="en-US" l10n="U" oldref="10">Dim iSpectral(10) As Integer</paragraph>
-<paragraph role="paragraph" id="par_id3148673" xml-lang="en-US" l10n="U" oldref="12">Randomize 2^14-1</paragraph>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="13">For iCount = 1 To 1000</paragraph>
-<paragraph role="paragraph" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="14">iVar = Int((10 * Rnd) ) REM Range from 0 to 9</paragraph>
-<paragraph role="paragraph" id="par_id3155132" xml-lang="en-US" l10n="U" oldref="15">iSpectral(iVar) = iSpectral(iVar) +1</paragraph>
-<paragraph role="paragraph" id="par_id3153143" xml-lang="en-US" l10n="U" oldref="16">Next iCount</paragraph>
-<paragraph role="paragraph" id="par_id3154011" xml-lang="en-US" l10n="U" oldref="18">sText = " | "</paragraph>
-<paragraph role="paragraph" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="19">For iCount = 0 To 9</paragraph>
-<paragraph role="paragraph" id="par_id3145748" xml-lang="en-US" l10n="U" oldref="20">sText = sText &amp; iSpectral(iCount) &amp; " | "</paragraph>
-<paragraph role="paragraph" id="par_id3146921" xml-lang="en-US" l10n="U" oldref="21">Next iCount</paragraph>
-<paragraph role="paragraph" id="par_id3148617" xml-lang="en-US" l10n="U" oldref="22">MsgBox sText,0,"Spectral Distribution"</paragraph>
-<paragraph role="paragraph" id="par_id3152941" xml-lang="en-US" l10n="U" oldref="23">end sub</paragraph>
+<paragraph role="code" id="par_id3151211" xml-lang="en-US" l10n="U" oldref="8">Sub ExampleRandomize</paragraph>
+<paragraph role="code" id="par_id3147229" xml-lang="en-US" l10n="U" oldref="9">Dim iVar As Integer, sText As String</paragraph>
+<paragraph role="code" id="par_id3150870" xml-lang="en-US" l10n="U" oldref="10">Dim iSpectral(10) As Integer</paragraph>
+<paragraph role="code" id="par_id3148673" xml-lang="en-US" l10n="U" oldref="12">Randomize 2^14-1</paragraph>
+<paragraph role="code" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="13">For iCount = 1 To 1000</paragraph>
+<paragraph role="code" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="14">iVar = Int((10 * Rnd) ) REM Range from 0 to 9</paragraph>
+<paragraph role="code" id="par_id3155132" xml-lang="en-US" l10n="U" oldref="15">iSpectral(iVar) = iSpectral(iVar) +1</paragraph>
+<paragraph role="code" id="par_id3153143" xml-lang="en-US" l10n="U" oldref="16">Next iCount</paragraph>
+<paragraph role="code" id="par_id3154011" xml-lang="en-US" l10n="U" oldref="18">sText = " | "</paragraph>
+<paragraph role="code" id="par_id3151114" xml-lang="en-US" l10n="U" oldref="19">For iCount = 0 To 9</paragraph>
+<paragraph role="code" id="par_id3145748" xml-lang="en-US" l10n="U" oldref="20">sText = sText &amp; iSpectral(iCount) &amp; " | "</paragraph>
+<paragraph role="code" id="par_id3146921" xml-lang="en-US" l10n="U" oldref="21">Next iCount</paragraph>
+<paragraph role="code" id="par_id3148617" xml-lang="en-US" l10n="U" oldref="22">MsgBox sText,0,"Spectral Distribution"</paragraph>
+<paragraph role="code" id="par_id3152941" xml-lang="en-US" l10n="U" oldref="23">end sub</paragraph>
 </body>
 </helpdocument>

File helpcontent2/source/text/sbasic/shared/03080302.xhp

 <!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * for a copy of the LGPLv3 License.
  *
  ************************************************************************-->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsbasicshared03080302xml" indexer="include" status="PUBLISH">
 <title id="tit" xml-lang="en-US">Rnd Function [Runtime]</title>
 <filename>/text/sbasic/shared/03080302.xhp</filename>
 </topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-24T14:16:16">converted from old format - fpe</lastedited>
-</history>
 </meta>
 <body>
 <section id="rnd">
 <paragraph role="paragraph" id="par_id3154365" xml-lang="en-US" l10n="U" oldref="6">Double</paragraph>
 <paragraph role="heading" id="hd_id3154909" xml-lang="en-US" level="2" l10n="U" oldref="7">Parameters:</paragraph>
 <paragraph role="paragraph" id="par_id3125864" xml-lang="en-US" l10n="U" oldref="8">
-<emph>Expression:</emph> Any numeric expression that defines how to generate random numbers.</paragraph>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U" oldref="9">
-<emph>Less than zero:</emph> Always returns the same random number.</paragraph>
-<paragraph role="paragraph" id="par_id3149560" xml-lang="en-US" l10n="U" oldref="10">
-<emph>Greater than zero:</emph> Returns the next random number in the sequence.</paragraph>
-<paragraph role="paragraph" id="par_id3148648" xml-lang="en-US" l10n="U" oldref="11">
-<emph>Zero:</emph> Returns the random number that was last generated.</paragraph>
+<emph>Expression:</emph> Any numeric expression.</paragraph>
 <paragraph role="paragraph" id="par_id3155306" xml-lang="en-US" l10n="U" oldref="12">
 <emph>Omitted:</emph> Returns the next random number in the sequence.</paragraph>
-<paragraph role="paragraph" id="par_id3153091" xml-lang="en-US" l10n="U" oldref="13">If the same number is passed for each successive call to the Rnd function, the same random-number sequence is generated. This is because the Expression parameter is used as a starting point for the next number.</paragraph>
 <paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="U" oldref="14">The <emph>Rnd</emph> function only returns values ranging from 0 to 1. To generate random integers in a given range, use the formula in the following example:</paragraph>
 <embed href="text/sbasic/shared/00000003.xhp#errorcode"/>
 <embed href="text/sbasic/shared/00000003.xhp#err5"/>
 <paragraph role="heading" id="hd_id3151118" xml-lang="en-US" level="2" l10n="U" oldref="15">Example:</paragraph>
-<paragraph role="paragraph" id="par_id3145365" xml-lang="en-US" l10n="U" oldref="16">Sub ExampleRandomSelect</paragraph>
-<paragraph role="paragraph" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="17">Dim iVar As Integer</paragraph>
-<paragraph role="paragraph" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="18">iVar = Int((15 * Rnd) -2)</paragraph>
-<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="19">Select Case iVar</paragraph>
-<paragraph role="paragraph" id="par_id3154097" xml-lang="en-US" l10n="U" oldref="20">Case 1 To 5</paragraph>
-<paragraph role="paragraph" id="par_id3147124" xml-lang="en-US" l10n="U" oldref="21">Print "Number from 1 to 5"</paragraph>
-<paragraph role="paragraph" id="par_id3155418" xml-lang="en-US" l10n="U" oldref="22">Case 6, 7, 8</paragraph>
-<paragraph role="paragraph" id="par_id3154943" xml-lang="en-US" l10n="U" oldref="23">Print "Number from 6 to 8"</paragraph>
-<paragraph role="paragraph" id="par_id3145800" xml-lang="en-US" l10n="U" oldref="24">Case Is &gt; 8 And iVar &lt; 11</paragraph>
-<paragraph role="paragraph" id="par_id3151074" xml-lang="en-US" l10n="U" oldref="25">Print "Greater than 8"</paragraph>
-<paragraph role="paragraph" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="26">Case Else</paragraph>
-<paragraph role="paragraph" id="par_id3155602" xml-lang="en-US" l10n="U" oldref="27">Print "Outside range 1 to 10"</paragraph>
-<paragraph role="paragraph" id="par_id3150328" xml-lang="en-US" l10n="U" oldref="28">End Select</paragraph>
-<paragraph role="paragraph" id="par_id3154479" xml-lang="en-US" l10n="U" oldref="29">end sub</paragraph>
+<paragraph role="code" id="par_id3145365" xml-lang="en-US" l10n="U" oldref="16">Sub ExampleRandomSelect</paragraph>
+<paragraph role="code" id="par_id3147426" xml-lang="en-US" l10n="U" oldref="17">Dim iVar As Integer</paragraph>
+<paragraph role="code" id="par_id3150011" xml-lang="en-US" l10n="U" oldref="18">iVar = Int((15 * Rnd) -2)</paragraph>
+<paragraph role="code" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="19">Select Case iVar</paragraph>
+<paragraph role="code" id="par_id3154097" xml-lang="en-US" l10n="U" oldref="20">Case 1 To 5</paragraph>
+<paragraph role="code" id="par_id3147124" xml-lang="en-US" l10n="U" oldref="21">Print "Number from 1 to 5"</paragraph>
+<paragraph role="code" id="par_id3155418" xml-lang="en-US" l10n="U" oldref="22">Case 6, 7, 8</paragraph>
+<paragraph role="code" id="par_id3154943" xml-lang="en-US" l10n="U" oldref="23">Print "Number from 6 to 8"</paragraph>
+<paragraph role="code" id="par_id3145800" xml-lang="en-US" l10n="U" oldref="24">Case Is &gt; 8 And iVar &lt; 11</paragraph>
+<paragraph role="code" id="par_id3151074" xml-lang="en-US" l10n="U" oldref="25">Print "Greater than 8"</paragraph>
+<paragraph role="code" id="par_id3154016" xml-lang="en-US" l10n="U" oldref="26">Case Else</paragraph>
+<paragraph role="code" id="par_id3155602" xml-lang="en-US" l10n="U" oldref="27">Print "Outside range 1 to 10"</paragraph>
+<paragraph role="code" id="par_id3150328" xml-lang="en-US" l10n="U" oldref="28">End Select</paragraph>
+<paragraph role="code" id="par_id3154479" xml-lang="en-US" l10n="U" oldref="29">end sub</paragraph>
 </body>
 </helpdocument>

File helpcontent2/source/text/sbasic/shared/03090201.xhp

 <!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * for a copy of the LGPLv3 License.
  *
  ************************************************************************-->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsbasicshared03090201xml" indexer="include" status="PUBLISH">
 <paragraph role="paragraph" id="par_id3154490" xml-lang="en-US" l10n="U" oldref="45">statements</paragraph>
 <paragraph role="paragraph" id="par_id3153159" xml-lang="en-US" l10n="U" oldref="46">Loop...</paragraph>
 <paragraph role="heading" id="hd_id3147396" xml-lang="en-US" level="2" l10n="U" oldref="47">Example</paragraph>
-<paragraph role="paragraph" id="par_id3144764" xml-lang="en-US" l10n="U" oldref="49">Sub ExampleDoLoop</paragraph>
-<paragraph role="paragraph" id="par_id3154791" xml-lang="en-US" l10n="U" oldref="50">Dim sFile As String</paragraph>
-<paragraph role="paragraph" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="51">Dim sPath As String</paragraph>
-<paragraph role="paragraph" id="par_id3155600" xml-lang="en-US" l10n="U" oldref="52">sPath = "c:\"</paragraph>
-<paragraph role="paragraph" id="par_id3150717" xml-lang="en-US" l10n="U" oldref="53">sFile = Dir$( sPath ,22)</paragraph>
-<paragraph role="paragraph" id="par_id3146898" xml-lang="en-US" l10n="U" oldref="54">If sFile &lt;&gt; "" Then</paragraph>
-<paragraph role="paragraph" id="par_id3156333" xml-lang="en-US" l10n="U" oldref="55">Do</paragraph>
-<paragraph role="paragraph" id="par_id3153947" xml-lang="en-US" l10n="U" oldref="56">MsgBox sFile</paragraph>
-<paragraph role="paragraph" id="par_id3150327" xml-lang="en-US" l10n="U" oldref="57">sFile = Dir$</paragraph>
-<paragraph role="paragraph" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="58">Loop Until sFile = ""</paragraph>
-<paragraph role="paragraph" id="par_id3153765" xml-lang="en-US" l10n="U" oldref="59">End If</paragraph>
-<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="60">End Sub</paragraph>
+<paragraph role="code" id="par_id3144764" xml-lang="en-US" l10n="U" oldref="49">Sub ExampleDoLoop</paragraph>
+<paragraph role="code" id="par_id3154791" xml-lang="en-US" l10n="U" oldref="50">Dim sFile As String</paragraph>
+<paragraph role="code" id="par_id3149401" xml-lang="en-US" l10n="U" oldref="51">Dim sPath As String</paragraph>
+<paragraph role="code" id="par_id3155600" xml-lang="en-US" l10n="U" oldref="52">sPath = "c:\"</paragraph>
+<paragraph role="code" id="par_id3150717" xml-lang="en-US" l10n="U" oldref="53">sFile = Dir$( sPath ,22)</paragraph>
+<paragraph role="code" id="par_id3146898" xml-lang="en-US" l10n="U" oldref="54">If sFile &lt;&gt; "" Then</paragraph>
+<paragraph role="code" id="par_id3156333" xml-lang="en-US" l10n="U" oldref="55">Do</paragraph>
+<paragraph role="code" id="par_id3153947" xml-lang="en-US" l10n="U" oldref="56">MsgBox sFile</paragraph>
+<paragraph role="code" id="par_id3150327" xml-lang="en-US" l10n="U" oldref="57">sFile = Dir$</paragraph>
+<paragraph role="code" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="58">Loop Until sFile = ""</paragraph>
+<paragraph role="code" id="par_id3153765" xml-lang="en-US" l10n="U" oldref="59">End If</paragraph>
+<paragraph role="code" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="60">End Sub</paragraph>
 </body>
 </helpdocument>

File helpcontent2/source/text/sbasic/shared/03132400.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
-	
+
 <helpdocument version="1.0">
 <meta>
 <topic id="textsbasicshared03132400xhp" indexer="include" status="PUBLISH">
 <title id="tit" xml-lang="en-US">CreateObject Function [Runtime]</title>
 <filename>/text/sbasic/shared/03132400.xhp</filename>
 </topic>
-<history>
-<created date="2004-10-27T14:19:46">CreateObject</created>
-<lastedited date="2006-10-27T12:41:06">yj: checked</lastedited>
-</history>
 </meta>
 <body>
 <section id="createobject">

File helpcontent2/source/text/scalc/01/02160000.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
 </topic>
 </meta>
 <body>
-  
-  
-  
+
+
+
 <bookmark xml-lang="en-US" branch="index" id="bm_id3153726"><bookmark_value>cells; deleting cells</bookmark_value>
 <bookmark_value>columns; deleting</bookmark_value>
 <bookmark_value>rows; deleting</bookmark_value>
 <bookmark_value>deleting;cells/rows/columns</bookmark_value>
 </bookmark>
   <comment>MW made one "deleting;" entry out of 3</comment>
-  
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteCell" id="bm_id512529" localize="false"/>
-  
+
 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteCell" id="bm_id3151115" localize="false"/>
   <paragraph xml-lang="en-US" id="hd_id3153726" role="heading" level="1" l10n="U" oldref="1">Delete Cells</paragraph>
-  <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph" l10n="U" oldref="2"><variable id="zellenloeschentext"><ahelp hid=".uno:DeleteCell">Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space.</ahelp> 
+  <paragraph xml-lang="en-US" id="par_id3154490" role="paragraph" l10n="U" oldref="2"><variable id="zellenloeschentext"><ahelp hid=".uno:DeleteCell">Completely deletes selected cells, columns or rows. The cells below or to the right of the deleted cells will fill the space.</ahelp>
 </variable> Note that the selected delete option is stored and reloaded when the dialog is next called.</paragraph>
   <section id="howtoget">
-   
+
    <embed href="text/scalc/00/00000402.xhp#bzelo"/>
-   
+
   </section>
   <paragraph xml-lang="en-US" id="hd_id3149121" role="heading" level="2" l10n="U" oldref="3">Selection</paragraph>
   <paragraph xml-lang="en-US" id="par_id3150751" role="paragraph" l10n="U" oldref="4">This area contains options for specifying how sheets are displayed after deleting cells.</paragraph>
-  
+
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DELCELL:BTN_CELLSUP" id="bm_id3154755" localize="false"/>
   <paragraph xml-lang="en-US" id="hd_id3155767" role="heading" level="3" l10n="U" oldref="5">Shift cells up</paragraph>
   <paragraph xml-lang="en-US" id="par_id3153714" role="paragraph" l10n="U" oldref="6"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSUP">Fills the space produced by the deleted cells with the cells underneath it.</ahelp></paragraph>
-  
+
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DELCELL:BTN_CELLSLEFT" id="bm_id3147346" localize="false"/>
   <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="3" l10n="U" oldref="7">Shift cells left</paragraph>
   <paragraph xml-lang="en-US" id="par_id3154702" role="paragraph" l10n="U" oldref="8"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DELCELL:BTN_CELLSLEFT">Fills the resulting space by the cells to the right of the deleted cells.</ahelp></paragraph>
-  
+
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DELCELL:BTN_DELROWS" id="bm_id3149566" localize="false"/>
-  
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteRows" id="bm_id167872" localize="false"/>
-  
 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteRows" id="bm_id3149565" localize="false"/>
   <paragraph xml-lang="en-US" id="hd_id3146918" role="heading" level="3" l10n="U" oldref="9">Delete entire row(s)</paragraph>
   <paragraph xml-lang="en-US" id="par_id3148487" role="paragraph" l10n="U" oldref="10"><ahelp hid=".uno:DeleteRows">After selecting at least one cell, deletes the entire row from the sheet.</ahelp></paragraph>
-  
+
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DELCELL:BTN_DELCOLS" id="bm_id3150342" localize="false"/>
-  
-<bookmark xml-lang="en-US" branch="hid/.uno:DeleteColumns" id="bm_id8964231" localize="false"/>
-  
 <bookmark xml-lang="en-US" branch="hid/.uno:DeleteColumns" id="bm_id3159240" localize="false"/>
   <paragraph xml-lang="en-US" id="hd_id3155114" role="heading" level="3" l10n="U" oldref="11">Delete entire column(s)</paragraph>
   <paragraph xml-lang="en-US" id="par_id3150086" role="paragraph" l10n="U" oldref="12"><ahelp hid=".uno:DeleteColumns">After selecting at least one cell, deletes the entire column from the sheet.</ahelp></paragraph>
   <section id="relatedtopics">
-   
-   <paragraph xml-lang="en-US" id="par_id3166424" role="paragraph" l10n="C"><link href="text/scalc/01/02150000.xhp" name="Deleting Cells">Deleting Cells</link></paragraph>
-   
+
+   <paragraph xml-lang="en-US" id="par_id3166424" role="paragraph" l10n="CHG"><link href="text/scalc/01/02150000.xhp" name="Deleting Contents">Deleting Contents</link></paragraph>
+
   </section>
  </body>
 </helpdocument>

File helpcontent2/source/text/scalc/01/03080000.xhp

-<?xml version="1.0" encoding="UTF-8"?>
-
-
+<?xml version="1.0" encoding="UTF-8"?><helpdocument version="1.0">
 <!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * <http://www.openoffice.org/license.html>
  * for a copy of the LGPLv3 License.
  *
- ************************************************************************-->
-	
-<helpdocument version="1.0">
+ ************************************************************************ -->
+
 <meta>
 <topic id="textscalc0103080000xml" indexer="include" status="PUBLISH">
-<title id="tit" xml-lang="en-US">Value Highlighting</title>
-<filename>/text/scalc/01/03080000.xhp</filename>
+<title xml-lang="en-US" id="tit">Value Highlighting</title>
+<filename>file:///cws/so-cwsserv01/hcshared27/DEV300/ooo/helpcontent2/source/text/scalc/01/03080000.xhp</filename>
 </topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-10-12T12:45:45">converted from old format - fpe</lastedited>
-</history>
 </meta>
 <body>
 <section id="wertehervorheben">
-<bookmark xml-lang="en-US" branch="index" id="bm_id3151384"><bookmark_value>spreadsheets; value highlighting</bookmark_value>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3151384">
+<bookmark_value>spreadsheets; value highlighting</bookmark_value>
 <bookmark_value>values;highlighting</bookmark_value>
 <bookmark_value>highlighting; values in sheets</bookmark_value>
+<bookmark_value>colors;values</bookmark_value>
 </bookmark>
-<bookmark xml-lang="en-US" branch="hid/.uno:ViewValueHighlighting" id="bm_id6436040" localize="false"/><!-- HID added by script -->
 <bookmark xml-lang="en-US" branch="hid/.uno:ViewValueHighlighting" id="bm_id3145068" localize="false"/>
-<paragraph role="heading" id="hd_id3151384" xml-lang="en-US" level="1" l10n="C"><link href="text/scalc/01/03080000.xhp" name="Value Highlighting">Value Highlighting</link></paragraph>
-<paragraph role="paragraph" id="par_id3154366" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid=".uno:ViewValueHighlighting">Displays cell contents in different colors, depending on type.</ahelp></paragraph>
+<paragraph id="hd_id3151384" role="heading" xml-lang="en-US" level="1"><link href="text/scalc/01/03080000.xhp" name="Value Highlighting">Value Highlighting</link></paragraph>
+<paragraph id="par_id3154366" role="paragraph" xml-lang="en-US"><ahelp hid=".uno:ViewValueHighlighting">Displays cell contents in different colors, depending on type.</ahelp></paragraph>
 </section>
-<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US" l10n="U" oldref="5">To remove the highlighting, unmark the menu entry.</paragraph>
-<section id="howtoget">
-  <embed href="text/scalc/00/00000403.xhp#awehe"/>
+<paragraph id="par_id3125863" role="paragraph" xml-lang="en-US">To remove the highlighting, unmark the menu entry.</paragraph>
+<section id="howtoget"><embed href="text/scalc/00/00000403.xhp#awehe"/>
 </section>
-<paragraph role="paragraph" id="par_id3145785" xml-lang="en-US" l10n="U" oldref="4">Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted.</paragraph>
-<paragraph role="warning" id="par_id3153188" xml-lang="en-US" l10n="U" oldref="3">If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again.</paragraph>
+<paragraph id="par_id3145785" role="paragraph" xml-lang="en-US">Text cells are formatted in black, formulas in green, and number cells in blue, no matter how their display is formatted.</paragraph>
+<paragraph id="par_id3153188" role="warning" xml-lang="en-US">If this function is active, colors that you define in the document will not be displayed. When you deactivate the function, the user-defined colors are displayed again.</paragraph>
 </body>
-</helpdocument>
+</helpdocument>

File helpcontent2/source/text/scalc/01/04050000.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
 <topic id="textscalc0104050000xml" indexer="include">
 <title id="tit" xml-lang="en-US">Insert Sheet</title>
 <bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id1669896" localize="false"/>
 <bookmark xml-lang="en-US" branch="hid/.uno:Insert" id="bm_id3153896" localize="false"/>
 <paragraph role="heading" id="hd_id3155629" xml-lang="en-US" level="1" l10n="U" oldref="1">Insert Sheet</paragraph>
-<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="2"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file. 
+<paragraph role="paragraph" id="par_id3147264" xml-lang="en-US" l10n="U" oldref="2"><variable id="tabelleeinfuegentext"><ahelp hid=".uno:Insert">Defines the options to be used to insert a new sheet.</ahelp> You can create a new sheet, or insert an existing sheet from a file.
 </variable></paragraph>
 <section id="howtoget">
 <embed href="text/scalc/00/00000404.xhp#eitab"/>
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_BEHIND" id="bm_id3147434" localize="false"/>
 <paragraph role="heading" id="hd_id3155414" xml-lang="en-US" level="3" l10n="U" oldref="23">After current sheet</paragraph>
 <paragraph role="paragraph" id="par_id3145271" xml-lang="en-US" l10n="U" oldref="24"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_INSERT_TABLE:RB_BEHIND">Inserts a new sheet directly after the current sheet.</ahelp></paragraph>
-<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2" l10n="U" oldref="25">Create</paragraph>
+<paragraph role="heading" id="hd_id3147428" xml-lang="en-US" level="2" l10n="CHG" oldref="25">Sheet</paragraph>
 <paragraph role="paragraph" id="par_id3154012" xml-lang="en-US" l10n="U" oldref="26">Specifies whether a new sheet or an existing sheet is inserted into the document.</paragraph>
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_INSERT_TABLE:RB_NEW" id="bm_id3145750" localize="false"/>
-<paragraph role="heading" id="hd_id3147350" xml-lang="en-US" level="2" l10n="U" oldref="3">Create</paragraph>
+<paragraph role="heading" id="hd_id3147350" xml-lang="en-US" level="2" l10n="CHG" oldref="3">New sheet</paragraph>
 <paragraph role="paragraph" id="par_id3149262" xml-lang="en-US" l10n="CHG" oldref="4"><ahelp hid="SC_RADIOBUTTON_RID_SCDLG_INSERT_TABLE_RB_NEW">Creates a new sheet. Enter a sheet name in the <emph>Name</emph> field. Allowed characters are letters, numbers, spaces, and the underline character.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/sc:NumericField:RID_SCDLG_INSERT_TABLE:NF_COUNT" id="bm_id3153157" localize="false"/>
-<paragraph role="heading" id="hd_id3155418" xml-lang="en-US" level="3" l10n="U" oldref="27">No. of Sheets</paragraph>
+<paragraph role="heading" id="hd_id3155418" xml-lang="en-US" level="3" l10n="CHG" oldref="27">No. of sheets</paragraph>
 <paragraph role="paragraph" id="par_id3148457" xml-lang="en-US" l10n="U" oldref="28"><ahelp hid="SC:NUMERICFIELD:RID_SCDLG_INSERT_TABLE:NF_COUNT">Specifies the number of sheets to be created.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/sc:Edit:RID_SCDLG_INSERT_TABLE:ED_TABNAME" id="bm_id3154510" localize="false"/>
 <paragraph role="heading" id="hd_id3149379" xml-lang="en-US" level="3" l10n="U" oldref="7">Name</paragraph>

File helpcontent2/source/text/scalc/01/05070000.xhp

 <!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
 </history>
 </meta>
 <body>
-  
-  
-  <bookmark xml-lang="en-US" branch="hid/.uno:PageFormatDialog" id="bm_id2129266" localize="false"/><!-- HID added by script -->
 <bookmark branch="hid/.uno:PageFormatDialog" xml-lang="en-US" id="bm_id3153561"/><paragraph role="heading" level="1" id="hd_id3157910" l10n="U" xml-lang="en-US" oldref="1">Page Style</paragraph>
   <paragraph l10n="U" role="paragraph" id="par_id3156023" xml-lang="en-US" oldref="2"><variable id="seitetext"><ahelp hid=".uno:PageFormatDialog" visibility="visible">Opens a dialog where you can define the appearance of all pages in your document.</ahelp></variable></paragraph>
   <section id="howtoget">
   <embed href="text/shared/01/05040300.xhp#kopfzeile"/>
   <embed href="text/shared/01/05040400.xhp#fusszeile"/>
   <embed href="text/scalc/01/05070500.xhp#tabelle"/>
-  <embed href="text/shared/00/00000001.xhp#zurueck"/>
+  <embed href="text/shared/00/00000001.xhp#zurueck2"/>
  </body>
 </helpdocument>

File helpcontent2/source/text/scalc/01/12090100.xhp

 <paragraph role="paragraph" id="par_id3145271" xml-lang="en-US" l10n="U" oldref="10"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DAPITYPE:BTN_DATABASE">Uses a table or query in a database that is registered in $[officename] as the data source for the DataPilot table.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/sc:RadioButton:RID_SCDLG_DAPITYPE:BTN_EXTERNAL" id="bm_id3153876" localize="false"/>
 <paragraph role="heading" id="hd_id3146119" xml-lang="en-US" level="3" l10n="U" oldref="11">External source/interface</paragraph>
-<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid="SC:RADIOBUTTON:RID_SCDLG_DAPITYPE:BTN_EXTERNAL">Opens the <emph>External Source </emph>dialog where you can select the <link href="text/shared/00/00000005.xhp" name="OLAP">OLAP</link> data source for the DataPilot table.</ahelp></paragraph>
+<paragraph role="paragraph" id="par_id3145647" xml-lang="en-US" l10n="U" oldref="12"><ahelp hid=".">Opens the <emph>External Source</emph> dialog where you can select the OLAP data source for the DataPilot table.</ahelp></paragraph>
 <paragraph role="paragraph" id="par_idN10670" xml-lang="en-US" l10n="NEW"><link href="text/scalc/01/12090102.xhp" name="DataPilot dialog">DataPilot dialog</link></paragraph>
 </body>
 </helpdocument>

File helpcontent2/source/text/scalc/02/06040000.xhp

 <title id="tit" xml-lang="en-US">Function</title>
 <filename>/text/scalc/02/06040000.xhp</filename>
 </topic>
-<history>
-<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created>
-<lastedited date="2004-08-10T11:09:26">converted from old format - fpe</lastedited>
-</history>
 </meta>
 <body>
 <section id="funktion">
 <paragraph role="heading" id="hd_id3150084" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/scalc/02/06040000.xhp" name="Function">Function</link></paragraph>
 <paragraph role="paragraph" id="par_id3151245" xml-lang="en-US" l10n="U" oldref="2"><ahelp hid="HID_INSWIN_FUNC">Adds a formula to the current cell. Click this icon, and then enter the formula in the <emph>Input line</emph>.</ahelp></paragraph>
 </section>
-<paragraph role="paragraph" id="par_id3153360" xml-lang="en-US" l10n="U" oldref="3">This icon is only available when the <emph>Input line</emph> box is hidden.</paragraph>
+<paragraph role="paragraph" id="par_id3153360" xml-lang="en-US" l10n="CHG" oldref="3">This icon is only available when the <emph>Input line</emph> box is not active.</paragraph>
 <section id="syfunktion">
 <table id="tbl_id3154684">
 <tablerow>

File helpcontent2/source/text/scalc/guide/borders.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguidebordersxhp" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">User Defined Borders in Cells </title>
-         <filename>text/scalc/guide/borders.xhp</filename>
+         <filename>/text/scalc/guide/borders.xhp</filename>
       </topic>
    </meta>
    <body>

File helpcontent2/source/text/scalc/guide/calculate.xhp

-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-	
-<!--
-***********************************************************************
+<?xml version="1.0" encoding="UTF-8"?><helpdocument version="1.0">
+<!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * <http://www.openoffice.org/license.html>
  * for a copy of the LGPLv3 License.
  *
- ************************************************************************
- -->
- 
-	
+ ************************************************************************ -->
+
 <meta>
-      <topic id="textscalcguidecalculatexml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Calculating in Spreadsheets</title>
-         <filename>/text/scalc/guide/calculate.xhp</filename>
-      </topic>
-   </meta>
-   <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150791"><bookmark_value>spreadsheets; calculating</bookmark_value>
-      <bookmark_value>calculating; spreadsheets</bookmark_value>
-      <bookmark_value>formulas; calculating</bookmark_value>
+<topic id="textscalcguidecalculatexml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Calculating in Spreadsheets</title>
+<filename>text/scalc/guide/calculate.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150791">
+<bookmark_value>spreadsheets; calculating</bookmark_value>
+<bookmark_value>calculating; spreadsheets</bookmark_value>
+<bookmark_value>formulas; calculating</bookmark_value>
 </bookmark><comment>mw changed "formulas;..." entry</comment>
-<paragraph xml-lang="en-US" id="hd_id3150791" role="heading" level="1" l10n="U"
-                 oldref="25"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp" name="Calculating in Spreadsheets">Calculating in Spreadsheets</link>
-</variable></paragraph>
-      <paragraph xml-lang="en-US" id="par_id3146120" role="paragraph" l10n="CHG" oldref="6">The following is an example of a calculation in $[officename] Calc.</paragraph>
-      <list type="ordered">
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_id3153951" role="listitem" l10n="CHG" oldref="7">Click in a cell, and type a number</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_idN10656" role="listitem" l10n="NEW">Press <item type="keycode">Enter</item>.</paragraph>
-            <paragraph xml-lang="en-US" id="par_idN1065D" role="listitem" l10n="NEW">The cursor moves down to the next cell.</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_id3155064" role="listitem" l10n="CHG" oldref="9">Enter another number.</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_idN1066F" role="listitem" l10n="NEW">Press the <item type="keycode">Tab</item> key.</paragraph>
-            <paragraph xml-lang="en-US" id="par_idN10676" role="listitem" l10n="NEW">The cursor moves to the right into the next cell.</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_id3154253" role="listitem" l10n="CHG" oldref="10">Type in a formula, for example, <item type="literal">=A3 * A4 / 100.</item>
-</paragraph>
-         </listitem>
-         <listitem>
-            <paragraph xml-lang="en-US" id="par_idN1068B" role="listitem" l10n="NEW"> Press <item type="keycode">Enter</item>.</paragraph>
-            <paragraph xml-lang="en-US" id="par_id3147343" role="listitem" l10n="U" oldref="20">The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.</paragraph>
-            <paragraph xml-lang="en-US" id="par_id3155378" role="listitem" l10n="U" oldref="12">When you edit a formula, the new result is calculated automatically.</paragraph>
-         </listitem>
-      </list>
-      <section id="relatedtopics">
-         <embed href="text/scalc/guide/calc_date.xhp#calc_date"/>
-         <embed href="text/scalc/guide/calc_series.xhp#calc_series"/>
-         <embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/>
-         <embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/>
-      </section>
-   </body>
+<paragraph id="hd_id3150791" role="heading" xml-lang="en-US" level="1"><variable id="calculate"><link href="text/scalc/guide/calculate.xhp" name="Calculating in Spreadsheets">Calculating in Spreadsheets</link></variable></paragraph>
+<paragraph id="par_id3146120" role="paragraph" xml-lang="en-US">The following is an example of a calculation in $[officename] Calc.</paragraph>
+<list type="ordered">
+<listitem>
+<paragraph id="par_id3153951" role="listitem" xml-lang="en-US">Click in a cell, and type a number</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_idN10656" role="listitem" xml-lang="en-US">Press Enter.</paragraph>
+<paragraph id="par_idN1065D" role="listitem" xml-lang="en-US">The cursor moves down to the next cell.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id3155064" role="listitem" xml-lang="en-US">Enter another number.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_idN1066F" role="listitem" xml-lang="en-US">Press the Tab key.</paragraph>
+<paragraph id="par_idN10676" role="listitem" xml-lang="en-US">The cursor moves to the right into the next cell.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id3154253" role="listitem" xml-lang="en-US">Type in a formula, for example, <item type="literal">=A3 * A4 / 100.</item></paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_idN1068B" role="listitem" xml-lang="en-US"> Press Enter.</paragraph>
+<paragraph id="par_id3147343" role="listitem" xml-lang="en-US">The result of the formula appears in the cell. If you want, you can edit the formula in the input line of the Formula bar.</paragraph>
+<paragraph id="par_id3155378" role="listitem" xml-lang="en-US">When you edit a formula, the new result is calculated automatically.</paragraph>
+</listitem>
+</list>
+<section id="relatedtopics"><embed href="text/scalc/guide/calc_date.xhp#calc_date"/><embed href="text/scalc/guide/calc_series.xhp#calc_series"/><embed href="text/scalc/guide/calc_timevalues.xhp#calc_timevalues"/><embed href="text/scalc/guide/cellreferences.xhp#cellreferences"/>
+</section>
+</body>
 </helpdocument>

File helpcontent2/source/text/scalc/guide/datapilot_edittable.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguidedatapilot_edittablexml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Editing DataPilot Tables</title>
       <paragraph xml-lang="en-US" id="par_id3147434" role="paragraph" l10n="U" oldref="29">To remove a button from the table, just drag it out of the DataPilot table. Release the mouse button when the mouse pointer positioned within the sheet has become a 'not allowed' icon. The button is deleted.</paragraph>
       <paragraph xml-lang="en-US" id="par_id3156442" role="paragraph" l10n="U" oldref="40">To edit the DataPilot table, click a cell inside the DataPilot table and open the context menu. In the context menu you find the command <emph>Start</emph>, which displays the <emph>DataPilot</emph> dialog for the current DataPilot table.</paragraph>
       <paragraph xml-lang="en-US" id="par_id2666096" role="paragraph" l10n="NEW">In the DataPilot table, you can use drag-and-drop or cut/paste commands to rearrange the order of data fields.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id266609688" role="paragraph" l10n="NEW">You can assign custom display names to fields, field members, subtotals (with some restrictions), and grand totals inside DataPilot tables. A custom display name is assigned to an item by overwriting the original name with another name.</paragraph>
+
       <section id="relatedtopics">
          <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
          <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>

File helpcontent2/source/text/scalc/guide/datapilot_filtertable.xhp

-<?xml version="1.0" encoding="UTF-8"?>
-<helpdocument version="1.0">
-	
-<!--
-***********************************************************************
+<?xml version="1.0" encoding="UTF-8"?><helpdocument version="1.0">
+<!--***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  * <http://www.openoffice.org/license.html>
  * for a copy of the LGPLv3 License.
  *
- ************************************************************************
- -->
- 
-	
+ ************************************************************************ -->
+
 <meta>
-      <topic id="textscalcguidedatapilot_filtertablexml" indexer="include" status="PUBLISH">
-         <title xml-lang="en-US" id="tit">Filtering DataPilot Tables</title>
-         <filename>/text/scalc/guide/datapilot_filtertable.xhp</filename>
-      </topic>
-   </meta>
-   <body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3150792"><bookmark_value>DataPilot function; filtering tables</bookmark_value>
-      <bookmark_value>filtering;DataPilot tables</bookmark_value>
-</bookmark><comment>mw deleted "filters;"</comment>
-<paragraph xml-lang="en-US" id="hd_id3150792" role="heading" level="1" l10n="U"
-                 oldref="35"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering DataPilot Tables">Filtering DataPilot Tables</link>
-</variable></paragraph>
-      <paragraph xml-lang="en-US" id="par_id3153192" role="paragraph" l10n="U" oldref="36">You can use filters to remove unwanted data from a DataPilot table.</paragraph><comment>UFI: removed help id</comment>
-<paragraph xml-lang="en-US" id="par_id3150441" role="paragraph" l10n="CHG" oldref="37">Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the DataPilot table.</paragraph>
-      <section id="relatedtopics">
-         <embed href="text/scalc/guide/datapilot.xhp#datapilot"/>
-         <embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/>
-         <embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/>
-         <embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/>
-         <embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/>
-         <embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/>
-         <embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
-      </section>
-   </body>
+<topic id="textscalcguidedatapilot_filtertablexml" indexer="include" status="PUBLISH">
+<title xml-lang="en-US" id="tit">Filtering DataPilot Tables</title>
+<filename>/text/scalc/guide/datapilot_filtertable.xhp</filename>
+</topic>
+</meta>
+<body>
+<bookmark xml-lang="en-US" branch="index" id="bm_id3150792">
+<bookmark_value>DataPilot function; filtering tables</bookmark_value>
+<bookmark_value>filtering;DataPilot tables</bookmark_value>
+</bookmark>
+<paragraph id="hd_id3150792" role="heading" xml-lang="en-US" level="1"><variable id="datapilot_filtertable"><link href="text/scalc/guide/datapilot_filtertable.xhp" name="Filtering DataPilot Tables">Filtering DataPilot Tables</link></variable></paragraph>
+<paragraph id="par_id3153192" role="paragraph" xml-lang="en-US">You can use filters to remove unwanted data from a DataPilot table.</paragraph>
+<paragraph id="par_id3150441" role="paragraph" xml-lang="en-US">Click the <emph>Filter</emph> button in the sheet to call up the dialog for the filter conditions. Alternatively, call up the context menu of the DataPilot table and select the <emph>Filter</emph> command. The <link href="text/scalc/01/12090103.xhp" name="Filter"><emph>Filter</emph></link> dialog appears. Here you can filter the DataPilot table.</paragraph>
+<paragraph id="par_id315044199" role="paragraph" xml-lang="en-US">You can also click the arrow on a button in the DataPilot table to show a pop-up window. In this pop-up window, you can edit the visibility settings of the associated field.</paragraph>
+<list type="unordered">
+<listitem>
+<paragraph id="par_id0720201001344485" role="paragraph" xml-lang="en-US">The pop-up window displays a list of field members associated with that field. A check box is placed to the left of each field member name. When a field has an alternative display name that differs from its original name, that name is displayed in the list.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344449" role="paragraph" xml-lang="en-US">Enable or disable a checkbox to show or hide the associated field member in the DataPilot table.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344493" role="paragraph" xml-lang="en-US">Enable or disable the <emph>All</emph> checkbox to show all or none of the field members.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344431" role="paragraph" xml-lang="en-US">Select a field member in the pop-up window and click the <item type="menuitem">Show only the current item</item> button to show only the selected field member. All other field members are hidden in the DataPilot table.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344484" role="paragraph" xml-lang="en-US">Select a field member in the pop-up window and click the <item type="menuitem">Hide only the current item</item> button to hide only the selected field member. All other field members are shown in the DataPilot table.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344578" role="paragraph" xml-lang="en-US">Commands enable you to sort the field members in ascending order, descending order, or using a custom sort list.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344584" role="paragraph" xml-lang="en-US">To edit the custom sort lists, open <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences
+</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Calc - Sort Lists.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344811" role="paragraph" xml-lang="en-US">The arrow to open the pop-up window is normally black. When the field contains one or more hidden field members, the arrow is blue and displays a tiny square at its lower-right corner.</paragraph>
+</listitem>
+<listitem>
+<paragraph id="par_id0720201001344884" role="paragraph" xml-lang="en-US">You can also open the pop-up window by positioning the cell cursor at the button and pressing <switchinline select="sys"><caseinline select="MAC">Command
+</caseinline><defaultinline>Ctrl</defaultinline></switchinline>+D.</paragraph>
+</listitem></list>
+<section id="relatedtopics"><embed href="text/scalc/guide/datapilot.xhp#datapilot"/><embed href="text/scalc/guide/datapilot_createtable.xhp#datapilot_createtable"/><embed href="text/scalc/guide/datapilot_edittable.xhp#datapilot_edittable"/><embed href="text/scalc/guide/datapilot_updatetable.xhp#datapilot_updatetable"/><embed href="text/scalc/guide/datapilot_grouping.xhp#datapilot_grouping"/><embed href="text/scalc/guide/datapilot_tipps.xhp#datapilot_tipps"/><embed href="text/scalc/guide/datapilot_deletetable.xhp#datapilot_deletetable"/>
+</section>
+</body>
 </helpdocument>

File helpcontent2/source/text/scalc/guide/finding.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
 <topic id="textscalcguidefindingxhp" indexer="include">
 <title id="tit" xml-lang="en-US">Finding and Replacing in Calc</title>
-<filename>text/scalc/guide/finding.xhp</filename>
+<filename>/text/scalc/guide/finding.xhp</filename>
 </topic>
 </meta>
 <body>

File helpcontent2/source/text/scalc/guide/multioperation.xhp

 </variable></paragraph>
 <paragraph role="heading" id="hd_id3145171" xml-lang="en-US" level="2" l10n="U" oldref="1">Multiple Operations in Columns or Rows</paragraph>
 <paragraph role="paragraph" id="par_id4123966" xml-lang="en-US" l10n="NEW">The <item type="menuitem">Data - Multiple Operations</item> command provides a planning tool for "what if" questions. In your spreadsheet, you enter a formula to calculate a result from values that are stored in other cells. Then, you set up a cell range where you enter some fixed values, and the Multiple Operations command will calculate the results depending on the formula.</paragraph>
-<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="CHG" oldref="2">In the <emph>Formula</emph> field, enter the cell reference to the formula that applies to the data range. In the <emph>Column input cell/Row input cell</emph> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</paragraph>
+<paragraph role="paragraph" id="par_id3156424" xml-lang="en-US" l10n="CHG" oldref="2">In the <emph>Formulas</emph> field, enter the cell reference to the formula that applies to the data range. In the <emph>Column input cell/Row input cell</emph> field, enter the cell reference to the corresponding cell that is part of the formula. This can be explained best by examples:</paragraph>
 <paragraph role="heading" id="hd_id3159153" xml-lang="en-US" level="3" l10n="U" oldref="7">Examples</paragraph>
 <paragraph role="paragraph" id="par_id3153189" xml-lang="en-US" l10n="U" oldref="8">You produce toys which you sell for $10 each. Each toy costs $2 to make, in addition to which you have fixed costs of $10,000 per year. How much profit will you make in a year if you sell a particular number of toys?</paragraph>
 <paragraph role="paragraph" id="par_id6478774" xml-lang="en-US" l10n="NEW">
 </list>
 <paragraph role="heading" id="hd_id3146139" xml-lang="en-US" level="2" l10n="U" oldref="3">Multiple Operations Across Rows and Columns</paragraph>
 <paragraph role="paragraph" id="par_id3148584" xml-lang="en-US" l10n="CHG" oldref="4">
-<item type="productname">%PRODUCTNAME</item> allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the <emph>Formula</emph> field. The <emph>Row input cell</emph> and the <emph>Column input cell</emph> fields are used to enter the reference to the corresponding cells of the formula.</paragraph>
+<item type="productname">%PRODUCTNAME</item> allows you to carry out joint multiple operations for columns and rows in so-called cross-tables. The formula cell has to refer to both the data range arranged in rows and the one arranged in columns. Select the range defined by both data ranges and call the multiple operation dialog. Enter the reference to the formula in the <emph>Formulas</emph> field. The <emph>Row input cell</emph> and the <emph>Column input cell</emph> fields are used to enter the reference to the corresponding cells of the formula.</paragraph>
 <paragraph role="heading" id="hd_id3149949" xml-lang="en-US" level="3" l10n="U" oldref="57">Calculating with Two Variables</paragraph>
 <paragraph role="paragraph" id="par_id3154808" xml-lang="en-US" l10n="U" oldref="58">Consider columns A and B of the sample table above. You now want to vary not just the quantity produced annually, but also the selling price, and you are interested in the profit in each case.</paragraph>
 <paragraph role="paragraph" id="par_id3149731" xml-lang="en-US" l10n="CHG" oldref="59">Expand the table shown above. D2 thru D11 contain the numbers 500, 1000 and so on, up to 5000. In E1 through H1 enter the numbers 8, 10, 15 and 20.</paragraph>
 <paragraph role="listitem" id="par_id3153620" xml-lang="en-US" l10n="U" oldref="96">Choose <emph>Data - Multiple Operations</emph>.</paragraph>
 </listitem>
 <listitem>
-<paragraph role="listitem" id="par_id3149981" xml-lang="en-US" l10n="U" oldref="97">With the cursor in the <emph>Formulas </emph>field, click cell B5.</paragraph>
+<paragraph role="listitem" id="par_id3149981" xml-lang="en-US" l10n="U" oldref="97">With the cursor in the <emph>Formulas</emph> field, click cell B5.</paragraph>
 </listitem>
 <listitem>
 <paragraph role="listitem" id="par_id3156113" xml-lang="en-US" l10n="CHG" oldref="98">Set the cursor in the <emph>Row input cell</emph> field and click cell B1. This means that B1, the selling price, is the horizontally entered variable (with the values 8, 10, 15 and 20).</paragraph>

File helpcontent2/source/text/scalc/guide/multitables.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguidemultitablesxml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Applying Multiple Sheets</title>
             <paragraph xml-lang="en-US" id="par_id3154731" role="paragraph" l10n="CHG" oldref="4">Choose <item type="menuitem">Insert - Sheet</item> to insert a new sheet or an existing sheet from another file.</paragraph>
          </listitem>
       </list>
+
+<bookmark xml-lang="en-US" branch="hid/FID_TAB_EVENTS" id="bm_id906582498" localize="false"/><comment>Sheet Events</comment>
+<paragraph xml-lang="en-US" id="par_id05092009140203598" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a dialog box where you can assign macros to sheet events.</ahelp></paragraph>
+
+<bookmark xml-lang="en-US" branch="hid/FID_TAB_MENU_SET_TAB_BG_COLOR" id="bm_id906582434" localize="false"/><comment>Tab Color</comment>
+<bookmark xml-lang="en-US" branch="hid/FID_TAB_SET_TAB_BG_COLOR" id="bm_id9016345434" localize="false"/>
+<paragraph xml-lang="en-US" id="par_id05092009140203523" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Opens a window where you can assign a color to the sheet tab.</ahelp></paragraph>
+
 <bookmark xml-lang="en-US" branch="hid/.uno:TableSelectAll" id="bm_id9065824" localize="false"/>
 <paragraph xml-lang="en-US" id="par_id050920091402035" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to select all sheets in the document.</ahelp></paragraph>
 <bookmark xml-lang="en-US" branch="hid/.uno:TableDeselectAll" id="bm_id9065825" localize="false"/>
 <paragraph xml-lang="en-US" id="par_id0509200914020391" role="paragraph" l10n="NEW"><ahelp hid="." visibility="hidden">Click to deselect all sheets in the document, except the current sheet.</ahelp></paragraph>
       <paragraph xml-lang="en-US" id="hd_id3154491" role="heading" level="2" l10n="U"
                  oldref="11">Selecting Multiple Sheets</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command 
+      <paragraph xml-lang="en-US" id="par_id3145251" role="paragraph" l10n="CHG" oldref="6">The sheet tab of the current sheet is always visible in white in front of the other sheet tabs. The other sheet tabs are gray when they are not selected. By clicking other sheet tabs while pressing <switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl </defaultinline></switchinline>you can select multiple sheets.</paragraph>
       <paragraph xml-lang="en-US" id="par_idN106B7" role="paragraph" l10n="CHG">You can use Shift+<switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl</defaultinline></switchinline>+Page Up or Page Down to select multiple sheets using the keyboard.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3155600" role="heading" level="2" l10n="U"
                  oldref="12">Undoing a Selection</paragraph>
-      <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command 
+      <paragraph xml-lang="en-US" id="par_id3146969" role="paragraph" l10n="CHG" oldref="13">To undo the selection of a sheet, click its sheet tab again while pressing the <switchinline select="sys"><caseinline select="MAC">Command
 </caseinline><defaultinline>Ctrl </defaultinline></switchinline>key. The sheet that is currently visible cannot be removed from the selection.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id3156382" role="heading" level="2" l10n="CHG"
                  oldref="15">Calculating Across Multiple Sheets</paragraph>
       <paragraph xml-lang="en-US" id="par_id3155333" role="paragraph" l10n="CHG" oldref="16">You can refer to a range of sheets in a formula by specifying the first and last sheet of the range, for example, <item type="literal">=SUM(Sheet1.A1:Sheet3.A1) </item>sums up all A1 cells on Sheet1 through Sheet3.</paragraph>
+
+
       <section id="relatedtopics">
          <embed href="text/scalc/guide/multi_tables.xhp#multi_tables"/>
          <embed href="text/scalc/guide/edit_multitables.xhp#edit_multitables"/>

File helpcontent2/source/text/scalc/guide/rename_table.xhp

             <paragraph xml-lang="en-US" id="par_id3155131" role="listitem" l10n="U" oldref="12">Click the name of the sheet that you want to change.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3146976" role="listitem" l10n="U" oldref="13">Open the context menu and choose the <emph>Rename</emph> command. A dialog box appears where you can enter a new name.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3146976" role="listitem" l10n="U" oldref="13">Open the context menu and choose the <emph>Rename Sheet</emph> command. A dialog box appears where you can enter a new name.</paragraph>
          </listitem>
          <listitem>
             <paragraph xml-lang="en-US" id="par_id3149260" role="listitem" l10n="U" oldref="15">Enter a new name for the sheet and click <emph>OK</emph>.</paragraph>

File helpcontent2/source/text/scalc/guide/row_height.xhp

 </listitem>
 <listitem>
 <paragraph role="listitem" id="par_id3166432" xml-lang="en-US" l10n="U" oldref="9">Start the context menu on the header at the left-hand side.</paragraph>
-<paragraph role="listitem" id="par_id3150519" xml-lang="en-US" l10n="U" oldref="10">You will see the commands <emph>Height</emph> and <emph>Optimal row height</emph>. Choosing either opens a dialog.</paragraph>
+<paragraph role="listitem" id="par_id3150519" xml-lang="en-US" l10n="U" oldref="10">You will see the commands <emph>Row Height</emph> and <emph>Optimal row height</emph>. Choosing either opens a dialog.</paragraph>
 </listitem>
 </list>
 <section id="relatedtopics">

File helpcontent2/source/text/scalc/guide/text_rotate.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguidetext_rotatexml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Rotating Text</title>
             <paragraph xml-lang="en-US" id="par_id3155854" role="listitem" l10n="U" oldref="4">Click the <emph>Alignment</emph> tab.</paragraph>
          </listitem>
          <listitem>
-            <paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="U" oldref="5">In the <emph>Text direction</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph>
+            <paragraph xml-lang="en-US" id="par_id3147426" role="listitem" l10n="CHG" oldref="5">In the <emph>Text orientation</emph> area use the mouse to select in the preview wheel the direction in which the text is to be rotated. Click <emph>OK</emph>.</paragraph>
          </listitem>
       </list><comment>removed a wrong para, i104207</comment>
 <section id="relatedtopics">

File helpcontent2/source/text/scalc/guide/value_with_name.xhp

 <?xml version="1.0" encoding="UTF-8"?>
 <helpdocument version="1.0">
-	
+
 <!--
 ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
  *
  ************************************************************************
  -->
- 
-	
+
+
 <meta>
       <topic id="textscalcguidevalue_with_namexml" indexer="include" status="PUBLISH">
          <title xml-lang="en-US" id="tit">Naming Cells</title>
          </listitem>
       </list>
       <paragraph xml-lang="en-US" id="par_id328989" role="paragraph" l10n="NEW">Names must not be the same as cell references. For example, the name A1 is invalid because A1 is a cell reference to the top left cell.</paragraph>
+      <paragraph xml-lang="en-US" id="par_id32898987" role="paragraph" l10n="NEW">Names must not start with the letter R followed by a number. See the ADDRESS function for more information.</paragraph>
       <paragraph xml-lang="en-US" id="par_id4769737" role="paragraph" l10n="NEW">Names for cell ranges must not include blanks. Blanks are allowed within names for single cells, sheets and documents.</paragraph>
       <paragraph xml-lang="en-US" id="hd_id1226233" role="heading" level="2" l10n="NEW">Naming cells and formulas</paragraph>
       <paragraph xml-lang="en-US" id="par_id5489364" role="paragraph" l10n="NEW">A good way of making the references to cells and cell ranges in formulas legible is to give the ranges names. For example, you can name the range A1:B2 <emph>Start</emph>. You can then write a formula such as "=SUM(Start)". Even after you insert or delete rows or columns, $[officename] still correctly assigns the ranges identified by name. Range names must not contain any spaces.</paragraph>

File helpcontent2/source/text/shared/00/00000020.xhp

  ***********************************************************************
  *
  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
+ *
  * Copyright 2000, 2010 Oracle and/or its affiliates.
  *
  * OpenOffice.org - a multi-platform office productivity suite
 </bookmark>
 <paragraph role="heading" id="hd_id3152952" xml-lang="en-US" level="1" l10n="U" oldref="1">About Import and Export Filters</paragraph>
 <paragraph role="paragraph" id="par_id3143272" xml-lang="en-US" l10n="U" oldref="2">In $[officename], apart from its own <link href="text/shared/00/00000021.xhp" name="XML formats">XML formats</link> you can also open and save many foreign XML formats.</paragraph>
-<paragraph role="paragraph" id="par_id3152414" xml-lang="en-US" l10n="U" oldref="3"><switchinline select="sys"><caseinline select="UNIX">In UNIX, certain file formats cannot be recognized automatically. 
+<paragraph role="paragraph" id="par_id3152414" xml-lang="en-US" l10n="U" oldref="3"><switchinline select="sys"><caseinline select="UNIX">In UNIX, certain file formats cannot be recognized automatically.
 </caseinline><defaultinline>$[officename] normally recognizes the correct file type automatically on opening a file.</defaultinline></switchinline> There may be cases where you have to select the file type yourself in the <emph>Open</emph> dialog. For example, if you have a database table in text format that you want to open as a database table, you need to specify the file type "Text CSV" after selecting the file.</paragraph>
 <paragraph role="heading" id="hd_id3148668" xml-lang="en-US" level="2" l10n="U" oldref="238">Basic Macros in MS Office Documents</paragraph>
 <paragraph role="paragraph" id="par_id3156211" xml-lang="en-US" l10n="U" oldref="239">In <switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - <link href="text/shared/optionen/01130100.xhp" name="Load/Save - VBA Properties">Load/Save - VBA Properties</link> you can specify the settings for the VBA macro codes in MS Office documents. VBA macros are unable to run in $[officename]; they must first be converted and adapted. Often you only want to use $[officename] to change the visible content of a Word, Excel or PowerPoint file and then save the file again in Microsoft Office format without changing the macros they contain. You can set the behavior of $[officename] as desired: Either the VBA macros are saved in commented form as a subroutine of $[officename] and when the document is saved in MS Office format are written back correctly again, or you can select the Microsoft Office macros to be removed when loading. The last option is an effective protection against viruses within the Microsoft Office documents.</paragraph>
 <paragraph role="heading" id="hd_id3154232" xml-lang="en-US" level="2" l10n="U" oldref="5">Notes regarding external formats and file types</paragraph>
 <paragraph role="paragraph" id="par_id3154230" xml-lang="en-US" l10n="U" oldref="226">Even if they are not installed, some filters can be selected in the <emph>Open</emph> and <emph>Save</emph> dialogs. If you select such a filter, a message will appear saying that you can still install the filter if you require.</paragraph>
-<paragraph role="paragraph" id="par_id3149999" xml-lang="en-US" l10n="U" oldref="200"><switchinline select="sys"><caseinline select="WIN">If you want to install additional filters or remove individual filters from the installation, close %PRODUCTNAME, start the Setup program and select the <emph>Modify</emph> option. Then you will see a dialog in which you can add or remove individual components of %PRODUCTNAME. Graphic filters can be found in "Optional Components". 
+<paragraph role="paragraph" id="par_id3149999" xml-lang="en-US" l10n="U" oldref="200"><switchinline select="sys"><caseinline select="WIN">If you want to install additional filters or remove individual filters from the installation, close %PRODUCTNAME, start the Setup program and select the <emph>Modify</emph> option. Then you will see a dialog in which you can add or remove individual components of %PRODUCTNAME. Graphic filters can be found in "Optional Components".
 </caseinline></switchinline></paragraph>
 <paragraph role="heading" id="hd_id3156027" xml-lang="en-US" level="3" l10n="U" oldref="7"><switchinline select="appl"><caseinline select="CALC">
 </caseinline><caseinline select="DRAW">
 </caseinline><defaultinline>It is also possible to import and export <link href="text/shared/00/00000005.xhp#rtf" name="RTF">RTF</link> files. This file format can be used to exchange formatted texts across various applications and platforms. In this way, many formats read by most programs will be transferred without a problem. The clipboard uses RTF format when you insert part of a spreadsheet from $[officename] Calc through <link href="text/shared/00/00000005.xhp" name="DDE">DDE</link> into $[officename] Writer.</defaultinline></switchinline></paragraph>
 <paragraph role="tip" id="par_id3151378" xml-lang="en-US" l10n="U" oldref="237">The filter <emph>Text Encoded</emph> helps you open and save text documents with another encoding font. The filter opens a dialog that enables you to select character set, default fonts, language and paragraph break.</paragraph>
 <paragraph role="heading" id="hd_id3149763" xml-lang="en-US" level="3" l10n="U" oldref="11">Importing and Exporting in HTML Format </paragraph>
-<paragraph role="paragraph" id="par_id3153825" xml-lang="en-US" l10n="U" oldref="12">When borders in HTML documents are exported, lines are exported in a width of exactly 1 pixel since Netscape Navigator and MS Internet Explorer do not recognize smaller lines. When importing, a border of 1 pixel width will appear with 0.05 pt width.<comment>still true? this para is very old.</comment></paragraph>
 <paragraph role="paragraph" id="par_id3150244" xml-lang="en-US" l10n="U" oldref="198">With $[officename] Writer, you can insert footnotes and endnotes in your HTML document. They are exported as meta tags. The footnote and endnote characters are exported as hyperlinks.</paragraph>
 <paragraph role="paragraph" id="par_id3149800" xml-lang="en-US" l10n="U" oldref="199">Comments are used to include unknown characters in an HTML document. Every note that begins with "HTML:..." and ends with "&gt;" is treated as an HTML code, but is exported without these designations. Several tags around text can be included after "HTML:..." Accented characters are converted into the ANSI character set. Comments are created during import (for example, for meta tags that have no room in the file properties or unknown tags).</paragraph>
 <paragraph role="paragraph" id="par_id3149734" xml-lang="en-US" l10n="U" oldref="201">The HTML import of $[officename] Writer is able to read files that have UTF-8 or UCS2 character coding. All characters that are contained in the ANSI character set or in the system's character set can be displayed.</paragraph>
 </list>
 <paragraph role="paragraph" id="par_id3155135" xml-lang="en-US" l10n="CHG" oldref="14">If MS Internet Explorer or $[officename] Writer are set as the export option, the sizes of the control field and their internal margins are exported as styles (print formats). CSS1 size properties are based on "width" and "height" values. The "Margin" property is used to set equal margins on all sides of the page. To allow different margins, the "Margin-Left", "Margin-Right", "Margin-Top" and "Margin-Bottom" properties are used.</paragraph>
 <paragraph role="paragraph" id="par_id3148473" xml-lang="en-US" l10n="CHG" oldref="15">The distances of graphics and Plug-Ins to the content can be set individually for export to $[officename] Writer and MS Internet Explorer. If the top/bottom or right/left margin is set differently, the distances are exported in a "STYLE" option for the corresponding tag as CSS1 size properties "Margin-Top", "Margin-Bottom", "Margin-Left" and "Margin-Right".</paragraph>
-<paragraph role="paragraph" id="par_id3144510" xml-lang="en-US" l10n="CHG" oldref="16">Text frames are supported with the use of CSS1 extensions for absolute positioned objects. This applies only to the export options Netscape Navigator, MS Internet Explorer, and $[officename] Writer. Text frames can be aligned as graphics, <switchinline select="sys"><caseinline select="WIN"> Plug-Ins, 
+<paragraph role="paragraph" id="par_id3144510" xml-lang="en-US" l10n="CHG" oldref="16">Text frames are supported with the use of CSS1 extensions for absolute positioned objects. This applies only to the export options Netscape Navigator, MS Internet Explorer, and $[officename] Writer. Text frames can be aligned as graphics, <switchinline select="sys"><caseinline select="WIN"> Plug-Ins,
 </caseinline></switchinline>and Floating Frames, but character-linked frames are not possible.</paragraph>
 <paragraph role="paragraph" id="par_id3147530" xml-lang="en-US" l10n="U" oldref="46">Text frames are exported as "&lt;SPAN&gt;" or "&lt;DIV&gt;" tags if they do not contain columns. If they do contain columns then they are exported as "&lt;MULTICOL&gt;".</paragraph>
 <paragraph role="paragraph" id="par_id3153896" xml-lang="en-US" l10n="U" oldref="202">The measurement unit set in $[officename] is used for HTML export of CSS1 properties. The unit can be set separately for text and HTML documents under <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Writer - General</emph> or <emph><switchinline select="sys"><caseinline select="MAC">%PRODUCTNAME - Preferences</caseinline><defaultinline>Tools - Options</defaultinline></switchinline> - %PRODUCTNAME Writer/Web - View</emph>. The number of exported decimal places depends on the unit.</paragraph>
 <paragraph role="paragraph" id="par_id3144441" xml-lang="en-US" l10n="U" oldref="106">When you import an EPS file, a preview of the graphic is displayed in the document. If a preview is not available, a placeholder corresponding to the size of the graphic is displayed in the document. Under Unix and Microsoft Windows you can print the imported file by using a PostScript printer. <switchinline select="sys"><caseinline select="UNIX">
 </caseinline><defaultinline>If a different printer is used the preview will be printed.</defaultinline></switchinline> When exporting EPS graphics, a preview is created and has the TIFF or EPSI format. If an EPS graphic together with other graphics is exported in the EPS format then this file will be embedded unchanged in the new file.</paragraph>
 <paragraph role="paragraph" id="par_id3146120" xml-lang="en-US" l10n="U" oldref="222">Multipage-TIFFs are allowed when graphics are imported or exported in TIFF format. The graphics are retrieved as a set of individual pictures in a single file, for example, the individual pages of a fax.</paragraph>
-<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US" l10n="U" oldref="109">Some $[officename] Draw and $[officename] Impress options can be accessed through <emph>File - Export</emph>.</paragraph>
+<paragraph role="paragraph" id="par_id3159153" xml-lang="en-US" l10n="CHG" oldref="109">Some $[officename] Draw and $[officename] Impress options can be accessed through <emph>File - Export</emph>. See <link href="text/shared/00/00000200.xhp" name="Graphics Export Options">Graphics Export Options</link> for more information.</paragraph>
 <paragraph role="heading" id="hd_id3153213" xml-lang="en-US" level="3" l10n="U" oldref="228">PostScript</paragraph>
 <paragraph role="paragraph" id="par_id3156444" xml-lang="en-US" l10n="U" oldref="229">To export a document or graphic in PostScript format:</paragraph>
 <list type="ordered">

File helpcontent2/source/text/shared/00/00000200.xhp

+<?xml version="1.0" encoding="UTF-8"?>
+
+
+<!--***********************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2000, 2010 Oracle and/or its affiliates.