Difference between revisions of "Feature Freeze Testing 3.0"

From Apache OpenOffice Wiki
Jump to: navigation, search
(add L10N features)
(add spreadsheet features)
Line 199: Line 199:
 
** Test case specification : - -
 
** Test case specification : - -
 
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Flocales30 locales30] integrated in DEV300m2
 
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Flocales30 locales30] integrated in DEV300m2
 +
<BR>
 +
 +
==Component : Spreadsheet (sc)==
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=4904 4904] : ODFF: Dynamic ranges of named cells, OpCode ocRange
 +
** Description : Takes two references and computes the range, that is, a reference to the smallest 3-dimensional cube of cells that include both Left and Right. Note that Left and Right need not be a single cell. For an expression such as B4:B5:C5 the resulting range is B4:C5. In case Left and/or Right involve a reference list (result of operator reference union), the range is computed and extended for each element of the list(s). For example, (a,b,c,d denoting one reference each) (a~b):(c~d) computes a:b:c:d determining the outermost front-upper-left and rear-lower-right corners. Note that Left and Right may also be defined names or the result of a function returning a reference, such as INDIRECT. Description taken from the ODFF specification draft available at http://www.oasis-open.org/committees/documents.php?wg_abbrev=office-formula
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=258
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51723/TestCaseSpecification_i4904.htm
 +
** Test documents : http://www.openoffice.org/nonav/issues/showattachment.cgi/51724/i4904_ocrange.ods
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=8808 8808] : Need a solver
 +
** Description : 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.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=251
 +
** Specification : http://specs.openoffice.org/calc/features/Solver.odt
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51378/Calc_Solver.html
 +
** Test documents : http://www.openoffice.org/nonav/issues/showattachment.cgi/51379/Solver_testdoc01.ods; http://www.openoffice.org/nonav/issues/showattachment.cgi/51380/stest_large.ods
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fcalcsolver calcsolver] integrated in SRC680m246
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=8811 8811] : Allow multiple users to edit the same spreadsheet through workbook sharing
 +
** Description : 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).
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=264
 +
** Specification : http://specs.openoffice.org/calc/features/Collaboration.odt
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51910/TestCaseSpecification_Collaboration.htm (Beta-Status)
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fcalcshare calcshare] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=31612 31612] : Column limitation in SpreadSheet
 +
** Description : 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).
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=252
 +
** Specification : - -
 +
** Test case specification : - -
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fcalccolumns calccolumns] integrated in SRC680m247
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=32340 32340] : ODFF: EmptyCell return for functions, like LOOKUP()
 +
** Description : 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:
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=263
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51714/TestCaseSpecification_Emptycell.htm
 +
** Test documents : http://www.openoffice.org/nonav/issues/showattachment.cgi/51750/i32340_variable_result.ods
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=32341 32341] : ODFF: OpCode 'ocUnion' to pass multiple ranges as one parameter
 +
** Description : 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. ...
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=260
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51704/TestCaseSpecification_Union.htm
 +
** Test documents :
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=38759 38759] : ODFF: MIN/MINA MAX/MAXA should return 0 if all parms are empty
 +
** Description : For MS-Excel interoperability the functions MIN() and MAX() now return 0 if no numeric value and no error was encountered in the cell range(s) passed as cell reference(s), note that text cells are ignored by MIN/MAX. The functions MINA() and MAXA() return 0 if no value (numeric or text) and no error was encountered. The functions previously returned an error in these cases. Passing a literal string argument to MIN() or MAX(), e.g. MIN("string"), still results in an error.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=257
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51717/TestCaseSpecification_Min.htm
 +
** Test documents : http://www.openoffice.org/nonav/issues/showattachment.cgi/51718/i38759_min.ods
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=51656 51656] : Add resizeable margin on page preview
 +
** Description : Page preview in Calc has a new toolbar button "Margins". It shows page margins and handles for the column widths, which can then be modified by dragging them.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=255
 +
** Specification : http://specs.openoffice.org/calc/features/Page_Margins_Specification.odt
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51472/TCS_Pagemargins.htm
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fpagemargins pagemargins] integrated in SRC680m247
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=77280 77280] : ODFF: ISERROR(undefinedname) results in #NAME! error, should be TRUE instead.
 +
** Description : Earlier versions set an unconditional error at the formula cell if the formula contained an error and the formula was not interpreted in this case. This changed now for undefined names and operators and the formula is still interpreted, an expression like =ISERROR(undefinedname) gives the result TRUE. 'undefinedname' may also be a function or macro name, so =ISERROR(undefinedname(A1)) results in TRUE as well.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=262
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51796/TestCaseSpecification_i77280.htm
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=85000 85000] : ODFF: SUMIF's 3rd parameter is handled differently from Excel
 +
** Description : 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.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=261
 +
** Specification : - -
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51778/TestCaseSpecification_i8500.htm
 +
