Apache OpenOffice Wiki - User contributions [en]

FAQ

2009-03-03T06:13:38Z

Ashawley: /* What does OpenOffice really look like ? */ fix layers.png

{{DISPLAYTITLE:Development FAQ}}

[[Documentation/FAQ|There are also user FAQs!]]

<p>
So no-one ever asked me these, I just made them up to astro-turf
a bit (safer, wipe-clean, more durable questions).
</p>

== Why do branches like 'mws_srx645' have odd numbers in them ? ==

<p>
By consulting various oracles, entrails etc. it transpires that
in theory this number once incremented weekly, there being weekly
freezes and hence solvers, development environments.
The 'mws' stands for 'Master Workspace'. Master Workspaces for releases
are on CVS branches. Those branches are named with Master Workspace
name, f.e. 'mws_ooh680' is the name of the branch of workspace OOH680,
used for OpenOffice.org 2.4.
The latest 3.0 development is done with the DEV300 stem ob CVS HEAD;
with auto-incrementing milestones; hence milestone tags like
<code>DEV300_m5</code> would be common.
</p>

== Why does XYZ require Java ? up-stream/Sun are so evil !? ==

Nah up-stream just use the best tool to hand, and have a different set world-view to you, where Java is an engineering solution to their cross platform problems. By using Java StarDivision can avoid having to re-invent and then maintain an essentially competing cross-platform layer. There is no malice here whatsoever; just pragmatic engineering from a different perspective.

See [[Java and OpenOffice.org]]

== Why is [t]csh so broken ? ==

