© Martin Manns 2012
Q: What kind of expressions can a cell contain?
A: A cell can contain any normal Python expression such as a
list comprehension or a generator expression. However, it cannot
contain statements such as
for i in xrange(10): pass
If you want to program more complex algorithms then use the macro
editor.
There, you can define functions that use arbitrary Python code and is
callable from any cell.
Example:
Type in the macro editor:
def factorize(number):
"""Silly factorizing algorithm for demonstration purposes only"""
counter = 1
result = []
while counter <= number:
if number % counter == 0:
result.append(counter)
counter += 1
return result
And in the cell:
factorize(25)
Result is:
[1 5 25]
Q: What are the boundaries for the number of
rows/columns/sheets?
A: These are limited by your memory (and maybe your stack
restriction
if any). However, the grid is restricted to a number that changes with
row size.
For standard size (GTK), 80 000 000 rows can be displayed.
Q: Is the new file-format considered stable, or will it
change again?
A: The new file format is stable. This means that future
versions of Pyspread will be able to read the old format.
Q: Can pyspread still read the old format?
A: Unfortunately not. If you have old pys files, install both
versions of pyspread and copy the cell contents via the Clipboard from
the old to the new version. However, cell formatting cannot be
preserved this way.