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.
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.
So you have some formula in C1, which writes something to a different cell (A1)? I suppose it’s only possible with some kind of user-defined functions (implemented with macros). Am I right?
Then you have at least one way to achieve what you want, and one important thing to note.
Of course, it’s only applicable if I understand the mechanics right.
No, it’s not a custom formula/macros.
Anyway I’d manage to extract manual dates with method of erAck below.
So the case is closed I suppose.
You could try if one of the online viewers on the net (search for ODF .ods viewer) displays data without recalculating (if you want to throw your data at them). Other than that you can extract the content.xml stream from the zipped document and view that (if it’s not too confusing to you). To do so unzip yourfile.ods content.xml then you can open it with Firefox like in firefox content.xml and search for occurrences of <text:p> elements that contain the displayed string before saving. You will have to keep track for yourself which rows/columns/cells you are in, i.e. by following the table:table-row and table:table-cell elements (note that repeated cells in a row are written as <table:table-cell table:number-columns-repeated="2"/> (here for two cells in a row, for example empty, so the next cell with data would be the third cell)). Formula cells also contain the unformatted value as attributes, for dates that is, for example, office:value-type="date" and office:date-value="2018-12-05T14:58:45.84", the result of a table:formula="of:=NOW()"
Thank you very much - that is helpful in my case!
Sorry I don’t have enough reputation to upvote your answer like a solution.