Browse Search Popular Register Upload Rules User list Login:
Search:
XL Spreadsheet

Image:
screenshot of the scene

Author: s_noonan

Group: Default

Filesize: 53.09 kB

Date added: 2022-12-24

Rating: 5

Downloads: 249

Views: 113

Comments: 3

Ratings: 1

Times favored: 0

Made with: Algodoo v2.1.0

Tags:

Scene tag
You no longer need to use those other spreadsheets that have a similar sounding name to this one. Don't be bashful, just uninstall that other app (since it's now a subscription) and use this one instead.

Rev A: Works only with simulation running.
Rev B: Enter key now works.

I couldn't get the GUI to recognize the caret ("^") with the simulation paused. Maybe somebody else can figure it out.
Last edited at 2022/12/31 12:23:12 by s_noonan
Please log in to rate this scene
edit
Similar scenes
Title: AI box template
Rating: 5
Filesize: 28.56 kB
Downloads: 738
Comments: 0
Ratings: 1
Date added: 2012/12/14 23:44:13
Made with: Algodoo Phunlet
screenshot of the scene
AI box template
Rating: rated 5
download
Title: Create your own book!
Rating: 5
Filesize: 0.58 MB
Downloads: 456
Comments: 3
Ratings: 1
Date added: 2016/07/09 21:28:09
Made with: Algodoo v2.1.0
screenshot of the scene
Create your own book!
Rating: rated 5
download
Xray
2022/12/24 23:26:18
My "other" similar-sounding spreadsheet app has many more cells (rows and columns) than this one. So how can I increase the number of cells?
s_noonan
2022/12/25 00:00:55
Q: So how can I increase the number of cells?
A:

1. Make the main form larger.
2. Copy and paste the original cells.
3. Rename the new cells.
4. Scale up the common _calcResult and _calcAll functions for each cell.

I won't hold my breath. One problem is that I couldn't find a way to automatically create variables in a loop that can be seen in another loop so the cell object variables and cell value variables had to be created by hand before filling automatically. Another problem I had is in calculating all the cells in the right order. Ideally the program would build a dependency tree and calculate cells in an order based on dependency level. That's not going to happen.

One interesting thing that I found out while trying to figure out how to recognize the caret (^) symbol is that You can call the onKey(e) function while the simulation is paused and it will detect key presses.
Xray
2022/12/25 00:30:48
Okay, I'm glad that I held off uninstalling my "other" spreadsheet app! :lol: