The worst of the two worlds: Excel meets Outlook

Re:The worst of the two worlds: Excel meets Outlook by xiaq on Saturday February 13, 2021 @08:06PM (#26128693)

If you have a long expression, you can break it into multiple ones by storing some intermediate results in another cell. You can also hide such cells or put them in another sheet.

This might sound like a hack, but being able to see intermediate results makes debugging complex expressions easier too, so in a sense it is working as intended.

[ Parent | on HN ]

Re:The worst of the two worlds: Excel meets Outlook by DavidPeiffer on Saturday February 13, 2021 @10:53PM (#26129521)

Formula -> Trace Dependencies/Precedents is also super handy! I have a short VBA loop that applies it to all selected cells. It makes it very easy to visually spot one cell reference that's wrong, because 20 cells connect to corresponding cells with parallel lines, then one isn't parallel.

Ctrl+Tilda toggles show/hide formulas, which helps identify input cells when you inherit a messy spreadsheet.

[ Parent | on HN ]

Re:The worst of the two worlds: Excel meets Outlook by darkerside on Saturday February 13, 2021 @10:41PM (#26129448)

3D Excel would be intriguing. A dimension on which to store intermediate calculations.

[ Parent | on HN ]

Re:The worst of the two worlds: Excel meets Outlook by phonon on Sunday February 14, 2021 @02:41AM (#26130430)

Sounds like https://en.wikipedia.org/wiki/Lotus_Improv

[ Parent | on HN ]

Re:The worst of the two worlds: Excel meets Outlook by davchana on Sunday February 14, 2021 @11:09AM (#26133484)

I would love just getting the ability to resize the Evaluate Formula dialogue box text area.

[ Parent | on HN ]