diff options
Diffstat (limited to 'kspread/CHANGES')
-rw-r--r-- | kspread/CHANGES | 410 |
1 files changed, 410 insertions, 0 deletions
diff --git a/kspread/CHANGES b/kspread/CHANGES new file mode 100644 index 000000000..9b9b654ef --- /dev/null +++ b/kspread/CHANGES @@ -0,0 +1,410 @@ +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_*.cc + +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 + |