Apache OpenOffice Wiki - User contributions [en]

Help Standardisation issues

2011-03-17T10:15:48Z

Alicethomas:

The conversion of the entire help system to the new xml specification was a huge and doubtless heroic task. In the process a number of convenience measures had to be taken, with the result that in some cases the new specification is not fully obeyed.

This is a page to record variations and discuss solutions.

==Simplified background notes==

Help sources are written in xhp, which is an xml format specifically for OOo Help. The xhp files are processed by main_transform.xsl to produce html, which is in essence displayed by the OOo Help Viewer (although in practice it is more complicated than this). The Help system is very well defined in OOo2HelpAuthoring.pdf "Understanding, authoring and editing OpenOffice.org Help".

The variation of help sources from specification becomes more important as help authoring is opened up for user contributions - it is another 'entry barrier'.

A major consideration in changing help sources to bring them into specification is that any change may trigger a request for translation into other languages - which might cause much unnecessary work.

==Issues==

*Paragraphs within tables
**Currently main_transform.xsl changes any paragraph role inside a table by adding "intable" to it. The original reason was probably to do with layout. Thus the system does not deliver the paragraph role specified by the help author.
**Solution: the only styles ending in 'intable' that are defined in default.css - namely .listitemintable, .tablecontentintable, .codeintable, .exampleintable, .literalintable, .pathintable, .tableheadintable - are the same as those styles defined without 'intable'. It should therefore be safe to edit main_transform.xsl so that it leaves paragraph roles unchanged. Translation requests should not be triggered by this.
**It appears from running a Perl script that no paragraph directly specifies a role ending in 'intable' - thus once main_transform.xsl has been edited, styles .listitemintable, .tablecontentintable, .codeintable, .exampleintable, .literalintable, .pathintable, .tableheadintable can be removed from the .css files. Oh joy oh rapture.

*Embedded variables
**The <embed> element should embed only sections and paragraphs according to the specification. However main_transform.xsl also allows it to embed variables, enclosed in <p class="embedded"> </p> tags.
**A script reveals: there are 2618 embed elements which falsely call a variable. Of those only 9 call a variable which does not have a paragraph as direct parent. Of the 2609 which call a variable whose direct parent is a paragraph, 2492 call a variable which is the sole element inside a paragraph, and 117 call a variable which is not alone inside a paragraph. There are 53 files containing the variables which are called by these 117.
**Possible solution: The 9, 53 and 117 may need individual editing. The 2492 could be corrected by script, firstly to change the embed to call the paragraph not the variable, then to check that no embedvar element calls the variable, then to remove the variable. Embedding a paragraph rather than a variable may mean that the style changes, so this needs checking as well; most likely the paragraph will be in the default style which is how variables appear currently. If the script that triggers re-translation is set to look at textual changes to a paragraph (not just subnode changes) then no retranslation should be triggered. With this number of corrections to be made, it might be safest to start with just some of the files.
**An alternative solution is to replace any embed element which calls a variable with embedvar encased in a paragraph with role="embedded". That's simple, but leaves a lot of redundant elements. Possibly this could be used on those embeds that can't be corrected by script as above.

*How-to-get
**Help sources that refer to '/00/00000004.xhp#wie' are intercepted by main_transform.xsl, to provide a specially formatted section which starts (in English) "To access this command..."
**solution: main_transform.xsl appears to implement an alternative method using sections, although it looks unused at present. There are 462 instances of the old unconforming references, so a script might be the only practical way to solve this.

*Demoted embedded headings
**Any level 1 heading is demoted to level 2 on embed, which is contrary to the xhp spec.
**Solution: There are 3 embed elements that call a level 1 heading directly - these could be hand edited. There are no embed elements that call a variable that contains a level 1 heading. There are 1809 embed elements that call a section that contains a level 1 heading - typically embedding 2 paragraphs. This is the difficult case - the 'correct' solution is probably to embed the section elements separately. With great care this would be possible with a script, but it is not straightforward.
**Would solving this one issue allow main_transform.xsl to be (considerably) simplified with the removal of 'mode="embedded"'? That would be a prize worth having.

