development: OpenOffice.org 3.0 Release Candidate 4

How do I...

OpenOffice.org 3.0 Release Candidate 4

These notes contains changes between SRC680_m242 and SRC680_m248 as well as between DEV300_m1 and DEV300_m27 as well as between OOO300_m1 and OOO300_m9.
This release will install as OpenOffice.org 3.0.
Sources can be received from cvs by tag OOO300_m9.

What's new ?

Feature title	TaskId	Spec. abstract	Dev. owner	Component
Sheet names can contain almost any character	i6087	feature-info: Sheet names now can contain almost any character, previously they were restricted to letters, digits, underscore and space. For MS-Excel interoperability the following characters are not allowed when renaming sheets or entering new sheet names: colon : back slash \ forward slash / question mark ? asterisk * left square bracket [ right square bracket ] single quote ' if that is the very first or last character of the name (leading or trailing single quote) When used in cell references, a sheet name has to be enclosed in single quotes ' if the name contains other characters than alphanumeric or underscore. A single quote contained within a name has to be escaped by doubling it (two single quotes), e.g. a reference to cell A1 on a sheet named This year's sheet would had to be given as 'This year''s sheet'.A1	eike.rathke@sun.com	sc
ADDRESS and INDIRECT support additional parameter for A1/R1C1 notation	i91020	feature-info: For interoperability the ADDRESS and INDIRECT spreadsheet functions now support an additional optional parameter to specify whether the R1C1 address notation instead of the usual A1 notation should be used. Though the R1C1 notation otherwise is not supported by the application yet, this enables imported spreadsheet documents to calculate formulas using it. In ADDRESS, the parameter is _inserted_ as the 4th parameter, shifting the optional sheet name parameter to the 5th position. In INDIRECT, the parameter is appended as the 2nd parameter. In both functions, if the argument is given and 0 the R1C1 notation is used, if the argument is not given or has a value other than 0, the A1 notation is used. In case of R1C1 notation, ADDRESS produces address strings using the exclamation mark '!' as the sheet name separator and INDIRECT expects the exclamation mark as sheet name separator. Both functions still use the dot '.' sheet name separator with A1 notation. When opening documents stored in ODF 1.0 or 1.1 format, an ADDRESS function appearing in a formula expression gets a 4th parameter of value 1 inserted if a sheet name was given as 4th parameter, shifting the sheet name to the 5th parameter. When storing a document in ODF 1.0/1.1 format, if in an ADDRESS function a 4th parameter is present that parameter's expression will be stripped and not written. NOTE! This causes incompatibilities if the argument's expression calculated to 0, the function when loaded again will calculate a different result! A document should not be stored in the old ODF 1.0/1.1 format if the ADDRESS function's new 4th parameter was used with a value of 0. The INDIRECT function is written as is to ODF 1.0/1.1 format; if the 2nd parameter was present, an older version of Calc will return an error for that function. This is on purpose, as ADDRESS usually is used in conjunction with INDIRECT, and when stored to ODF 1.0/1.1 format this combination will more likely return an error result upon recalculation if the R1C1 notation was used. This change aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
ODFF: automatic intersection !! operator	i91259	feature-info: ODFF in section "5.10.5 Automatic Intersection" defines the '!!' operator for a range intersection of labels. To comply with the specification this needs to be written to and read from ODF 1.2 files. The UI representation does not change and still displays a space, as does the ODF 1.1 file format.	eike.rathke@sun.com	sc
ODFF: store ERRORTYPE as ORG.OPENOFFICE.ERRORTYPE	i91294	feature-info: The ERRORTYPE function is specific to OOoCalc, returning the internal error number. The ODF formula specification specifies an ERROR.TYPE function for interoperability with other spreadsheet applications. The ERRORTYPE function specific to Calc will be stored as ORG.OPENOFFICE.ERRORTYPE in ODF 1.2 documents, and as ERRORTYPE in ODF 1.1 documents.	eike.rathke@sun.com	sc

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
new: XML Document's XForm models support "internal" vs. "external" data	i90243	XForms Graphical User Interface (GUI) Specification - Part 1	XForms is an international standard for web forms. OO.org is able to create and edit XForms compatible forms. Part 1 of the specification describes the graphical user interface (GUI) for Toolbars, modes and the Data navigator for this new XForms functionality.	frank.schoenheit@sun.com	speclink	word processing

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
default connection string for UnoAPI-Tests has changed	i86692			christoph.neumann@sun.com	speclink	tools

