contains prices for each product on different dates.
contains dates which are sorted into descending order.
is grouped by Column A which contains the name of the products e.g. "file:///Applications/./data.ods"#$DATA.ĭoes anyone know how I can reference the external (and closed) workbook inside an array formula with nested IFs like in the examples above? I also came across this post which states that Err:504 may be due to that literal strings are "double quoted". Given my research, here is where I originally got my syntax for referencing by file-URL. It seems to be that somehow OpenOffice Calc does not read the domain reference to the external workbook properly, but for other formulas it works (like the one mentioned above). I have the following formula that works in OpenOffice 4.1.2: does not work either. I thought I should ask this separately as this issue is external references related. The row (each row) contains several references to the row just above, so I thought the easiest way would be INDIRECT(ADDRESS(ROW()-1,COLUMN())) for the same column or INDIRECT(ADDRESS(ROW()-1,1)) for column A.Basically this is a continuation of my previous post. Cell d46 could point to d45 or b45 or $a45, and that would work when copying a row, but not when inserting or deleting a row: If you insert a row just above, the references pointing 1 row above would start pointing 2 rows above, so each time I would have to edit the formulae. I want to refer to a cell immediately above or a cell from a row immediately above. Is the problem that a very long branched out calculation trail makes the software think it will never get to the initial values and therefore it must be circular? (Which my idea of fixing values would solve.) Or could there be something else I may have missed? I have also found out about Ctrl-Shift-F9 (must be re-calculate), which also makes errors disappear.Įven though the file has been saved and re-saved by LibreOffice several times it still reports false Error 522 when I open the file, so it doesn't seem to be compatibility problem. Sometimes a change makes it re-calculate it all and errors disappear and doesn't reappear when I undo the change. LibreOffice, however, when the file is opened, seems to give up after some rows and further calculations become Error 522. Until recently I used and it worked fine. (Yes, I have considered fixing values every 50-100 rows to reduce calculation trail.) I use reference functions: ROW(), COLUMN() and INDIRECT(), ADDRESS(). I have a large spreadsheet: 700+ rows, each having references to the previous row.
0 kommentar(er)
