advanced-tables-obsidian icon indicating copy to clipboard operation
advanced-tables-obsidian copied to clipboard

Spreadsheet formulas column sum problem whit last version (ok with 0.13.0)

Open EKliptus opened this issue 2 years ago • 0 comments

Describe the bug On the 0.13.0 version of Advanced Tables plugins and previous, I use a very beautiful formula I made :) to calculated my time spend on a task. But on the 0.17.2 this really beautiful formula no longer works :(

To Reproduce This is the entire table, past it in 0.13.0 it work, in 0.17.2 it don't work :

| date  | am start | am end | pm start | pm end | Total h |
| ----- | -------- | ------ | -------- | ------ | ------- |
| 12/01 | 8        | 12.5   | 14       | 18     | 8.5     |
| 13/01 |          |        | 19       | 23     | 4       |
|       |          |        |          | Total  | 12.5    |
<!-- TBLFM: @>$>=sum(@I..@-1) -->
<!-- TBLFM: @I$>..@>$>=(($-1-$-2)+($-3-$-4)) -->

Expected behavior past it in 0.17.2 and "evaluate table formulas" the sum of the last column should be 12.5 like in the 0.13.0 version. But the sum is equal to 0

Screenshots image

Desktop (please complete the following information):

  • OS: Win 10
  • Obsidian Version: 0.13.19
  • Advanced Tables Version: 0.17.2

EKliptus avatar Jan 28 '22 21:01 EKliptus