incubator-ooo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1204763 [6/45] - in /incubator/ooo/ooo-site/trunk/content/documentation: HOW_TO/ HOW_TO/data_source/ HOW_TO/data_source/link_tablehtml/ HOW_TO/drawing_graphics/ HOW_TO/files_performances/ HOW_TO/formula/ HOW_TO/img/ HOW_TO/impress/ HOW_TO/...
Date Tue, 22 Nov 2011 00:55:19 GMT
Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,394 @@
+<html><head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<body>
+<TABLE WIDTH="98%" BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
+<TBODY> 
+<TR> 
+<TD ALIGN="CENTER"> <BR><BR> 
+<TABLE WIDTH="85%" BORDER="0" CELLPADDING="0" CELLSPACING="0"
+ BGCOLOR="#003333"> 
+<TBODY> 
+<TR> 
+<TD HEIGHT="2"></TD> 
+</TR> 
+</TBODY> 
+</TABLE> 
+<TABLE WIDTH="85%" BORDER="0" CELLPADDING="0" CELLSPACING="0"
+ BGCOLOR="#E7E7E7"> 
+<TBODY> 
+<TR> 
+<TD VALIGN="TOP" ALIGN="CENTER"><BR><BR> 
+<TABLE WIDTH="80%" BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
+<TBODY> 
+<TR> 
+<TD BGCOLOR="#000000" HEIGHT="1"></TD> 
+</TR> 
+<TR> 
+<TD BGCOLOR="#FFFFFF" ALIGN="CENTER"><BR><B>website.openoffice.org
+HowTos</B><BR><BR></TD> 
+</TR> 
+<TR> 
+<TD BGCOLOR="#000000" HEIGHT="1"><A NAME="top"></A></TD> 
+</TR> 
+<TR> 
+<TD BGCOLOR="#FFFFFF" ALIGN="CENTER"> <BR> 
+<TABLE WIDTH="90%" BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
+<TBODY> 
+<TR> 
+<TD ALIGN="LEFT"> 
+<H3>Installing and using CVS under Windows</H3> 
+<P><B><FONT COLOR="#C70000">Credits: this HowTo is the result of the combined
+efforts of the website.openoffice.org mailing-list members. This file is on the
+OpenOffice.org server because of their collaboration. We hope that this
+summary, and any improved or rewritten version in the future will help others
+to enjoy CVS-ing and online HTML collaboration in as pleasurable and effective
+a way as possible. It is not difficult at all. It is, in fact, extremely easy,
+easier than ftp-ing. So if you can ftp, you will certainly be able to CVS using
+the combined tools of Cygwin and TortoiseCVS. </FONT></B></P> 
+<P><B>Miljenko Williams</B></P> 
+<P><B><FONT COLOR="#C70000">Improvements to the original document made by
+Johannes Czerwinski. Corrections and comments made by Gianluca Turconi, 10th
+September 2002.</FONT></B></P> 
+<P><A
+HREF="http://website.openoffice.org/servlets/BrowseList?listName=dev&by=thread&from=13252&to=13252&first=1&count=100">related
+e-mail thread</A> | email comments etc. to
+<A
+ HREF="mailto:dev@website.openoffice.org">dev@website.openoffice.org</A></P><HR
+SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT"> 
+<UL> 
+<LI><A HREF="#1">Downloading and installing Cygwin</A></LI> 
+<LI><A HREF="#2">Generating your public and private keys</A></LI> 
+<LI><A HREF="#3">Creating a tunnel and minimising the window</A></LI> 
+<LI><A HREF="#4">Opening a new window in Cygwin, logging on to a project
+repository (the folder where the HTML files of a project are stored), and
+checking out a project repository (downloading the files from the online
+repository to your hard drive for the first time)</A></LI> 
+<LI><A HREF="#5">Downloading and installing Tortoise CVS</A></LI> 
+<LI><A HREF="#6">Updating (downloading files from a project repository to your
+hard drive which have been modified by other developers), committing (uploading
+files to a project repository from your hard drive which you modified), adding
+new files (one new folder or one new HTML file which didn't previously exist in
+the repository), and adding new files recursively (add a folder or several
+folders and/or several HTML files which didn't previously exist in the
+repository)</A></LI> 
+</UL><BR></TD> 
+</TR> 
+</TBODY> 
+</TABLE></TD> 
+</TR> 
+</TBODY> 
+</TABLE> 
+<TABLE WIDTH="80%" BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
+<TBODY> 
+<TR> 
+<TD BGCOLOR="#FFFFFF" ALIGN="CENTER"> <BR> 
+<TABLE WIDTH="90%" BORDER="0" CELLPADDING="0" CELLSPACING="0"> 
+<TBODY> 
+<TR> 
+<TD ALIGN="LEFT"> 
+<P><A NAME="1"><B>Downloading and installing Cygwin</B></A> | <A
+HREF="#top">top</A></P> 
+<P>Make sure you are connected to the Internet. </P> 
+<P>Go to <A HREF="http://www.cygwin.com" TARGET="_blank">www.cygwin.com</A> and
+download the <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> executable to your computer, the icon of which you will see on the
+homepage somewhere. Remember the following:</P> 
+<UL> 
+<LI>this file simply administers the process of choosing which files to
+download to your computer, the download process itself (if you are disconnected
+from the Internet whilst you are downloading from a server which supports the
+function, you will be able to carry on from where you left off when you
+reconnect by simply clicking on setup again) and unzipping and installing once
+everything has been downloaded. When you download the <B>Cygwin</B> <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE>, you will not yet have downloaded the <B>Cygwin</B> program. The
+<B>Cygwin</B> <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> simply makes it possible for you to download the program files you need
+in order to install <B>Cygwin</B> on your hard drive</LI> 
+<LI>if you are disconnected whilst downloading the <B>Cygwin</B> files, when
+you reconnect and restart the download process, you may think it is starting
+from scratch as the <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> file always reloads a file called <CODE><FONT COLOR="#C70000">setup.ini</FONT></CODE> from the download server. Do not think you are starting from scratch.
+The <CODE><FONT COLOR="#C70000">setup.ini</FONT></CODE> is always re-downloaded from the server when you reconnect from a
+broken connection, but the download process will pick up from where it left off
+(or from the beginning of the last file incompletely downloaded), once the <CODE><FONT COLOR="#C70000">setup.ini</FONT></CODE> has been re-downloaded</LI> 
+<LI>please do not try and use WinZip or any other ZIP program to unzip and
+install <B>Cygwin</B> at any point. The <B>Cygwin</B> <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> file will do it for you and will do it correctly</LI> 
+<LI>if you ever need to uninstall any or all of the files, you should use the <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> to do so. <A HREF="#install">Click here for more information</A> on how
+to uninstall</LI> 
+</UL> 
+<P><B>Choose A Download Source</B>: once you have downloaded the<B> Cygwin</B> <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> file, click on the <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> icon and click the <CODE><FONT COLOR="#C70000">Next</FONT></CODE> button. You will be asked to choose between <CODE><FONT COLOR="#C70000">Install from Internet</FONT></CODE>, <CODE><FONT COLOR="#C70000">Download from Internet</FONT></CODE> or <CODE><FONT COLOR="#C70000">Install from Local Directory</FONT></CODE><B></B>. Choose <CODE><FONT COLOR="#C70000">Download from Internet</FONT></CODE> and click the <CODE><FONT COLOR="#C70000">Next</FONT></CODE> button.</P> 
+<P><B>Select Local Package Directory</B>: you will now be asked to define the
+local package directory (where you want the downloaded files to be stored to on
+your hard drive &#150; not where the program folder or files will eventually be
+placed). This can be any folder where you normally download files to from the
+Internet. We suggest you create a folder called <CODE><FONT COLOR="#C70000">Cygwin Download Files</FONT></CODE> to download the files to. Click on the <CODE><FONT COLOR="#C70000">Next</FONT></CODE> button</P> 
+<P><B>Select Your Internet Connection</B>: select <CODE><FONT COLOR="#C70000">Direct Connection</FONT></CODE> (and make sure you are already connected to the Internet) and then
+click on the <CODE><FONT COLOR="#C70000">Next</FONT></CODE> button</P> 
+<P><B>Choose a Download Site</B>: we suggest you choose
+<A HREF="http://mirrors.sunsite.dk"
+ TARGET="_blank">http://mirrors.sunsite.dk</A>, as this site supports
+re-downloading from where you left off if you are disconnected from the
+Internet whilst still downloading files. Other mirrors and servers may also
+offer this facility. Remember the following:</P> 
+<UL> 
+<LI>not all mirrors appear to update the setup.ini regularly. The setup.ini may
+therefore change from server to server. It's best to choose a server, check it
+works for you, and continue the download process through to the end, instead of
+changing servers halfway and running the risk of starting up again with a
+different setup.ini and the problems that may (or may not) be generated for
+you</LI> 
+</UL> 
+<P><B>Select packages to download</B>: you must now ensure the following
+packages (program files) are selected for download. Remember the following:</P>
+
+<UL> 
+<LI>if you have to select certain packages manually, because they are not
+selected by default, and you are then disconnected from the Internet whilst
+downloading the packages, when you reconnect to the server and the <CODE><FONT COLOR="#C70000">setup.ini</FONT></CODE> (the download instructions which tell the server what packages) is
+re-loaded, it will be re-loaded with the default selections only. You must
+therefore always reselect manually any packages you had to select manually
+first time round. If you do not do so, they will not be downloaded and
+<B>Cygwin</B> will not necessarily work for you</LI> 
+</UL> 
+<P>First click the <CODE><FONT COLOR="#C70000">View</FONT></CODE> button. This will open up the list of packages which can be downloaded
+and show you which of them are selected by default. In addition to the packages
+which are selected by default, you have to select the following packages
+manually:</P> 
+<UL> 
+<LI>- cvs (Category: Devel)</LI> 
+<LI>- openssh (Category: Net)</LI> 
+<LI>- openssl (Category: Libs)</LI> 
+<LI>- patch (Category: Utils)</LI> 
+</UL> 
+<P>Now click the <CODE><FONT COLOR="#C70000">Next</FONT></CODE> button and wait for the files you have selected to be downloaded.</P> 
+<P>Once the files have been downloaded, installation is very simple. Click
+again on the <CODE><FONT COLOR="#C70000">setup.exe</FONT></CODE> as before, and when you get to the section <CODE><FONT COLOR="#C70000">Choose a Download Source</FONT></CODE>, select <CODE><FONT COLOR="#C70000">Install from Local Directory</FONT></CODE>, the directory being the directory you downloaded the program files to
+from the Internet. Click on <CODE><FONT COLOR="#C70000">Next</FONT></CODE>.</P> 
+<P><B>Select Root Install Directory</B>: the default directory is <CODE><FONT COLOR="#C70000">C:\cygwin</FONT></CODE>. We suggest you do not modify this default. Leave all other selections
+as default and click on <CODE><FONT COLOR="#C70000">Next</FONT></CODE>.</P> 
+<P><B>Select Local Package Directory</B>: the default directory will be the
+directory you downloaded the program files to from the Internet. We suggest you
+do not modify this default. Click on <CODE><FONT COLOR="#C70000">Next</FONT></CODE>.</P> 
+<P><B><A NAME="install">Select packages to
+install/keep/reinstall/uninstall</A></B>: make sure the default packages as
+listed above are all checked to be installed if this is the first installation.
+If a package shows <CODE><FONT COLOR="#C70000">Keep</FONT></CODE>, this means the package is already installed. Remember the
+following:</P> 
+<UL> 
+<LI>if you ever need to uninstall any or all of the packages, instead of
+checking the packages to <CODE><FONT COLOR="#C70000">Keep</FONT></CODE> or <CODE><FONT COLOR="#C70000">Reinstall</FONT></CODE>, select <CODE><FONT COLOR="#C70000">Uninstall</FONT></CODE> at this point in the process</LI> 
+</UL> 
+<P>Click on <CODE><FONT COLOR="#C70000">Next</FONT></CODE>. The packages will now be installed.</P>
+<HR SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT"> 
+<P><A NAME="2"><B>Generating your public and private keys</B></A> |
+<A HREF="#top">top</A></P> 
+<P>Click on the <B>Cygwin</B> icon which you should have on your Desktop. This
+will open a black window. Type the following line into the black window:</P> 
+<P><CODE><FONT COLOR="#C70000">ssh-keygen -d</FONT></CODE></P> 
+<P> This commands the program to generate an SSH2 key (the <CODE><FONT COLOR="#C70000">-d</FONT></CODE> extension specifies a DSA/SSH2 key which is the type that
+OpenOffice.org needs). Depending on the speed of your processor, it could take
+anywhere from several seconds to several minutes. When finished, it will prompt
+you for a file in which to save the key. You should press the <CODE><FONT COLOR="#C70000">Enter</FONT></CODE> key without typing anything else in. Although the prompt appears to be
+a filepath without a filename, it does actually include the filename too. Don't
+add anything else to this filepath and name - if you do you will then have
+problems later on which you will only be able to solve if you understand how to
+use Unix directories.</P> 
+<P>You will then be asked to enter a passphrase. It is strongly recommended
+that you enter one, and that it be fairly good. (This means: try to avoid using
+real words, change the case, incorporate numbers, symbols, or some other
+combination.) </P> 
+<P>Whilst you are keying in your passphrase, you will not see any characters
+being typed up onto the black window, nor will a cursor move. You are
+nevertheless registering the passphrase as you type. You will be asked to enter
+this passphrase twice. Make sure you make careful note of it: you will be asked
+for it every time you log in to the OpenOffice.org SSH2 server, which you will
+have to connect to using this public key.</P> 
+<P>Once you have entered the passphrase twice, you will then be told that the
+"identification" has been saved in the default file you stipulated above, and
+that the "public key" has been saved in a file bearing that same name but with
+a <CODE><FONT COLOR="#C70000">.pub</FONT></CODE> suffix. The .pub signifies that it is the public key. It is this file
+you should then send to OpenOffice.org. You will find it in the following
+folder (as long as you have used default values throughout the
+installation):</P> 
+<P><CODE><FONT COLOR="#C70000"> C:\cygwin\home\Standard\.ssh</FONT></CODE></P> 
+<P>In order to be able to use this public key, you should either send it via
+the OpenOffice.org IssueZilla bug-reporting system, if you know how to do this,
+logging in with your OpenOffice.org website login name and password (not the
+passphrase you have used to generate the public key), creating an issue which
+you can call My Public Key or something similar, and then attaching the public
+key to the issue.</P> 
+<P>You may however prefer to ask your project leader to help you with the
+procedure. </P> 
+<P>In any case, once this public key has been placed on the OpenOffice.org
+server, and you have been told it has been placed there (it is not an automatic
+process and you may have to wait a few days), you will be able to continue with
+the process of CVS-ing under OpenOffice.org. </P> 
+<P>Remember that this public key will be used in conjunction with your
+OpenOffice.org website login name, and that although you need the passphrase
+associated with the public key to tunnel, your website login name and
+associated password are needed for you to be able to use the tunnel in order to
+CVS on the OpenOffice.org site. That is to say:</P> 
+<UL> 
+<LI>you need your public key to be physically present on the OpenOffice.org
+server in order to create a tunnel</LI> 
+<LI>your need to have an OpenOffice.org website login name and login password
+to be able to CVS on an OpenOffice.org project, using the tunnel you have
+created</LI> 
+</UL> <HR SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT"> 
+<P><A NAME="3"><B>Creating a tunnel and minimising the window</B></A> |
+<A HREF="#top">top</A></P> 
+<P>First, click on the <B>Cygwin</B> icon on your Desktop. The black window
+will open again. At the prompt, enter the following phrase:</P> 
+<P><CODE><FONT COLOR="#C70000">ssh -2 -x -L 2401:localhost:2401 tunnel@openoffice.org</FONT></CODE></P> 
+<P>If you have problems typing in the "@" sign, you may have a key on your
+keyboard which is called Alt Gr, or Alt plus something else: press it along
+with the key where the "@" sign appears.</P> 
+<P>The server will ask you for your passphrase. Enter it. If this is your first
+time, the server will send you a message along these lines: </P> 
+<P><CODE><FONT COLOR="#C70000">Host key not found from the list of known hosts. 
+Are you sure you want to continue connecting (yes/no)? </FONT></CODE></P> 
+<P> Enter:</P> 
+<P><CODE><FONT COLOR="#C70000">Yes</FONT></CODE></P> 
+<P> (You can't just enter "y"; you have to spell it out fully.)</P> 
+<P>The server will then respond with: </P> 
+<P><CODE><FONT COLOR="#C70000">Host "openoffice.org" added to the list of known hosts</FONT></CODE></P> 
+<P>The screen does not show a prompt. That's how it should be. The tunnel has
+been established. You are now ready to begin using CVS. You can, at this point,
+minimize the black window, but do not close it by clicking on the <CODE><FONT COLOR="#C70000">X</FONT></CODE> in the top right-hand corner. If you close it, you will be closing the
+tunnel you have just created.</P>
+<HR SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT"> 
+<P> <A NAME="4"><B>Opening a new window in Cygwin, logging on to a project
+repository (the folder where the HTML files of a project are stored), and
+checking out a project repository (downloading the files from the online
+repository to your hard drive for the first time)</B></A> | <A
+HREF="#top">top</A></P> 
+<P>Once you have minimised the existing Cygwin window which you have used to
+create a tunnel, you should now click on the Cygwin icon again to open a new
+window.</P> 
+<P>At the prompt, type in the following command:</P> 
+<P><CODE><FONT COLOR="#C70000">cvs -d:pserver:{my openoffice.org website login name}@localhost:/cvs login</FONT></CODE></P> 
+<P>For example, if your OpenOffice.org login name is "walter", you will type in
+the following command:</P> 
+<P><CODE><FONT COLOR="#C70000">cvs -d:pserver:walter@localhost:/cvs login</FONT></CODE></P> 
+<P>You will now be asked for your CVS password, which is the password
+associated with your OpenOffice.org website login name, not the passphrase you
+have used in conjunction with the public key you generated to create a
+tunnel.</P> 
+<P>Once you have logged in to the CVS repository successfully, you can type in
+the following command which will download onto your hard drive the current
+content of the project you are going to work on:</P> 
+<P><CODE><FONT COLOR="#C70000">cvs -z3 -d:pserver:{your openoffice.org login name}@localhost:/cvs checkout {the name of your project}</FONT></CODE></P> 
+<P>For example, if your OpenOffice.org login name is "walter" and the project
+you are going to work in is the Spanish lang project, you will type in the
+following command:</P> 
+<P><CODE><FONT COLOR="#C70000">cvs -z3 -d:pserver:walter@localhost:/cvs checkout es</FONT></CODE></P> 
+<P>Once you have successfully downloaded the content of your project (you will
+find it within the Cygwin folder: <CODE><FONT COLOR="#C70000">C:\cygwin\home\Standard</FONT></CODE> if you have used default values or within the current user if you have
+defined your own values), you are ready to continue with the installation
+process. </P> 
+<P>At the prompt, type in <CODE><FONT COLOR="#C70000">Control C</FONT></CODE> and then <CODE><FONT COLOR="#C70000">exit</FONT></CODE> - this will logout from the CVS server and close the window. If you
+close the window this way, instead of by clicking on the <CODE><FONT COLOR="#C70000">X</FONT></CODE> in the top right-hand corner, the next time you open the window CVS,
+you will be able to use the up/down arrows to flick through the commands you
+have used to create the tunnel etc. and you will not need to type them
+laboriously in letter by letter.</P> 
+<P>Maximise the black window you had created to tunnel with and press <CODE><FONT COLOR="#C70000">Control C</FONT></CODE> at the prompt. This will close the tunnel, but not the window. Then
+type in <CODE><FONT COLOR="#C70000">exit</FONT></CODE> and this will close the window. If you close the window this way,
+instead of by clicking on the <CODE><FONT COLOR="#C70000">X</FONT></CODE> in the top right-hand corner, the next time you open the window, you
+will be able to use the up/down arrows to flick through the commands you have
+used to create the tunnel etc. and you will not need to type them laboriously
+in letter by letter.</P> <HR SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT">
+
+<P><A NAME="5"><B>Downloading and installing Tortoise CVS</B></A> |
+<A HREF="#top">top</A></P> 
+<P>Assuming you are connected to the Internet, go the following web: </P> 
+<P><A
+HREF="http://www.tortoisecvs.org/download.shtml">http://www.tortoisecvs.org/download.shtml</A>,<BR>
+or simply <A HREF="http://www.tortoisecvs.org">http://www.tortoisecvs.org</A>
+(and then look for the <CODE><FONT COLOR="#C70000">Download</FONT></CODE> link)</P> 
+<P>Choose the most recent stable version of <B>TortoiseCVS</B> available and
+download it to your hard drive.</P> 
+<P>Install the program, using the default values in all circumstances. </P> 
+<P>Once you have installed TortoiseCVS, you will see that when you right-click
+on any folder under Windows Explorer, you will see a series of commands have
+been added to the normal ones on this menu. You are now ready to upload
+modified files to your project's OpenOffice.org repository. The meaning of the
+four most important commands is explained in the following section.</P> 
+<P>NOTE 1: If Cygwin is handling text files in Unix format, you should uncheck
+the "Check not Unix sandbox" in the Quirky tabs of TortoiseCVS preferences. If
+you do not do so, an annoying dialogue box will pop up complaining about "an
+attempt to checkout Unix Sandbox on Windows machines"; TortoiseCVS may then
+crash.</P> 
+<P>NOTE 2: With a standard Cygwin and TortoiseCVS installation, you may have to
+select the Cygwin CVS binary in order to be able to use TortoiseCVS under the
+procedures described in this HowTo.</P>
+<HR SIZE="1" WIDTH="80%" COLOR="#999999" ALIGN="LEFT"> 
+<P><A NAME="6"><B>Updating (downloading files from a project repository to your
+hard drive which have been modified by other developers), committing (uploading
+files to a project repository from your hard drive which you modified), adding
+new files (one new folder or one new HTML file which didn't previously exist in
+the repository), and adding new files recursively (add a folder or several
+folders and/or several HTML files which didn't previously exist in the
+repository)</B></A> | <A HREF="#top">top</A></P> 
+<P>There are four basic commands which you will need to understand in order to
+modify files within your project and upload them to the project site.</P> 
+<P>Before you do so, you should understand the meaning of the following:</P> 
+<UL> 
+<LI><B><FONT COLOR="#C70000">updating</FONT></B> - this means downloading files
+from a project repository on the OpenOffice.org server to your hard drive which
+have been modified by other developers. This is not the same as when you
+"checked out" - "checking out" is creating a copy of the repository on your
+hard drive for the very first time</LI> 
+<LI><B><FONT COLOR="#C70000">committing</FONT></B> - this means uploading files
+to a project repository on the OpenOffice.org server which you have
+modified</LI> 
+<LI><B><FONT COLOR="#C70000">adding</FONT></B> - this means creating a new
+filename on the project repository, after first having created the file itself
+on your hard drive. This file will only ever exist on the project repository if
+you use both the "add" command first (adding means that you are registering the
+new filename on the repository), and then the "commit" command second (making
+the addition a reality by sending the content associated with that
+filename)</LI> 
+<LI><B><FONT COLOR="#C70000">adding recursively</FONT></B> - this means that
+instead of first "adding" a new folder name and then "committing" it, and then
+"adding" each file within that new folder one by one and "committing" them by
+one by one, you can simply choose to "add recursively" (register both the new
+folder name and/or multiple filenames together) and then "commit" the whole
+folder (sending all the content associated with all the new filenames you have
+registered together)</LI> 
+</UL> 
+<P>In order to do all of this, you only need to remember the following:</P> 
+<OL> 
+<LI>Create a tunnel first, using the procedure already described above. Don't
+forget to minimise the black window</LI> 
+<LI>Use Windows Explorer to find the folder where your project repository has
+been stored on your own hard drive. If your project is the Spanish lang project
+and you have used default values throughout the whole installation of Cygwin,
+you will find your project files in the following folder:<BR><BR><CODE><FONT COLOR="#C70000">C:\cygwin\home\Standard\es\www</FONT></CODE></LI> 
+</OL> 
+<P>In order to <CODE><FONT COLOR="#C70000">update</FONT></CODE>, <CODE><FONT COLOR="#C70000">commit</FONT></CODE>, <CODE><FONT COLOR="#C70000">add</FONT></CODE> or <CODE><FONT COLOR="#C70000">add recursively</FONT></CODE>, all you need to do is select the folder which contains files you need
+to work on, click on your right-hand mouse button, and select the command you
+need to use. The process will then be carried out automatically.</P> 
+<P>We hope you enjoy your CVS-ing with OpenOffice.org for a long time to
+come.</P><BR><BR></TD> 
+</TR> 
+</TBODY> 
+</TABLE></TD> 
+</TR> 
+<TR> 
+<TD BGCOLOR="#000000" HEIGHT="1"></TD> 
+</TR> 
+</TBODY> 
+</TABLE> <BR><BR><BR><BR><BR></TD> 
+</TR> 
+</TBODY> 
+</TABLE> 
+<TABLE WIDTH="85%" BORDER="0" CELLPADDING="0" CELLSPACING="0"
+ BGCOLOR="#003333"> 
+<TBODY> 
+<TR> 
+<TD HEIGHT="2"></TD> 
+</TR> 
+</TBODY> 
+</TABLE><BR><BR> <BR><BR></TD> 
+</TR> 
+</TBODY> 
+</TABLE></body>
+</html>
+

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/cygwin_tortoise_cvs.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.sxw
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.sxw?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/email_change_v0.2.sxw
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.odt
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.odt?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.odt
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/misc/multiple_screens.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image2.jpg
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image2.jpg?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image2.jpg
------------------------------------------------------------------------------
    svn:mime-type = image/jpeg

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image3.jpg
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image3.jpg?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/Image3.jpg
------------------------------------------------------------------------------
    svn:mime-type = image/jpeg

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut1.jpg
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut1.jpg?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut1.jpg
------------------------------------------------------------------------------
    svn:mime-type = image/jpeg

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut2.gif
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut2.gif?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/aut2.gif
------------------------------------------------------------------------------
    svn:mime-type = image/gif

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1HTML.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1HTML.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1HTML.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1PDF.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1PDF.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1PDF.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,418 @@
+<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
+<HTML>
+<HEAD>
+	<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=iso-8859-1">
+	<TITLE></TITLE>
+	<META NAME="GENERATOR" CONTENT="OpenOffice.org 1.1  (Linux)">
+	<META NAME="CREATED" CONTENT="20040408;22520700">
+	<META NAME="CHANGEDBY" CONTENT="Kevin Carr">
+	<META NAME="CHANGED" CONTENT="20040408;22580500">
+</HEAD>
+<BODY LANG="en-US" DIR="LTR">
+<H2 ALIGN=CENTER STYLE="margin-top: 0in">How to Carry out Simple
+Calculations</H2>
+<H2 ALIGN=CENTER STYLE="margin-top: 0in">and</H2>
+<H2 ALIGN=CENTER STYLE="margin-top: 0in">Format Cells and Sheets in a
+Folder.</H2>
+<H2 ALIGN=CENTER STYLE="margin-top: 0in">&nbsp;</H2>
+<H5 ALIGN=CENTER STYLE="margin-top: 0in"><I>provided by</I></H5>
+<H5 ALIGN=CENTER STYLE="margin-top: 0in"><I>the OpenOffice.org
+Documentation Project</I></H5>
+<H2 ALIGN=CENTER STYLE="margin-top: 0in">&nbsp;</H2>
+<P><B>Table of contents :</B> 
+</P>
+<OL>
+	<LI><P STYLE="margin-bottom: 0in"><A HREF="#1">A quick introduction</A>.
+	Introduction to the tools available in the Calc environment 
+	</P>
+	<LI><P STYLE="margin-bottom: 0in"><A HREF="#2">Initial Calculations</A>.
+		</P>
+	<LI><P STYLE="margin-bottom: 0in"><A HREF="#3">Personalized
+	Formatting</A> 
+	</P>
+	<LI><P STYLE="margin-bottom: 0in"><A HREF="#4">Printing your work</A>
+		</P>
+	<LI><P><A HREF="#5">Credits</A> 
+	</P>
+</OL>
+<H3 STYLE="margin-top: 0in"><A NAME="1"></A>1. A quick introduction.
+Introduction to the tools available in the Calc environment. 
+</H3>
+<P>Before you start doing those highly advanced calculations that you
+will no doubt be spinning off in no time, let's take a brief look at
+your work surroundings to familiarize yourself with the tools that
+have been made available. 
+</P>
+<P><IMG SRC="image1.jpg" NAME="Image1" ALIGN=MIDDLE WIDTH=628 HEIGHT=471 BORDER=0><BR>&nbsp;
+<BR>&nbsp; <BR>&nbsp; 
+</P>
+<P>Just below the title bar (the one with the butterfly) you will see
+four command toolbars : 
+</P>
+<UL>
+	<LI><P STYLE="margin-bottom: 0in">A <B>Menu toolbar</B> 
+	</P>
+	<LI><P STYLE="margin-bottom: 0in">A <B>Function toolbar</B> 
+	</P>
+	<LI><P STYLE="margin-bottom: 0in">An <B>Object toolbar</B> 
+	</P>
+	<LI><P>A <B>Calculation toolbar</B> 
+	</P>
+</UL>
+<P>The <B>Menu toolbar</B> contains the main menus of the Calc
+module. The <B>Function toolbar</B> provides user access to function
+icons such as <B>Open, Save, Copy, Cut, Paste</B> and other common
+tasks in OpenOffice.org. The <B>Object toolbar </B>comprises a set of
+tools that are specific to calculation and cell formatting (number
+format, text alignment, borders). Finally, the <B>Calculation toolbar</B>
+is intended for the entry of formulae necessary for your
+calculations, and also shows you the position of the cursor within
+the spreadsheet.</P>
+<P>&nbsp;</P>
+<P><I><B>NB</B> : Some people believe that these toolbars can not be
+changed, but this is not actually true. It is in fact possible to
+modify the icons and the associated functions according to your needs
+by clicking on the right mouse button of the main toolbar or the
+Object toolbar. A context-sensitive menu will then appear. Next,
+choose `<B>Configure</B>' or `<B>Customize</B>' in order to change
+the contents of the toolbar. You can also select `<B>Visible Buttons</B>'
+and add or remove the buttons of your choice. You can also add an
+extra toolbar from the same context-sensitive menu, called <B>Options
+toolbar </B>which , by default, is not shown. This bar contains
+several additional buttons that are in fact useful positioning or
+modification tools.</I></P>
+<P>&nbsp;</P>
+<P ALIGN=LEFT><IMG SRC="Image3.jpg" NAME="Image2" ALIGN=RIGHT WIDTH=30 HEIGHT=394 BORDER=0>On
+the left of the screen, you will notice the <B>Instrument toolbar
+</B>(shown here on the right). This toolbar provides the tools that
+you will need to work with your spreadsheet. The basic functions of
+the toolbar are explained in this `How-to'. At the bottom of the
+screen, you will notice the <B>Status Bar</B>. This bar provides
+essential information such as the sheet that you're currently working
+on, the page style, and in normal mode, the sum of the cell in which
+the cursor is situated.</P>
+<P ALIGN=LEFT>&nbsp;</P>
+<P><I><B>NB :</B> A right mouse button click in the box where Sum is
+written will give you access to a context-sensitive menu that
+proposes other choices, such as mean, maximum, minimum...</I></P>
+<P>You will also notice that the folder you have just opened contains
+three worksheets by default, indicated by the presence of three small
+tabs above the Status Bar and bearing the names : Sheet1, Sheet2,
+Sheet3.</P>
+<P>The spreadsheet is represented as a grid comprising cells, with
+each cell bearing a unique reference. A cell is referenced by its
+column (vertical reference), given here as a letter (e.g. A...Z
+etc.), and its line (horizontal reference), given here as a number
+(e.g. 1...65000 etc.), These references appear as grey column and
+line headers on the spreadsheet. Thus, the first cell in the first
+line (the one at the uppermost left hand corner) bears the reference
+A1.</P>
+<H3 STYLE="margin-top: 0in"><A NAME="2"></A><B>2. Initial
+Calculations</B></H3>
+<P>If you 've jumped to this section without having read the
+preceding paragraphs, it might be a good idea to go back and read
+them now anyway, since the terms that will be used here were
+introduced previously. However, if you too impatient, tired, excited
+or even bored to do that , read on and we'll take a look at how to
+carry out additions with Calc !</P>
+<P>As mentioned above, the boxes that you see formed by the grid are
+called cells. You can enter text, numbers or formulae in these cells.
+Of course, the whole &quot;raison d'etre&quot; of a spreadsheet
+application is to be able to carry out calculations within these
+cells. 
+</P>
+<P>Anyway, enough of the waffle, let's go and try our first
+calculation ! : 
+</P>
+<OL>
+	<P>In the cell A1 type (without the quotes) &quot;=3&quot; 
+	</P>
+	<P>Then press `<B>Enter</B>' on your keyboard 
+	</P>
+	<P>And you should see &quot;3&quot; appear in the cell, since the
+	result of the calculation appears automatically. 
+	</P>
+</OL>
+<P>Your cursor should now be in the cell immediately below the cell
+A1, but if you click once more in cell A1, you will see the
+mathematical operation that you have just entered shown in the
+<B>Calculation toolbar</B> .</P>
+<P>Let's carry on : now type 6 in cell A2 and we'll request the
+result of the addition of cell A1 to cell A2 and have the result
+displayed in cell A3. Here's how it's done :</P>
+<OL>
+	<P>Place the cursor in cell A2, and type 6 
+	</P>
+	<P>Confirm this data entry by pressing the button '<B>Enter</B>',
+	and your cursor will move to cell A3 
+	</P>
+	<P>Type (without quotes) &quot;=A1+A2&quot; 
+	</P>
+	<P>Confirm with `<B>Enter</B>', and you will see the result
+	displayed as &quot;11&quot; in cell A3 
+	</P>
+</OL>
+<P>This last calculation was carried out using the cell references
+and not discreet values.</P>
+<P>Let's go ever onward, and try adding up a whole column of cells,
+i.e. a range. Click on Sheet2 to get a clear sheet.</P>
+<OL>
+	<P>Type in some numbers in cells A1 to A9 
+	</P>
+	<P>Confirm with `<B>Enter</B>', and the cursor will move to cell A10
+		</P>
+	<P>Type (without quotes) &quot;=sum(A1:A9)&quot; 
+	</P>
+	<P>Confirm with `<B>Enter</B>', and you will view see the result of
+	the addition displayed in cell A10, and the formula will be visible
+	in the Calculation bar.</P>
+</OL>
+<P>By typing the colon [ : ] between the cell references, you have
+told the software that you want to add up the values in the range of
+cells from A1 to A9. The range is indicated on the screen by a red
+border.</P>
+<P>By typing `sum ()', you are telling the software the type of
+mathematical operation that you want to carry out on the referenced
+cells that are between parentheses.</P>
+<P><B><I>NB</I></B> : <I>You'll probably have noticed when you
+started to type `<B>sum</B>', that Calc suggested the completion of
+the formula. This is the <B>Autocomplete </B>function, with which it
+suffices to press `<B>Enter</B>' if you agree with the suggestion
+made by StarOffice, and your cursor will be positioned automatically
+between the parentheses so that all you have to do is enter the
+ranges.</I></P>
+<P>Right, let's do it again, only this time we'll replace the colon
+by a semi-colon (;) between A1 and A9. You'll notice that the result
+is completely different. In this case, you have only added up the
+contents of cell A1 to those of cell A9 and not the range. Thus, in
+order to add two ranges of cells, you would type &quot;=sum(A1:A9;B1:B9)&quot;.</P>
+<P>You can also select the ranges to be added together using the
+mouse. After having typed &quot;= sum(&quot; into the target cell,
+click on the first cell and whilst holding the mouse button down,
+drag the mouse to the last cell of the range, and then let go of the
+mouse button, and you will see the end of the formula inserted in
+automatically into the Formula bar.</P>
+<P><I><B>NB</B> : If the number that is displayed is too big to be
+displayed completely in the cell, it will be replaced by a series of
+musical flat symbols (<B>###</B>). In order to adjust the size of the
+cell, all you have to do is click on the right-hand column separator
+of any given column and drag the separator rightwards (to broaden) or
+leftwards (to narrow). The same function can be reached through the
+command <B>Format - Column - Optimal width</B>.</I></P>
+<P><U>About references</U></P>
+<P>It is important to grasp the basics of references when you want to
+carry out calculations on cells containing formulae.</P>
+<P STYLE="text-decoration: none">A relative reference is a range
+whose references are adjusted when the formula is moved : <BR>e.g.. :
+if you copy the formula &quot;=sum(A1:A9)&quot; to column B, it will
+become &quot;=sum(B1:B9)&quot; 
+</P>
+<P STYLE="text-decoration: none">An absolute reference is used when a
+calculation has to refer to a precise cell of the spreadsheet. This
+is written for example $A$1 to designate the absolute reference for
+column A and line 1. Thus $A1 is used as the absolute reference to
+column A and A$1 for the absolute reference to line 1. 
+</P>
+<P STYLE="text-decoration: none">Now that we've finished learning
+about simple calculations, let's exercise our brains (and fingers)
+with some subtractions,&nbsp; multiplications and divisions ! 
+</P>
+<H3 STYLE="margin-top: 0in"><A NAME="3"></A>3. Personalized
+formatting 
+</H3>
+<P>Your spreadsheet contains three sheets, Sheet1,2,3. We'll give
+each sheet a name (after all, it does make it easier to remember them
+!). Right-mouse button click on the tab of Sheet1, and a
+context-sensitive menu will appear offering you to `<B>Rename</B>'
+Click on this option. In the following window, enter the name you
+wish your sheet to have and click on `<B>OK</B>', the sheet will then
+display the new name in the tab. 
+</P>
+<P>You'll also have noticed that this context-sensitive menu offers
+you the choice&nbsp; of inserting or deleting the sheet as well as
+moving or copying it. Each time, a windowed dialog box will allow you
+to specify your precise choice. 
+</P>
+<P>Let's do some work on cell formatting. Suppose you want to enter
+the title of your spreadsheet over several sheets, do as follows : 
+</P>
+<UL>
+	<P>Select all the sheets in which the title is to appear. Then with
+	the mouse, click on the first cell and drag the mouse to the last
+	cell of the title . 
+	</P>
+	<P>In the menu toolbar, select : <B>Format - Merge Cells- Define</B>
+		</P>
+</UL>
+<P>More often than not, you will want to centre the title over the
+selected cells. In order to do so :</P>
+<UL>
+	<P>Select the title cell 
+	</P>
+	<P>In the menu toolbar, select: <B>Format - Cells</B> 
+	</P>
+	<P>In the dialog box that appears, select the tab&nbsp; `<B>Alignment</B>'
+		</P>
+	<P>Click on the button `<B>Center</B>' 
+	</P>
+	<P>You can also select&nbsp; other options in this dialog box if you
+	wish 
+	</P>
+	<P>Click on `<B>OK</B>' 
+	</P>
+</UL>
+<P>If you want to set a fine border around&nbsp; your table, select
+the cells, and from the menu toolbar&nbsp; choose <B>Format - Cells</B>
+and click on the tab&nbsp; `<B>Borders</B>'. Choose the thickness of
+the border that suits you as well as the border that you wish and
+click on `<B>OK</B>'.</P>
+<P>You will notice that the dialog box `<B>Cell Attributes</B>'
+comprises a certain number of tabbed pages relating to cell
+formatting (<B>Fonts, Font Effects, Alignment</B>). You can also
+reach these tabbed pages by right-mouse button clicking on a cell and
+selecting&nbsp; `<B>Format cells'</B>. And of course, the function
+toolbar also contains some of these formatting functions.</P>
+<P><IMG SRC="Image2.jpg" NAME="Image3" ALIGN=RIGHT WIDTH=84 HEIGHT=26 BORDER=0>Let's
+look at the last three icons of the function toolbar. These three
+icons allow you to position text at the top, middle and bottom of a
+cell respectively. Very handy !</P>
+<P>One last thing, in order to make our cells containing text to
+stand out on the sheet from those containing&nbsp; numbers and
+formulae, you can use the&nbsp; `<B>Value Highlighting</B>' :</P>
+<UL>
+	<P>From the menu toolbar, choose <B>View - Value Highlighting</B>, 
+	</P>
+	<P>You will note that all of the text is displayed in black, all of
+	the numbers in blue and all of the formulae in green. 
+	</P>
+</UL>
+<P><I><B>NB :</B> In order to directly format your cell as one
+containing text, enter an apostrophe ( ` )&nbsp; into the cell before
+typing your word , e.g. : `Price</I></P>
+<P>&nbsp;</P>
+<P>At last , our sheet is starting to take shape !</P>
+<P>Let's look at the page settings now. Perhaps you find it easier to
+work with landscape style pages, so do as follows :</P>
+<OL>
+	<P>From the menu toolbar, choose <B>Format - Page</B> 
+	</P>
+	<P>Click on the tab `<B>Page'</B> 
+	</P>
+	<P>At the section 'Orientation', click on the radio button
+	`<B>Landscape'</B> 
+	</P>
+	<P>Confirm with `<B>OK'</B> 
+	</P>
+</OL>
+<P>In order to check that your sheet has indeed been saved in the
+landscape format, click on&nbsp; <B>File - Preview</B> in the menu
+toolbar.</P>
+<P>Staying now with the page dialog box for a while, you can add a
+header, footer, and of course page numbers.</P>
+<P>Let's look at this aspect more closely :</P>
+<OL>
+	<P>From the menu toolbar, choose <B>Format - Page</B> 
+	</P>
+	<P>Click on the tab `<B>Footer</B>' 
+	</P>
+	<P>In the window that appears, click on the bow that says&nbsp;
+	`<B>Footer on</B>' 
+	</P>
+	<P>The button `<B>Options</B>' allows you to add a border or
+	background to the footer 
+	</P>
+	<P>Click on the button&nbsp; `<B>Edit</B>' 
+	</P>
+	<P>In the window that appears, you will see three smaller windows
+	and a series of icons. The smaller windows correspond to tabulation
+	marks inserted into the footer and the icons to field instructions.
+	The one that we're interested in has a musical flat sign (<B>#</B>)
+	on it . 
+	</P>
+	<P>Place your cursor onto the small window that you wish to use 
+	</P>
+	<P>Click on the icon `<B>Page</B>' (illustrated by a single #), you
+	will see the page number written into the selected window 
+	</P>
+	<P>Click on `<B>OK</B>' to return to the `<B>Page Style</B>' window.
+		</P>
+	<P>Click on `<B>OK</B>' to close this window. 
+	</P>
+</OL>
+<P><I><B>NB :</B> You can of course insert any text that you want
+into the header or the footer, and in the same way, your company or
+group logo.</I></P>
+<H3 STYLE="margin-top: 0in"><A NAME="4"></A><B>4. Printing your work</B></H3>
+<P>It may be that you only want to print part of your spreadsheet, or
+even only one sheet, or on the other hand, maybe the whole
+workfolder.</P>
+<P>In order to print just an area of your sheet proceed as follows :</P>
+<UL>
+	<P>Select the zone you wish to print with the mouse or the keyboard 
+	</P>
+	<P>Choose <B>Format - Print ranges... </B>from&nbsp; the menu
+	toolbar. 
+	</P>
+	<P>Click on `<B>Define</B>' 
+	</P>
+	<P>You will see the selected print range appear on the sheet as two
+	slightly darkened grey lines. You can check that you've selected the
+	correct area by looking at the preview of the range to be printed. 
+	</P>
+</UL>
+<P><I><B>NB :</B> In the drop-down menu under <B>Format - Print
+ranges</B>, you can also add other ranges of your document to be
+printed. Select the range and click on Add. This second print range
+will be printed on a second page (even though it forms part of the
+same sheet screen).</I></P>
+<P>In order to print a single sheet from your workfolder:</P>
+<UL>
+	<P>click on <B>File - Print </B>from the menu toolbar 
+	</P>
+	<P>In the dialog box that appears, under `<B>Print Range</B>' click
+	on the radio button `Pages' and enter the page number that you wish
+	to print out. 
+	</P>
+	<P>Click on `<B>OK</B>' to start printing 
+	</P>
+</UL>
+<P>In the same Print range field of the dialog box, you could also
+have indicated for example (2,3) to print page 2 and page 3 or even
+(2-5) to print from page 2 to page 5 .</P>
+<P>A quicker way is to select the sheets to be printed&nbsp; and then
+to click on the print icon in the function bar. To do this :</P>
+<UL>
+	<P>Click on the sheet tab at the bottom of the sheet and select the
+	ones you wish to print by holding down the <B>CTRL</B> key on your
+	keyboard. In this way, you do a multiple selection of the sheets 
+	</P>
+	<P>Click on the icon&nbsp; `<B>Quick printing</B>' in the function
+	toolbar. Off it goes ! 
+	</P>
+	<P>To undo your selection, click once more on the sheet tab and hold
+	the <B>CTRL</B> key down.</P>
+</UL>
+<P>In order to print only certain columns or lines from your sheet :</P>
+<UL>
+	<P>Select the lines or columns to print 
+	</P>
+	<P>Select `<B>File - Print</B>' from the menu toolbar 
+	</P>
+	<P>In the dialog box that appears, click on the box `<B>Selection</B>'
+	in `Print range' 
+	</P>
+	<P>Click on `<B>OK</B>' 
+	</P>
+</UL>
+<H3 STYLE="margin-top: 0in"><A NAME="5"></A><B>5. Credits</B></H3>
+<P><B>Author</B> : Sophie Gautier</P>
+<P><B>Thanks to</B> : Alexander Thurgood for his precious help</P>
+<P><B>Intgr by</B> : Gianluca Turconi</P>
+<P><B>Last modified</B> : January 16, 2002</P>
+<P><B>Contacts</B> : OpenOffice.org Documentation Project
+<A HREF="http://documentation.openoffice.org/index.html">http://documentation.openoffice.org/index.html</A></P>
+<P><B>Translation</B> : Alexander Thurgood 
+</P>
+<P>&nbsp;</P>
+</BODY>
+</HTML>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc1_EN.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2HTML.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2HTML.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2HTML.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2PDF.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2PDF.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2PDF.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,170 @@
+<html><head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<BODY >
+<H2  ALIGN=CENTER>&nbsp;</H2>
+<H2  ALIGN=CENTER>&nbsp;</H2>
+<h2 align="center">How to utilize Sort Lists and AutoFill </h2>
+<P  ALIGN=CENTER><BR><BR>
+</P>
+<H5  ALIGN=CENTER><I>Provided from</I></H5>
+<H5  ALIGN=CENTER><I>the OpenOffice.org Documentation
+Project</I></H5>
+<P><BR><BR>
+</P>
+<DIV ID="Table of Contents1"> 
+  <DIV ID="Table of Contents1_Head"> 
+    <P><FONT SIZE=4 STYLE="font-size: 16pt"><B>Table 
+      of Contents</B></FONT></P>
+  </DIV>
+</DIV>
+<ol>
+  <li> 
+    <DIV ID="Table of Contents1"><a href="#1">Introduction </a></DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><a href="#2">Sort Lists </a></DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><a href="#3">AutoFill </a></DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><a href="#4">Credits </a></DIV>
+  </li>
+  <P></P>
+</ol>
+<H3><A NAME="1"></A> 1. Introduction</H3>
+<P>These automations make data insertion easier in Calc. For instance, when you 
+  type Monday into a cell, there is a mechanism to allow inserting all the days 
+  of the week. The same mechanism works for month lists, as well. OpenOffice.org 
+  allows you to automatically insert the most used Sort Lists. </P>
+<P>It's the same for a number or date series. With a single click or dragging 
+  action, you will be able to increase the series of numbers or years. Very practical, 
+  isn't it?</P>
+<H3><A NAME="2"></A>2. Sort Lists</H3>
+<P>Here's an easy example: Type the word January in a cell, select the cell (it 
+  has to be surrounded from a thick rectangle with a small square on the lower 
+  right corner), and click on that square without releasing the mouse button and 
+  drag the mouse.</P>
+<P><IMG SRC="list1.GIF" NAME="Graphic1" ALT="list example 1" ALIGN=BOTTOM WIDTH=241 HEIGHT=245 BORDER=0></P>
+<P><BR>
+  Magic! By dragging the mouse, the words are automatically displayed in a yellow 
+  floating info box. Stop at March and the cells will be automatically updated.</P>
+<P><IMG SRC="list2.GIF" NAME="Graphic2" ALT="list example 2" ALIGN=LEFT WIDTH=124 HEIGHT=107 BORDER=0></P>
+<P>&nbsp;</P>
+<P>&nbsp;</P>
+<P>&nbsp;</P>
+<P>These lists are already recorded in the software; there are a lot of them, 
+  and of course, you can record your own lists. Let's see how this is possible.</P>
+<UL>
+  <LI>In <B>Tools-Options-Spreadsheet-Sort Lists,</B> let's discover those lists 
+    that are already present
+</UL>
+<P><img src="list3.GIF" width="709" height="362"><BR>
+  There are 4 default recorded lists. In the image above, there is an additional 
+  custom list. </P>
+<P>You can insert them from the left, right, upwards, or downwards. Of course, 
+  the order will be respected: If you start with Monday then drag your mouse upwards, 
+  the next displayed day will be Sunday. Same thing, if you drag your mouse to 
+  the left.</P>
+<ol>
+  <li>Now, we'll create our own sort list</li>
+  <li>Type the list in your sheet,</li>
+  <li>Select it by highlighting,</li>
+  <li>Choose <B>Tools-Options-Spreadsheet-Sort Lists, </B></li>
+  <li>In the dialog window that it will appear, you'll see the '<B>Copy'</B> button. 
+    Next to this button there is a text box, named '<B>Copy list from</B>'. You 
+    should read there the sheet name and the cells range you have previously selected,</li>
+  <li>Click on the '<B>Copy</B>' button,</li>
+  <li>Then, your custom sort list is listed in the main Sort Lists text box!</li>
+</ol>
+<P><IMG SRC="list4.GIF" NAME="Graphic4" ALT="list example 4" ALIGN=BOTTOM WIDTH=588 HEIGHT=297 BORDER=0><BR>
+  <BR>
+  <BR>
+</P>
+<P>Now, you are able to use it in your sheets, in 
+  every way, being sure that the order will always be respected. In fact, you 
+  can start from whichever element of the list you choose.</P>
+<P>If you don't wish to keep that sample list: </P>
+<UL>
+  <LI>Select it in the Sort Lists windows and click on the '<B>Delete</B>' button 
+    to remove it.
+</UL>
+<H3><A NAME="3"></A>3. AutoFill</H3>
+<P>The AutoFill is similar to the procedure described above.</P>
+<ol>
+  <li>Select a cell range,</li>
+  <li>Under <B>Edit-Fill</B>; Choose '<B>Series...</B>' ,</li>
+</ol>
+<P><IMG SRC="remp1.GIF" NAME="Graphic5" ALT="filling window" ALIGN=BOTTOM WIDTH=614 HEIGHT=220 BORDER=0><BR>
+</p>
+<ol>
+  <li>In the <B>Direction section, </B>determine in which direction you wish to 
+    fill your cells</li>
+  <li>For the time being, in <B>Series Type, </B>choose<B> Linear,</B></li>
+  <li>In <B>Start value,</B> type '2'; in <B>End value,</B> insert '16'; and finally 
+    in <B>Increment,</B> type '2'. We have set up to fill the cells with numbers 
+    from 2 to 16 incremented progressively by 2. </li>
+  <li>Let's see the result:</li>
+</ol>
+<P><IMG SRC="remp2.jpg" NAME="Graphic6" ALT="filling example 2" ALIGN=LEFT WIDTH=153 HEIGHT=172 BORDER=0><BR>
+  <BR>
+</P>
+<P><BR>
+  <BR>
+</P>
+<P><BR>
+  <BR>
+  <BR>
+</P>
+<P>Wonderful! We have filled 8 cells only, but try to imagine if there were 3000. 
+  What a time savings!</P>
+<P>Let's analyse the other filling options:</P>
+<UL>
+  <LI>'<B>Growth</B>': it's similar to linear, but this option allows not selecting 
+    the exact range of cells to be filled; though it is obligatory to insert the 
+    <B>End value. E</B>ven if you have selected only a few cells, the filling 
+    action will continue until the End Value has been reached, while the linear 
+    mode respects the number of cells you have selected,
+  <LI>'<B>Date</B>': gives you the access to the section '<B>Time Unit</B>'. It's 
+    an explicit choice, you have to select what you wish to be displayed. Remember 
+    to fill the fields '<B>Start Value</B>', '<B>End Value</B>', and '<B>Increment</B>'
+  <LI>AutoFill: will fill your cells from a start value.
+</UL>
+<P><I><B>Note</B> : As far as the Date 
+  AutoFill is concerned, don't forget to format your cells with the format <B>'Date'</B> 
+  in the format <B>'Number' </B>as they are by default; otherwise, you'll get 
+  the wrong result.<BR>
+  After you have acknowledged your mistake after the AutoFill action, selecting 
+  the related cell range and formatting it correctly will resolve the issue. </I></P>
+<P>A faster trick is:</P>
+<OL>
+  <LI>Type 1 inside cell A1,
+  <LI>Type 3 inside cell A2,
+  <LI>Select both cells by clicking on the first, hold down the [<B>SHIFT</B>] 
+    key, and press the arrow key,
+  <LI>Click the little square on the bottom right corner of the highlighted area 
+    and drag downward with the mouse, your cells will be increased 2 by 2!
+</OL>
+<H3><A NAME="4"></A> 4. Credits</H3>
+<P><B>Author</B>: Sophie 
+  Gautier</P>
+<P><B>Thanks</B>: Richard 
+  Holt, great proof reader and OOo contributor</P>
+<P><B>Intgr by</B>: 
+  Gianluca Turconi</P>
+<P><B>Last modified</B>: 
+  10 February, 2002</P>
+<P><B>Contacts</B>:<SPAN STYLE="font-weight: medium">OpenOffice.org 
+  Documentation Project </SPAN><A HREF="http://documentation.openoffice.org/index.html"><SPAN STYLE="font-weight: medium">http://documentation.openoffice.org/index.html</SPAN></A></P>
+<P><B>Translation</B>: 
+  Gianluca Turconi</P>
+<H3><BR>
+  <BR>
+</H3>
+<P><BR>
+  <BR>
+</P>
+</BODY>
+</html>
+

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc2_EN.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3HTML.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3HTML.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3HTML.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3PDF.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3PDF.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3PDF.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,151 @@
+<html><head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<BODY LANG="en-US">
+<H2  ALIGN=CENTER>&nbsp;</H2>
+<H2  ALIGN=CENTER>&nbsp;</H2>
+<H2  ALIGN=CENTER>How to apply</H2>
+<H2  ALIGN=CENTER>Conditional Formatting to a Cell</H2>
+<P ALIGN=CENTER><BR><BR>
+</P>
+<H5  ALIGN=CENTER><I>Provided from</I></H5>
+<H5  ALIGN=CENTER><I>the OpenOffice.org Documentation
+Project</I></H5>
+<P ALIGN=CENTER STYLE="page-break-before: always"><BR><BR>
+</P>
+<DIV ID="Table of Contents1"> 
+  <DIV ID="Table of Contents1_Head"> 
+    <P><FONT FACE="Arial"><FONT><B>Table 
+      of Contents</B></FONT></FONT><BR>
+    </P>
+  </DIV>
+  </DIV>
+<ol>
+  <li> 
+    <DIV ID="Table of Contents1"> 
+      <DIV ID="Table of Contents1"><FONT FACE="Times New Roman"> <a href="#1">Introduction: 
+        an example </a></FONT></DIV>
+    </DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><FONT FACE="Times New Roman"> <a href="#2">Create 
+      a new Style 3</a></FONT></DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><FONT FACE="Times New Roman"> <a href="#3">Apply 
+      the Conditional Formatting </a></FONT></DIV>
+  </li>
+  <li> 
+    <DIV ID="Table of Contents1"><FONT FACE="Times New Roman"><a href="#4">Credits 
+      </a></FONT></DIV>
+  </li>
+</ol>
+<H3><A NAME="1"></A> 
+  1. Introduction: an example</H3>
+<P><FONT>You 
+  are a bookseller and sell books every day. You'd like to highlight, in color, 
+  the number of books sold during a week with the result displayed in yellow if 
+  less than 100 and in blue if 100 or more were sold.</FONT></P>
+<P><FONT>To 
+  do so, you have to create 2 new styles for each color and 2 formatting conditions: 
+  one for numbers less than 100 and another for those numbers greater than or 
+  equal to 100.</FONT></P>
+<P><FONT>Let's 
+  do it!</FONT></P>
+<H3><A NAME="2"></A>2. Create a new Style</H3>
+<P><FONT>To 
+  create a new Style, open the <B>Stylist</B>: </FONT> </P>
+<UL>
+  <LI><FONT>choose <B>Format&ndash;Stylist</B></FONT>
+  <LI><FONT>or press <B>F11 </B>key,</FONT>
+  <LI><FONT>or click the <B>Stylist icon</B> on the <B>Function bar</B>: <IMG SRC="sty1.jpg" NAME="Image1" ALIGN=BOTTOM WIDTH=28 HEIGHT=29 BORDER=0></FONT>
+</UL>
+<P><FONT>In 
+  the Stylist window, there are several styles ready to use. You'll use the <B>Default</B> 
+  style as a base to create your own:</FONT></P>
+<UL>
+  <LI><FONT>select the <B>Default </B>style,</FONT>
+  <LI><FONT>right click on it to access the context menu,</FONT>
+  <LI><FONT>choose <B>New...</B></FONT>
+</UL>
+<P><IMG SRC="sty2.GIF" NAME="Graphic1" ALIGN=LEFT WIDTH=633 HEIGHT=194 BORDER=0 alt="conditional formatting window"><BR CLEAR=LEFT>
+  <FONT>The dialog window that will appear has several tabs as in the diagram 
+  below:</FONT></P>
+<UL>
+  <LI>
+    <P  STYLE="margin-bottom: 0cm">in the <B>Organizer 
+      </B><SPAN STYLE="font-weight: medium">tab</SPAN><B>,</B> type a name for 
+      your style; here it is simply called '<B>blue</B>', </P>
+  <LI>
+    <P  STYLE="margin-bottom: 0cm">now switch to 
+      the <B>Background </B>tab and <FONT>choose a blue color in the color 
+      palette,</FONT></P>
+  <LI><FONT>now switch to the Font tab, scroll to find <B>Automatic</B>, and click 
+    <B>OK.</B></FONT>
+</UL>
+<P><FONT>In 
+  the Stylist, your new style will be displayed with the name you gave it. Repeat 
+  the steps above to create the style '<B>yellow</B>'.</FONT></P>
+<P><IMG SRC="sty3.GIF" NAME="Graphic2" ALIGN=BOTTOM WIDTH=200 HEIGHT=222 BORDER=0><BR>
+  <I><B>Note</B>: You have created a background style, but of course you may apply 
+  other features to that style. By clicking on the other tabs, you may access 
+  many other functions, such as, apply a border, change font, alignment, etc.</I></P>
+<H3><A NAME="3"></A>3. Apply the Conditional Formatting</H3>
+<P> 
+  <FONT>You have typed your figures, inserted your formulas in the cells, 
+  and now you wish to add some colors!</FONT></P>
+<P> 
+  <FONT>In our example, the colors are to be displayed in cell [<B>B9</B>]</FONT></P>
+<OL>
+  <LI> Select the cell [<B>B9</B>]
+  <LI> <FONT>in the <B>Format </B>menu, choose <B>Conditional Formatting</B></FONT>
+  <LI> 
+      <FONT>In the window that will appear, you'll insert your condition:</FONT>
+<P  STYLE="margin-bottom: 0cm"><img src="sty4_bis.gif" width="749" height="347"></P>
+  <LI> <FONT>under <B>Condition 1</B>, click the small triangle of the first drop-down 
+    menu and choose '<B>Cell value is'</B></FONT>
+  <LI> Then, in the second drop-down menu, choose '<B>greater than'</B>
+  <LI> <FONT>in the next box to the right, insert the value, 99. Eventually, you 
+    can change the selected cell by clicking on the <B>Shrink icon <IMG SRC="shrink_icon.GIF" NAME="Graphic4" ALT="shrink icon" ALIGN=BOTTOM WIDTH=28 HEIGHT=24 BORDER=0></B></FONT>
+  <LI><SPAN STYLE="font-style: normal"><FONT>In the drop-down menu labeled, <B>Cell 
+    Style</B>, search and select the '<B>Blue</B>' style,</FONT></SPAN>
+  <LI> <FONT>Check the <B>Condition 2 </B>check-box, repeat steps from 
+    4 up to 7, but use <B>'less than', a value of '100',</B> and <B>'yellow' </B>style 
+    where applicable,</FONT> 
+  <li><FONT>Click on <B>OK,</B></FONT></li>
+</OL>
+<P> <FONT>Look at the result: type in '122' in cell [B9] and the color 
+  changes!</FONT></p>
+<H3><IMG SRC="sty5.GIF" NAME="Graphic5" ALIGN=LEFT WIDTH=327 HEIGHT=217 BORDER=0></H3>
+<H3>&nbsp;</H3>
+<H3>&nbsp;</H3>
+<H3>&nbsp;</H3>
+<H3>&nbsp;</H3>
+<H3>&nbsp;</H3>
+<H3><BR>
+</H3>
+<H3><B>4. Credits
+  </B><A NAME="4"></A></H3>
+<P><B>Author</B>: Sophie 
+  Gautier</P>
+<P><B>Thanks to</B>: 
+  Richard Holt, great proof reader and OOo contributor</P>
+<P><B>Intgr by</B>: 
+  Gianluca Turconi</P>
+<P><B>Last modified</B>: 
+  January 28, 2002</P>
+<P><B>Contacts</B>: 
+  <SPAN STYLE="font-weight: medium">OpenOffice.org Documentation Project </SPAN><A HREF="http://documentation.openoffice.org/index.html"><SPAN STYLE="font-weight: medium">http://documentation.openoffice.org/index.html</SPAN></A></P>
+<P><B>Translation</B>: 
+  Gianluca Turconi</P>
+<H3><BR>
+  <BR>
+</H3>
+<P>&nbsp;</P>
+<P>
+  <!--EndFragment-->
+  <BR>
+  <BR>
+</P>
+</BODY></html>
+

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc3_EN.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,167 @@
+<html><head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<BODY>
+<h2>&nbsp;</h2>
+<h2>&nbsp;</h2>
+<h2 align="center">How to Format a Spreadsheet</h2>
+<h2>&nbsp;</h2>
+<p align="center"><i>provided by the OpenOffice.org Documentation Project</i></p>
+<p align="center">&nbsp;</p>
+<h3><B>Table of Contents</B><SPAN STYLE="font-weight: medium">:</SPAN></h3>
+<ol>
+  <li><SPAN STYLE="font-weight: medium"><A HREF="#1">Applying a style:</A></SPAN> 
+    <ul>
+      <li><SPAN STYLE="font-weight: medium">to a cell</SPAN></li>
+      <li><SPAN STYLE="font-weight: medium">to a page</SPAN></li>
+    </ul>
+  </li>
+  <li><A HREF="#2"><SPAN STYLE="font-weight: medium">Using the AutoFormat feature</SPAN></A></li>
+  <li><A HREF="#3"><SPAN STYLE="font-weight: medium">Using the Themes</SPAN></A></li>
+  <li><A HREF="#4"><SPAN STYLE="font-weight: medium">Credits</SPAN></A></li>
+</ol>
+<h3><A NAME="1"></A><B>1. Applying a style</B></h3><br>
+<P><strong>A. -- to a cell</strong></P>
+<P>Open the <B>Stylist</B>: </P>
+<UL>
+  <LI> 
+    <P>choose <B>Format &#150; Stylist</B>,</P>
+  <LI> 
+    <P>or press<B> F11</B>, </P>
+  <LI> 
+    <P>or click the icon <IMG SRC="sty1.jpg" NAME="Image1" ALIGN=BOTTOM WIDTH=28 HEIGHT=29 BORDER=0> 
+      on the <b>Function Bar.</b></P>
+</UL>
+<P>Inside the Stylist window, there are several ready-to-use styles. You may choose 
+  the <B>Default</B> style to modify it as you wish:</P>
+<UL>
+  <LI> 
+    <P>select the <B>Default style</B></P>
+  
+  <LI>
+    <P>right click to display the context menu</P>
+  
+  <LI>
+    <P>choose <B>Modify...</B></P>
+  
+</UL>
+<P><IMG SRC="sty2.gif" NAME="Image2" ALIGN=LEFT WIDTH=550 HEIGHT=386 BORDER=0 alt="Modify Style Window"><BR CLEAR=LEFT>
+  This new window includes all tabs needed to format your cells, either for the 
+  fonts, alignment, or numbers. In fact, it's this latter tab which is the 
+  most used.</P>
+<P>Let's take a look at the <B>Currency </B>setting of the <b>Numbers </b>tab. Here, 
+  you can choose which currency you wish to work with. Below, you can see what 
+  is displayed if you click on this category:</P>
+<P><IMG SRC="sty3.gif" NAME="Image3" ALIGN=LEFT WIDTH=500 HEIGHT=304 BORDER=0 alt="Numbers tab"><BR CLEAR=LEFT>
+  A box called <B>Format</B> is displayed. Select your currency and an example 
+  is shown just to the right. The language is what you have chosen by default 
+  in the global options of your OOo Suite.</P>
+<P>Under '<B>Options</B>', select the number of decimal places that you wish to be 
+  displayed, the color of the negative numbers, etc.</P>
+<P>When you have completed your choices, click the <B>OK</B> button and all cells 
+  formatted with the Default style will be changed according to the new settings..</P>
+<P><I><B>Note</B> 
+ : If you don't want to accept the style of some cell, select it and instead 
+  of changing the Default standard, when the right click context menu appears, select <b>New....</b> 
+  In this way you'll be able to create your own style. Repeat the same actions 
+  you may have done for the Default style changes. Then, give it  
+  a name for the new style in the <b>Organizer</b> tab and click on <b>OK </b>to 
+  have the new style displayed in the Stylist window<b>.</b><BR>
+  To apply it to a cell, locate your cursor inside the cell and then double click 
+  on the name style, inside the Stylist.</I></P><br>
+<P><strong>B. -- to a page</strong></P>
+<P>Once more, everything happens inside the <B>Stylist</B>.</P>
+<UL>
+  <LI>
+    <P>Click the second icon of the <B>Stylist</B> to access the '<b>Page Styles</b>'</P>
+  
+  <LI>
+    <P>Right click on the '<B>Default</B>' style and choose <B>Modify...</B></P>
+  
+  <LI>
+    <P>The windows that will appear have some new 
+      tabs:</P>
+  
+</UL>
+<P><IMG SRC="sty4.gif" NAME="Image4" ALIGN=LEFT WIDTH=500 HEIGHT=351 BORDER=0 alt="Page tab"><BR CLEAR=LEFT>
+  Remember: it's inside this page that you can set the header and the footer 
+  of your sheets and the color of the background too. Some tabs are the same as 
+  we have found in the previous procedure, so they will not be explained again.</P>
+<P>Instead, pay attention to the <B>Page </B>tab:</P>
+<ul>
+  <li>in the <b>Paper Format</b> section, you can choose not only the paper type 
+    of the output but also its orientation. The sheet displayed to the right 
+    reflects your changes in a mini-preview,</li>
+  <li>in the <b>Margins </b>section, you set the margin sizes. If you set them 
+    beyond the printing area, a message will warn you.</li>
+  <li>in the <b>Layout section, </b> '<B>Page Layout </B>' lets you select how 
+    to align the content of the cells inside the sheet. Make your choices!</li>
+</ul>
+<P>Now, let's examine another very interesting tab: 
+  the <B>Sheet.</B></P>
+<P><IMG SRC="sty5.gif" NAME="Image5" ALIGN=LEFT WIDTH=500 HEIGHT=351 BORDER=0 alt="Sheet tab"><BR CLEAR=LEFT>
+  It's self-explanatory, except for the section, <B>Scale</B>, which is a bit obscure:
+	</P>	
+<UL>
+  <LI>
+    <P>'<B>Reduce/enlarge printout</B>' allows you to decrease or increase the 
+      size of the print image of your sheet</P>
+  <LI>
+    <P>'<B>Fit printout on number of pages</B>' allows 
+      you to determine the exact number of pages on which the spreadsheet will 
+      be printed. The size of the sheets will be adjusted to fit that number.</P>
+</UL>
+<h3><A NAME="2"></A><B>2. Using the AutoFormat feature </B></h3>
+<P><I><B>Attention</B>: to use this feature, you 
+  have to select, by highlighting an area of cells, because the function isn't for one 
+  or two cells only, but rather for a range.</I></P>
+<P>You can access the formatter by selecting '<B>AutoFormat</B>' 
+  from the menu, <B>Format</B>, or by clicking on this icon: <IMG SRC="aut1.jpg" NAME="Image6" ALIGN=BOTTOM HSPACE=8 WIDTH=23 HEIGHT=29 BORDER=0 alt="AutoFormat icon">that 
+  you find in the Toolbar to the left of your display.</P>
+<P><img src="aut2.gif" width="600" height="217" alt="AutoFormat window"><BR CLEAR=LEFT>
+  Incredible! It seems that the whole presentation work has been done automatically! 
+ :-)</P>
+<P>You only have to click on the format's name tabs to 
+  select what you prefer!</P>
+<P>Of course, you can create your own format (see 
+  the <b>Add.... </b>button to the right) and, eventually, delete it when you 
+  think that its look and feel doesn't reflect the fashion of the moment anymore!</P>
+<P>By clicking on <B>More</B>, some additional formatting options 
+  appear. If you modify them, the result will be presented in the preview image 
+  displayed in the AutoFormat window.</P>
+<P><I><B>Note </B>: if you want to undo an AutoFormat 
+  action, select the zone to which you have applied the style, right click on 
+  it to display the context menu and choose <b>'Default'</b>.</I></P>
+<h3><A NAME="3"></A><B>3. Using Themes from the Gallery</B></h3>
+<P>They consist of a collection of cell styles, Themes, 
+  whose settings are fixed, but whose styles are interchangeble.</P>
+<p>To understand how they work:</p>
+<ul>
+  <li>open the <B>Gallery<!-- Stylist --></B></li>
+  <li>click on the '<B>Choose Theme</B>' in the Toolbar to the left of your display. 
+    It's just below the AutoFormat icon.</li>
+  <li>choose the '<B>Blue jeans</B>' theme in the selection window,</li>
+  <li>pay attention to the custom cell styles that are displayed in the <B>Stylist</B>,</li>
+  <li>your page will be modified according to the theme you have chosen,</li>
+  <li>click on <B>OK</B> to close the selection window,</li>
+  <li>now, click on the cell style to see how they are shown and, eventually, 
+    modify them to change your sheet pagination.</li>
+</ul>
+<P>Yes, to utilize these themes, it is necessary 
+  to learn a bit about them, but it's so easy to learn!</P>
+<h3><A NAME="4"></A><B>4. Credits</B></h3>
+<div> 
+  <p><b>Author</b>: Sophie Gautier</p>
+  <p><b>Thanks to</b>: Richard Holt, great proofreader and OOo contributor</p>
+  <p><b>Intgr by</b>: Gianluca Turconi</p><!-- rh: Best to spell out "Intgr", does it mean integrated? -->
+  <p><b>Last modified</b>: February 18, 2002</p>
+  <p><b>Contacts</b>: <span style="font-weight: medium">OpenOffice.org Documentation 
+    Project </span><a href="http://documentation.openoffice.org/index.html"><span style="font-weight: medium">http://documentation.openoffice.org/index.html</span></a></p>
+  <p><b>Translation</b>: Gianluca Turconi</p>
+</div>
+<div></div>
+<P>&nbsp; </P>
+<P>&nbsp;</P>
+</BODY>
+</html>
+

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_HTML.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_HTML.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_HTML.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_PDF.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_PDF.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc4_EN_PDF.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.html
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.html?rev=1204763&view=auto
==============================================================================
--- incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.html (added)
+++ incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.html Tue Nov 22 00:35:05 2011
@@ -0,0 +1,98 @@
+<html>
+<head>
+<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">
+</head>
+<body>
+<h2 align="center">&nbsp;</h2>
+<h2 align="center">&nbsp;</h2>
+<h2 align="center"><B>How to set the Printing Settings</B></h2>
+<h2 align="center">&nbsp;</h2>
+<p align="center"><i>provided by</i></p>
+<p align="center"><i>the OpenOffice.org Documentation Project</i></p>
+<P><BR>
+</P>
+<h3><B>Table of Contents</B></h3>
+<ol>
+  <li><A HREF="#1">Printing a range</A></li>
+  <li><A HREF="#2">The Sheet Options</A></li>
+  <li><A HREF="#3">Printing a Sheet</A></li>
+  <li><A HREF="#4">Credits</A></li>
+</ol>
+<h3><A NAME="1"></A><B>1. Printing a range</B></h3>
+<P>OpenOffice.org gives you the ability to print a selected zone of your 
+  spreadsheet. To see how to perform this action:</P>
+<UL>
+  <LI>Highlight the zone that you wish to print (it may be, for example, only 
+    the result column, while you don't want to print the intermediate figures).
+  <LI>In the <B>Format </B>menu, select<b> 'Print Range'</b> and then '<B>Define</B>'.
+  <LI>Your range is now defined and you can see it highlighted in your sheet with 
+    a thicker line. <!-- rh: GT, did this get translated? "voir mat&eacute;rialis&eacute;e par des lignes d'un gris un peu plus fonc&eacute; sur votre feuille." --> 
+    <P><img src="zon1.gif" width="515" height="237" alt="zone 1"><BR CLEAR=LEFT>
+      In the page preview (<b>File-Page Preview</b>), you can verify that only 
+      the selected columns and rows will be printed.</P>
+  <LI>You can add as many printing ranges as you wish, you need only to select 
+    the new zone and under <B>Format-Print Range</B>, choose '<B>Add</B>'.<br> 
+    Pay attention! Each zone will be printed on a separated page.
+  <LI>To verify (or modify) the zone you chose, select <B>Format-Print Range-Edit...</B>
+<P><img src="zon2.gif" width="600" height="180" alt="zone 2"><BR CLEAR=LEFT>
+      The printing range selected is displayed in the first line called '<B>user 
+      defined</B>'.</P>
+  <LI>The following two lines are related to rows or columns that you wish to 
+    repeat while your zone is printed. You can:
+<ul>
+      <li>either directly insert the cell references by hand,</li>
+      <li>or click the small icon you see to the right of the window, then 
+        click and drag the mouse inside your sheet to select the zone you wish 
+        to repeat.</li>
+    </ul>
+</UL>
+<h3><A NAME="2"></A><B>2. The Sheet Options</B></h3>
+<P>The greater part of the printing options, for a sheet, are accessible with the menu 
+  command, <B>Format -&gt; Page</B> in the <B>Sheet </B>tab.</P>
+<P><img src="sty5.gif" width="550" height="465" alt="Page Style Window"><BR CLEAR=LEFT>
+</P>
+<p>It's self-explanatory, except for the section, <b>Scale</b>, which is a bit 
+  obscure: </p>
+<ul>
+  <LI>'<b>Reduce/enlarge printout</b>' allows you to decrease or increase the 
+    size of the print image of your sheet.
+  <LI>'<b>Fit printout on number of pages</b>' allows you to determine the exact 
+    number of pages on which the spreadsheet will be printed. The size of the 
+    sheets will be adjusted to fit that number.
+</ul>
+<P>You can access this window also from the Page Preview by clicking on 
+  the last icon of the Toolbar. <img src="sty6.gif" width="24" height="20" alt="Page Style icon"></P>
+<h3><A NAME="3"></A><B>3. Printing a Sheet</B></h3>
+<P>A trick to print faster some particular sheets from a group or workbook (let's say the 2nd 
+  and the 4th one):</P>
+<UL>
+  <LI>click on the tab of the second sheet to select it,
+  <LI>while holding the <B>CTRL</B> key down, click on the 4th sheet. Both sheets 
+    will be selected,
+  <LI>click on the<b> Print File directly </b>icon and, &quot;hocus pocus&quot;, 
+    the magic is done!
+</UL>
+<P><I><B>Note</B>: if you wish to insert the same 
+  thing into different sheets, select them as you have just done for printing them, 
+  then insert your data in the cell that you can see, and that insertion will be 
+  repeated in all the sheets you have selected. (It's the power of a carbon copy on 
+  your display!)</I></P>
+<P>You can find other printing options by selecting <B>File-Print... </B>from 
+  the Menu bar. If you click on the '<B>Options</B>' button, you'll have the possibility 
+  to suppress the output of empty pages or to print only the selected sheets.</P>
+<P>To display a break page preview before printing your sheet:</P>
+<UL>
+  <LI>select <B>View -Break Page preview </B>from the menu bar. 
+    <P><img src="pag1.gif" width="296" height="142"></P>
+</UL>
+<p>The sections that will be printed are highlighted with a blue border.</p>
+
+<h3><A NAME="4"></A><B>4. Credits</B></h3>
+<p><b>Author</b>: Sophie Gautier</p>
+<p><b>Translation</b>: Gianluca Turconi</p>
+<p><b>Thanks</b>: Richard Holt, proofreader and OOo contributor</p><!-- Great is too much. :-)) -->
+<p><b>Integration by</b>: Gianluca Turconi</p>
+<p><b>Last modified</b>: February 24, 2002</p>
+<p><b>Contacts</b>: <span>OpenOffice.org Documentation Project </span><a href="http://documentation.openoffice.org/index.html"><span>http://documentation.openoffice.org/index.html</span></a></p>
+</BODY>
+</html>

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.html
------------------------------------------------------------------------------
    svn:eol-style = native

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.pdf
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.pdf?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN.pdf
------------------------------------------------------------------------------
    svn:mime-type = application/pdf

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_HTML.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_HTML.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_HTML.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_PDF.ZIP
URL: http://svn.apache.org/viewvc/incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_PDF.ZIP?rev=1204763&view=auto
==============================================================================
Binary file - no diff available.

Propchange: incubator/ooo/ooo-site/trunk/content/documentation/HOW_TO/spreadsheet/calc5_EN_PDF.ZIP
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message