** Test documents : http://www.openoffice.org/nonav/issues/showattachment.cgi/51779/i85000_SUMIF.ods
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fodff odff] integrated in DEV300m2
 +
<BR>
 +
* [http://www.openoffice.org/issues/show_bug.cgi?id=86069 86069] : New look for selection and column/row headers
 +
** Description : The selection visualization in spreadsheets is changed to be transparent. Furthermore the column headers get a glass effect in selection color to improve visibility.
 +
** Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=256
 +
** Specification : http://specs.openoffice.org/calc/features/Selection_Visualization.odt
 +
** Test case specification : http://www.openoffice.org/nonav/issues/showattachment.cgi/51587/TCS_Calcselection.htm
 +
** CWS : [http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fcalccolumns calccolumns] integrated in SRC680m248
 
<BR>
 
<BR>

Revision as of 12:27, 10 April 2008

Feature testing for OOo 3.0

Here are the features and enhancements, which were integrated in OOo 3.0 (Beta). All the listed issues are announced in the release notes for the developer snapshots since SRC680m242 to DEV300mX. These list is more technical orientated and isn't a release note for OOo 3.0 (Beta). This list could and should be used for testing and checking the new features in general or for translation purposes.

What's new ?

Component : Chart







Component : Base / Database Access

  • 67987 : let the "Address Book Data Source Wizard" use a roadmap
    • Description : 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.)
    • Feature Announcement : http://dba.openoffice.org/servlets/ReadMsg?list=features&msgNo=221
    • Specification : --
    • Test case specification : --
    • CWS : odbmacros2 integrated in DEV300m2


  • 69740 : API: Add ability to find which table(s) or query(s) are currently selected in the main Base window
    • Description : The controller of the database application window now supports the com.sun.star.view.XSelectionSupplier interface. The method getSelection return an Any which contains a Sequence of NamedValue. 1st NamedValue: Name = "Type" Value is an integer with values from com.sun.star.sdb.application.DatabaseObject which indicates which kind of object is currently selected. 2nd NamedValue: Name = "Selection" Value is a sequence of strings which are currently selected in the view. Value = Sequence < Strings > === selected names
    • Feature Announcement : http://dba.openoffice.org/servlets/ReadMsg?list=features&msgNo=213
    • Specification : --
    • Test case specification : --
    • CWS : dba24e integrated in SRC680m245


  •  : Database / Insert Menu, new menu item


  •  : Database / Edit Menu / Delete Record
    • Description : 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).
    • Feature Announcement : http://dba.openoffice.org/servlets/ReadMsg?list=features&msgNo=223
    • Specification : --
    • Test case specification : --
    • CWS : dba30a integrated in DEV300m2


Component : Drawing


Component : Framework


  • 84309 : remove pkgchk
    • Description : 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.
    • Feature Announcement : http://framework.openoffice.org/servlets/ReadMsg?list=features&msgNo=275
    • Specification : - -
    • Test case specification : - -
    • CWS : sb83 integrated in DEV300m4




  • 86352 : Add options button from print dialog to printer setup dialog




Component : Graphic System Layer (GSL)


Component : Installation/Setup


Component : Localization (L10N)

  • 53498 : Support for Indian and Bhutanese numbering systems, grouping not in thousands.
    • Description : 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. ...
    • Feature Announcement : http://l10n.openoffice.org/servlets/ReadMsg?list=features&msgNo=136
    • Specification : - -
    • Test case specification : - -
    • CWS : locales30 integrated in DEV300m2


  • 64095 : Support for Tetum Language (Timor-Leste)



  • 84582 :Locale data for Guaraní
    • Description : Added locale data for Paraguayan Guaraní (gug-PY). The language is selectable for character attribution and spell-checking, as default locale, default document language and available for number formats.
    • Feature Announcement : http://l10n.openoffice.org/servlets/ReadMsg?list=features&msgNo=133
    • Specification : - -
    • Test case specification : - -
    • CWS : locales30 integrated in DEV300m2


  • 84912 : Inclusion of languages Bodo, Dogri, Maithili and Santali in the Locale Setting dialog box,


  • 86322 : Locale file for Turkmen language
    • Description : Locale data for Turkmen in Turkmenistan (tk-TM) is available. The language is selectable for character attribution, as default locale, default document language and available for number formats.
    • Feature Announcement : http://l10n.openoffice.org/servlets/ReadMsg?list=features&msgNo=131
    • Specification : - -
    • Test case specification : - -
    • CWS : locales30 integrated in DEV300m2


Component : Spreadsheet (sc)




  • 31612 : Column limitation in SpreadSheet
    • Description : 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).
    • Feature Announcement : http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=252
    • Specification : - -
    • Test case specification : - -
    • CWS : calccolumns integrated in SRC680m247







  • 85000 : ODFF: SUMIF's 3rd parameter is handled differently from Excel



Retrieved from "https://wiki.openoffice.org/w/index.php?title=Feature_Freeze_Testing_3.0&oldid=73044"
Personal tools