Pyspread – The Spreadsheet with a Python connection
|
Saving Documents
When you reopen a previously saved Pyspread document, the application does not automatically interpret the formulas that the document contains. The reasoning behind this is a security mechanism that is designed to prevent the running of potentially malicious code – any Python snippet could in principle do harm to the system.
Pyspread cannot itself identify the side effects of the program code in the data sheet – particularly not for external modules. If you are sure that the Python snippets included do no harm, you can select File | Approve .
To automate this step in the future, Pyspread asks you for your GnuPG key [7], which it uses to sign Pyspread files. As a user, you can now use the GnuPG key to check whether the document is from a trusted source.
Listing 1 shows the thumbprint of my own GnuPG key [8]. Pyspread stores this fingerprint in its settings (Figure 3). The corresponding dialog is found in the menu below File | Preferences ; the entry for the fingerprint is the bottom input box.
Listing 1
Fingerprint
$ gpg --fingerprint D431AC07 pub 4096R/D431AC07 2014-09-05 Key fingerprint = 35F8 DF9C 884E 36AB 9744 60AF CFA7 2978 D431 AC07 uid Frank Hofmann (Hofmann EDV) <frank.hofmann@efho.de> sub 4096R/3B074F29 2014-09-05
Conclusions
The idea of elegantly combining a spreadsheet with an existing, mature programming language is smart. The same applies to the use of GnuPG signatures to boost confidence in the submitted documents. This is a combination that the major league players currently do not offer.
Pyspread has mature basic functions that make working with the program convenient. The major construction sites are the charts and documentation – there is ample scope for improvement here. But, there is good reason to keep an eye on Pyspread's development in the future.
Acknowledgements
I thank Martin Manns, the creator of Pyspread, for his help while writing this article.
Infos
- Pyspread: http://manns.github.io/pyspread/
- Ubuntu Pyspread package: http://packages.ubuntu.com/xenial/pyspread
- NumPy: http://www.numpy.org
- Matplotlib: http://matplotlib.org
- Working with Excel Files in Python: http://www.python-excel.org
- wxPython library: http://www.wxpython.org
- GnuPG: https://gnupg.org
- "Encrypting Email with GnuPG" by Peter Kreussel, Ubuntu User , Issue 19, 2013: http://www.ubuntu-user.com/Magazine/Archive/2013/19/Encrypting-email-with-GnuPG/%28language%29/eng-GB
« Previous 1 2 3 Next »
Buy this article as PDF
Pages: 4
(incl. VAT)