MindFusion.Spreadsheet for Java Swing のリリース
Released: Apr 4, 2023
V1.1 での更新項目
機能
- Formula hints:
- Target cells or cell ranges in a formula expression are now color-coded to show the matching area in grid view.
- The control now shows a hint box when user enters a function name in a formula.
- Formula bar improvements:
- Users now can enter a new line in formula bar by pressing Ctrl + Enter.
- The Tab key now tabs out of the formula bar instead of tabulating the text.
- Changes entered through formula bar are now undoable.
- Formula bar no longer displays trailing zeros when selecting...
Released: Jul 23, 2022
V1.0.11 での更新項目
機能
- Added cellChangedPreCalc and cellChangedPostCalc events.
不具合の修正
- Fix for diagonal borders showing in exported Excel files when border width is set to 0.
- MROUND and ROUND function fixes.
- Fix for skipping manual page breaks (set via PageBreak property).
Released: Oct 7, 2021
V1.0.10 での更新項目
機能
- Frozen row and column properties have been moved from Worksheet class to the view class and now allow freezing from a non-zero scroll position.
- You can now format numbers in thousands or millions by adding a comma for each 1000 scale.
- Custom format strings can now contain color names in square brackets, compatible with Microsoft Excel color specifiers.
- Extended the set of expression types in which blank cells are promoted to zeros or empty strings when referenced from formulas.
不具合の修正
Released: May 5, 2021
V1.0.9 での更新項目
機能
- Added ValidateOnPaste property which specifies if Validation rules should be applied to pasted values.
- FindReplaceForm can now search for formatted text values.
- You can now skip individual cell changes from validation events by setting SkipCell.
- Context property of validation event now specifies the cause of the change.
不具合の修正
- Fixed resizeRowsToFit results when the spreadsheet view is zoomed.
- Fixed issue with excelStyleMergedBorders.
- Fixed issue with SUMIF and AVERAGEIF function.
- Fixed merged...
Released: Nov 21, 2020
V1.0.8 での更新項目
機能
- Added the ability to limit a spreadsheet's scroll range by setting MaxRows and MaxColumns properties.
- The drawCell event now specifies the origin of the merged range as an argument, instead of the first visible cell from a merged range.
- When a cell's format is set to percentage, the cell's entry box automatically appends % suffix (as in Microsoft Excel).
不具合の修正
- Fixed formatting for Percent data type.
- Fixed glitches from optimized-scrolling buffer when Windows 10 display scaling is enabled.
Released: Oct 27, 2020
V1.0.7 での更新項目
不具合の修正
- Fixed drawing glitches when Microsoft Windows 10 display scaling is enabled.
- Fixes and improvements of clipboard operations.
Released: Sep 8, 2020
V1.0.6 での更新項目
機能
- Added drawCell event which lets you render custom graphics inside cells.
- Added ActiveBorderPen property which lets you customize the borders of the ActiveCell.
- Improved scrolling speed.
- Added TabBackground property which specifies a worksheet's tab background.
- Added ArrowActions property which lets you specify the action of arrow buttons in the tab strip.
- Added new resizeRowsToFit overloads which lets you set the default size of empty rows.
- Added queryDropDownList event which lets you provide...
Released: May 16, 2020
V1.0.5 での更新項目
機能
- Added dynamic layouts to standard dialogs.
- Pressing ESC in formula bar cancels editing.
- You can now override cell navigation by handling the cellActivating event.
- resizeRowsToFit now supports merged cells.
不具合の修正
- Fixed click-select of merged cell address when editing formulas.
- Fixed rendering of wrapped cell text.
Released: Feb 24, 2020
V1.0.3 での更新項目
機能
- Localization - Standard forms can now be localized using XML. Translations for German, Spanish, French, Korean, Portuguese, Russian, and Chinese are included.
- Miscellaneous
- Drag-select cells to enter a range while editing in formula bar.
- New worksheetCellParsing event lets you replace values entered by users or change their data type.
- Microsoft Excel importer fixes and optimization.
- Auto-fill no longer changes values of non-editable cells (due to property or validation events).
Released: Apr 23, 2019
V1.0.2 での更新項目
機能
- Added Editable property to Cells.
- Added the ability to rotate cell text.
- Double underlining of cell text.
- AllowResizeHeaders property.
- inplaceEditStarting event with formula bar.
- CSV importer fixes.
- JavaFX dependencies removed.