Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


So, what do you mean with "is not working"? I made a test sheet with some figures and formulas, and also defined a couple of areas. Moreover I made a new sheet where I inserted links, in the way I assume you mean. Well, here is my experience.

A link appears to make a copy of the content in the source into the target cells with relative cell addressing in the target. An empty cell in the source is copied when linking as an empty cell in the target. I can agree, this is not how one use to look at a link. To me a link is something pointing to the value in the source, might be a formula, but still with addressing in the source. Apparently this is not how LO looks at this, and that is a surprise for me too. A bug or something to live with? Someone?
____________________________________________________________________________________________________________

Hello! Need Help with calc. I often use links to other cells. That is, for example, copying what a cell, and then for example in another worksheet using the menu "insert as" and insert a link. But if I cell is empty, then "insert as a" link on an empty cell is not working. You can of course use a formula such as: = A1, but it is not convenient.

Здравствуйте! Требуется помощь по calc. Я часто использую ссылки на другие ячейки. То есть например: копирую какую нибудь ячейку, а затем например в другом листе использую меню "вставить как" и вставляю связь. Но если я ячейке пусто, то "вставить как" связь на пустую ячейку не работает. Можно конечно использовать формулу например: =A1, но это не удобно.


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.