What's new in pyspread 2.2.1 Source Code
Apr 30, 2023
- This is a bugfix release
- Note that missing libvoikko, nuspell and hspell may lead to warning messages if pyenchant is installed. However, pyspread is still functional as this affects only spellchecking.
- Dependencies:
- Mandatory: Python (= 3.6), numpy (>=1.1), PyQt5 (= 5.10, requires PyQt5.Svg), setuptools (>=40.0), markdown2 (>= 2.3)
- Recommended: matplotlib (>=1.1.1), pyenchant (>=1.1), pip (>=18), python-dateutil (>= 2.7.0), py-moneyed (>=2.0), rpy2 (>=3.4), plotnine (>=0.8), libvoikko (>=4.0), libvoikko (>=4.3), nuspell (>=5.1), hspell (>= 1.4), ggplot2 (>=3.4)
- For building the apidocs with Sphinx see apidocs/requirements.txt
- Bug fixes:
- Chart dialog now correctly starts if rpy2 is not installed and if optional R modules are missing.
- Deleting large selections is now significantly faster.
- Pasting into large selections is now significantly faster.
- QPen cache now is limited in size.
New in pyspread 2.0.2 (Jan 4, 2022)
- Bug fixes:
- Various type issues with Python 3.10 fixed
New in pyspread 1.1.1 (Jun 12, 2018)
- Windows: GUI translations are now correctly found
- Windows: Code is now executed when clicking on locked or on button cells
- COPYING file moved to top folder
- Pyspread color scheme now adapts better to most dark themes
- Missing or non-existent GPG key is no longer crashing the GUI
- Shift-scroll now scrolls the grid sideways
- Undo and redo functionality made robust (now based on David Townshend's functional undo framework)
- Table choice panel is now shown and hidden with F3
- Macro dialog changed to AUI panel (shown and hidden with F4)
- The entry line is now correctly updated
- The last savepoint is now identified using the undo framework
- Undo and redo buttons are now disabled if no undo / redo is available
- Current grid label highlights changed for better visibility on high resolution displays
- Mouse wheel scrolling speed increased
- xlrd is not anymore a hard requirement (bugfix)
- The grid is now prevented from scrolling on focusing a cell editor
- Merged cells are now correctly drawn if the top left cell is invisible
- Copy and paste format now ignores merged cell information
- If a merged area is shifted outside the grid via insert rows etc. this is now correctly handled
- Chart dialog switched to AUI panel for better resizeability of sub panels
- GPG key choice now only allows choosing private keys without passwords
New in pyspread 0.2.7 (Feb 10, 2014)
- This is a bug fix release for the chart dialog on Windows systems.
New in pyspread 0.2.5 (Sep 26, 2013)
- String representation of S removed to prevent lockups in large grids
- Brazilian Portuguese localization added
- CSV file import now allows different file encodings
- Improved chart dialog
- Unit tests now succeed in Windows
- Various bug fixes
New in pyspread 0.2.4 (Jul 22, 2013)
- Windows compatibility
- More charts and chart options
- Localization in Norwegian Nynorsk and Bokmaal
- More than 64k characters supported in one cell
- High quality embedded images
- Paste iterable data into multiple cells via Paste As.
New in pyspread 0.1.2 Beta (Nov 8, 2010)
- New features:
- Added function to make a cell visible
- Third cell justification "center" added
- Ctrl-F now points to find toolbar instead of find dialog
- Frozen state is now saved
- Entering text in a cell now deletes old text
- Added function F5 (in menu View) for refreshing selected cells
- Save option "pys file with/without gpg signature" added
- Bug fixes:
- Grid flicker reduced
- Printing works again
- Changing the table now empties the entry line and does not mess up data any more (BUG 3030172)
- 1D printing bug fixed (BUG 2790444)
- Loading a file from command line no longer deletes cell 0,0,0 (BUG 3030880)
- Undoing paste operations now works (BUG 3019334)
- Bitmap toggle buttons now work in Windows as well
- Marks undo and redo operation do not accumulate any more
- Undoing text font and textattribute changes works now
- CSV import dialog apply button removed
- Cell limit (2**26) for 32 bit systems removed
- Prints of off-screen areas now correctly center on page
- Help now works when not in the home directory
- Double underscores in Tutorial corrected
- Pyspread gpg key name changed to pyspread_
- Deleting rows and columns can be undone again
- When reversing search, all values are now found
- Saved pys files now have .pys suffix added automatically
- Fixed font size reset bug when setting font attributes
- Loading a file from command line now checks signature correctly
- Fixed moving cells bug for edits in non top-left grid position in wx.GTK
New in pyspread 0.1 Alpha (Mar 22, 2010)
- New features:
- New macro editor dialog.
- Macros can now contain any Python code.
- Macros load and save files are now plain text files.
- Macros are now saved within the pys-file.
- Macros files are now signed and included in the trusted file concept.
- Bug fixes:
- Cells can now be correctly accessed with negative index (BUG 2965144)
New in pyspread 0.0.14b (Mar 22, 2010)
- Cell border can be changed independently.
- Cell access allows negative indices when not slicing.
New in pyspread 0.0.14a (Mar 22, 2010)
- Release 0.0.14a fixes font problems (BUG 2942779).
New in pyspread 0.0.14 (Mar 22, 2010)
- New features:
- Sparse grid introduced. It supports up to 80 000 000 rows
- Safe mode for inspecting foreign files
- GPG signatures for own files
- Help framework
- New About dialog
- Insertion of cell access code via Ctrl + Insert
- Simplified Macro editor dialog
- Improved cycle detection algorithm for grid
- Bug fixes:
- Globals now update immediately
- Colour works now when loading pys files
- wxPython v 2.8 is now preferred
- Error handling bug removed
- Help files are now found after changing the path
- Font rendering in Windows fixed
New in pyspread 0.0.13 (Mar 22, 2010)
- New features:
- Print framework that supports colors and drawn elements
- Splash screen removed
- Some drawing speed-ups
- Bug fixes:
- Small white rectangle in upper left corner removed (BUG 2918360)
- setup.py does not copy directories fixed (BUG 2913911)
- Folder renaming to fix installation errors (BUG 2909017)
New in pyspread 0.0.12 (Mar 22, 2010)
- New features:
- ODF file support
- Detachable tool bars
- Cells now support attributes such as fonts, borders, colors
- Cells can now be painted on from inside a macro function
- Major speed-up and memory reduction
- Dependency to networkx removed
- Frozen cells that are not updated introduced
- Style toolbar added
- Find toolbar added
- Regular expression search added
- Zoom functionality added
- Default text color changed to system default (for black themes)
- Ok and Cancel buttons swapped in New sheet dialog
- Bug fixes:
- Strange arange reference behaviour fixed (BUG 2760121)
- stt = sum(S[16:18,Y,0]) raises TypeError fixed (BUG 2579698)
- On Windows, some dialogs have to be closed twice. (fixed)
- Recursion detection dows not work on nested structures, i.e. when S[2,2,2] is referred to from inside a container object, pyspread will not realize a cycle. Therefore, a "Maximum recursion depth" error is reported (fixed)
New in pyspread 0.0.11 (Mar 22, 2010)
- New features:
- Recursion detection for slicing operations added
- Dependency to networkx added
- Command line options added
- Command line help added
- Unicode support added
- Save As and Save functionality separated
- Bug fixes:
- Internal variables stop showing up in macro dialog (BUG 2407828)
- Copy result now works on Windows (BUG 2569877)
- Replace now updates cells properly (BUG 2569880)
- Resize function works now (BUG 2569895)
New in pyspread 0.0.10a (Mar 22, 2010)
- Debian deb package added
- Tooltips added that display the cell code
- Icon and library path de-coupled
- Bug in setup.py fixed
New in pyspread 0.0.10 (Mar 22, 2010)
- Code completely re-structured
- Unit tests for main grid functionality
- Speed-up by caching of cell results
- Change of spread method syntax
- Various bug fixes