development: 3.1 m30 Snapshot

How do I...

3.1 m30 Snapshot - Release Notes

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

What's new ?

Feature title	TaskId	Spec. abstract	Dev. owner	Component
"Refresh Control" item in form navigation toolbar	i66628	feature-info: In the form navigation toolbar (the one used as soon as you have an alive form filled from a database), there's a new item, called "Refresh Control", located right after the "Refresh" item. This new item is enabled if and only if a list or combo box control has the focus. When pressed, the item list of the control is refreshed. This is particular interesting for lists based on the content of a table (or query) of the database, when some instance outside the form did changes to this table/query's data. In this case, you can reflect those changes in the control's item list by using the "Refresh Control" function. The change is effective when CWS dba31a is integrated, which will be somewhere on the track to OOo 3.1.	frank.schoenheit@sun.com	dba
new configuration setting for pre-specifying per-driver classpaths	i81899	feature-info: There's a new setting in the org.openoffice.Office.DataAccess configuration module which allows to specify, on a per-driver basis, a classpath to use when searching for a JDBC driver. An administrator of a shared OOo installation can use this setting to pre-configure the installation, without all users having the need to add the respective .JAR file to their own Java options. The complete path of the new configuration node is /org.openoffice.Office.DataAccess/JDBC/DriverClassPaths. An exemplary configuration fragment: url_to_jar_file For questions and feedback, please use users@dba.openoffice.org.	frank.schoenheit@sun.com	dba
parameters recognized in function argument lists	i91208	feature-info: With the integration of CWS dba31a, OOo's parser will have the ability to recognize parameters in function argument lists. That is, a query like SELECT CONCAT( :C, "name" ) FROM "name" will now, when executed, properly present the dialog asking the user for parameter value input.	frank.schoenheit@sun.com	dba
easier programmatic access to form/report documents	i91223	feature-info: (Strictly, this is an "API client feature announcement", but we don't have a features@api.openoffice.org, do we?) Programmatic access to forms/reports contained in database documents is (with the integration of CWS dba31a) easier than ever before: ThisDatabaseDocument.FormComponents.getByName( "form name" ).open will open the form "form name" in the very same way a double-click onto the form in the document UI would do, i.e. doing all the proper knittings to the document UI. Thanks to Andrew Jensen for suggesting this new syntax (well, the one he suggested would be even better, but need some adjustments to the Basic runtime).	frank.schoenheit@sun.com	dba
testtool: functional trigger StartTheOffice to start soffice by VCL TestTool	i86540	feature-info: In case VCL TestTool recognizes no soffice.bin to communicate to, it tries to call the function 'StartTheOffice'. If this function does not exist, it starts soffice.bin on its own. The functions 'StartTheOffice' purpose is to start soffice.bin and perform the minimal action needed to use it for automation tests. Which would be the execution of Start sAppExe, sParameter (this was formerly done by testtool) The current only known additional action is for MacOS X: disable the quickstart/startcenter functionality: call hDisableQuickstarterAPI. For the changes to take effect a new testtool.bin is needed. Changes to test environment in modul testautomation work also with an old testtool.bin. Changes to testautomation: Global gStartTheOffice as boolean '///+ gStartTheOffice => indicates an alternative startroutine is run in testautomation/global/system/includes/gvariabl.inc sub StartTheOffice warnlog "OpenOffice.org application crashed or can not be started. Double click the above error message if exists for the culprint." sStartUpOffice() catchGPF false hDisableQuickstarterAPI() gStartTheOffice = TRUE end sub in testautomation/global/system/includes/master.inc	tbo@openoffice.org	qa
"Templates: Address Book Assignment" dialog: "Administrate" now named "Configure"	i48161	feature-info: In the "Templates: Address Book Assignment" dialog, (File / Templates / Address Book Source), the button label "Administrate" has been changed to "Configure", to better reflect that the button starts a wizard which helps configuring the address book data source.	frank.schoenheit@sun.com	word processing

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
Plotting of missing values	i65549	Plotting of Missing Values	When plotting values in a chart it can happen that some of the values are missing - for example when a cell was left empty or did not contain a valid value. The user now can decide what should be plotted in such cases:a)	ingrid.halama@sun.com	speclink	chart
New document properties page: custom properties	i86606	Custom Document Properties	Current implementation supports only four text field info1 to 4. The new implementation allows to create user defined name value pairs of a certain data type. This is important for document management in companies.	Frank Loehmann (FL)	speclink	framework

