tabulous

What's Changed

• Fixes for Qt6 by @hanjinliu in https://github.com/hanjinliu/tabulous/pull/131
• Restrict the length of tooltip by @hanjinliu in https://github.com/hanjinliu/tabulous/pull/132
• Replace nan value to "" in spreadsheet by @hanjinliu in https://github.com/hanjinliu/tabulous/pull/133

Full Changelog: https://github.com/hanjinliu/tabulous/compare/v0.5.6...v0.5.7

Bug Fixes

• Do not save index if it is not edited.
• Do not copy the name of column header.
• Fix double-click event of matplotlib figures.
• Fix the preview matplotlib figure tick colors when the viewer theme is dark.
• Fix the opacity of highlight color.

New Features

• Tabs can be deleted by right drag.
• Implement table column proxy (#125).
• Use dynamic scrollbar for spreadsheet (#130).
• Use N in cells for the number of rows.

Bug Fixes

• Fix in-cell slots (#126).
• Fix sort button behavior (#127).
• Fix segfalut in test (#128).
• Fix plot UI.

Improvements

• Asynchronously import qtconsole, matplotlib and scipy to boost startup.
• Implement append method to Table and SpreadSheet.
• Show viewer after some function calls.
• Improve dark-theme syntax style of QtConsole.

Deprecations

• Methods and menus that add cell widgets are all deprecated since its behavior is not compatible with row/column insertion/deletion.

Bug Fixes

• Fix switch headers.
• Fix pasting from numpy-style text.
• Fix Japanese and Chinese preedit text.

Improvements

• Implement custom IPython auto completion (#121).
• Add custom ipython magics (#122).
• Add jump-to-cell widget and assign Ctrl+G to it (#123).
• Implement animation (#124).

Changes

• Add pyproject.toml and github workflow.

Bug Fixes

• Fix file explorer.
• Fix bugs in Qt6 (key sequences).
• Fix s runpy bug on startup.
• Fix close confirmation not being shown.
• Fix the traceback dialog when it encountered an exception with no argument.
• Fix the architecture of row/column spans.

Changes

• Use latest qt-command-palette (#116).
• Add distributions from scipy.stats (#117).

Bug fixes

• Consider HTML escape sequences in the traceback dialog (#118).
• Fix assign function (#119).
• Don't update cell values if escaped by Esc.
• Match color for each theme (#120).

New Features

• Zooming in/out is now compatible with non-uniform header spans (#112).
• Thread worker support (#115).
• Implement file tree widget.
• Implement regressor widget.
• Add __builtins__ to the namespace to make evaluation safer.

Bug Fixes

• Fix parsing in cell evaluation (#113).
• Removing columns with text color, background color etc. was not undoable (#114).

Highlights

Now dark mode and many other color themes are implemented.

New Features

• Fetch latest version if available (#107).
• Add dynamic stylesheet and preference dialog (#108).
• Add selection editor at the upper-right corner (#109).
• Update configuration (#110).
• Record table source path and parent table (#111).
• Make zooming and header span compatible (#112).

Highlights

Now dark mode and many other color themes are implemented.

New Features

• Fetch latest version if available (#107).
• Add dynamic stylesheet and preference dialog (#108).
• Add selection editor at the upper-right corner (#109).
• Update configuration (#110).
• Record table source path and parent table (#111).

Bug Fix

• Fix FileNotFoundError after the first installation.

Changes

• Always install tabulate.

New Features

• More commands related to pandas, such as pd.fillna (#101).
• Basic support of timedelta dtype (#102).
• Basic support of interval/period dtype (#104).
• Add post-initialization architecture (#105).

Bug Fixes

• Fix many bugs related to table-only use cases (#100).
• Fix table editing bugs related to foreign languages (#106).

Deprecations

• viewer.keymap.bind, viewer.tables.register_action, table.cell.register_action, table.index.register_action, viewer.columns.register_action are all deprecated and their API are unified to XXX.register method, according to #105.

New Features

• Slot with cell reference is fully supported (#71).
• Command palette is fully supported (#72).
• Refactor all the command, add command setting in the config.toml (#74).
• Unify filtering and sorting and add commands for this (#76).
• Implement fill_between etc. to plot menu (#80).
• Add "Edit" menu (#81).
• Support sort/filter header button in column header (#87).
• Add --init-confg and --init-history CLI options (#95).
• Implement more copy/paste methods, such as markdown and rst (#96).
• Methods to create linearly segmented colormaps from colors (#98).
• Show contextmenu on the current cell when the keyboard menu button is clicked.
• Support rich text in status bar.
• Experimental support of table subset creation by __getitem__, loc and iloc.
• Allow input from polars and xarray.

Bug Fixes

• SignalArray did not work with compiled psygnal.
• Fix pandas unreachable error by pinning pandas version (#75).
• Fix QLineEdit behavior on MacOS (#78).
• Fix table widget not working independently (#85).
• Fix painting during proxy is set (#90).
• Fix in-cell evalutation slot during proxy is set (#92).

Changes/Deprecations

• Change matplotlib figure background color.
• The table.filter API is deprecated. Use table.proxy from now on (#79, #89).
• Use str column (A, B, ..., Z, AA, ...) by default (#86).
• Auto generate readme and documentation figures (#94).
• Deprecate foreground_colormap and background_colormap and use new fields text_color and background_color (#98).
• Lots of changes in GUI design, especially the tool buttons.

New Features

• Cell reference is fully supported (#71).
• Command palette is fully supported (#72).
• Refactor all the command, add command setting in the config.toml (#74).
• Unify filtering and sorting and add commands for this (#76).
• Implement fill_between etc. to plot menu (#80).
• Add "Edit" menu (#81).
• Show contextmenu on the current cell when the keyboard menu button is clicked.

Bug Fixes

• SignalArray did not work with compiled psygnal.
• Fix pandas unreachable error by pinning pandas version (#75).
• Fix QLineEdit behavior on MacOS (#78).

Changes/Deprecations

• Change matplotlib figure background color.
• The table.filter API is deprecated. Use table.proxy from now on (#79).
• Lots of changes in GUI design, especially the tool buttons.

New Features

• New widgets for general data analysis.
  • Add scipy.optimize widget (#52).
  • Add random number generator (#65).
  • Add scipy.stats widget (#67).
  • Add sklearn widget (#68).
• Implement in-cell labels and map NamedTuple and dict to labeled items (#55, #57).
• Implement parametric signal array and use it for most of the functions (#63).
• Toggle full screen by F11.
• Implement label parameter for plt.scatter, plt.errorbar and plt.hist (#70).

Changes

• Use selection widgets in plot dialogs (#61).
• Run IPython startup file on launching app.

Bug Fixes

• Support drag-and-drop of files starts with IP address (#58).
• Fix wrong table shape after undoing.

tabulous now supports Excel-style cell reference!

New Features

• In-cell literal evaluation with/without cell references (#36, #38, #42, #43, #46, #47).
• Dynamic plotting with cell reference (#49).
• Overlay widget using table.add_overlay_widget.
• Use config file for most of the configurations (#40).

UI changes

• Shortcuts to click tool buttons are relabeled. Buttons 0, 1, 2 ... were assigned from left to right, but now 1, 2, ...., 0 are assigned.
• Add "switch header and row" button.
• Finder (Ctrl+F) is two-way (#41).

Bug Fixes

• Drag-and-drop now can open multiple files.
• Nan was not formatted correctly.

This release is focused on bug fixes.

Bug Fixes

• Most non-string dtypes caused format error in spreadsheet.
• Fix timedelta64 formatters.
• Fix right-click context menu after header is renamed.
• Fix many inconsistency in popup view caused by copying table view.

Others

• Add ico file.

New Features

• Make contextmenu API consistent using register_action.
• Add API and GUI to set custom foreground/background colormaps to each column.
• Add API and GUI to set custom text formatter to each column.
• Add API to set custom data validator to each column.
• Add API and GUI to set dtype to spreadsheet.
• Implement table highlight.
• Add a tool button to open seaborn sample datasets.
• Insert table data reference object into Qt console by Ctrl+I.

Improvements

• Support Qt6.
• Re-implement paintEvent to make table painting much more efficient.
• Re-implement selection models to make header selection consistent to cell selection.
• Use appdirs to save the user history file locally.
• Close popup view on table deletion.

Bug Fixes

• Completion bug in some line edit widgets.
• IndexError in traceback dialog.
• Error on plotting data with single selection.
• Fix incompatibility between GroupBy/TableDisplay and view modes.
• Avoid many bugs caused by duplicated header name.
• Fix some collapsed layout on MacOS.

New Features

• Show a startup menu when table stack is empty.
• Implement a custom selection model for better performance.
• Add stylesheet.
• Add keyboard shortcuts for table scrolling (Ctrl+Alt+arrows).
• Add window and application icon.
• Show notification when user tried to edit read-only tables.
• Add matplotlib editor.
• Add metadata attribute to all the tables.
• Show filter icon when a table is filtrated.
• Add table-specific operations to the contextmenu of the tabs.

Bug Fixes

• Fix many keyboard behaviors of spreadsheets.
• Fix completer of line edit of evaluation based widget.
• Fix some weird behaviors of tiled/popped-up tables.
• Fix errors that happened when zero-sized spreadsheet is edited.
• Make out-of-border edition of spreadsheet header values undoable.

New Features

• Default plot canvas and its API is available now!
• Add side area and its interface to all the table widget.
• Find/replace widget (Ctrl+F).
• Evaluate widget (in toolbar).
• Filter widget (in toolbar).
• Add preview widgets to many of the dialogs that return DataFrame or update plots.
• Format all the undoable operations in a semi-executable fashion.
• Add undo stack view.

Improvements

• Customize QSplitter's handles to make it easier to grab.
• Override event filters to make console shortcuts better.
• Reset selection on insertion or removal of rows or columns.
• Make dock widget title bars better.
• cell interface accept array and out-of-bound slicing.

Changes

• NaN is replaced to "" in spreadsheet instead of np.nan.
• Some keymaps are changed because they did not work in some keyboards.

Bug Fixes

• DataFrame was not copied correctly in some occasions.
• bind_key was not compatible with some functions.
• Table tiling and non-standard view mode had many problems in the GUI.
• Many focusing bugs were fixed.
• Do not synchronize zoom factor between tables created from the same data model.
• Ctrl+Shift+Arrow did not work as expected.
• Inserting/removing rows or columns in GUI was not undoable.
• Editing headers emitted wrong signals.