3.0 m16 Snapshot - Release Notes

These notes contains
changes between SRC680_m242 and SRC680_m248 as well as between
DEV300_m1 and DEV300_m16.
This release will install as OOo-Dev3.0.
Sources can be received from cvs by tag DEV300_m16.

feature-info:
Access to the ExtensionListBox has been implemented with the following
methods:
int GetItemCount
String GetItemText Nr1, Nr2 returns the text of Item Nr1 where Nr2
selects the text given: case 1: ItemName case 2: ItemVersion case 3:
ItemDescription
Select String selects the entry that has the item name given in string.
if not found leave selection unchanges and return error
Select Nr selects the Nr-th Item
int GetSelCount always 0 or 1
int GetSelIndex returns 0 if no selection

The user interface of the current Extension Manager
will be changed to
ease the usability with the aim, that each user can work easily with
this UI. Especially the need to differentiate between user extensions
and shared extensions will be eased by an appropriate interface design.

feature-info:
Implemented a strategy to not let the user accidentally overwrite
content of filtered rows by treating a filtered selection similar to
a multi-selection of unfiltered rows, which disables operations not
possible on a multi-selection, like cut, fill, merge. Exceptions
respectively special treatment are:
- Deletion. It was already implemented to not delete filtered rows or
cells. No change.
- Copy filtered to clipboard. Same behavior as before, range is copied
to the clipboard including filtered rows, that when pasted or
transfered to other applications are excluded and only unfiltered rows
are pasted.
- Paste from clipboard to filtered. Clipboard content is sliced and
distributed over unfiltered rows. If formulas are pasted, the
references are updated individually for each slice. The behavior
otherwise is the same as for pasting on a non-filtered range, including
cases of a possibly marked selection being larger or smaller than the
clipboard content.
Overview of menu entries and operations:
Working with multi-selection, taking filtered into account if area
selected:
- Edit - delete contents - delete cells
- Format - cells - borders applies borders only to first contiguous
area
- delete rows (also columns, but that deletes all rows of the column of
course)
Not working with multi-selection, but taking filtered into account if
area selected:
- Edit - copy - paste - paste special
- input auto sum via icon, creates a SUBTOTAL() function formula
- cell input confirmed with Alt-Enter only inputs value to unfiltered
- drag & drop - Without control key moves data, similar to cut
to clipboard this is disabled if the source range is filtered. - Drop
on filtered area is disabled. - With control key copies unfiltered as
in copy & paste via clipboard. - Drop on filtered area is
disabled.
- primary X selection - Filtered source range will be pasted using only
unfiltered rows. - Pasting on filtered area is disabled.
The operations not working with multi-selections and hence being
disabled if a filtered range is selected:
- Edit - cut - fill - all
- Insert - cells - rows - columns - names - create
- Format - merge cells - auto format
- Data - sort - subtotals - multiple operations - group and outline -
all - data pilot - all
- auto fill by dragging the cell corner
Not working with multi-selection but taking the encompassing range in
the case of a filtered selection:
- Insert - names - define - labels
- Data - define range
Not working with multi-selection but taking the current cell in that
case:
- Insert - names - insert - note
- show note
Special case of course, always available when filtered:
- Data - filter - auto filter - standard filter - advanced filter -
remove filter - hide filter

feature-info:
Since OOo2.0 we support language selection via Windows language bar,
but only for Asian and CTL languages. Due to hight demand to support
at least also Greek and Russian (they are considered to be "Western"
languages) this feature was enhanced to now support all types of
languages.
As this will create a problem for all users that don't use the Windows
language bar and want to write english texts with a "latin" type
keyboard (German, French, Italian etc.) the enhancement got a small
restriction: in this case the language reported by the system will be
ignored until the user explicitly switches it at least once.
But after the first usage of the language tool bar every change in it
also switches the language inside OOo. For all other language
combinations the language bar will always override the OOo text
language attribute.
BTW: in case you don't know this feature from using Asian or CTL
languages: the language status bar control will not immediately show
the overridden language, this will happen when something ins entered
via keyboard. But this is not causes by the enhancement, that was so
all the time before.