Feature title	TaskId	Spec. title	Spec. abstract	Dev. owner	Spec. link	Component
New document locking mechanics for file: protocol	i85694	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	framework

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:

aw033	CWS for GraphicPrimitives	DEV300m30
gh15	testtool bugs and features 2008	DEV300m30
xsltfilter10	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.	DEV300m30
maccrashrep	Enable crash reporting for MacOSX builds	DEV300m30
hrovista2	Critical OOo 3.0 fixes for Windows Vista and Windows XP	DEV300m30
rmfreetype	Remove the private copy of libfreetype.so.6	DEV300m30
dba31a	Ongong bug fixing for OOo 3.1	DEV300m30
mh30b	various issue towards 3.0	DEV300m30
doccomments01	Extend import and export notes (ala postits/comments) to .doc format to support formatting newly available in 3.0	DEV300m30
register30	Update the way of registering OOo	DEV300m30
userdatamigration	Migrate userdata	DEV300m30
autotestfixfha1		DEV300m30
i18n44	i18n bug fixes	DEV300m30
helpsearch	hotfix for Japanese help index search i91750	DEV300m30
ocautotestfixes01	Autotestfixes for the spreadsheet module	DEV300m30
dictionaryupdate	update of some dictionaries to latest versions	DEV300m30
os119	Fix of issue i91896	DEV300m30
vcl30stop1	gsl showstopper	DEV300m30
sw30bf10	late fixes in Writer for OOo 3.0	DEV300m30
native177	Removing ICE check errors in msi database.	DEV300m30
extrasooo30	unification CWS for SO/OOo extras	DEV300m30
dr65	Latest OOo 3.0 fixes	DEV300m30
pdf25		DEV300m30
vcl30stop2	last minute fixes for 3.0	DEV300m30
cmcfixes48	Uncontroversial fixes and improvements, generally in the vicinity of xmlsignature code	DEV300m30
mhu19	sal/rtl/source/alloc_global.c is not 64bit clean.	DEV300m30
tbo02	Fix typos in include files of testautomation/framework Fix changed behaviour for global test on MacOS X	DEV300m30
native178	OOo 3.0 installation tasks	DEV300m30
sw30bf11	fixes for OOo 3.0 in Writer	DEV300m30
ab56	Split library container config files script.xlc, dialog.xlc into user and share files.	DEV300m30
mav35	OOo3.0 showstopper cws.	DEV300m30
aquaupdateicon	Implement update icon in native menubar on Mac	DEV300m30
impress151	impress showstopper fixes for OOo 3.0	DEV300m30
native179	OOo 3.0 installation tasks	DEV300m30
dev300m30masterfix		DEV300m30
languageswitchfix	Prevent superfluous language changes caused by the system keyboard	DEV300m30
vcl30stop3	Some more 3.0 showstoppers	DEV300m30
native180	Preparing OOo 3 for Windows patches using msp technique.	DEV300m30
pflin11	basic fix	DEV300m30
tl58		DEV300m30
hsqldb1810	Integrate hsqldb version 1.8.0.10	DEV300m30
dba30h_DEV300	fix issue 92668	DEV300m30
cwscheckapi3_DEV300	bugfix for cwscheckapi: since on Linux tgz are default for cws cwscheckapi could not install the office nymore	DEV300m30
sw30bf12_DEV300	Galician spell checker added and Ichitaro filters removed	DEV300m30
localisation30_DEV300	L10N showstopers	DEV300m30
vcl30stop4_DEV300	GSL related showstoppers for OOo 3.0	DEV300m30
native182_DEV300	OOo 3.0 / SO 9 installation tasks	DEV300m30
impress152_DEV300	showstopper fixes for impress in OOo 3.0	DEV300m30

