A computer application that simulates a paper accounting worksheet.
2
votes
1answer
839 views
How do you insert an Excel sheet as part of a new mail message?
How do you insert an Excel sheet as part of a new mail message? I tried inserting a MS Excel document directly / via a Microsoft document. But when I copied into a new Gmail message, the formatting ...
1
vote
0answers
1k views
Change value in one cell through a formula in another cell
I am trying to capture a timestamp for when a spreadsheet is first edited, and ONLY keep that first timestamp. However, NOW() updates each time a spreadsheet is edited. I found a working formula ...
0
votes
0answers
7 views
CSV Web Interface
Is there a web app (preferably open source) which lets you upload CSV file and create CRUD presentation (preferably with users and permissions)? It may treat first row as header and rest as content. ...
0
votes
0answers
5 views
Google Spreadsheets Messes Up Comments When Sorted
I added comments to a bunch of cells. When I then sorted the cells, the comments did not follow their original cell and now was connected to the new cell. This is a massive problem and now my ...
0
votes
0answers
24 views
Google Docs spreadsheets: how to specify entire sheet as range?
The best workaround I have found so far is:
worksheet_name!$A$1:$YY
but ideally I would like to be able to simply write, e.g.:
worksheet_name!
So, does anyone know: is there a syntax for ...
0
votes
0answers
23 views
Referencing a cell for a formula by how many rows down the cell is from another
Hi I have a problem with a formula where I am trying to get a total flow per 24 hours.
My columns are referenced by date with data every two minutes with flow creating an increasing total over time.
...
