Re: [libreoffice-users] calc
Thanks, got vlookup to do what I want. :-) -- 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
Re: [libreoffice-users] Libre office writer
Is the long list in any other file? I think it is gone from Writer and you need to restore it from a backup. translate.google.com On 2024-06-05 18:31, Harry Stoller wrote: Hello. During data recovery, I recovered Libre office writer. Almost everything from it recovered. Some writing isn't how it used to be. Like a long list of problem solving. After recovery, it made itself short. Anything I can do to recover writing how it was before? Some are in Chinese too. How do I translate? -- 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
Re: [libreoffice-users] calc
I believe what OP wants is "Give me the contents of the cell at Column B, Row the-number-that-appears-in-cell-A4" I think it can be done with CONCAT but I wouldn't bet money on it. --hymie! On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote: > If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what > you want > > > > Op 6 jun. 2024, om 05:33 heeft James het volgende > > geschreven: > > > > Say I have column A with the numbers 1, 2, 3: > > A1 (1) > > A2 (2) > > A3 (3) > > and column B with the numbers 11, 22, 33: > > B1 (11) > > B2 (22) > > B3 (33) > > > > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch > > which row is referenced so I can see the effects of different choices). > > > > Is there a calc function which can find which row I chose so I > > automatically populate row 4, column B? > > Row 4, column A matches one of the rows 1-3... > > > > -- > > 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 > > > -- > 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 > -- 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
Re: [libreoffice-users] calc
Ignore me, I think I misunderstodd your "vlookup" command which now looks right to me. Sorry. --hymie! On Thu, Jun 06, 2024 at 08:10:42AM -0400, hymie! wrote: > I believe what OP wants is "Give me the contents of the cell at Column B, > Row the-number-that-appears-in-cell-A4" > > I think it can be done with CONCAT but I wouldn't bet money on it. > > --hymie! > > On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote: > > If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what > > you want > > > > > > > Op 6 jun. 2024, om 05:33 heeft James het volgende > > > geschreven: > > > > > > Say I have column A with the numbers 1, 2, 3: > > > A1 (1) > > > A2 (2) > > > A3 (3) > > > and column B with the numbers 11, 22, 33: > > > B1 (11) > > > B2 (22) > > > B3 (33) > > > > > > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch > > > which row is referenced so I can see the effects of different choices). > > > > > > Is there a calc function which can find which row I chose so I > > > automatically populate row 4, column B? > > > Row 4, column A matches one of the rows 1-3... > > > > > > -- > > > 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 > > > > > > -- > > 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 > > -- 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
Re: [libreoffice-users] calc
If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what you want > Op 6 jun. 2024, om 05:33 heeft James het volgende > geschreven: > > Say I have column A with the numbers 1, 2, 3: > A1 (1) > A2 (2) > A3 (3) > and column B with the numbers 11, 22, 33: > B1 (11) > B2 (22) > B3 (33) > > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch which > row is referenced so I can see the effects of different choices). > > Is there a calc function which can find which row I chose so I automatically > populate row 4, column B? > Row 4, column A matches one of the rows 1-3... > > -- > 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 -- 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
Re: [libreoffice-users] [SOLVED] Table of Contents, again
Good afternoon On 2024/06/05 20:12, W. Robert J. Funnell, Prof. wrote: Thomas - In the 'Table of Contents, Index or Bibliography' dialogue window, in the 'Type' tab, under 'Create From', is the 'Additional styles' box unchecked? No, it was checked. I did that before. Apparently, you DO HAVE to check it and assign OTHER STYLES than those of the headings. They are designed to provide some extra space, font size etc. for chapter headings. Using them creates a total mess. Where the inclusion of ALL paragraphs comes from I still have not figured out. The solution to my basic problem: Use / create other paragraph styles, in my case I tried "contents", set font size, indent etc. and I got a single-spaced TOC. The LO manual says: "*Additional styles *You *_can _*add more paragraph styles to the TOC. This *_can _*be useful, for example, when you want to include the heading of an annex (appendix) in the TOC." Apparently you MUST these extra paragraph styles to make the TOC work. When I first tried to set up a TOC, clutching the manual, I did not give that wording a second thought, since there are a lot of things you "can" but do not have to do. Well, for the time being I solved the problem, hoping to remember it until the next time. Thank you. Thomas -- 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] Libre office writer
Hello. During data recovery, I recovered Libre office writer. Almost everything from it recovered. Some writing isn't how it used to be. Like a long list of problem solving. After recovery, it made itself short. Anything I can do to recover writing how it was before? Some are in Chinese too. How do I translate? -- 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