Apache OpenOffice Wiki - User contributions [en]

API/Samples/Java/Writer/BookmarkInsertion

2019-01-04T16:57:12Z

Adailton:

== Example project download ==

[[Image:BookmarkInsertion.zip]]

== See Also ==
*[[API]]
*[[Java]]

[[Category:Writer/API]]
[[Category:API]]
[[Category:Samples]]
[[Category:Java]]

API/Samples/Java/Office/ReadFilesFromOxt

2019-01-04T16:38:37Z

Adailton:

This example shows how to read files that are contained within your .oxt package at runtime.

Here is some code that you can add to your project:

<source lang="java">
private String[] getFileList() {
try {
XPackageInformationProvider xPackageInformationProvider = PackageInformationProvider.get(m_xContext);
String location = xPackageInformationProvider.getPackageLocation("org.openoffice.example");
Object oTransformer = m_xContext.getServiceManager().createInstanceWithContext("com.sun.star.util.URLTransformer", m_xContext);
XURLTransformer xTransformer = (XURLTransformer)UnoRuntime.queryInterface(XURLTransformer.class, oTransformer);
com.sun.star.util.URL[] oURL = new com.sun.star.util.URL[1];
oURL[0] = new com.sun.star.util.URL();
oURL[0].Complete = location + "/some_sub_directory";
xTransformer.parseStrict(oURL);
return new File(oURL[0].Path + oURL[0].Name).list();
} catch (com.sun.star.uno.Exception ex) {
System.out.println(ex);
System.out.println(ex.getStackTrace());
}

return null;
}
</source>

This method returns an array of '''String'''s containing the files in a subdirectory of your package. Be sure to change "some_sub_directory" to the actual name of the subdirectory, or leave it blank to get a list of files at the top level. Also, change "org.openoffice.example" to the Extension Identifier of your package. If you're using Netbeans, you can get the Extension Identifier by right-clicking your project in the projects list and selecting OXT Extension properties, it's under the Extension Management tab.

If you're using Netbeans to build the .oxt file, you'll want to add something like this to your build.xml file:

<source lang="xml">
<target name="-post-uno-package">
<zip update="true" destfile="${uno.package.name}">
<zipfileset dir="src/some_sub_directory" includes="*" casesensitive="yes" prefix="some_sub_directory"/>
</zip>
</target>
</source>

This causes Netbeans to add the sub directory to your package when the .oxt file is built.

== See Also ==
*[[API]]
*[[Java]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Office]]

API/Samples/Java/Office/PropertySet

2019-01-04T16:37:14Z

Adailton:

==About the PropertySet Example==
This example shows how to write a component and set it's properties. Once it is deployed, we'll be able to use a document with OO.o Basic macro to test the component and get its property informations.

First of all, let's look at the example test document “/API/Samples/Java/PropertySet/test/”. You could also get it from here [[Image:PropertySetTest.odt]]. The example button triggers a macro which creates the “PropTest” example service and displays the supported interfaces and properties. You can take a closer look to the Basic macro by editing the macro: 
Select Tools -> Macros -> Organize Macros -> StarOffice Basic, navigate into the document section of “PropertySetTest.odt”, select the Standard -> “PropTest” module, select the “PropetySetTest” macro and press the edit button.

Here is the OpenOffice.org Basic code of the macro:
<source lang="oobas">
REM ***** BASIC *****
Sub PropertySetTest
dim propTest as object
propTest = createUnoService("org.openoffice.sdk.example.propertyset.PropTestService")
msgbox propTest.dbg_supportedinterfaces
msgbox propTest.dbg_properties
End Sub
</source>

'''CreateUnoService()''' method initializes the component / creates the service using service name “org.openoffice.sdk.example.propertyset.PropTestService”, the name which should be exactly the same as the service name property when component is written.

<source lang="java">
private static final String[] m_serviceNames = {
"org.openoffice.sdk.example.propertyset.PropTestService" };
</source>
If you would like to know more detail about above code, please read [http://docs.sun.com/app/docs/doc/819-0439/faakn?l=en&q=staroffice+basic&a=view, OO.o Basic chapters(English)] or [http://docs.sun.com/app/docs/doc/819-1334/faakn?l=zh&a=view, (Chinese version)]. 

==Create component project==
 
The process to create the PropertySet project could refers to [http://wiki.services.openoffice.org/wiki/API/Samples/Java/Office/MinimalComponent, MinimalComponent] project. Some important settings are addressed here. If you aren't familiar with creating a component using OO.o API plugin, you may take a look at the MinimalComponent example as a starting point.

==Use OpenOffice.org Component wizards==

Set the project details 
Project Name: PropertySet 
Class Name: PropTest 
Package: org.openoffice.sdk.example.propertyset 

===Define New Data Type===

Service Property Name: PropertyTestService (it's default value) 
Interface: com.sun.star.lang.XServiceInfo 

===Edit the Source file: PropTest.java===

'''Change the Class definitions to:''' 
public final class PropTest extends PropertySet implements ''com.sun.star.lang.XServiceInfo''

the inherited relation between PropertySet and WeakBase is:
java.lang.Object
└ com.sun.star.lib.uno.helper.WeakBase
└ com.sun.star.lib.uno.helper.ComponentBase
└ com.sun.star.lib.uno.helper.PropertySet

'''Import necessary libraries:''' 
import com.sun.star.lib.uno.helper.PropertySet; 
import com.sun.star.beans.PropertyAttribute; 
import com.sun.star.lang.XTypeProvider; 
import com.sun.star.uno.Any; 
import com.sun.star.uno.Type; 
import com.sun.star.uno.XInterface; 

'''Add following members to the class as component properties''', it's a list of usable data type
<source lang="java">
public boolean boolA;
public char charA;
public byte byteA;
public short shortA;
public int intA;
public long longA;
public float floatA;
public double doubleA;
public String stringA; // MAYBEVOID
public Object objectA; // MAYBEVOID
public Any anyA; // MAYBEVOID
public Type typeA;// MAYBEVOID
public XInterface xinterfaceA;// MAYBEVOID
public XTypeProvider xtypeproviderA;// MAYBEVOID
public boolean[] arBoolA; // MAYBEVOID
public char[] arCharA; // MAYBEVOID
public byte[] arByteA; // MAYBEVOID
public short[] arShortA; // MAYBEVOID
public int[] arIntA; // MAYBEVOID
public long[] arLongA; // MAYBEVOID
public float[] arFloatA; // MAYBEVOID
public double[] arDoubleA; // MAYBEVOID
public String[] arStringA; // MAYBEVOID
public Object[] arObjectA; // MAYBEVOID
public Any[] arAnyA; // MAYBEVOID
public XInterface[] arXinterfaceA; // MAYBEVOID
public boolean[][] ar2BoolA; // MAYBEVOID
public Boolean boolClassA; // MAYBEVOID
public Character charClassA; // MAYBEVOID
public Byte byteClassA; // MAYBEVOID
public Short shortClassA; // MAYBEVOID
public Integer intClassA; // MAYBEVOID
public Long longClassA; // MAYBEVOID
public Float floatClassA; // MAYBEVOID
public Double doubleClassA; // MAYBEVOID

// readonly
public int roIntA= 100;
public Integer roIntClassA= new Integer(100);
public Object roObjectA= new Integer(101);
public Any roAnyA= new Any( new Type(int.class), new Integer(102));

// BOUND & CONSTRAINED
public boolean bcBoolA;
public Boolean bcBoolClassA; // MAYBEVOID
public Object bcObjectA; // MAYBEVOID
public Any bcAnyA; // MAYBEVOID

// MAYBEVOID
public Integer mvIntA;
public Object mvObjectA;
public Any mvAnyA;
public XInterface mvXinterfaceA;
</source>

In the constructor “PropTest( XComponentContext context )”, initialize those properties using registerProperty() method, the method registers a property with this class. It is presumed that the name of property is equal to the name of the member variable that holds the property value.
<source lang="java">
registerProperty("boolA", (short) 0);
registerProperty("charA", (short) 0);
registerProperty("byteA", (short) 0);
registerProperty("shortA", (short) 0);
registerProperty("intA", (short) 0);
registerProperty("longA", (short) 0);
registerProperty("floatA", (short) 0);
registerProperty("doubleA", (short) 0);
registerProperty("stringA", PropertyAttribute.MAYBEVOID);
registerProperty("objectA", PropertyAttribute.MAYBEVOID);
registerProperty("anyA", PropertyAttribute.MAYBEVOID);
registerProperty("typeA", PropertyAttribute.MAYBEVOID);
registerProperty("xinterfaceA", PropertyAttribute.MAYBEVOID);
registerProperty("xtypeproviderA", PropertyAttribute.MAYBEVOID);
registerProperty("arBoolA", PropertyAttribute.MAYBEVOID);
registerProperty("arCharA", PropertyAttribute.MAYBEVOID);
registerProperty("arByteA", PropertyAttribute.MAYBEVOID);
registerProperty("arShortA", PropertyAttribute.MAYBEVOID);
registerProperty("arIntA", PropertyAttribute.MAYBEVOID);
registerProperty("arLongA", PropertyAttribute.MAYBEVOID);
registerProperty("arFloatA", PropertyAttribute.MAYBEVOID);
registerProperty("arDoubleA", PropertyAttribute.MAYBEVOID);
registerProperty("arStringA", PropertyAttribute.MAYBEVOID);
registerProperty("arObjectA", PropertyAttribute.MAYBEVOID);
registerProperty("arAnyA", PropertyAttribute.MAYBEVOID);
registerProperty("arXinterfaceA", PropertyAttribute.MAYBEVOID);
registerProperty("ar2BoolA", PropertyAttribute.MAYBEVOID);
registerProperty("boolClassA", PropertyAttribute.MAYBEVOID);
registerProperty("charClassA", PropertyAttribute.MAYBEVOID);
registerProperty("byteClassA", PropertyAttribute.MAYBEVOID);
registerProperty("shortClassA", PropertyAttribute.MAYBEVOID);
registerProperty("intClassA", PropertyAttribute.MAYBEVOID);
registerProperty("longClassA", PropertyAttribute.MAYBEVOID);
registerProperty("floatClassA", PropertyAttribute.MAYBEVOID);
registerProperty("doubleClassA", PropertyAttribute.MAYBEVOID);
registerProperty("roIntA", PropertyAttribute.READONLY);
registerProperty("roIntClassA", PropertyAttribute.READONLY);
registerProperty("roObjectA", PropertyAttribute.READONLY);
registerProperty("roAnyA", PropertyAttribute.READONLY);
registerProperty("bcBoolA",(short) ( PropertyAttribute.BOUND | PropertyAttribute.CONSTRAINED));
registerProperty("bcBoolClassA", (short) (PropertyAttribute.BOUND |PropertyAttribute.CONSTRAINED | PropertyAttribute.MAYBEVOID));
registerProperty("bcObjectA", (short) (PropertyAttribute.BOUND | PropertyAttribute.CONSTRAINED | PropertyAttribute.MAYBEVOID));
registerProperty("bcAnyA", (short) (PropertyAttribute.BOUND | PropertyAttribute.CONSTRAINED |PropertyAttribute.MAYBEVOID));
registerProperty("mvIntA", PropertyAttribute.MAYBEVOID);
registerProperty("mvObjectA", PropertyAttribute.MAYBEVOID);
registerProperty("mvAnyA", PropertyAttribute.MAYBEVOID);
registerProperty("mvXinterfaceA", PropertyAttribute.MAYBEVOID);
</source>

For information of PropertyAttribute, please visit SDK docuement: SDK_DIR/docs/java/ref/com/sun/star/beans/PropertyAttribute.html
The document can be loaded into browser when the editing cursor on “PropertyAttribute” string in the editor and then press keys Alt + F1.

===Delopyment===
Deploy the component and load PropTest.odt to test your component.
After the button pressed, two message boxes will show this component's supported interfaces and it's attributes.
<source lang="oobas">
msgbox propTest.dbg_supportedinterfaces
msgbox propTest.dbg_properties
</source>

== Example project download ==

[[Image:PropertySet.zip]]

== See Also ==
*[[API]]
*[[Java]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Office]]

API/Samples/Java/Office/OokScriptProvider

2019-01-04T16:34:48Z

Adailton:

{{revision}}

The OokScriptProvider is a sample extension that shows how to integrate a new macro scripting language (in this case the esotheric language [http://www.dangermouse.net/esoteric/ook.html Ook]) into OpenOffice.org.

You can find the source code within the OpenOffice.org repository in /contrib/sdk/examples/java/OokScriptProvider

You can find a [http://extensions.services.openoffice.org/project/ookscriptprovider binary version here].

== See Also ==
*[[API]]
*[[Java]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Office]]

API/Samples/Java/Office/MinimalComponent

2019-01-04T16:33:01Z

Adailton:

'''Building a Minimal Component'''

== Building Environment ==
NetBeans 5.5.1, OpenOffice.org 2.3，OpenOffice.org. 2.3 SDK, OpenOffice.org plugin

Openoffice.org API plugin, it's easy task to create a component framework/minimal component project(SDK_DIR/examples/java/MinimalComponent). More featured component could be extended from this mini component. The tutorial aims to show how to use the wizard. For detailed wizards specification, please visit: http://specs.openoffice.org/sdk/tools/spec_openoffice-netbeans-integration-component-wizard.odt
(lasted visit Jan 7th, 2008)

--------------------------------------------------------------------

==Project Wiards==
===Create a new OpenOffice.org Component project===
[[Image:minicomfg1.PNG]]

===Editing project information===
[[Image:minicomfg2.PNG]]

===Define Service===
[[Image:minicomfg3.PNG]]

The component requires “'''at least one implemented service with at least one valid interface'''”. Click “Define New Data Type” button to defined the Component Service. The wizard would not be able to proceed to next step if the requirement is not meet.

===Choose implementation Interface===
The project will automatically create a service for you, which is named with '''YOUR_COMPONENTService''' in your package, the one thing you need to do is, to specify it's implantation interface.

[[Image:minicomfg4.PNG]]

Let's set the Interface as “com.sun.star.lang.XInitialization“, you can enter the full interface manually or via pick up window (Figure 5, click th e small button on the right end to pop up the window). For detail of component interface please look at developers' guide chapter 4.4 '''Core Interfaces to Implement'''.

[[Image:minicomfg5.PNG]]

The Service name specified here could be referred to the source code:
<code> [java,N]
private static final String[] m_serviceNames = {
"org.openoffice.sdk.example.minimalcomponent.MinimalComponentService" };
</code>

[[Image:minicomfg6.PNG]]

After finish this step, we will get a following code in the source file:
<code> [java,N]
public final class MinimalComponent extends WeakBase
implements com.sun.star.lang.XServiceInfo,
com.sun.star.lang.XInitialization
{....}
</code>

Click 'OK' to continue. Now the Service 'org.openoffice.sdk.example.minimalcomponent.MinimalComponentService' was defined and available to use. It is the service name, will be available to called by UNO API.

[[Image:minicomfg7.PNG]]

Now, the new type could be added to the implementation of this project by clicking 'Add Service/Interface' button which is located at top right.

[[Image:minicomfg8.PNG]]

The service could be found in which package the service was defined.

After selected MinimalComponentService to the implementation, click 'Finish' button to finish the wizard, then the Component project will be created.

[[Image:minicomfg9.PNG]]

==Edit source code==

There are three main files was placed in source folder:

CentralRegistartionClass.java
it's a helper class from the NetBeans plugin. this class manage the
registration of several UNO implmentation objects in one project. For
exmaple if you would now based on this new project create a second
service implementation via the new File -> Java UNO Object or UNOIDL
File (with implementation) the registration class would handle all this
components to register them during the installation.

MinimalComponent.java
it's the generated code skeleton for the new defined
MinimalComponentService. Here you have to implement all the interface
methods that are related to this new service and it's interface.

MinimalComponentService.idl
The UNOIDL definition of the new defined service

[[Image:minicomfg10.PNG]]

Because it's a minimali component, it doesn't have other implementation. Thus, we can deploy and test it straight away.
[[Image:minicomfg11.PNG]]

==Test the component==

After you have deployed the component. It should be possible to use the
new type in your client application. A Testing program is needed to test the component, which connect to component and call getImplementationName() method to get the component implementation name. From the project browser, add a new Java class to the package, name it as TestMinimalComponent, and input the following lines
<source lang="java">
package org.openoffice.sdk.example.minimalcomponent;

import com.sun.star.lang.XSingleComponentFactory;
import com.sun.star.lang.XMultiComponentFactory;
import com.sun.star.uno.XComponentContext;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.container.XSet;
import com.sun.star.lang.XServiceInfo;
import com.sun.star.uno.XInterface;

public class TestMinimalComponent {

/** Creates a new instance of TestMinimalComponent */
public TestMinimalComponent () {
}

public static void main(String args[]) {
com.sun.star.uno.XComponentContext xContext = null;

try {
// get the remote office component context
xContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
if( xContext != null )
System.out.println("Connected to a running office ...");

XMultiComponentFactory xMCF = xContext.getServiceManager ();

XServiceInfo xSIMinimalComponent = (XServiceInfo) UnoRuntime.queryInterface (
XServiceInfo.class,
xMCF.createInstanceWithContext ("org.openoffice.sdk.example.minimalcomponent.MinimalComponentService",xContext)
);

System.out.println("\nXServiceInfo is used to get the implementation" +
" name: " +
xSIMinimalComponent.getImplementationName() +
"\nOk\n");
xContext = null;

System.exit(0);
}
catch( Exception e ) {
System.err.println( e );
e.printStackTrace();
System.exit(1);
}
}
}
</source>

Another option is to create separated project by using OpenOffice.org client application wizard, but you need the new type info on the client side. you should added '''IDL_types.jar''' file from the component output directory(/dist folder in the component project) to the libraries of the client program in order to gain the service support, MinimalComponentService in this case.

In the TestMinimalComonent code, here is the way to get and use the reference of the component and its services.
<source lang="java">
XServiceInfo xSIMinimalComponent = (XServiceInfo) UnoRuntime.queryInterface (
XServiceInfo.class,
xMCF.createInstanceWithContext("org.openoffice.sdk.example.minimalcomponent.MinimalComponentService",xContext)
);

System.out.println("\nXServiceInfo is used to get the implementation" +
" name: " +
xSIMinimalComponent.getImplementationName() +
"\nOk\n");
</source>

'''Output Result:'''
Run TestMinimalComponent.java, you should get output:
XServiceInfo is used to get the implementation name: org.openoffice.sdk.example.minimalcomponent.MinimalComponent
Ok

== See Also ==
*[[API]]
*[[Java]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Office]]

API/Samples/Java/Draw/Impress/SDraw

2019-01-04T16:28:55Z

Adailton:

== Open Drawing documents ==

you need to specifies the URL of the document to load for loadComponentFromURL() as “private:factory/sdraw”

== Draw document structure ==

Draw documents maintain their drawing content on draw pages, master pages and layers. If a new draw document is opened, it contains one slide that corresponds to a '''com.sun.star.drawing.DrawPage''' service. Switching to Master View brings up the master page handled by the service '''com.sun.star.drawing.MasterPage'''. The Layer View allows access to layers to structure your drawings. These layers can be controlled through '''[http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/Layer.html com.sun.star.drawing.Layer]''' and '''com.sun.star.drawing.LayerManager'''.

The com.sun.star.drawing.DrawingDocument service has following interfaces for this purposes:

XDrawPagesSupplier:
XMasterPagesSupplier:
XLayerSupplier:
XStyleFamiliesSupplier:

[http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/XDrawPageSupplier.html XDrawPagesSupplier] and [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/XMasterPagesSupplier.html XMasterPagesSupplier] supplies XDrawPages and [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/MasterPage.html XMasterPages] via [[http://www.openoffice.org/api/docs/common/ref/com/sun/star/container/XIndexAccess.html XIndexAccess]. Each DrawPage has support [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/XShape.html com.sun.star.drawing.XShapes] interface to manage shapes in this DrawPage.

The brief summary to access the single shape in Drawing document might be described as:

# Open Drawing document
# Querying DrawPagesSupplier interface of Drawing document
# Call '''getDrawPages()''' method of DrawPagesSupplier to get DrawPages
# Querying '''XIndexAccess''' interface of DrawPages
# Single DrawPage can be accessd through method of [http://www.openoffice.org/api/docs/common/ref/com/sun/star/container/XIndexAccess.html#getByIndex XIndexAccess: XIndexAccess.getByIndex()]
# However, [http://www.openoffice.org/api/docs/common/ref/com/sun/star/container/XIndexAccess.html#getByIndex XIndexAccess.getByIndex()] method returns ANY type, you should querying [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/DrawPage.html XDrawPage] interface before using it.
# Going a little bit further, Querying [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/XShapes.html XShapes] interface of [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/DrawPage.html XDrawPage] to gain access to the list of [http://www.openoffice.org/api/docs/common/ref/com/sun/star/drawing/Shapes.html XShape]

== Shapes ==

Drawings consist of shapes on draw pages. Shapes are drawing elements, such as rectangles, circles, polygons, and lines. To create a drawing, get a shape by its service name at the ServiceFactory of a drawing document and add it to the appropriate DrawPage.

<source lang="java">

//get MSF
com.sun.star.lang.XMultiServiceFactory xDocMSF =
(com.sun.star.lang.XMultiServiceFactory)UnoRuntime.queryInterface(
com.sun.star.lang.XMultiServiceFactory.class, xDocComp );

...

oInt = xDocMSF.createInstance("com.sun.star.drawing.EllipseShape");
xShape = (com.sun.star.drawing.XShape)UnoRuntime.queryInterface(
com.sun.star.drawing.XShape.class, oInt);

...

// set the size and positions
size.Height = height;
size.Width = width;
position.X = x;
position.Y = y;
xShape.setSize(size);
xShape.setPosition(position);
</source>

ServiceFactory can create several kind of Shape Service, they could be LineShape, PolyLineShape, RectangleShape, TextShape etc.

[[Image:ShapeType1.png]]

[[Image:ShapeType2.png]]

== Example project download ==

[[Image:SDraw.zip]]

== See Also ==
*[[API]]
*[[Java]]
*[[Draw]]
*[[Impress]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Draw]]
[[Category:Impress]]

API/Samples/Java/Database/TableStructure(SDBCX)

2019-01-04T16:22:28Z

Adailton:

== Table Structure (extended) ==
Beside the [[database]] meta data interface, the interfaces in the namespace com.sun.star.sdbcx.* supports a different more objective orientated way on looking at the database.

<source lang="java">
public void displayTableProperties() throws com.sun.star.uno.Exception
{
// the variable xTabSup is a XTablesSupplier which you get from the XDriver in conjunction with the connection
XNameAccess xTables = xTabSup.getTables();
String[] aTableNames = xTables.getElementNames();
if ( 0 != aTableNames.length )
{
Object table = xTables.getByName(aTableNames[0]);
XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, table);
System.out.println("Name: " + xProp.getPropertyValue(NAME));
System.out.println("CatalogName: " + xProp.getPropertyValue("CatalogName"));
System.out.println("SchemaName: " + xProp.getPropertyValue("SchemaName"));
System.out.println("Description: " + xProp.getPropertyValue("Description"));
// the following property is optional so we first must check if it exists
if ( xProp.getPropertySetInfo().hasPropertyByName(TYPE) )
{
System.out.println("Type: " + xProp.getPropertyValue(TYPE));
}
System.out.println("Columns:");
XColumnsSupplier columnsSupplier = (XColumnsSupplier) UnoRuntime.queryInterface(XColumnsSupplier.class, table);
printColumns(columnsSupplier);
System.out.println("Keys:");
printKeys(columnsSupplier);
}
}
//###########################################################
// 15. example
// print all columns of a XColumnsSupplier
//###########################################################
public static void printColumns(final XColumnsSupplier xColumnsSup) throws com.sun.star.uno.Exception, SQLException
{
System.out.println("Example printColumns");
// the table must be at least support a XColumnsSupplier interface
System.out.println("--- Columns ---");
XNameAccess xColumns = xColumnsSup.getColumns();
String[] aColumnNames = xColumns.getElementNames();
for ( int i = 0; i <= aColumnNames.length - 1; i++ )
{
System.out.println(" " + aColumnNames[i]);
}
}
//###########################################################
// 16. example
// print all keys inclusive the columns of a key
//###########################################################

public static void printKeys(final XColumnsSupplier xColumnsSup) throws com.sun.star.uno.Exception, SQLException
{
System.out.println("Example printKeys");
XKeysSupplier xKeysSup = (XKeysSupplier) UnoRuntime.queryInterface(XKeysSupplier.class, xColumnsSup);
if ( xKeysSup != null )
{
System.out.println("--- Keys ---");
XIndexAccess xKeys = xKeysSup.getKeys();
for ( int i = 0; i < xKeys.getCount(); i++ )
{
Object key = xKeys.getByIndex(i);
XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, key);
System.out.println(" " + xProp.getPropertyValue(NAME));
XColumnsSupplier xKeyColumnsSup = (XColumnsSupplier) UnoRuntime.queryInterface(XColumnsSupplier.class, xProp);
printColumns(xKeyColumnsSup);
}
}
}
</source>

[[Category:API]]
[[Category:Java]]

API/Samples/Java/Database/TableStructure

2019-01-04T16:21:22Z

Adailton:

== Table Structure ==
The [[database]] meta data interface gives you access to many information about the structure of the database. The example below show how to display all tables of the database including the column names using [[Java]].

<source lang="java">
// displays the structure of the first table
public static void displayTableStructure(final XConnection con) throws com.sun.star.uno.Exception
{
XDatabaseMetaData dm = con.getMetaData();
XResultSet rsTables = dm.getTables(null, "%", "SALES", null);
XRow rowTB = (XRow) UnoRuntime.queryInterface(XRow.class, rsTables);
while ( rsTables.next() )
{
String catalog = rowTB.getString(1);
if ( rowTB.wasNull() )
{
catalog = null;
}

String schema = rowTB.getString(2);
if ( rowTB.wasNull() )
{
schema = null;
}

String table = rowTB.getString(3);
String type = rowTB.getString(4);
System.out.println("Catalog: " + catalog + " Schema: " + schema + " Table: " + table + " Type: " + type);
System.out.println("------------------ Columns ------------------");
XResultSet rsColumns = dm.getColumns(catalog, schema, table, "%");
XRow rowCL = (XRow) UnoRuntime.queryInterface(XRow.class, rsColumns);
while ( rsColumns.next() )
{
System.out.println("Column: " + rowCL.getString(4) + " Type: " + rowCL.getInt(5) + " TypeName: " + rowCL.getString(6));
}

}
}
</source>

[[Category:API]]
[[Category:Java]]

API/Samples/Java/Database/DataAwareness

2019-01-04T16:18:56Z

Adailton:

{{DISPLAYTITLE:Data aware forms}}
=== Introduction ===
*[[API]]
*[[Java]]
*[[Database]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Database]]

API/Samples/Java/CalcAddin

2019-01-04T16:17:54Z

Adailton:

'''Create [[Calc]] Addin'''

2008.01.03

== System Environment ==
Netbeans 5.5.1, OpenOffice.org 2.3 and OpenOffice.org 2.3 SDK, OpenOffice.org [[API]] plugin for Netbeans
For more installation details and instructions, please visit:
[[http://wiki.services.openoffice.org/wiki/OpenOffice_NetBeans_Integration OpenOffice NetBeans Integration]] 
This step-by-step illustration shows how to create the sdk example - CalcAddin by using OpenOffice.org API plugin in NetBeans. 

=== Create a Calc Addin project by using OpenOffice.org API plugin ===
 
Select 'File'->'New Project' to bring up the following dialog, then select 'OpenOffice.org Calc Add-in' project type in 'OpenOffice.org' Categories, click 'Next' button to proceed to next step. 
[[Image:CalcAddinFg1.png]] Figure 1, choose project type 

=== Set project details ===
 
Set project name and Calc Add-in name as 'CalcAddin',assign this project to 'org.openoffice.sdk.example.spreadsheet' package, chose the project location where the source code are stored, then click 'Next' to proceed to next step. 
[[Image:CalcAddinFg2.png]] Figure 2, Set project details 

Check 'Create backward compatible Cacl Add-In' option to create extra backward compatible Calc Addin(*.xcs file). 

=== Add functions and Parameters ===
 
Adding two function for this AddIn.
<code>[java,N]
public int getMyFirstValue(
com.sun.star.beans.XPropertySet xOptions)

public int getMySecondValue(
com.sun.star.beans.XPropertySet xOptions,
int intDummy)
</code>
 

==== GetMyFirstValue function configuration ====
 
*Double click Function1 to expand function settings for the first function: 
[[Image:CalcAddinFg3.png]] Figure 3, The first function Name and its type 
*Set the first Function name as 'getMyFirstValue”
*Set return Type as 'int'
*Set Category as “Add-In'

*Double click parameter0 to configure parameter settings 
[[Image:CalcAddinFg4.png]] Figure 4, The first function parameter 
*Set parameter name as 'xOptions', and set type as 'XpropertySet'

Finaly, the first function will be like the following figure:

[[Image:CalcAddinFg5.png]] Figure 5, The first function setting 

==== Add the second function – getMySecondValue method ====
 
*click 'Add function' button at top right of dialog 
[[Image:CalcAddinFg6.png]] Figure 6, Add new function 
*setting function name as 'getMySecondValue' 
*click 'Add parameter' to add one more parameter for the second function 
[[Image:CalcAddinFg7.png]] Figure 7, Add new parameter 
*set parameter0's name as ' xOptions', set it's type as 'XpropertySet' 
*set parameter1's name as ' intDummy', set it's type as 'int' 
[[Image:CalcAddinFg8.png]] Figure 8, Configuration completed 
*Click Finish button to finish the wizards.

Now, the Calc Add-In project has been created. From project browser, it will be like the following figure:
[[Image:CalcAddinFg9.png]] Figure 9, Project Browser 

=== Implement functions ===
 
To implement two functions specified previously, open CalcAddinImpl.java file from project browser and find the function bodies. 
<code>[java,N]
// org.openoffice.sdk.example.Spreadsheet.XCalcAddin:
public int getMyFirstValue(com.sun.star.beans.XPropertySet xOptions)
{
// TODO: Exchange the default return implementation for "getMyFirstValue" !!!
// NOTE: Default initialized polymorphic structs can cause problems
// because of missing default initialization of primitive types of
// some C++ compilers or different Any initialization in Java and C++
// polymorphic structs.
return 0;
}

public int getMySecondValue(com.sun.star.beans.XPropertySet xOptions, int intDummy)
{
// TODO: Exchange the default return implementation for "getMySecondValue" !!!
// NOTE: Default initialized polymorphic structs can cause problems
// because of missing default initialization of primitive types of
// some C++ compilers or different Any initialization in Java and C++
// polymorphic structs.
return 0;
}

</code>Figure 10. Original code 
Modify a few lines of these two functions:
<code>[java,N]
// org.openoffice.sdk.example.Spreadsheet.XCalcAddin:
public int getMyFirstValue(com.sun.star.beans.XPropertySet xOptions)
{
// TODO: Exchange the default return implementation for "getMyFirstValue" !!!
// NOTE: Default initialized polymorphic structs can cause problems
// because of missing default initialization of primitive types of
// some C++ compilers or different Any initialization in Java and C++
// polymorphic structs.
return (int) 1;
}

public int getMySecondValue(com.sun.star.beans.XPropertySet xOptions, int intDummy)
{
// TODO: Exchange the default return implementation for "getMySecondValue" !!!
// NOTE: Default initialized polymorphic structs can cause problems
// because of missing default initialization of primitive types of
// some C++ compilers or different Any initialization in Java and C++
// polymorphic structs.
return ( (int) 2 + intDummy);
}
</code>Figure 11, Completed implementation 

you may get error message on line 13 like 'cannot find symbol', ignore it. After the first build, the message will not not shown any more. 

[[Image:CalcAddinFg12.png]] Figure 12, Error message for XCalcAddin 

=== Deploy and test CalcAddin ===
 
==== Deployement ====
 
Save all changes and 'clear and build' the project, then the addin can be deployed via right click the 'CalcAddin' in the project browser.
[[Image:CalcAddinFg13.png]] Figure 13, Delpoy the Addin 

Extension manager dialog, the new addin is available to use now: 
[[Image:CalcAddinFg14.png]] Figure 14, Extension manager 

In the function wizard (Ctrl+F2), these two function could be found in the 'Addin' 
[[Image:CalcAddinFg15.png]] Figure 15, Function Wizard 
==== Testing ====
 
Go to the example folder'/CalcAddin/test/' to open the 'CalcAddins.ods' file to test these two functions. 
[[Image:CalcAddinFg16.png]] Figure 16, Test Addins 

== Example project download ==

[[Image:CalcAddin.zip]]

[[Category:API]]
[[Category:Samples]]
[[Category:Java]]
[[Category:Calc]]

API/Samples/Java

2019-01-04T16:15:00Z

Adailton:

Under this section you can find examples showing different [[API]] use cases implemented in [[Java]].

==Office==
<DPL> category=API
category=Samples
category=Java
category=Office</DPL>
==Writer==
<DPL> category=API
category=Samples
category=Java
category=Writer/API</DPL>
==Calc==
<DPL> category=API
category=Samples
category=Java
category=Calc</DPL>
==Draw/Impress==
<DPL> category=API
category=Samples
category=Java
category=Draw
category=Impress</DPL>
==Database==
<DPL>
category=API
category=Samples
category=Java
category=Database
</DPL>
==Chart==
<DPL> category=API
category=Samples
category=Java
category=Chart</DPL>

[[Category:API]]
[[Category:Samples]]

API/Samples/Groovy/Writer/MostPopularWords

2019-01-04T16:12:40Z

Adailton:

==About the MostPopularWords Example==
This example shows how to get the text of whole document or its selected parts and how to display some statistics (exactly the most popular words) for this text in info message box in a [[GroovyForOpenOffice|Groovy]] macro.

==The Code==
<source lang="java">

/*
Some OpenOffice.org API classes. For more information on
these classes and the OpenOffice.org API, see the OpenOffice.org
Developers Guide at:

http://api.openoffice.org/
*/

import com.sun.star.uno.UnoRuntime
import com.sun.star.uno.XComponentContext

import com.sun.star.container.XIndexAccess
import com.sun.star.container.XNameContainer

import com.sun.star.beans.XPropertySet

import com.sun.star.frame.XDesktop
import com.sun.star.frame.XModel

import com.sun.star.awt.XWindow
import com.sun.star.awt.XWindowPeer
import com.sun.star.awt.XMessageBoxFactory
import com.sun.star.awt.XMessageBox
import com.sun.star.awt.Rectangle

import com.sun.star.lang.XComponent
import com.sun.star.lang.XMultiComponentFactory
import com.sun.star.lang.XMultiServiceFactory

import com.sun.star.view.XSelectionSupplier

import com.sun.star.text.XTextDocument
import com.sun.star.text.XTextRange
import com.sun.star.text.XText

// The number of words to display as a result
final int NW = 5
// These words should be ignored when searching for most popular words
final List<String> ignoreList = ['a', 'an', 'the', 'in', 'for', 'to', 'at', 'of', 'by',
'and', 'or', 'nor', 'whether', 'as', 'with', 'on', 'through', 'when']

class UnoCategory {
public static Object uno(Object unoObj, Class clazz) { UnoRuntime.queryInterface(clazz, unoObj) }
public static Object getAt(XPropertySet pset, String pname) { pset.getPropertyValue(pname) }
public static void putAt(XPropertySet pset, String pname, Object newValue) { pset.setPropertyValue(pname, newValue) }
public static Object getAt(XIndexAccess ndx, int x) { ndx.getByIndex(x) }
}

// The algorithmic part of this macro
List<String> getMostPopularWords(String text, List<String> ignoreList, int count) {
words = (text =~ /\w+/)
freqMap = [:]
words.each {
String lcWord = it.toLowerCase()
if (!ignoreList.contains(lcWord)) {
if (null == freqMap[lcWord]) {
freqMap[lcWord] = 1
} else {
freqMap[lcWord]++
}
}
}
wordList = freqMap.keySet().toList()
wordList.sort {freqMap[it]}
return (count >= wordList.size()) ? wordList : wordList[-1..-count]
}

// This function is used to get the text of whole document or its selected parts
String getText() {
String text = ""

use (UnoCategory) {
def oDoc = XSCRIPTCONTEXT.document
def oModel = oDoc.uno(XModel)
def oSelectionSupplier = oModel.currentController.uno(XSelectionSupplier)
def oIndexAccess = oSelectionSupplier.selection.uno(XIndexAccess)
def count = oIndexAccess.count

def xText = oDoc.uno(XTextDocument).text
if (count > 1) {
// More than one selection
// Work backwards so that multiple selections stay valid.
for (i in count - 1..0) {
// get the XTextRange of the selection
oTextRange = oIndexAccess[i].uno(XTextRange)
text += ' ' + oTextRange.string
}
} else {
oTextRange = oIndexAccess[0].uno(XTextRange)
if (0 == oTextRange.string.size()) {
// The whole document, no selection
text = xText.string
} else {
// Exactly one selection
text = oTextRange.string
}
}
}

return text
}

// Getting parent window for message box
XWindow getParentWindow(xContext) {
use (UnoCategory) {
XMultiComponentFactory xMCF = xContext.serviceManager
Object boxModel = xMCF.createInstanceWithContext("com.sun.star.frame.Desktop", xContext)
XDesktop xd = boxModel.uno(XDesktop)
XComponent box = xd.currentComponent
XModel model = box.uno(XModel)
return model.currentController.frame.containerWindow
}
}

// Function to display info message box
def showInfoMsg(title, text) {
use (UnoCategory) {
XWindow pWnd = getParentWindow(XSCRIPTCONTEXT.componentContext)
XWindowPeer pWndPeer = pWnd.uno(XWindowPeer)
XMessageBoxFactory msgBoxFactory = pWndPeer.toolkit.uno(XMessageBoxFactory)
XMessageBox msgBox = msgBoxFactory.createMessageBox(pWndPeer, new Rectangle(), "infobox", 0, title, text)
msgBox.execute()
}
}

showInfoMsg('The most popular words', getMostPopularWords(getText(), ignoreList, NW).join(' '))
</source>

[[Category:Writer/API]]
[[Category:API]]
[[Category:Samples]]
[[Category:Groovy]]

AOO UX Design Exploration - Task Pane Content Panel - User Interface Design Proposals

2019-01-04T16:08:23Z

Adailton:

== [[Sidebar]] Content Panel - UX Design propoals ==
For frame work part, use flat tab option to replace accordion effect. 
For content part, create 3 proposals to show the status of ‘Unfolded/Folded’ in Content Panels, and also created 3 proposals for Content panel layouts: 

‘Unfolded/folded’ of Content Panel: 
Proposal 1. Grey Title + Grey Panel 
Proposal 2. Grey Title + White Panel 
Proposal 3. Dark Grey Title + White Panel(Consistent with current AOO definitions) 

Content panel layouts: 
Proposal A. Gradient Color Background 
Proposal B. Simple Line as spliter 
Proposal C. Emboss effect 

To combine these proposals, totally we have 9 options for Content Panel. 

{| class="wikitable"
|-
! Sidebar Options
! Proposal 1. Grey Title + Grey Panel
! Proposal 2. Grey Title + White Panel
! Proposal 3. Dark Grey Title + White Panel
|-
| Proposal A. Gradient Color Background
| [[File:AOO 40 Sidebar Option 1.png]]
| [[File:AOO 40 Sidebar Option 2.png]]
| [[File:AOO 40 Sidebar Option 3.png]]
|-
| Proposal B. Simple Line as spliter
| [[File:AOO 40 Sidebar Option 4.png]]
| [[File:AOO 40 Sidebar Option 5.png]]
| [[File:AOO 40 Sidebar Option 6.png]]
|-
| Proposal C. Emboss effect
| [[File:AOO 40 Sidebar Option 7.png]]
| [[File:AOO 40 Sidebar Option 8.png]]
| [[File:AOO 40 Sidebar Option 9.png]]
|}

Option 10:Gradient section title + Light grey panel + Simple line separators 
[[File:Option 10.png]] 

Screenshots of Presentation editor with option 10 
[[File:Screenshots of Presentation editor with proposal 10.png]] 

== Overview visual information definition ==
Including the gradient color, the background color, the border line, the font color, the font size and so on. 
All the overview visual definition is based on font Arial 11. We set all distance and size based on that. If the font size has been changed, other distance and size should be also changed. 
We use Win7 as OS reference, all systems effects that we mentioned in the proposal follow Win7. If the OS has been changed, the system effects should be also changed and follow the corresponding OS. 
[[File:AOO4.0sidebar visual option size marking .jpg]][[File:AOO4.0sidebar panel visual option size marking .jpg]]

== Sidebar specific panel design ==
Two design principles: 
1.Icon style of sidebar in AOO 4.0. From UX point of view, to avoid the usability issues, we need to make sure the same icon for the same function in AOO and all the icons have the same visual style. So we need to use AOO icons in sidebar. For the buttons which did not have AOO icons, we will use Symphony icons. 
2. UI controls in A00 4.0. Choose the one has more user-friendly interaction behavior. Symphony did lots of improvements based on the original Open Office, so the current behavior in Symphony is more reasonable choice, like Number Bullet, Line Style... 
{| class="wikitable" style="background-color:#FFFFFF;"
|-
!
!Document Editor contextual sections
!scope="col" width="490" |Spreadsheet Editor contextual sections
!Presentation Editor contextual sections
!scope="col" width="320" |Dropdown List
!Note
|-
!1 Text
|[[File:Text-DE-22-aa.jpg]][[File:Text-DE-22-ab.jpg]]
|[[File:Text-SE-23-aa.jpg|left|230px]][[File:Text-SE-23-ba.jpg|right|230px]][[File:Text-SE-23-ab.jpg|left|230px]][[File:Text-SE-23-bb.jpg|right|230px]]
|[[File:Text-PE-24-aa.jpg]][[File:Text-PE-24-ab.jpg]]
|[[File:Text-25-aa.jpg|left|145px]][[File:Text-25-ba.jpg|right|145px]][[File:Text-25-ab.jpg|left|145px]][[File:Text-25-bb.jpg|right|145px]]
|
|-
!2 Paragraph
|[[File:Paragraph-DE-32-aa.jpg]][[File:Paragraph-DE-32-ab.jpg]]
|no need
|[[File:Paragraph-PE-34-aa.jpg]][[File:Paragraph-PE-34-ab.jpg]]
|[[File:Paragraph-35-aa.jpg|left|145px]][[File:Paragraph-35-ba.jpg|right|145px]][[File:Paragraph-35-ab.jpg|left|145px]][[File:Paragraph-35-bb.jpg|right|145px]]
|
|-
!3 Slide Layout
|no need
|no need
|[[File:Slide layout-PE-44-aa.jpg]]
|no need
|
|-
!4 Line
|[[File:Line-DE-52-aa.jpg]]
|[[File:Line-SE-53-aa.jpg]]
|[[File:Line-PE-54-aa.jpg]]
|[[File:Line-55-aa.jpg|left|150px]][[File:Line-55-ba.jpg|right|140px]][[File:Line-55-ab.jpg|left|150px]][[File:Line-55-ac.jpg|right|140px]][[File:Line-55-bc.jpg]]
|
|-
!5 Area
|[[File:Area-DE-62-aa.jpg]][[File:Area-DE-62-ab.jpg]]
|[[File:Area-SE-63-aa.jpg]][[File:Area-SE-63-ab.jpg]]
|[[File:Area-PE-64-aa.jpg]][[File:Area-PE-64-ab.jpg]]
|[[File:Area-65-aa.jpg]][[File:Area-65-ba.jpg]][[File:Area-65-ca.jpg]]
|Use AOO Icon to replace Symphony Icon in control on sidebar.
|-
!6 Alignment
|no need
|[[File:Aligment-SE-73-aa.jpg]][[File:Aligment-SE-73-ab.jpg]]
|no need
|[[File:Aligment-75-aa.jpg]]
|
|-
!7 Number Format
|no need
|[[File:Number Format-SE-83-aa.jpg]][[File:Number Format-SE-83-ab.jpg]]
|no need
|[[File:Number Format-85-aa.jpg]]
|
|-
!8 Page
|[[File:Page-DE-92-aa.jpg]][[File:Page-DE-92-ab.jpg]]
|no need
|no need
|[[File:Page-95-aa.jpg]][[File:Page-95-ba.jpg]][[File:Page-95-ab.jpg]][[File:Page-95-bb.jpg]]
|
|-
!9 Position and Size
|[[File:Position and Size-DE-102-aa.jpg]][[File:Position and Size-DE-102-ba.jpg]]
|[[File:Position and Size-SE-103-aa.jpg]][[File:Position and Size-SE-103-ba.jpg]]
|[[File:Position and Size-PE-104-aa.jpg]]
|[[File:Position and Size-105-aa.jpg]]
|
|-
!10 Graphic
|[[File:Graphic-DE-112-aa.jpg]][[File:Graphic-DE-112-ab.jpg]]
|[[File:Graphic-SE-113-aa.jpg]][[File:Graphic-SE-113-ab.jpg]]
|[[File:Graphic-PE-114-aa.jpg]][[File:Graphic-PE-114-ab.jpg]]
|[[File:Graphic-115-aa.jpg]]
|All use Symphony controls in this panel, except color mode.
|-
!11 Cell Appearance
|no need
|[[File:Cell Appearance-SE-123-aa.jpg]][[File:Cell Appearance-SE-123-ab.jpg]]
|no need
|[[File:Cell Appearance-125-aa.jpg|left|145px]][[File:Cell Appearance-125-ba.jpg|right|145px]][[File:Cell Appearance-125-ab.jpg|left|145px]][[File:Cell Appearance-125-bb.jpg|right|145px]]
|Use AOO Icon to replace Symphony Icon in control on sidebar.
|-
!12 Wrap
|[[File:Wrap-DE-132-aa.jpg]]
|no need
|no need
|no need
|
|-
!13 Table Design
|no need
|no need
|[[File:Table Design-PE-144-aa.jpg]]
|no need
|
|}

== Controls consistent issues proposal ==
We should pursue the same behavior for the same control in one software, if we choose the Symphony behavior, we should apply it to all areas, such as toolbar, property dialog... At least we need to keep the first level UI elements on controls of sidebar and toolbar consistent for 4.0. 
Summarize all 13 controls that will show both on sidebar and toolbar and give the design proposal. 

{| class="wikitable" style="background-color:#ffffff;"
|-
! Panel
! Control
! Sidebar(4.0 Design Proposal)
! Toolbar(3.4.1)
! Toolbar(4.0 Design Proposal)
! Note
|-
! rowspan=3|Text
| 1. Font Color
| [[File:Text-23-S4.0.jpg]]
| [[File:Text-24-T3.4.1.jpg]]
| [[File:Text-25-T4.0.jpg]]
| Change the color panel arrange layout from 10*10 to 8*13 to make the similar colors in one row.
|-
| 2. Highlight Color
| [[File:Text-33-S4.0.jpg]]
| [[File:Text-34-T3.4.1.jpg]]
| [[File:Text-35-T4.0.jpg]]
| Change the color panel arrange layout from 10*10 to 8*13 to make the similar colors in one row.
|-
| 3. Underline
| [[File:Text-43-S4.0.jpg]]
| [[File:Text-44-T3.4.1.jpg]]
| [[File:Text-44-T3.4.1.jpg]]
|
|-
! rowspan=4|Paragraph
| 4. Bullets
| [[File:Paragraph-53-S4.0.jpg]]
| [[File:Paragraph-54-T3.4.1.jpg]]
| [[File:Paragraph-54-T3.4.1.jpg]]
| Use AOO icon to replace Symphony icon on Sidebar.
|-
| 5. Numbering
| [[File:Paragraph-63-S4.0.jpg]]
| [[File:Paragraph-64-T3.4.1.jpg]]
| [[File:Paragraph-64-T3.4.1.jpg]]
| Use AOO icon to replace Symphony icon on Sidebar.
|-
| 6. Paragraph Background Color
| [[File:Paragraph-73-S4.0.jpg]]
| [[File:Paragraph-74-T3.4.1.jpg]]
| [[File:Paragraph-75-T4.0.jpg]]
| Change the color panel arrange layout from 10*10 to 8*13 to make the similar colors in one row.
|-
| 7. Line Spacing
| [[File:Paragraph-83-S4.0.jpg]]
| [[File:Paragraph-84-T3.4.1.jpg]]
| [[File:Paragraph-85-T4.0.jpg]]
| Use Symphony icons to replace corresponding AOO icons on toolbar.
|-
! rowspan=3|Line
| 8. Width
| [[File:Line-93-S4.0.jpg]]
| [[File:Line-94-T3.4.1.jpg]]
| [[File:Line-95-T4.0.jpg]]
| Make the control on toolbar consistent with sidebar.
|-
| 9. Color
| [[File:Line-103-S4.0.jpg]]
| [[File:Line-104-T3.4.1.jpg]]
| [[File:Line-105-T4.0.jpg]]
| Change the color list to 8*13 to make the similar colors in one row.
|-
| 10. Style
| [[File:Line-113-S4.0.jpg]]
| [[File:Line-114-T3.4.1.jpg]]
| [[File:Line-115-T4.0.jpg]]
| Make the control on toolbar consistent with sidebar.
|-
! rowspan=2|Area
| 11. Fill Type
| [[File:Area-123-S4.0.jpg]]
| [[File:Area-124-T3.4.1.jpg]]
| [[File:Area-125-T4.0.jpg]]
| Use "None" replace "Invisible"."None" is easier to understand for user.But the changing string maybe cause other issues,e.g. ACC and so on.Need to discuss.
|-
| 12. Color
| [[File:Area-133-S4.0.jpg]]
| [[File:Area-134-T3.4.1.jpg]]
| [[File:Area-135-T4.0.jpg]]
| Change the color list to 8*13 to make the similar colors in one row.Use AOO icon to replace Symphony icon.
|-
! Graphic
| 13. Graphic-Color mode
| [[File:Graphic-143-S4.0.jpg]]
| [[File:Graphic-144-T3.4.1.jpg]]
| [[File:Graphic-145-T4.0.jpg]]
| Make the control on sidebar consistent with toolbar.
|}

[[Category:UX]]
[[Category:Visual Design]]

AODL features

2019-01-04T16:06:48Z

Adailton: +cat

{{wkf}}
{{revision}}

'''AODL features list'''

<ul>
<li> Reading, editing, creating and saving documents in the OpenDocument text format (TextDocument class).</li>
<li> Reading, editing, creating and saving documents in the OpenDocument spreadsheet format (SpreadsheetDocument class).</li>
<li> ParagraphBuilder class, this class offer several methods for the creation of often used Paragraphs types.</li>
<li> TableBuilder class, this class offer several methods for the creation of often used Table types.</li>
<li> TextBuilder class, this class offer several methods for the simple creation of ITextCollections that will be used within a Paragraph.</li>
<li> SizeConverter class, this class offer size conversation and size type conversation methods for height and width properties of AODL OpenDocument objects.</li>
<li> Colors class, this class offer the possibility to convert any .net system color to the corresponding color used in any document in the OpenDocument format.</li>
<li> Support for common styles. These are e.g used by OpenOffice as style templates.</li>
<li> Reading and writing of the documents metadata.</li>
<li> Full Paragraph support incl. Paragraphstyle and Paragraphproperties.</li>
<li> Full Header support incl. Headerstyle and Proeperties.</li>
<li> List support (number and bullet) support incl. Liststyle and Listproperties.</li>
<li> Full Table of Contents support incl. Sectionstyles.</li>
<li> Full Table support with nested table up to any depth and cellmerging support.</li>
- Full support for Rows incl. Rowstyle and Rowproperties.
- Full support for Columns incl. Columnstyle and Columnproperties.
- Full support for Cells incl. Cellstyle and Cellproperties.
<li> Text support incl. Textstyle and textproperties.</li>
- Simple Text
- Formated text
- Footnotes and Endnotes
<li> Textcontrol Whitespaces, Tabstops and Linebreaks.</li>
<li> XLink support (Hyperlinks for www, email, ftp,.. ).</li>
<li> Full Bookmark support (Standard, End and Start).</li>
<li> Graphic support, graphics could be used as simple embed graphic or as a Illustration with a sorounding DrawTextBox.</li>
<li> Drawframe support. The draw frame is the standard container object for draw objects and graphics. Incl. Graphicstyle and Graphicproperties.</li>
<li> Imagemap support with DrawAreaRectangle and DrawAreaCircle.</li>
<li> DrawTextBox support.</li>
<li> Officescripts support. Office scripts could be used within a image map.</li>
<li> Deep cloning of AODL content objects. Deep clones from most of the IContent implementations like Tables, Paragraphs could be simply created by calling the clone method.</li>
<li> The Unknown content pattern. The unknown content implementation is available for Styles, Content and Text. All content that will be read from a OpenDocument file which isn't implemented yet will be mapped to a UnknownContent, UnknownTextContent resp. a UknownStyle object. All these implementation has a public property Node which made it easy to analyze the OpenDocument format inside. At least this solution make it possible to load and write files back without loosing any style or content information.</li>
<li> OpenDocument Importer interface. This interface let you easily writing your own importer implementations. Existing standard implementation of IImporter</li>
- PlainTextImporter (TextDocument only)
- CsvImporter (SpreadsheetDocument only)
- OpenDocumentImporter all document types.
<li> OpenDocument Exporter interface. This interface let you easily writing your own exporter implementations. Existing standard implementation of IExporter</li>
- OpenDocumentExporter all document types.
- HtmlExporter all document types.
- PDF export for text documents (early beta and TextDocument only)
<li> Helper class LinesStyles (possible Linestyles), Border (possible Border) and FontFamilies (about 100 fonts).</li>
<li> Print documents via the included OpenOfficeLib (This is feature is embed in seperate dll and is the only feature which need an existing OpenOffice installation.)</li>
<li> Master style pages support</li>
<li> Office forms support</li>
<li> Fields support</li>
</ul>
[[category:Summer of Code 2007]][[category:AODL]]

Revision

2019-01-04T14:54:05Z

Adailton: Created page with "{|border=1 style="background-color:inherit!important; text-align:center" celpadding=0 cellspacing=0 |- |English |Older pages, with no review for more than a year, may be outda..."

{|border=1 style="background-color:inherit!important; text-align:center" celpadding=0 cellspacing=0
|-
|English
|Older pages, with no review for more than a year, may be outdated. Consider the guidelines in [[Wiki Contribution Guidelines]] and others [[:Category:Guidelines|guides]] to edit pages;
|-
|Português
|Páginas antigas, sem revisão a mais de um ano, podem estar com conteúdo desatualizados. Considere as orientações em [[Wiki Contribution Guidelines]] e outros [[:Category:Guidelines|guias]] para editar as páginas;
|-
|Deutsch
|Ältere Seiten, die seit mehr als einem Jahr nicht bewertet wurden, sind möglicherweise veraltet. Beachten Sie die Richtlinien in [[Wiki Contribution Guidelines]] und anderen [[:Category:Guidelines|Guides]], Seiten zu bearbeiten;
|-
|Français
|Les pages les plus anciennes, sans révision depuis plus d'un an, peuvent être obsolètes. Considérez les lignes directrices dans [[Wiki Contribution Guidelines|Lignes directrices concernant les contributions au wiki]] et dans d'autres [[:Category:Guidelines|guides]] pour modifier des pages;
|-
|italiano
|Le pagine precedenti, senza revisione per più di un anno, potrebbero essere obsolete. Considera le linee guida in [[Wiki Contribution Guidelines|Linee guida per il contributo Wiki]] e altre [[:Category:Guidelines|guide]] per modificare le pagine;
|-
|Русский
|Старые страницы без рецензирования более года могут быть устаревшими. Изучите инструкции в [[Wiki Contribution Guidelines|Руководства по вики-публикации]] и другие [[:Category:Guidelines|руководства]] по редактированию страниц.
|}

[[Category:Outdated]]
[[Category:Education]]
[[Category:Development]]

2 0 1 regression review

2019-01-04T14:24:23Z

Adailton: +revision

{{revision}}

[[Category:Quality Assurance]]

This page is a snapshot of issues that have already been reported against 2.0.1RC's.
It should be used to identify regressions, that have been introduced between 2.0.0 and 2.0.1.

Please pick an issue, try to verify with 2.0.0 and 2.0.1. If it only exists in 2.0.1, add the regression keyword to the issue. If not, leave the issue as it is or handle it according to the QA project's [http://qa.openoffice.org/helping.html guidelines for help].

In any case, add a sign here, that you have reviewed the issue. (E.g my reviews are tagged with "sca" at the beginning of a line)
----
sca = Andre Schnabel,
regina = Regina Henschel,
khirano = Kazunari Hirano,
andreas = Andreas Mantke,
jrahemipour = Jacqueline Rahemipour,
BeDipp = Bernhard Dippold (- = no regression / + = regression),
timar = Andras Timar

----
{| border="0"
!width="950"|Issue list (104 issues found)
|-
|Sun Dec 11 13:45:53 -0800 2005
|}

{| border="1" cellpadding="2"
!width="50"|Name / comment
!width="900"|ID Type Pri Plt Owner State Result Summary
|-
|khirano (regression)
|59272 DEFECT P3 All as NEW database forms are automatically replaced when another text document is loaded
|-
|sca
|59185 DEFECT P1 All mru NEW Regular expressions search replace may result in severe data
|-
|khirano
|58517 DEFECT P2 All af STAR Impress crashes on document open with gtk plug
|-
|
|58524 DEFECT P2 Maci openstep UNCO SAMBA i/O error in saving doc
|-
|sca
|58769 DEFECT P2 All af STAR crash in close the document after I add and delete a master
|-
|sca
| 58845 DEFECT P2 All of REOP User cannot start OOo after updating from 2.0.0 to 2.0.1
|-
|andreas
| 59037 DEFECT P2 PC iano NEW [DE] Indexing for help texts completely messed up and mixed
|-
|sca
| 59168 DEFECT P2 All mru NEW RTF file crashes OOo
|-
|khirano
| 47377 DEFECT P3 All ja NEW Crash on Crash Report.
|-
|sca
|58527 DEFECT P3 PC jsk NEW problem with templates and macros in post-2.0 versions
|-
|sca
| 58531 DEFECT P3 All issues@lingucomponent UNCO make dictionary etc. engine-specific to allow multiple engin
|-
|sca
|58557 DEFECT P3 PC mru NEW Word Import: Word elements imported incorrectly
|-
|timar
|58558 DEFECT P3 All nemeth STAR OOo's hyphenator doesn't handle alternations at hyphenation
|-
|
|58561 DEFECT P3 PC tm NEW some Applications tooltips in Start menu grammatically wrong
|-
|sca
| 58562 DEFECT P3 PC sj NEW Numbering messed up when opening MS PowerPoint document
|-
|sca
| 58573 DEFECT P3 All os NEW untranslated string
|-
|sca
| 58594 DEFECT P3 All mru NEW Word Import: frames positioned incorrectly
|-
|sca
| 58597 DEFECT P3 All mru UNCO Table filelds not displaying or calculating properly
|-
|andreas
| 58607 DEFECT P3 All sba UNCO Outline Numbering 'show sublevel' not reflect ParentNumberin
|-
|sca
| 58613 DEFECT P3 PC sj NEW PPT export bug
|-
|sca
| 58614 DEFECT P3 PC mru UNCO Word document margin error
|-
|sca
|58644 DEFECT P3 PC cl NEW can not delete all text of rectangle with custom animation
|-
|sca
| 58645 DEFECT P3 PC od NEW Text of numbered list with numtype "none" not displaying
|-
|
|58646 DEFECT P3 All cn UNCO xTableRows insertByIndex() method fails inserting new row to
|-
|sca
|58648 DEFECT P3 All flr NEW RTF: landscape pages after continuous section break are inco
|-
|
|58653 DEFECT P3 All thb NEW Dim with color did not work for bitmap shape
|-
|andreas (same in 2.0.0)
| 58702 DEFECT P3 PC thb NEW non-tiled background bitmap tiled in slideshow
|-
|andreas (regress)
|58707 DEFECT P3 All af NEW hide slide ico invisible beside hide slide
|-
|khirano
| 58712 DEFECT P3 PC cl NEW Saved Impress file lose Image Map
|-
|andreas (not relevant for Linux)
| 58750 DEFECT P3 Maci ericb NEW Capslock doesn't work correctly
|-
|sca
|58758 DEFECT P3 All tm NEW stylist and navigator window states not restored
|-
|andreas(Linux not infected; 2.0.0 and 2.0.1RC4 Win no defect)
| 58763 DEFECT P3 PC es UNCO subject meta tag corrupted for html file
|-
|
|58776 DEFECT P3 All od NEW Removing a paragraph via backspace needs backspace for delet
|-
|
|58777 DEFECT P3 All od NEW Deleting an outline paragraph via backspace does not work wh
|-
|
|58817 DEFECT P3 PC cmc NEW configure should use with-system-stdlibs by default when /et
|-
|
|58831 DEFECT P3 All sba UNCO Wrong key assignement for OOo ES
|-
|
|58843 DEFECT P3 PC mru UNCO Word Export: borders of frames not exported correctly
|-
|sca
|58847 DEFECT P3 All is NEW Previous (2.0.0) Version not found
|-
|
|58851 DEFECT P3 All issues@lingucomponent NEW DicOOo fails to update
|-
|BeDipp-
|58858 DEFECT P3 All fme NEW Table borders not correct if table wraps to next page
|-
|
|58866 DEFECT P3 All msc UNCO XForm binding expression not re-evaluated on namespace chang
|-
|
|58886 DEFECT P3 All iano NEW Placeholder for tablename in hungarian version still present
|-
|khirano
| 58888 DEFECT P3 All cgu NEW export .ppt as .odp changing line spacing
|-
|
|58904 DEFECT P3 All od NEW WW8: loop on formatting frames and redlines in RTL context
|-
|khirano
|58910 DEFECT P3 All mh NEW Please, Allow Concurrent Running Of OOo Builds
|-
|
|58919 DEFECT P3 All os UNCO Black Pages in Mail Merge
|-
|BeDipp-
|58930 DEFECT P3 All af NEW Find & Replace Dialog: "Current selection only" is always di
|-
|
|58981 DEFECT P3 All flr NEW WW8: Table-of-contents Link style has wrong size
|-
|khirano BeDipp-
|58999 DEFECT P3 All cl UNCO align does not work for Vertical text
|-
|BeDipp-
|59001 DEFECT P3 All thb NEW Some "Font Effects" is bad when slide show
|-
|sca
|59006 DEFECT P3 All tm UNCO can't open the odt on double click the file ico in browse
|-
|sca
| 59007 DEFECT P3 All tm NEW "Edit file" menubutton is invalid
|-
|BeDipp-
|59025 DEFECT P3 PC hbrinkm NEW UNDO for insert frame moves cursor position to top of docume
|-
|
|59026 DEFECT P3 All sb STAR crash on desktop terminate() through PyUNO
|-
|jrahemipour
|59030 DEFECT P3 All sba UNCO Spelling: change all does not work when typing custom sugges
|-
|
|59033 DEFECT P3 All tl NEW PageStyleName is read-only
|-
|sca
|59047 DEFECT P3 PC ab NEW Macros in a new document based on a template did not work
|-
|BeDipp-
|59048 DEFECT P3 All dbaneedsconfirm NEW Can not delete Base document
|-
|BeDipp-
|59051 DEFECT P3 All od NEW dimension arrows in a group from Oo.o draw pasted into Write
|-
|
|59059 DEFECT P3 All es NEW Drop Cap Style Setting Not Saved?
|-
|jrahemipour
|59060 DEFECT P3 All sba UNCO word count does not include Bullet and Numbering character
|-
|BeDipp-
|59061 DEFECT P3 All cl NEW move up/down does not work well in Outline View when select
|-
|
|59073 DEFECT P3 All iano NEW [DE] Wrong Description for Symbolleisten Schaltflächen hinz
|-
|
|59084 DEFECT P3 PC dbaneedsconfirm UNCO Cannot connect to Outlook Addresses
|-
|
|59086 DEFECT P3 PC dbaneedsconfirm UNCO OOo2.0.x shows "Persö?liches Adre?buch" instead of "Persön
|-
|
|59088 DEFECT P3 All od NEW WW8: sometime outline numbers not displayed though styles co
|-
|andreas (2.0.0 hängt; 2.0.1 öffnet mit 2 Bestätigungdialogen)
|59089 DEFECT P3 PC jsk NEW The warning dialog titled "Security Warning" is always opene
|-
|
|59097 DEFECT P3 PC es UNCO Undo Menu strings with non-Ascii characters broken
|-
|khirano
|59104 DEFECT P3 PC cgu UNCO Displaying Powerpoint files is really really slow
|-
|BeDipp-
|59105 DEFECT P3 PC spreadsheet NEW undo inserted picture, the context menu is incorrect!
|-
|BeDipp-
|59107 DEFECT P3 PC spreadsheet NEW 2 foci after minimizing and maximizing a second spreadsheet
|-
|khirano
|59110 DEFECT P3 PC kla NEW 2 pages of chart wizard appear
|-
|dridgway-
|59112 DEFECT P3 PC spreadsheet NEW Off-by-one calculation int() and floor() with large inputs
|-
|
|59121 DEFECT P3 All iano UNCO Kontrollelemente instead of Kontrollfelder
|-
|
|59124 DEFECT P3 All iano UNCO [DE] English text in German Help
|-
|
|59134 DEFECT P3 All od NEW Outline Numbering Starts with 2 Instead of 1
|-
|khirano
|59137 DEFECT P3 All pb NEW Template dialog closes silently when trying to edit template
|-
|
|59140 DEFECT P3 All iano NEW [DE] English text in German Help for property of floating fr
|-
|sca
|59144 DEFECT P3 All flr NEW Regression: rtf document can not be opend
|-
|jrahemipour
|59152 DEFECT P3 PC iano NEW [DE] English text in German help for CALC under heading "For
|-
|jrahemipour
|59155 DEFECT P3 PC of NEW association for MS Office extension do not work during setup
|-
|andreas (Regression, kein Stopper)
|59169 DEFECT P3 All mru NEW wmf picture show incorrectly
|-
|
|59170 DEFECT P3 All iano UNCO NL: Help - Format of help page is mixed up.
|-
|scan
|59171 DEFECT P3 All of NEW Shared configuration lost during update
|-
|sca
|59173 DEFECT P3 All wg NEW Color bar colors disappear after editing OLE object
|-
|jrahemipour
|59174 DEFECT P3 All iano UNCO NL: GUI - String doesn't fit in dialog
|-
|jrahemipour
|59175 DEFECT P3 All iano UNCO NL: GUI - Double and untranslated strings in controls toolba
|-
|jrahemipour
|59186 DEFECT P3 PC sba NEW Wrong description in part "Add Commands" of customize toolba
|-
|sca
|59188 DEFECT P3 PC sba NEW File dialog in OOo 2.01 RC4
|-
|jrahemipour
|59190 DEFECT P3 All sba NEW Empty toolbar appears after installation of 2.0.1 RC4
|-
|regina
|59194 DEFECT P3 PC iano UNCO [DE] English texts in help "Symbolleisten"
|-
|jrahemipour
|59203 DEFECT P3 PC iano NEW [DE] typos in German help for IMPRESS under heading "Funktio
|-
|BeDipp+
|59204 DEFECT P3 All dbaneedsconfirm UNCO Report Wizard: Columns using reserved words like table
|-
|andreas (italienischer Hilfedialog; soll behoben sein)
|59208 DEFECT P3 PC iano UNCO IT: OOO_VENDOR occurs unresolved in About -> Config
|-
|dridgway looks like RFE
|59211 DEFECT P3 All dbaneedsconfirm UNCO Query design does not support concatenation
|-
|jrahemipour
|59212 DEFECT P3 All mru NEW Rectangles instead of bullets in standard bullet list
|-
|jrahemipour
|59213 DEFECT P3 PC mru NEW bullet and numbering buttons are not shown pressed anymore
|-
|sca
|47781 DEFECT P4 PC sba REOP inconsistent behaviour in formatting after autoformat
|-
|jrahemipour
|58638 DEFECT P4 PC dbaneedsconfirm NEW garbage content around form
|-
|sca
|58699 DEFECT P4 PC es NEW Updated field code after print doesn't trigger a save
|-
|jrahemipour
|58848 DEFECT P4 PC jsk UNCO macros executable in read-only documents
|-
|khirano
|59017 DEFECT P4 All sba UNCO Regression of i39036: bmp icons with png name
|-
|jrahemipour
|59159 DEFECT P4 PC sba UNCO [DE] inkonsistent translations for "toolbox" in Basic Dialog
|-
|jrahemipour
|58633 DEFECT P5 PC fs STAR Form Design toolbar icons state inconsistent
|-
|jrahemipour
|58867 DEFECT P5 All od NEW note visually appears twice numbered paragraph
|-
|
|

|}

Template:Revision

2019-01-04T14:22:50Z

Adailton: Created page with "<div style="border:thin solid blue;float:left; padding:3pt; background-color: #ebd0d0; margin-top: 10pt; margin-bottom: 10pt;"> {|border=0 style="background-color:inherit!impo..."

<div style="border:thin solid blue;float:left; padding:3pt; background-color: #ebd0d0; margin-top: 10pt; margin-bottom: 10pt;">
{|border=0 style="background-color:inherit!important; text-align:center" celpadding=0 cellspacing=0
|-
|[[File:Edit-find-replace.png|42px]]
|'''
'''[[revision|{{#switch:{{{1}}}
| RU = Эта страница требует пересмотра
| UA = Ця сторінка потребує перегляду
| EN = This page needs revision
| PT = Esta página necessita revisão
| FR = Cette page a besoin d'être révisée
| IT = Questa pagina ha bisogno di revisione
| DE = Diese Seite muss überarbeitet werden
| #default = This page needs revision
}}]]'''

|}
</div><includeonly>
[[Category:Outdated]]
[[Category:{{{1|EN}}}]]
</includeonly><noinclude>
[[Category:Templates]]
</noinclude>

Template:SeeAlso

2019-01-04T13:46:45Z

Adailton:

<noinclude>{{doc}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
<includeonly>
---------------- '''{{#switch:{{{1}}}
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}''' 
{{{2|}}}

</includeonly>

Category:Outdated

2019-01-04T13:43:33Z

Adailton:

*{{category|classify old contents that need to be revised}};
* Esta [[Special:Categories|categoria]] classificar os conteúdos antigos que precisam ser revisados;

* Diese [[Special:Categories|Kategorie]] alte Inhalte einordnen, die überarbeitet werden müssen;
* Cette [[Special:Categories|catégorie]] classer les anciens contenus à réviser;
* Questa [[Special:Categories|categoria]] classificare vecchi contenuti che devono essere rivisti;
* Данная [[Special:Categories|категория]] классифицировать старое содержание которое необходимо пересмотреть.

:en: Outdated are all pages from OOo old wiki content. This category was created in order to classify old contents that need to be revised;
:pt: Desatualizados são todas as páginas do conteúdo antigo do wiki. Esta categoria foi criada para classificar os conteúdos antigos que precisam ser revisados;
:de: Veraltet sind alle Seiten aus dem alten Wiki-Inhalt von OOo. Diese Kategorie wurde erstellt, um alte Inhalte zu klassifizieren, die überarbeitet werden müssen;
:fr: Sont pas à jour toutes les pages de OOo ancien contenu du wiki. Cette catégorie a été créée afin de classer les anciens contenus devant être révisés;
:it: Sono obsolete tutte le pagine di OOo vecchio contenuto del wiki. Questa categoria è stata creata per classificare vecchi contenuti che devono essere rivisti;
:ru: Устаревшие все страницы из OOo старого содержимого вики. Эта категория была создана для того, чтобы классифицировать старое содержимое, которое необходимо пересмотреть.

[[Category:Development]]

2 0 1 regression review

2019-01-04T13:20:22Z

Adailton: +cat

{{Old|EN}}
[[Category:Quality Assurance]]
This page is a snapshot of issues that have already been reported against 2.0.1RC's.
It should be used to identify regressions, that have been introduced between 2.0.0 and 2.0.1.

Please pick an issue, try to verify with 2.0.0 and 2.0.1. If it only exists in 2.0.1, add the regression keyword to the issue. If not, leave the issue as it is or handle it according to the QA project's [http://qa.openoffice.org/helping.html guidelines for help].

In any case, add a sign here, that you have reviewed the issue. (E.g my reviews are tagged with "sca" at the beginning of a line)
----
sca = Andre Schnabel,
regina = Regina Henschel,
khirano = Kazunari Hirano,
andreas = Andreas Mantke,
jrahemipour = Jacqueline Rahemipour,
BeDipp = Bernhard Dippold (- = no regression / + = regression),
timar = Andras Timar

----
{| border="0"
!width="950"|Issue list (104 issues found)
|-
|Sun Dec 11 13:45:53 -0800 2005
|}

{| border="1" cellpadding="2"
!width="50"|Name / comment
!width="900"|ID Type Pri Plt Owner State Result Summary
|-
|khirano (regression)
|59272 DEFECT P3 All as NEW database forms are automatically replaced when another text document is loaded
|-
|sca
|59185 DEFECT P1 All mru NEW Regular expressions search replace may result in severe data
|-
|khirano
|58517 DEFECT P2 All af STAR Impress crashes on document open with gtk plug
|-
|
|58524 DEFECT P2 Maci openstep UNCO SAMBA i/O error in saving doc
|-
|sca
|58769 DEFECT P2 All af STAR crash in close the document after I add and delete a master
|-
|sca
| 58845 DEFECT P2 All of REOP User cannot start OOo after updating from 2.0.0 to 2.0.1
|-
|andreas
| 59037 DEFECT P2 PC iano NEW [DE] Indexing for help texts completely messed up and mixed
|-
|sca
| 59168 DEFECT P2 All mru NEW RTF file crashes OOo
|-
|khirano
| 47377 DEFECT P3 All ja NEW Crash on Crash Report.
|-
|sca
|58527 DEFECT P3 PC jsk NEW problem with templates and macros in post-2.0 versions
|-
|sca
| 58531 DEFECT P3 All issues@lingucomponent UNCO make dictionary etc. engine-specific to allow multiple engin
|-
|sca
|58557 DEFECT P3 PC mru NEW Word Import: Word elements imported incorrectly
|-
|timar
|58558 DEFECT P3 All nemeth STAR OOo's hyphenator doesn't handle alternations at hyphenation
|-
|
|58561 DEFECT P3 PC tm NEW some Applications tooltips in Start menu grammatically wrong
|-
|sca
| 58562 DEFECT P3 PC sj NEW Numbering messed up when opening MS PowerPoint document
|-
|sca
| 58573 DEFECT P3 All os NEW untranslated string
|-
|sca
| 58594 DEFECT P3 All mru NEW Word Import: frames positioned incorrectly
|-
|sca
| 58597 DEFECT P3 All mru UNCO Table filelds not displaying or calculating properly
|-
|andreas
| 58607 DEFECT P3 All sba UNCO Outline Numbering 'show sublevel' not reflect ParentNumberin
|-
|sca
| 58613 DEFECT P3 PC sj NEW PPT export bug
|-
|sca
| 58614 DEFECT P3 PC mru UNCO Word document margin error
|-
|sca
|58644 DEFECT P3 PC cl NEW can not delete all text of rectangle with custom animation
|-
|sca
| 58645 DEFECT P3 PC od NEW Text of numbered list with numtype "none" not displaying
|-
|
|58646 DEFECT P3 All cn UNCO xTableRows insertByIndex() method fails inserting new row to
|-
|sca
|58648 DEFECT P3 All flr NEW RTF: landscape pages after continuous section break are inco
|-
|
|58653 DEFECT P3 All thb NEW Dim with color did not work for bitmap shape
|-
|andreas (same in 2.0.0)
| 58702 DEFECT P3 PC thb NEW non-tiled background bitmap tiled in slideshow
|-
|andreas (regress)
|58707 DEFECT P3 All af NEW hide slide ico invisible beside hide slide
|-
|khirano
| 58712 DEFECT P3 PC cl NEW Saved Impress file lose Image Map
|-
|andreas (not relevant for Linux)
| 58750 DEFECT P3 Maci ericb NEW Capslock doesn't work correctly
|-
|sca
|58758 DEFECT P3 All tm NEW stylist and navigator window states not restored
|-
|andreas(Linux not infected; 2.0.0 and 2.0.1RC4 Win no defect)
| 58763 DEFECT P3 PC es UNCO subject meta tag corrupted for html file
|-
|
|58776 DEFECT P3 All od NEW Removing a paragraph via backspace needs backspace for delet
|-
|
|58777 DEFECT P3 All od NEW Deleting an outline paragraph via backspace does not work wh
|-
|
|58817 DEFECT P3 PC cmc NEW configure should use with-system-stdlibs by default when /et
|-
|
|58831 DEFECT P3 All sba UNCO Wrong key assignement for OOo ES
|-
|
|58843 DEFECT P3 PC mru UNCO Word Export: borders of frames not exported correctly
|-
|sca
|58847 DEFECT P3 All is NEW Previous (2.0.0) Version not found
|-
|
|58851 DEFECT P3 All issues@lingucomponent NEW DicOOo fails to update
|-
|BeDipp-
|58858 DEFECT P3 All fme NEW Table borders not correct if table wraps to next page
|-
|
|58866 DEFECT P3 All msc UNCO XForm binding expression not re-evaluated on namespace chang
|-
|
|58886 DEFECT P3 All iano NEW Placeholder for tablename in hungarian version still present
|-
|khirano
| 58888 DEFECT P3 All cgu NEW export .ppt as .odp changing line spacing
|-
|
|58904 DEFECT P3 All od NEW WW8: loop on formatting frames and redlines in RTL context
|-
|khirano
|58910 DEFECT P3 All mh NEW Please, Allow Concurrent Running Of OOo Builds
|-
|
|58919 DEFECT P3 All os UNCO Black Pages in Mail Merge
|-
|BeDipp-
|58930 DEFECT P3 All af NEW Find & Replace Dialog: "Current selection only" is always di
|-
|
|58981 DEFECT P3 All flr NEW WW8: Table-of-contents Link style has wrong size
|-
|khirano BeDipp-
|58999 DEFECT P3 All cl UNCO align does not work for Vertical text
|-
|BeDipp-
|59001 DEFECT P3 All thb NEW Some "Font Effects" is bad when slide show
|-
|sca
|59006 DEFECT P3 All tm UNCO can't open the odt on double click the file ico in browse
|-
|sca
| 59007 DEFECT P3 All tm NEW "Edit file" menubutton is invalid
|-
|BeDipp-
|59025 DEFECT P3 PC hbrinkm NEW UNDO for insert frame moves cursor position to top of docume
|-
|
|59026 DEFECT P3 All sb STAR crash on desktop terminate() through PyUNO
|-
|jrahemipour
|59030 DEFECT P3 All sba UNCO Spelling: change all does not work when typing custom sugges
|-
|
|59033 DEFECT P3 All tl NEW PageStyleName is read-only
|-
|sca
|59047 DEFECT P3 PC ab NEW Macros in a new document based on a template did not work
|-
|BeDipp-
|59048 DEFECT P3 All dbaneedsconfirm NEW Can not delete Base document
|-
|BeDipp-
|59051 DEFECT P3 All od NEW dimension arrows in a group from Oo.o draw pasted into Write
|-
|
|59059 DEFECT P3 All es NEW Drop Cap Style Setting Not Saved?
|-
|jrahemipour
|59060 DEFECT P3 All sba UNCO word count does not include Bullet and Numbering character
|-
|BeDipp-
|59061 DEFECT P3 All cl NEW move up/down does not work well in Outline View when select
|-
|
|59073 DEFECT P3 All iano NEW [DE] Wrong Description for Symbolleisten Schaltflächen hinz
|-
|
|59084 DEFECT P3 PC dbaneedsconfirm UNCO Cannot connect to Outlook Addresses
|-
|
|59086 DEFECT P3 PC dbaneedsconfirm UNCO OOo2.0.x shows "Persö?liches Adre?buch" instead of "Persön
|-
|
|59088 DEFECT P3 All od NEW WW8: sometime outline numbers not displayed though styles co
|-
|andreas (2.0.0 hängt; 2.0.1 öffnet mit 2 Bestätigungdialogen)
|59089 DEFECT P3 PC jsk NEW The warning dialog titled "Security Warning" is always opene
|-
|
|59097 DEFECT P3 PC es UNCO Undo Menu strings with non-Ascii characters broken
|-
|khirano
|59104 DEFECT P3 PC cgu UNCO Displaying Powerpoint files is really really slow
|-
|BeDipp-
|59105 DEFECT P3 PC spreadsheet NEW undo inserted picture, the context menu is incorrect!
|-
|BeDipp-
|59107 DEFECT P3 PC spreadsheet NEW 2 foci after minimizing and maximizing a second spreadsheet
|-
|khirano
|59110 DEFECT P3 PC kla NEW 2 pages of chart wizard appear
|-
|dridgway-
|59112 DEFECT P3 PC spreadsheet NEW Off-by-one calculation int() and floor() with large inputs
|-
|
|59121 DEFECT P3 All iano UNCO Kontrollelemente instead of Kontrollfelder
|-
|
|59124 DEFECT P3 All iano UNCO [DE] English text in German Help
|-
|
|59134 DEFECT P3 All od NEW Outline Numbering Starts with 2 Instead of 1
|-
|khirano
|59137 DEFECT P3 All pb NEW Template dialog closes silently when trying to edit template
|-
|
|59140 DEFECT P3 All iano NEW [DE] English text in German Help for property of floating fr
|-
|sca
|59144 DEFECT P3 All flr NEW Regression: rtf document can not be opend
|-
|jrahemipour
|59152 DEFECT P3 PC iano NEW [DE] English text in German help for CALC under heading "For
|-
|jrahemipour
|59155 DEFECT P3 PC of NEW association for MS Office extension do not work during setup
|-
|andreas (Regression, kein Stopper)
|59169 DEFECT P3 All mru NEW wmf picture show incorrectly
|-
|
|59170 DEFECT P3 All iano UNCO NL: Help - Format of help page is mixed up.
|-
|scan
|59171 DEFECT P3 All of NEW Shared configuration lost during update
|-
|sca
|59173 DEFECT P3 All wg NEW Color bar colors disappear after editing OLE object
|-
|jrahemipour
|59174 DEFECT P3 All iano UNCO NL: GUI - String doesn't fit in dialog
|-
|jrahemipour
|59175 DEFECT P3 All iano UNCO NL: GUI - Double and untranslated strings in controls toolba
|-
|jrahemipour
|59186 DEFECT P3 PC sba NEW Wrong description in part "Add Commands" of customize toolba
|-
|sca
|59188 DEFECT P3 PC sba NEW File dialog in OOo 2.01 RC4
|-
|jrahemipour
|59190 DEFECT P3 All sba NEW Empty toolbar appears after installation of 2.0.1 RC4
|-
|regina
|59194 DEFECT P3 PC iano UNCO [DE] English texts in help "Symbolleisten"
|-
|jrahemipour
|59203 DEFECT P3 PC iano NEW [DE] typos in German help for IMPRESS under heading "Funktio
|-
|BeDipp+
|59204 DEFECT P3 All dbaneedsconfirm UNCO Report Wizard: Columns using reserved words like table
|-
|andreas (italienischer Hilfedialog; soll behoben sein)
|59208 DEFECT P3 PC iano UNCO IT: OOO_VENDOR occurs unresolved in About -> Config
|-
|dridgway looks like RFE
|59211 DEFECT P3 All dbaneedsconfirm UNCO Query design does not support concatenation
|-
|jrahemipour
|59212 DEFECT P3 All mru NEW Rectangles instead of bullets in standard bullet list
|-
|jrahemipour
|59213 DEFECT P3 PC mru NEW bullet and numbering buttons are not shown pressed anymore
|-
|sca
|47781 DEFECT P4 PC sba REOP inconsistent behaviour in formatting after autoformat
|-
|jrahemipour
|58638 DEFECT P4 PC dbaneedsconfirm NEW garbage content around form
|-
|sca
|58699 DEFECT P4 PC es NEW Updated field code after print doesn't trigger a save
|-
|jrahemipour
|58848 DEFECT P4 PC jsk UNCO macros executable in read-only documents
|-
|khirano
|59017 DEFECT P4 All sba UNCO Regression of i39036: bmp icons with png name
|-
|jrahemipour
|59159 DEFECT P4 PC sba UNCO [DE] inkonsistent translations for "toolbox" in Basic Dialog
|-
|jrahemipour
|58633 DEFECT P5 PC fs STAR Form Design toolbar icons state inconsistent
|-
|jrahemipour
|58867 DEFECT P5 All od NEW note visually appears twice numbered paragraph
|-
|
|

|}

Category:Older articles PT

2019-01-04T13:19:56Z

Adailton:

*{{category|older articles that need to be revised.}};
* Esta [[Special:Categories|categoria]] contém artigos antigos que necessitam ser revisados;

[[Category:Older_articles]]
[[Category:PT]]

Category:Older articles

2019-01-04T13:19:21Z

Adailton: +cat

*{{category|older articles that need to be revised.}};
* Esta [[Special:Categories|categoria]] contém artigos antigos que necessitam ser revisados;

* Diese [[Special:Categories|Kategorie]] ältere Artikel, die überarbeitet werden müssen;
* Cette [[Special:Categories|catégorie]] articles plus anciens qui doivent être révisés;
* Questa [[Special:Categories|categoria]] articoli più vecchi che devono essere rivisti;
* Данная [[Special:Categories|категория]] старые статьи которые должны быть пересмотрены.


[[Category:Outdated]]
[[Category:MainIndex]]

API/Samples/Groovy/Writer/CleanUpForHTML

2019-01-03T20:09:41Z

Adailton:

==About the CleanUpForHTML Example==
This is an example shows how to access properties in a Groovy macro or extension using a category (aka "mixin") [[UNO]] [[API]] helper. It is the CleanUpForHTML macro used in [http://www.ifcx.org/wiki/Wings.html IFCX Wings] to compensate for issues with the HTML generated by OpenOffice for Writer documents.

==The Code==
<source lang="java">
/**
* IFCX Wings - CleanUpForHTML.groovy macro.
* Copyright 2007-2008 by James P. White. All rights reserved.
* mailto:jim@pagesmiths.com
* http://www.ifcx.org/
*
* This software may be redistributed under the term of the GNU GENERAL PUBLIC LICENSE Version 2.
* http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
*
* For expert professional services and/or distribution under other terms, contact the author:
*
* James P. White
* mailto:jim@pagesmiths.com
* 26272 Summerhill Lane
* Laguna Hills, CA
* USA 92653
*
*/

package org.ifcx.wings.openoffice

/*
Import standard OpenOffice.org API classes. For more information on
these classes and the OpenOffice.org API, see the OpenOffice.org
Developers Guide at:

http://api.openoffice.org/
*/

import com.sun.star.uno.UnoRuntime
import com.sun.star.uno.XInterface

/*
Import XScriptContext class. An instance of this class is available
to all BeanShell scripts in the global variable "XSCRIPTCONTEXT". This
variable can be used to access the document for which this script
was invoked.

Methods available are:

XSCRIPTCONTEXT.getDocument() returns XModel
XSCRIPTCONTEXT.getDesktop() returns XDesktop
XSCRIPTCONTEXT.getComponentContext() returns XComponentContext

For more information on using this class see the scripting
developer guides at:

http://framework.openoffice.org/scripting/index.html
*/

import com.sun.star.beans.XPropertySet

import com.sun.star.text.XTextRange
import com.sun.star.text.XTextViewCursorSupplier
import com.sun.star.view.XViewCursor
import com.sun.star.text.XParagraphCursor

class UnoCategory {
public static Object uno(Object unoObj, Class clazz) {UnoRuntime.queryInterface(clazz, unoObj)}

public static Object getAt(XPropertySet pset, String pname) {pset.getPropertyValue(pname)}

public static void putAt(XPropertySet pset, String pname, Object newValue) {pset.setPropertyValue(pname, newValue)}
}

/**
* In order for the paragraph style to apply to an entire code block (a run of code
* paragraphs that Wings evaluates as a single block), we find all multiple line
* code blocks and make sure that they are a single paragraph. It is normal for
* code blocks to consist of multiple paragraphs because pressing 'return' starts
* a new paragraph.
*/
def doMergeCode(document) {
def viewCursor = document.currentController.uno(XTextViewCursorSupplier).viewCursor
// We get the XText from the cursor so that if it is from a frame or table it'll work.
def docText = viewCursor.text
XParagraphCursor textCursor = docText.createTextCursorByRange(viewCursor).uno(XParagraphCursor)

// It's a "paragraph" cursor, but may be positioned inside one.
// We assume that since "GroovyCode" is supposed to be a "paragragh" style
// that we'll still be in "GroovyCode" when we go to the beginning.

textCursor.gotoStartOfParagraph(false)

while (true) {
// Code blocks are runs of paragraphs whose style name ends with "Code".
while (!(textCursor.uno(XPropertySet)['ParaStyleName'] =~ /.*Code$/)) {
// println "Skipping ahead."
if (!textCursor.gotoNextParagraph(false)) {
// Can't find another paragraph, so we're done.
return;
}
}

XParagraphCursor codeRange = docText.createTextCursorByRange(textCursor).uno(XParagraphCursor)

def codeStyle = textCursor.uno(XPropertySet)['ParaStyleName']

// Move forward paragraphs until the end of the document,
// or we find a paragraph that isn't "GroovyCode" then move back one.

while (textCursor.gotoNextParagraph(false)) {
if (textCursor.uno(XPropertySet)['ParaStyleName'] != codeStyle) {
if (!textCursor.gotoPreviousParagraph(false)) doError("Couldn't move back (end)!");
break;
}
}

// The cursor is at the start of the paragraph, move it to the end.
textCursor.gotoEndOfParagraph(false);

// Then select all that text as our code.
codeRange.gotoRange(textCursor.end, true)

def codeString = codeRange.string

// println codeString

// the TextRange.getString() will have replaced paragraph end characters with '\n',
// which is the same as line breaks within a paragraph. So we don't really know
// whether we have multiple paragraphs or not, but we don't really care.

if (codeString.contains('\n')) {
// println "Replacing some"
// There are multiple lines, so we replace the paragraph(s) with a single
// paragraph of multiple lines.
codeRange.text.insertString(codeRange, codeString, true)
// The paragraph style is unchanged so we don't need to do anything about that.
}

if (!textCursor.gotoNextParagraph(false))
return
}
} // def doMergeCode...

/**
* When saving as HTML, OpenOffice doesn't take into consideration that all whitespace runs
* will be collapsed into a single space (or line break). That is disaster for most program
* text (code and output) which typically depend on leading whitespace on lines to be preserved.
* So what this method does is replace all leading whitespace on each line of a style that
* looks like it is used for Wings (those whose nanes end with "Code", "Result", "Exception",
* "Output", "Error", or "Input") and replace it with non-breaking spaces.
*/
def doFixFormatting(document) {
def viewCursor = document.currentController.uno(XTextViewCursorSupplier).viewCursor
// We get the XText from the cursor so that if it is from a frame or table it'll work.
def docText = viewCursor.text
XParagraphCursor textCursor = docText.createTextCursorByRange(viewCursor).uno(XParagraphCursor)

// It's a "paragraph" cursor, but may be positioned inside one.
// We assume that since "GroovyCode" is supposed to be a "paragragh" style
// that we'll still be in "GroovyCode" when we go to the beginning.

textCursor.gotoStartOfParagraph(false)

while (true) {
String codeStyle = textCursor.uno(XPropertySet)['ParaStyleName']

// Match style names of interest, if no match then it just falls thru.
switch (codeStyle) {
case ~/.*Code$/:
case ~/.*Result$/:
case ~/.*Exception$/:
case ~/.*Output$/:
case ~/.*Errors$/:
case ~/.*Input$/:

XParagraphCursor codeRange = docText.createTextCursorByRange(textCursor).uno(XParagraphCursor)

// The cursor is at the start of the paragraph, move it to the end.
textCursor.gotoEndOfParagraph(false);

// Then select all that text as our code.
codeRange.gotoRange(textCursor.end, true)

def codeString = codeRange.string

// println codeString

if (codeString.contains(' ') || codeString.contains('\t')) {
// println "Replacing some"

String[] lines = codeString.split('\n')

lines.length.times {
String line = lines[it]

// Treat tabs as eight spaces.
line = line.replace('\t', ' ')

if (line.startsWith(' ')) {
char[] chars = line.toCharArray()

// Replace the leading spaces with non-breaking spaces.
for (int i = 0; i < chars.length; ++i) {
if (' ' != chars[i]) break
chars[i] = '\u00A0'
}

lines[it] = new String(chars)
}
}

codeRange.text.insertString(codeRange, lines.join('\n'), true)
}
}

// println "Skipping ahead."
if (!textCursor.gotoNextParagraph(false)) {
return;
}

}
} // def doFixFormatting...

////////////// BEGIN //////////////
// This is the XModel for the currently active document.
def document = XSCRIPTCONTEXT.document

use(UnoCategory) {
doMergeCode(document)
doFixFormatting(document)
}

0
</source>

[[Category:API]]
[[Category:Writer/API]]
[[Category:Samples]]
[[Category:Groovy]]

API/Samples/Cpp

2019-01-03T20:06:17Z

Adailton:

Under this section you can find examples showing different [[API]] use cases implemented in C++.

==Office==
<DPL> category=API
category=Samples
category=Cpp
category=Office</DPL>
==Writer==
<DPL> category=API
category=Samples
category=Cpp
category=Writer</DPL>
==Calc==
<DPL> category=API
category=Samples
category=Cpp
category=Calc</DPL>
==Draw/Impress==
<DPL> category=API
category=Samples
category=Cpp
category=Draw
category=Impress</DPL>
==Chart==
<DPL> category=API
category=Samples
category=Cpp
category=Chart</DPL>
==Database==
<DPL> category=API
category=Samples
category=Cpp
category=Database</DPL>

[[Category:API]] [[Category:Samples]]

API/Implementation Details/Programmatic StyleNames

2019-01-03T20:05:26Z

Adailton:

This page provides an overview of default implementation stylenames that can be used to set the different styles over the [[API]]. For example if you want to set the '''Heading 1''' paragraph style, you have to set the property '''ParaStyleName''' with the value '''Heading 1''' at the appropriate TextCursor. If you use a wrong spelling, e.g. '''Heading1''', you will get an error. These stylenames are implementation details and not documented in the IDL reference.

== Writer StyleNames ==

{|cellpadding=5 cellspacing=0 border=1 style="border-collapse:collapse; margin-left: 2em; border-color: #333;"
|- style="background-color: #dedede;"
! Implementation name !! UI name (en-US) !! Style family
|-
| style="background-color: #f2f6f9;" | "Standard" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Text body" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "First line indent" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Hanging indent" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Text body indent" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Salutation" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Signature" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "List Indent" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Marginalia" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 1" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 2" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 3" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 4" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 5" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 6" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 7" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 8" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 9" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "Heading 10" || - || Paragraph Style, Text Style
|-
| style="background-color: #f2f6f9;" | "List" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 1 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 1" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 1 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 1 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 2 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 2" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 2 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 2 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 3 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 3" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 3 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 3 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 4 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 4" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 4 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 4 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 5 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 5" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 5 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Numbering 5 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 1 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 1" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 1 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 1 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 2 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 2" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 2 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 2 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 3 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 3" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 3 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 3 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 4 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 4" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 4 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 4 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 5 Start" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 5" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 5 End" || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "List 5 Cont." || - || Paragraph Style, List Style
|-
| style="background-color: #f2f6f9;" | "Header" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Header left" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Header right" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Footer" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Footer left" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Footer right" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Table Contents" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Table Heading" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Caption" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Illustration" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Table" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Text" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Frame contents" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Footnote" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Addressee" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Sender" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Endnote" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Drawing" || - || Paragraph Style, Special Style
|-
| style="background-color: #f2f6f9;" | "Index" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Index Heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Index 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Index 2" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Index 3" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Index Separator" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents Heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 2" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 3" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 4" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 5" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index Heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 2" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 3" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 4" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 5" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 6" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 7" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 8" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 9" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Contents 10" || - || Paragraph Style, ndex Style
|-
| style="background-color: #f2f6f9;" | "Illustration Index Heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Illustration Index 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Object index heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Object index 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Table index heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Table index 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Bibliography Heading" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Bibliography 1" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9 | "User Index 6" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 7" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 8" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 9" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "User Index 10" || - || Paragraph Style, Index Style
|-
| style="background-color: #f2f6f9;" | "Title" || - || Paragraph Style, Chapter Style
|-
| style="background-color: #f2f6f9;" | "Subtitle" || - || Paragraph Style, Chapter Style
|-
| style="background-color: #f2f6f9;" | "Quotations" || - || Paragraph Style, HTML Style
|-
| style="background-color: #f2f6f9;" | "Preformatted Text" || - || Paragraph Style, HTML Style
|-
| style="background-color: #f2f6f9;" | "Horizontal Line" || - || Paragraph Style, HTML Style
|-
| style="background-color: #f2f6f9;" | "List Contents" || - || Paragraph Style, HTML Style
|-
| style="background-color: #f2f6f9;" | "List Heading" || - || Paragraph Style, HTML Style
|-
| style="background-color: #f2f6f9;" | "Frame" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Graphics" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "OLE" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Formula" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Marginalia" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Watermark" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Labels" || - || Frame Style
|-
| style="background-color: #f2f6f9;" | "Footnote Symbol" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Page Number" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Caption characters" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Drop Caps" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Numbering Symbols" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Bullet Symbols" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Internet link" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Visited Internet Link" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Placeholder" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Index Link" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Endnote Symbol" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Line numbering" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Main index entry" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Footnote anchor" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Endnote anchor" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Rubies" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Vertical Numbering Symbols" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Emphasis" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Citation" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Strong Emphasis" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Source Text" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Example" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "User Entry" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Variable" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Definition" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Teletype" || - || Character Style
|-
| style="background-color: #f2f6f9;" | "Standard" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "First Page" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Left Page" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Right Page" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Envelope" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Index" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "HTML" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Footnote" || - || Page Style
|-
| style="background-color: #f2f6f9;" | "Endnote" || - || Page Style
|-
|}

[[Category:API]]

API/FAQ

2019-01-03T20:04:46Z

Adailton:

[[API]] ... in progress ...

[[Category:API]]
[[Category:FAQ]]

API/Concepts API changes

2019-01-03T20:04:01Z

Adailton:

{{DISPLAYTITLE:Concepts for incompatible API changes and an API deprecation process}}

== Concept for incompatible [[API]] changes ==

=== Background ===
Today we have over 4280 IDL types, many types defining how to define or transport data, how to access certain data, information via certain interfaces. Many types defining Service Provider Interfaces that allows to extend the feature set of OpenOffice with completely new features or with further implementation of the same category (eg. filter, calc add-ins, etc).
When the design of the office API started the goal was to design one API for all the different use cases and make use of the UNO technology to use this one API from different programming languages. A very high goal which sounds perfect from the beginning but the reality is that users of the API have different skill levels and different requirements to an API. The design focused mainly on internal usage to drive the modularization of the office core and provide a better flexibility. Basic means macro developers should use the same API but a macro programmer has a different abstraction level and prefer a more highlevel API. The whole API is very fine grained, allows many modification on a fine grained detail level and make use of object oriented concepts.
So far so good but a further goal was to keep the API compatible which a nice goal but in the reality hard to achieve. Especially when you take into account that many API's were designed without really using them. Not a very good approach to create good API's that ideally evolve over time and where feedback is integrated to improve them. The problem of changing API's is not the office core but existing macros in documents or extensions. The problem increased over years and new interface where introduced where normally an existing one would have been changed. New UNO concepts were introduced to make API's much more intuitive and easier to use. Ideally existing API's would have been changed to improve from these very useful changes. We used the new stuff only for new API's. Many design errors remain unchanged in the API and make the whole API not really better over time.

=== Incompatible changes ===
Over time we recognized that we have to allow useful incompatible changes to move the project, the product forward and to be able to change things.

Requirements for an incompatible API change:
* incompatible changes should be allowed to major releases only
* the change must be communicated clearly in advance
* a migration path from old to new have to be documented with examples. (additional tooling support is appreciated if possible)

== API deprecation process ==
Sometimes it is also useful and necessary to deprecate API's to be able to remove them over time. This can make sense for cleanup reasons but more often because the supported feature is dropped or removed completely. Or the API as it is today make no longer sense at all.

Requirements for deprecated API's:
* API's can be deprecated with every major, minor release.
* recommendation is to support a deprecated API for at least one further (minor) version. Means a deprecated API for 3.4 should not be removed in 4.0 when 4.0 is the next major/minor version after 3.4.
* deprecated API's can be removed in major release only

[[Category:API]]

API/Samples/Any Language

2019-01-03T20:02:31Z

Adailton:

Under this section you can find examples showing different API use cases implemented in any language.

==Office==
<DPL> category=API
category=Samples
category=Office</DPL>
==Writer==
<DPL> category=API
category=Samples
category=Writer</DPL>
==Calc==
<DPL> category=API
category=Samples
category=Calc</DPL>
==Draw/Impress==
<DPL> category=API
category=Samples
category=Draw
category=Impress</DPL>
==Chart==
<DPL> category=API
category=Samples
category=Chart</DPL>
==Database==
<DPL> category=API
category=Samples
category=Database</DPL>

[[Category:API]]
[[Category:Samples]]

Template:Pdf

2019-01-03T19:32:04Z

Adailton: Redirected page to Template:PDF

#REDIRECT [[Template:PDF]]

2008 Q2 Review of Spreadsheet Project

2019-01-03T19:29:14Z

Adailton:

= Review of the OpenOffice.org [[Spreadsheet]] project (April/May 2008) =

== Review schedule ==

* start of review: April 28th
* review of collected issues: May 5th, 3pm UTC, #ooocalc on freenode
* start of sorting priorities and assignments May 5th
* review of final list: May 13th, 3pm UTC, #ooocalc on freenode

== Status of the project ==

=== what are the most severe issues in the current release ===
High voted issues April 2008 (all types - defects, features, enhancements):
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=8302 8302]: (111 Votes) Want to be able to insert into the middle of merged cells
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5560 5560]: (75) Spreadsheet Sheet Labels (change Color and Font)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5930 5930]: (71) Engineering Notation
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=12666 12666]: (61) Autofilter works just on one sheet (only one auto-range per
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=30215 30215]: (57) Further thoughts on row limits
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=20857 20857]: (55) R1C1 notation for the spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=21280 21280]: (50) Automatic Insert (shift down or shift right) of cells, colum
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=2131 2131]: (47) Ability to merge cells already merged
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=15773 15773]: (45) Currency symbol left justified, while amount right justified
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=59745 59745]: (44) Cell notes do not move when cells are sorted in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=35579 35579]: (42) Standard filter requires more options..
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=6087 6087]: (40) ODF: Allow all characters in sheet names
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=25855 25855]: (38) Copy multiple seperated rows
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=22762 22762]: (33) Page preview for Selection
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=33723 33723]: (31) Ability to turn off Number Recognition in Calc
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5658 5658]: (24) Spreadsheet thinks a number is a string (text)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=87970 87970]: (22) Hebrew Characters in Spreadsheet Names Became Misdisplayed
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=38494 38494]: (21) Copy/Paste numbers from Writer to Calc: decimal separator in
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5759 5759]: (19) DataPilot: allow more than 8 data fields
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=3687 3687]: (18) Make CSV import/export filter settings persistent (e.g. the

=== which are the most requested (or needed) features (in the press, user forums, issues, other feedback) ===

The following ux-ctest issues have been recorded during usability sessions.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60408 60408]: Sum Icon in Calc not Found: [http://specs.openoffice.org/calc/ease-of-use/sum_button_enhancements.odt Specification]
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60403 60403]: Edit menu: Expected menu command to duplicate sheets
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60402 60402]: German terminology in context menu for sheet controls could be misunderstood
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60401 60401]: Calc does not support all users' strategies regarding sorting data
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60400 60400]: Spreadsheet handling wording table vs. spreadsheet
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=60399 60399]: Delete Columns/Rows in the context menu is missing if the cursor is not positioned on Column/Row Header

The following issues have been recorded during expert talks with customers.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=969 969]: Auto-Correct on leaving cells does not work
# Issue no.: ??????: Add Color Picker and Link to Color Dialog to Color Float
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=66484 66484]: Missing Range Chooser Issue
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=5432 5432]: F4 should repeat last command
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=10864 10864]: Color chooser do not show latest color
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]: [http://specs.openoffice.org/calc/features/Print_Output_Scaling_Factor.odt]: Print Output Scaling Factor

Usability problems
# {{Bug|87999}}: (11 votes) In "standard" data type CSV import should never convert items with one dot to dates
:: Users very often struggle with this problem. Some issues from the issue tracker: {{Bug|6315}} {{Bug|7606}} {{Bug|13156}} {{Bug|18458}} {{Bug|20804}} {{Bug|23024}} {{Bug|25201}} {{Bug|31326}} {{Bug|59339}} {{Bug|65142}} {{Bug|67813}} {{Bug|69097}} {{Bug|72449}} {{Bug|82196}} {{Bug|88243}}. They are all closed as "worksforme" or "invalid" or "duplicate", but they show that the import of CSV files needs improvement. The issue is related to {{Bug|33723}} but not the same.

== short term planning ==
=== which defect needs to go into the next release ===

None at the moment, but we agreed to be flexible for any incoming new issues if any, especially those with patches.

=== which features will be worked on for the half year ===
# ODFF formula changes
# Excel 2007 import
# Calc collaboration (extend change tracking for formatting and attributes)
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=14893 14893]: (3) Excel displays Grid lines on a per sheet basis, Calc on a per document basis
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=85305 85305]: (1) Dynamically grow a filtered range for autofilter, standard filter, and advanced filter
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=86856 86856]:Show Formula Syntax in tip help.
# Issue no.: [http://www.openoffice.org/issues/show_bug.cgi?id=88521 88521]:Adding scaling factor on page preview in calc.

=== which issues needs an assignment ===

== mid/long term planning ==
=== which features/bugfixes needs to be addressed in the next two/three years ===
=== unassigned feature/bugfixes ===

=== long-term suggestions ===
#; separate functional units:
#* split Calc into 2 functional units / separate applications
#* one broad '''table/canvas''' application for general users, similar to [http://www.apple.com/iwork/numbers/ Apple's Numbers]
#* one application focused on '''professional spreadsheet''' users
#*;
# '''general use:'''
#* modalities for easier and more productive table input: a lot of brainstorming needed
#*; professional users would benefit as well
#** create input templates, e.g. see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingcheckboxesandsliders_20070807_640x360.mov Apple's iWork tutorial] and any decent statistical application (e.g. [http://www.cdc.gov/epiinfo/ Epi Info])
#** data validation
#* ease table formatting:
#** [http://www.openoffice.org/issues/show_bug.cgi?id=78181 issue 78181] and Apple's iWorks Tutorial [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_customizingtables_20070807_640x360.mov movie 1] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_usingtablesheadersfooters_20070807_640x360.mov movie 2]: table styles, striped tables, highlight current row, headers and footer rows (results row)
#** advanced canvas formatting:
#*** add various elements/objects to spreadsheets, see [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov iWorks tutorial] and [http://www.openoffice.org/issues/show_bug.cgi?id=83767 issue 83767: Company Logos]
#*** merge Draw-features into the spreadsheet application (see previous iWorks tutorial)
#* ease and implement automatic analysis features (very basic ones - like correct descriptive statistics)
#** [http://www.openoffice.org/issues/show_bug.cgi?id=89980 '''SUMMARY()'''] function: compute automatically all needed results for descriptive statistics purposes and export results adapted as for publication needs (e.g. in academic settings)(see also the discussion on the [http://lists.oasis-open.org/archives/office-comment/200806/msg00003.html OASIS mailing list])
#*;
# '''professional use:'''
#* catch numerous errors by implementing strong typing: see [http://www.openoffice.org/issues/show_bug.cgi?id=79924 issue 79924]
#* prepare for multidimensional spreadsheets / OLAP functionality:
#** split table into functional layers
#** separate data layer from formula layer (see next section: multidimensional spreadsheets)
#** separate general definitions of constants, variables, and names into a separate spreadsheet header: see [http://www.openoffice.org/issues/show_bug.cgi?id=67499 issue 67499] and [http://www.openoffice.org/issues/show_bug.cgi?id=66886 issue 66886]
#** separate spreadsheet and table headings from data layer: see [http://www.openoffice.org/issues/show_bug.cgi?id=83767 Company Logo] and [http://movies.apple.com/movies/us/apple/mac/iwork/2007/numbers/iwork_numbers_addingtextandshapes_20070807_640x360.mov Apple's iWorks tutorial] on adding various elements to the canvas
#** separate results from Data Layer: issue not yet filed
#* implement multidimensional spreadsheets: see [http://www.openoffice.org/issues/show_bug.cgi?id=85825 issue 85825]

[[Category:Calc]]
[[Category:To-Do]]
[[Category:Releases]]

User talk:Adailton

2019-01-03T14:00:03Z

Adailton:

{{User:Adailton/idiomas}}

==Top level category==
Hi, Adailton,

First, thanks a lot for all the maintenance work you have been doing; it's good stuff.

You are correct in observing that the [[:Category:MainIndex]] will remain un-categorized, but such is the fate of the topmost category! It's the same on Wikipedia, where Category:Contents belongs to no category.

The idea here is to prevent category-linkage loops, to avoid confusing the bots. These would normally process categories recursively. If you've done any recursive programming, you can see how a closed loop could lead to infinite recursion.

:Please keep up the good work! --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 14:38, 11 January 2012 (UTC)
::fyi - (list of categories) (edit window bottom displayed, probably in the .CSS heirarchy somewhere) isn't connected to that above link: [[:Category:MainIndex]], for some reason. Search engine foibles are a funky thing in mediawiki. Good Luck and thanks for the Welcome! //[[User:Fabartus|Fra]][[User talk:Fabartus|nkB]] 18:09, 24 May 2013 (UTC)

== Template HowTos ==

If you edit [[Documentation/How_Tos]] you will see that most of the HowTo entries are gathered automatically by the <nowiki><DPL></nowiki> feature, which lists all the pages in a category. However, the Templates HowTos are not automated, and they should be. This means going to each entry, changing the category from doc/howto to doc/howto/templates, then creating that category (and categorizing it in doc/howto). Then add the automatic stuff to use the new category. There are some (at least one) pages in [[:Category:Templates]] that should be included, too.

If any of this sounds like something you'd like to do, please do. Otherwise, I'll plod along at it. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 21:30, 27 September 2012 (UTC)

== Hurricane Sandy ==

Hurricane Sandy is passing by my location. I may lose power or internet access. Please watch for spammers in the meantime. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 09:54, 26 October 2012 (UTC)

== Sysop ==

You are now a sysop. Please delete these idiots. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 11:25, 17 November 2012 (UTC)

:Good work! We're catching up with them. Thanks for your efforts; please keep it up. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 13:53, 17 November 2012 (UTC)

::Well done, partner! With two or three of us, it doesn't take long, does it? --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]]) 22:56, 18 November 2012 (UTC)

== Redlinks ==

Thanks for cleaning up those OldES redlinks. Keith ([[User:KNMcKenna]]) may be creating some redlinks in his work on the FAQs. They should go away when he's finished. I didn't want you to worry about them. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]]) 13:19, 15 December 2012 (UTC)

== Icons and simbols ==
Hi Adailton,
Maybe rename Category:Icons_and_simbols --> Category:Icons_and_symbols ? --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 16:26, 11 February
2013 (UTC)

== Category:Files ==
Hi Adailton,
I created two new subcategories in [[:Category:Images]]: [[:Category:Logo and Design‎]] and [[:Category:Splash Screens‎]]. Please look --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 04:27, 12 February 2013 (UTC)

I created [[:Category:ODP]] --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 06:22, 13 February 2013 (UTC) and
[[:Category:Screenshots and Dialogs]] --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 03:33, 18 February 2013 (UTC)

== Создать документ ==
Hi Adailton,
I deleted [[Создать документ]] page. --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 07:42, 24 May 2013 (UTC)

== You may want to steal some ideas ==

Hi again, Seeing your talk, I just thought I'd share a couple of links
# [en.wikipedia.org/wiki/Special:Categories en.wikipedia.org/wiki/Special:Categories]
# http://commons.wikimedia.org/wiki/Category:Categories
Both [http://en.wikipedia.org/wiki/Wikimedia_Foundation Wikimedia Foundation's] projects have an extensive category system worked out, albeit with a little bit of differences such as where the category trees start, the second is the media repository site for all the Mediawiki Foundation wiki projects--including even image namespace archives for most of the many images used in all language Wikipedia's world wide, the first has some how-to Wikipedia namespace (i.e. special Editor Help namespace) and the special page of course.
#If you follow the Category trees, you'll see many categories are listed in multiple categories as you descend from the root categories. (I didn't see that on the few links above I sampled) Structured that way, a user can use the categories to efficiently locate related 'articles' or 'media' resources.
Good luck! //[[User:Fabartus|Fra]][[User talk:Fabartus|nkB]] 18:23, 24 May 2013 (UTC)

== Double redirects ==

Hi Adailton

> The page [User talk:Mirek2] is listed in [[Special:DoubleRedirects]].

> It was started on [Iced Coffee] title and moved to [Proposal by Miroslav Mazel], and now for [User talk:Mirek2]. But there are contributions from other users,

> so I think this should be the main-domain, which was created. What do you think?

This page is a part of the old Renaissance project. Mirek2 is main contributor and he wished to delete this page via the moving to [User talk:Mirek2] (he wrote "''I'd like to remove the whole page. This is the simplest way I can think of.''", please look at [http://wiki.openoffice.org/w/index.php?title=User_talk:Mirek2&action=history history]). I think we should :
# delete [Iced Coffee] (no content, no links, no value)
# rename back [User talk:Mirek2] -> [Proposal by Miroslav Mazel] because this page has other contributors. (rename again or undo the editing ?)
# add the delete template <nowiki>{{delete}}</nowiki> to [Proposal by Miroslav Mazel] because the main contributor wished to delete this page.

Then we are waiting some time (2-3 months) and if other contributors will not protest against deleting of this page we'll delete it. --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 17:23, 16 September 2013 (UTC)

: Adailton, thank you for your work! --[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 04:04, 17 September 2013 (UTC)

== wfs000.png ==

Hi ADAILTON.

it seems that wfs000.png. is a duplicatie of wfs1000.png but it ism't

Beyond the word Students in wfs000.png is a thin blue line that shouldn't be there.
I tried to fix that with a new screenshot but failed.

That is why I entered wfs1000.png.

I have no problem with totally deleting wfs000.png. I won't be using it anymore.
Problem is I can't delete it, otherwise I already would have :)

Thanks for noticing though,

Greetings,
DiGro

== A massive spam attack ==

Hello Adailton,

Big thank you for your hard work for deleting and blocking of spammer accounts!

The wiki configuration was changed so that only sysops can create new accounts now (thanks to Jan Iversen).

Discussion in a mailing list: http://www.mail-archive.com/dev@openoffice.apache.org/msg16242.html

--[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 04:06, 7 February 2014 (UTC)

== more about spam ==

Hi Adailton,

My reply for [[User_talk:Helen_russian#more_about_spam]]

I think external links are not a big problem for this Wiki. Please take a look at source code of any wiki page with an external link. You'll see almost all external links contain "[https://en.wikipedia.org/wiki/Nofollow nofollow]" attribute here. So I see no reason for very very hard work on the manually checking of old external links.
--[[User:Helen russian|Helen]] ([[User talk:Helen russian|talk]]) 16:14, 1 March 2014 (UTC)

== Sancho: File:Function IMSQRT 3 formula.png ==

Hi Adailton!
I answered your question.
--[[User:Sancho|А. Е. Харламенков]] ([[User talk:Sancho|talk]]) 12:05, 3 January 2019 (UTC)

User:Adailton

2019-01-03T13:58:16Z

Adailton:

{{User:Adailton/idiomas}}

{| border="1" class="wikitable sortable"
|+[[Wiki maintenance|Tarefas]]
! Tarefa || Páginas
|-
|[[Special:UncategorizedCategories|Categorias não categorizadas (Uncategorized categories)]]
| style="background:#40ff40;" | 1
|-
|[[Special:UnusedCategories|Categorias não utilizadas (Unused categories)]]
| style="background:#40ff40;" | 23<ref name=correlation-failure>'''''Números afetados por [[User:Adailton/character correlation failure|falha na correlação de caracteres especiais (correlation failure)]]'''''</ref>
|-
|[[Special:WantedCategories|Categorias pedidas (Wanted categories)]]
| style="background:#40ff40;" | 22<ref name=correlation-failure/>
|-
|[[Special:UncategorizedFiles|Arquivos não categorizadas (Uncategorized files)]]
| style="background:#40ff40;" | 85
|-
|[[Special:UncategorizedTemplates|Predefinições não categorizadas (Uncategorized templates)]]
| style="background:#40ff40;" | 0
|-
|[[Special:UnusedTemplates|Predefinições não utilizadas (Unused templates)]]
| style="background:#ffb040;" | 128
|-
|[[Special:WantedTemplates|Predefinições pedidas (Wanted templates)]]
| style="background:#ffb040;" | 63
|-
|[[Special:UncategorizedPages|Páginas não categorizadas (Uncategorized pages)]]
| style="background:#40ff40;" | 0
|-
|[[Special:DeadendPages|Páginas sem saída (Deadend pages)]]
| style="background:#ff4040;" | 3 377
|-
|[[Special:LonelyPages|Páginas órfãs (Lonely pages)]]
| style="background:#ff4040;" | 1 087
|-
|[[Special:DoubleRedirects|Redirecionamentos duplos (Double redirects)]]
| style="background:#40ff40;" | 0
|-
|[[Special:BrokenRedirects|Redirecionamentos quebrados (Broken redirects)]]
| style="background:#40ff40;" | 0
|-
|[[:Category:Candidates for speedy deletion|Eliminação rápida (speedy deletion)]]
| style="background:#ffb040;" | {{PAGESINCATEGORY:Candidates for speedy deletion}}
|}
<references/>

User:Adailton/idiomas

2019-01-03T13:39:10Z

Adailton: Created page with "<div style="border:thin solid green;float:right; padding:3pt; background-color: #d0d0eb; margin-top: 10pt; margin-bottom: 10pt;"> {|border=0 style="background-color:inherit!im..."

<div style="border:thin solid green;float:right; padding:3pt; background-color: #d0d0eb; margin-top: 10pt; margin-bottom: 10pt;">
{|border=0 style="background-color:inherit!important; text-align:center" celpadding=0 cellspacing=0
|-
|[[File:AutoSpellcheck.png|42px]]
|-
|'''<big> Welcome, Bem vindo, bienvenida, Bienvenue, Benvenuto, Willkommen, добро пожаловать </big>
|-
|bgcolor="f0d0d0" |Sorry if I write bad, I'm fluent in Portuguese, and use [https://translate.google.com.br/ 'google translator']
|}
</div>

User talk:Sancho

2019-01-03T12:56:23Z

Adailton: /* File:Function IMSQRT 3 formula.png */

Hi Sancho,

please do not create new pages under Kb/ but use RU/Kb/ instead as the pages are russian. see [[Help:Translating]] and [[Help:Page_naming]] for details.

--[[User:B michaelsen|B michaelsen]] 22:16, 31 March 2010 (UTC)

Another thing i am wondering about is the strange pagetitles (basically huge numbers) you are using. Why dont you use "speaking" pagetitles? It makes the content much easier to find.

--[[User:B michaelsen|B michaelsen]] 22:25, 31 March 2010 (UTC)

: Pagetitles that are just numbers make it very difficult for the MediaWiki search tool to find any content unless the number is something people will search. The MediaWiki search tool searches page titles FIRST and returns the results. If it cannot find matches on Page title, then it does a best guess based on page content (and doesn't do an especially good job). Meaningful pagetitles are '''very''' important in a Wiki. So... please consider using something other than numbers. --[[User:Ccornell|ccornell]] 13:06, 1 April 2010 (UTC)

To mark pages to be deleted, add <tt><nowiki>{{delete}}</nowiki></tt> to the page, and it will be deleted in the routine maintenance. --[[User:Ccornell|ccornell]] 13:06, 1 April 2010 (UTC)

Breadcrumbs will be added automatically if you set up your sub pages correctly. Then, you do not need to add links at the top of the page to take readers back to the parent page (I've noticed that this has been done on all the new pages I've looked at). For the breadcrumbs to work, you must make sure that there is content at each subpage level (eg there is no content at RU right now, and there should be) - any extra redirects that are in place right now may need to be fixed and cleaned up (there are redirects at RU/Kb and RU/kb pointing at RU/Knowledge_base). --[[User:Ccornell|ccornell]] 13:16, 1 April 2010 (UTC)

----
Hello, B michaelsen, ccornell.

Thank you for your assistance and attention to my work.

I try to fix remarks from you and follow the rules.

We are creating a new project - "The OpenOffice.org Knowledge Base”.

My activity has few goals:
:*Users do not speak English
:*For russian-speaking users use english page names for searching is impossible.
:*The URL with cyrilic symbols are showing in "percent‐encoded" form. It is very difficult to input and dictate by telephone. For telephone talk are easier say numbers then URL.

I found that the wiki url case sensitive.

URL with RU/Kb != RU/kb != Ru/kb != ru/kb != Knowledge base. But logically they are equal. So I had to make a redirects.

I have seen "Automatic Breadcrumbs".. In addition, I have adding links to missing pages in Breadcrumbs, if such links are logically related to the context.

--[[User:Sancho|Sancho]] 2 April 2010

----

Hi Sancho,

thanks for your comments. However, I think that creating all the redirects will lead to a maintenance disaster. The automatic redirects created by moving pages are need because someone might have already linked to the old page. But for new pages I would prefer it if you would create just one page (either RU/kb.. or RU/Kb/..) and no redirects. Otherwise their is a high risk that other contributors start creating pages with different names so that you end up with 20 pages in RU/Kb, 14 pages in RU/kb, 2 in ru/Kb and 32 in ru/kb. Such a mess would be annoying to administer or clean up.

Have Fun,

--[[User:B michaelsen|B michaelsen]] 13:45, 3 April 2010 (UTC)
: Thinking a bit about it, I am still unconvinced that those numbered titles are necessary. If you use cyrillic titles and add the Knowledge base ID on the top of page it is really easy to search for that ID. Here is an example:
{{Note|This is Kb/47114711!}}
:[http://wiki.services.openoffice.org/w/index.php?ns0=1&ns3=1&search=Kb%2F47114711 Easy to find by search.]
--[[User:B michaelsen|B michaelsen]] 15:21, 3 April 2010 (UTC)

----
Hello, B michaelsen, ccornell.

Thank you for your help.

We very carefully examined your proposal. It took a long time.

Our goal - reduction of addresses transmission errors of important for user information.

'''Redirecting'''

Redirect pages are made only for two start pages of the Russian section.

Before you mark the page to delete, I check that it had no options.

'''URLs as nunbers'''

We conducted a study on all possible options for URL. We have taken all your suggestions. We reached the following conclusions.

Russian names to use inappropriate for the following reasons:

* words and terms in the Russian language is much longer than those in English.
* all the Russian people made spelling mistakes. This meaning of the text is not distorted. Record dictated by telephone URL without error unlikely.
* Russian URL when converted to "percent-encoded" is longer than 6 times.
* converted to "percent-encoded" URL totally meaningless. Example: '''(EN)''' «To enable detailed tooltips throughout the interface once and for all at once, press the key combination» '''(RU)''' «Чтобы включить подробные всплывающие подсказки во всём интерфейсе сразу и навсегда на один раз нажмите сочетание клавиш» is transformed into: '''(%%)''' % D0% A7% D1% 82% D0% BE% D0% B1% D1% 8B_% D0% B2% D0% BA% D0% BB% D1% 8E% D1% 87% D0% B8% D1% 82% D1 % 8C_% D0% BF% D0% BE% D0% B4% D1% 80% D0% BE% D0% B1% D0% BD% D1% 8B% D0% B5_% D0% B2% D1% 81% D0% BF % D0% BB% D1% 8B% D0% B2% D0% B0% D1% 8E% D1% 89% D0% B8% D0% B5_% D0% BF% D0% BE% D0% B4% D1% 81% D0 % BA% D0% B0% D0% B7% D0% BA% D0% B8_% D0% B2% D0% BE_% D0% B2% D1% 81% D1% 91% D0% BC_% D0% B8% D0% BD % D1% 82% D0% B5% D1% 80% D1% 84% D0% B5% D0% B9% D1% 81% D0% B5_% D1% 81% D1% 80% D0% B0% D0% B7% D1 % 83_% D0% B8_% D0% BD% D0% B0% D0% B2% D1% 81% D0% B5% D0% B3% D0% B4% D0% B0_% D0% BD% D0% B0_% D0% BE % D0% B4% D0% B8% D0% BD_% D1% 80% D0% B0% D0% B7_% D0% BD% D0% B0% D0% B6% D0% BC% D0% B8% D1% 82% D0 % B5_% D1% 81% D0% BE% D1% 87% D0% B5% D1% 82% D0% B0% D0% BD% D0% B8% D0% B5_% D0% BA% D0% BB% D0% B0 % D0% B2% D0% B8% D1% 88

* transformed into a "percent-encoded" URL can not dictate, can not be read as a text, can not be used for reference and educational literature.

So we decided to translate the names of Russian articles in English and use the tag ((DISPLAYTITLE))

Only '''one''' subsection, "knowledge base", URL use numbers to avoid transmission errors.

URL-numbers will be collected in a separate Categories. For visual navigation to manually create the index.

We ask that you allow to continue the experiment in Russian namespace.

Respectfully [[User:Sancho|Санчо]] 16:34, 15 April 2010 (UTC)

For example, the French also use the numbered articles in the FAQ: [[:Category:FR/Documentation/FAQ/Base]], and [[:Category:Pt.openoffice.org]]
--[[User:Sancho|Санчо]] 15:25, 18 April 2010 (UTC)

Sancho, хватит уже править [http://wiki.services.openoffice.org/wiki/RU/rules_and_information_policy "правила"]? Давайте обсуждать лучше в обсуждении?--[[User:Fyva|Fyva]] 11:14, 22 May 2010 (UTC)

Пожалуйста, давайте обсуждать. Все вопросы можно решить только обсуждением, а не войной, я не пони маю, почему вы игнорируете то что я пишу?--[[User:Fyva|Fyva]] 11:26, 22 May 2010 (UTC)

== Please stop edit warring ==

Please let's talk
* [[Talk:RU/rules_and_information_policy]]
* [[Talk:RU/Documentation/FAQ/General]]

Thank you --[[User:Helen russian|Helen]] 17:37, 22 May 2010 (UTC)

== Edit Warring is Not Cultured ==

(This is directed at all participants in the edit warring currently in progress on several Russian-language pages. Users other than Sancho will be directed here.)

This is a wiki: a venue for group efforts, through consensus. No matter how much effort you put into a page or pages, you do not own them; you do not control them. As it says at the bottom of any page open for editing, "If you do not want your writing to be edited mercilessly, then do not submit it here." Because the essence of a wiki is cooperation and politeness, it is wise (and polite) to discuss important changes on the Talk pages; that is their purpose. If someone objects to your changes, consider the changes "important", and discuss the issue on the Talk page; now that you know it's "important" to somebody else, discuss the issue ''before'' making further changes. Try to reach a consensus. Try hard.

Reverting (undoing) another contributor's edits is rude. Doing so without discussion on the Talk page is ''very'' rude, and can lead to edit wars, wherein various contributors are reverting each other's edits. This can lead to users being blocked (edit wars are forbidden) for cooling-off periods.

Please do not misuse the term, "vandalism". We do see it here, but very rarely: pages blanked, obscenities or jokes randomly inserted, and so forth. Vandals are usually banned (permanently blocked). Differences of opinion are not vandalism; calling them such is an insult, and will not be tolerated. (Personal attacks are forbidden.)

Your friendly neighborhood sysop, --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 00:33, 23 May 2010 (UTC)

:TJFrazier, for a response I need some time. Please wait. --[[User:Sancho|Санчо]] 08:17, 23 May 2010 (UTC)

::Yes, of course. We are all aware of all your hard work in this area; take what time you need. Meanwhile, please do not undo the contributions of others, without discussing it first. --[[User:TJFrazier|TJ]] ([[User_talk:TJFrazier|Talk]] | [[Special:Contributions/TJFrazier|Contribs]]) 08:48, 23 May 2010 (UTC)

== RU/UA Categories ==
Hi Sancho,
I you find me assigning pages wrongfully as [[:Category:RU]] please just reassign them as [[:Category:UA]]. Im sorry, I cant really tell them apart ;)

--[[User:B michaelsen|B michaelsen]] 20:39, 4 June 2010 (UTC)

:Ok, I will do. 
:To distinguish between the Russian and Ukrainian. In Russian, there is no letter '''«i»''' inside words.
:--[[User:Sancho|Санчо]] 08:39, 5 June 2010 (UTC)

== ES and Education template functionality ==

The issue between the localization of an international proyect, vs the content of a locale project. So Spanish localizations work as project/lang while ES project works as lang/pagename

Education project (if you see) uses the same convention for locales in FR, ZH, IT, etc.

Update: Also seems to be the natural way that the templateEduc works using a LANG:LANG Template. (please view source)

== Thanks for your work ==

Ok thanks for letting e know, I'll fix it ASAP

== [[:File:Function IMSQRT 3 formula.png]] ==

Hi Алексей

The file [[:File:Function IMSQRT 3 formula.png]] was not categorized. I included in the category [[:Category:Formulas]].

Please, consider categorize all the files to load, in [[:Category:Files]] or any subcategory, or create a [[Special:Categories|categorie]].

:Hi Adailton!
:I thank you for adding categories to all files.
:--[[User:Sancho|А. Е. Харламенков]] ([[User talk:Sancho|talk]]) 12:03, 3 January 2019 (UTC)

By appropriate, why did not you use the code ''(a1+b1i)*(a1+b1i)=a0+b0i''? or ''(a1+b1i)2=a0+b0i''?

Regards [[User:Adailton|Adailton]] ([[User talk:Adailton|talk]]) 15:32, 29 December 2018 (UTC)

:There are very complex formulas, for example [[File:Function_IMSQRT_formula.png|360px]]. There are even more complex formulas.
:I do not know the wiki code that can shape the formula that way. Therefore, in order for all formulas to be visible as they should be printed in a book, I have to use photographs (screenshots).
:Regards --[[User:Sancho|А. Е. Харламенков]] ([[User talk:Sancho|talk]]) 12:03, 3 January 2019 (UTC)
::There should be a Формулы module, according [https://ru.wikipedia.org/wiki/%D0%92%D0%B8%D0%BA%D0%B8%D0%BF%D0%B5%D0%B4%D0%B8%D1%8F:%D0%A4%D0%BE%D1%80%D0%BC%D1%83%D0%BB%D1%8B Википедия:Формулы], but <nowiki><math>...</math></nowiki> does not seem to work. I ask you to consider whether there is any image in [[:Category:Formulas]] already loaded, to avoid duplication of files. Удачной работы! [[User:Adailton|Adailton]] ([[User talk:Adailton|talk]]) 12:56, 3 January 2019 (UTC)

2.4 változat újdonságai

2019-01-03T12:05:52Z

Adailton:

Ez a lista [[Feature Freeze Testing 2.4]]-n és az [[New Features 2.4#Base .2F DBA|oldalon]] alapul.

== Általános ==

*WebDAV-kiszolgálóhoz kapcsolódás HTTPS-en keresztül
*Ikonok importálása az eszköztárak testreszabásához
*Mesterjelszó beállításának lehetősége a Beállítások -> Biztonság panelen
*Figyelmeztetés, ha a dokumentum az új ODF formátumban van
*PDF-dokumentumok: relatív linkek, dokumentumhivatkozások, PDF/A (ISO 19005-1) támogatása
*Mac OS X: Quicktime-támogatás a filmek és zene/hangok lejátszásához
*Mac OS X: a beépített helyesírás ellenőrző használata
*A nyomtatási párbeszédablak használhatóságának javítása
*Szövegdobozok szerkesztése: figyelmeztetés a karakterszám túllépésnél
*DejaVu betűkészlet alapbeállítása a BitStream Vera helyett
*Magyar szinonimaszótár (Szókincstár) [http://hu.openoffice.org/about-downloads.html beépítve a magyar „FSF.hu build”-be], [http://downloads.sourceforge.net/magyarispell/hu_HU-1.3-pack-for_OOo_2.1_or_newer.zip külön is letölthető]
**kb. 200 szinonimahalmaz (demó, később ki lesz bővítve)
**névnaptár (egy hh-nn formátumú dátum „szinonimái” az arra a napra eső névnapok, egy név „szinomimái” a névnapjának dátuma és az ezen a napon ünnepelt többi név)
**görög betűk (alfa↔α,A; béta↔β,Β stb.)
**írásjelek (,↔vessző stb.)
*Hitelesített, 1.3-as kiadású helyesírási szótár. A szótár nagyobb része, mintegy 45 ezer tőszó ellenőrizve lett. [http://magyarispell.sf.net/ Bővebben...] – [http://hu.openoffice.org/about-downloads.html beépítve a magyar „FSF.hu build”-be], [http://downloads.sourceforge.net/magyarispell/hu_HU-1.3-pack-for_OOo_2.1_or_newer.zip külön is letölthető]

== Base ==
*A numeric(n) javított interpretálása jdbc/oracle esetében
*Tábla másolásakor a tábla nevének könnyebb kiválasztása
*HSQLDB esetében a nézetek szerkeszthetők
*Listapanel SQL-tulajdonságainál használható a Lekérdezéstervező
*SQL-nézetben lekérdezéstervező
*A Relaciótervező használható MySQL-adatbázisoknál is
*Űrlapon kötelezően megadandó mezők kitöltése ellenőrizhető
*Access 2007 (accdb fájl) támogatása

== Calc ==
*Szövegből oszlop átalakító / CSV adatot a cellából közvetlenül átalakítja oszloppá
*Oszlop/sor mozgatás a munkalapon belül adatfelülírás nélkül
*Az Enter lenyomásakor a kurzor visszatér abba az oszlopba, ahol az adatbevitel elkezdődött (a sorban egymás után bevitt adatoknál)
*Képletbevitel: „+” és „-” is használható a kezdésnél, nem csak az „=”
*Munkalaponkénti nagyíthatóság
*Automatikus szűrő: világosabb csoportosítás, más oszlopok csoportosítási eredményeire alapozva
*Adattündér: Kézi sorbarendezés / Dupla kattintás az Adattündér cellájára, visszaadja e cellának a kiszámolt adatait
*Teljesítményjavulás a VLOOKUP és a MATCH függvényeknél
*Nyomtatás párbeszédablak egyszerűbb kezelése
*Nyomtatási kép: PageUp és a PageDown billentyűk használhatók
*A cella-hiperhivatkozásoknál a munkalapok átnevezése pontos

== Chart ==
*Regressziós görbék: az egyenlet és az R² érték mutatása
*Fordított értékek a tengelyeken
*Különböző tengelyekhez tartozó oszlopok egymás mellett
*Adatcímke: Számformátum, pontosság és % beállítható
*Adatpontcímke: érték és százalék egyidejű mutatása
*Adatcímke: minden egyes rész külön vonalon
*Adatcímke: címkék rugalmasabb elhelyezése
*Címkék a tortadiagramon: átfedés elkerülése
*Adatpont címke: törlés gombbal eltávolítható

== Draw ==
*Bejárási sorrend (tabulátorral) az oldal objektumaira
*PDF export: az oldalnevek mint könyvjelzők
*A bonyolultság csökkentése: a többé nem szükséges kijelzési lehetőségek eltávolítása

== Impress ==
*Bejárási sorrend (tabulátorral) az oldal objektumaira
*Diaátmenetek: izgalmas 3D hatások
*PDF export: az oldalnevek mint könyvjelzők
*Háttérkép: egyszerűbb beillesztés

== Writer ==
*Négyszög alakú szövegrész kiválasztása (táblázat)
*Keresés és csere: visszahivatkozások a reguláris kifejezéseknél
*Helyesírás-ellenőrzés: egyszerűbb nyelvkiválasztás
*Beillesztés és Objektumok beillesztése eszköztár újratervezése
*Rejtett szöveg kinyomtatása kiválasztható
*Helykitöltő kinyomtatása kiválasztható
*Gyorsbillentyű a Címsor4, Címsor5 és a Szövegtörzs bekezdésstílusokhoz
*Ctrl+kattintás a hiperhivatkozásokra megváltoztatható
*Egyedi dokumentumtulajdonságok: Szövegmezők és felhasználói felület

== Kiterjesztések / programozhatóság / API ==
*Kiterjeszthető súgórendszer a kiterjesztések számára
*A kiterjesztésnek lehet külön kijelzett neve
*Kiterjesztések: webalapú frissítések támogatása
*Kiterjesztések: kiegészítő információk a kiadóról és a kiadási információkról
*Kiterjesztések: frissítések keresése
*Párbeszédablakok háttérképpel
*Átlátszó háttér a vezérlőelemekhez
*Bemutatók távvezérelhetősége az API-n keresztül
*API: a Base ablakában, a kijelölt táblák, lekérdezések, űrlapok, jelentések megjelölése

[[Category:Magyar]]

2.4 Japanese Translation and Checking

2019-01-03T12:01:26Z

Adailton:

== 2.4翻訳概要　==
* [[Translation for 2.4]]

-- 翻訳スケジュール --

* '''第1ラウンド'''
翻訳開始: 9月27日 
翻訳納期:10月29日正午（中央ヨーロッパ標準時） 
翻訳分量:
GUI（ユーザーインターフェース）約700ワード、
Help（ヘルプ）約9,000ワード

* '''第2ラウンド'''
翻訳開始:11月22日 
翻訳納期:12月13日正午（中央ヨーロッパ標準時） 
翻訳分量:未定

-- 2.4リリーススケジュール --

* [[OOoRelease24]]
* 2007年11月15日: UIおよびFeatureフリーズ
* 2007年11月22日: 2.4翻訳第2ラウンドスタート
* 2007年12月13日: 翻訳納期
* 2007年12月20日: TCM l10n テスト
* 2008年01月17日: コードフリーズ
* 2008年02月07日: 最終フィクスCWS統合
* 2008年02月21日: 全言語リリース候補
* 2008年03月04日: OpenOffice.org 2.4 リリース

== 日本語プロジェクト（第1ラウンドのとりくみ）==
* 日本語 Language Support:斎藤Reiko
* 日本語 Engineering Support:石村Naoyuki
* 日本語プロジェクトリード:中田Maho
* 日本語翻訳コーディネータ:平野Khirano
* 翻訳者
** 1.t_otsuki: Takeshi Otsuki, 大槻武志
** 2.surinrin: Toshie Abe, 阿部敏江
** 3.kiryu: KIRYU Y., 桐生康生
** 4.khirano: Kazunari Hirano, 平野一成

-- 9月14日、l10nプロジェクトリード Rafaella 翻訳スケジュール発表 --
* http://l10n.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=8072

-- 9月25日、斎藤さんより日本語プロジェクトに呼びかけ --
* http://ja.openoffice.org/servlets/ReadMsg?list=translate&msgNo=2985

-- 9月26日、日本語プロジェクト参加表明
* http://l10n.openoffice.org/servlets/ReadMsg?listName=dev&msgNo=8091

-- 10月1日、石村さん、翻訳対象ファイルをIssueにアップ
* http://www.openoffice.org/issues/show_bug.cgi?id=82122
* chartのヘルプ:1460ワード、impressのヘルプ:1058ワード

-- 翻訳者4人をChartチーム2人とImpressチーム2人に分け翻訳作業
* Chartチーム（桐生、阿部）:使用ツール[OmegaT]、作業ファイル[.po]
* Impressチーム（大槻、平野）:使用ツール[エディタ, Calc]、作業ファイル[.sdf]

-- OmegaTエキスパート(Jean-Christophe Helary)サポート
* 翻訳結果POファイルの特定:OmegaTのプロジェクトの/target/にあるPOファイル

-- 翻訳完了-->査読-->GSIチェック-->最終版 --

* Chartチーム
** 10月25日翻訳完了Issueにアップ
** 10月26日GSIチェック（斎藤）、査読完了（斎藤）、査読結果コメント了解（桐生）
** 10月29日最終版アップ（斎藤）
** http://www.openoffice.org/issues/show_bug.cgi?id=83030

* Impressチーム
** 10月22日翻訳完了Issueにアップ
** 10月25日査読完了（斎藤）、GSIチェック（斎藤）
** 10月25,26日GSIエラー修正Issueにアップ
** 10月26日GSIチェックおよびエラー修正（石村）、査読結果コメント了解（大槻、平野）
** 10月29日最終版アップ（斎藤）
** http://www.openoffice.org/issues/show_bug.cgi?id=83030

-- 翻訳完了、delivery告知 --
* http://l10n.openoffice.org/servlets/ReadMsg?list=dev&msgNo=8255
[[Category:JA]]

Template:Mac

2019-01-02T20:36:25Z

Adailton: fusion of history

<noinclude>{{doc}}
[[Category:Formatting templates]]
</noinclude><includeonly><div style="padding:3pt; border: 1px solid #ddd; border-left: 10px solid #ddd; margin-top: 10pt; margin-bottom: 10pt;">
{|border=0 style="background-color:inherit!important" cellpadding=3 cellspacing=0
|-
|valign="top" |[[image:documentation Mac Logo 40.png|40px]]||{{{1}}}
|}
</div></includeonly>

Template:Mac

2019-01-02T20:35:32Z

Adailton: Adailton moveu a página Template:Documentation/OSX para Template:Mac sem deixar um redirecionamento: fusion of history

Category:Multilingual templates PT

2019-01-02T18:04:47Z

Adailton: +cat

[[Category:Multilingual_templates]]
[[Category:PT]]
[[Category:PT-BR]]

User talk:Myfiuver

2019-01-02T16:08:15Z

Adailton: -cat

{{Note|
== برای دیدن قوانین ترجمه عمومی(غیر تخصصی) این لینک را مشاهده کنید ==
[[OOo Wiki Contribution Rules]]
}}
<section begin=translating />

== در اینجا یک سری راهنمایی برای ترجمه وجود دارد ==
* در صورت امکان، ساختاری مشابه ساختار اصلی دنبال شود.
* در صورت امکان، نام صفحات ویکی ترجمه نشود بلکه از <tt><nowiki>{{DISPLAYTITLE:Page title}}</nowiki></tt> استفاده شود برای بومی سازی نام صفحه. با استفاده از نام همان صفحه این کار را برای شناسایی آسان تر صفحات ترجمه شده انجام می دهد و به صورت خودکار از یک صفحه را به دیگری پیوند می خورد
* استفاده از ساختار نامگذاری صفحات وب که به وضوح زبان صفحه را نشان می دهد. به عنوان مثال ، نسخه سوئدی صفحه می تواند به صورت <tt>SV/Pagename/</tt>. مشاهده کنید [[Help:Page naming]]
{{Note|در صورت امکان همیشه سعی کنید از ساختار برای کدهای زبان ایزو استفاده کنید.}}
* با انجمن های L10N و NLC ارتباط برقرار کنید وا جازه بدهید به آنها که بدانند شما چکار می کنید.

* اگر شک کردید سوال بپرسید. مستندات موجود و انجمن های NLC برای کمک به شما هستند

The OpenOffice.org L10N community is working on a [[L10n_Wiki Process for Documentation|process and toolset for translating Wiki pages]].

=== مراحل ترجمه===
در اینجا ابزار و مکانیسمی برای کمک به ترجمه ویکی وجود ندارد. مراحل ترجمه به صورت زیر می باشد.
مراحل ترجمه
# شناخت صفحه ای که قرار است ترجمه شود
#کلیک روی EDIT
# کلیک کردن روی تمام متن ویکی و کپی کردن آن
#کنسل کردن ادیت
# ساخت یک صفحه جیدی با نام مناسب برای مقاله ترجمه شده (see [[Help:Page naming]]).
# کردن متن کپی شده از زبان اصلیPaste
#ذخیره کردن صفحه برای شروع کار خودتان
#ترجمه متن در صفحه ی جدیدی که ساخته شده
<section end=translating />

{| align="right"
| __TOC__
|}
[[ru:RU/l10n/dictionary]]

This page lists spell checker dictionaries, [[hyphenation]] files, and thesauri for OpenOffice.org 2.x.

{{Warn|'''IMPORTANT NOTE: From OpenOffice.org 3.0 on the dictionary wizard is no longer available -- All new dictionaries are now available via [http://extensions.services.openoffice.org/dictionary the Extensions Repository]'''.}}
See [[Extension Dictionaries]] for how to create dictionary extensions. As an end-user this page is now only useful for those using OpenOffice.org < 3.0, though it still has a role for aiding Linux distribution packagers in collecting what un-bundled linguistic extensions are available.

'''To install a new dictionary in Vanilla OpenOffice.org 2.x, call "File -> Wizards -> Install new dictionaries" in OpenOffice.org. Then exit and re-start OpenOffice.org, including the Quickstarter (if used).''' Most of the files on this page are available for installation via the wizard. If not, download the Pack file, and use the "off-line language installation" option of [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/dicooo/DicOOo.sxw DicOOo wizard].

One user notes: If you have the "wrong" dictionary installed and spell check and other features cannot be supported, you will not receive any warning or notification. At best you can type some gibberish and see if it is underlined, if auto-correct is enabled. Download dictionaries (from the new extensions mechanisms detailed below, not the Web site listed in the help), and change settings in the various dialogues (sorry, not sure which one, there are several language related dialogues) until things work again. However, this didn't work for me but if you have the settings of the majority (eg US English) maybe you won't have to bother.

'''OpenOffice.org dictionaries in Fedora.'''
In Fedora to install OpenOffice.org, you can use the "Add/Remove Software" application, or you can do this from the command line with e.g. "yum install openoffice.org-writer". Additional language support can then be installed using something like "yum install openoffice.org-langpack-fr" to install French language support which will automatically include spell-checking support where available. A list of currently installed and available language packs can be seen using "yum list openoffice.org-langpack*". Additional dictionaries can also be installed separately using yum, e.g. yum install hunspell-fr.

'''OpenOffice.org dictionaries wizard in Ubuntu.'''

If the window is too small when using the File>Wizards>Install new dictionaries then make sure visual effects (compiz) are disabled (that is: change from "Extra" or "Normal" to "None" in Ubuntu System | Settings | Appearance | Visual Effect tab).
In order to use this wizard in '''Ubuntu''' (tested on Kubuntu 7.10) you need to have the package '''openoffice.org''' installed in addition to standard installation of open-office.org-writer and open-office.org-calc. You can do this by typing '''sudo apt-get install openoffice.org'''

'''Adding Resources'''

Please use [http://extensions.services.openoffice.org/ the extensions repository] -- the resources listed on this page refer to ftp.services.openoffice.org, which will not be maintained anymore.

'''OpenOffice.org dictionaries in Gentoo.'''

To install a dictionary, execute the following command as root:

emerge myspell-<lang>

Start OpenOffice. Open Tools -> Options -> Language Settings -> Languages. From the drop-down menu under "Default languages for documents" select a language whose dictionary you've installed.--[[User:Dnt2wiki|Dnt2wiki]] 19:33, 30 September 2008 (CEST)

'''Tools for dictionary developers''':
 Spellchecker: [http://hunspell.sourceforge.net Hunspell].
 Hyphenator: [http://sourceforge.net/project/showfiles.php?group_id=143754&package_id=231949 Hyphen].
 Thesaurus: [http://lingucomponent.openoffice.org/MyThes-1.zip OpenOffice.org MyThes].
 Grammar checker: [http://www.languagetool.org LanguageTool], [http://www.afterthedeadline.com/download.slp?platform=OpenOffice After the Deadline] and [http://extensions.services.openoffice.org/project/lightproof Lightproof].

More information on the file formats of dictionaries can be found on the [http://lingucomponent.openoffice.org/ Lingucomponent Project homepage].

== آفریقایی(آفریقای جنوبی)==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/af_ZA.zip Spelling] 2006-01-17
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/af_ZA-pack.zip Pack] 2006-01-17
* [http://translate.org.za/download/spellchecker/afrikaans/ Spelling, Pack, Word lists (Experimental/Development)]

== آمهاریک (اتیوپی)==
* [http://hunspell.sourceforge.net/am-demo.tar.gz Spelling] 2004-12-28

== عربی(جنوب و شرق آفریقا)==
* [http://downloads.sourceforge.net/ayaspell/arabic_tehsaurus0.1-19-12-2009.zip Thesaurus] (theasurus-ar from [http://ayaspell.sourceforge.net/ ayaspell project]) 2009-12-19
* [http://downloads.sourceforge.net/ayaspell/dict_ar.oxt Pack (spelling, thesaurus)] (OpenOffice 3.x extension from [http://ayaspell.sourceforge.net/ ayaspell project]) 2009-12-19
* [http://downloads.sourceforge.net/ayaspell/hunspell-ar_20080110.tar.gz Spelling] (hunspell-ar from [http://ayaspell.sourceforge.net/ ayaspell project]) 2008-01-10
* [ftp://foolab.org/pub/software/arspell/20060329/ar.zip Spelling] (Simple word list) 2006-03-29
* [http://hunspell.sourceforge.net/buckwalter_morphan_1_hunspell_patch.tar.gz Spelling] (Conversion of Buckwalter's Arabic morphological analyser) 2006-02-08

== ارمنی (خاورشرقی)==
* [https://sourceforge.net/projects/armspell/files/myspell-hy/myspell-hy-0.20.0/myspell-hy-0.20.0.tar.gz/download Spelling] ([http://sf.net/projects/armspell Armspell Project], 0.20.0 - 2010-05-05)

==آذربایجانی(آذربایجان و ایران) ==
* [http://hunspell.sourceforge.net/az-demo.tar.gz Spelling] 2004-08-17

== Basque ==
* [http://www.euskara.euskadi.net/r59-738/es/contenidos/informacion/euskarazko_softwarea/es_9568/lista.html Spelling] 2006-10-06 (note: use ANY country code in dictionary.lst, see documentation. anther note: license is absent in the package, so at least some distributions avoid including of this package. Consider adding AUTHORS and License files in this package.)

== بلاروس ==
* [http://pravapis.info/spell/dict/ooo-official.zip Spelling(official orthography)] 2008-11-17
* [http://pravapis.info/spell/dict/ooo-classic.zip Spelling(classic orthography)] 2008-11-17

== بنگالی(بنگلادش وهند) ==
* [http://www.ankur.org.bd/downloads/spell_check/hunspell/hunspell-bn-BD-0.02.tar.bz2 Spelling] (version 0.02) 2008-02-01 ([http://ankur.org.bd/wiki/Documentation#OpenOffice.org ankur.org.bd])

==بلغاری(بلغارستان)==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/dictionaries-bg Extension]
* [http://sourceforge.net/project/showfiles.php?group_id=52198 Spelling] 2007-12-11
* [http://sourceforge.net/project/showfiles.php?group_id=52198 Hyphenation] 2007-12-11
* [http://sourceforge.net/project/showfiles.php?group_id=52198 Thesaurus] 2007-12-11

== کاتالون ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ca_ES.zip Spelling] 2002-10-15
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ca_ES-pack.zip Pack] 2002-10-15

== مالی) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ny_MW.zip Spelling] 2005-01-08

== Coptic (North Africa) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/copt_dict Extension]
* [http://www.moheb.de/coptic_proofing.html Spelling] 2006-05-29

== قبطی(شمال آفریقا)==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hr_HR.zip Spelling] 2006-06-07
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hr_HR-pack.zip Pack] 2006-06-07

==چکی(جمهوری چک)==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/cs_CZ.zip Spelling] 2003-01-01
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_cs_CZ.zip Hyphenation] 2003-12-27
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_cs_CZ.zip Thesaurus] (for OpenOffice.org 1.x) 2004-08-20
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_cs_CZ_v2.zip Thesaurus] (for OpenOffice.org 2.x) 2007-09-26
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/cs_CZ-pack.zip Pack] 2004-08-20

==دانمارک==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_da_DK.zip Hyphenation] 2007-09-03
* [http://www.stavekontrolden.dk Pack] 2008-02-20
== هلند==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nl_NL.zip Spelling] 2007-06-07 (OpenTaal 1.00G) Note: this is not the [http://extensions.services.openoffice.org/project/dict-nl latest version]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_nl_NL.zip Hyphenation] 2005-06-17
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nl_NL-pack.zip Pack] 2005-07-20 (contains older spelling dictionary)

==انگلیسی==
''For an up-to-data list of available English spelling dictionaries please see [http://misc.aspell.net/wiki/English_Dictionaries misc.aspell.net/wiki/English_Dictionaries]''
* Spelling:

** [http://en-gb.pyxidium.co.uk/dictionary/en_GB.zip English (United Kingdom)] 2006-11-30
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_US.zip English (United States)] 2006-02-07
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_AU.zip English (Australia)] 2003-03-29 by Kelvin Eldridge (Australian dictionary creator and maintainer). Latest dictionary (2008-12-18) available from Kelvin's site [http://www.JustLocal.com.au www.JustLocal.com.au]. Scroll to the bottom of the page and click on Australian spell check dictionary files. Also OpenOffice.org 3 version. Commercial software fee payable.
** [http://chenopod.net/dnw/en_AU.zip English (Australia)] 2008-09-25 (OpenSource, no charge, updated 2 Oct. 2008)
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_CA.zip English (Canada)] 2002-03-15
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_NZ.zip English (New Zealand)] 2002-05-18
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_ZA.zip English (South Africa)] 2006-01-20
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_GB-oed.zip English (OED English)] 2005-06-13
* Hyphenation:
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_en_GB.zip English (United Kingdom)] 2002-07-27
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_en_US.zip English (United States)] 2002-07-27
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_en_CA.zip English (Canada)] 2002-07-27
* Thesaurus:
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_en_US_v2.zip English (United States & United Kingdom)], requires OpenOffice.org 2.x or later, 2006-03-06
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/en_EN-pack.zip Pack] 2003-11-05
==زبان بین المللی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/eo.zip Spelling] 2004-11-29
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/eo-pack.zip Pack] 2004-11-29

== استونی==
* [http://www.meso.ee/~jjpp/speller Spelling] 2003-06-02
* [http://www.meso.ee/~jjpp/speller Hyphenator]

==ایسلند==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fo_FO.zip Spelling] 2005-03-07
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fo_FO-pack.zip Pack] 2005-01-15

==فارسی==
*[http://hunspell.sourceforge.net/fa-demo.tar.gz Spelling] 2005-07-26

==فیچی ==
* [http://www.iosn.net/pacific-islands/usp-microgrants/fijian-spellchecker See iosn.net] 2005-08-11

==فلاند==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fi_FI.zip Spelling] 2002-11-20
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_fi_FI.zip Hyphenation] 2004-04-10
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fi_FI-pack.zip Pack] 2004-04-11

'''NOTE: Hunspell is not capable of handling Finnish language properly, so these dictionaries should not be used. Instead, [http://voikko.sourceforge.net/ Voikko] project should be used, either via [http://www.abisource.com/projects/enchant/ Enchant] (a recommended spell-checking library for any project, supports also hunspell) or directly in OOo via openoffice.org-voikko provided by the project also.'''

==فرانسه==

'''[http://www.dicollecte.org/ The French project: Dicollecte]'''

About the French spelling reform of 1990, please read:
- [http://en.wikipedia.org/wiki/Reforms_of_French_orthography#The_rectifications_of_1990 Reforms of French orthography (en)]
- [http://www.renouvo.org/regles.php Réforme de l’orthographe (fr)]
- [http://www.orthographe-recommandee.info/index.htm Orthographe recommandée (fr)]

'''OpenOffice.org 3.x extensions''':
* [http://extensions.services.openoffice.org/project/french-dictionary-classic-reform1990 Classic & Reform 1990 Spelling ]
* [http://extensions.services.openoffice.org/project/french-dictionary-classic Classic Spelling]
* [http://extensions.services.openoffice.org/project/french-dictionary-reform1990 Reform 1990 Spelling]

'''OpenOffice.org 2.x''':
* [http://www.dicollecte.org/download.php?prj=fr Latest dictionaries]
* You can also get them in OOo with Menu File -> Wizards -> Install new dictionaries

==فرانسه(هلند)==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fy_NL.zip Spelling] (version 0.12) 2007-11-28
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/fy_NL-pack.zip Pack] (version 0.11) 2007-02-22

==ایتالیا==
* [http://digilander.libero.it/paganf/coretors/myspell-fur-12092005.zip Spelling] 2005-09-12 [http://digilander.libero.it/paganf/coretors/dizionaris.html home page]
* [http://fur.openoffice.org/ Pagine ufficial progjet - Open Office par furlan ]

* [http://extensions.services.openoffice.org/en/node/4080 Open office extension - Coretôr ortografic par furlan ]



==اسپانیایی==

Made by Frco. Javier Rial in [http://www.mancomun.org Mancomun.org]

* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gl_ES.zip Spelling] 2008-05-16 Hunspell version.
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gl_ES-pack.zip Pack] 2008-05-16 Hunspell version.

* [http://extensions.services.openoffice.org/project/Extension_Corrector_galego_OOo Extensión co corrector de Hunspell para o OpenOffice.org 3] (2008-05-15).

* [http://extensions.services.openoffice.org/project/Extension_Guionizador_galego_OOo Extensión co guionizador para o OpenOffice.org 3] (2009-02-09).

==گاسکن فرانسه==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gsc_FR.zip Spelling] 2007-08-16 Contributed by [http://www.pernoste.com Per Noste]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gsc_FR-pack.zip Pack] 2007-08-16

Requires OOo 2.1 or later

==آلمانی==
* '''OpenOffice.org 3.x Extensions (Spelling dictionaries, Hyphenation, Thesaurus)''':
** [http://extensions.services.openoffice.org/project/dict-de_DE_frami Extension "German (de-DE-frami) dictionaries: spell checking, hyphenation, thesaurus" for locale Germany de-DE] (recommended), by Franz Michael Baumann, an extended version of Björn Jacke's dictionary, 2010-05-25
** [http://extensions.services.openoffice.org/project/dict-de_CH_frami Extension "German (de-CH-frami) dictionaries: spell checking, hyphenation, thesaurus" for locale Switzerland de-CH] (recommended), by Franz Michael Baumann, an extended version of Björn Jacke's dictionary, 2010-05-25
** [http://extensions.services.openoffice.org/project/dict-de_AT_frami Extension "German (de-AT-frami) dictionaries: spell checking, hyphenation, thesaurus" for locale Austria de-AT] (recommended), by Franz Michael Baumann, an extended version of Björn Jacke's dictionary, 2010-05-25
** [http://extensions.services.openoffice.org/project/dict-de Extension "German dictionary, hyphenation patterns and thesaurus" for locales de-DE, de-AT and de-CH], by Björn Jacke, 2008-07-09
* '''OpenOffice.org 3.x Extensions (Supplementary spelling dictionaries for special use/subjects)''':
** [http://extensions.services.openoffice.org/de/project/DFEW Extension Deutsches Fachspezifisches Ergänzungswörterbuch German Specialist Supplemental Dictionary] (recommended), by Vladyslav Shtabovenko, supplementary dictionary containing only words that are missing in de-frami, 2009-09-07
** [http://extensions.services.openoffice.org/de/project/philo_dic_DE Extension Philosophical spell-check dictionary for German] (recommended for philosophical terms), by Jan Schreiber, 2008-11-27
* '''OpenOffice.org 3.x Extension Thesaurus'''
** Daily snapshot of [http://www.openthesaurus.de/about/download OpenThesaurus]
* '''Old spelling dictionaries, hyphenation, thesaurus (outdated)''':
** ''Spelling Dictionaries:'' The new orthography dictionary with compound word support is shipped with OpenOffice.org since version 2.0.2. Its quality currently suffers from OpenOffice.org [http://qa.openoffice.org/issues/show_bug.cgi?id=64400 issue 64400].
*** Recommended version (requires OpenOffice.org 2.0.2 or later):
**** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_DE_frami.zip German (Germany], [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_CH_frami.zip Switzerland], [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_AT_frami.zip Austria]) by Franz Michael Baumann, an extended version of Björn Jacke's dictionary, 2009-02-21
*** Others versions:
**** [http://www.j3e.de/hunspell/ German (Germany, Switzerland, Austria)] by [http://www.j3e.de/ Björn Jacke] latest snapshots of the hunspell dictionary derived from [http://www.j3e.de/ispell/igerman98/ igerman98], requires OpenOffice.org 2.0.2 or later
**** [http://www.j3e.de/myspell/ German (Germany)] by [http://www.j3e.de Björn Jacke] This is a dictionary in myspell format used up to OpenOffice.org 2.0.1, 2003-06-17
**** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_DE_comb.zip German (Germany - mit Komposita, alte & neue Rechtschreibung gemischt)] by [http://tkltrans.sourceforge.net/spell.htm Eleonora] This is a dictionary in myspell format used up to OpenOffice.org 2.0.1, 2005-06-10
**** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_DE_neu.zip German (Germany - mit Komposita, neue Rechtschreibung)] by [http://tkltrans.sourceforge.net/spell.htm Eleonora] This is a dictionary in myspell format used up to OpenOffice.org 2.0.1, 2005-06-10
** ''Hyphenation:''
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_de_DE.zip German (Germany)] 2006-01-20
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_de_CH.zip German (Switzerland)] 2006-01-20
** ''Thesaurus'':
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_de_DE_v2.zip German (Germany)], requires OpenOffice.org 2.x or later, 2008-01-05
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_de_CH_v2.zip German (Switzerland)], requires OpenOffice.org 2.x or later, 2008-01-05
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/de_DE-pack.zip ''Pack''] 2005-11-02

==یونانی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/el_GR.zip Spelling] 2004-12-20
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_el_GR.zip Hyphenation] 2005-10-18
* [http://www.ellak.gr/pub/oo_extras/th_el.zip Thesaurus] 2007-04-12
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/el_GR-pack.zip Pack] 2004-09-01

==هندی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gu_IN.zip Spelling] 2006-10-15

==آمریکایی==
* [https://addons.mozilla.org/en-US/firefox/addon/204309/ Spelling] 2009-04-06

==اسرائیلی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/he_IL.zip Spelling] 2005-01-12

==هندی==
* [http://hunspell.sourceforge.net/hi-demo.tar.gz Spelling] 2005-01-27
* [http://devendraparakh.port5.com/ HindiWriter] includes a Hindi Spell Checker(engine and dictionary) that works with OpenOffice.org 2.0 for Windows.
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hi_IN.zip Pack] 2007-02-19

==مجارستانی==
* Extensions:
** [http://extensions.services.openoffice.org/project/hu_dicts Hungarian Dictionary Pack] for OpenOffice 3.0 or later. Contains Hungarian spellchecking dictionary, hyphenation patterns & thesaurus.
** [http://extensions.services.openoffice.org/project/lightproof Lightproof] grammar checker (Hungarian rules are included)
* Spelling:
** [http://dfn.dl.sourceforge.net/project/magyarispell/Magyar%20Ispell/1.5/hu_HU-1.5.tar.gz Magyar Ispell v1.5] requires OpenOffice.org 2.1 or later, 2009-09-18. [http://magyarispell.sourceforge.net Magyar Ispell dictionary]. [[Magyar Ispell hibabejelentés|Bug report page]].
** [http://tkltrans.sourceforge.net/tklspell/hu_HU_comb.zip Hungarian_2] requires OpenOffice.org 2.0.2 or later, 2006-11-05. This dictionary contains around 700 thousand manually collected compound words.
** [http://downloads.sourceforge.net/magyarispell/hu_HU-0.99.4.zip Hungarian] compatible with MySpell 2004-04-02
* [http://downloads.sourceforge.net/magyarispell/hyph_hu.zip Hyphenation] 2006-12-13
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_hu_HU.zip Thesaurus] 2003-09-29, NOTE: works with OpenOffice.org 1.x only!
* Pack:
** [http://downloads.sourceforge.net/magyarispell/hu_HU-1.3-pack.zip Pack] requires OpenOffice.org 2.0.2 or later, 2008-03-15
** [http://downloads.sourceforge.net/magyarispell/hu_HU-1.3-pack-for_OOo_2.1_or_newer.zip Pack] requires OpenOffice.org 2.1 or later (for Unicode non-standard hyphenation) 2008-03-15
** [http://downloads.sourceforge.net/magyarispell/hu_HU-0.99.4-pack.zip Pack] 2004-04-02

==ایسلندی==
* [http://hunspell.sourceforge.net/is_IS.zip Spelling] 2006-09-28
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_is_IS.zip Hyphenation] 2003-09-20
* [http://hunspell.sourceforge.net/is_IS-pack.zip Pack] 2006-09-28

==اندونزایی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/id_ID.zip Spelling] 2004-08-12 (NOTE: relicensed under GPL/LGPL/MPL tri-license, see https://addons.mozilla.org/en-US/firefox/addon/6818)
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_id_ID.zip Hyphenation] 2004-08-12
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/id_ID-pack.zip Pack] 2004-08-12

== Interlingua (x-register) ==

* [http://download.savannah.nongnu.org/releases/interlingua/ia_myspell.zip Spelling] 2005-01-01
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_ia.zip Hyphenation] 2005-03-07
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ia-pack.zip Pack] 2003-08-07

==ایرلندی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ga_IE.zip Spelling] (version 4.3) 2007-10-29 [http://borel.slu.edu/ispell/index.html home page]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_ga_IE.zip Hyphenation] (version 1.0) 2004-02-20 [http://borel.slu.edu/fleiscin/index.html home page]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_ga_IE_v2.zip Thesaurus] (version 1.001) 2007-10-01 [http://borel.slu.edu/lsg/index.html home page]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ga_IE-pack.zip Pack] 2006-07-31

==ایتالیایی==
You can find how to install Italian dictionaries in the dictionary home page (Italian language only).

Per sapere come fare ad installare i dizionari qui sotto riportati andare all'home page dello strumento linguistico desiderato (solo in lingua italiana).

* '''Spelling''':
** [http://prdownloads.sf.net/linguistico/italiano_2_4_2007_09_01.zip?download Italian dictionary (dizionario italiano)] (2.4 2007-09-01) [http://linguistico.sf.net/wiki/doku.php?id=dizionario_italiano home page]
** [http://prdownloads.sf.net/linguistico/cognomi_italiani_03_01__2009_06_26.zip?download Italian surname dictionary (dizionario dei cognomi italiani)] (3.01 2009-06-26) [http://linguistico.sf.net/wiki/doku.php?id=dizionario_cognomi_italiani home page]

* '''Hyphenation''':
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_it_IT.zip Hyphenation] 2007-11-27

* '''Thesaurus''':
** [http://downloads.sf.net/linguistico/thesaurus2_it_02_09_l_2008_11_29.zip?download Thesaurus OOo 2.x] (2.09.l 2008-11-29) - only for OpenOffice.org >= 2.0 [http://linguistico.sf.net/wiki/doku.php?id=thesaurus_italiano home page]
** [http://prdownloads.sf.net/linguistico/thesaurus_it_01_00_2005_07_26.zip?download Thesaurus OOo 1.1.x] (1.00 2005-07-26) - only for OpenOffice.org 1.1.x [http://linguistico.sf.net/wiki/doku.php?id=thesaurus_italiano home page]
*** [http://prdownloads.sf.net/linguistico/thesaurus_it_01_00_2005_07_26_src.zip?download Thesaurus source] (1.00 2005-07-26) - only for OOo 1.1.x [http://linguistico.sf.net/wiki/doku.php?id=thesaurus_italiano home page]
*** [http://prdownloads.sf.net/linguistico/thescoder-0.6.zip?download ThesCoder 0.60], program to make the OOo 1.1.x thesaurus binary [http://linguistico.sf.net/wiki/doku.php?id=thescoder home page]

* '''Extensions''':
** [http://prdownloads.sf.net/linguistico/Dizionari.IT_20081129.oxt?download Estensione Dizionario IT] (20081129 2008-11-29) - only for OOo >= 3.0 [http://linguistico.sf.net/wiki/doku.php?id=estensione:estensione_dizionario_it home page]
** [http://prdownloads.sf.net/linguistico/Cognomi.IT_20090626.oxt?download Estensione Cognomi IT] (20090626 2009-06-26) - only for OOo >= 3.0 [http://linguistico.sf.net/wiki/doku.php?id=estensione:estensione_cognomi_it home page]

* '''Package''':
** [http://prdownloads.sf.net/linguistico/it_IT-OOo2-pack_01_07__2008_11_29.zip?download Pack OOo 2.x] (01.07 2008-11-29) - only for OOo >= 2.0 [http://linguistico.sf.net/wiki/doku.php?id=pacchetto_strumenti_linguistici home page]
** [http://prdownloads.sf.net/linguistico/it_IT-OOo1-pack_1_1_beta_2006_07_23.zip?download Pack OOo 1.1.x] (1.1 beta 2006-07-23) - only for OOo 1.1.x [http://linguistico.sf.net/wiki/doku.php?id=pacchetto_strumenti_linguistici home page]



== لهستان ==
* [http://hunspell.sourceforge.net/csb-demo.tar.gz Spelling] 2005-03-04

== Khmer (Cambodia) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/en/project/khmersbbic SBBIC Khmer Spelling Checker Extension]
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/km_spellchecker KhmerOS Extension]

==روندا==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/rw_RW.zip Spelling] 2005-01-08

==کیسوالی(شرق آفریقا)==
* [http://www.it46.se/downloads/openoffice/dictionary/dictionary_myspell_sw_TZ_1.1.tar.gz Spelling] (extended word list) 2005-08-19
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/sw_KE.zip Spelling] 2004-05-16
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/sw_KE-pack.zip Pack] 2004-05-16

== کره ای ==
* [http://code.google.com/p/spellcheck-ko/ Korean Spellchecker Project Home]
* [http://extensions.services.openoffice.org/project/spellchecker-ko Korean Spellchecker extension for OpenOffice.org]

==کردی(ترکیه سوریه)==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ku_TR.zip Spelling] 2005-01-21
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ku-pack.zip Pack] 2005-01-21

==لاتین==
* Spelling:

**[http://www.drouizig.org/Saozneg/Misc/misc-Latinspellchecker.html COL1.0ß] 2006-01-27 by Marjorie Burghart
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/la-pack.zip Pack] 2002-05-05

== خلیج ریگا (Latvia) ==
* [ftp://ftp.stardiv.de/pub/OpenOffice.org/contrib/dictionaries/lv_LV.zip Spelling] v.0.8b1 2009-05-09

== خلیج کنگو==
* [http://softlayer.dl.sourceforge.net/sourceforge/lingala/ln_CD.zip Spelling] 2009-04-03

== Lithuanian (Lithuania) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/lt_LT.zip Spelling] 2003-12-31
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_lt_LT.zip Hyphenation] 2004-01-10
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/lt_LT-pack.zip Pack] 2004-04-05

==لوگزامبورگ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/lb-dict Extension]
* [http://www.spellchecker.lu/ Spellchecker.lu] Project Website, in Luxembourgish
* [http://downloads.spellchecker.lu/packages/OOo2/ OOo2 Pack] Notes: updated regularly, needs OOo >= 2.0.2
* [http://downloads.spellchecker.lu/packages/OOo3/ OOo3 Extension] Notes: updated regularly

==ماداگاسکار==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/mg_MG.zip Spelling] 2005-01-09

==مالزیایی==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ms_MY.zip Spelling] 2005-01-17
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ms_MY-pack.zip Pack] 2005-01-17

== Māori (Aotearoa) ==
[http://papakupu.maori.nz/ Te Papakupu Māori] should be considered the source for Māori dictionaries from now on.
The following packages are being auto-generated:
* [http://packages.papakupu.maori.nz/hunspell/ Spelling] dictionary for Hunspell, includes regional dialects.
* [http://packages.papakupu.maori.nz/hunspell-hyphen/ Hyphenation] rules for Hunspells' Hyphen.
* [http://packages.papakupu.maori.nz/mythes/ Thesaurus] for MyThes.
* [http://packages.papakupu.maori.nz/openoffice2/ OpenOffice.org 2 Pack] includes spelling dictionary, no regional dialects. Beta version also includes hyphenation rules and thesaurus.
* [http://extensions.services.openoffice.org/project/maori-papakupu OpenOffice.org 3 Extension] includes spelling dictionary, hyphenation rules, and thesaurus, no regional dialects.
* [http://packages.papakupu.maori.nz/ Everything else] For all supported software including the above.

Contact me if you would like tailored packages auto-generated for upstream projects.

-- [[User:Kiharoa|Kiharoa]]

== Macedonian (Former Yugoslav Republic of Macedonia) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/mk_MK.zip Spelling] 2005-11-26

==هندی==
* [http://ftp.stardiv.de/pub/OpenOffice.org/contrib/dictionaries/mr_IN.zip Spelling] 2006-09-26
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/dicooo/mr_IN_pack.zip Pack] 2006-09-26

== Malayalam (India) ==
* [http://ftp.twaren.net/Unix/NonGNU/smc/Spellchecker/ooo-hunspell-ml-0.1.tar.bz2 Spelling] 2008-05-19
* [http://git.savannah.gnu.org/cgit/smc.git/tree/hyphenation Hyphenation] 2008-05-19

==مغولستان==

* [http://www.openoffice.org/issues/show_bug.cgi?id=92263 Spelling] 2008-07-29 (see the attachment)


==Ndebele جنوب آفریقا==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nr_ZA.zip Spelling] 2006-01-20
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nr_ZA-pack.zip Pack] 2006-01-20
* [http://translate.org.za/download/spellchecker/ndebele/ Spelling, Pack, Word lists (Experimental/Development)]

== نپالی ==
* [http://nepalinux.org/downloads/ne_NP_dict.zip Spelling] 2006-10-17
* [http://nepalinux.org/downloads/thes_np_NP_v2.zip Thesaurus] requires OpenOffice.org 2.x or later, 2006-12-20

== Northern Sotho (South Africa) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ns_ZA.zip Spelling] 2006-01-20
* [http://translate.org.za/download/spellchecker/northern_sotho/ Spelling, Pack, Word lists (Experimental/Development)]

== نروژی ==
* Spelling:
** [http://alioth.debian.org/frs/download.php/2357/no_NO-pack2-2.0.10.zip Norwegian Bokmål & Nynorsk (Norway) pack for OOo '''2.x'''] 2008-03-10
** [http://alioth.debian.org/frs/download.php/2358/no_NO-pack1-2.0.10.zip Norwegian Bokmål & Nynorsk (Norway) pack for OOo '''1.x'''] 2008-03-10
** Older versions:
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nb_NO.zip Norwegian Bokmål (Norway)] 2006-05-08
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/nn_NO.zip Norwegian Nynorsk (Norway)] 2006-05-08
*** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/no_NO-pack.zip Pack] 2005-01-12
*** [http://alioth.debian.org/frs/?group_id=30577 All older versions, including sources]

== Occitan (فرانسه) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/oc_FR.zip Spelling (Languedocien)] 2006-09-22

== Oriya ) ==
* [http://hunspell.sourceforge.net/or-demo.tar.gz Spelling] 2005-01-25

== Papiamentu (Netherlands Antilles) ==
* no information yet

== فارسی (Iran) ==
* [http://hunspell.sourceforge.net/fa_IR.tar.bz2 Spelling] 2007-08-16

== Polish (لهستان) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/pl-dict Extension]
* [http://pl.openoffice.org/pliki/pl_PL.zip Spelling] 2006-12-02
* [http://pl.openoffice.org/pliki/hyph_pl_PL.zip Hyphenation] 2006-07-26
* [http://pl.openoffice.org/pliki/thes_pl_PL_v2.zip Thesaurus] requires OpenOffice.org 2.x or later, 2006-12-23
* [http://pl.openoffice.org/pliki/pl_PL-pack.zip Pack] 2006-12-23
* [http://pl.openoffice.org/pliki/thes_pl_PL.zip Thesaurus] only for OpenOffice.org 1.x, 2006-12-23

==پرتغالی(برزیل و پرتغال) ==
* Spelling:
** [http://natura.di.uminho.pt/download/sources/Dictionaries/myspell Portuguese (Portugal)] 2006-10-26
** [http://www.openoffice.org.br/?q=verortografico Portuguese (Brazil)] 2006-10-17
* Hyphenation:
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_pt_PT.zip Portuguese (Portugal)] 2002-10-21
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_pt_BR.zip Portuguese (Brazil)] 2002-10-21
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/pt_PT-pack.zip Pack] 2003-12-30

== Punjabi (هند) ==
* [http://hunspell.sourceforge.net/pa-demo.tar.gz Spelling] 2005-01-25

== Quechua (بولیوی) ==
* [http://hunspell.sourceforge.net/qu_BO-pack.zip Pack] (Spelling) 2007-05-09
== Quichua (اکوادور) ==
* [http://hunspell.sourceforge.net/qu_EC-pack.zip Pack] AWAITING STORAGE (Spelling) 2009-03-02

== Romanian (رومانی) ==

'''''OpenOffice.org 3.x extensions / Extensii OpenOffice.org 3.x:'''''
* [http://extensions.services.openoffice.org/project/dictionaries-ro-contemporary â/sunt]
* [http://extensions.services.openoffice.org/project/dictionaries-ro-classic î/sînt].

'''''Extensii OpenOffice.org 3.x cu sedile (pentru sistemele vechi precum Windows XP):'''''
* [http://downloads.sourceforge.net/rospell/dict-ro-cedilla.1.2.oxt â/sunt]
* [http://downloads.sourceforge.net/rospell/dict-ro-classiccedilla.1.2.oxt î/sînt]

''Toate extensiile cuprind un corector ortografic, un dicționar de sinonime, și un dicționar de despărțire în silabe. În cazul în care se dorește compatibilitatea cu utilizatorii care folosesc platforme cu suport incomplet pentru limba română (precum Windows XP), se recomandă folosirea dicționarelor împreună cu extensia '' [http://extensions.services.openoffice.org/project/RomanianDiacritics Diacritice românești]. ''Această extensie permite introducerea caracterelor diacritice românești și conversia textului dintr-un format de caractere în altul. Suport pentru [http://extensions.services.openoffice.org/project/AutocorrectRomanian autocorectare] este de asemenea disponibil. ''

'''Source Code (latest release):
'''
* [http://downloads.sourceforge.net/rospell/ro_RO.3.3.6.zip Spelling] 2010-11-06
* [http://downloads.sourceforge.net/rospell/hyph_ro_RO.3.3.6.zip Hyphenation] 2010-11-06
* [http://downloads.sourceforge.net/rospell/th_ro_RO.3.3.zip Thesaurus] 2010-01-16

'''Previous releases:
'''
* [http://downloads.sourceforge.net/rospell/ro_RO.3.2.zip Spelling] 2008-07-06
* [http://downloads.sourceforge.net/rospell/ro_RO.3.1.zip Spelling] 2008-04-09
* [http://www.archeus.ro/Download/OpenOffice/CorectorOrtografic/1.1/ro_RO.zip Spelling (Experimental)] 2007-05-12 - see [http://www.archeus.ro/lingvistica/CorectorOrtografic description (romanian)]
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ro_RO.zip Spelling] 2005-02-27
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_ro_RO.zip Hyphenation] 2005-02-21

== Русский (Россия) ==
Русский перевод данной страницы / Russian translation of this page: {{SecTitle|RU/l10n/dictionary}}
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/dict_ru_RU Extension]
OpenOffice.org 2.x:
* Spelling:
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ru_RU.zip Russian (Russia)] 2004-04-06
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ru_RU_ye.zip Russian ye (Russia)] 2003-09-11
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ru_RU_yo.zip Russian yo (Russia)] 2004-04-06
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_ru_RU.zip Hyphenation] 2002-07-27
* [http://download.i-rs.ru/pub/openoffice/dict/thes_ru_RU_v2.zip Thesaurus] 2007-06-13
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ru_RU-pack.zip Pack] 2004-04-06

== Sami ==
* [http://divvun.no/static_files/smi.zip Spelling] 2008-05-23
* [http://divvun.no/static_files/smi-pack.zip Pack] 2008-05-23

== Scottish Gaelic (Scotland) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/gd_GB.zip Spelling] 2005-01-08

== Serbian (Serbia, Republic Srpska) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/dict-sr Extension]
* [http://openoffice.rs/dict-sr/hunspell-sr-20100818.zip Spelling] 2010-08-18
* [http://openoffice.rs/dict-sr/hyphen-sr-20100818.zip Hyphenation] 2010-08-18

Spelling and Hyphenation packages includes both Cyrillic (sr) and Latin (sh) support.

== Setswana (آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/tn_ZA.zip Spelling] 2004-05-16
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/tn_ZA-pack.zip Pack] 2004-05-16
* [http://translate.org.za/download/spellchecker/tswana/myspell-tn_ZA-20060123.zip Spelling (Experimental)] 2006-01-23
* [http://translate.org.za/download/spellchecker/tswana/myspell-pack-tn-ZA-20060123.zip Pack (Experimental)] 2006-01-23
* [http://translate.org.za/download/spellchecker/tswana/ Spelling, Pack, Word lists (Experimental/Development)]

== Sinhala (Sri Lanka) ==
* [http://extensions.services.openoffice.org/project/SinhalaSpellChecker Spelling - Sinhala Spell Checker] by Chamendri Silva
* [http://extensions.services.openoffice.org/en/project/SinhalaUbiquitousSpellChecker Sinhala Ubiquitous Spell Checker] by Faculty of Information Technology, University of Moratuwa, Sri Lanka

== Slovak (اسلواکی) ==

* [http://www.sk-spell.sk.cx/file_download/75/hunspell-sk-20091213.zip Spelling] 2009-12-13 (see [http://www.sk-spell.sk.cx/hunspell-sk hunspell-sk])
* [http://www.sk-spell.sk.cx/thesaurus/download/OOo-Thesaurus2-sk_SK.zip Thesaurus] 2010-09-19 (weekly updated; see: [http://www.sk-spell.sk.cx/thesaurus/ OpenThesaurus-SK - Slovenský synonymický slovník])
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_sk_SK.zip Hyphenation] 2003-12-27
* [http://www.sk-spell.sk.cx/file_download/41/acor_sk-SK.dat Slovak autocorrection] 2008-10-09
* OpenOffice.org 3.x Extensions
** [http://extensions.services.openoffice.org/en/project/dict-sk Slovak dictionary plug-in for OpenOffice.org 3] 2010-09-19
** [http://www.sk-spell.sk.cx/file_download/62/acor_sk.oxt Slovak autocorrection plug-in for OpenOffice.org 3] 2009-02-22

For other information/files please check [http://www.sk-spell.sk.cx/ sk-spell project] or [http://www.sk-spell.sk.cx/openofficeorg-sk openoffice.org-sk]






== Slovenian (اسلوونی) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/sl_SI.zip Spelling] 2007-01-27
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_sl_SI.zip Hyphenation] 2007-01-27
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/sl_SI-pack.zip Pack] 2007-01-27
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/thes_sl_SI_v2.zip Thesaurus] 2008-01-26 ([http://www.tezaver.si experimental - click here for updates])

== Southern Sotho (جنوب آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/st_ZA.zip Spelling] 2006-01-20
* [http://translate.org.za/download/spellchecker/southern_sotho/ Spelling, Pack, Word lists (Experimental/Development)]

== Spanish (اسپانیا و ...) ==
* Spelling:
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/es_ES.zip Spanish (Spain-etal)] 2005-05-10
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/es_MX.zip Spanish (Mexico)] 2005-05-05
** [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/Math_es_ES.zip Math_es_ES] 2004-04-05
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_es_ES.zip Hyphenation] 2004-08-10
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/es_ES-pack.zip Pack] 2005-01-18

For IE7Pro Spellchecker
* [http://erwin.ried.cl/files/articles/_public/esp_ie7pro_2007_04_09.rar Spanish (Spain-etal) Autoinstaller]

== Swazi/Swati (جنوب آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ss_ZA.zip Spelling] 2006-07-05
* [http://translate.org.za/download/spellchecker/swati/ Spelling, Pack, Word lists (Experimental/Development)]

== Swedish (Sweden) ==
'''Senaste versionen''' 
Besök den svenska webbplatsen på: [http://sv.openoffice.org/addons/ sv.openoffice.org]

'''OpenOffice.org 2''' 
[http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_sv_SE.zip Avstavning (Hyphenation)] 2003-08-14

== Tagalog (فیلیپین) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/tl_PH.zip Spelling] 2005-01-08

== Tamil (هند) ==
* [http://hunspell.sourceforge.net/ta-demo.tar.gz Spelling] 2004-08-25

== Tetum (اندونزی) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/tet_ID.zip Spelling] 2005-01-08

== Thai (تایلند) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/th_TH.zip Spelling] 2006-12-12

== Tsonga (جنوب آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ts_ZA.zip Spelling] 2006-01-23
* [http://translate.org.za/download/spellchecker/tsonga/ Spelling, Pack, Word lists (Experimental/Development)]

== Ukrainian (اکراین) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/uk_UA.zip Spelling] 2009-01-25
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/hyph_uk_UA.zip Hyphenation] 2003-09-03
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/uk_UA-pack.zip Pack] 2005-11-06

== Urdu (پاکستان, هند) ==
* [http://ftp.stardiv.de/pub/OpenOffice.org/contrib/dictionaries/ur_PK.zip Spelling] 2007-01-26
also bound to Urdu (India)

== Uzbek (ازبکستان) ==
* [http://hunspell.sourceforge.net/uz-demo.tar.gz Spelling] (Cyrillic) 2005-04-27

== Venda (جنوب آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/ve_ZA.zip Spelling] 2006-07-06
* [http://translate.org.za/download/spellchecker/venda/ Spelling, Pack, Word lists (Experimental/Development)]

== Vietnamese (ویتنام) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/project/Vietnamese_SpellChecker Extension]
* [http://hunspell-spellcheck-vi.googlecode.com/files/vi_VN.zip Spelling] 2008-06-04
* [http://hunspell-spellcheck-vi.googlecode.com/files/PackVietnamese.zip Pack] 2008-06-04
* [http://hunspell-spellcheck-vi.googlecode.com/ Project Forge]

== Wayunaiki (ونزولا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/??_VE.zip Spelling (Experimental/Development)] 2006-??-??

== Welsh (والس) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/cy_GB.zip Spelling] 2004-04-25
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/cy_GB-pack.zip Pack] 2004-04-30

== Xhosa (جنوب آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/xh_ZA.zip Spelling] 2006-01-23
* [http://translate.org.za/download/spellchecker/xhosa/ Spelling, Pack, Word lists (Experimental/Development)]

== Yiddish (International) ==
* OpenOffice.org 3.x [http://extensions.services.openoffice.org/pl/project/jidysz-net-ooo-spellchecker Extension] 2010-09-01

== Zulu (آفریقا) ==
* [http://ftp.services.openoffice.org/pub/OpenOffice.org/contrib/dictionaries/zu_ZA.zip Spelling] 2006-01-20
* [http://translate.org.za/download/spellchecker/zulu/ Spelling, Pack, Word lists (Experimental/Development)]

[[fa:FA/rules/wiki/wiki:Dictionaries|دیکشنری ها]]

== Creation of translated pages ==

Please, make translations of pages in accordance with the rules [[Help:Page_naming]]

When you create a translated page, you do not need to change the URL. You must change only the national prefix. Otherwise you are violating international structure wiki.

I moved the page you created ([[FA/Localization:BASIC Guide]] in the correct URL [[FA/Documentation/BASIC Guide]].

Page [[FA/Localization:BASIC Guide]] is now a redirection. Please do not change it.

--[[User:Sancho|Санчо]] 10:33, 12 March 2011 (UTC)

User:Adailton

2019-01-02T16:01:48Z

Adailton: +ref

{| border="1" class="wikitable sortable"
|+[[Wiki maintenance|Tarefas]]
! Tarefa || Páginas
|-
|[[Special:UncategorizedCategories|Categorias não categorizadas (Uncategorized categories)]]
| style="background:#40ff40;" | 1
|-
|[[Special:UnusedCategories|Categorias não utilizadas (Unused categories)]]
| style="background:#40ff40;" | 23<ref name=correlation-failure>'''''Números afetados por [[User:Adailton/character correlation failure|falha na correlação de caracteres especiais (correlation failure)]]'''''</ref>
|-
|[[Special:WantedCategories|Categorias pedidas (Wanted categories)]]
| style="background:#40ff40;" | 22<ref name=correlation-failure/>
|-
|[[Special:UncategorizedFiles|Arquivos não categorizadas (Uncategorized files)]]
| style="background:#40ff40;" | 85
|-
|[[Special:UncategorizedTemplates|Predefinições não categorizadas (Uncategorized templates)]]
| style="background:#40ff40;" | 0
|-
|[[Special:UnusedTemplates|Predefinições não utilizadas (Unused templates)]]
| style="background:#ffb040;" | 128
|-
|[[Special:WantedTemplates|Predefinições pedidas (Wanted templates)]]
| style="background:#ffb040;" | 63
|-
|[[Special:UncategorizedPages|Páginas não categorizadas (Uncategorized pages)]]
| style="background:#40ff40;" | 1 (?)
|-
|[[Special:DeadendPages|Páginas sem saída (Deadend pages)]]
| style="background:#ff4040;" | 3 377
|-
|[[Special:LonelyPages|Páginas órfãs (Lonely pages)]]
| style="background:#ff4040;" | 1 087
|-
|[[Special:DoubleRedirects|Redirecionamentos duplos (Double redirects)]]
| style="background:#40ff40;" | 0
|-
|[[Special:BrokenRedirects|Redirecionamentos quebrados (Broken redirects)]]
| style="background:#40ff40;" | 0
|-
|[[:Category:Candidates for speedy deletion|Eliminação rápida (speedy deletion)]]
| style="background:#ffb040;" | {{PAGESINCATEGORY:Candidates for speedy deletion}}
|}
<references/>

Category:Candidates for speedy deletion

2019-01-02T15:57:25Z

Adailton:

Articles in this [[Special:Categories|categories]] have been nominated for deletion. The intended way to nominate a page is by addition of the template '''<code><nowiki>{{delete|explanation}}</nowiki></code>'''.

{{note|1='''Sysop note:''' Pages in this category should be processed regularly by sysops, and removed, either by deletion or by removing the template, with an explanation in the action summary. Hence, this category should '''<big>not be deleted</big>''', even if it's empty: it's ''supposed'' to be empty, most of the time.}}

[[Category:Wiki Maintenance]]

Template:Mt/doc

2019-01-02T15:44:35Z

Adailton: +pt

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Для использования на страницах правил оформления вики. Для отметки мультиязычных шаблонов.
|l2=For use on wiki rules. To mark multilingual templates.
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Один обязательный параметр с кодом локали:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
|l2=One required parameter with the code locale:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставляется в начале описания шаблона.
|l2=Inserted at the beginning of the template description.
}}
{{Doc/doc/code/tbl/strL10n
|l1=Параметр шаблона соответствует коду национальной языковой страницы, к которой относится статья, помечаемая данным шаблоном.
|l2=Template parameter corresponds to the national language code page to which the article is marked with the template.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Mt|RU}}
|examp2={{Mt|RU}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Mt|UA}}
|examp2={{Mt|UA}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}

Template:Mt

2019-01-02T15:42:46Z

Adailton: +pt

<noinclude>{{doc}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>

<includeonly>'''{{#switch:{{{1}}}
| RU = Многоязычный шаблон
| UA = Багатомовний шаблон
| EN = Multilingual template
| PT = Modelo multilingue
| #default = Multilingual template
}}'''

{{#switch:{{{1}}}
| RU = Доступные локализации см. На странице шаблона.
| UA = Для наявних локалізацій див. Сторінку шаблону.
| EN = Go to the template page to view available localizations.
| PT = Vá para a [[:Category:Multilingual templates PT|página de modelos]] para ver as localizações disponíveis.
| #default = Go to the template page to view available localizations.
}}

</includeonly>

Template:SpecialPage/doc

2019-01-02T15:38:47Z

Adailton: +cat

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Данный шаблон предназначен для пометки служебных статей.

При применении данного шаблона к статье, ей назначается дополнительная категория [[:Category:Special Page]].
|l2=This template is used to mark special articles.

It puts an article to the additional category [[:Category:Special Page]].
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Один обязательный параметр с кодом локали:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
|l2=One required parameter with the code locale:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставляется в начале статьи перед секцией TOC.
|l2=Inserted at the beginning of the article. Inserted before the section of the "TOC".
}}
{{Doc/doc/code/tbl/strL10n
|l1=Параметр шаблона соответствует коду национальной языковой страницы, к которой относится статья, помечаемая данным шаблоном.
|l2=Template parameter corresponds to the national language code page to which the article is marked with the template.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|SpecialPage|RU}}
|examp2={{SpecialPage|RU|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|SpecialPage|UA}}
|examp2={{SpecialPage|UA|1}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}

Template:SpecialPage/doc

2019-01-02T15:37:15Z

Adailton: +pt

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Данный шаблон предназначен для пометки служебных статей.

При применении данного шаблона к статье, ей назначается дополнительная категория [[:Category:Special_Page]].
|l2=This template is used to mark special articles.

It puts an article to the additional category [[:Category:Special_Page]].
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Один обязательный параметр с кодом локали:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
|l2=One required parameter with the code locale:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставляется в начале статьи перед секцией TOC.
|l2=Inserted at the beginning of the article. Inserted before the section of the "TOC".
}}
{{Doc/doc/code/tbl/strL10n
|l1=Параметр шаблона соответствует коду национальной языковой страницы, к которой относится статья, помечаемая данным шаблоном.
|l2=Template parameter corresponds to the national language code page to which the article is marked with the template.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|SpecialPage|RU}}
|examp2={{SpecialPage|RU|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|SpecialPage|UA}}
|examp2={{SpecialPage|UA|1}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}

Template:SpecialPage

2019-01-02T15:35:36Z

Adailton: +pt

<noinclude>{{doc}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]

</noinclude><includeonly>

<div>

[[image:Special_Page.png|80px]]    '''Служебная страница{{Doc/doc/code/tbl/titleSeparator}}Special Page        '''

</div> {{#switch:{{{1}}}
| RU = Если вы попали сюда случайно, пожалуйста, перейдите на уровень выше:
| UA = Якщо ви потрапили сюди випадково, будь ласка, перейдіть на рівень вище:
| EN = If you got here by accident, please go to the next level:
| PT = Se você chegou aqui por acidente, por favor, vá para o próximo nível:
| #default = Если вы попали сюда случайно, пожалуйста, перейдите на уровень выше:
}} {{SecTitleRel|..}}.

----
 

{{#if: {{{2|}}} | |[[Category:Special Page]]}}
</includeonly>

Template:OOoVersion/doc

2019-01-02T15:31:48Z

Adailton: +pt

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Данный шаблон предназначен для вставки в статью отметки о версии {{OOo}}, к которой относится статья.
|l2=This template is designed to be inserted into the article notes about the version of {{OOo}}, to which the article.
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Два обязательных параметра
# - с кодом локали:
#* '''RU'''
#* '''UA'''
#* '''EN'''
#* '''PT'''
# - номер версии {{AOo}}.
|l2=Two required parameters
# - Locale code:
#* '''RU'''
#* '''UA'''
#* '''EN'''
#* '''PT'''
# - The version number {{AOo}}.
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставить в конце статьи после шаблона подписи автора перед шаблоном подвала.
|l2=Insert at the end of the article after the template author byline and before the template footer.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1={{Tl|SignAll}}
|l2={{Tl|SignAll}}
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|OOoVersion|RU|3.1}}
|examp2={{OOoVersion|RU|3.1}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}

Template:Old/doc

2019-01-02T15:29:51Z

Adailton: +cat

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Данный шаблон предназначен для пометки устаревших статей. При этом все статьи, помеченные данным шаблоном, относятся в специальную категорию [[:Category:Older_articles]].
|l2=This template is intended to mark the outdated articles. In this case all entries marked with a given pattern are in a special category of manuscripts [[:Category:Older_articles]].
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский язык.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Один обязательный параметр с кодом локали:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
|l2=One required parameter with the code locale:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставляется в начале статьи перед секцией TOC.
|l2=Inserted at the beginning of the article. Inserted before the section of the "TOC".
}}
{{Doc/doc/code/tbl/strL10n
|l1=Параметр шаблона соответствует коду национальной языковой страницы, к которой относится статья, помечаемая данным шаблоном.
|l2=Template parameter corresponds to the national language code page to which the article is marked with the template.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Old|EN}}
|examp2={{Old|EN|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Old|RU}}
|examp2={{Old|RU|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Old|PT}}
|examp2={{Old|PT|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|Old|UA}}
|examp2={{Old|UA|1}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}

Template:NeedsRework/doc

2019-01-02T15:28:22Z

Adailton: +pt

<noinclude>{{docpage}}
[[Category:Multilingual templates RU]]
[[Category:Multilingual templates UA]]
[[Category:Multilingual templates EN]]
[[Category:Multilingual templates PT]]
</noinclude>
__NOTOC__
{{Doc/doc/code/tbl/begin
|l1=РУС
}}
{{Doc/doc/code/tbl/titleMission}}
{{Doc/doc/code/tbl/strL10n
|l1=Мультиязычный шаблон.
|l2=Multilingual templates
}}
{{Doc/doc/code/tbl/strL10n
|l1=Отметка для статей, нуждающихся в дополнительной проверке на стилистическое оформление и точность содержания.
|l2=Mark for articles that need to be checked for accuracy and stylistic content.
}}

{{Doc/doc/code/tbl/strL10n
|l1=Имеющиеся локализации:
* '''RU''' - русская;
* '''UA''' - украинская;
* '''EN''' - английская;
* '''PT''' - Португальский.
|l2=Available localizations:
* '''RU''' - Russian;
* '''UA''' - Ukrainian;
* '''EN''' - the English;
* '''PT''' - Português.
}}
{{Doc/doc/code/tbl/titleParameters}}
{{Doc/doc/code/tbl/strL10n
|l1=Один обязательный параметр с кодом локали:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
|l2=One required parameter with the code locale:
* '''RU'''
* '''UA'''
* '''EN'''
* '''PT'''
}}
{{Doc/doc/code/tbl/titleOperationManual}}
{{Doc/doc/code/tbl/strL10n
|l1=Вставляется в начале статьи перед секцией TOC.
|l2=Inserted at the beginning of the article. Inserted before the section of the "TOC".
}}
{{Doc/doc/code/tbl/strL10n
|l1=Параметр шаблона соответствует коду национальной языковой страницы, к которой относится статья, помечаемая данным шаблоном.
|l2=Template parameter corresponds to the national language code page to which the article is marked with the template.
}}
{{Doc/doc/code/tbl/titleParentTemplate}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleSubsidiariesTemplates}}
{{Doc/doc/code/tbl/strL10n
|l1=Нет.
|l2=No.
}}
{{Doc/doc/code/tbl/titleExample}}
{{Doc/doc/code/tbl/exampleBegin}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|NeedsRework|RU}}
|examp2={{NeedsRework|RU|1}}
}}
{{Doc/doc/code/tbl/exampleStrL10n
|examp1={{Tlp|NeedsRework|UA}}
|examp2={{NeedsRework|UA|1}}
}}
{{Doc/doc/code/tbl/exampleEnd}}
{{Doc/doc/code/tbl/end}}