*Heading linked to itself
**Heading which are linked to themselves are intercepted by main_transform.xsl to remove the link. This doesn't conform to the xhp spec - and is confusing to read in the help sources.
**It appears (from running a script) that there are 1920 link elements in the help texts that refer to their own file. All of these are removed by main_transform.xsl. However in quite a few cases the help author seemingly intended the link as written.
**This is tied in with the 'demoted headings' issue, and could probably be solved at the same time, by script. This is not straightforward.
**All self references are removed at present, even if not in the heading. A decision is needed whether to keep this behaviour or not. If keeping it, then another script would be need to remove those links. If allowing those links, then a review of their (individual) usefulness would be good, because at least some of them point to the wrong place.

*Table classes
**main_transform.xsl intercepts single cell tables and forces them to be class="onecell"; it also intercepts tables where the first cell is an image and forces them to be class="icontable". Thus the author has lost control (eg can't make an image table with a border).
**Possible solution: table class could be specified in xhp - eg <table class="onecell" .. >. As happens already with <table class="wide" .. >. This would hopefully not trigger re-translation.

*html tags
**main_transform.xsl outputs html tags containing attributes that might be better set in the stylesheet. eg the default table style <table border="1" class="border" cellpadding="0" cellspacing="0" >. This may well be because the Help Viewer does not fully implement stylesheets.
**Solution: await improved Help Viewer?

*Stylesheets
**default.css does not define some classes outputted by main_transform.xsl: .paragraph, .paragraphintable, .embedded, .border, .icontable, .onecell, .avis.
**Also <ol> and <ul> have no style attached. This works OK in the OOo HelpViewer, but when viewing the html with a browser the default style looks wrong.
**Solution: define as necessary. Not that important, and possibly the Help Viewer cannot handle some of these styles yet anyway. Some styles will become redundant when other issues have been fixed - and it might be better to wait until then.

*Redundant attributes
**The paragraph element has two attributes that were used in the changeover from the old Help system. Is there any reason they are still needed?

*'createlink' template in main_transform.xsl
**tests for # to identify an internal link, but an external link might be <nowiki>http://.......#anchor</nowiki> - is this a potential bug?
**possible solution: test for not starting with "http://" as well as "#"

*'insertembed' template in main_transform.xsl
**currently inserts <p class="embedded">..</p> around an embedded paragraph, which itself inserts <p...> </p> - so the <p>s are nested in html eg <p class="embedded"><p class="paragraph">some text</p></p>.
**there are only 5 instances where a paragraph is embedded. Two examples are in /text/shared/00/00000005.xhp.
**the Help Viewer seems to handle this OK, but different broswers might well see 2 attempts at a paragraph and perhaps double the line spacing.
**Solution: simply remove <p class="embedded">..</p> from 'insertembed' template

==Plan==

Bringing the help source files into line with the xhp definition is quite a task. It needs a plan of action.

Suggestion: tackle the easy things first -
'createlink' template /
'insertembed' template /
Paragraphs within tables /
Stylesheets

then check out what triggers re-translation and modify if necessary, then tackle the more difficult issues.
[[Category:Documentation/OnlineHelp]]

* [http://www.seoprofessionalsonline.com professional seo]
* [http://www.seoprofessionalsonline.com/website-optimizer.asp website optimizer]
* [http://www.realsofttech.com/ web design service]

NLPSolver

2011-03-17T10:15:27Z

Alicethomas:

== Introduction ==

=== Optimization ===

Many scientific and economic problems involve the task of finding a certain optimum to a set of formulas, be it the minimum or the maximum. Additionally there are often also constraints, further restricting the set of possible solutions.

An example would be, to minimize the costs of a company while still meeting the demand of its customers. Such a formula could look like:
<math>c = p_1 \cdot x_1 + p_2 \cdot x_2</math>

where <math>p_1</math> and <math>p_2</math> are the prices of the two products and <math>x_1</math> and <math>x_2</math> are their amounts to be produced.
This would be a typical ''linear'' optimization problem, since the target variables (<math>x_1</math> and <math>x_2</math>) are linear. A ''nonlinear'' problem on the other hand could involve much more complicated relations between the variables. An example for this is the [http://en.wikipedia.org/wiki/Rosenbrock_function Rosenbrock Function]:
<math>f(x,y) = (1-x)^2 + 100 \cdot (y - x^2)</math>

In practice nonlinear optimization is used for curve fitting (by minimizing an error function) or for more complicated economical relations.

=== Spreadsheets - Calc ===

Since optimization problems consist of several variables and many different relations between them, they can be modeled inside a spreadsheet and therefore allow for easy user interaction. It is therefore useful, to have an embedded tool to solve such a model.

In ''Calc'', there is by default a solver for linear problems. To lift this limit, the extension '''[http://extensions.services.openoffice.org/project/NLPSolver Solver for Nonlinear Programming]''' can be used to add more solvers which are also capable of handling nonlinear problems (as well as linear ones).

=== When to use? ===

Since the '''[http://extensions.services.openoffice.org/project/NLPSolver Solver for Nonlinear Programming]''' can handle both - linear and nonlinear problems - you may ask yourself, why it is still necessary to have the '''OpenOffice.org Linear Solver''' then. The answer is easy: performance.

Solving nonlinear problems is a large burden and is still an active field of research in mathematics. There are not many all-round solutions. Often it is necessary to precisely know the problem to be solved and choose the appropriate method as well as their parameters according to that knowledge.

Since the representation of optimization models in a spreadsheet cannot be analyzed that deeply, the solver has to be able to handle a broad spectrum of optimization problems.

Another problem is, that many algorithms tend to get trapped in ''local extrema''. That means that the solution they find, may not be the best ''overall'' (global) solution.

One category of algorithms which overcome both problems are Evolutionary Strategies which are slow, in comparison to the deterministic approach by the OpenOffice.org Linear Solver.

=== Evolutionary Strategies ===

In nature there is not much analysis but things "just work" through a complex system of behaviors and events. Ant colonies build very short routes over time to transport food into their anthill - just by instinct. Bird swarms stay together and follow a leader in a certain formation. The simple change of the leaders mind, influences the behavior of all the other birds in the swarm. Similarly, a human population is influenced by each others knowledge. People talk, share information and make up their own mind based on what they learned, read and heard so far.

Several people had the idea, to use these principles to solve numerical and combinatorial problems. This is also the approach our '''[http://extensions.services.openoffice.org/project/NLPSolver Solver for Nonlinear Programming]''' chooses to solve nonlinear optimization problems. The solution is found by annealing the solution towards the (global) optimum, which is achieved by "structured trial and error". Due to the randomization it becomes very likely to find the '''global optimum''' instead of getting stuck in a local optimum. Also it doesn't matter (much) how the problem is structured, since the solver will adjust itself automatically by learning.

The biggest downside of this approach is, that it has to evaluate the whole optimization model many times to find the solution, which costs a lot of time and is therefore rather slow.

== Solvers ==

=== DEPS - Differential Evolution & Particle Swarm Optimization ===

DEPS consists of two independent algorithms: ''Differential Evolution'' and ''Particle Swarm Optimization''. Both are especially suited for numerical problems, such as nonlinear optimization, and are complementary to each other in that they even out their others shortcomings.

The idea behind ''Particle Swarm Optimization'' is to represent every solution vector as coordinates in an n-dimensional room. Each individual (particle) traverses through that space and keeps track of its own best point so far. This information as well as the knowledge about the particle with the best current solution influence how it will move in each iteration. Due to that, the particles will always try to build a swarm and float around the best solutions, traversing possible even better solutions on its way.

''Differential Evolution'' on the other hand is a strategy to "recombine" two individuals similar to Genetic Algorithms. Instead of crossing over chromosomes (i.e. mixing up their variables), the knowledge about the target function is used to anneal both points.

In each iteration of the algorithm, each individual chooses one of both strategies and applies them to its current solution vector. The probability, which strategy is chosen, can be modified with the option Agent Switch Rate.

=== SCO - Social Cognitive Optimization ===

SCO takes into account the human behavior of learning and sharing informations. Each individual has access to a common library with knowledge shared between all individuals.

In each step, an individual looks up the (presumably) best information available in the library and builds a decision based on it together with its own current knowledge about the problem. Afterwards it replaces one of the worse informations from the library with its newly learned solution.

That way all individuals work together (''the social aspect'') and make up their own mind (''the cognitive aspect''). Therefore it's called '''Social Cognitive Optimization'''.

== Usage ==

Regardless whether you use DEPS or SCO, you start by going to Tools -> Solver and set the Cell to be optimized, the direction to go (minimization, maximization) and the cells to be modified to reach the goal. Then you go to the Options and specify the solver to be used and if necessary adjust the according parameters.

There is also a list of constraints you can use to restrict the possible range of solutions or to penalize certain conditions. However, in case of the evolutionary solvers DEPS and SCO, these constraints are also used to specify bounds on the variables of the problem. Due to the random nature of the algorithms, it is '''highly recommended''' to do so and give upper (and in case "Assume Non-Negative Variables" is turned off also lower) bounds for all variables. They don't have to be near the actual solution (which is probably unknown) but should give a rough indication of the expected size (<math>0 \leq \text{var} \leq 1</math> or maybe <math>-1000000 \leq \text{var} \leq 1000000</math>).

Bounds are specified by selecting one or more variables (as range) on the left side and entering a numerical value ('''not''' a cell or a formula) on the right side. That way you can also choose one or more variables to be ''Integer'' or ''Binary'' only.

== Options and Parameters ==

=== General Options ===

{|width=100% class="wikitable"
|- valign="top"
|width=20% | '''Size of Swarm''' || ... defines the number of individuals to participate in the learning process. Each individual finds its own solutions and contributes to the overall knowledge.
|- valign="top"
| '''Learning Cycles''' || ... defines the number of iterations, the algorithm should take. In each iteration, all individuals make a guess on the best solution and share their knowledge.
|- valign="top"
| '''Variable Bounds Guessing''' || ... If enabled (default), the algorithm tries to find variable bounds by looking at the starting values.
|- valign="top"
| '''Variable Bounds Threshold''' || When guessing variable bounds, this threshold specifies, how the initial values are shifted to build the bounds. The calculation is as follows: <math>\text{Bound} = \text{InitialValue} \pm(\text{Threshold} \cdot \text{InitialValue})</math>.

'''Example''':

The <math>\text{InitialValue}</math> is <math>100</math> and the <math>\text{Threshold}</math> is <math>3</math> (default). In this case, the lower bound would be <math>100 - 3 \cdot 100 = -200</math> and the upper bound <math>100 + 3 \cdot 100 = 400</math>.
|- valign="top"
| '''Use ACR Comparator''' || If ''disabled'' (default), the BCH Comparator is used. It compares two individuals by first looking at their constraint violations and only if those are equal, it measures their current solution.

If ''enabled'', the ACR Comparator is used. It compares two individuals dependent on the current iteration and measures their goodness with knowledge about the libraries worst known solutions (in regard to their constraint violations).
|- valign="top"
| '''Use Random Starting Point''' || If ''enabled'', the library is simply filled up with randomly chosen points.

If ''disabled'', the currently present values (as given by the user) are inserted in the library as reference point.
|- valign="top"
| '''Stagnation Limit''' || If this number of individuals found solutions within a close range, the iteration is stopped and the best of these values is chosen as optimal.
|- valign="top"
| '''Stagnation Tolerance''' || Defines in what range solutions are considered "similar".
|- valign="top"
| '''Show Enhanced Solver Status''' || If ''enabled'', an additional dialog is shown during the solving process which gives information about the current progress, the level of stagnation, the currently best known solution as well as the possibility, to stop or resume the solver.
|}

=== DEPS-specific Options ===

{| width=100% class=wikitable
|- valign=top
|width=20% | '''Agent Switch Rate''' || Specifies the probability for an individual to choose the Differential Evolution strategy.
|- valign=top
| '''DE: Crossover Probability''' || ... defines the probability of the individual being combined with the globally best point. If crossover is not used, the point is assembled from the own memory of the individual.
|- valign=top
| '''DE: Scaling Factor''' || During crossover, the scaling factor decides about the "speed" of movement.
|- valign=top
| '''PS: Constriction Coefficient''' || ... defines the speed at which the particles/individuals move towards each other.
|- valign=top
| '''PS: Cognitive Constant''' || ... sets the importance of the own memory (in particular the best reached point so far).
|- valign=top
| '''PS: Social Constant''' || ... sets the importance of the global best point between all particles/individuals.
|- valign=top
| '''PS: Mutation Probability''' || ... defines the probability, that instead of moving a component of the particle towards the best point, it randomly chooses a new value from the valid range for that variable.
|}

=== SCO-specific Options ===

{| width=100% class=wikitable
|- valign=top
|width=20% | '''Size of Library''' || ... defines the amount of information to store in the public library. Each individual stores knowledge there and asks for information.
|}

== Scripting ==

There are a number of reasons why it may be useful to access the solver from within a scripting language (like '''OpenOffice.org Basic'''). One of them could be, that you don't want to specify all of the constraints whenever you want to run the solver on a specific problem. In that case you could handle the solver setup from Basic.

=== Properties and Methods ===

Apart from the default properties and methods defined by the [http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/XSolver.html XSolver] interface, DEPS and SCO publish the following properties:

{|width=100% class=wikitable
!style="text-align: left" | Property !!style="text-align: left" | Type !!style="text-align: left" | Meaning
|-
| <tt>SwarmSize</tt> || <tt>Integer</tt> || Size of Swarm
|-
| <tt>LearningCycles</tt> || <tt>Integer</tt> ||Learning Cycles
|-
| <tt>GuessVariableRange</tt> || <tt>Boolean</tt> || Variable Range Guessing
|-
| <tt>VariableRangeThreshold</tt> || <tt>Double</tt> || Variable Range Threshold
|-
| <tt>UseACRComparator</tt> || <tt>Boolean</tt> || Use ACR Comparator
|-
| <tt>UseRandomStartingPoint</tt> || <tt>Boolean</tt> || Use Random Starting Point
|-
| <tt>StagnationLimit</tt> || <tt>Integer</tt> || Stagnation Limit
|-
| <tt>Tolerance</tt> || <tt>Double</tt> || Stagnation Tolerance
|-
| <tt>EnhancedSolverStatus</tt> || <tt>Boolean</tt> || Show Enhanced Solver Status
|-
!colspan=3 style="text-align: left" | <tt>com.sun.star.comp.Calc.NLPSolver.DEPSSolverImpl</tt>
|-
| <tt>AgentSwitchRate</tt> || <tt>Double</tt> || Agent Switch Rate
|-
| <tt>DEFactor</tt> || <tt>Double</tt> || Scaling Factor
|-
| <tt>DECR</tt> || <tt>Double</tt> || Crossover Probability
|-
| <tt>PSC1</tt> || <tt>Double</tt> || Cognitive Constant
|-
| <tt>PSC2</tt> || <tt>Double</tt> || Social Constant
|-
| <tt>PSWeight</tt> || <tt>Double</tt> || Constriction Coefficient
|-
| <tt>PSCL</tt> || <tt>Double</tt> || Mutation Probability
|-
!colspan=3 style="text-align: left" | <tt>com.sun.star.comp.Calc.NLPSolver.SCOSolverImpl</tt>
|-
| <tt>LibrarySize</tt> || <tt>Integer</tt> || Size of Library
|}

=== Example ===

The following example will iterate over the row 5 to 300 (the internal numbering starts at 0!) from sheet 1 and solve each of them separately by minimizing the objective in the same row.

<source lang="oobas">
Sub OptimizeDEPS
Dim Solver as Object
Set Solver = CreateUnoService("com.sun.star.comp.Calc.NLPSolver.DEPSSolverImpl")
Solver.Document = ThisComponent
Solver.Maximize = false

Dim ObjectiveCell as new com.sun.star.table.CellAddress
ObjectiveCell.Sheet = 0
ObjectiveCell.Column = 10

Dim VariableCells(0) as new com.sun.star.table.CellAddress
VariableCells(0).Sheet = 0
VariableCells(0).Column = 2

For TargetRow = 4 To 299
ObjectiveCell.Row = TargetRow
VariableCells(0).Row = TargetRow
Solver.Objective = ObjectiveCell
Solver.Variables = VariableCells
Solver.solve
Next

MsgBox "Done."
End Sub
</source>

== License and Disclaimer ==

This extension has been developed at '''Sun Microsystems Inc.''' and is licensed under the terms of the [http://www.openoffice.org/license.html GNU Lesser General Public License version 3].

Research and implementation of DEPS and SCO have been done by '''Xiao-Feng Xie''' of [http://www.adaptivebox.net/research/ adaptivebox.net]. Both were modified and applied to the needs of the OpenOffice.org Solver by Andreas Schneider for Sun Microsystems, Inc.
[[Category:Extensions]]

* [http://www.designerevaluation.com/logo-design/ logo design]
* [http://www.designerevaluation.com/ website design]

Documentation

2011-03-17T10:11:29Z

Alicethomas:

{{DISPLAYTITLE:The OpenOffice.org Documentation Project}} __NOTOC__

{|
|-
| This project creates and maintains documentation in English for OpenOffice.org. Documentation can include user guides, [[Documentation/FAQ|FAQs]], [[Documentation/How Tos|How Tos]], samples, User Templates, the application help and training materials. The project [http://documentation.openoffice.org has a home page on the web as well].
This is a wiki, so feel free to contribute to {{OOo}} documentation.

Look [[:Category:Documentation/NeedsRework|here to see a list of wiki pages that need your help]].

Here is a [[Documentation/Dashboard/User_Guides|task list for the user guides]].

If you cannot find what you're looking for, check out the [http://user.services.openoffice.org/en/forum the OpenOffice.org User Forum].

| <div style="border: 1px solid rgb(140, 45, 6); margin: 0px 5px 5px; padding: 1px; float: right; width: 300px; background-color: rgb(255, 255, 255);" id="contrib"><div style="padding: 2px; background-color: rgb(140, 45, 6); color: rgb(255, 255, 255); font-weight: bold; text-align: center;">WANT TO HELP?</div>
{|
|-
|
*[[Documentation/Contribute|How to contribute]]
*[[Documentation/OpenOffice.org needs YOU|OOo needs YOU!]]
*[[Documentation/Dashboard/Wiki Editing Policy|Wiki Editing Policy]]
*[[Documentation/Dashboard|Project Dashboard]]

|
*[[Documentation/Wishlist|Doc Wishlist]]
*[[:Category:Documentation/NeedsRework|Pages that Need Help!]]
*[[:Category:Documentation/BeingEdited|Pages in the Works]]
*[[:Category:Documentation/Candidate|Candidate Pages]]

|}
</div>
|}

{| align="center" cellspacing="8" cellpadding="3" style="border: 0px solid rgb(102, 102, 102);"
|- valign="top"
| width="45%" colspan="2" | <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">What's New</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
* March 2011 - Attended CeBIT in Hanover. Answered lots of Documentation related questions from home and business users.
* November 2010 - Getting Started guide (updated for OOo 3.3) published in [[/OOo3_User_Guides/Chapters|individual chapters - PDF]].
* November 2010 - Impress Guide 2nd edition (updated for OOo 3.2) published in [[/OOo3_User_Guides/Chapters|individual chapters - PDF]]. Full book coming soon. Update of wiki version is in progress.
* September 2010 - OOoCon 2010 Doc Project presentation is available via the [http://www.ooocon.org/index.php/ooocon/2010/schedConf/presentations OOo Con 2010 website].
* July 2010 - Draw Guide published in [[Media:0400DG3-DrawGuide.pdf|PDF - full book]] and [[Documentation/OOo3_User_Guides/Chapters|individual chapters - PDF]]. Update of wiki version is in progress.
* June 2010 - Calc Guide published in [[Media:0300CS3-CalcGuide.pdf|PDF - full book]] and [[Documentation/OOo3_User_Guides/Chapters|individual chapters - PDF]]. Update of wiki version is in progress.
</div>
|- valign="top"
| width="45%" colspan="2" | <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">Searching/Downloading</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*Search and download documents through the [http://documentation.openoffice.org Documentation Website]
*or, type here to search this Documentation Wiki: <google />
</div>
|- valign="top"
| width="45%" | <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">Installation Guide for OpenOffice.org 3.x</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*{{Documentation/PDF}}[[Media:Installation_Guide_OOo3.pdf|PDF]] - 2010-06-06 (June 6) - 470 kb
*{{Documentation/OOo}}[[Media:Installation_Guide_OOo3.odt|ODT]] - 2010-06-06 (June 6) - 300 kb
</div><div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/OOo3 User Guides/OOo3.3 User Guide Chapters|User Guides for OpenOffice.org 3.3]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
<b>PDFs by chapter</b>
</div><div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/OOo3 User Guides|User Guides for OpenOffice.org 3.2]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
<b>Wiki format</b>
*[[Documentation/OOo3 User Guides/Getting Started|Getting Started with OpenOffice.org 3.x]] - Published
*[[Documentation/OOo3 User Guides/Writer Guide|Text Documents with Writer 3.x]] - Published
*[[Documentation/OOo3 User Guides/Impress Guide|Presentations with Impress 3.x]] - Published
*[[Documentation/OOo3 User Guides/Calc Guide|Spreadsheets with Calc 3.x]] - Being updated to published
*[[Documentation/OOo3 User Guides/Math Guide|Equation Editing with Math 3.x]] - Published
*[[Documentation/OOo3 User Guides/Draw Guide|Drawings with Draw 3.x]] - Being updated to published

{{SeeAlso}}

*[[Documentation/OOo3 User Guides/Chapters|PDFs of OpenOffice.org 3.2 User Guides by Chapter]]
*[[Documentation/OOo3 User Guides/Chapters_ODT|ODTs of OpenOffice.org 3.2 User Guides by Chapter]]
*{{Documentation/OOo}}[http://documentation.openoffice.org/whitepapers/Creating_large_documents_with_OOo.odt Creating Large Documents with OpenOffice.org Writer] - 2010-02-11 (February 11) - 832 kb
</div> <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/OOoAuthors User Manual|User Guides for OpenOffice.org 2.x]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
</div> <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/FAQ|Frequently Asked Questions]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/FAQ/General|General Questions]]
*[[Documentation/FAQ/Installation|Installing OpenOffice.org]]
*[[Documentation/FAQ/Writer|Working with Text Documents (Writer)]]
*[[Documentation/FAQ/Calc|Working with Spreadsheets (Calc)]]
*[[Documentation/FAQ/Draw|Working with Drawings (Draw)]]
*[[Documentation/FAQ/Impress|Working with Presentations (Impress)]]
*[[Documentation/FAQ/Formula|Working with Formulae (Math)]]
*[[Documentation/FAQ/Databases|Working with Databases (Base)]]
</div>
| width="45%" style="border-left: 1px dotted rgb(153, 153, 153); border-right: 1px dotted rgb(153, 153, 153);" | <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">Developers/SysAdmin Guides</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/Administration Guide|Administration Guide]]
*[[Documentation/BASIC Guide|BASIC Programmers Guide]]
*[[Documentation/Building Guide|Building Guide]]
*[[Documentation/DevGuide/OpenOffice.org Developers Guide|Developer's Guide]]
{{SeeAlso}}
*[[Using_Cpp_with_the_OOo_SDK|Using C++ with the OOo SDK]]
</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/Wiki Books|Download these guides as PDF / ODT]]
</div>
<div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/Reference|Reference Lists]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/Reference/Math commands|Syntax for Math Formulae]]
*[[Documentation/How Tos/Calc: Functions listed by category|Calc Spreadsheet Functions]]
*[[Documentation/How Tos/Regular Expressions in Writer|Syntax for Regular Expressions in Writer]]
*[[Documentation/Reference/Bibtex-Bibliography Mappings|Bibtex-Bibliography_Mappings]]
</div> <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/How Tos|HOWTOs]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/How Tos|Installation and Setup]]
*[[Documentation/How Tos|Text Documents]]
*[[Documentation/How Tos|Databases]]
*[[Documentation/How Tos|Presentations]]
*[[Documentation/How Tos|Spreadsheets]]
</div> <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">[[Documentation/Tutorials|Tutorials/Screencasts]]</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/Tutorials|Dennis Daniels' Tutorials]]
*[[Documentation/Tutorials|Carlo Daffara's Tutorials]]
*[[Documentation/Tutorials|Dai's Tutorials]]
*[[Documentation/Tutorials|Horst Jens' Tutorials]]
*[[Documentation/OpenOffice.org Conceptual Guides|OpenOffice.org Conceptual Guides]]
*[http://plan-b-for-openoffice.org Plan-B For OpenOffice.org Tutorials]
*[http://easy10seconds.com/How-To-Video/OpenOffice.org Easy10Seconds Tutorials]
</div> <div style="padding: 5px; font-size: 120%; font-weight: bold; background-color: rgb(205, 219, 246);">Documentation Bounties</div> <div style="border: 1px solid rgb(205, 219, 246); margin-bottom: 15px;">
*[[Documentation/Bounties|Documentation Bounties for Developer documentation]]
* [[http://www.customwritinghelp.co.uk/assignment.php assignment writing]]
* [[http://www.perfectwriting.co.uk/assignment/assignment-help.php assignment help]]
* [[http://www.perfectwriting.co.uk/assignment/assignment-writing.php assignment writing]]
</div>
|}

{{Documentation/Hook}} {{PDL1}}

[[Category:Documentation]] [[Category:Project]]

{{Documentation/Languages}}