[ANN] pyspread 0.2.6


Martin Manns

pyspread 0.2.6

Pyspread 0.2.6 is released.

This update brings Excel xls file reading and prevents many
pyspread lock ups that were caused by misbehaving user code.

About pyspread

Pyspread is a non-traditional spreadsheet application that is based on
and written in the programming language Python.

The goal of pyspread is to be the most pythonic spreadsheet application.

Pyspread is free software. It is released under the GPL v3.

Project website: http://manns.github.com/pyspread/
Download page: https://pypi.python.org/pypi/pyspread

What is new in 0.2.6

+ Reading support for Excel xls files (requires dependency xlrd)
+ Code execution timeout, i. e. buggy code such as infinite loops does
not lock up pyspread any more.
Note: The timeout does not work for C operations such as
a ** <big number>
+ Macro dialog now provides an error message field
+ Multiple rows/columns can now be resized together when selected
+ Show frozen option added that changes background of frozen cells
+ The cell editor now is resized when the text grows too large
+ Cells are now always clipped
+ Example macro for in cell LaTeX equations added
+ Contour plots and Sankey charts added to chart dialog
+ Pie chart can now be rotated in the chart dialog
+ Chart fonts and ticks can now be changed in chart dialog
+ Some bug fixes

Known issues

+ Selection mode is disabled in Windows.
+ Sometimes, pressing redo when there is nothing left to redo has
undesired effects such as redoing an operation again.
+ Pyspread with wxPython 3.x instead of 2.8.x may be slow and buggy
+ On some (not all) Windows system lockup prevention does not work




Dec 8, 2014
Reaction score
This seems a nice project. However the version I installed from debian with apt-get is 0.2.3 and there seem to be quite a few improvements since then. I tried downloading versions 0.3.3 then 0.3.2 but after removing the apt-get version and running python setup.py install neither of these run. I get
Traceback (most recent call last):
File "./pyspread/pyspread", line 241, in <module>
File "./pyspread/pyspread", line 227, in pyspread
app = MainApplication(S=S, redirect=False)
File "./pyspread/pyspread", line 156, in __init__
wx.App.__init__(self, *args, **kwargs)
File "/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode/wx/_core.py", line 7981, in __init__
File "/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode/wx/_core.py", line 7555, in _BootstrapApp
return _core_.PyApp__BootstrapApp(*args, **kwargs)
File "./pyspread/pyspread", line 166, in OnInit
from src.gui._main_window import MainWindow
File "/home/jill/Downloads/pyspread-0.3.3/pyspread/src/../src/gui/_main_window.py", line 53, in <module>
from _grid import Grid
File "/home/jill/Downloads/pyspread-0.3.3/pyspread/src/../src/gui/_grid.py", line 48, in <module>
from src.model.model import CodeArray
File "/home/jill/Downloads/pyspread-0.3.3/pyspread/src/../src/model/model.py", line 81, in <module>
class CellAttributes(list):
File "/home/jill/Downloads/pyspread-0.3.3/pyspread/src/../src/model/model.py", line 99, in CellAttributes
"bordercolor_bottom": get_color(config["grid_color"]).GetRGB(),
File "/home/jill/Downloads/pyspread-0.3.3/pyspread/src/../src/sysvars.py", line 82, in get_color
return wx.SystemSettings.GetColour(name)
File "/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode/wx/_misc.py", line 159, in GetColour
return _misc_.SystemSettings_GetColour(*args, **kwargs)
TypeError: in method 'SystemSettings_GetColour', expected argument 1 of type 'wxSystemColour'​

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads