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 "" 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