development: 3.0 Beta 2 - Release Notes

How do I...

3.0 Beta 2 - Release Notes

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

What's new ?

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:

beb300m3masterfix		BEB300m3
extensionupdate02_BEB300	Minor updates and bugfixes regarding CWS extensionupdate01	BEB300m3
extmgrui04c	Last minute fix for extension manager	BEB300m3
native160_BEB300	System wide integration of msvc* libraries (using msm modules during packaging process)	BEB300m3
aquavcl08_BEB300	Mac/Aqua specific tasks	BEB300m3
extensionl10nfix01_BEB300	Fix various extensions l10n related issues RE: Please also build helpcontent2 again	BEB300m3
extensionupdate01_BEB300		BEB300m3
icondialog_BEB300	CWS to fix crash in icon dialog. Showstopper for Beta refresh.	BEB300m3

beb300m2masterfix		BEB300m2
impressmuc_BEB300	Showstopper fix for beta2 refresh concerning the unmovable shapes in impress	BEB300m2
native156_BEB300	New process for spellchecker selection in OOo 3.0	BEB300m2
notes6_BEB300	bugfixes for new notes implementation for 3.0	BEB300m2
beb300m1masterfix		BEB300m1
extmgrui04_BEB300	More bugfixes for the new extension manager	BEB300m1
i91009_BEB300	i91009	BEB300m1
impress144_BEB300	OOo 3.0 bug fixes.	BEB300m1
rptfix01_BEB300	Fix for the SRB to work with OOo 2.4 and OOo 3.0 and filter issue.	BEB300m1

dev300m21masterfix		DEV300m21
aquabmpfix03	Critical fixes for graphics issues on the Aqua port	DEV300m21
extensionl10n01	OOo 3.0 UI/HELP Beta refresh l10n The localizations of the extensions have been moved into cws extnsionl10n02 Please integrate this cws together with extensionl10n02!!!!!	DEV300m21
extensionl10n02	Localization of OOo extensions Please integrate this cws together with cws extensionl10n01!!!!!	DEV300m21
fwk88	Framework fixes for OpenOffice.org 3.0.	DEV300m21
ooxtablefilter	Import of OfficeOpen XML tables	DEV300m21
jl103	3.0 issues	DEV300m21
obo32	Fix for i90866	DEV300m21

dev300m20masterfix		DEV300m20
extmgrui02	Bugfixes for new extension manager ui	DEV300m20
hr51	Changes for a Solaris (Sparc) 64 OOo version bit.	DEV300m20
notes5	change tracking, spellchecking and other issues in combination with new implementation of notes	DEV300m20
rptchart02	ongoing charts in reports	DEV300m20
sb88	various OOo 3.0 bugfixes	DEV300m20
aquabmpfix02	a second batch of fixes for Aqua port graphics problems	DEV300m20
chart28_DEV300	issue 90071 display of charts with clipped data crashes office	DEV300m20
hunspellexternal	make hunspell be built/used as an external library, because that's what it actually is / other hunspell-related fixes	DEV300m20
obr09	OOo 3.0 packaging fixes.	DEV300m20
qadev32	Implementaion of checkcws (UnoAPI-Test)	DEV300m20
smoketest20	remove statjars	DEV300m20
swlists01	Changes and enhancements in Writer due to the accepted ODF proposal to enhance and clarify list for ODF version 1.2 - see http://www.oasis-open.org/committees/download.php/23418/07-04-05-proposal-lists.odt	DEV300m20

dev300m19masterfix		DEV300m19
impress141	impress & draw bugfixes for OOo 3.0	DEV300m19
odff03	More changes for ODFF compliance, follow-up on CWS 'odff02'. Implementation details of spreadsheet functions.	DEV300m19
openjdk6b	provide openjdk6, fixes, testbuild	DEV300m19
sb87	OOo 3.0 fixes	DEV300m19
dev300m18masterfix		DEV300m18
ause093	building and related...	DEV300m18
ause094	create common targets for extension packing	DEV300m18
chart25	bug fixes for chart	DEV300m18
dateinput	Accept x/y as a valid month/year date also in MDY order (e.g. en-US).	DEV300m18
dba30c	ongoing DBA bugfixing towards OOo 3.0	DEV300m18
extmgrui03	Add provider link inside new extension manager ui	DEV300m18
fmebugs04	Some more 3.0 fixes.	DEV300m18
fmepatches02	cws that applies some community patches	DEV300m18
impressodf12	Fixing odf related tasks for OOo 3.0	DEV300m18
jl101	3.0 Fixes	DEV300m18
l10nfix27	This cws fixes some en-US typos . The strings changed but FMA will fix the status in the database -> No new strings introduced	DEV300m18
mingwport13	MinGW port catch up fixes for DEV300	DEV300m18
native151	Binfilter into an own package.	DEV300m18
os113	Bugfixing OOo 3.0	DEV300m18
shutup2	Make build process less verbose: - configure switch to control verbosity - silently unpack tarballls of external moduls	DEV300m18
sw30bf05	fixes of defects in Writer for OOo 3.0	DEV300m18
sw30rng01	Issues regarding odf specification	DEV300m18
xmlfix2	- upgrade libxml2 to latest version - fix various infelicities in unoxml - remove some code duplications	DEV300m18

dev300m17masterfix		DEV300m17
l10nfix26		DEV300m17
odfversionedexport	Omit export of OFD 1.2 chart features when 1.1 is set	DEV300m17
sw30bf04	Patches and bug fixes for OOo3.0	DEV300m17
tkr10	UCB Issues	DEV300m17
touchpoints01	Install touchpoints to new dictionaries and templates online.	DEV300m17

dev300m16masterfix		DEV300m16
hcshared18	Application Help following the OOo 3.0 Beta deadline	DEV300m16
rt28	Some small build fixes for OOo 3.0	DEV300m16
stctplbtn	implement issue 90035	DEV300m16
dev300m15masterfix		DEV300m15
aquabmpfix01	Aqua port: Fixes and improvements for bitmap handling	DEV300m15
aquavcl07	Mostly Mac/Aqua specific fixes.	DEV300m15
hro35_DEV300	Fixes for Vista Common File Dialogs. Needs to be tested on Vista with AND without SP1 platform.	DEV300m15
notes4	OOo 3.0 bugfixes for new notes implementation in Writer	DEV300m15
ooo3readme2	Readme Changes for OOo3 Final Release	DEV300m15
sjfixes05		DEV300m15
uaa06	Accessibility API enhancements and bug fixes.	DEV300m15
xformsmodify	add a new string, in preparation of an upcoming minor enhancement to the XML Form Document's model data behavior.	DEV300m15
calcodfversion	Implement differentiation between file formats ODF 1.1 and ODF 1.2 with ODFF.	DEV300m15
calcshare4	String changes for Calc collaboration	DEV300m15
cmcfixes45		DEV300m15
extrasso9		DEV300m15
native155	OOo 3.0 installation tasks	DEV300m15
odfversion241_DEV300	Issues of ODF warning message	DEV300m15
pdfi03	Implementation of pdf restrictions.	DEV300m15
pj90	Minor fixes (goodies WaE free on Windows, Mac OS X is now complete warning free, add Gaelic language etc).	DEV300m15

dev300m14masterfix		DEV300m14
extmgrui01	Rewrite the UI used for the extensions manager	DEV300m14
jl98_DEV300	showstopper issues	DEV300m14
late241bf01_DEV300	late fixes for OOo 2.4.1	DEV300m14
native150_DEV300	OOo 2.4.1 installation tasks.	DEV300m14
native152	OOo 3.0 packaging and installation tasks.	DEV300m14
ab51	New option on Options / Load/Save / VBA Properties page to choose between importing Basic uncommented or executable	DEV300m14
c17v003_DEV300		DEV300m14
dba241c_DEV300	Bug fix for i88091	DEV300m14
fwk89_DEV300	Framework fixes for OOo2.4.1	DEV300m14
i18n43_DEV300	bug fix for issue i88411.	DEV300m14
impress142	Beta refresh bug fixes	DEV300m14
jl100_DEV300	Show stopper issues for 2.4.1	DEV300m14
koheidatapilot01	This CWS adds 'drill-down' feature to Calc's DataPilot feature, where the user can double-click on a cell within the data field area and have a new sheet that shows all data rows that constitute that cell. The CWS also introduces cache table to cache DataPilot's raw data in order to eliminate redundant access to the data source and somewhat simplify the data access code.	DEV300m14
l10nfix24	Fix a P1 l10n issue	DEV300m14
mba30patches01		DEV300m14
mhu18_DEV300		DEV300m14
nofsnames_DEV300		DEV300m14
obo27	Build fixes for unxmacxi	DEV300m14
pyunosystempaths_DEV300	fix Issue 86251	DEV300m14
srb104	Next version of the SRB (1.0.4)	DEV300m14
sw241bf02_DEV300	Writer bug fixes for OOo2.4.1	DEV300m14
sw241bf03_DEV300	fix for issue i89000	DEV300m14
tbe33_DEV300	OOo 2.4.1 bug fixes	DEV300m14
tkr13_DEV300	UCB fix for OOo 2.4.1	DEV300m14
wizards241fix01_DEV300	Fixes in wizards project.	DEV300m14
dev300m13masterfix		DEV300m13
chart26_DEV300	OOo 2.4.1 issues for chart and calc	DEV300m13
oxtsysint01	soffice.bin should be able to handle oxt files	DEV300m13
xsltfilter09	- Mayor improvements of XSLT XHTML export - Fixed missing OXT functionality for XSLT filter	DEV300m13
c07v018_DEV300		DEV300m13
dba241b_DEV300		DEV300m13
hsqldb16	HSQLDB should be buildable with jdk 1.6	DEV300m13
jl93	Adapt digital signatures to ODF 1.2	DEV300m13
koheiformula01	Change the implementation of Calc's formula code to allow certain tokens to be switched if needed. Currently the separator tokens are hard-coded. This CWS will make those separator tokens replaceable. Note, however, that this change will not alter the run-time behavior of the formula syntax handling; it's implementation details only.	DEV300m13
native149	Windows: Dynamic link creation between layers in 3-layer office.	DEV300m13
obo29	CWS-Tools: Remove dependency to Logging.pm	DEV300m13
pdfirename	rename pdfi extension	DEV300m13
stliterators	::comphelper::StlUnoSequence is a wrapper-class that provides stl-container-like access to an existing ::com::sun::star::uno::Sequence see http://www.sgi.com/tech/stl/Container.html see http://www.sgi.com/tech/stl/Sequence.

The free and open productivity suite

3.0 Beta 2 - Release Notes

What's new ?

Integrated Child Workspaces