Language
The Free and Open Productivity Suite
| Feature title | TaskId | Spec. title | Spec. abstract | Dev. owner | Spec. link | Component |
|---|---|---|---|---|---|---|
| separated UI/configuration for database forms anddatabase reports | i45663 | feature-info: With the integration of CWS fwkdbdesign01(http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01),database forms and reports will not share their UI configuration withtext documents anymore.That is, you can have separate toolbar/menu/keyboard configurationsfor all three modules: forms, reports, normal text documents.Additionally, window states are also handled separately, that is, ifyou open a database form with a certain window size, and a certain setof opened toolbars, then those settings will not be shared with textdocuments anymore, but be valid for all database forms only. The sameholds for database reports, of course. | frank.schoenheit@sun.com | dba | ||
| keyboard shortcuts for database record navigation | i74918 | feature-info: With the integration of CWS fwkdbdesign01(http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01),you have a number of new keyboard shortcuts available in databaseforms. In particular, those are:Modifier 1 + Modifier 2 + Home: First RecordModifier 1 + Modifier 2 + Cursor-Left: Previous RecordModifier 1 + Modifier 2 + Cursor-Right: Next RecordModifier 1 + Modifier 2 + End : Last RecordAs usual, the meaning of "Modifier" depends on your platform/hardware,for an ordinary PC keyboard, it's "Ctrl" resp. "Alt". | frank.schoenheit@sun.com | dba | ||
| Show filter options dialog before file dialog in caseof pdf-export. | i13154 | PDF Export | This document is about enhancements to OOo1.1's PDFexport feature. ForOoo2.0 the features most requested by our users should be implemented;namely: improved graphics output, links, document outline, documentnotes, tagged PDF, presentation effects, form controls and documentencryption. | Mikhail.Voitenko@sun.com | speclink | framework |
| Selection of stylist filter now persistent | i4854 | feature-info: Now the selection of a stylist filter is persistent. One selection forevery application. | hans-peter.burow@sun.com | framework | ||
| The title for the broken signature dialog has beenchanged. | i69640 | Electronic Signatures and EncryptionGraphical UserInterface (GUI) | Mikhail.Voitenko@sun.com | speclink | framework | |
| Extension Identifiers, unopkg, pkgchk | i69910 | Extension Identifiers | Extensions can now contain an element in their , givingtheextension a unique identifier. This removes the current restrictionthat no two extensions can have the same file name. | StephanBergmann (SB) | speclink | framework |
| Export COT, ACOT, COTH, and ACOTH to MS Excel files | i72768 | feature-info: The Excel export filter now handles the cotangent functions COT, ACOT,COTH, and ACOTH which are not contained in Microsoft Excel. The filterreplaces the functions by the related tangent functions:Cotangent: COT(x) is replaced with (1/TAN(x))Arccotangent: ACOT(x) is replaced with (PI/2-ATAN(x)) where PI/2 isgiven as numerical constantHyperbolic cotangent: COTH(x) is replaced with (1/TANH(x))Hyperbolic arccotangent: ACOTH(x) is replaced with ATANH(1/(x))with "x" being any simple or complex expression.Note the additional parentheses which are needed to preserve correctoperator precedence, for example:COT(1)^2 is correctly replaced by (1/TAN(1))^2 instead of the wrong1/TAN(1)^2. | daniel.rentz@sun.com | sc | ||
| Centered document view | i1761 | feature-info: From mmp's short spec as issue comment:If the horizontal scrollbar has nothing to do then the pages will becentered in the window. Otherwise we keep the behavior fromprevious OOo versions (ZoomIn bahaviour will not be changed.)The center of the pages is defined by the half width of the widestpage of thedocument (pages can also be in landscape orientation, right?).Then all pages are aligned to the left border of the widest page. | oliver.specht@sun.com | word processing | ||
| separated UI/configuration for XML Form Documents | i75146 | feature-info: With the integration of CWS fwkdbdesign01(http://eis.services.openoffice.org/EIS2/servlet/cws.ShowCWS?Path=SRC680%2Ffwkdbdesign01),XML form documents will not share their UI configuration with textdocuments anymore.That is, you can have separate toolbar/menu/keyboard configurationsfor text documents and XML form documents. Additionally, window statesare also handled separately, that is, if you open an XML form documentwith a certain window size, and a certain set of opened toolbars, thenthose settings will not be shared with text documents anymore, but bevalid for all XML form documents only. | frank.schoenheit@sun.com | word processing |
| Locale data for Hausa_Ghana (ha_GH) available | i72206 | feature-info: Locale data for Hausa_Ghana (ha_GH) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Ewe_Ghana (ee_GH) available. | i72207 | feature-info: Locale data for Ewe_Ghana (ee_GH) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Frisian_Netherlands (fy_NL) available. | i72919 | feature-info: Locale data for Frisian_Netherlands (fy_NL) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Tagalog_Philippines (tl_PH) added to language list box. | i73406 | feature-info: The Tagalog_Philippines (tl_PH) locale is now selectable for characterattribution. | eike.rathke@sun.com | L10N | ||
| Jewish calendar dates for en_US locale. | i74008 | feature-info: Jewish calendar dates are available in en_US locale data, selectablefrom the number formatter's date formats with the prefix modifier[~jewish] | eike.rathke@sun.com | L10N | ||
| Locale data for Uzbek_Uzbekistan (uz_UZ) available. | i75857 | feature-info: Locale data for Uzbek_Uzbekistan (uz_UZ) Latin script was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Uzbek(Cyrillic) removed from language list box. | i75857 | feature-info: The already existing "Uzbek (Cyrillic)" language list box entry wasremoved because there is no support of Uzbek in Cyrillic script andthe value could not be stored. | eike.rathke@sun.com | L10N | ||
| Locale data for Occitan_France (oc_FR) available. | i76044 | feature-info: Locale data for Occitan_France (oc_FR) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Lingala_Congo (ln_CD) available. | i76153 | feature-info: Locale data for Lingala_Congo [Democratic Republic] (ln_CD) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Sango _ Central African Republic(sg_CF) available. | i76345 | feature-info: Locale data for Sango _ Central African Republic (sg_CF) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for English_Ghana (en_GH) available. | i76346 | feature-info: Locale data for English_Ghana (en_GH) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Ganda_Uganda (lg_UG) available. | i76348 | feature-info: Locale data for Ganda_Uganda (lg_UG) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Locale data for Armenian_Armenia (hy_AM) available. | i78003 | feature-info: Locale data for Armenian_Armenia (hy_AM) was added.The locale is now available as a default document language andselectable for number formats. | eike.rathke@sun.com | L10N | ||
| Currency Bolivar Fuerte, VEF, for Spanish_Venezuela(es_VE) locale. | i78586 | feature-info: According to ISO 4217 MA amendment #138 there will be a new currency inVenezuela, effective from 2008-01-01ID: VEFSymbol: BsFDecimals: 2Name: bolívar fuerteAdded as a secondary currency to the Spanish_Venezuela (es_VE) localedata. | eike.rathke@sun.com | L10N | ||
| Default currency Ghana Cedi, GHS, for *_Ghana (ak_GH,ee_GH, en_GH, ha_GH) locales. | i78587 | feature-info: According to ISO 4217 MA amendments #138 and #139 there will be a newcurrency inGhana, effective from 2007-07-01ID: GHSSymbol: ₵Decimals: 2Name: Ghana CediAdded this as the default currency to the *_Ghana (ak_GH, ee_GH,en_GH, ha_GH) locales. | eike.rathke@sun.com | L10N | ||
| com.sun.star.io.SequenceInputStream service | i77185 | feature-info: While using OOo API there is often a need to represent data from asequence as astream. For this reason the service"com.sun.star.io.SequenceInputStream" is introduced. Please see theidl specification for details. | Mikhail.Voitenko@sun.com | api | ||
| Insert/Title Dialog Layout Changed | i13443 | With the “Insert Title” dialog forcharts, a user can decide whichtitle objects in a chart are shown, and what content they have. Thereis a main title, a sub title and axis-titles for some axes. | bjoern.milcke@sun.com | speclink | chart | |
| offer to switch to a Simple 3d look in charts | i14202 | The 3D settings for charts are presented in one newdialog “3DView”. It offers settings for perspective, appearance, andillumination. The user can also choose “right-angledaxes” to easilyensure vertical and horizontal axes. | ingrid.halama@sun.com | speclink | chart | |
| exploded 3D pies and donuts | i20321 | Chart Wizard | Charts can be created with a new Chart Wizard. | MatthiasMüller-Prove /MMP | speclink | chart |
| more easy creation of charts / new wizard | i20344 | Chart Wizard | Charts can be created with a new Chart Wizard. | MatthiasMüller-Prove /MMP | speclink | chart |
| enhanced logarithmic scales | i26869 | This specification describes the scaling behavior ofcharts as wellas the settings for the visible interval marks and the grid linesinside the chart. | ingrid.halama@sun.com | speclink | chart | |
| Strings for Undo in Charts | i27351 | Chart Undo | Undo actions are represented to the user with strings. | ingrid.halama@sun.com | speclink | chart |
| enhanced logarithmic scales | i27694 | This specification describes the scaling behavior ofcharts as wellas the settings for the visible interval marks and the grid linesinside the chart. | ingrid.halama@sun.com | speclink | chart | |
| Automatic axis scaling | i30426 | Automatic Axis Scaling | This document describes how axes are scaledautomatically in thenew chart module. The goal of automatic axis scaling is to visualizeall data points best possible in the available plot area. | daniel.rentz@sun.com | speclink | chart |
| Flexible Source-Range Selection | i3997 | Allow users to associate source-ranges of spreadsheetdata tosingle chart-objects in different roles, like the x-values of adata-series in a scatter chart. Especially different data series withdifferent x-values are commonly used in competitor's applications. | bjoern.milcke@sun.com | speclink | chart | |
| enhanced selection handling | i58161 | Chart Selection Handling | This document describes how the selection via mouseworks in thenew chart module. The goal of the mouse handling is to be predictableand easy. | ingrid.halama@sun.com | speclink | chart |
| Export donut charts according to spec | i58457 | feature-info: Donut charts now are written to xml according to the ODF specification.Wrong files from former versions are converted during loading.As former versions are buggy they will not be able to import the newcorrect files correctly. So switch to the corrected version completelywhen you use this chart type. | ingrid.halama@sun.com | chart | ||
| Export manual scales for percent charts correctly | i59288 | feature-info: Percent charts with user defined scales now are written to xmlcorrectly.Wrong files from former versions are converted during loading.As former versions are buggy they will not be able to import the newcorrect files correctly. So switch to the corrected version completelywhen you use this kind of charts. | ingrid.halama@sun.com | chart | ||
| Menu for Charts | i60358 | Chart Menu Structure | By activating a chart (select and double click it) themain menustructure offers commands to edit the type, style and appearance of thechart. Terminology is simplified and the menus are easier to accessbecause the items are grouped in meaningful sections. | ingrid.halama@sun.com | speclink | chart |
| Chart Data Editor improved | i64824 | bjoern.milcke@sun.com | speclink | chart | ||
| Right-angled axes for 3D Charts | i67754 | The 3D settings for charts are presented in one newdialog “3DView”. It offers settings for perspective, appearance, andillumination. The user can also choose “right-angledaxes” to easilyensure vertical and horizontal axes. | ingrid.halama@sun.com | speclink | chart | |
| New Default Colors for Charts | i7019 | bjoern.milcke@sun.com | speclink | chart | ||
| Chart-Specific Toolbars | i70287 | When editing a chart the user interface provides somechart-specific functions in toolbars. | bjoern.milcke@sun.com | speclink | chart | |
| Terms for Chart Elements | i74907 | Chart Object Names | This document specifies the names of the differentchart objects. | ingrid.halama@sun.com | speclink | chart |
| Terms for Chart Elements | i74909 | Chart Object Names | This document specifies the names of the differentchart objects. | ingrid.halama@sun.com | speclink | chart |
| simplified 3D dialog for charts | i75176 | The 3D settings for charts are presented in one newdialog “3DView”. It offers settings for perspective, appearance, andillumination. The user can also choose “right-angledaxes” to easilyensure vertical and horizontal axes. | ingrid.halama@sun.com | speclink | chart | |
| Right-angled axes for 3D Charts | i76430 | The 3D settings for charts are presented in one newdialog “3DView”. It offers settings for perspective, appearance, andillumination. The user can also choose “right-angledaxes” to easilyensure vertical and horizontal axes. | ingrid.halama@sun.com | speclink | chart | |
| Show formula and R^2 for regression curves in StatusBar and Extended Tip Help | i78442 | Chart Object Names | This document specifies the names of the differentchart objects. | bjoern.milcke@sun.com | speclink | chart |
| keyboard shortcuts for task pane entries | i72799 | feature-info: With the integration of CWS dba23ui, the entries in Base's task pane(the upper pane with items such as "Create a new table..." etc.) haveaccelerator shortcuts, i.e. can be accessed by pressing the Alt key(or whatever is the platform dependent accelerator key) plus therespective shortcut.The shortcuts are determined dynamically at runtime, and do notinterfere with the accelerators for main menu and the left hand sidecategory pane. | frank.schoenheit@sun.com | dba | ||
| / in database object names not allowed anymore | i73084 | feature-info: With the integration of CWS dba23a, database objects (queries, forms,reports) cannot contain slashes / in their name anymore. Thischaracter never reliably worked when used, and since it's used inanother meaning already - separating hierarchies when you, forinstance, put forms or reports into folders -, they have beencompletely forbidden. Every attempt to create or rename an object,giving it a name with a slash, will now be rejected with an errormessage.If Base reads a document which already contains such broken names,then the slashes will silently be converted to underscores _ - whichimplies the objects will then work, again. | frank.schoenheit@sun.com | dba | ||
| New Report Designer | i76758 | At the moment OpenOffice.org Base supports only verylimited reportfunctionality. This document describes the user interface to design areport by hand. This allows the user to design a report with any levelof complexity e.g. grouped records, sorting of records, differentalignment of text fields, and calculations. | MarcNeumann (msc) | speclink | dba | |
| HTML export for draw and presentation documents nowsupports png | i23353 | HTML Export | Documents the HTML Export functionality including theHTML Wizard in OOo Draw & Impress. | ChristianLippka (cl) | speclink | drawing |
| Alternative text for non-text image map | i68099 | Image Map Dialog | This specification documents the image map dialogfeature. | ChristianLippka (cl) | speclink | drawing |
| Alternative text for layers in drawings | i68100 | Layer Dialog | This specification documents the layer dialog that letsthe user insertor make changes to layers in the OpenOffice.org Draw application. | ChristianLippka (cl) | speclink | drawing |
| Alternative text for layers in drawings (now with issuenumber) | i68100 | Layer Dialog | This specification documents the layer dialog that letsthe userinsert or make changes to layers in the OpenOffice.org Drawapplication. | ChristianLippka (cl) | speclink | drawing |
| Preview Document in Web Browser | i74477 | Preview Document in Web Browser | Make the current document previewed by browser as webpage, inorder to see the effect of display before release. dded a new menu itemin the File menu which named 'Preview in Web Browser'. This menu itemcan make the current document browsed in web page. text, picture andmedia that can be edit in the document are all can be browsedsuccessful. | LiuTao | speclink | framework |
| Extension can integrate options pages in the optionsdialog | i75869 | Options Dialog for Extensions | An extension may require to be configured before it canbe usedreasonably or in order to adapt it to personal preferences. Forexample, a spell checker extension could be configured to use differentsets of grammar rules, a clock extension could be configured to showtwelve or twenty four hours, etc. Configuring the extension should beas easy as possible for the user. That is, a dialog should be usedrather then some obscure configuration files which need to be edited.And, of course, this dialog should be easily accessible, that is, itneeds to be found intuitively.Future extensions shall be able tointegrate own options pages into the options dialog. An options page issimilar to a dialog but is lacking the title bar and border so that itcan be shown in a parent window, which is the option dialog. Theoptions dialog can also be started from the Extension Manager, in whichcase it shows only the options pages of the selected extension. | JoachimLingner (JL) | speclink | framework |
| New option: Load printer settings with the document | i76855 | Load Printer Settings with the Document Option | OOo stores and restores printer settings with adocument bydefault. In an enterprise environment with always available printers(i.e. around the world) this could result in printing a document on theother side of the world. Therefore a new option is added to suppressloading document printer settings on loading a document. | Frank Loehmann (FL) | speclink | framework |
| Single dialog export in dialog editor | i77640 | Export Single Dialog from Library | Currently dialogs are always embedded into a basiclibrary.Especially for OOo extensions it would be helpful to have access tosingle dialogs. Therefore the dialog IDE gets a possibility to exportthe current dialog via a new button in the tool bar. | Frank Loehmann (FL) | speclink | framework |
| Link to extensions.openoffice.org in ExtensionManager | i78209 | Link to extensions.openoffice.org | JoachimLingner (JL) | speclink | framework | |
| Editing of path animations is possible again | i41800 | Custom Animation User Interface | The user interface for custom animation now alsosupports addinguser drawn motion path effects and the feature to edit the path ofexisting motion path effects. | ChristianLippka | speclink | presentation |
| testtool: new commands to request webpages | i22679 | feature-info: + Integer HTTPSend | gregor.hartmann@sun.com | qa | ||
| testtool: new implementation for typekeys and mouse* | i45199 | feature-info: the implementation for typekeys and mouseup, mousedown and mousemovehas changedto be able to return to the old implementation (temporarily) a nrecommand has ben establishedUsePostEvents Booldefault is to use the new method so "UsePostEvents false" would returnto the old behaviour | gregor.hartmann@sun.com | qa | ||
| testtool: new methods to access EditBrowseBox | i52436 | feature-info: IMPORTANTto use EditBrowsBox the command SetControlType is not needed anymoresame for ValueSetsnew methods to access EditBrowseBoxText GetSelText returns the text of the selected fieldInt GetColumnCountInt GetRowCount Bool IsEditing TRUE if the field is in edit modeSelect nRow, nColumn go to given field | gregor.hartmann@sun.com | qa | ||
| testtool: config tabpage for Crashreport configuration | i63641 | feature-info: there is a new config tabpage inside the testtool to configure theCrashreporter section of the testtoolrc/.ini | gregor.hartmann@sun.com | qa | ||
| testtool: New option in options dialog to set OOoprogram path | i63642 | feature-info: On the "misc" tabpage there is a new option to set the following partof the testtool.ini/rc called "OOo Program Dir"[OOoProgramDir]Current=so now there are 2 ways to set it from within the testtool: this oneand the generic one via the "generic" tabpage | gregor.hartmann@sun.com | qa | ||
| testtool: method to get state of menu entry ifexpandable | i68654 | feature-info: + BOOL MenuHasSubMenu nItemId | gregor.hartmann@sun.com | qa | ||
| testtool: add new methods for ORoadmap e.g. in wizards | i72795 | feature-info: This contol is used in wizards on the left side of the dialog to showthe steps of the wizardnew methods are:nNr GetItemCountString GetItemText nIndexSelect nIndexnNr GetSelIndexString GetSelTextBool IsItemEnabled nIndex | gregor.hartmann@sun.com | qa | ||
| testtool: new method to get slot execution status | i76851 | feature-info: | gregor.hartmann@sun.com | qa | ||
| Default print options in Calc | i25278 | feature-info: The default values for the following print options in Calchave been changed:- Print only selected sheets (property AllSheets)- Suppress output of empty pages (property EmptyPages)By default those options are now enabled.In addition, if the 'Print only selected sheets' option isenabled, the Calc page preview prints only the displayed sheet.Furthermore a warning box with the message'There is nothing to print. The selected print range or sheet isempty.'is shown, if nothing is printed, e.g. if the document,selected sheet or print range is empty. | thomas.benisch@sun.com | sc | ||
| Support of inline matrix/array constants in formulas | i32342 | feature-info: Calc now supports inline matrix/array constants in formulas. An inlinearray is surrounded by curly braces '{' and '}'. Elements can be eacha number (including negatives), a logical constant (TRUE, FALSE) or aliteral string. Non-constant expressions are not allowed. Arrays canbe entered with one or more rows, and one or more columns. All rowsmust consist of the same number of elements, all columns must consistof the same number of elements, so that a two-dimensional array has nosparse elements. The column separator (separating elements in one row)is the ';' semicolon, the row separator is a '|' pipe symbol. Theywere chosen because the upcoming ODF formula specification uses theseseparators. Contrary to Excel, the separators are not UI-versionand/or locale dependent. Arrays can not be nested. Import/exportfrom/to Excel are implemented.Examples:={1;2;3}An array with one row consisting of the three numbers 1, 2 and 3.={1;2;3|4;5;6}An array with two rows and three values in each row.={0;1;2|FALSE;TRUE;"two"}A mixed data array.=SIN({1;2;3})Entered as a matrix formula delivers the result of three SINcalculations with the arguments 1, 2 respectively three.={1;2|4;5;6}Invalid array, the first row misses an element. This results inErr:512 "Formula overflow".={1;2+3}Invalid array, the second element is not a constant. This results inErr:512 "Formula overflow".={1;2;{3;4;5}}Invalid array, nested arrays are not allowed. This results in Err:533"Nested arrays are not supported". This is a new error conditionrelevant for translation. | eike.rathke@sun.com | sc | ||
| Keyboard shortcut "Ctrl-1" is now "Format Cells" | i35738 | feature-info: The shortcut "Ctrl-1" in Calc was changed from from "single linespacing" (in drawing objects only) to "cell format dialog". | niklas.nebel@sun.com | sc | ||
| Keyboard shortcuts Ctrl-Plus and Ctrl-Minus forInsert/Delete Cells | i38108 | feature-info: Ctrl-Plus is now "Insert Cells".Ctrl-Minus is now "Delete Cells".Both work like the menu entries: If whole columns or rows areselected, they are inserted/deleted, otherwise the dialog is shown. | niklas.nebel@sun.com | sc | ||
| GETPIVOTDATA formula function | i45843 | feature-info: The GETPIVOTDATA function returns a result value from a DataPilottable, so it can be used in a cell formula. The value is addressedusing field and item names, so it remains valid if the layout of theDataPilot table changes.The field/item names can be passed as a variable-sized parameter list,or as a single string (compatibility syntax).The new function is also imported and exported to XLS files. | niklas.nebel@sun.com | sc | ||
| Division by zero #DIV/0! error displayed for certainfunctions, #NUM! displayed for illegal floating-point operation errors | i47644 | feature-info: Introduced a new error code 532 to distinguish division by zero errorsfrom the more general illegal floating-point operation with error code503.A more user-friendly #DIV/0! instead of Err:532 is displayed. Theillegal floating-point operation now displays #NUM! instead ofErr:503. This should be reflected in the online help under "errorcodes;list of".The list of functions resulting in #DIV/0! includes, but may not belimited to:division operator / if the denominator is 0VARP with less than 1 argument, e.g. only empty cells in a rangeSTDEVP with less than 1 argumentVAR with less than 2 argumentsSTDEV with less than 2 argumentsAVERAGE of nothingAVERAGEA of nothingKURT of nothingZTEST of only 1 pointSUBTOTAL with functions average, stdev, stdevp, var, varp as aboveLOGNORMDIST with stdev=0STANDARDIZE with stdev=0NORMDIST with stdev=0The #DIV/0! error is also exported to MS-Excel so that a recalculationdoesn't flip from #NUM! to #DIV/0! anymore. | eike.rathke@sun.com | sc | ||
| Division by zero #DIV/0! error displayed for certainfunctions, #NUM! displayed for illegal floating-point operation errors | i47724 | feature-info: Introduced a new error code 532 to distinguish division by zero errorsfrom the more general illegal floating-point operation with error code503.A more user-friendly #DIV/0! instead of Err:532 is displayed. Theillegal floating-point operation now displays #NUM! instead ofErr:503. This should be reflected in the online help under "errorcodes;list of".The list of functions resulting in #DIV/0! includes, but may not belimited to:division operator / if the denominator is 0VARP with less than 1 argument, e.g. only empty cells in a rangeSTDEVP with less than 1 argumentVAR with less than 2 argumentsSTDEV with less than 2 argumentsAVERAGE of nothingAVERAGEA of nothingKURT of nothingZTEST of only 1 pointSUBTOTAL with functions average, stdev, stdevp, var, varp as aboveLOGNORMDIST with stdev=0STANDARDIZE with stdev=0NORMDIST with stdev=0The #DIV/0! error is also exported to MS-Excel so that a recalculationdoesn't flip from #NUM! to #DIV/0! anymore. | eike.rathke@sun.com | sc | ||
| Cell context menu entry changed | i47732 | feature-info: The cell context menu entry "~Default" has been changed to "~DefaultFormatting". Now, the entry is equal to the corresponding context menuentry in a Writer document (see http://www.openoffice.org/issues/show_bug.cgi?id=39939). | daniel.rentz@sun.com | sc | ||
| Renamed checkbox in Paste Special dialog | i50436 | feature-info: In Calc's Edit -> Paste Special dialog, the checkbox "~Strings"has been renamed to "Te~xt". | daniel.rentz@sun.com | sc | ||
| Checkbox in Delete Contents dialog renamed | i50439 | feature-info: In Calc's Edit -> Delete Contents dialog, the checkbox"~Strings" has been renamed to "~Text". | daniel.rentz@sun.com | sc | ||
| Extend AutoSum Capabilities in Calc | i51564 | Extend AutoSum Capabilities in Calc | OpenOffice.org Calc's capabilities to sum up cellvaluesautomatically are extended. The cell range used for summation isspecified by the user. All values in the marked area are summed upcolumn- and/or rowwise and the result is inserted automatically as asum formula. | thomas.benisch@sun.com | speclink | sc |
| Renamed "Set Input Mode" to "Toggle Edit Mode" | i53756 | feature-info: The description of the slot .uno:SetInputMode has been changed from"Set Input Mode" to "Toggle Edit Mode". This slot is used toenter/leave the cell edit mode in spreadsheets using the F2 key. Pleasesee the issue for details. | daniel.rentz@sun.com | sc | ||
| Shortcut for Format->Cells menu entry changed | i55972 | feature-info: The shortcut for the menu entry "Cells" in the "Format" menu has beenchanged from "~Cells" to "Ce~lls" to prevent clash with the globallydefined entry "~Change Case". | daniel.rentz@sun.com | sc | ||
| Ctrl + ~ (Ctrl + `) toggles formula view | i56202 | feature-info: Ctrl + ~ (Ctrl + `) now toggles formula view i.e. the cells displaythe (formula) result or the formula that the cells contain. Thisapplies to all the cells in the table.The shortcut key can also be configured through the customize option.Ctrl + ~ is available for English keyboard layouts only. Fornon-English Keyboard layouts, the shortcut key has to be configured toa different key combination. | muthusuba@openoffice.org | sc | ||
| Dynamic ranges as formula results in validation lists | i56566 | feature-info: Calc now supports dynamic ranges as formula results in validationlists, menu Data.Validity, pick "Cell range".Previously, only directly entered range references such as A1:A5 ordefined names that simply (recursively) evaluated to a range weresupported.Now also a formula that evaluates to a range or an array can beentered, such asINDIRECT(A1)if A1 contains a string that evaluates to a range, such as B2:C3.Defined names are deeply evaluated now and don't need to be defined toa simple range, a formula returning a range or an array here is fineas well. This makes it possible to define a name to a complex formulathat calculates a rectangular area and enter that defined name in thevalidation dialog.The restriction that a range has to be exactly one column or one rowwas removed. If a two-dimensional area is given, the elements in theselection list are listed row-wise if not sorted.If the range or formula calculation results in an error, that error isdisplayed as the only value of the selection list box.The hint displayed below the Source edit field was adapted to "A validsource can only consist of a contiguous selection of rows and columns,or a formula that results in an area or array." | eike.rathke@sun.com | sc | ||
| Drawing objects support Basic macro calls | i59082 | Support Macros for graphic and autoshapes in Calc | To improve MS Excel interoperability, support forassociating | NoelPower (NP) | speclink | sc |
| JIS and ASC Spreadsheet Functions | i70213 | er@openoffice.org | speclink | sc | ||
| "Form Objects" toolbar removed | i71900 | feature-info: The toolbar "Form Objects" has been removed from Calc. It was aremaint from the times before the Big Toolbar Renewal, did exist inCalc only, and contained only items which nowadays are to be found inthe "Form Design" toolbar. | frank.schoenheit@sun.com | sc | ||
| Toolbars "Insert" and "Insert Object" merged | i73123 | This specification covers the Toolbar content changesfor OpenOffice.org 2.0 | FrankSchönheit | speclink | sc | |
| Changed menu entry Data->Outline | i77653 | feature-info: The menu entry "~Outline" (Data menu) has been changed to "~Group andOutline". | daniel.rentz@sun.com | sc | ||
| Default print options in Calc | i78488 | feature-info: The default values for the following print options in Calchave been changed:- Print only selected sheets (property AllSheets)- Suppress output of empty pages (property EmptyPages)By default those options are now enabled.In addition, if the 'Print only selected sheets' option isenabled, the Calc page preview prints only the displayed sheet.Furthermore a warning box with the message'There is nothing to print. The selected print range or sheet isempty.'is shown, if nothing is printed, e.g. if the document,selected sheet or print range is empty. | thomas.benisch@sun.com | sc | ||
| Intro and about bitmap location changed, configurescript extended | i66426 | feature-info: To better support the creation of adapted OpenOffice.org installationsets we now support the following options with the configure script.intro-bitmaps[ --with-intro-bitmaps Prefer the specified intro bitmaps over the thedefault one. Can be more than one(separated by commas), the order means priority offallback if the first does not exist (in the installed tree). Usage:--with-intro-bitmaps=/path/my_ooo_intro.bmp],,)about-bitmaps[ --with-about-bitmaps Similarly to --with-intro-bitmaps, this allowsspecification of bitmaps for the About box. Usage:--with-about-bitmaps=/path/my_ooo_about.bmp],,)vendor,[ --with-vendor Set vendor of the build. Usage: --with-vendor="John theBuilder"],,)The location of the intro and about bitmaps have changed in thefollowing way:- "svx/res/oooabout.bmp"- "svx/res/ooointro.bmp"- "svx/res/brabout.bmp"- "svx/res/brintro.bmp"- "svx/res/soffice.bmp"- "svx/res/ofaabout.bmp"+ "default_images/introabout/about.bmp"+ "default_images/introabout/intro.bmp"+ "ooo_custom_images/broffice/about.bmp"+ "ooo_custom_images/broffice/intro.bmp"+ "custom_images/so/introabout/about.bmp"+ "custom_images/so/introabout/intro.bmp" | carsten.driesner@sun.com | tools | ||
| Selectable FixedTexts | i64785 | feature-info: Now the values of File - Properties... - General (Type. Location,Size...) are selectable and can be copied into the clipboard. | hans-peter.burow@sun.com | ui | ||
| Changed shortcut for "Object" in the Edit menu | i72608 | feature-info: The shortcut of the menu entry "Object" in the Edit menus of theapplications (Writer, Calc, Impress, Draw) has been changed from O toJ, to prevent clash with "Delete C~ontents". | daniel.rentz@sun.com | ui | ||
| Standard Color Palette Extended by new Chart DefaultColors | i75202 | With the Tools/Options/Charts/Default Colors dialog aset ofdefault colors can be defined. These default colors are applied to thedata series of newly created charts, as well as data series added toexisting charts. | bjoern.milcke@sun.com | speclink | ui | |
| Automatic update for charts in Writer | i55007 | feature-info: Hi,As with CWS chart2mst3:The checkbox in the dialog "Tools/Options/Star Office Writer/General"named"Charts" is now indented the same level as the "Fields" box. Alsoenabling/disabling the "Field" box does not have an effect on the"Chart" boxanymore. Thus toggling of automatic updates for charts is now fully aflag on it's own.If that flag is set and changes to a table cell (with a chartattached) are made the chart will be updated a moment after the cursorleaves the current cell. And this is right after the formula fields ina table got updated. Thus chart will get the correct value for everyfield.Previously the chart was only updated if cells/rows/columns gotdeleted/inserted or if a cell changed that was used in a formula fieldof another cell.Now all changes to a cells content will trigger the automatic updatefor the chart object if the cursor leaves the cell.Regards,Thomas | thomas.lange@sun.com | word processing | ||
| Language Guessing | i73173 | Automatic Language Guessing Component | The following component allows to determine the langueof a(selected) text. This feature works without using wordbooks, so thelanguage could be determined without having a special wordbookinstalled for that language. This feature was developed during a Googlesummer of code. | Frank Loehmann (FL) | speclink | word processing |
| Ctrl-click to execute hyperlinks | i75130 | Smart Tags | A smart tag scans the text of a document thru an API(i.e. forstock symbols like “SUNW”) and could offerfunctionality for such arecognized text via a context menu. Smart tags can be provided byextensions. This first version will support Writer text documents onlyand is only visible in the product if at least one Smart Tag has beeninstalled. | FrankLoehmann | speclink | word processing |
| New Smart Tag API and UI | i75130 | Smart Tags | A smart tag scans the text of a document thru an API(i.e. forstock symbols like “SUNW”) and could offerfunctionality for such arecognized text via a context menu. Smart tags can be provided byextensions. This first version will support Writer text documents onlyand is only visible in the product if at least one Smart Tag has beeninstalled. | FrankLoehmann | speclink | word processing |
| 'Old' mail merge dialog now supports output to singlefile | i76853 | Rework Simple Mail Merge Print Dialog | The simple mail merge dialog is often used to printalready presentmail merge documents. The new mail merge wizard seems to be overloadedfor those existing mail merge documents. The feature to save the mailmerge in a single document is not implemented yet for this old dialog.This specification defines how this feature gets integrated into thisdialog. | Frank Loehmann (FL) | speclink | word processing |
| Soft page break | i78650 | The ODF 1.1 allows the export of soft page breaks. Asoft pagebreak is a page break that has been inserted by a page orientedprocessor like Writer at a position where the document itself does notinclude a page break (e.g. paragraph attribute page breakbefore/after). | AndreasMartens | speclink | word processing |
| Shortcut for "Repeat" | i41586 | feature-info: We added a new shortcut for "Repeat": | hans-peter.burow@sun.com | framework | ||
| New writer compatibility option | i45491 | feature-info: There is a new compatibility option on Tools - Options - Writer -Compatibility:"Do not justify alignment in lines ending with manual line break" | hans-peter.burow@sun.com | framework | ||
| Password of a document is asked untill the correct oneis entered or the dialog is cancelled. | i75966 | feature-info: While opening an encrypted document the password should be asked againif an incorrect one was entered, otherwise an information loss ispossible. Please see the related task for details. | Mikhail.Voitenko@sun.com | framework | ||
| Menu and toolbar merging support for extensions | i78020 | New feature for Add-ons to merge into OpenOffice.orgmenu bar and toolbars | speclink | framework | ||
| Default Macro Security Level changed | i79170 | Electronic Signatures and EncryptionGraphical UserInterface (GUI) | malte.timmermann@sun.com | speclink | framework | |
| First word in a Calc cell will no longer be capitalizedby auto-correction | i78661 | feature-info: As requested in the issue the auto capitalization of the first word inthe first paragraph of a cell will no longer happen in spread sheets.This behavior is independent(!) of the respective setting forauto-correction.Developer notes:To allow for this the EditEngine has two new functions- IsFirstWordCapitalization and- SetFirstWordCapitalizationCalling SetFirstWordCapitalization( FALSE ) will override theauto-correction setting and result in the described behavior. Thedefault is TRUE. | thomas.lange@sun.com | sc | ||
| Customize Keyboard tabpage | i75754 | feature-info: There are some improvements of the Customize-Keyboard-TabPage. Now theCategory-, Function- and Keys-Box are wider and the Load-, Save- andReset-Button have new positions. The width of the tab of theShortcut-Keys-Box is calculate dynamically. | hans-peter.burow@sun.com | ui | ||
| Compatibility option "Expand word space..." added | i45491 | Compatibility Options | Allow configuration of behavior when a line break isinserted | FrankLoehmann (FL) | speclink | word processing |
| New export filter: MediaWiki | i48409 | MediaWiki Export Filter | This document describes the usage of the Openoffice.orgMediaWikiexport filter and its formatting features. This adds the feature toexport Writer and Writer/Web documents to a text file in Wikitextsyntax. | mathias.bauer@sun.com | speclink | word processing |
| Spell checking one letter words | i78734 | feature-info: As requested in the issue one letter words will now also be spellchecked.Regards,Thomas | thomas.lange@sun.com | word processing |
Copyright & License |Privacy |Contact Us |Donate |Thanks
Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The ASF logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.