Created attachment 126986 [details] spreadsheet in xlsx format The sum of numbers for column B, and, the sum of numbers for column N are disproportionate. In any case when I added up the numbers using a calculator (KARCE KC 328) the sum of column is 97.49 EUR which indicates a rounding problem as when I highlighted the numbers the sum displayed is 97.57 EUR. In some applications rounding can make a difference, so I need to understand the accuracy involved.
I'm a bit confused, column N depends on other columns as well, apart from B, why should they be proportionate? Before I look into the numbers, what did you add exactly to get 97.49? I do see that the sum of N2:N45 is 97.57. Note that there is indeed some rounding in displaying values, if I format cells to display with 4 decimal digits, N18 becomes 0.0720 for example, and the sum shows 97.5730 (despite the rounded values, I'd assume Calc uses the "exact" numbers for the calculations).
Created attachment 126994 [details] Another way with sample file Not all calculations in column N are based in column B, like in N13, N14 or N20. I can't see any bug here.
I wouldn't be hasty to claim there's no bug until we know exactly what Jonathan meant. Then again, if he thinks there's an issue, or something is still unclear, he's welcome to reopen the bug report with further details.
Do what you like Aron.