Open Librecalc file without execute formulas [closed]
Hello everyone, Due to logical mistake whole schedule with start date and calculated end date is fake. In Start date was put logical condition and when is not true the date is fulfilled with Today(). So everything is starting today that is wrong.
My question is how to open file w/o executing formulas and does that make sense to see actual entered dates, not Today() ?
Can't you just fix the start date formula, to recalculate and show you the desired output?
Sure I can but I loose that way actual dates. Now when open the sheet - every one task without predecessor is TODAY. I just want to open the sheet without re-fresh to see dates, not today date.
I don't understand why fixing the formulas would display wrong dates. If you replace occurrences of TODAY() with DATE(...) or calculated date values that depend on other cells then that should be correct, shouldn't it?
Because instead of StartDate 12/01/18 which is entered MANUAL, from other cell date is calculated as Today(), the EndDate = StartDate+TaskLenght and.... when the sheet is open everyone task is OK because StartDate is TODAY.
That's why I want to open sheet w/o execution of formulas to see MANUAL ENTERED DATA.
/me cannot understand how it's possible that there was some manually-entered data in cell, and at the same time, something that causes the cell to change when formulas recalculate.
Anyway, you can open the spreadsheet as a ZIP (if you are using ODS/XLSX), and look through the XML files there for the cached data.
Never mind, focus on "open sheet w/o execution of formulas " - do you know way or it's impossible and that's all.
Sigh. Two LibreOffice developers here trying to help you, @erAck being the key Calc developer. I suppose that if we knew a way, we'd start from the solution, and only then asked how did you create that. But given the we cannot see how it's possible, we cannot suggest some workarounds, too. So, if your position is "never mind, just answer the direct question" - then no, personally I cannot help.
Let say it in less words - cell A1 is fulfilled with manual entered StartDate1. Cell C1 has a formula, which checks condition in B1 and when B1 is empty (when Task1 with StartDate1 doesen't have a predecessor) with the formula writes Today() in A1 and also calculate EndDate in D1. So that (wrong) way we loose manual entered date in A1.