feature-info:
In India, the concept of lakh (100,000) and crore (10,000,000) is the
most used for numbering (and not one million). They group the number
differently for representation, not in thousands but following the
schema #,##,##,### instead. The first grouping separator from the
right groups 3 digits, all others group by 2 digits.
The number formatter now supports this schema if an Indian [*-IN] or
Bhutan [*-BT] locale is selected. You'll notice if the number to be
formatted has 6 or more digits or increase the count of leading zeros
in the number formatter dialog, and a grouping separator is used in
the format.
Currently the following Indian locales have locale data available and
thus are supported:
Bengali
English
Hindi
Gujarati
Kannada
Malayalam
Marathi
Oriya
Punjabi
Tamil
Telugu
plus Dzongkha in Bhutan.

feature-info:
Added locale data for Paraguayan Guaraní (gug-PY). The
language is
selectable for character attribution and spell-checking, as default
locale, default document language and available for number formats.

feature-info:
Locale data for Turkmen in Turkmenistan (tk-TM) is available. The
language is
selectable for character attribution, as default locale, default
document language and available for number formats.

feature-info:
With the integration of CWS odbmacros2, the "Address Book Data Source
Wizard" (the one which helps you created a database document for your
address data) will use a roadmap (a left-hand-side control displaying
all steps of the wizard).
(this is only a cheap side effect of some other change which happened
in this CWS.)

Target of the extensible help project is to support
help content
inside OpenOffice.org extensions. The extensions' help content is
provided together with the OpenOffice.org installed help content. The
help index can be extended by extensions. The implementation supports
extended tool tips and accessing extension help content by pressing F1
in UNO dialogs and menus.

feature-info:
The pkgchk tool has been deprecated in favor of the unopkg tool a long
time ago, and for quite some time pkgchk has been nonfunctional (only
giving an error message that unopkg should be used instead): finally
remove it completely.

OpenOffice.org is separated into single applications
like Writer,
Calc, Draw and Impress, which could be started directly from the
operating system start panel. If the OpenOffice.org executable is
started directly OOo shows the start module, always shown if no
document is loaded. The start module has no value for the user on
start-up, but keeps OOo loaded if the last document has been closed and
a new one is generated.

The Print dialog in Calc gets extended by a new
possibility to
define what part of the spreadsheet has to be printed. In the current
version the print setting "print only selected sheets" is located in
the Options dialog of the Print dialog and got defaulted for OOo 2.3.
This raised several new issues around print output is empty when the
corresponding table was not selected in the spreadsheet and the setting
itself was overseen/unknown in the Options dialog.

Product registration is important to be able to get
reliable
numbers of the installed product base. OOo and SO users have different
motivations to register themselves, therefore the registration dialogs
are different for these two products. Furthermore a registration
reminder is introduced using the online update

Printer administration for OpenOffice.org is done with
normal system
tools. The problem here is that on traditional Unix flavors the printer
administration is far too primitive for OOo's purposes. Therefore an
own printer administration program has been devised that allows to use
advanced printer features like duplex, paper formats, font substitution
and the like.

feature-info:
Summary: Concatenate two references
Syntax: Reference Left ~ Reference Right
Returns: ReferenceList
Semantics: Takes two references and computes the "cell union", which
is simply a concatenation of the reference Left followed by the
reference Right. This is not the same as a union in set theory;
duplicate references to cells are not removed. The resulting reference
will have the number of areas, as reported by AREAS, as
AREAS(Left)+AREAS(Right). If Left or Right are not references, an
error is returned.
A reference concatenation results in a list of references. A reference
list can be passed as an argument to functions expecting a reference
parameter where passing one reference results in an identical
computation as an arbitrary sequence of single references occupying
the identical cell range. For example, SUM(A1:B2) is identical to
SUM(A1~B2~A2~B1), but COLUMNS(A1:B2), resulting in 2 columns, is not
identical to COLUMNS(A1~B2~A2~B1), where iterating over the reference
list would result in 4 columns. Also many statistical functions depend
on the order of values and will not accept a reference list as
argument. A reference list can not be converted to an array, thus in
array context {ABS(A1~B2~A2~B1)} is an invalid expression, whereas
{ABS(A1:B2)} is not. Passing a reference list in all these cases
generates an error A list of functions accepting this argument is
given below.
Older versions of OpenOffice.org do not understand this operator and
will generate an error when encountered.
The UI syntax known from MS-Excel is also accepted, where two
references are separated by the parameter separator and the entire
expression has to be put in parentheses: (Left;Right). As this form is
easily confusable with normal parameters, e.g. SUM((A1:B2;C3:D4))
indeed is only one argument to the SUM function, and adding
respectively removing parentheses may significantly change the meaning
of the expression, the form using the '~' tilde character was chosen,
which follows the ODFF specification draft. A user input of
(Left;Right) is automatically converted to (Left~Right).
Functions accepting a reference list instead of a range reference as
parameter:
AREAS
INDEX
SUM
AND
OR
ISREF
MIN
MINA
MAX
MAXA
COUNT
COUNTA
STDEV
STDEVA
COUNTBLANK
COUNTIF
SUMIF Note: only in first parameter (criteria) and only if third
parameter (sum range) not given.
NPV
ZTEST
KURT
HARMEAN
GEOMEAN
SKEW
RANK
AVEDEV
GCD
LCM
FREQUENCY
MEDIAN
PERCENTILE
LARGE
SMALL
PERCENTRANK
TRIMMEAN
Parts of the description extracted from the ODFF specification draft
available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula

feature-info:
For MS-Excel interoperability the functions MIN() and MAX() now return
0 if no numeric value and no error was encountered in the cell
range(s) passed as cell reference(s), note that text cells are ignored
by MIN/MAX. The functions MINA() and MAXA() return 0 if no value
(numeric or text) and no error was encountered. The functions
previously returned an error in these cases. Passing a literal string
argument to MIN() or MAX(), e.g. MIN("string"), still results in an
error.

feature-info:
Summary: Computes an inclusive range given two references
Syntax: Reference Left : Reference Right
Returns: Reference
Semantics: Takes two references and computes the range, that is, a
reference to the smallest 3-dimensional cube of cells that include
both Left and Right. Note that Left and Right need not be a single
cell. For an expression such as B4:B5:C5 the resulting range is B4:C5.
In case Left and/or Right involve a reference list (result of operator
reference union), the range is computed and extended for each element
of the list(s). For example, (a,b,c,d denoting one reference each)
(a~b):(c~d) computes a:b:c:d
determining the outermost front-upper-left and rear-lower-right
corners.
Note that Left and Right may also be defined names or the result of a
function returning a reference, such as INDIRECT.
Description taken from the ODFF specification draft available at
http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula

feature-info:
Earlier versions set an unconditional error at the formula cell if the
formula contained an error and the formula was not interpreted in this
case. This changed now for undefined names and operators and the
formula is still interpreted, an expression like
=ISERROR(undefinedname) gives the result TRUE. 'undefinedname' may
also be a function or macro name, so =ISERROR(undefinedname(A1))
results in TRUE as well.

feature-info:
For interoperability with other spreadsheet applications the handling
of the 3rd parameter to the SUMIF() function changed. Previously, Calc
expected the geometry of that cell range to match that of the 1st
parameter. Now the 3rd parameter's range geometry does not have to
match the 1st parameter's; the upper left cell address is taken and
the geometry of the 1st parameter is used to turn that into a cell
range. For example, =SUMIF(A1:C3;1;X1) will result in the range X1:Z3
to be summed. If a range is passed, the geometry of the range is
ignored. If the resulting range would extend over the lower/right
sheet boundaries, those cells are silently ignored. For example, with
a lower right boundary of IV65536 the formula =SUMIF(A1:C3;1;IU65535)
would result in only 4 cells IU65535:IV65536 to be summed.

In a global world, collaboration becomes even more
important. The
collaboration feature for OOo allows to share and work simultaneously
on a single spreadsheet. Furthermore it allows to share documents in
any system environment and prevents documents from being overwritten by
others (i.e. if the used file system does not support a reliable file
locking).

With the current trend in larger monitors and the
advent of
computers using dual monitors, end users expect to use the extra space
on the screen to view additional pages of the document. At the same
time, professional users expect to view facing pages adjacent to each
other so that they are able to adjust complementary elements on the two
.

A cross-reference to a heading or a numbered paragraph
will be
inserted directly into the current text document by choosing the
heading respectively numbered paragraph. A list of all headings
respectively all numbered paragraphs will be provided to the user to
perform such a selection.