Feature title	TaskId	Spec. abstract	Dev. owner	Component
Change to table view when a new database was created by the db wizard	i84173	feature-info: When a new database will be created by the wizard and the database should be opened, the view will change to the "tables view". Former it changes to the "forms view".	ocke.janssen@sun.com	dba
INDEX() function supports return of an entire vector of a 2D array	i66930	feature-info: The INDEX() spreadsheet function now supports the return of an entire vector of a 2D array if the corresponding row respectively column parameter is given a 0 argument. This aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
GCD() and LCM() convert arguments to integer	i71158	feature-info: The GCD() and LCM() spreadsheet functions now convert their arguments to integer before processing. Negative arguments are not allowed and by definition GCD(0;a)=>a, including GCD(0;0)=>0. This aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
LOOKUP in columns of a row if range is wider than tall	i74245	feature-info: The LOOKUP() spreadsheet function's lookup direction now depends on the width of the search array (first parameter, Searched) given. There are two major uses for this function; the 3-parameter version (vector) and the 2-parameter version (non-vector array). When given two parameters, Searched is first examined: - If Searched is square or is taller than it is wide (more rows than columns), LOOKUP searches in the first column (similar to VLOOKUP), and returns the corresponding value in the last column. - If Searched covers an area that is wider than it is tall (more columns than rows), LOOKUP searches in the first row (similar to HLOOKUP), and returns the corresponding value in the last row. When given 3 parameters, Results must be a vector (either a row or a column) or an error is raised. The function determines the index of the match in the first column respectively row of Searched, and returns the value in Results with the same index. Searched is first examined: - If Searched is square or is taller than it is wide (more rows than columns), LOOKUP searches in the first column (similar to VLOOKUP). - If Searched covers an area that is wider than it is tall (more columns than rows), LOOKUP searches in the first row (similar to HLOOKUP). The lengths of the search vector and the result vector do not need to be identical. When the match position falls outside the length of the result vector, an error is returned if the result vector is given as an array object. If it is a cell range, it gets automatically extended to the length of the searched vector, but in the direction of the result vector. If just a single cell reference was passed, a column vector is generated. If the cell range cannot be extended due to the sheet's size limit, then a NA() error is returned. This aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
INDEX of vector needs just one offset parameter	i78781	feature-info: The INDEX() spreadsheet function now returns an element of a vector regardless of its orientation if just two parameters were given. The general syntax for INDEX is: INDEX( ReferenceList\|Array DataSource ; [ Integer Row ] [ ; [ Integer Column ] ] [ ; Integer AreaNumber = 1 ] ) If called as INDEX( vector; offset) the offset value now is taken as an offset into vector, regardless of orientation. Vector can be a row vector as well, so it looks as if the column offset was passed as a row argument. This aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
COUNT ignores error results	i86643	feature-info: The COUNT() spreadsheet function now ignores error results of expressions and formula cells. Previously =COUNT(A1:A2) propagated an error if, for example, A1 contained the formula =1/0 the result was #DIV/0! This aligns with the behavior of other spreadsheet applications and the definition given in the OASIS ODFF/OpenFormula specification available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula	eike.rathke@sun.com	sc
Adding MS Access databases in Writer now possible	i83536	feature-info: Adding a data source in Writer is possible at different locations. For example in the mail merge dialog, the field dialog and under edit/exchange database. The list of data source types now includes MS Access files (*.mdb). This is only supported on Windows.	oliver.specht@sun.com	word processing

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
New Excel import VBA macro option	i88690	Option Dialog	This specification documents all changes made to the implementation of Options dialog.	Frank Loehmann (FL)	speclink	framework
COMMAN_WHEEL_DATAZOOM changed	i85450			philipp.lohmann@sun.com	speclink	gsl
testtool: new methods to access ExtensionListBox in extensions manager	i86913		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	gregor.hartmann@sun.com		qa
UI of Extension Manager changed	i83902	Extension Manager UI Change	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.	Bettina Haberer, BH	speclink	util
The office now supports .oxt files on the cmd line	i85856	Extension System Integration	Extensions shall be recognized on desktops by using particular icons. It also shall be possible to install an extension by double clicking on the respective file.	Joachim Lingner (JL)	speclink	util

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
Behavior of cut/paste/fill/drag on filtered rows.	i33851		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	eike.rathke@sun.com		sc