<p>
This is rather inscrutable; some particularly curious brokenness
would be the way piping commands on stdin is crucially different
to inputting them from the tty thus:
<code>echo 'echo #define DLL_NAME "libsch641li.so" >./foo.hxx' | /bin/tcsh -s</code>
fails to do anything whereas typing the same thing into the shell
works just fine. Even more oddly:
<code>tcsh -fc 'echo #define DLL_NAME "libsch641li.so" >./foo.hxx'</code>
does do the right thing. See also [http://www.faqs.org/faqs/unix-faq/shell/csh-whynot/ csh].
</p>

== I just tried to re-locate the build, why doesn't it work ? ==

<p>
The simple answer is: you need to run <code>relocate /path/to/new/build</code>;
another more complex answer is:
</p>
<p>
Well, <b>assuming</b> you have re-configured things (LinuxIntelEnv.Set will
need paths tweaking too — and re-importing to your shell) — then it's most
likely down to the ubiquitous non-relative paths, coded in lots
of generated / built files, particularly '.dpc*' (dependency)
files. Try:
<code>find -name '*.dpc*' -exec rm {} \;</code>
</p>
<p>
The stlport does some really broken things, so
you will also need to edit the 'stl_gcc.h' inside the solver/, and replace the
two path instances there (see inc/stl/config/stl_gcc.h. )</p>

== CVS says 'Fatal Error aborting. [acc] no such user', why ? ==

<p>
While of course it's possible that your user name is not registered; often
this just means your ~/.cvspass got lost and/or that you haven't logged in.
cvs login, and repeat the command.
</p>

== What does '.pro' in 'unxlngi4.pro' mean ? ==

<p>
<i>Pro</i>duct — isn't it obvious ?
</p>

== What does OpenOffice really look like ? ==

Today I found a photograph of it on my system, so I stuck it in here:

[[Image:layers.png]]

Abstraction Layers

SW: Star Writer<br/>
SD: Star Draw<br/>
SC: Star Calc<br/>
SCH: Star Chart<br/>
SFX: Star Framework ???<br/>
SVX: Star View X for miscellany ?, it's a bit of a dumping ground for dialogs and shared between apps code<br/>
UNO: Universal Network Objects<br/>
UCB: Universal Content Broker<br/>
SBL: Scripting And Basic Library<br/>
SO: ???<br/>
VOS: Virtual Operating System<br/>
VCL: Visual Class Library<br/>
STL: Standard Template Library<br/>
RTL: Run Time Library<br/>
OSL: Operating System Library<br/>

== How do I take a screenshot of OO.o ? ==

OOo does some very odd things with X resources, thus some conventional
screenshot apps fail to take accurate shots. ImageMagick's 'import'
however does a good job; use:

import foo.png

from the console, or

sleep 2; import -window root foo.png

instead.

NB. unless you want your world to look tiny, you need to turn large toolbar icons first.

You can also use [http://www.gimp.org The GIMP] to Acquire Screenshots of OpenOffice.org.
From the Gimp:
* Click '''File'''
* Click '''Aquire'''
* Click '''Screen Shot'''

== Why does the code look so ugly? ==
<p>
The authors must be using a really strange editor.
It <em>thinks</em> tab stops are on every fourth column.
Of course, the files come out ugly in Unix editors which <em>know</em>
that tabs are eight characters wide.
</p>
<p>
If you happen to use
[http://www.gnu.org/software/emacs/ a Real Editor],
we have some pink glasses to sell to you. Paste the contents of
[http://go-ooo.org/emacs.el] into your <tt>.emacs</tt>,
or load it with a line like this: <tt>(load "/path/to/that/file.el")</tt>.
Don't forget to adapt <tt>my-openoffice-path-regexp</tt> to your needs.
</p>
<p>
Henceforth emacs will use 4-column tabs for your OOo source files.
(And use <em>C++-Mode</em> for <tt>sdi</tt>-, <tt>hrc</tt>-,
and <tt>src</tt>-files.) Alternatively if you are sufficiently set in
your ways that you can't cope with investing these few seconds do:
<code>M-x set-variable\ntab-width 4</code> & learn to love change.
</p>
<p>
Apparently if you use vi you can do: <code>:set ts=4 sw=4</code>, and
good luck to you. For a better vim, use <code>:set ts=4 sw=4 et</code> to also expand tabs to spaces, as this is what new code should use.
</p>

== Where can I suggest ideas for what OpenOffice.org should do and what I don't/do like about it? ==
''Awaiting an answer from a kind contributor.''

== How can OOo be used to author wiki pages at a MediaWiki site?==
''Awaiting an answer from a kind contributor.''

== Can the content of a MediaWiki hosted wiki be exported into OOo? ==
''Awaiting an answer from a kind contributor.''

The dream idea is to take a complete wiki and flow it into a filter so that it can be exported into a series of OOo documents, or one larger OOo document. This would allow writters to start a wiki and then finish with a book.

I'm not sure if they can be exported from MediaWiki to OOo, but the reverse is possible. If you follow :- [[http://wiki.services.openoffice.org/wiki/Odt2Wiki Odt2 To Wiki]]

== How can OOo be used to author blog pages at a Blogspot.com hosted site? ==
A filter exists for MS Word users to write blog articles -- and then upload the content to the blog easily. A similiar add-on is [http://people.redhat.com/caolanm/oooblogger/ oooblogger] which is an experimental blogger plugin for OOo which is not complete, but is a suitable starting position for a developer (python) who wants to tackle this area

== See also ==

* [[CvsFAQ]] - for CVS problems
* [[OOo_Ergonomics]] - why is it so painful to use ?
* [[Bibliographic/FAQ]] - for bibliographic problems
* [[CWS|How to use Childworkspaces]]

[[Category:Development]]
[[Category:Build_System]]

File:Layers.png

2009-03-03T06:13:14Z

Ashawley: pulled from http://web.archive.org/

pulled from http://web.archive.org/

Main Page

2009-03-03T04:58:22Z

Ashawley: /* Hot Topics */ online conference isn't new. fix Extensions feature ideas link

<div style="float:right; padding-left:5px;">
{| style="text-align:left; border:1px solid #aaaaaa; background-color:#f9f9f9;font-family: Verdana, sans-serif;"
|- padding:5px;padding-top:0.5em;font-size: 95%;
|
<div style="border:1px solid #ccc; background: #fff; border-right:3px solid #ccc; border-bottom:3px solid #ccc; text-align: center; padding:3px; float:right; font-size: smaller; line-height: 1.3; margin-right: 4px;">
<div style="width:100%">{{CURRENTDAYNAME}}</div>
<div style="width: 100%;">{{CURRENTYEAR}}</div>
<div style="width: 100%;"> {{CURRENTMONTH}}</div>
<div style="font-size: x-large; width: 100%;">{{CURRENTDAY}}</div>
<div style="background: #aaa; color: #000;">'''{{CURRENTTIME}}''' [[wikipedia:UTC|UTC]]</div>
</div>
|}
</div>


== Welcome to the OpenOffice.org wiki ==
__NOTOC__
This wiki is for all projects associated with OpenOffice.org (OOo). It has a good focus on resources for developers. Also other projects work more and more on the wiki. (Most...) are listed here. Click a link to go directly to the page you want.
* [[Certification]]
* [[Community_Council|Community Council]]
* [[#Getting started with OOo development|Development]] (see below)
* [[Documentation]]
* [[Education Project]]
* [[Localization]]
* [[Marketing]]
** [[Art]]
* [[NLC]] ''Native-Language Confederation''
* [[Product_Release|Product Releases]]
* [[OOPM|Project Management Tool (OOPM)]]
* [[Regional Groups]]
* [[Quality Assurance]]
* [[Security]]
* [[User_Experience|User Experience (UX)]]
* User Interface ([[Accessibility]], [[Visual Design]])
* [[#Finding general OpenOffice.org user help|User Resources]]
* [[Website]]
* [[List of wishes]]
Join in contributing to the OpenOffice.org Wiki. Please use your OOo login name for the wiki account. Some functionality is available only if you are logged in to avoid [[MediaWiki_Configuration#AntiSPAM_Measures43q5|SPAM]]. Additionally your email address has to be validated. We might be able to avoid the separate user administration later and log you in with the OpenOffice.org site credentials.

To get started editing the wiki see [[Help:Editing]].

== Getting started with OOo development ==
<div style="float:right; background-color:lightyellow; border: 1px solid black; margin:0 1em 0 0.5em; padding:0 0.5em 0 0.5em; ">
<b>Get Started from Scratch</b><br />
you most likely need to:
# [[Getting It|Get it]]
# [[Building|Build it]]
# [[Installing|Install it]]
# [[Running|Run it]]
Click for instructions on <br />
each step!
</div>

[[Building]] and [[hacking]] on [http://www.openoffice.org OpenOffice.org] (OOo) entails climbing a fairly lengthy and steep incline. Hopefully, this wiki will make the learning curve less steep and less abrupt, and will give you a walking stick to help you out.

Much of our documentation assumes that you'll be using a reasonably current Linux system, as this is the easiest environment to start. On Linux, all prerequisites are available as [http://www.gnu.org Free software]. There is also some information on developing on [[Windows]].

[[Education_Project |Education Project]] aims to welcome Students or Teachers who are interested to contribute for code, or whatever concerning Educational system ( see e.g. [[Education_Project/Effort |Education Project Effort]] )

For help setting up your editor or environment to search/edit/compile OOo easily, please refer to the [[:Category:Developer_Tools|developer tools]] area.

Note that you can build either the plain 'up-stream' OOo or use an [[ooo-build]] release which adds some patches & fixes. However, the ooo-build process is destined to being gradually phased out as the various up-stream issues it solves go away.

Remember that learning UNO components development is not an easy task. To help you there is an Eclipse plugin and tutorial. You can install the Eclipse plugin by using the following update site: http://cedric.bosdonnat.free.fr/ooeclipseintegration. The tutorial on how to create a UNO component in Java is available in the [http://api.openoffice.org/files/documents/22/3216/JavaComponentTuto.odt api project docs & files sections]. The document will even be wikified on this page: [[JavaEclipseTuto | Java Tutorial using Eclipse]]

There exists also an [[OpenOffice_NetBeans_Integration|OpenOffice.org API plugin for NetBeans]] that helps a lot to get started with the API and with developing with and for OpenOffice.org. The plugin provides several wizards that simplify the first steps and help to create full working code skeletons for extensions. Try it out and have fun when you want to develop a Java extension for OpenOffice.org. Feedback is always welcome, help us to improve the plugin and send us new ideas what we can do better!

== Going Further ==

* [[I want to be an OpenOffice.org developer]] - the basic what & where
* [[IRC Communication|Meet the team on IRC]]
* [[Tutorials]] - hacker tutorials to get the hang of the code
* [[Debugging]] - for when it all goes wrong
* [[Tinderbox]] - test new [[CWS|child workspaces]] and show your build logfile to others
* [[Environment Variables]] - a description of handy environment variables used at runtime
* [[Source code directories| A description of the source directories]]
* [[Contributing Patches]] - for when you have something to fold back
* [[Commit Rights]] - An overview of how to attain commit rights, and what to do with them once you get them
* [[Tips]] - misc. hints & tips.
* [[FAQ]] - some infrequently asked questions
* [[Using_Cpp_with_the_OOo_SDK|Using C++ with OOo SDK]]
* [[Extensions_development|Extensions development]] (Python, Basic, Java and C++)
* [[Extensions_development#Ideas|Extensions Ideas]] An ideas section for new extensions '''(NEW)'''
* [[:Category:Localization|Localization of OpenOffice.org]] - translate, review and test OpenOffice.org in your language
* [[OpenOffice_NetBeans_Integration|OpenOffice.org NetBeans Integration]] - program, extend, and customize OO.org in Java with a modern IDE
* [[OpenOffice_Eclipse_Integration|OpenOffice.org Eclipse Integration]] - program, extend, and customize OOo in Java with Eclipse
* [[Extra Software]] - other open source programs

== Hot Topics ==
* [[SVN]]: [[OOo_and_Subversion|OpenOffice.org migrates to Subversion]] '''(NEW)'''
* [[Marketing/OnlineConferenceSessions|Online Conference Sessions]]
* [[Extensions feature ideas]]
* [[To-Dos]]
* [[Performance]]
* [[User:Ericb|Native Mac OS X port]] or for everything related to OpenOffice.org and [[:Category:MacOSX|Mac OS X]]
* [[SVG_Import_Filter|SVG import]]
* [[Product Release|Product release data]]
* [[Java_and_OpenOffice.org|Java related functionality]]
* [[Cpp Coding Standards|C++ Coding Standards]], [[Writing_warning-free_code|Warning-free Code]] and [[Writing_correct_Cplusplus|Correct C++]]
* [[Syndication|Syndication]] Of OOoAnnouncements
* [[Mono Integration|details on how to get Mono working with OOo]]
* [[Porting_to_x86-64_%28AMD64%2C_EM64T%29|64bit porting]]
* [[VBA|MS Office VBA interoperability]]
* [[Digital Signatures]]
* [[Bibliographic| Bibliographic Project Developer and Documentation pages]]
* [[QA Metrics]]
* [[BuildSpeedup| Make the OO.o build process the coolest on the planet]]
* [[Chart2 | Chart2: The new chart implementation]]
* [[Firefox ODFReader extension]]
* [[Firefox OpenOffice.org extension]] Menu extension with useful OO.o links
* [[Compiler versions used by port maintainers and release engineers]]
* [[Effort/Revise OOo Multi-Threading|Revise OOo Multi-Threading]].
* [[Uno]] on the Wiki.
* [[Framework]] on the Wiki.
* [[Summer_of_Code_2007]] and [[OpenOffice.org_Developer_Article_Contest]]
* [[BetterDatabaseDrivers | Better and simpler infrastructure for database drivers]]
* [http://www.openoffice.org.br/?q=lancamento_do_cogroo Cogroo] grammatical checker in Portuguese
* [[Architecture]] - Description of OOos software architecture.
* [[Metalink]] - An XML format used by OOo for file distribution that stores mirror/P2P locations.
* [[Convert2MediaWiki]] - Informations to convert from OOo to media wiki
* [[Object Inspector]] - Description of an extension to inspect Uno-Objects
* [[OOoCon 2007]] - The OpenOffice Conference 2007

== Finding general OpenOffice.org user help ==

* [[OOoHelpOutline|OpenOffice.org Help Outline]]
* [[Documentation/Dashboard/Application_Online_Help|OOo Application Help]]
* [http://plan-b-for-openoffice.org/ Technical support] for non technical users
* Free and commercial [[OpenOffice.org_Solutions|Solutions]] to assist in the adoption of OpenOffice.org
* [[Press coverage on OpenOffice.org]] (please update the linked page)
* [[Wikipedia:List_of_applications_supporting_OpenDocument|List of applications supporting OpenDocument]] from Wikipedia
* [[OASIS]] and [[OpenDocument]]
* Developer portals for specific components: [[Writer]], [[Calc]], [[Impress]], [[Base]], [[Math]], [[Draw]], and [[Chart]].
* [[Documentation/OpenOffice.org_needs_YOU|OpenOffice.org Needs YOU!]]

[[:Category:MainIndex|Main Index of Articles]]

<center>
{|style="border: 1px solid #cfcfbf; padding: .0em .25em .0em; background-color: #f0f0ff; text-align: center;"
|
|-
|
<p style="margin: 0em 0 0 0%; line-height: 1.1">
</p>
| style="font-size: 95%;"|You loaded this Main Page on {{CURRENTDAYNAME}}, {{CURRENTYEAR}}-{{CURRENTMONTH}}-{{CURRENTDAY}} ''T'' {{CURRENTTIME}} '''[[wikipedia:UTC|UTC]]'''.
|-
|style="font-size: 95%;"|
|}
</center>
{{InterWiki Languages}}

Sorting and searching

2009-03-02T23:51:46Z

Ashawley: fix link

Neither OpenOffice.org Basic nor the API provide methods or functions for sorting arrays or searching within arrays.

It is quite common to sort almost sorted arrays, for example the list of style names belonging to a style family. Thus, I have found the shell sort to be the fastest for most uses in OpenOffice.org:

<source lang="oobas">
sub subShellSort(mArray)

dim n as integer, h as integer, i as integer, j as integer, t as string, Ub as integer, LB as integer
Lb = lBound(mArray)
Ub = uBound(mArray)

' compute largest increment
n = Ub - Lb + 1
h = 1
if n > 14 then
do while h < n
h = 3 * h + 1
loop
h = h \ 3
h = h \ 3
end if
do while h > 0
' sort by insertion in increments of h
for i = Lb + h to Ub
t = mArray(i)
for j = i - h to Lb step -h
if strComp(mArray(j), t, 0) < 1 then exit for
mArray(j + h) = mArray(j)
next j
mArray(j + h) = t
next i
h = h \ 3
loop
end sub
</source>
Based on a routine available from [http://www.oopweb.com/Algorithms/Documents/Sman/Volume/ShellSort.html a Visual Basic version here].

Searching in a sorted list is compartively efficient with a binary search:

<source lang="oobas">
function fnBinarySearch(a, v)
nLeft = 0
nRight = uBound(a)
nLen = len(v)
while nLeft <= nRight
nMid = int((nLeft + nRight)/2)
if left(a(nMid), nLen) = v then
fnBinarySearch = nMid
exit function
elseif v < a(nMid) then
nRight = nMid - 1
else
nLeft = nMid + 1
end if
wend
fnBinarySearch = -1
end function
</source>

[[Category:Basic:Tutorials]]

Talk:Documentation/BASIC Guide/Arrays

2009-02-27T01:43:31Z

Ashawley: /* Multi-dimensional */ new section

== Please expand... ==

* how do you set a value in an array?
** example: see [[Documentation/BASIC Guide/Loops]].
** I added a very simple example, but as I'm only starting, I don't know more ways - I'd also expect something like "myArray = [1, 2, 3] to work, as in many other languages, but I couldn't find how to do that --[[User:HenningSprang|HenningSprang]] 14:38, 22 November 2008 (CET)
* can arrays be appended to other arrays?
* can an item be inserted into an array?
* can an array be indexed with strings or other values?

(copied from the bottom of the Article page. Please post all discussions and comments to the Discussion page.)
--[[User:Ccornell|Ccornell]] 14:34, 20 June 2008 (CEST)

== Multi-dimensional ==

The example for multi-dimensional is awful, because the number for each dimension is the same 5.

Here's what it currently says.

: In addition to single dimensional data fields, {{OOo}} Basic also supports work with multi-dimensional data fields. The corresponding dimensions are separated from one another by commas. The example

: <source lang="oobas">Dim MyIntArray(5, 5) As Integer</source>

: defines an integer array with two dimensions, each with 6 indexes (can be addressed through the indexes 0 to 5). The entire array can record a total of 6 x 6 = 36 integer values.

: You can define hundreds of dimensions in {{OOo}} Basic Arrays; however, the amount of available memory limits the number of dimensions you can have.

Shouldn't how to store and access entries in these also be described? --[[User:Ashawley|Ashawley]] 01:43, 27 February 2009 (UTC)

Documentation/OOo3 User Guides/Calc Guide

2009-02-24T22:48:26Z

Ashawley: fix link

{{DISPLAYTITLE:Spreadsheets with OpenOffice.org 3.x Calc - DRAFT}}

This section contains the text of the user guide titled '''OpenOffice.org 3.x Calc Guide'''.

If you can help with writing, reviewing, or updating any chapters, please contact the [http://oooauthors.org/| OOoAuthors team] regarding chapters not on this wiki, or contribute directly to the chapters on the wiki. [http://oooauthors.org/en/authors/userguide3/calc3/cg3_outline/document_view A draft outline of the book is here.]

[[Documentation/OOo3_User_Guides/Calc Guide/Introducing Calc | Chapter 1 Introducing Calc]]<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Enter edit format | Chapter 2 Entering, Editing, and Formatting Data]]<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Functions and formulas | Chapter 3 Using functions and creating formulas]] - can you help write this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Charts and graphs | Chapter 4 Creating charts and graphs]] - can you help write this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Printing exporting emailing | Chapter 5 Printing, Exporting, and E-mailing]]<br />
[[Documentation/OOo3_User_Guides/Calc Guide/DataPilot | Chapter 6 DataPilot]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Data analysis | Chapter 7 Data analysis]] - can you help write this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Graphics in Calc | Chapter 8 Graphics in Calc]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Linking Calc Data | Chapter 9 Linking Calc Data]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Styles and Templates | Chapter 10 Using styles and templates]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Editing changing reviewing | Chapter 11 Editing, changing and reviewing]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Calc macros | Chapter 12 Calc Macros]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Calc as a Simple Database | Chapter 13 Calc as a Simple Database]] - coming soon<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Keyboard shortcuts | Appendix A Keyboard shortcuts]] - can you help update this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Description of Functions | Appendix B Description of Functions]] - can you help update this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Calc Error Codes | Appendix C Calc Error Codes]] - can you help update this chapter?<br />
[[Documentation/OOo3_User_Guides/Calc Guide/Customizing Calc | Appendix D Setting up and Customizing Calc]] - coming soon