use the "frozen" value of a cell in calc [closed]

asked 2014-11-02 12:18:11 +0100

phil_69 gravatar image

I'd want to reference a named cell in a formula, and use its immediate value, that is, the value it stores at the moment where the sheet is saved. The way to achieve that would be to add a "frozen" attribute to the cell, which modifies its behavior: the value it holds is "frozen" into the formula when the document is saved, and later the user must explicitly ask to update the formulas which reference this cell. Another way would be to create a new type of reference. I need that to create a model with one sheet per month, which uses bus or train prices, mileage allowance, etc. stored in named cells, but keeps the correct values for past months whenever the rates change.

Does this feature exist, or is it possible to develop it?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-05 18:48:04.068026

Comments

2

"Does this feature exist ...?" No, as far as I know.

"... or is it possible to develop it?" Programming Subs and assigning them to events: nearly everything possible in principle. I would not recommend this for many reasons.

"... create a model with one sheet per month ..." As I deduce from own old experiences and from many questions (cries for help) in this forum and in others: Keeping data of same structure in more than one sheets is a source of problems arising on and on.

Lupp gravatar imageLupp ( 2014-11-02 13:26:56 +0100 )edit

I am wondering what @JohnSUN would answer and hope he gets triggered by this comment.

ROSt52 gravatar imageROSt52 ( 2014-11-03 02:14:11 +0100 )edit

Lupp rightly said "I would not recommend this for many reasons". "stored ... but keeps the correct values ​​for past months whenever the rates change"- This is not a task for the calculator (Calc), but for the database (Base)

JohnSUN gravatar imageJohnSUN ( 2014-11-03 09:14:24 +0100 )edit

@JohnSUN & @Lupp - Thanks for your comments!

ROSt52 gravatar imageROSt52 ( 2014-11-03 10:47:19 +0100 )edit