Language selection through Windows language bar extended to Western languages	i1035		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.	mathias.bauer@sun.com		word processing

Support of digit grouping as used in India	i53498		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.	eike.rathke@sun.com		L10N
Tetun (Indonesia) [tet-ID] and Tetun (Timor-Leste) [tet-TL] language listbox entries.	i64095		feature-info: Added to the language listbox: Tetun (Indonesia) [tet-ID] Tetun (Timor-Leste) [tet-TL] The languages are selectable for character attribution and spell-checking.	eike.rathke@sun.com		L10N
Sami, Kildin (Russia) [sjd-RU] in language listbox	i83565		feature-info: Added "Sami, Kildin (Russia)" [sjd-RU] to the language listbox. The language is selectable for character attribution and spell-checking.	eike.rathke@sun.com		L10N
Locale data for Paraguayan Guaraní (gug-PY)	i84582		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.	eike.rathke@sun.com		L10N
Language listbox entries for Bodo, Dogri, Maithili, Santali	i84912		feature-info: The following languages are available for character attribution and spell-checking: Bodo [brx-IN] Dogri [dgo-IN] Maithili [mai-IN] Santali [sat-IN]	eike.rathke@sun.com		L10N
Locale data for Turkmen_Turkmenistan (tk-TM)	i86322		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.	eike.rathke@sun.com		L10N
Error Bars can be selected from cell ranges	i366		For some chart types it is possible to add y error bars to data series. An error bar shows a region of values around the measured one to indicate the inaccuracy of the measurement.	bjoern.milcke@sun.com	speclink	chart
Additional Error Bar Style "Standard Error"	i85796		For some chart types it is possible to add y error bars to data series. An error bar shows a region of values around the measured one to indicate the inaccuracy of the measurement.	bjoern.milcke@sun.com	speclink	chart
Database / Insert Menu, new menu item			feature-info: The table data view of a table now has a menu entry Insert->Record. This command inserts a new row at the end of the data set.	ocke.janssen@sun.com		dba
Database / Edit Menu / Delete Record			feature-info: The table data view of a table now has a menu entry Edit->Delete Record. This command deletes the current selected row (this excludes the row when inserting a new one).	ocke.janssen@sun.com		dba
"Address Book Data Source Wizard" uses a roadmap	i67987		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.)	frank.schoenheit@sun.com		dba
support of native tables in impress and draw	i68103	Tables in Impress		Christian Lippka	speclink	drawing
Extensible help: Adding content to the Contents tree	i83624	Extensible Help	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.	Andreas Bregas (ab)	speclink	framework
remove pkgchk	i84309		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.	stephan.bergmann@sun.com		framework
new start center dialog	i85963	Start Center	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.	Frank Loehmann (FL)	speclink	framework
Tools - Options - Load/Save - General: ODF default version	i86209	ODF 1.2 Migration	With the next major version after OpenOffice.org 2.x, OOo will support ODF 1.2 in addition to ODF 1.0/1.1. This specification describes the migration from ODF 1.1 to ODF 1.2.	Michael Brauer	speclink	framework
Printer Settings dialog gets an "Options" button	i86352	OpenOffice.org Calc	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.	Frank Loehmann (FL)	speclink	framework
Tools - Options - Load/Save - General: ODF default version	i86649	ODF 1.2 Migration	With the next major version after OpenOffice.org 2.x, OOo will support ODF 1.2 in addition to ODF 1.0/1.1. This specification describes the migration from ODF 1.1 to ODF 1.2.	Michael Brauer	speclink	framework
Now the registration page (First StartUp Wizard) has different text for OOo and SO	i86683	Product Registration	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	Frank Loehmann (FL)	speclink	framework
SPAdmin: added UI option for external dialogs	i83676	Printer administration for OpenOffice.org on Unix	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.	philipp.lohmann@sun.com	speclink	gsl
new commandline tool cwsattach	i85505		feature-info: New commandline tool cwsattach to attach files to a childworkspace. Usage: cwsattach [-h] [-m master] [-c child] [-t mimetype] filename Attach files to CWS in EIS database Options: -h help -m master override MWS specified in environment -c child override CWS specified in environment -t mimetype explicitly set mime type Examples: cwsattach barfoo.html cwsattach -t text bar.cxx cwsattach -t text/rtf foo.rtf If no -t mimetype option is given the tool tries to map the extension to a mimetype via a configuration file. Standard Mimetypes for OpenDocument files as well as for txt and html and some graphics file formats are known to this config file.	bernd.eilers@sun.com		inhouse-tools
Three-Layer Installations	i84200			stephan.bergmann@sun.com	speclink	installation
Reference to empty cell not forced to type	i32340		feature-info: Previously, empty cells were forced to numeric 0 in some contexts and to empty string in others, except in direct comparison where =A1=0 and =A1="" both resulted in TRUE if A1 was empty. Emptiness now is inherited until used, so both =VLOOKUP(...)=0 and =VLOOKUP(...)="" give TRUE if the lookup resulted in an empty cell being returned. A simple reference to an empty cell is still displayed as numeric 0 but is not necessarily of type numeric anymore, so also comparisons with the referencing cell work as expected. For example: A1: 1 B1: C1: =B1 (displays 0) =B1=0 => TRUE =B1="" => TRUE =C1=0 => TRUE =C1="" => TRUE (previously was FALSE) =ISNUMBER(B1) => FALSE =ISNUMBER(C1) => FALSE (previously was TRUE) =ISNUMBER(VLOOKUP(1;A1:C1;2)) => FALSE (B1) =ISNUMBER(VLOOKUP(1;A1:C1;3)) => FALSE (C1, previously was TRUE) =ISTEXT(B1) => FALSE =ISTEXT(C1) => FALSE =ISTEXT(VLOOKUP(1;A1:C1;2)) => FALSE (B1, previously was TRUE) =ISTEXT(VLOOKUP(1;A1:C1;3)) => FALSE (C1) =ISBLANK(B1) => TRUE =ISBLANK(C1) => FALSE =ISBLANK(VLOOKUP(1;A1:C1;2)) => TRUE (B1, previously was FALSE) =ISBLANK(VLOOKUP(1;A1:C1;3)) => FALSE (C1) Note that MS-Excel has a difference in inherited emptiness and treats the result of a reference to an empty cell or a formula cell with the result of an empty cell, such as VLOOKUP(...) returning an empty cell, always as number. For example, Calc vs. Excel: A1: B1: =A1 => displays 0, but is just a reference to empty =ISNUMBER(A1) => FALSE =ISTEXT(A1) => FALSE =A1=0 => TRUE =A1="" => TRUE =ISNUMBER(B1) => FALSE (MS-Excel: TRUE) =ISTEXT(B1) => FALSE =B1=0 => TRUE =B1="" => TRUE (MS-Excel: FALSE) C1: =VLOOKUP(...) with empty cell result => displays empty (MS-Excel: displays 0) =ISNUMBER(VLOOKUP(...)) => FALSE =ISTEXT(VLOOKUP(...)) => FALSE =ISNUMBER(C1) => FALSE (MS-Excel: TRUE) =ISTEXT(C1) => FALSE	eike.rathke@sun.com		sc
Infix Operator Reference Concatenation ("~") (aka Union)	i32341		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	eike.rathke@sun.com		sc
MIN/MAX/MINA/MAXA return 0 if no value at all	i38759		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.	eike.rathke@sun.com		sc
Infix Operator Reference Range (":")	i4904		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	eike.rathke@sun.com		sc
ISERROR(undefinedname) results in TRUE	i77280		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.	eike.rathke@sun.com		sc
SUMIF geometry of 3rd parameter adapts to 1st parameter	i85000		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.	eike.rathke@sun.com		sc
Calc Collaboration	i8811	Collaboration	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).	Frank Loehmann (FL)	speclink	sc
Multiple Pages per View and Zoom Control in Statusbar	i1598	Multiple Pages per View and Zoom Control	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 .	Leonard Mada	speclink	word processing
Direct cross-references to headings and numbered paragraphs in text documents	i25072	Direct Cross-references to Headings and Numbered Paragraphs	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.	Frank Loehmann (FL)	speclink	word processing
Enhance Chapter Number Capability on Writer Indexes	i53420		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	beppec56@openoffice.org		word processing

