Re: [libreoffice-users] Heading 1 missing in Navigator

[Krunose]

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

[krishna]

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

[gordon cooper]

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

[Remy Gauthier]

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

[Robert Großkopf]

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

[Harvey Nimmo]

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

[Robert Großkopf]

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

[Harvey Nimmo]

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

[Robert Großkopf]

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

[Robert Großkopf]

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

[krishna]

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

[Harvey Nimmo]

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

[Regina Henschel]

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

[zahra a]

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

[libreoffice-users] Re: LO Base Queries, Forms & Reports not appearing

[Alexander Thurgood]

Le 15/09/2017 à 04:36, Marion & Noel Lodge a écrit :

Hi Noel,

I don't know of any particular configuration setting that might cause
this, unless there is something physically wrong with the file itself.

Some possibilities to explore :

- if you have automatic document backups (AutoSave) configured on the
Mac LO, turn that off, restart LO and see if it makes a difference.
There is/was a known bug that affected the display of some ODB files
when this option was activated ;

- compare the files on both OSes to check that they are identical (in
structure and content) by unzipping each one ;

- when you create a query in H2 via LO, is it stored within the H2
database schema, for which the LO ODB would merely contain a reference
(with a file path, which would be different between Win/Mac)  OR is the
query stored within the LO ODB in full SQL ?


The fact that you can't see any of the Queries, Reports, Forms, might
indicate a problem with the paths in the XML sections of the ODB file
that defines each of these.


Alex



-- 
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