Or maybe several dialogues
@xdhmoore Since slicing the grid e.g. via S[1:10, :5, 0] yields a numpy array, you can save this programmatically as a csv file using the macro editor or cell code. However you should make sure that it is not written on each cell update, which can be achieved by freezing the cell that calls the respective macro function.
What we need anyway is that when someone is using pyspread they can be alerted to a new version.. U blew that out with no externals// !!!
Kudos and thanks to you guys for writing this and making it available. I'm just at the beginning of the learning curve and my python isn't very strong, but I was looking for a "programmable" lighter weight spreadsheet to kludge a project tracking "database" together with "macros" and stumbled on this. I don't yet know if it is a reasonable fit for what I have in mind, but I do know it is exceptionally solid, powerful, well designed, responsive, and documented (polished) for an open source project I hadn't heard of before! Question: I need to store a lot of TEXT in various columns and rows; is there any easier way than using commas everywhere to have the spreadsheet recognize text as text? That is, I was expecting to see some sort of formatting option that would, by default, get the engine of pysheet to EXPECT text (no code) in certain cells instead of being freaked out by it. I haven't found any such feature.
I guess, for internal consistency, it would be fine to have a macro which automatically quoted certain inputs, but I don't see that, either. If it doesn't exist, maybe you could consider it for a future feature? The space between database applications and spreadsheets is sparse, as you doubtless know. Access seems to have been pretty much abandoned and ... well, I haven't tried Filemaker, but I am on Linux...but the Linux community has only a few things in that area and none that I have found (e.g., Kexi) are ready for prime time. That probably wasn't what you had in mind for pyspread, but it IS highly programmable and python IS pretty strong with strings, etc. So, well ... that's what I am going to try to stretch pyspread to do a little of.
@blkstph_gitlab Thank you for getting in touch. As I understand your question, the two documented ways, i.e. selecting all cells with text content and pressing <Ctrl>+<Enter> (identical to selecting Edit -> Quote cells) and importing strings from csv files, do not work for you because you would like to import text into cells programmatically from code in the macro editor. This can be done by using Pythons's builtin repr function.
S[3,1,0]=repr("MyString") inserts code into the cell 3,1,0, which results in the string MyString being displayed.
Thank you, @manns_gitlab ! Let me explain further in case you have any other suggestions or see any obvious impossibilities (or have any thoughts in between, since this will be unknown for me): Sort of like on trello, I want to have four sheets for projects: new; active; pending; completed with one line per project. Projects get moved from one sheet to another by cutting and pasting. Eventually they get moved to "done" if they are completed -- or abandoned. I have used this sort of "kludge" for years to manage my personal big-picture tasks: It allows me to keep the list of "active" tasks to things I am committed to be working on in the next day or three, so I don't overwhelm myself or deceive myself, yet keeps looking at the other categories just a tab away. I have done this on a "dumb" spreadsheet and manually cut and paste but want to automate the process so I can hand the task off to someone else and reduce the risk that manually cutting and pasting is going to gum something up - I would prefer to have a button which moves the currently highlighted task and otherwise protects the sheets from some keyboard accident. I had hoped to do this with Kexi, but it is just not stable nor well documented (I has deleted my database twice); I tried Symphytum, but it is way underpowered. I could do this in excel, except (a) I am moving to linux and (b) it seems cool to have a python-based spreadsheet with enough power to create a stand-along app;-). I don't want to do this on the web, do to security issues, otherwise trello would probably do this. Any thoughts?
As an add-on thought, might it be worthwhile to support cells being EITHER capable of containing python expressions OR being designated "pure data"? I could see that being very, very useful (certainly for me) and generally useful provided (a) there was some way to easily, visually distinguish whether cells could only hold code or could only hold data (b) if data-only cells could be manipulated by code in other cells. Sort of like an eval function on what is otherwise a string. Not trying to unnecessarily complicate your program, but it would seem an elegant and massively powerful new capability if that can't yet be easily done. The segregation, though, would seem to me to be relatively easily added to pyspread (seem to me as I have the benefit of ignorance, perhaps;-)
What you are doing reminds me of what Alan Kay during a speech he was giving at a https://en.wikipedia.org/wiki/West_Coast_Computer_Faire. He specifically pointed out that spreadsheets were an example of a very powerful object and it should be possible to make them way more powerful than simple "macros" supported. I think he was thinking of Smalltalk powered, of course, but the impact of what he was proposing hit me right between the eyes, like a bullet. Alan Kay, more recently, has opined on how disappointed he is that things that were envisioned as just around the corner in the 1970's, or even had completely working prototypes, have STILL not been manifested. While all sorts of junk and bloat has filled all the extra storage, working memory, processing power, and human attention.
Be aware that pyspread currently has no database backend but runs in memory. While you can integrate a database it would mean work. If concurrent usage was not needed, I would just store the spreadsheet file in a git folder and write a script to auto-commit on each change. However, this requires merging if multiple users are involved in a concurrent way.
In pyspread, one of the basic concepts is that there is no distinction between code and data. I do not understand your issue with that.
@RudolfVonKrugstein The description indeed is missing in the docs. I have opened an issue. Button cells depict a button instead of the cell result. When the button is activated (on release), the cell code is executed. Therefore, you may call any function by pressing the button. Note that button cells work even if the cell is locked.
@manns_gitlab Ok, thanks for your answer! I was able to set the color of a cell by doing
So do I have to set the value of a cell in some other way?
Is there a way to get debug output from pyspread?
S.cell_attributes[X,Y,Z]["bgcolor"] = color from a button. But if I simple do S[X,Y,Z]=12 nothing happens.So do I have to set the value of a cell in some other way?
Is there a way to get debug output from pyspread?
@RudolfVonKrugstein This type of assignment does not work in the last(!) line of a cell. Furthermore, cell assignment should not be used from within a cell as it may introduce too much complexity. Please use one of the following approaches:
- Set a global variable that the target cell refers to, i.e. in the cell
a=1and in the target cella; - Define the function in the macro editor, i.e.
def set_cell(): S[1,2,0] = "234"and in the button cellset_cell()
@akhil-619 Thank you for your positive feedback. Creating a Python spreadsheet and pushing it to this goal has been tried before by Resolver One (see https://en.wikipedia.org/wiki/Resolver_One) - without market success. Therefore, pyspread does not aim at mimicking Excel. Nevertheless, I think it may be worth a look - already being able to use a dedicated money library instead of float numbers for money cells should save more trouble than getting accustomed to another UI.
@Legogris I have not published an implementation of row/column dragging because of two reasons: Switching long rows or columns takes too long for good usability and I found it too easy to mess up the spreadsheet with the feature. At the moment, please (1) insert a column where the column should be moved to, (2) cut the column that shall be moved, (3) paste it into the new column and (4) remove the now empty old column.
I got a database which contains values and I want to import them in a web spreadsheet like program...
Current setting allow up to 1,000,000 rows and 100,000 columns. This is changeable in settings.py using the maxshape parameter. However, note that large grids slow down pyspread considerably. Therefore, I think that such large grid sizes only make sense for sparse data. For large, non-sparse data sets, I suggest a data structure or data base that is accessed via a macro.
Hi! Any tips on how to debug/solve the issue when a graph won't stretch to fill out the whole area "freed up"/"made available" when merging cells? It's like it's somewhat collapsed and ignores part of the area available on the right.
(Maybe a comparison is that it doesn't make use of the full aspect ratio? As if it can only use so-and-so wide, and no more?)
What's strange is that in the preview mode (where you enter code on the left, and can click apply/see result on the right), I can stretch/maximize this view to the same size (on the same screen/dpi) as the "merged cell's area" without problem...
2 replies
After some further experimentation, I feel it's safe to conclude that the aspect ratio (directly or indirectly) plays a part in this. But no matter the aspect ratio of the merged cell, there's always something of the borders "cut off" of the final matplotlib produced figure =/
@x10an14:matrix.org The difference between the dialog and the grid is that matplotlib renders directly to a Qt widget in the dialog. However in the grid, it currently renders to an SVG, which is rendered inside the cell. As it seems, matplotlib generated SVG boundaries have issues that lead to the described behavior. Please file an issue at https://gitlab.com/pyspread/pyspread/-/issues
1 reply
The tests run headless mode..so maybe thats a place to start looking.. https://gitlab.com/pyspread/pyspread/-/blob/master/.gitlab-ci.yml#L12
@spamme180_gitlab If you want a QPushButton then you can use Format -> Button cell. When the displayed button is pushed, the code of the cell, in which it is displayed, is executed. Other Qt widgets are not supported out of the box. If you just want to display them, render them to an SVG string and change the cell renderer to
Image renderer