KOffice 1.3 Changelog

The following summarizes the major changes and bugfixes to the KOffice Suite since the release of KOffice 1.2

KOffice Libraries

• New command line option: --print. Prints the document(s) passed on the command line, without showing a window. Useful for scripts and servicemenus.
• Support for opening backup files (e.g. foo.kwd~)
• Page Layout Dialog: validate user input to prevent nonsense (e.g. margins wider than page)
• Support for EPS images: works again for gs interpreters without the png16m device
• Cache the configuration object around kofficerc, to improve startup performance

Fixes:

• Restart autosave timer when saving
• Fixed saving of the window size when closing
• Fixes for remote documents (authentication dialog not on top, error handling)
• Many stability fixes in spell checking
• Fixed doc/window association which led to closing all windows when closing only one
• Fixed bug where the dialog wouldn't show the spell client from the config file

KoText library features (shared between KWord and KPresenter):

• Paragraph borders now support variable width (e.g. being inside DTP frames of different widths)
• Improve hierarchical numbering - doesn't require using a suffix of '.' anymore, and doesn't copy over the prefix and suffix from parent levels anymore (#40911)
• PgUp/PgDown works better than before when "move the caret" is enabled (#45246)
• Implemented painting of non-breakable-spaces when "draw formatting characters" is on
• Added more default formats for date variables
• Added time/date variable offset (new)
• Added new variables: Next page number, Previous page number (new)

Formatting:

• Text formats now include language information (new)
• New line spacing types: at least / exactly / multiple of (new)
• New font attributes: small caps, uppercase, lowercase (new)
• New underline and strikethru type: word by word
• Repainting fixes (in multiline paragraphs)
• Linespacing fixes (at-least and multiple work as advertised, added "fixed")
• Major reduction of the memory usage per paragraph
• Hyphenation fixes (support for breaking the same words more than once)
• Shadow is now a character property (instead of a paragraph property)
• More precise painting of paragraph borders

Fixes:

• Fixed painting of non-breakable-spaces (could show up as a visible square)
• Fixed crash (e.g. happening with 'section title' variable, #61735)
• Fixed pasting of plain text (so that it creates new pages if necessary, #58651)
• Fixed insert dialog for date and time variables
• Fixed missed hit during search-replace backwards with a single paragraph
• Fixed rare crash when applying a format to a selection
• Fixed painting bug in text view mode (the right side was being erased)
• Fixed saving of left-to-right direction in RTL paragraphs
• Created/modified/printed document date (bug #24242)

KWord

• Language added as a new character property
• Possibility to copy/remove links
• Added support for converting table to text
• Horizontal line
• Sorting of text
• Improved statistics dialogbox : count number of lines
• Hyphenation support. Configurable as a character property (to disable hyphenation on specific words)
• PDF import filter
• Right-click on a selected frame shouldn't unselect it
• Esc to deselect all frames
• Don't select inline frame after pasting text containing it (only select non-inline frames)
• Improved "create style from selection": use format at cursor if no selection, allow to type the name of an existing style to update it, and select the style for the current paragraph after creating it
• Frames default to "auto-resize" mode instead of "auto-create-new-page"
• Better handing of "auto-resize" mode (manually-set size acts as minimum size)
• Make the find dialog avoid the area where the match is (requires kde-3.2)

Fixes:

• Fixed Paragraph numbering: simple lists are not restarted by simple text in between
• Fixed line-height bug due to hyphenation
• Fixed handling of part frames (clicking didn't select it anymore, #63041)
• Fixed cursor shape when pressing Ctrl
• Fixed cursor in text view mode (#57554)
• Added fix for frames extending beyond the page getting the wrong size in 'preview mode'
• Fixed wrong layouting of inline frames (e.g. pictures)
• Fixed crash in table operations (#66349)
• Fixed crash in table iterator
• Fixed "edit frameset" for tables in doc structure panel (#67084)
• Save "no underline" explicitly if the paragraph layout says "underline" but the user removed the underline (#67735)
• Fixed successive image DnD
• Load and save the frames order ("z index")

KPresenter

Text boxes:

• Can spellcheck in selection only (new)
• Shadow is a text property now (bugfix)
• Link manipulation (add/copy/remove) (new)
• Access to spellcheck result via context menu

Images:

• Properly draw images with alpha channels (bugfix)
• Better loading of background pictures; especially for remote files (new)

Configurability:

• Whether and where to create backup files (new)
• Path to pictures (new)
• Personal dictionary (new)
• List of ignored words when spellchecking (new)
• Go with a per-slide default when inserting a new one (wish #22629)
• Printing of slide notes (wish #56120)

Misc:

• Web presentation: better HTML generation, usability improvement of the wizard (new)
• Comment text can be copied now (bugfix)
• Undo/redo shows history of commands (new)
• Objects use "forbidden" cursor when they're protected (new)
• Display an "End of presentation"-slide at end of presentation; configurable (new)
• Transition effect dialog with preview (new)
• Grid, snap to grid are on now by default, with a finer step of 5mm (#60011 and #60013)

Fixes:

• Fixed copy/paste of images/embedded objects between different instances
• Fixed flipping groups horizontally/vertically (#45561)
• Fixed loading of old documents with invalid paragraph indents
• Fixed initial size of pasted images (#59058)
• Fixed adjusting of font size in the toolbar (#39786)
• Fixed problem with disappearing objects on dinA0 presentations (#37370)
• Fixed large offset in print preview and printing (#56123)
• Fixed KPR 'forgetting' solid line attribute of text frames (#61343)
• Fixed pasting text objects with UTF-8 text
• Snap to Grid function aligns relatively, not absolutely (#56181)
• Fixed problem with cutting&pasting a vertically centered text frame (#61330)
• Fixed cursor not blinking in some cases
• Fixed "blinking cursor erases formatting characters" bug
• "Adjust object to contents" works as intended now
• Clarified purpose of the 'Notebar' (#63037)
• Fixed crashed when inserting the variable "section title" (#61735)
• Fixed embedded KSpread object getting wrong size (#33233)
• Fixed hang when inserted text wraps to newline (#56946)
• Fixed layer lowering (#53277)
• Fixed problem with zoomed out resize handles (#61602)
• Fixed painting garbage at a side of the screen in the presentation mode (on weird DPIs)
• Fixed snap to grid when resizing a frame (#63032)
• Fixed when after resize/undo size of object is not the same
• Fixed when after move/undo position of object is not the same
• Fixed resizing of poly line objects
• Fixed after reload of some objects moved up a little bit
• Fixed moving with key left used in grid
• Fixed header/footer moved in undo
• during a presentation variables on the sticky page were not updated (#67515)
• font sizes are lost after reload (#72120)
• duplicate slide doesn't exactly duplicate it, some formats are lost (#72126)
• text style is not used if text field is empty (#72129)

KSpread

• Real more than one currency support
• New date and time formats
• Enhanced the "Text to Columns", "Insert from file" and "Insert from clipboard" dialog to support "ignore double delimiters"
• "Insert from file" now also adjusts the column width depending on imported cell content
• Enhanced the CSV import dlg
  • to support "ignore double delimiters"
  • to adjust cell width to imported cell content
  • you can specify the column and row range for import
• Enhanced the CSV export dialog so that you can choose
  • table to export
  • delimiters between tables
  • delimiter between cells
  • character for quotes
  • export selection only
• Goal Seek message fixes + you can select the cells with the mouse now
• Enhanced Gnumeric import filter to support
  • background (color + patterns), borders (colors + style)
  • font formating, text alignment
  • format parsing (date, time, numbers,...), cell height, width
  • print range, page setup, hidden columns/row, comments
• New OpenCalc export and import filter
• Added subtotal dialog and formula
• Paper layout can now be applied to all sheets
• Now you can define the default cell style
• Autoscroll while selecting now also available for columns and row headers
• When cell is too short, then the content is now available in the tooltip
• Drag 'n' Drop of selections
• Protection of sheets or of the document structure (with or without password)
• Protection tab in layout dialog: you unprotect certain cells, hide their contents, hide the formulas, or select them for not being printed
• FindNext, FindPrevious cell enhancement for find
• Fill: Fill area from right to left, left to right, bottom to top, top to bottom
• Full zoom support
• Printing:
  • High resolution printing (600dpi)
  • Improved WYSIWYG
  • Zoom support on printout
• New direction mode when pressing Enter: you can jump now to the first cell of the next row
• Hierarchical style support
  • builtin styles
  • creation of custom styles
  • creation of custom styles using a cell as template
• Insert special characters
• Smaller, more efficient file format
• Many performance enhancements
• More powerful conditional cell attributes (you can assign a whole style if condition matches)
• Conditions can be used for text and numbers now (was numbers only before)
• Adjust print zoom to limit printout to m x n pages
• New templates: Balance Sheet, Price Quotation, Packing Slip
• Improved speed of text to column conversion (#59999)

New functions:
GETPIVOTDATA, BESSELI, BESSELJ, BESSELK, BESSELY, ERF, ERFC, CONVERT

Date/Time (16): EDATE, EOMONTH, DAYS360, WEEKDAY, TIMEVALUE, DATEVALUE, YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DAYNAME, MONTHNAME, EASTERSUNDAY, ISOWEEKNUM

Math (16): SUBTOTAL, POWER, TRUNC, CEILING, PRODUCT (now Excel compatible), KPRODUCT, RANDEXP, RANDBINOM, RANDNEGBINOM, RANDBERNOULLI, RANDPOISSON, MROUND, COUNTA, MINA, MAXA, SUMA

Statistical (24): VARP, STDEV, VAR, STDEVP, GEOMEAN, HARMEAN, KURT, LOGINV, DEVSQ, STANDARDIZE, HYPGEOMDIST, NEGBINOMDIST, KURTP, CORREL, COVAR, SMALL, LARGE STDEVA, STDEVPA, VARA, VARPA, SKEW, SKEWP, MODE

Financial (19): PPMT, DDB, DURATION, PMT, NPER, ISPMT, IPMT, TBILLEQ, TBILLPRICE, TBILLYIELD, ACCRINT, ACCRINTM, COUPNUM, DOLLARDE, DOLLARFR, DISC, EFFECT, INTRATE, RECEIVED

Database (12): DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP

Reference & Lookup (8): ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, INDIRECT, ROW, ROWS

Engineering (2): DELTA, GESTEP

Logical (2): FALSE, TRUE

Information (2): ISNONTEXT, ISNUMBER

Obsolete formulas:

• stddev (was stddevp in fact)
• day (is dayname now)
• month (is monthname now)

Obsolete (does no longer show up in dialog) but still usable formulas: variance, pow, isnottext, isnum, effective

Fixes:

• Fixed KSpread redrawing problem during and after 'Print Preview' (#60147)
• Fixed KSpread crash when changing paper orientation (#60279)
• Fix problem cycling absolute cell reference with F4 key (#46959)
• The calculator plugin saves its configuration now (#49954)
• Fixed problem with calculating dates (#64794)
• Fixed cell border of merged cells (#61570)
• Fixed display of text starting with a single quote
• Fixed problem formatting the whole row (#65504)
• Made the top/middle/bottom alignment buttons work
• Fixed problem with reference from another sheet (bug #60455)
• Show indicator of chosen/selected cells (bug #58098)
• Hide in-place cell editing when choosing other sheet
• Proper zoom and display of formatted hyperlink (#66214)
• Fixed flickering problem with many hyperlinks (#65501)
• Don't crash when leaving the preview in Konq (#65928)
• Fixed redraw problem with Print Preview (#60147)
• Support only one zoom for two or more views
• Fixed painting problem with multiple views
• Prevent possible crash with conditional formatting (#58713)
• Fixed dependency problem with automatic recalculation (#58097)
• Better adjustment of cell references on cut & paste
• Fix crash on csv import (#66047)
• Fix problem for cells copy/cut to clipboard (#58712)
• Show frame when embedded object is selected (#37152)
• Better handling of "nothing to print" warning (#60147)
• When embedded, use real zoom instead of scaling (#45503)
• Fixed data sorting (#63317)

Kugar

• Kugar and Kugar Designer are now pure KOffice applications. Partification was made and KOffice zipped xml format is used
• Create reports with data and template stored in one file
• Print reports from command line
• Support for fields list in detail sections
• DCOP interface
• Integration with Kexi
• Undo/Redo functionality in Kugar Designer
• Direct database support in Kugar

Kugar Designer

• Redesign for the KOffice architecture
• New user-friendly interface
• Flexible property editing for report elements and multiple selections of elements
• Flexible placing and resizing report elements
• Cut, copy and paste for report items
• Undo/redo operations
• Manual z-ordering for report items
• DCOP interface

Kivio

• GUI cleanup
• Better KOffice integration
• Implemented real clipboard support
• Added more stencils
• Improved diastencil support
• Added template support
• The connector tool now snaps to targets before the grid/help lines
• The select tool now snaps to targets before the grid when resizing connectors

Fixes:

• Fixed embedding of kivio in other KOffice app
• Fixed layout problem at start up when using a template
• Fixed deletion of connected connectors
• Fixed copying text in other codecs then latin1
• Fixed the size of the stencilbar when loading stencils at start up
• Lots of other bugfixes

KFormula

• Support for multi-line formulae including element alignment
• Changeable char attributes
• New over- and underlines

Karbon

• Improvements on layer/document tree
• Added document preview
• Changes to move karbon file format towards svg/OO Draw formats
• Extended star tool with 6 new types
• Extended ellipses with 3 new types
• Extended spirals so it can have rectangular structure
• Added aligning options
• Made plugin structure
• Added new zoom tool and zoom options
• Added menu option to import drawings into current document
• Improved cut/copy/paste
• Added option to perform transformations on cloned shapes while leaving original intact
• New tool controller
• Refactoring flattenpath command after WMF filter changes
• Zooming fix
• SVG exporting uses document dimension, not dimension of the active selection
• New style docker introduced, with dragable clipart
• Added aspect-ratio keeping way of scaling for select tool
• Various ui tweaks, including new icons
• Improved behavior for strokefill preview widget
• Speedups on large documents for the document tree widget
• Make imported SVG's visible by default
• Update statusbar info while moving the selection using arrow keys
• Delete key now deletes selected object (#68062)

Fixes:

• Fixed freeze when opening certain karbon files (#68499)
• Fixed loading recent files
• Fixed zooming into rectangular areas (#60842)
• Fixed crash with polyline tool drawing + Ctrl key (#63981)

Filters

KWord MSWord import filter (requiring wv2-0.1.9):

• Support for Word 6 and Word 7 (aka Word 95) files added
• Fixed the list handling for weird corner cases
• wv2 isn't so noisy anymore, when compiled with --disable-debug. Packagers are highly encouraged to use that flag

KWord RTF export filter:

• Re-written filter
• Improved table support
• Better conformity to RTF specification
• Better export for other RTF readers
• Better document information
• Declare fonts better (especially not Western European ones.)
• Better date and time fields (except locale dates/times.)
• Fix word-by-word underline

KWord RTF import filter:

• Import non-7-bit-clean files
• Fix underline import
• Better picture support (all forms except "picture in shapes")
• Speed up importing files with many Unicode characters
• Support for the field-like keywords for date, time and page number
• Allow non-ASCII style and font names
• Fix header/footer when they are the same for all pages
• Allow all combinations of first, odd, even page headers/footers

KWord OpenOffice.org Writer export filter:

• New!

KWord OpenOffice.org Writer import filter:

• New!

KWord MS Write export filter:

• New!

KWord MS Write import filter:

• Portable rewrite using LibMSWrite

KSpread CSV import filter:

• Be careful when the first column is declared as numeric by the user but in reality it is not a number. (#66047)

KSpread HTML export filter:

• Fixed RTL problems with sheet and cell direction

KSpread OpenOffice.org Calc import filter:

• New!

KSpread OpenOffice.org Calc export filter:

• New!

KPresenter OpenOffice.org Impress export filter:

• New!

KPresenter Magicpoint import filter:

• New!

Karbon filters:

• OpenOffice.org Draw import filter with limited functionality
• Improvements on SVG import/export
• Improvements on Kontour import filter