I just spent 30m chasing a penny in Calc while updating a cash flow forecast. One of the cells was a simple formula (99% of an amount, formatted as currency). The displayed result was $11.74. But a subsequent formula that summed that cell with some others apparently came to a different conclusion, reducing the amount by 0.01, causing my sum to differ from the bank statement by a penny even though all of the individual transaction amounts matched. 1/2

@johns In times of Calc trouble, I turn to Gnumeric. Always wonder why I never just use it in the first place. It's so nice. Fast, pixel-perfect icons, all around great.

Follow

@davisr Hmmm.. I haven't tried it in several years, but I certainly wish I'd thought to try it in this case. (Maybe I still will to see if it handles the case differently..)

Sign in to participate in the conversation
Librem Social

Librem Social is an opt-in public network. Messages are shared under Creative Commons BY-SA 4.0 license terms. Policy.

Stay safe. Please abide by our code of conduct.

(Source code)

image/svg+xml Librem Chat image/svg+xml