Google Spreadsheets-在保留数学函数的同时重置单元格吗? [英] Google Spreadsheets - Resetting cells while keeping mathematical functions?

问题描述

我正在使用Google Spreadsheets，我想创建一个按钮，该按钮在激活后将重置一系列单元格中的数据，但保留分配给这些单元格的任何数学函数.

I am working in Google Spreadsheets and I am wanting to create a button that, when activated, will reset the data in a range of cells but keep any math functions assigned to those cells.

我已经尝试了基本的clearContent();脚本，但是我发现这会删除单元格中的所有数据(文本和函数).

I have experimented with the basic clearContent(); scripting but I found that this deletes all data within a cell (text and functions).

有没有一种方法可以在清除文本的同时保留功能?

Is there a way to keep the functions while just clearing the text?

推荐答案

有充分的理由要从单元格中删除数据并保留公式.我创建了可以完成我的校长想要的计算任务的工作表.所需的结构我一次制作工作簿页面一周.如果我复制下一周的工作表，然后删除数据，那么下周我就准备好了.当我输入数据时，将使用公式来计算新的计算.Excel有一个清除"按钮，可以完成此操作.选择要删除数据的单元格，并在保留公式的同时将其删除.

There is a good reason to want to delete the data from a cell and keep the formula. I have created sheets that accomplish computational tasks my principal wants. The structure requiored I make the workbook page for a week at a time. If I copy the sheet for the next week, then delete the data, I am all set for the next week. As I input data the formulas are used to compute the new calculations. Excel has a CLEAR button which allows this to be done. Select the cells to delete the data and remove it while leaving the formulas.

这篇关于Google Spreadsheets-在保留数学函数的同时重置单元格吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！