KOffice 1.3-beta1 Changelog

The following summarizes the major changes to the KOffice Suite since the release of KOffice 1.2 (latest stable version).

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.

KoText library features (shared between KWord and KPresenter):

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

Variables:

• created/modified/printed document date (bug #24242)
• added time/date variable offset (new)
• added new variables: Next page number, Previous page number (new)

KWord

New features:

• 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)

Bugfixes:

• Paragraph numbering: simple lists are not restarted by simple text in between

KPresenter

Visual stuff:

• 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)

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)
• copy/paste image/embedded objects between different instances (bugfix)
• comment text can be copied now (bugfix)
• undo/redo shows history of commands (new)

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
• hierachical 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)

New functions:

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 but still usable formulas (do not show up in dialog): variance, pow, isnottext, isnum, effective

Kugar

• Redesign for the KOffice architecture
• 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

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
• Lots of bugfixes

Kexi

• Hiding of database backend specifics from the user, but allowing advanced users full access at the same time
• Table structure altering
• Table creation
• Easy database query creation, without the need of knowing SQL (Structured Query Language)
• User-friendly data manipulation (even on complicated queries)
• Easy data report generation using Kugar
• User-defined forms for data input and presentation
• Scripting support with a JavaScript/ECMA-Script like language (QSA)
• MySql backend
• CQL++ backend and embedding

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

Filters

KWord:

• new RTF export filter for KWord (replacing the old one; new: styles, picture...)
• better RTF import filter (better support for old RTF files)
• new OpenOffice.org Writer import filter

KPresenter:

• new OpenOffice.org Impress import filter
• new Magicpoint import filter

KSpread:

• new OpenOffice.org Calc import and export filters

Karbon:

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