Support » Plugin: TablePress » Tablepress Reference Value In Another Cell, Same Table

  • Resolved caljim

    (@caljim)


    I have columns of numbers and I totaled them with =number_format(SUM(C2:C51)). The works. However, I need to show thousands separators in most numbers. If I use something like this in the cell it works: =number_format(577737).

    Now the problem. If I put =number_format(577737) in a cell that is summed as above then it crashes =number_format(SUM(C2:C51)). So I’m trying a hidden cell for the formula and I want to put the value from =number_format(577737) in a cell that is summed, hoping to not crash the sum formula.

    I tried using =D51 but that gives an error in both the summed cell and the sum formula cell: !ERROR! D51 does not contain a number or expression.

    Now what?

    It would be wonderful if we could format the whole columns with the thousands separator instead of hacking each cell!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The best chance for working with formatted data is to first create the complete table without any NUMBER_FORMAT calls. After that, insert new columns in the table, e.g. a new column E, in which you then only add

    =NUMBER_FORMAT(D5)
    

    (for each row with the correct number).

    Regards,
    Tobias

    Thank you. That does work for numbers in the display column with the NUMBER_FORMAT’s in each cell but I can’t make anything work for the totals at the bottom. I could hide the input column with the NUMBER_FORMAT for the totals mirrored in the display column if there was some way to show the value from SUM in the display column / mirror only the value.

    When I try this with a simple =C52 in the display column it doesn’t mirror the value and I have this message:

    !ERROR! C52 does not contain a number or expression

    I would love to let users make some changes in the columns for their analysis but not have that change in the db. I’m sure that is asking too much of any WP data table though.

    Great support for an O/S project!!!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    what does cell C52 contain? A NUMBER_FORMAT formula? If so, you’d need to move that to the target cell as well. Basically, the approach would need to be duplicated for the SUM row, just with an extra row.

    Unfortunately, TablePress does not contain a possibility to allow users to change the values, sorry.

    Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.