title for secondary axes	i1163		With the “Insert Title” dialog for charts, a user can decide which title objects in a chart are shown, and what content they have. There is a main title, a sub title and axis-titles for the axes.	ingrid.halama@sun.com	speclink	chart
customizeable starting angle for pie charts	i16776	Options for Pie chart	new options are available for and donut charts: and	ingrid.halama@sun.com	speclink	chart
clockwise direction for pie charts	i37823	Options for Pie chart	new options are available for and donut charts: and	ingrid.halama@sun.com	speclink	chart
Ease handling of Trendlines in Charts	i44768		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².	bjoern.milcke@sun.com	speclink	chart
XSelectionSupplier now being supported by the database application controller	i69740		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	ocke.janssen@sun.com		dba
delays for quick help change	i77170			philipp.lohmann@sun.com	speclink	gsl
1024 columns per sheet instead of 256	i31612		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).	niklas.nebel@sun.com		sc
Adjustable margins and column widths in page preview	i51656			niklas.nebel@sun.com	speclink	sc
Transparent cell selection and changed column/row headers	i86069	New Selection Visualization	The selection visualization in spreadsheets is changed to be transparent. Furthermore the column headers get a glass effect in selection color to improve visibility.	Frank Loehmann (FL)	speclink	sc
Optimization Solver in Calc	i8808	Solver Implementation	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.	Frank Loehmann (FL)	speclink	sc
notes in the margin	i6193	Improved notes		Max Odendahl	speclink	word processing

