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.

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

Lupp gravatar image

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

(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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 60 times

Last updated: Jul 03 '17