You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
411 lines
15 KiB
411 lines
15 KiB
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
|
|
|