Integrated Child Workspaces

List of integrated child workspaces:

dba30y	fixing issue 94433	OOO300m9
ooo300m9masterfix		OOO300m9

docmacroassignments	fix the problem that in various places, browsing for a macro/script to assign to a document element does not list the macros/scripts of the document itself (issue 94280).	OO300m8
jl112	showstopper	OOO300m8
localization33	Missing Spanish hc2 index files	OOO300m8
localization34	fix one greek string in officecfg	OOO300m8
mav40	Showstopper fix for autosave problem.	OOO300m8
ooo300m8masterfix		OOO300m8
sb98	libxml2.dll from Windows system dir vs. OOo URE layer (Windows only)	OOO300m8
sjfixes09		OOO300m8
tl62	Fix for a grammar checker related crash.	OOO300m8

addentitlement		OOO300m7
hro38	Preset filename in Vista File Dialog	OOO300m7
impress158	OOo 3.0 bugfix workspace	OOO300m7
impress159	possible showstopper for impress	OOO300m7
impress160	showstopper fix for impress	OOO300m7
indentfix	cws for i93873	OOO300m7
localization32	L10N showstoppers	OOO300m7
native199	Mac fix for English system language.	OOO300m7
ooo300m7masterfix		OOO300m7
sb96	msvcr71.dll missing under Windows MSVC 2003	OOO300m7
sjfixes06		OOO300m7
sysui32	sysui OOo build fix for solaris	OOO300m7
ab63	Fix shopstopper issue i92940	OOO300m6
dba30z	fix issue 93737	OOO300m6
i93386	Improve the behaviour on systems with older libfontconfig (older means <2.4)	OOO300m6
i93512	Prevent a deadlock on the OSX Aqua port	OOO300m6
i93555	Fix issue 93555 to display some "Arabic" instead of "Unknown" for an 'ar' Arabic language pack.	OOO300m6
impress157	fix in the pdfimport extension to enable it to load hybrid pdf in OOO300m4 and newer. This cws only changes the pdf extension and not the office. The fixed extension will also work in prior versions.	OOO300m6
mav39	3.0 show stopper fix for activated embedded objects in writer.	OOO300m6
native195	userland rpm into subdir in Linux installation sets with Java GUI Installer.	OOO300m6
native196	OOo 3.0 installation tasks	OOO300m6
ooo300m6masterfix		OOO300m6
qaerrorlogfixes1	[Automation]	OOO300m6
rt31	Hamburg RE process related only: fix for getting product update information into database	OOO300m6
sw30bf14	fix for issue i93392	OOO300m6
sw30bf15	fix for issue i93725 in Writer and for issue i90961 in desktop	OOO300m6
sysui31	sysui cleanup	OOO300m6

