path: root/kspread/CHANGES

Changes for KSpread 1.5 Beta 1
==============================

Features
--------
Non-contiguous selection
Rewritten dependency handling
Embedded picture/image inside workbook
Improved and faster formula calculation
Manual line break (wish #9881)
Syntax highlight and function autocomplete for formula editing 
Custom sheet selection and ordering in print dialog

Enhancements
------------
QWhatsThis help is available to various dialogs
Updated dialog screenshot in the handbook
Default autofill increment is set to 1 if only one cell is selected
Sum button automatically selects a suitable cell range 	
Percent operator in formula (wish #101217)
Improved zoomed printouts (bug #115879)
Use standard KDE font dialog in cell format dialog (bug #116991)
Faster redraw of merged cells (bug #118248)

Bug Fixes
---------
#120234: Freeze on circular reference
#120232: Strange behaviour on creating new file
#120204: Cell comment isn't wrapped
#119675: Background brush color is not correctly loaded
#119097: Right arrow for entry and validation
#118769: Better wording cursor movement setting
#117435: Incorrect result from COUNTIF function
#117252: Fix date (and time) increment for autofill
#116903: Indentation setting is not correctly handled in preferences
#116901: Unclear unit setting in preferences 
#116702: Fix freeze with certain spreadsheet content
#116546: Endless dependency calculation
#116444: Fix cell protection
#116236: Crash on OpenDocument with external file cell references
#116144: Incorrect return value of ISBLANK function
#115948: Formatting problem in automerged cells
#115362: Crash when spellchecking
#114693: Comment indicator in sheet properties dialog
#114961: Enter does not move cursor
#114635: Endless loop while loading
#109633: OASIS format wrongly changes vertical align to Bottom
 #50192: Always allow date input in ISO 8601 format

??#483630: Prevent hiding all rows/columns

Developer-Visible Only
----------------------
Manipulators used in commands
KSpread::Cell is associated with KSpread::Format, no longer inherits it
Setter and getter methods for KSpread::Point



since 1.4.1
===========
- Fix slow scrolling left/right (#110551, #101234)

since 1.4.0
===========
- Fix potential crash when rendering obscured cells (#108659)
- Don't automatically make cells left aligned when increasing indent.

since 1.4-beta1
===============
- Use General/Blank Worksheet as default template.
- KSpread crashes on exit if there is a chart in the sheet (#101915).
- The data editor is disabled for charts which has been loaded.
- Don't use 600 dpi as default resolution (the chart printing is much faster now).
- The chart/object printing is simplified and works correctly now. Unfortunately
  this breaks the transform feature but the ordinary rectangle printing is more
  important.
- Paint the child document after it has been inserted.

since 1.3
=========

- fix bug #63332: Pasting into a cell that has spilled out, pastes
  into all overwritten cells
- fix bug #101926: kspread never prints the grid
- Implement save/load Oasis format
- Allow to sort without respect case
- allow editing/removing of links
- fixed bug 76861: bad rendering of hyperlink
- Validation: allow to display or not message
- Add new dcop function
- Start to port KSpread_undo to kcommand
- Add combobox to search area name
- Add Help Message as in oocalc
- multiple steps undo and redo
- fix problem where hidden sheet is simply appended in the tab bar
  (when it is shown again).
- fix bug #81026: SUMIF() function added
- sheet layout direction can be explicitly set (fix bug #46831)
- new dependency manager
- prevent a very wide Insert Link dialog
- fix bug #59291: potential crash on loading new template

changes for 1.3.4
=================
- fix bug #87369: ctrl+C in formula bar doesn't copy contents

changes for 1.3.3
=================
- fix bug #78747: problem with duration format (hh:mm:ss)
- fix bug #74091: wrong special paste from cell with formula
- fix bug #76679: time shown with one second offset

changes for 1.3.2
=================
- fix condition cell attribute (multi condition)
- fix bug #69798: SEXDEC parse error
- fix enable/disable action into validation dialogbox
- fix disable/enable "show table" menu item
- fix bug #69066: crash when viewing a KSpread document in Konqueror

changes for 1.3.1
=================
- fix bug #77844: undo not working after deleting multiple cells
- fix bug #45822: fixed crash when opening a file over the network

since 1.3 RC1
=============
- fix display of text starting with a single quote
- fix problem formatting the whole row (#65504)
- make the top/middle/bottom alignment buttons work
- fix 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)
- fix flickering problem with many hyperlinks (#65501)
- don't crash when leaving the preview in Konq (#65928)
- fix redraw problem with Print Preview (#60147)
- support only one zoom for two or more views
- fix painting problem with multiple views
- prevent possible crash with conditional formatting (#58713)
- fix 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)
- fix data sorting (#63317)

since 1.3 beta4
===============
- #64794: kspread problem with calculating dates
- #61570: cell border does not work with merged cells
- fix unsorted zoom values (#64154)

since 1.3 beta3
===============
- KSpread is slow during text to column conversion (#59999)
- fix problem cycling absolute cell reference with F4 key (#46959)
- the calculator plugin saves its configuration now (#49954)
- fix detection of sheet direction (for rtl support)

since 1.3 beta2
===============
- KSpread crash when changing paper orientation (#60279)


since 1.3 beta1
===============
- adjust print zoom to limit printout to m x n pages
- new functions: GETPIVOTDATA, BESSELI, BESSELJ, BESSELK, BESSELY,
  ERF, ERFC, CONVERT
- new templates: Balance Sheet, Price Quotation, Packing Slip


since 1.2 relase ( 'til 1.3 beta 1 :-)
======================================

- 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 efficent 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 templates: Body-Mass Index Calculator, Calendar 2003, Student ID Card,
  Invoice, Expense Report


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


=====================================================
After 1.2 above
=====================================================


Changes from 1.1 to 1.2
=======================

Since RC1:
----------
Bugfixes:
- Fix display and printout with special files (offset by 1 pixel).
- Fix printout of thick cell borders on page borders
- Fix printout of children, when they overlap one page
- Fix #45967, #31130
- Fix #45944 (Normal): Paste special->text overwrite borders
- Fix #42456 (Normal): merged cells with centered text do not survive insert/delete rows
- Fix #45943 (Crash): crash after "money format"
- Fix function documentation (YEAR(), FACTDOUBLE() )
- Fix parsing and error checking for spreadsheet names.
- Fix #46045 (Normal): serious errors in forumulas
- Fix Embedded chart changes titles when opening again
- Fix #44628 (Grave): 1.1 document not read with 1.2 - circular references
- Fix #40150 (Normal): Precision problem in calculations
- Fix #29524:  KSpread Formula editors tooltip should be changed
- Fix #18083: KSpread rounding error
- Fix #46530: crash on selecting validity
- Fix #45395: Save as HTML is called "mime type"
- Fix #34088: Precision of currency is too low or overflow is handled in a strange way
- Fix #45324: consolidate function result reference area selecting unintuitive

Until RC1:
----------
New:
- Like all of KOffice: a readonly GUI for embedding into Konqueror
- More DCOP calls

Bugfixes:
- bug fixes
- Fix cancel add embedded document.
- Fix mem leak
- Fix copy/paste attribute.
- Fix offset of rotated text in one case (top/middle)

Until beta2:
------------

- bug fixes
- perfomance enhancements
- print functions:
    - added option for print grid, comment indicator and formula indicator
    - added print range definiton
    - added repeat columns & rows on printout
    - added "<pages>" macro in header/footer
- paper layout now a property of sheet (not the whole workbook)
- header/footer now a property of sheet (not the whole workbook)
- Settings in paper layout are now undoable
- Sort enhanced for
    - sorting by up to three rows or columns
    - possibility of putting the result of sorting some place else
    - you can use a custom lists (like days of week) as a primary key
    - option if you want to copy the layout or not
    - you can define a row header which gets copied but not sorted
- auto continuation support for every direction and all types supported in
  KSpread and for more complex series like 1,3,4,6,...
- just one "copy" instead of "copy" and "copy as text"
- insertion of series supports now doubles and decreasing series
- support for inserting data from SQL databases
- implemented "Goal Seek"
- implemented new shortcuts for cell formating
- implemented "Insert from text file" and "Insert formated clipboard data"
- Added "Text to Column"
- improved Data Consolidate, with more choices: Sum, Average, Count,
  Min, Max, Product, Standard Deviation, Variance.
- fixed some functions to be Excel-compatibel (FIND, REPLACE,LEFT,
  RIGHT,MID,REPT)
- now it's "Sheet" everywhere, not more "Table"
- added formula indicator (small blue rectangle on the corner,
  when the cell holds a formula). idea from Quattro Pro
- added Greek to EURO() function
- new function category: Engineering
- added support with templates
- added support for changing row/col and table of named areas
- Multiple views work for spreadsheets (can change tables, select different
  parts of the sheet independantly in each open view or embedded object)
- DCOP interface for a table has changed.  Many of the operations have been
  moved to the 'view' class.  Current DCOP scripts will need to be updated
- Zoom

new functions added:
 ISBLANK, CHAR, CODE, VALUE, DOLLAR, CONCATENATE, FIXED, T, TEXT, SUBSTITUTE,
 SEARCH, INFO, FILENAME, TYPE, COUNTBLANK, N, AVEDEV, ARABIC, AVERAGEA, ROT,
 FIB, BASE, FACTDOUBLE, SQRTPI, QUOTIENT, MULTINOMIAL, COUNTIF

Until beta1:
------------

- bug fixes
- performance enhancements
- support up to 2^15 columns and rows, formerly it was 676 columns and 10000
  rows

- add support for spell-check
- many new built-in functions (see detailed list below)
- function name is now case-insensitive
- "Related Function" in formula editor
- move functions in kspread_interpreter into several kspread_functions_*.cpp

New functions added:
 conversion:
   INT2BOOL, CharToAscii, AsciiToChar, BOOL2STRING, NUM2STRING,
   BOOL2INT
 math:
   DIV, LCD, PRODUCT, LCM, TOGGLE, TRIM, ABS
 text:
   COMPARE, CLEAN, SLEEK, PROPER, REPLACE
 date/time:
   DAYS, WEEKS, MONTHS, YEARS
 financial:
   DB, SLN, SYD, EURO
 logical:
   XOR
 statistical:
   CHIDIST, FDIST, TDIST, CONFIDENCE, BETADIST, GAMMADIST,
   PHI, GAUSS, MEDIAN, POISSON, GAMMALN, NORMINV, NORMSINV,
   WEIBULL, EXPONDIST, NORMDIST, NORMSDIST, FISHER,
   FISHERINV, LOGNORMDIST