A couple of simple questions

Post Reply
beny
Posts: 33
Joined: Tue Sep 20, 2016 5:16 pm

A couple of simple questions

Post by beny »

A couple of simple questions.
After performing calculations in a column with the SUM formula and saving the document, how do I stop the formula from functioning? After all, even after reopening the document, the formula continues to work.

The document contains 10 columns and 20 rows. How to remove unused rows and columns?
Woody44
Posts: 242
Joined: Wed May 22, 2019 11:56 pm

Re: A couple of simple questions

Post by Woody44 »

beny wrote: Tue Jan 25, 2022 9:43 am A couple of simple questions.
After performing calculations in a column with the SUM formula and saving the document, how do I stop the formula from functioning? After all, even after reopening the document, the formula continues to work.
I am not affiliated with SoftMaker, I'm a fellow user. With that disclaimer, I have to say that I do not understand your question. The entire purpose of a spreadsheet is that the formulae are supposed to keep working. That's so that, if you change any numbers in (to use your example) the column being added, the sum automatically changes. Why would you want a formula to NOT work?
The document contains 10 columns and 20 rows. How to remove unused rows and columns?
If you are using the ribbon menu, from the Home tab go to Cells, and click the little down arrow next to the word "Delete." This will open a drop-down menu offering the option to delete a complete row or a complete column. Be sure you are in the row or column you want to delete -- this commend works on the active row or column.
beny
Posts: 33
Joined: Tue Sep 20, 2016 5:16 pm

Re: A couple of simple questions

Post by beny »

Woody44 wrote: Wed Jan 26, 2022 5:43 am Why would you want a formula to NOT work?
By default, the SUM function is disabled. I work with a document and perform operations using SUM. After the document is ready, I want to disable only for this document the SUM function that I enabled. Not for Planmaker as a whole, but just for this document, i.e., return the function to its default state.
For example, originally the default font is 10pt, if I change it to 14pt, I can always return it to the default state.
beny wrote: Tue Jan 25, 2022 9:43 am If you are using the ribbon menu, from the Home tab go to Cells, and click the little down arrow next to the word "Delete."
No, that's not it. This does not apply to rows and columns outside the range A1-J20. You need to delete all rows and columns that are not in the specified range. There is a custom instruction for Microsoft Excel for a similar purpose.
27.png
stascheit
Posts: 20
Joined: Fri Nov 09, 2018 11:34 am

Re: A couple of simple questions

Post by stascheit »

I have to agree with woody, I can't follow these questions as they are described.

To your first question:
How did you enable the SUM function in PlanMaker?
In my mind, it is only possible to insert a SUM formula to a cell. This formula can be edited or deleted, but not be disabled.
Maybe you used the AutoSum function (?), but even this only inserts a formula to one or more cells.

To your second question:
How did you proceed in Excel to achieve what is shown in your screenshot?
I cannot imagine that the cells are really deleted. I assume that the sheet is prepared with the Page Break Preview(?)
This command is available in PlanMaker also. When using the ribbon interface:
On the ribbon tab View, enable the "Page break preview". Now you can adjust the range by dragging the dashed lines with the mouse.

Another method is to hide the cells that are beyond your specified range:
Select all columns to the right of your range and right click to open the context menu, select "Hide".
Then do the same with the rows below your range.
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2108
Joined: Wed Mar 11, 2020 5:31 pm

Re: A couple of simple questions

Post by SuperTech »

If you wrote a formula, and now you just want the values so that the formula shouldn't recalculate, please follow these steps:

1. Select that cell > Right click > Copy.
OR
Press Ctrl+C

2. Again, right-click on that cell > Paste special > Check "Convert formulas to values" > OK.

This will remove the dynamic formula and paste the static value of it in the cell.

As explained above, you can hide unused rows and columns.
Woody44
Posts: 242
Joined: Wed May 22, 2019 11:56 pm

Re: A couple of simple questions

Post by Woody44 »

beny wrote: Wed Jan 26, 2022 7:42 am
Woody44 wrote: Wed Jan 26, 2022 5:43 am Why would you want a formula to NOT work?
By default, the SUM function is disabled. I work with a document and perform operations using SUM. After the document is ready, I want to disable only for this document the SUM function that I enabled.
What do you mean, "By default, the SUM function is disabled"? I have been using Excel for twenty years, before that I used Quattro Pro extensively, and before Quattro Pro I used Lotus 1-2-3. The SUM function is not disabled "by default." It is always there and active (just like every other function) whenever you type it into a formula.
beny wrote: Wed Jan 26, 2022 7:42 amNo, that's not it. This does not apply to rows and columns outside the range A1-J20. You need to delete all rows and columns that are not in the specified range. There is a custom instruction for Microsoft Excel for a similar purpose.
But your screen shot does not show that the rows and columns outside of the selected area are deleted. They are still there, as demonstrated by the fact that the row and column headings are still present. You have not deleted those rows and columns. All you have done is to somehow hide the display of the grid lines outside of the selected area.
Post Reply

Return to “PlanMaker 2021 for Windows”