Jeff Prater wrote:
Where would I find a list of changes/additions for the new version of OOo?
I'd like to update some of the older guides if possible. I just want to know
what to look for. Do you guys subscribe to a developer mailing list too?
-----
Jeff Prater
Hello,
I searched the list archive and apparently this message that I thought I
sent on the 17th last month never made it on the list... If it did, then
I would like to apologise for the duplication.
Cheers,
Michele
Jean Hollis Weber wrote:
OOo v3.2 is due out around the end of November. Several books (Getting
Started, Writer Guide, Impress Guide) needs to be updated from v3.0 to
include v3.1 and 3.2 features. Anyone who can help with reviewing and
marking where changes are needed -- please do so! (Huge thanks to the
people who have already been reviewing and have left files in Feedback
folders for me to deal with when I have time to get to them.)
And the Draw Guide has not yet been updated from v2.x to v3.x at all!
The Calc Guide is mostly up to date with features, even though several
chapters are still unfinished.
--Jean
WARNING: I am sending this email in HTML format as I have copied and
pasted some HTML tables and some hyperlinks. As plain text would not
work, I will also upload an odt document on OOoAuthors with the contents
of this email.
Hello Jean,
I have been going through the release notes of the OOo3.2 m60 snapshot
and I have listed below the new features compared to OOo 3.1 which I
have grouped by component.
They hyperlink should provide more details. As I am not very familiar
with Base I was not in the position to judge which are the new features
that are worth capturing in the documentation. The document I used is
available here, so maybe someone with experience in Base could take a
look at it:
http://development.openoffice.org/releases/DEV300_m60_snapshot.html
As for the new features between 3.0 and 3.1 all I could find is this:
http://www.openoffice.org/dev_docs/features/3.1/
nice, but not as detailed as I would have wished. If someone has by any
chance a copy of the release notes of version DEV300_m40 I can offer to
compile a more detailed list.
I think I should be able to make the necessary changes in the Impress
and Writer guide.
Cheers,
Michele
Framework changes (affect all applications)
Default button in password dialog now is "OK" i102230
<http://www.openoffice.org/issues/show_bug.cgi?id=102230> feature-info:
Though it is only a bugfix, but as it changes the UI: The OK button in
the password dialog now is the default button again
All document events in the Application Framework now can be assigned to
Macros i83692
<http://www.openoffice.org/issues/show_bug.cgi?id=83692> feature-info:
Until now only a selected number of document events could be assigned to
macros using the "Customize Event" dialog, though they could assigned
via API or ODF. Now the dialog shows all existing events. No new events
have been added.
Keyboard shortcut configuration dialog now supports "ALT" modifier
i4756 <http://www.openoffice.org/issues/show_bug.cgi?id=4756> feature-info:
Though the configuration itself was able to handle it all the time, the
dialog for configuring keyboard shorcuts never allowed to use the
ALT-key. Now ALT as well als SHIFT-ALT, CTRL-ALT, SHIFT-CTRL-ALT
modifiers can be used in the dialog. The dialog does not check if a
shortcut can be used or if the system already catches it. The easiest
way to find out if the shortcut is usable is to use it to navigate to
the corresponding entry in the listbox before trying to assign a command
to it.
Import of password protected Microsoft Office XML files
<http://so-web.germany.sun.com/EIS2/changesmails.EditFeature?Id=4518>
i92645 <http://www.openoffice.org/issues/show_bug.cgi?id=92645>
feature-info:
Import of password protected Microsoft Office XML documents has been
implemented in CWS dr72. All document types are supported that are
handled by the MSO XML import filters: - MS Word 2007 documents (*.docx,
*.docm) - MS Word 2007 templates (*.dotx, *.dotm) - MS Excel 2007
documents (*.xlsx, *.xlsm) - MS Excel 2007 binary documents (*.xlsb) -
MS Excel 2007 templates (*.xltx, *.xltm) - MS Powerpoint 2007 documents
(*.pptx, *.pptm) - MS Powerpoint 2007 templates (*.potx, *.potm) Please
see http://sc.openoffice.org/testdocs/filetype/index.html for a source
of test documents for all applications containing password protection.
Impress changes
Impress and Draw now support comments (formerly known as sticky notes)
to support collaboration i103139
<http://www.openoffice.org/issues/show_bug.cgi?id=103139>
New text field "Page Count" in impress/draw i14832
<http://www.openoffice.org/issues/show_bug.cgi?id=14832>
[email protected] <mailto:[email protected]> speclink
<http://wiki.services.openoffice.org/wiki/Impress/Features/text_fields> presentation
Calc changes
The feature "Notes" has been renamed to "Comments" i103139
<http://www.openoffice.org/issues/show_bug.cgi?id=103139>
Transporting newlines in spreadsheet formulas i35913
<http://www.openoffice.org/issues/show_bug.cgi?id=35913> feature-info:
Newline characters (0x0A, decimal 10) created with Control+Enter in
multiline text cells are now preserved in spreadsheet formulas.
Previously the newline character was replaced by a space character. The
newline character can be searched for using the SEARCH or [HV]LOOKUP or
MATCH functions with the \n regular expression. A newline character can
be inserted in a formula using the CHAR(10) function. If the result
contains newline characters it is displayed as a multiline cell. The
multiline result is exported to file formats capable handling newlines
in cell data, such as CSV.
Calculate with strings i5658
<http://www.openoffice.org/issues/show_bug.cgi?id=5658> feature-info:
While interpreting a formula expression, string content is now converted
to numeric values if conversion is unambiguous, or a #VALUE! error is
set if no unambiguous conversion is possible. Converted are only integer
numbers including exponent, and ISO 8601 dates and times in their
extended formats with separators. Anything else, especially fractional
values with decimal separators or dates other than ISO 8601 would be
locale dependent and are not converted. Leading and trailing blanks are
ignored. The following ISO 8601 formats are converted: CCYY-MM-DD
CCYY-MM-DDThh:mm CCYY-MM-DDThh:mm:ss CCYY-MM-DDThh:mm:ss,s
CCYY-MM-DDThh:mm:ss.s hh:mm hh:mm:ss hh:mm:ss,s hh:mm:ss.s The century
CC may not be omitted and the two-digit year setting is not taken into
account. Instead of the T date and time separator exactly one blank may
be used. If a date is given, it must be a valid Gregorian calendar date.
In this case the optional time must be in the range 00:00 to
23:59:59.99999... If only time is given, it may have any value for
hours, taking elapsed time into account; minutes and seconds are limited
to the value 59 as well. NOTES: The conversion is done for single
arguments, either referenced cell content or inline string, cell range
arguments are not affected, so SUM(A1:A2) now will differ from A1+A2 if
at least one of the cells contain a convertible string, as in Excel ...
Because the conversion is also done for formula inline strings, such as
="1999-11-22"+42, calculations involving inline localized dates now
return an error, e.g. with "11/22/1999" or "22.11.1999". Conversion on
the fly naturally is significantly slower than calculating with numeric
values. Plus, as said, various values are not automatically converted as
the conversion may be ambiguous. You may be interested in the Convert
Text to Number (CTN) extension available at
http://extensions.services.openoffice.org/project/CT2N to interactively
convert textual numbers to permanent numeric values.
Toggle absolute/relative references for multiple cells i16615
<http://www.openoffice.org/issues/show_bug.cgi?id=16615> feature-info:
The Shift-F4 shortcut to toggle between relative and absolute references
in formulas can now be used for a selection of cells, and handles all
the formula cells in the selection.
Additional filter conditions in standard filter dialog i35579
<http://www.openoffice.org/issues/show_bug.cgi?id=35579>
Sorting with toolbar buttons now includes formats i13829
<http://www.openoffice.org/issues/show_bug.cgi?id=13829> feature-info:
When a cell range is sorted using the "Sort Ascending" or "Sort
Descending" toolbar button, cell formats are now sorted with the cells.
More filter criteria in "Standard Filter" dialog i17995
<http://www.openoffice.org/issues/show_bug.cgi?id=17995> feature-info:
The "Standard Filter" dialog now shows 4 instead of 3 conditions, and
has a scroll bar which allows to access up to 8 conditions in total.
Change source range of a DataPilot table i23658
<http://www.openoffice.org/issues/show_bug.cgi?id=23658> feature-info:
It's now possible to change the cell range from which a DataPilot table
takes its data.
"New Style" buttons in "Conditional Formatting" dialog i27253
<http://www.openoffice.org/issues/show_bug.cgi?id=27253> feature-info:
The "Conditional Formatting" dialog now has a button "New Style" next to
each style list box. Pressing one of the buttons opens the "Cell Style"
dialog for a new style, and if OK is pressed there, selects the new
style in the list box. This allows to create a new style without closing
the "Conditional Formatting" dialog.
Cell content is selected in validity selection list i27666
<http://www.openoffice.org/issues/show_bug.cgi?id=27666> feature-info:
If a cell has validity of type "Cell range" or "List", when the validity
selection list drop-down is opened, the existing cell content is now
selected in the list.
Transporting newlines in spreadsheet formulas i35913
<http://www.openoffice.org/issues/show_bug.cgi?id=35913> feature-info:
Newline characters (0x0A, decimal 10) created with Control+Enter in
multiline text cells are now preserved in spreadsheet formulas.
Previously the newline character was replaced by a space character. The
newline character can be searched for using the SEARCH or [HV]LOOKUP or
MATCH functions with the \n regular expression. A newline character can
be inserted in a formula using the CHAR(10) function. If the result
contains newline characters it is displayed as a multiline cell. The
multiline result is exported to file formats capable handling newlines
in cell data, such as CSV.
Double click on document position in status bar opens Navigator i49491
<http://www.openoffice.org/issues/show_bug.cgi?id=49491> feature-info:
A double click on the "document position" control in the Calc status bar
now opens the Navigator, like in Writer.
Applying cell borders to multiple selection i50019
<http://www.openoffice.org/issues/show_bug.cgi?id=50019> feature-info:
Previously it was only possible to apply cell borders to a single
rectangular cell range. Now borders can be applied to any selection of
cells. A list of rectangular ranges is determined from the selection,
and inner/outer borders are applied to each of the ranges.
AutoFill for cells with numbers at the start and end i5550
<http://www.openoffice.org/issues/show_bug.cgi?id=5550> feature-info:
If the starting cell for AutoFill contains a number at the start and the
end, and there's no space after the first number, the number at the end
is now incremented. This allows easier creation of things like lists of
IP addresses (10.0.0.1 is followed by 10.0.0.2).
Sort range dialog i60401
<http://www.openoffice.org/issues/show_bug.cgi?id=60401> feature-info:
If "Sort" is invoked with a selection of more than one cell in a single
column or row, and there are non-empty cells next to the selection, a
new dialog will ask if the selection should be extended to contain those
cells. With this, a user can select only the column of data by which to
sort, and still sort the whole range. It applies to the sort dialog as
well as the "Sort Ascending" and "Sort Descending" toolbar buttons. A
specification is attached to issue 60401.
Easier deselection of sheets if all sheets are selected i70320
<http://www.openoffice.org/issues/show_bug.cgi?id=70320> feature-info:
If all sheets in a document are selected, each of the following actions
deselects all except the current sheet: - Changing the active sheet -
Clicking into the area right of the sheet tabs (if not all sheets are
selected, this opens the "Insert Sheet" dialog as before) - The new
entry "Deselect All Sheets" in the context menu for the sheet tabs
Copy & Paste of merged cells over other merged cells i7500
<http://www.openoffice.org/issues/show_bug.cgi?id=7500> feature-info:
Merged cells can now be pasted from the clipboard onto other merged
cells. Instead of an error message, the old cells are unmerged.
Easier deselection of sheets if all sheets are selected i7921
<http://www.openoffice.org/issues/show_bug.cgi?id=7921> feature-info:
If all sheets in a document are selected, each of the following actions
deselects all except the current sheet: - Changing the active sheet -
Clicking into the area right of the sheet tabs (if not all sheets are
selected, this opens the "Insert Sheet" dialog as before) - The new
entry "Deselect All Sheets" in the context menu for the sheet tabs
Inserting/deleting in the middle of merged cells i8302
<http://www.openoffice.org/issues/show_bug.cgi?id=8302> feature-info:
Inserting or deleting cells, columns or rows into/from the middle of
merged cells, which previously caused an error message, is now possible.
The merged cell range is enlarged/reduced.
Chart
Contex Menu i102820
<http://www.openoffice.org/issues/show_bug.cgi?id=102820> Chart Context
Menu This specification describes the context menus for charts in edit
mode. The context menu for selected charts not in edit mode is defined
in the specification
selection dependent insert menu behavior i103593
<http://www.openoffice.org/issues/show_bug.cgi?id=103593> Chart Menu
This specification describes the menu for charts. It is visible when the
chart is in edit mode (activated via double click for example).
Contex Menu i58163
<http://www.openoffice.org/issues/show_bug.cgi?id=58163> Chart Context
Menu This specification describes the context menus for charts in edit
mode. The context menu for selected charts not in edit mode is defined
in the specification
Contex Menu i69422
<http://www.openoffice.org/issues/show_bug.cgi?id=69422> Chart Context
Menu This specification describes the context menus for charts in edit
mode. The context menu for selected charts not in edit mode is defined
in the specification
Chart Element Selector i7049
<http://www.openoffice.org/issues/show_bug.cgi?id=7049>
This specification describes the tool bars available in context of
charts.
Contex Menu i86146
<http://www.openoffice.org/issues/show_bug.cgi?id=86146> Chart Context
Menu This specification describes the context menus for charts in edit
mode. The context menu for selected charts not in edit mode is defined
in the specification
Rotate data labels i24203
<http://www.openoffice.org/issues/show_bug.cgi?id=24203> Chart Data
Labels The options for data labels have been extended. It is possible
now to define a number format for the value and the percentage value and
to display both values at the same time. Furthermore one can define a
separator for the different parts of the data label. The placement of
the labels can be manipulated via a given set of predefined positions.
Bubble Chart i64689
<http://www.openoffice.org/issues/show_bug.cgi?id=64689> Chart Wizard
This specification describes the Chart Wizard which is used to create
charts. The list of possible chart types now also includes bubble charts
and filled net charts.
Display of hidden cells i91578
<http://www.openoffice.org/issues/show_bug.cgi?id=91578> Plotting of
missing or hidden Values When plotting values in a chart it can happen
that some of the values are missing - for example when a cell was left
empty or did not contain a valid value. The users now can decide what
should be plotted in such cases:a)
Asian typography page for chart elements i92128
<http://www.openoffice.org/issues/show_bug.cgi?id=92128> Asian
Typography tab page for Chart A new tab page "Asian Typography" is now
available for Title, Legend, Axes and Data Series. It contains an option
to enable or disable the spacing between the different types of text.
Writer changes
"Notes" feature renamed to "Comments" i103139
<http://www.openoffice.org/issues/show_bug.cgi?id=103139>
Support for PS-OpenType fonts i43029
<http://www.openoffice.org/issues/show_bug.cgi?id=43029> feature-info:
Postscript based OpenType fonts are now supported (for formatting,
printing, PDF-export and display).
Support for PS-OpenType fonts i78858
<http://www.openoffice.org/issues/show_bug.cgi?id=78858> feature-info:
Postscript based OpenType fonts are now supported (for formatting,
printing, PDF-export and display).
Convert text to table dialog changed i101814
<http://www.openoffice.org/issues/show_bug.cgi?id=101814> feature-info:
The AutoFormat button has been moved in the dialog to ease localization.
The dialog is now similar to Insert/Table. [email protected]
<mailto:[email protected]>
word processing
The base line of Wiki Publisher is changed to OOo3.0 i81373
<http://www.openoffice.org/issues/show_bug.cgi?id=81373> feature-info:
Unfortunately, it is not possible to install an xslt-transformation
filter as a part of extension in OOo2.4. The problem is fixed in OOo3.0,
thus the new base line for the new versions of the extension is moved to
OOo3.0 As result the users of the OOo2.4 will not be able to install the
new version of the extension. [email protected]
<mailto:[email protected]>
word processing
Ctrl+F11 puts the focus into the style ListBox i81468
<http://www.openoffice.org/issues/show_bug.cgi?id=81468> feature-info:
The key combination Ctrl+F11 doesn't call the Style Catalog anymore. Now
it puts the focus into the style ListBox in the toolbox of text, frames,
OLE-objects and pictures. It makes it easier to apply a paragraph or
frame style without using a mouse. [email protected]
<mailto:[email protected]>
word processing
MediaWiki filter is no more installed as part of OOo installation
i99462 <http://www.openoffice.org/issues/show_bug.cgi?id=99462>
feature-info:
The MediaWiki filter is not installed as part of OOo installation any
more. Instead it will be installed as a part of Wiki Publisher
extension, since the two implementations are used together and it allows
to provide updates for the filter independently from OOo releases.
[email protected] <mailto:[email protected]>
word processing
User interface (screenshots)
Optionitem "Icons in menus" now listbox with three options i95318
<http://www.openoffice.org/issues/show_bug.cgi?id=95318> feature-info:
The Tools/Options->OpenOffice.org/View page now has a listbox for the
"Icons in menus" option. The enhancement is implemented in CWS
gtkmenuimages. This was a checkbox before and is now a listbox offering
three options: 1) Automatic 2) Hide 3) Show [email protected]
<mailto:[email protected]>
ui