sysui30	Linux / Solaris system integration issues	OOO300m5
impress155	Bug fixes for OOo 3.0	OOO300m5
hotmac	rtl_memory_fini gets called to early, before the d'tors of C++ objects ..	OOO300m5
native190	Additional Windows Patch preparations	OOO300m5
sb95	fix CWS macrestart	OOO300m5
greenstate30ver3	Issues for Greenstate of automated testing for OOo 3.0	OOO300m5
mav38	Showstopper fix for the database documents opening problem.	OOO300m5
dba30j	3.0 show stoppers in DBA an elsewhere ...	OOO300m5
native191	OOo 3.0 installation tasks	OOO300m5
ooo300m5masterfix		OOO300m5
native193	OOo 3.0 installation tasks.	OOO300m5
mav37	Showstopper cws for OOo3.0	OOO300m4
reportbuilderext	CWS to set up an extension only module for the reportbuilder extension	OOO300m4
ab58	cws to fix showstopper i92555 (JavaScript / BeanShell organizers broken)	OOO300m4
native184	OO0 3.0 installation tasks	OOO300m4
native185	Enable installation with Java GUI Installer and user privileges again. Resolve dependency problem.	OOO300m4
vcl30stop5	fix issue 92674	OOO300m4
localisation31	Fixed broken hungarian translation , fixed several hc2 issue in various languages	OOO300m4
macrestart	Force soffice process to automatically restart after a crash occured.	OOO300m4
mh30f	last minutes todos	OOO300m4
sw30bf13	late fixes in Writer for OOo 3.0	OOO300m4
jl110	3.0 issues	OOO300m4
ab60	cws to fix showstopper i92867 (Basic libraries in extensions disappear)	OOO300m4
chart31	chart&calc 3.0 showstopper	OOO300m4
impress153	Show stopper bug fixes for OOo 3.0	OOO300m4
extrasooo30_OOO300	unification CWS for SO/OOo extras	OOO300m4
ooo300m4masterfix		OOO300m4
jsktestfixes1	A number of fixes for automated test cases.	OOO300m4
greenstate30ver2	[Automation] - showstopperfixes for the Greenstate of 3.0	OOO300m4
native186	OOo 3.0 installation tasks	OOO300m4
fwk96	Framework fixes for OOo3.0 showstoppers.	OOO300m4
native188	OOo 3.0 update tasks.	OOO300m4
impress154	Show stopper bug fixes for OOo 3.0	OOO300m4
dba30i	Fix in report designer	OOO300m4
fwk97	framework ooo 3.0 bugfix cws	OOO300m4
native189	OOo 3.0 installation tasks. This issue is about the parallel installation of StarOffice and StarSuite. Some reviews of the package dependencies and un/install sequence.	OOO300m4
ab62	cws to fix showstopper i93163	OOO300m4
oobeanfix		OOO300m4
tl61_OOO300	OOo 3.0 fixes.	OOO300m4
vcl93_OOO300	GSL related stuff important enough for OOo3.0	OOO300m4
c17v004_OOO300		OOO300m4
obo34_OOO300	Fix for i93167	OOO300m4
dba30h	fix issue 92668	OOO300m3
greenstate30	Autotestfixes to get green state for OOo3.0	OOO300m3
native182	OOo 3.0 / SO 9 installation tasks	OOO300m3
sw30bf12	Galician spell checker added and Ichitaro filters removed	OOO300m3
vcl30stop4	GSL related showstoppers for OOo 3.0	OOO300m3
localisation30	L10N showstopers	OOO300m3
cwscheckapi3	bugfix for cwscheckapi: since on Linux tgz are default for cws cwscheckapi could not install the office nymore	OOO300m3
impress152	showstopper fixes for impress in OOo 3.0	OOO300m3
i18n44_OOO300	i18n bug fixes	OOO300m3
pdf25_OOO300		OOO300m3
tl58_OOO300		OOO300m3
pflin11_OOO300	basic fix	OOO300m3
ooo300m3masterfix		OOO300m3
xsltfilter10_OOO300	Exchanging the binary JARS of Xerces/Xalan couple (xalan.jar/xercesImpl.jar/xml-apis.jar/serializer.jar) with a source module providing the XSLT2 capable saxon9. Furthermore provide latest ODF2XHTML xslt filter patch as relevant for Saxon.	OOO300m2
maccrashrep_OOO300	Enable crash reporting for MacOSX builds	OOO300m2
hrovista2_OOO300	Critical OOo 3.0 fixes for Windows Vista and Windows XP	OOO300m2
autotestfixfha1_OOO300		OOO300m2
dictionaryupdate_OOO300	update of some dictionaries to latest versions	OOO300m2
sw30bf10_OOO300	late fixes in Writer for OOo 3.0	OOO300m2
vcl30stop2_OOO300	last minute fixes for 3.0	OOO300m2
mhu19_OOO300	sal/rtl/source/alloc_global.c is not 64bit clean.	OOO300m2
sw30bf11_OOO300	fixes for OOo 3.0 in Writer	OOO300m2
mav35_OOO300	OOo3.0 showstopper cws.	OOO300m2
aquaupdateicon_OOO300	Implement update icon in native menubar on Mac	OOO300m2
native179_OOO300	OOo 3.0 installation tasks	OOO300m2
vcl30stop3_OOO300	Some more 3.0 showstoppers	OOO300m2
ooo300m2masterfix		OOO300m2
native180_OOO300	Preparing OOo 3 for Windows patches using msp technique.	OOO300m2
languageswitchfix_OOO300	Prevent superfluous language changes caused by the system keyboard	OOO300m2
ooo300m1masterfix		OOO300m1
sb92_OOO300	HelpLinker crash on Solaris	OOO300m1
ause091_OOO300	build cleaner - cleaner build	OOO300m1
vcl91_OOO300	3.0 showstoppers in gsl	OOO300m1
pba11y02_OOO300	Fixes for A11y issues.	OOO300m1
impress150_OOO300	Impress showstopper fixes for OOo 3.0 release	OOO300m1
pb20_OOO300	Truncated strings issues	OOO300m1
vcl30stop1_OOO300	gsl showstopper	OOO300m1

The free and open productivity suite

OpenOffice.org 3.0 Release Candidate 4

What's new ?

Integrated Child Workspaces