Re: [libreoffice-users] Heading 1 missing in Navigator
On 16.09.2017 05:03, gordon cooper wrote: Hi Regina, Vielen danke, the Tools>Outline-numbering has solved part of the heading/TOC problem. I wonder if you can help with the second part. If I simply copy and paste the .odt section files to assemble the final document, making a TOC is easy. But, If I try to make an .odm master, following the instructions in LO Help, a master is created with correct formatting etc., but it is all read-only and will not allow access to make a TOC. Odm files are read only and you can not edit linked documents within master. Go back to navigator and place 'Text' item to desired position and that's the only part of master document you can edit. Place your cursor there and insert table of contents. Kruno Have tried changing the Edit Mode using Ctrl+Shift+M but this closes the file, and on re-opening it, any attempt to edit brings a pop-up saying that access is denied. A comment. This is my first serious attempt to build a User Manual in LO, we have been working in Lyx previously. Find this to be a bit like learning another language. Regards, Gordon P.S. Remy, have just received your suggestions. Many thanks On 15/09/17 22:15, Regina Henschel wrote: Hi Gordon, gordon cooper schrieb: Currently working here in Libre office 5.2.6.2 In assembling a set of .odt files from two different sources to make a user manual, am finding that the title of some files - which is Styled Heading 1 - is not being recognised by the Navigator and therefore does not appear in a TOC. If the style is changed to Heading 2 , the Navigator sees it and the TOC shows the title Have tried deleting the title and retyping it and setting style to Heading 1 but no improvement. The Navigator show paragraphs which are "true" headings and that does not depend on the name of the style. Instead go to Tools > Outline numbering and make sure that for "Level 1" the style "Heading 1" is selected. Files that have been written with LO 5.2 do show Heading 1 in the navigator, but those made with 5.3 do not. I could not see anything in the 5.3 release notes that could cause this problem. Am I missing something? If you ever have tried to use a bullet for that level [which is not possible] such error might appear. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] perplexed by password
good morning, does creation of password will disable editing of a document ? password to open file and File Sharing Password are one and same ? my queries aroused due to https://gerrit.libreoffice.org/#/c/40458/ regards, krishna -- krishna [ never ever ask about my real name or identity ] ji-bu-rish: https://github.com/kr1shna-opensource/ -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Heading 1 missing in Navigator
Hi Regina, Vielen danke, the Tools>Outline-numbering has solved part of the heading/TOC problem. I wonder if you can help with the second part. If I simply copy and paste the .odt section files to assemble the final document, making a TOC is easy. But, If I try to make an .odm master, following the instructions in LO Help, a master is created with correct formatting etc., but it is all read-only and will not allow access to make a TOC. Have tried changing the Edit Mode using Ctrl+Shift+M but this closes the file, and on re-opening it, any attempt to edit brings a pop-up saying that access is denied. A comment. This is my first serious attempt to build a User Manual in LO, we have been working in Lyx previously. Find this to be a bit like learning another language. Regards, Gordon P.S. Remy, have just received your suggestions. Many thanks On 15/09/17 22:15, Regina Henschel wrote: Hi Gordon, gordon cooper schrieb: Currently working here in Libre office 5.2.6.2 In assembling a set of .odt files from two different sources to make a user manual, am finding that the title of some files - which is Styled Heading 1 - is not being recognised by the Navigator and therefore does not appear in a TOC. If the style is changed to Heading 2 , the Navigator sees it and the TOC shows the title Have tried deleting the title and retyping it and setting style to Heading 1 but no improvement. The Navigator show paragraphs which are "true" headings and that does not depend on the name of the style. Instead go to Tools > Outline numbering and make sure that for "Level 1" the style "Heading 1" is selected. Files that have been written with LO 5.2 do show Heading 1 in the navigator, but those made with 5.3 do not. I could not see anything in the 5.3 release notes that could cause this problem. Am I missing something? If you ever have tried to use a bullet for that level [which is not possible] such error might appear. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Heading 1 missing in Navigator
Hello, Have you looked in the Tools -> Headline numbering to make sure the style that is used is Heading 1 for the top level in the merged document? It could be that merging the different documents changed that setting. If the styles listed there are not the right ones (or at least the ones you expect), the navigator and the TOC will not contain any reference to the Heading XX styles. If using the navigator is not really a must, then you can force these Heading XXs to appear in the TOC by right-clicking in the TOC, selecting Edit Index and then click "Additional Styles" in the "Create From" section. In that panel, you can assign any style to any level of TOC. I hope this helps. Rémy Gauthier. Le vendredi 15 septembre 2017 à 09:52 +1200, gordon cooper a écrit : > Currently working here in Libre office 5.2.6.2 > > In assembling a set of .odt files from two different sources to make a > user manual, > am finding that the title of some files - which is Styled Heading 1 - is > not being recognised > by the Navigator and therefore does not appear in a TOC. If the style > is changed > to Heading 2 , the Navigator sees it and the TOC shows the title Have > tried deleting > the title and retyping it and setting style to Heading 1 but no > improvement. > > Files that have been written with LO 5.2 do show Heading 1 in the > navigator, but those > made with 5.3 do not. I could not see anything in the 5.3 release notes > that could > cause this problem. Am I missing something? > > Gordon > Tauranga N.Z. > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Base query - CONCAT function
Hi Harvey, > > I have a backend Mariadb 10 which I access directly using the using the > MySQL connector. All right. With MariaDB (and MySQL) the two pipes (||) dont work. But something like SELECT CONCAT("Vorname, ' ',IFNULL("Partnervorname",' '),"Nachname") AS "Name" FROM "Table" should work. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Base query - CONCAT function
On Fri, 2017-09-15 at 19:19 +0200, Robert Großkopf wrote: > Hi Harvey, > > > > > Hi Robert, > > Thanks for answering. > > Your suggestion, however, do not work on my Opensuse Leap 42.3 / > > LibreOffice 5.3.3.2 configuration. > > > I use the Query design feature to enter > > > > "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" > > or > > > > "Nachname" || IFNULL( ', ' || "Vorname", ' ') > > > > Both above return 0 (yes, zero!) for every record. > > Only the "Partnervorname" field has NULL values. I didn't expect > > concatenation to be treated like 'multiplication', but I learn > > something new every day! Neverthless, something is not right here. > > > > However, > > COALESCE ( CONCAT( "Vorname", SUBSTR( ' & ', 1 ), "Partnervorname", > > SPACE( 1 ), "Nachname" ), CONCAT( "Vorname", SPACE( 1 ), "Nachname" > > ) ) > > > > delivers the required result. > > Which database do you use? Internal HSQLDB? My system here: OpenSUSE > 42.2, LO 5.4.1.2. Have tested all this code for the Base-Handbook, so > I > am interested why it shouldn't work for you. Must say I didn#t test > how > it would work when entering the code in GUI mode, not switching to > SQL mode. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 I have a backend Mariadb 10 which I access directly using the using the MySQL connector. Cheers Harvey > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Base query - CONCAT function
Hi Harvey, > Hi Robert, > Thanks for answering. > Your suggestion, however, do not work on my Opensuse Leap 42.3 / > LibreOffice 5.3.3.2 configuration. > > I use the Query design feature to enter > > "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" > or > > "Nachname" || IFNULL( ', ' || "Vorname", ' ') > > Both above return 0 (yes, zero!) for every record. > Only the "Partnervorname" field has NULL values. I didn't expect > concatenation to be treated like 'multiplication', but I learn > something new every day! Neverthless, something is not right here. > > However, > COALESCE ( CONCAT( "Vorname", SUBSTR( ' & ', 1 ), "Partnervorname", > SPACE( 1 ), "Nachname" ), CONCAT( "Vorname", SPACE( 1 ), "Nachname" ) ) > > delivers the required result. Which database do you use? Internal HSQLDB? My system here: OpenSUSE 42.2, LO 5.4.1.2. Have tested all this code for the Base-Handbook, so I am interested why it shouldn't work for you. Must say I didn#t test how it would work when entering the code in GUI mode, not switching to SQL mode. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Base query - CONCAT function
Hi Robert, Thanks for answering. Your suggestion, however, do not work on my Opensuse Leap 42.3 / LibreOffice 5.3.3.2 configuration. I use the Query design feature to enter "Vorname" || IFNULL( ' & ' || "Partnervorname", ' ' ) || "Nachname" or "Nachname" || IFNULL( ', ' || "Vorname", ' ') Both above return 0 (yes, zero!) for every record. Only the "Partnervorname" field has NULL values. I didn't expect concatenation to be treated like 'multiplication', but I learn something new every day! Neverthless, something is not right here. However, COALESCE ( CONCAT( "Vorname", SUBSTR( ' & ', 1 ), "Partnervorname", SPACE( 1 ), "Nachname" ), CONCAT( "Vorname", SPACE( 1 ), "Nachname" ) ) delivers the required result. Cheers Harvey On Fri, 2017-09-15 at 15:02 +0200, Robert Großkopf wrote: > Hey Harvey, > > > > > I wanted to use the CONCAT function in a Base query. However, it > > seems > > that if ONE of the elements of the list to be concatenated is NULL > > then > > the CONCAT function returns a NULL. Am I right? Is it a bug or a > > feature? > > feature, because anythin, which is connected with NULL should be > NULL. > > Do the following > > SELECT "surname"||', '||"forename" AS "name" FROM "table" > > for concatenate. You could concatenate more than two fields in this > way. > If one field is NULL all will be NULL. > > Now > > SELECT "surname"||IFNULL(', '||"forename",'') AS "name" FROM "table" > > will set '' for comma and forename if forename is NULL. Will only the > surname will be shown, if forename is NULL. > > Regards > > Robert > -- > Homepage: http://robert.familiegrosskopf.de > LibreOffice Community: http://robert.familiegrosskopf.de/map_3 > > -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Base query - CONCAT function
Hey Harvey, > I wanted to use the CONCAT function in a Base query. However, it seems > that if ONE of the elements of the list to be concatenated is NULL then > the CONCAT function returns a NULL. Am I right? Is it a bug or a > feature? feature, because anythin, which is connected with NULL should be NULL. Do the following SELECT "surname"||', '||"forename" AS "name" FROM "table" for concatenate. You could concatenate more than two fields in this way. If one field is NULL all will be NULL. Now SELECT "surname"||IFNULL(', '||"forename",'') AS "name" FROM "table" will set '' for comma and forename if forename is NULL. Will only the surname will be shown, if forename is NULL. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] LO Base Queries, Forms & Reports not appearing
Hi Noel, > I am transferring an H2 database from a Windows PC to a late model Apple > Mac, (Capitan 10.11.6). On the main Base window, the Tables are all > displaying normally, but nothing shows up under Queries, Forms or Reports. Did you create queries, forms and reports for the database in a Base-file on the Windows PC? Do you use the same Base-file on Apple now? Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Re: is anybody still experiencing crash
good evening, a small update, found that not every crash is reproducible on all os. exception: attachment 135935 on tdf#112163 http://tinyurl.com/y8b3bvql regards, krishna On September 14, 2017 1:51:39 PM GMT+05:30, krishna wrote: >good afternoon, > >is anybody still experiencing crash ON libreoffice daily viewer daily >build > >attachment 135894 on tdf#112123 > >attachment 135865 on tdf#112101 > >attachment 135893 on tdf#112122 > >attachment 135937 on tdf#112164 > >attachment 135935 on tdf#112163 > >regards, >krishna > > > >- > >krishna [ never ever ask about my real name or identity ] > >ji-bu-rish: https://github.com/kr1shna-opensource/ - krishna [ never ever ask about my real name or identity ] ji-bu-rish: https://github.com/kr1shna-opensource/ -- To unsubscribe e-mail to: users+unsubscr...@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
[libreoffice-users] Base query - CONCAT function
I wanted to use the CONCAT function in a Base query. However, it seems that if ONE of the elements of the list to be concatenated is NULL then the CONCAT function returns a NULL. Am I right? Is it a bug or a feature? Kind Regards Harvey Nimmo -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Heading 1 missing in Navigator
Hi Gordon, gordon cooper schrieb: Currently working here in Libre office 5.2.6.2 In assembling a set of .odt files from two different sources to make a user manual, am finding that the title of some files - which is Styled Heading 1 - is not being recognised by the Navigator and therefore does not appear in a TOC. If the style is changed to Heading 2 , the Navigator sees it and the TOC shows the title Have tried deleting the title and retyping it and setting style to Heading 1 but no improvement. The Navigator show paragraphs which are "true" headings and that does not depend on the name of the style. Instead go to Tools > Outline numbering and make sure that for "Level 1" the style "Heading 1" is selected. Files that have been written with LO 5.2 do show Heading 1 in the navigator, but those made with 5.3 do not. I could not see anything in the 5.3 release notes that could cause this problem. Am I missing something? If you ever have tried to use a bullet for that level [which is not possible] such error might appear. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@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
Re: [libreoffice-users] Heading 1 missing in Navigator
hello. some problems are resolved in relation to heading in xhtml format. you can test 5.3.4 and see if the bug fixed resolved your issue or not? if the problem is still persists, you can report in bugzilla, first you need to register your account. www.bugs.libreoffice.org hope that help, God bless you! On 9/15/17, gordon cooper wrote: > Currently working here in Libre office 5.2.6.2 > > In assembling a set of .odt files from two different sources to make a > user manual, > am finding that the title of some files - which is Styled Heading 1 - is > not being recognised > by the Navigator and therefore does not appear in a TOC. If the style > is changed > to Heading 2 , the Navigator sees it and the TOC shows the title Have > tried deleting > the title and retyping it and setting style to Heading 1 but no > improvement. > > Files that have been written with LO 5.2 do show Heading 1 in the > navigator, but those > made with 5.3 do not. I could not see anything in the 5.3 release notes > that could > cause this problem. Am I missing something? > > Gordon > Tauranga N.Z. > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- we have not sent you but as a mercy to the creation. holy quran, chapter 21, verse 107. in the very authentic narration is: imam hosein is the beacon of light and the ark of salvation. best website for studying islamic book in different languages al-islam.org -- To unsubscribe e-mail to: users+unsubscr...@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