Ask HN: What are your most common tasks and painpoints in spreadsheet software?

Re:Ask HN: What are your most common tasks and painpoints in... by wodenokoto on Monday January 15, 2024 @11:11PM (#39009395)

I’d like to be able to have custom functions that use cells as parameters.

It’s often difficult to understand the state of a cell (what is it’s formatting and other rules)

It’s difficult to reason about what the underlying value of a cell is and it’s representation (e.g, 12-nov-22 == 12/11/2022) and what will happen when you change the value type of a cell

At least for excel, scrolling doesn’t follow curser. Cells are deselected when focus leaves a window.

It’s not like any of these are going to revolutionize the spreadsheet.

I think old versions of access had a front-end builder. Now MS have power apps, but it’s not very nice and the backend data store is also not great.

A spreadsheet backed app builder would be nice.

I wish I could name cells, such that my

[ Parent | on HN ]

Re:Ask HN: What are your most common tasks and painpoints in... by atoav on Tuesday January 16, 2024 @12:47AM (#39009914)

Having coding/logic more decoupled from visuals/styling would be interesting.

E.g. allowing the application to be more visually clear when describing states of cells and the relationships between them, while giving one more freedom in the way those cells are then displayed.

[ Parent | on HN ]