feature-info:
Introduces the implementation of the new outline chapter number
feature in text indexes (Writer) as described in ODF specification
1.2, draft 6, chapter “7.12.1.1 Display Chapter
Format”.
The six index types available in OpenOffice.org will gain the ability
to insert the outline chapter number level in the index entry
structure together with the maximum index level to be examined to show
the chapter number.
Detailed specification at:
http://specs.openoffice.org/writer/index/index_and_tables_dialog_enhancement.odt

For some chart types it is possible to add trend lines
to data
series. A trend line shows an approximation of the values by a
mathematical curve like a linear function. In addition to the actual
curve a graph can also contain graphical objects for the equation of a
trend line and the accuracy of the calculation, denoted by R².

feature-info:
The controller of the database application window now supports the
com.sun.star.view.XSelectionSupplier interface. The method
getSelection return an Any which contains a Sequence of NamedValue.
1st NamedValue:
Name = "Type"
Value is an integer with values from
com.sun.star.sdb.application.DatabaseObject which indicates which kind
of object is currently selected.
2nd NamedValue:
Name = "Selection" Value is a sequence of strings which are currently
selected in the view.
Value = Sequence < Strings > === selected names

feature-info:
In OOo 3.0 there will be 1024 columns per sheet instead of 256.
The "used area" logic for automatic print ranges, HTML/RTF export, and
the Ctrl-End keyboard shortcut has changed: If there are at least 30
equal-formatted columns somewhere behind the last column that has cell
contents, the attributes in these and the following columns are
ignored in determining the used area. This ensures proper handling of
old files with cell attributes in 256 columns.
In the file format specification, more columns were always possible.
If OOo 2.4 loads a file with cell content beyond the 256th column, a
warning is shown (after the integration of fwk83, with the fix for
issue 85334).

OpenOffice.org lacks of a solver implementation. A
solver allows to
solve equations with multiple unknown variables. The following
specification defines the user interface and interaction to implement a
solver for OOo Calc. The UI design is capable to cover more than one
solver engine. Solver engines could be installed as an extension
provided by any OOo vendor using the newly introduced solver interface.

This CWS adds 'drill-down' feature to Calc's DataPilot feature, where the user can double-click on a cell within the data field area and have a new sheet that shows all data rows that constitute that cell. The CWSalso introduces cache table to cache DataPilot's raw data in order to eliminate redundant access to the data source and somewhat simplify the data access code.

Change the implementation of Calc's formula code to allow certain tokens to be switched if needed. Currently the separator tokens are hard-coded. This CWS will make those separator tokens replaceable. Note, however, that this change will not alter the run-time behavior of the formula syntax handling; it'simplementation details only.

::comphelper::StlUnoSequence is a wrapper-class that provides stl-container-like access to an existing ::com::sun::star::uno::Sequencesee http://www.sgi.com/tech/stl/Container.htmlsee http://www.sgi.com/tech/stl/Sequence.htmlsee http://www.sgi.com/tech/stl/RandomAccessIterator.html

Some fixes in build tool...Changes without bugs:reworked custom job handlingfixed hang on windows when started not in a module diradded new switch "--stoponerror" for breaking build right after first errorenabled "build --prepare" for windowsadded second chance for a job in Cygwin environmentfixed HTML page refresh rate settingfixed HTML page errors display (when klicking on "Total progress")

Move the remaining code that uses sound onto the avmedia api and not the vcl apii.e.a) the file picker for selecting sounds in impressb) the SoundHandler in framework which supports hyperlink buttons that have a .wav target

KA: installsets for SO as well as for OOo have been tested by meon Linux and Windows; all icons are visible as before, so thatthis CWS is ready to be nominated as a'developer CWS' with internal build changes

Implementation for the feature specified in the specification "Direct cross references for headings and numbered paragraphs",found at http://specs.openoffice.org/writer/numbering/Direct_Cross_References_to_Headings_and_Numberings.odt

- implement the service com.sun.star.document.DocumentProperties(at this time, just for ODF files)- refactor xml import/export and all applications to use DocumentProperties- remove obsolete stuff like SfxDocumentInfo

Apache, the Apache feather logo, and OpenOffice are trademarks of The Apache Software Foundation.
OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation.
Other names appearing on the site may be trademarks of their respective owners.