KOffice – TDE office suite
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
15KB

  1. Changes for KSpread 1.5 Beta 1
  2. ==============================
  3. Features
  4. --------
  5. Non-contiguous selection
  6. Rewritten dependency handling
  7. Embedded picture/image inside workbook
  8. Improved and faster formula calculation
  9. Manual line break (wish #9881)
  10. Syntax highlight and function autocomplete for formula editing
  11. Custom sheet selection and ordering in print dialog
  12. Enhancements
  13. ------------
  14. QWhatsThis help is available to various dialogs
  15. Updated dialog screenshot in the handbook
  16. Default autofill increment is set to 1 if only one cell is selected
  17. Sum button automatically selects a suitable cell range
  18. Percent operator in formula (wish #101217)
  19. Improved zoomed printouts (bug #115879)
  20. Use standard KDE font dialog in cell format dialog (bug #116991)
  21. Faster redraw of merged cells (bug #118248)
  22. Bug Fixes
  23. ---------
  24. #120234: Freeze on circular reference
  25. #120232: Strange behaviour on creating new file
  26. #120204: Cell comment isn't wrapped
  27. #119675: Background brush color is not correctly loaded
  28. #119097: Right arrow for entry and validation
  29. #118769: Better wording cursor movement setting
  30. #117435: Incorrect result from COUNTIF function
  31. #117252: Fix date (and time) increment for autofill
  32. #116903: Indentation setting is not correctly handled in preferences
  33. #116901: Unclear unit setting in preferences
  34. #116702: Fix freeze with certain spreadsheet content
  35. #116546: Endless dependency calculation
  36. #116444: Fix cell protection
  37. #116236: Crash on OpenDocument with external file cell references
  38. #116144: Incorrect return value of ISBLANK function
  39. #115948: Formatting problem in automerged cells
  40. #115362: Crash when spellchecking
  41. #114693: Comment indicator in sheet properties dialog
  42. #114961: Enter does not move cursor
  43. #114635: Endless loop while loading
  44. #109633: OASIS format wrongly changes vertical align to Bottom
  45. #50192: Always allow date input in ISO 8601 format
  46. ??#483630: Prevent hiding all rows/columns
  47. Developer-Visible Only
  48. ----------------------
  49. Manipulators used in commands
  50. KSpread::Cell is associated with KSpread::Format, no longer inherits it
  51. Setter and getter methods for KSpread::Point
  52. since 1.4.1
  53. ===========
  54. - Fix slow scrolling left/right (#110551, #101234)
  55. since 1.4.0
  56. ===========
  57. - Fix potential crash when rendering obscured cells (#108659)
  58. - Don't automatically make cells left aligned when increasing indent.
  59. since 1.4-beta1
  60. ===============
  61. - Use General/Blank Worksheet as default template.
  62. - KSpread crashes on exit if there is a chart in the sheet (#101915).
  63. - The data editor is disabled for charts which has been loaded.
  64. - Don't use 600 dpi as default resolution (the chart printing is much faster now).
  65. - The chart/object printing is simplified and works correctly now. Unfortunately
  66. this breaks the transform feature but the ordinary rectangle printing is more
  67. important.
  68. - Paint the child document after it has been inserted.
  69. since 1.3
  70. =========
  71. - fix bug #63332: Pasting into a cell that has spilled out, pastes
  72. into all overwritten cells
  73. - fix bug #101926: kspread never prints the grid
  74. - Implement save/load Oasis format
  75. - Allow to sort without respect case
  76. - allow editing/removing of links
  77. - fixed bug 76861: bad rendering of hyperlink
  78. - Validation: allow to display or not message
  79. - Add new dcop function
  80. - Start to port KSpread_undo to kcommand
  81. - Add combobox to search area name
  82. - Add Help Message as in oocalc
  83. - multiple steps undo and redo
  84. - fix problem where hidden sheet is simply appended in the tab bar
  85. (when it is shown again).
  86. - fix bug #81026: SUMIF() function added
  87. - sheet layout direction can be explicitly set (fix bug #46831)
  88. - new dependency manager
  89. - prevent a very wide Insert Link dialog
  90. - fix bug #59291: potential crash on loading new template
  91. changes for 1.3.4
  92. =================
  93. - fix bug #87369: ctrl+C in formula bar doesn't copy contents
  94. changes for 1.3.3
  95. =================
  96. - fix bug #78747: problem with duration format (hh:mm:ss)
  97. - fix bug #74091: wrong special paste from cell with formula
  98. - fix bug #76679: time shown with one second offset
  99. changes for 1.3.2
  100. =================
  101. - fix condition cell attribute (multi condition)
  102. - fix bug #69798: SEXDEC parse error
  103. - fix enable/disable action into validation dialogbox
  104. - fix disable/enable "show table" menu item
  105. - fix bug #69066: crash when viewing a KSpread document in Konqueror
  106. changes for 1.3.1
  107. =================
  108. - fix bug #77844: undo not working after deleting multiple cells
  109. - fix bug #45822: fixed crash when opening a file over the network
  110. since 1.3 RC1
  111. =============
  112. - fix display of text starting with a single quote
  113. - fix problem formatting the whole row (#65504)
  114. - make the top/middle/bottom alignment buttons work
  115. - fix problem with reference from another sheet (bug #60455)
  116. - show indicator of chosen/selected cells (bug #58098)
  117. - hide in-place cell editing when choosing other sheet
  118. - proper zoom and display of formatted hyperlink (#66214)
  119. - fix flickering problem with many hyperlinks (#65501)
  120. - don't crash when leaving the preview in Konq (#65928)
  121. - fix redraw problem with Print Preview (#60147)
  122. - support only one zoom for two or more views
  123. - fix painting problem with multiple views
  124. - prevent possible crash with conditional formatting (#58713)
  125. - fix dependency problem with automatic recalculation (#58097)
  126. - better adjustment of cell references on cut&paste
  127. - fix crash on csv import (#66047)
  128. - fix problem for cells copy/cut to clipboard (#58712)
  129. - show frame when embedded object is selected (#37152)
  130. - better handling of "nothing to print" warning (#60147)
  131. - when embedded, use real zoom instead of scaling (#45503)
  132. - fix data sorting (#63317)
  133. since 1.3 beta4
  134. ===============
  135. - #64794: kspread problem with calculating dates
  136. - #61570: cell border does not work with merged cells
  137. - fix unsorted zoom values (#64154)
  138. since 1.3 beta3
  139. ===============
  140. - KSpread is slow during text to column conversion (#59999)
  141. - fix problem cycling absolute cell reference with F4 key (#46959)
  142. - the calculator plugin saves its configuration now (#49954)
  143. - fix detection of sheet direction (for rtl support)
  144. since 1.3 beta2
  145. ===============
  146. - KSpread crash when changing paper orientation (#60279)
  147. since 1.3 beta1
  148. ===============
  149. - adjust print zoom to limit printout to m x n pages
  150. - new functions: GETPIVOTDATA, BESSELI, BESSELJ, BESSELK, BESSELY,
  151. ERF, ERFC, CONVERT
  152. - new templates: Balance Sheet, Price Quotation, Packing Slip
  153. since 1.2 relase ( 'til 1.3 beta 1 :-)
  154. ======================================
  155. - real more than one currency support
  156. - new date and time formats
  157. - enhanced the "Text to Columns", "Insert from file"
  158. and "Insert from clipboard" dialog to support "ignore double delimiters"
  159. - "Insert from file" now also adjusts the column width depending on imported
  160. cell content
  161. - enhanced the CSV import dlg
  162. - to support "ignore double delimiters"
  163. - to adjust cell width to imported cell content
  164. - you can specify the column and row range for import
  165. - enhanced the CSV export dialog so that you can choose
  166. - table to export
  167. - delimiters between tables
  168. - delimiter between cells
  169. - character for quotes
  170. - export selection only
  171. - Goal Seek message fixes + you can select the cells with the mouse now
  172. - enhanced Gnumeric import filter to support
  173. - background (color + patterns), borders (colors + style)
  174. - font formating, text alignment
  175. - format parsing (date, time, numbers,...), cell height, width
  176. - print range, page setup, hidden columns/row, comments
  177. - new OpenCalc export and import filter
  178. - Added subtotal dialog and formula
  179. - Paper layout can now be applied to all sheets
  180. - now you can define the default cell style
  181. - Autoscroll while selecting now also available for columns and row headers
  182. - When cell is too short, then the content is now available in the tooltip
  183. - Drag 'n' Drop of selections
  184. - Protection of sheets or of the document structure (with or without password)
  185. - Protection tab in layout dialog: you unprotect certain cells, hide their
  186. contents, hide the formulas, or select them for not being printed
  187. - FindNext, FindPrevious cell enhancement for find
  188. - Fill: Fill area from right to left, left to right, bottom to top, top to bottom
  189. - Full zoom support
  190. - Printing:
  191. + High resolution printing (600dpi)
  192. + Improved WYSIWYG
  193. + Zoom support on printout
  194. - New direction mode when pressing Enter: you can jump now to the first cell of the next row
  195. - hierachical style support
  196. - builtin styles
  197. - creation of custom styles
  198. - creation of custom styles using a cell as template
  199. - insert special characters
  200. - smaller, more efficent file format
  201. - many performance enhancements
  202. - more powerful conditional cell attributes (you can assign a whole style if condition matches)
  203. - conditions can be used for text and numbers now (was numbers only before)
  204. - new templates: Body-Mass Index Calculator, Calendar 2003, Student ID Card,
  205. Invoice, Expense Report
  206. New functions:
  207. Date/Time (16):
  208. - EDATE, EOMONTH, DAYS360, WEEKDAY, TIMEVALUE, DATEVALUE, YEAR,
  209. MONTH, DAY, HOUR, MINUTE, SECOND, DAYNAME, MONTHNAME, EASTERSUNDAY,
  210. ISOWEEKNUM
  211. Math (16):
  212. - SUBTOTAL, POWER, TRUNC, CEILING, PRODUCT (now Excel compatible),
  213. KPRODUCT, RANDEXP, RANDBINOM, RANDNEGBINOM, RANDBERNOULLI,
  214. RANDPOISSON, MROUND, COUNTA, MINA, MAXA, SUMA
  215. Statistical (24):
  216. - VARP, STDEV, VAR, STDEVP, GEOMEAN, HARMEAN,
  217. KURT, LOGINV, DEVSQ, STANDARDIZE, HYPGEOMDIST,
  218. NEGBINOMDIST, KURTP, CORREL, COVAR, SMALL, LARGE
  219. STDEVA, STDEVPA, VARA, VARPA, SKEW, SKEWP, MODE
  220. Financial (19):
  221. - PPMT, DDB, DURATION, PMT, NPER,
  222. ISPMT, IPMT, TBILLEQ, TBILLPRICE, TBILLYIELD,
  223. ACCRINT, ACCRINTM, COUPNUM, DOLLARDE, DOLLARFR,
  224. DISC, EFFECT, INTRATE, RECEIVED
  225. Database (12):
  226. - DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN,
  227. DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
  228. Reference & Lookup (8):
  229. - ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS,
  230. INDIRECT, ROW, ROWS
  231. Engineering (2):
  232. - DELTA, GESTEP
  233. Logical (2):
  234. - FALSE, TRUE
  235. Information (2):
  236. - ISNONTEXT, ISNUMBER
  237. Obsolete formulas
  238. - stddev (was stddevp in fact)
  239. - day (is dayname now)
  240. - month (is monthname now)
  241. Obsolete but still usable formulas (do not show up in dialog )
  242. - variance, pow, isnottext, isnum, effective
  243. =====================================================
  244. After 1.2 above
  245. =====================================================
  246. Changes from 1.1 to 1.2
  247. =======================
  248. Since RC1:
  249. ----------
  250. Bugfixes:
  251. - Fix display and printout with special files (offset by 1 pixel).
  252. - Fix printout of thick cell borders on page borders
  253. - Fix printout of children, when they overlap one page
  254. - Fix #45967, #31130
  255. - Fix #45944 (Normal): Paste special->text overwrite borders
  256. - Fix #42456 (Normal): merged cells with centered text do not survive insert/delete rows
  257. - Fix #45943 (Crash): crash after "money format"
  258. - Fix function documentation (YEAR(), FACTDOUBLE() )
  259. - Fix parsing and error checking for spreadsheet names.
  260. - Fix #46045 (Normal): serious errors in forumulas
  261. - Fix Embedded chart changes titles when opening again
  262. - Fix #44628 (Grave): 1.1 document not read with 1.2 - circular references
  263. - Fix #40150 (Normal): Precision problem in calculations
  264. - Fix #29524: KSpread Formula editors tooltip should be changed
  265. - Fix #18083: KSpread rounding error
  266. - Fix #46530: crash on selecting validity
  267. - Fix #45395: Save as HTML is called "mime type"
  268. - Fix #34088: Precision of currency is too low or overflow is handled in a strange way
  269. - Fix #45324: consolidate function result reference area selecting unintuitive
  270. Until RC1:
  271. ----------
  272. New:
  273. - Like all of KOffice: a readonly GUI for embedding into Konqueror
  274. - More DCOP calls
  275. Bugfixes:
  276. - bug fixes
  277. - Fix cancel add embedded document.
  278. - Fix mem leak
  279. - Fix copy/paste attribute.
  280. - Fix offset of rotated text in one case (top/middle)
  281. Until beta2:
  282. ------------
  283. - bug fixes
  284. - perfomance enhancements
  285. - print functions:
  286. - added option for print grid, comment indicator and formula indicator
  287. - added print range definiton
  288. - added repeat columns & rows on printout
  289. - added "<pages>" macro in header/footer
  290. - paper layout now a property of sheet (not the whole workbook)
  291. - header/footer now a property of sheet (not the whole workbook)
  292. - Settings in paper layout are now undoable
  293. - Sort enhanced for
  294. - sorting by up to three rows or columns
  295. - possibility of putting the result of sorting some place else
  296. - you can use a custom lists (like days of week) as a primary key
  297. - option if you want to copy the layout or not
  298. - you can define a row header which gets copied but not sorted
  299. - auto continuation support for every direction and all types supported in
  300. KSpread and for more complex series like 1,3,4,6,...
  301. - just one "copy" instead of "copy" and "copy as text"
  302. - insertion of series supports now doubles and decreasing series
  303. - support for inserting data from SQL databases
  304. - implemented "Goal Seek"
  305. - implemented new shortcuts for cell formating
  306. - implemented "Insert from text file" and "Insert formated clipboard data"
  307. - Added "Text to Column"
  308. - improved Data Consolidate, with more choices: Sum, Average, Count,
  309. Min, Max, Product, Standard Deviation, Variance.
  310. - fixed some functions to be Excel-compatibel (FIND, REPLACE,LEFT,
  311. RIGHT,MID,REPT)
  312. - now it's "Sheet" everywhere, not more "Table"
  313. - added formula indicator (small blue rectangle on the corner,
  314. when the cell holds a formula). idea from Quattro Pro
  315. - added Greek to EURO() function
  316. - new function category: Engineering
  317. - added support with templates
  318. - added support for changing row/col and table of named areas
  319. - Multiple views work for spreadsheets (can change tables, select different
  320. parts of the sheet independantly in each open view or embedded object)
  321. - DCOP interface for a table has changed. Many of the operations have been
  322. moved to the 'view' class. Current DCOP scripts will need to be updated
  323. - Zoom
  324. new functions added:
  325. ISBLANK, CHAR, CODE, VALUE, DOLLAR, CONCATENATE, FIXED, T, TEXT, SUBSTITUTE,
  326. SEARCH, INFO, FILENAME, TYPE, COUNTBLANK, N, AVEDEV, ARABIC, AVERAGEA, ROT,
  327. FIB, BASE, FACTDOUBLE, SQRTPI, QUOTIENT, MULTINOMIAL, COUNTIF
  328. Until beta1:
  329. ------------
  330. - bug fixes
  331. - performance enhancements
  332. - support up to 2^15 columns and rows, formerly it was 676 columns and 10000
  333. rows
  334. - add support for spell-check
  335. - many new built-in functions (see detailed list below)
  336. - function name is now case-insensitive
  337. - "Related Function" in formula editor
  338. - move functions in kspread_interpreter into several kspread_functions_*.cc
  339. New functions added:
  340. conversion:
  341. INT2BOOL, CharToAscii, AsciiToChar, BOOL2STRING, NUM2STRING,
  342. BOOL2INT
  343. math:
  344. DIV, LCD, PRODUCT, LCM, TOGGLE, TRIM, ABS
  345. text:
  346. COMPARE, CLEAN, SLEEK, PROPER, REPLACE
  347. date/time:
  348. DAYS, WEEKS, MONTHS, YEARS
  349. financial:
  350. DB, SLN, SYD, EURO
  351. logical:
  352. XOR
  353. statistical:
  354. CHIDIST, FDIST, TDIST, CONFIDENCE, BETADIST, GAMMADIST,
  355. PHI, GAUSS, MEDIAN, POISSON, GAMMALN, NORMINV, NORMSINV,
  356. WEIBULL, EXPONDIST, NORMDIST, NORMSDIST, FISHER,
  357. FISHERINV, LOGNORMDIST