Re: [libreoffice-users] Writer "Show variable" from Custom Properties?
On 2020-10-20 00:53, John Kaufmann wrote: The current Writer Guide (WG60, I believe) says that one way to define variables (particularly, but not limited to, text values) for use in a document is in "Custom Properties" (File > Properties > Custom Properties). Unfortunately, variables so defined do not show in the "Show variables" list (Insert > Field > More Fields > Variables > Show variable). So how are those variables inserted as text fields in the document? AFAICS neither Writer Help nor WG60 covers this question. Um, sorry for the list noise on this question. After a couple hours of not finding it in the referenced documentation (Help and WG60), I just found that variables defined in "Custom Properties" are treated differently from variables defined via Insert... . So, from Insert > Field > More Fields, the "Custom Properties" variables are inserted from the "DocInformation" tab > "Custom" rather than from the "Variables" tab > "Show variable". But that raises new questions. For example: Isn't it a hazard to having two databases for the document's variables? For example, what happens if the same variable name is used in both places? Also, I still have not found an answer to this: Also not covered (AFAICS) is the use of DDE for text fields in the document. How is that done? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Writer "Show variable" from Custom Properties?
The current Writer Guide (WG60, I believe) says that one way to define variables (particularly, but not limited to, text values) for use in a document is in "Custom Properties" (File > Properties > Custom Properties). Unfortunately, variables so defined do not show in the "Show variables" list (Insert > Field > More Fields > Variables > Show variable). So how are those variables inserted as text fields in the document? AFAICS neither Writer Help nor WG60 covers this question. Also not covered (AFAICS) is the use of DDE for text fields in the document. How is that done? John -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] use calc 7 IF command to change some column values?
I have a column of 365 daily values, non-negative integers, (for a calendar year) I want a columns (column 2) just like that but with some cells (start and end row specified) to be zeroed if they are too large. so... 1 1 3 3 21 21 29 0 22 22 0 0 All values in column 1 to be copied to column 2 and if greater than 28 replaced by zero. The help page gives a highly relevant IF function example that almost works. I just don't see how to write the value of the column 1 contents rather than the cell reference. The modified example is '=IF(A1:A13>28,0,"too small")' at first I tried changing "too small" to A1 but I get "A1" in column 2 rather than a value. I don't see the syntax to get column 1's value rather than its reference. Anyone? Dave -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
