Skip to content

start:

3.0 Beta2 RC1 - 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_m2.
This release will install as OOo-Dev3.0.
Sources can be received from cvs by tag BEB300_m2.

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. title Spec. abstract Dev. owner Spec. link 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:








  

    


      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.html
see http://www.sgi.com/tech/stl/RandomAccessIterator.html


      		

      DEV300m13

    


    


      sw241bf01_DEV300

      
      
Writer
bug fixes for OOo 2.4.1


      		

      DEV300m13

    


    


      ucpgio1

      
      
Add a ucp "gio" content broker. gio is
the gnome-vfs2 replacement in the glib/gnome stack


      		

      DEV300m13

    


    


      vcl88

      
      
More
3.0 fixes


      		

      DEV300m13

    


    


      cmcfixes44

      
      
Tidy
up some small issues


      		

      DEV300m13

    


    


      fwk86

      
      
Framework
fixes for OpenOffice.org 3.0.


      		

      DEV300m13

    


    


      presenterscreen

      
      
With the base line implementation and a large part of the presenter
screen implementation done in the CWS presenterview, this CWS is
 about the finishing touch on the presenter screen extension