Table Total Row Issue

Post Reply
PeterC
Posts: 7
Joined: Tue Mar 13, 2018 6:10 pm

Table Total Row Issue

Post by PeterC » Fri Jun 05, 2020 10:08 pm

If a worksheet is deleted in PlanMaker (note: I am using xlsx format), Total Row calculations (sum, count, etc.) in tables become inaccurate and require updating in any tables created to the right of the deleted worksheet. For example, if I have a workbook with worksheets A, B, C, D, E, and F, and I delete worksheet C, then any table Total Row summeries in worksheets D, E, and F become inaccurate (and require recalculation).

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1415
Joined: Wed Mar 11, 2020 5:31 pm

Re: Table Total Row Issue

Post by SuperTech » Fri Jun 05, 2020 11:39 pm

This is the case only if the sheet you are deleting has reference in the sheets right to it. Otherwise, there will be no such problem. If you currently have this problem please share your PlanMaker sheet and let us know with which sheet you have this problem.

You can share the file privately to our email ID forum[at]softmaker.de

Please mention link of this post also in the email:
viewtopic.php?f=383&t=20116&p=66435#p66435

PeterC
Posts: 7
Joined: Tue Mar 13, 2018 6:10 pm

Re: Table Total Row Issue

Post by PeterC » Sat Jun 06, 2020 5:22 pm

The worksheets and tables previously referenced had no links internally or externally. Additionally, the worksheets and tables were initially created in SO 2018.

SuperTech
SoftMaker Team
SoftMaker Team
Posts: 1415
Joined: Wed Mar 11, 2020 5:31 pm

Re: Table Total Row Issue

Post by SuperTech » Sat Jun 06, 2020 7:14 pm

Thanks for the information. I am waiting for the file as I tried to reproduce the issue but everything worked as expected. We have to check your file in which this issue occurring for a better resolution of this problem.

Post Reply

Return to “PlanMaker 2021 for Windows”