![]() Remove the table’s border by inserting the cursor in the cell, right clicking, Table/Borders and Set no borders.If you Paste special the cell value then you get the following result:īut don’t freak out! Our problem is not the DDE link per se, but rather the way it is displayed! So what we need to do is change its format so that it stays put at the desired position. Let’s assume, for example, that you have the following line of text in a writer documentĪnd you want to place a linked calc spreadsheet value after the colon. ![]() What if you want this value to be in-line with the rest of the text? The apparent problem when using this option, though, is that the resulting value is pasted in a one-line table. This is done by copying the cell value from calc and then Paste special / DDE Link in the document. What I rather needed was to have some value in my document that would be updated from the respective spreadsheet cell, whenever it changed. This is used when you want to merge multiple values at a specific place in your document, to produce many documents with the same general layout, but with different field values (it is referred to as mail merge). My first impulse was to use Inser/Field and use the database connector, but that didn’t work for me. ![]() Working with Libreoffice Writer I found myself in need to link some specific numerical values to a calc spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |