Ask Your Question

Open Librecalc file without execute formulas [closed]

asked 2018-12-05 09:12:39 +0200

Topper gravatar image

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() ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-12-06 17:14:39.758556


Can't you just fix the start date formula, to recalculate and show you the desired output?

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-05 09:21:48 +0200 )edit

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.

Topper gravatar imageTopper ( 2018-12-05 10:03:39 +0200 )edit

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?

erAck gravatar imageerAck ( 2018-12-05 11:01:00 +0200 )edit

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.

Topper gravatar imageTopper ( 2018-12-05 11:08:12 +0200 )edit

That's why I want to open sheet w/o execution of formulas to see MANUAL ENTERED DATA.

Topper gravatar imageTopper ( 2018-12-05 11:08:44 +0200 )edit

/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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-05 11:18:12 +0200 )edit

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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-05 11:25:29 +0200 )edit

Never mind, focus on "open sheet w/o execution of formulas " - do you know way or it's impossible and that's all.

Topper gravatar imageTopper ( 2018-12-05 11:25:45 +0200 )edit

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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-05 11:36:26 +0200 )edit

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.

Topper gravatar imageTopper ( 2018-12-06 09:52:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-12-05 15:08:12 +0200

erAck gravatar image

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()"

edit flag offensive delete link more


Thank you very much - that is helpful in my case! Sorry I don't have enough reputation to upvote your answer like a solution.

Topper gravatar imageTopper ( 2018-12-06 09:48:40 +0200 )edit

Question Tools

1 follower


Asked: 2018-12-05 09:12:39 +0200

Seen: 23 times

Last updated: Dec 05 '18