Ask Your Question

in libre calc - in the source file I assigned a name to a cell which has a formula. When I linked this named cell to the target file by external data, I get the formula in the target cell. I want the result of the formula to appear in the target cell. [closed]

asked 2017-07-03 07:59:55 +0100

Milind Vaze gravatar image

After linking external data from a named cell having a formula, I am getting the formula in the target cell, but I want the result of the formula to appear.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-09 00:28:16.548176

1 Answer

Sort by » oldest newest most voted

answered 2017-07-03 14:23:39 +0100

Lupp gravatar image

updated 2017-07-03 14:26:30 +0100

(You might try next time to find a more concise though incisive subject. The fully worded question comes then next in another place.)

There is a probably related bug tdf#61743. The original reporter was myself but it was one of my early attempts, and I didn't a good job.

The original claim of that bug was that named ranges (may be single-cell ranges) do not work with relative path-saving. Later the aspect you mentioned came into sight. There is a recent (2017-04-19) comment #12 by Eike Rathke making an assumption about the background. The bug is still not assigned. You may try a kind of bump adding to that bug.

( @erAck )

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-07-03 07:59:55 +0100

Seen: 67 times

Last updated: Jul 03 '17