dev300m29masterfix		DEV300m29
ause091	build cleaner - cleaner build	DEV300m29
chart22	Plotting of missing values	DEV300m29
doccustomproperties2	New document properties page: custom properties page replaces user defined page	DEV300m29
impress150	Impress showstopper fixes for OOo 3.0 release	DEV300m29
layoutdialogs	* Enable compiling of layout engine by default. * Old .src dialogs initially replaced by .xml layout dialogs: svx/source/dialog/zoom.src, sw/source/ui/dialog/wordcountdialog.src [WIP: svx/source/dialog/docrecovery.src] * Note: i18n translation strings, compile-time translation and testing can be found in toolkit/workben/layout. See also toolkit/doc/layout/README * Note: the layout engine is still a work in progress, not all widgets have been implemented yet.	DEV300m29
pb20	Truncated strings issues	DEV300m29
pba11y02	Fixes for A11y issues.	DEV300m29
sb92	HelpLinker crash on Solaris	DEV300m29
vcl91	3.0 showstoppers in gsl	DEV300m29

dev300m28masterfix		DEV300m28
localisation29	Localization for OOo 3.0 final	DEV300m28
aqua11y02	Bug fixes for accessibility support on the Mac.	DEV300m28
cmcfixes46	Fix some font issues	DEV300m28
cwscheckapi2	update lists for UnoAPI-Tests.	DEV300m28
dba30g	3.0 showstoppers for DBA	DEV300m28
fwk93	Showstopper for OOo 3.0.	DEV300m28
impress148	Bug fixes for OOo 3.0	DEV300m28
jl108	Showstopper for 3.0	DEV300m28
late30bf01	late fixes for OOo 3.0	DEV300m28
late30bf02	late fixes for OOo 3.0	DEV300m28
native173		DEV300m28
os118	3.0 tasks	DEV300m28
socs17		DEV300m28
tbo01	Fixes in testautomation/math towards 3.0 and CWS handling optimisation	DEV300m28

dev300m27masterfix		DEV300m27
chart2testfixes	The structure of testautomation is different to qatesttool and has to be adopdet to the optional tests in chart2 modul.	DEV300m27
dellauncher	Remove Launcher library from OpenOffice.org installation set.	DEV300m27
inifix	Rename version.ini to versionrc to avoid virtualization on Windows Vista	DEV300m27
native172	OOo 3.0 installation tasks.	DEV300m27
native174	OOo 3.0 installation tasks	DEV300m27
notes30stopper	showstopper for 3.0	DEV300m27
os2port03	2.4 based rcws for OS/2 release.	DEV300m27
pba11y01	A11y issues for 3.0.	DEV300m27
sdkfix	for sdk fix i91796	DEV300m27
xmlfilter06	development of ooxml filters	DEV300m27
chart29	3.0 Chart Data Range Bugfixes + donut import showstopper	DEV300m27
mscautotests	fix issues in the testautomation/dbaccess module and a showstopper in the report builder	DEV300m27
sw30bf09	fixes in Writer for OOo 3.0	DEV300m27

dev300m26masterfix		DEV300m26
aquavcl09	MacOSX/Aqua specific changes for 3.0	DEV300m26
ause095	build fixes	DEV300m26
dv04	Extension Manager bugfixes	DEV300m26
extensionupdate03	Extension Bugfix Workspace	DEV300m26
jl106	Extension Manager, and cli-ure related issues	DEV300m26
logger2	The OpenOffice.org Improvement Program is an extension that collects data about how OpenOffice.org is used. This information is used to better understand how people use OpenOffice.org.	DEV300m26
mav34	Framework showstopper fixes for OOo3.0	DEV300m26

The free and open productivity suite

3.1 m30 Snapshot - Release Notes

What's new ?

Integrated Child Workspaces