Re: [libreoffice-users] Libre Office for Androids

[jorge]

Hi Charles and all:

Until I know, LO for Android is in progress but at this moment as a
viewer only and Alpha or begining Beta version (not stable) for LO as we
use in GNU / Linux and windows.

There is an other version that could help you and your friend: This is
Aoo (Android OpenOffice). It is a version of OpenOffice for Android.
I've used it and it works good (In general as I probed: Writer, and
Calc). It is the nearest of LO at this moment that I know.

As I read, Aoo is based on OpenOffice but is not part of Apache
Fundation.

I suggest to your friend that use keyboard and mouse with your tablet
too.

Regards,

Jorge Rodríguez


El jue, 05-05-2016 a las 20:52 -0400, charles meyer escribió:
> Hi All,
> 
> I Googled for Libre Office for Androids to help a friend use LO on her
> Android tablet.
> 
> I found this...
> 
> https://www.libreoffice.org/download/android-viewer/
> 
> Anyone on the list using LO for Androids?
> 
> Does it come bundled with Libre Writer and Calc?
> 
> Thank you,
> 
> Charles.
> 

-- 
Atentamente,

Jorge Rodríguez


-- 
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] Libre Office for Androids

[charles meyer]

Hi All,

I Googled for Libre Office for Androids to help a friend use LO on her
Android tablet.

I found this...

https://www.libreoffice.org/download/android-viewer/

Anyone on the list using LO for Androids?

Does it come bundled with Libre Writer and Calc?

Thank you,

Charles.

-- 
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] Calc HH:MM:SS to decimal

[Michael D. Setzer II]

Think this is what you want.

=ROUND(A1/TIME(1,0,0)*4,0)/4

On 5 May 2016 at 12:44, Russell wrote:

To: users@global.libreoffice.org
From:   Russell 
Subject:[libreoffice-users] Calc HH:MM:SS to decimal
Date sent:  Thu, 5 May 2016 12:44:59 -0400

> does anyone know if there is a formula for a cell that will transform 
> the HH:mm:ss from another cell into a decimal equivalent?
> 
> example:
> 
> Cell A1 has 10:45:20
> 
> Cell A2 would change to 10.75
> 
> or
> 
> Cell A1 07:26:15
> 
> Cell A2 would change to 7.44 (or round it up 7.5)
> 
> Thanks
> 
> Russell
> 
> 
> 
> -- 
> 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



-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Robert Funnell]

On Thu, 5 May 2016, Piet van Oostrum wrote:


Robert Funnell wrote:

> Felipe -
>
> The hidden text being discussed here is described at
> https://help.libreoffice.org/Writer/Hiding_Text
> That doesn't seem to be what you're talking about?
>
> - Robert
>
That is missing one important case, that I think we were talking about.

It is normal text, that has been formatted with
Format > Character > Font Effects > Hidden.


OK, now I know there are two ways of hiding text :-) Thank you.



--
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Piet van Oostrum]

Walther Koehler wrote:

 > I posted the tag, which I think is the relevant, before:
 > > >>> blabla
 > I assume "P2" refers to printable, suppressing output on paper.
 > if you have a simple command line

No, "P2" is just a name, it could be anything. You would have to look up the 
style definition of "P2" and see if it has a text:display="none" in it. And 
there can be more than one of these styles, depending on the other character 
attributes, like font, size or color.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Piet van Oostrum]

Robert Funnell wrote:

 > Felipe -
 > 
 > The hidden text being discussed here is described at 
 > https://help.libreoffice.org/Writer/Hiding_Text
 > That doesn't seem to be what you're talking about?
 > 
 > - Robert
 > 
That is missing one important case, that I think we were talking about.

It is normal text, that has been formatted with 
Format > Character > Font Effects > Hidden.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Walther Koehler]

Hallo,

look at your *.txt file: the previously hidden formated text appears as plain 
string.

enjoy LO

Am Donnerstag, 5. Mai 2016 schrieb Luuk:
> On 03-05-16 19:13, Walther Koehler wrote:
> > Hallo,
> >
> > Am Dienstag, 3. Mai 2016 schrieb Bruce Hohl:
> >>> Do you have some advice how to remove the hidden (hard-)formatted text
> >>> in
> >>
> >> a
> >>
> >>> simple way?
> >>
> >> File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding
> >> (.txt) Thus, LO can be used to read, create and edit unformatted text
> >> files.
> >
> > Yes, you are right, but it does not solve my problem. The text file will
> > contain the hidden formated text.
> >
> > To make it very clear:
> > I do not care about the format information in the file.
> > I do not want the content (the hidden formated characters) in the file
> > before shipping.
>
> Are you saying that there are still 'hidden formated text' things in the
> textfile that is created when one does do 'File/SaveAs/.txt' ??
>
> ?



-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt

[Walther Koehler]

Hi Piet,

your makro is ingenious, short and effective, it does the job, than you very 
much, I am happy.

Walther

Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
> Walther Koehler wrote:
>  > Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
>  > > Walther Koehler wrote:
>  > >  > Thank you.
>  > >  > Your procedure is principally what I need.
>  > >  > However, quite complicated for routine work.
>  > >  >
>  > >  > Walther
>  > >
>  > > The first part (replacing hidden text with colored text) could be done
>  > > with a script.
>  >
>  > yes, and the whole procedure could be packed in a basic makro.
>  > The script can be called by a shell command within a makro, the replace
>  > functions realized with dispatcher commands.
>  >
>  > Let us try it.
>  >
>  > Walther
>
> Even simpler:
>
> Here is a Basic macro that just walks through the document, and deletes all
> hidden text. No unzipping, editing, etc. It just works inside the ODT
> document in LO.
>
> It only considers normal plain text, i.e. not inside tables, sections,
> frames, footnotes, etc. If you want that, these have to be specially coded.
>
> REM  *  BASIC  *
>
> Sub Main
>
> Dim oEnum   'com.sun.star.container.XEnumerationAccess
> Dim oPar
> Dim oSecEnum'com.sun.star.container.XEnumerationAccess
> Dim oParSection
>
> oEnum = ThisComponent.Text.createEnumeration()
> Do While oEnum.hasMoreElements()
>   oPar = oEnum.nextElement()
>   If oPar.supportsService("com.sun.star.text.Paragraph") Then
>   oSecEnum = oPar.createEnumeration()
>   Do While oSecEnum.hasMoreElements()
>   oParSection = 
> oSecEnum.nextElement()
>   If oParSection.TextPortionType 
> = "Text" AND oParSection.CharHidden
> Then oParSection.setString("")
>   End If
>   Loop
>
>   End If
> Loop
>
> End Sub
> --
> Piet van Oostrum 
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]



-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt

[Walther Koehler]

Hi Piet,

superb, a makro! I will try it later on.

Walther

Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
> Walther Koehler wrote:
>  > Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
>  > > Walther Koehler wrote:
>  > >  > Thank you.
>  > >  > Your procedure is principally what I need.
>  > >  > However, quite complicated for routine work.
>  > >  >
>  > >  > Walther
>  > >
>  > > The first part (replacing hidden text with colored text) could be done
>  > > with a script.
>  >
>  > yes, and the whole procedure could be packed in a basic makro.
>  > The script can be called by a shell command within a makro, the replace
>  > functions realized with dispatcher commands.
>  >
>  > Let us try it.
>  >
>  > Walther
>
> Even simpler:
>
> Here is a Basic macro that just walks through the document, and deletes all
> hidden text. No unzipping, editing, etc. It just works inside the ODT
> document in LO.
>
> It only considers normal plain text, i.e. not inside tables, sections,
> frames, footnotes, etc. If you want that, these have to be specially coded.
>
> REM  *  BASIC  *
>
> Sub Main
>
> Dim oEnum   'com.sun.star.container.XEnumerationAccess
> Dim oPar
> Dim oSecEnum'com.sun.star.container.XEnumerationAccess
> Dim oParSection
>
> oEnum = ThisComponent.Text.createEnumeration()
> Do While oEnum.hasMoreElements()
>   oPar = oEnum.nextElement()
>   If oPar.supportsService("com.sun.star.text.Paragraph") Then
>   oSecEnum = oPar.createEnumeration()
>   Do While oSecEnum.hasMoreElements()
>   oParSection = 
> oSecEnum.nextElement()
>   If oParSection.TextPortionType 
> = "Text" AND oParSection.CharHidden
> Then oParSection.setString("")
>   End If
>   Loop
>
>   End If
> Loop
>
> End Sub
> --
> Piet van Oostrum 
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]



-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Walther Koehler]

Am Mittwoch, 4. Mai 2016 schrieben Sie:
> Does this sound like a workable approach if you were familiar with
> Emacs? If you were able to identify exactly what needs to be removed
> from content.xml, and sent me a fragment of a file to illustrate it, I
> might be able to specify a sequence of commands that you could use.

I posted the tag, which I think is the relevant, before:
> >>> blabla
I assume "P2" refers to printable, suppressing output on paper.
if you have a simple command line
>
> On Tue, 3 May 2016, Walther Koehler wrote:
> > Hi Robert
> >
> > Am Dienstag, 3. Mai 2016 schrieb Robert Funnell:
> >> Walther -
> >>
> >> Could you open your content.xml with Emacs and record a macro to
> >> find and remove the hidden text? (I'm not sure that qualifies as
> >> simple.)
> >
> > Unfortunately, I am not used to emacs, although I know it is a very
> > powerful editor.
> >
> > Walther
> >
> >> - Robert
> >>
> >> On Tue, 3 May 2016, Walther Koehler wrote:
> >>> Hallo,
> >>>
> >>> Am Dienstag, 3. Mai 2016 schrieb Bruce Hohl:
> > Do you have some advice how to remove the hidden (hard-)formatted
> > text in
> 
>  a
> 
> > simple way?
> 
>  File > Save :: Save as type = Text (.txt) OR Text - Choose Encoding
>  (.txt) Thus, LO can be used to read, create and edit unformatted text
>  files.
> >>>
> >>> Yes, you are right, but it does not solve my problem. The text file
> >>> will contain the hidden formated text.
> >>>
> >>> To make it very clear:
> >>> I do not care about the format information in the file.
> >>> I do not want the content (the hidden formated characters) in the file
> >>> before shipping.
> >>>
> >>> Using linux, the command line program xpath might do the job. It is
> >>> capable of removing certain xml tags in a file like
> >>>
> >>> blabla
> >>>
> >>> Regards
> >>>
> >>> Walther
> >>>
> >>> ...
> >>>
> >> From: Walther Koehler 
> >> Date: Fri, Apr 29, 2016 at 5:54 AM
> >> Subject: [libreoffice-users] delete hidden formated text in odt
> >> To: users@global.libreoffice.org
> >>
> >>
> >> Dear LO users,
> >>
> >> I would like to give away *.odt files without hidden formated text.
> >> Do you have some advice how to remove the hidden (hard-)formatted
> >> text
> >
> > in a
> >
> >> simple way?
> >> Is it possible by a macro?
> >>
> >> (I am aware that you can make hidden text invisible and print the
> >> file without
> >> hidden text on paper. I also know how to remove properties)
> >>
> >> Thank you in advance
> >>
> >> Walther



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

Fwd: Re: free text editor (was: [libreoffice-users] delete hidden formated text in odt

[Walther Koehler]

Hi Piet,

because your makro left over empty paragraph marks I added a few lines.

Walther

--  Weitergeleitete Nachricht  --

Subject: Re: free text editor (was: [libreoffice-users] delete hidden formated 
text in odt
Date: Donnerstag, 5. Mai 2016
From: Walther Koehler 
To: Piet van Oostrum 

Hi Piet,

superb, a makro! I will try it later on.

Walther

Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
> Walther Koehler wrote:
>  > Am Mittwoch, 4. Mai 2016 schrieb Piet van Oostrum:
>  > > Walther Koehler wrote:
>  > >  > Thank you.
>  > >  > Your procedure is principally what I need.
>  > >  > However, quite complicated for routine work.
>  > >  >
>  > >  > Walther
>  > >
>  > > The first part (replacing hidden text with colored text) could be done
>  > > with a script.
>  >
>  > yes, and the whole procedure could be packed in a basic makro.
>  > The script can be called by a shell command within a makro, the replace
>  > functions realized with dispatcher commands.
>  >
>  > Let us try it.
>  >
>  > Walther
>
> Even simpler:
>
> Here is a Basic macro that just walks through the document, and deletes all
> hidden text. No unzipping, editing, etc. It just works inside the ODT
> document in LO.
>
> It only considers normal plain text, i.e. not inside tables, sections,
> frames, footnotes, etc. If you want that, these have to be specially coded.
>
> REM  *  BASIC  *
>
> Sub Main
>
> Dim oEnum   'com.sun.star.container.XEnumerationAccess
> Dim oPar
> Dim oSecEnum'com.sun.star.container.XEnumerationAccess
> Dim oParSection
>
> oEnum = ThisComponent.Text.createEnumeration()
> oTxt=ThisComponent.Text
> Do While oEnum.hasMoreElements() 
>   oPar = oEnum.nextElement()
>   If oPar.supportsService("com.sun.star.text.Paragraph") Then
>   oSecEnum = oPar.createEnumeration()
>   flag=0
>   Do While oSecEnum.hasMoreElements() 
>   oParSection = 
> oSecEnum.nextElement()
>   If oParSection.TextPortionType 
> = "Text" AND oParSection.CharHidden  
Then
>   oParSection.setString("")
>   else
>flag=1
>   End If 
>   Loop
>   if flag=0 then oTxt.removeTextContent(oPar)
>   End If
> Loop
>
> End Sub
> --
> Piet van Oostrum 
> WWW: http://pietvanoostrum.com/
> PGP key: [8DAE142BE17999C4]



---

-- 
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] APA Heading 3 that does not use paragraph style

[Marc Grober]

ROFL... Yes, Robert, that addresses the problem and the developer
deserves props for macro-izing it, lol  Thanks.
But it is not a satisfactory solution to what is a very mundane problem.

I have gone ahead and created a feature request in bugzilla
(https://bugs.documentfoundation.org/show_bug.cgi?id=99695) and ask that
anyone interested CC themselves and add confirmation/comment as
appropriate so we can get this assigned as I am thinking it should not
be a major problem in resolving the gap.



On 5/5/16 11:42 AM, Robert Funnell wrote:
> Marc -
>
> Does this link help?
> https://forum.openoffice.org/en/forum/viewtopic.php?f=71=709
>
> - Robert
>
> On Thu, 5 May 2016, Marc Grober wrote:
>
>> I have worked through quite a few templates, and have found that address
>> this problem  :-(
>>
>> On 5/5/16 11:14 AM, John Jason Jordan wrote:
>>> On Thu, 5 May 2016 06:48:54 -0800
>>> Marc Grober  dijo:
>>>
 The APA Publication Manual (Section 3.03, Pg 62) mandates a Heading 3
 style that that is bold and indented (1/2 an inch like a normal
 paragraph), and then followed on the same line by the text.
>>> I believe there is a template for APA. Don't ask me where to find it,
>>> however. And I don't know if it will solve your problem.
>>>



-- 
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] APA Heading 3 that does not use paragraph style

[Robert Funnell]

Marc -

Does this link help?
https://forum.openoffice.org/en/forum/viewtopic.php?f=71=709

- Robert

On Thu, 5 May 2016, Marc Grober wrote:


I have worked through quite a few templates, and have found that address
this problem  :-(

On 5/5/16 11:14 AM, John Jason Jordan wrote:

On Thu, 5 May 2016 06:48:54 -0800
Marc Grober  dijo:


The APA Publication Manual (Section 3.03, Pg 62) mandates a Heading 3
style that that is bold and indented (1/2 an inch like a normal
paragraph), and then followed on the same line by the text.

I believe there is a template for APA. Don't ask me where to find it,
however. And I don't know if it will solve your problem.



--
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] APA Heading 3 that does not use paragraph style

[Marc Grober]

I have worked through quite a few templates, and have found that address
this problem  :-(

On 5/5/16 11:14 AM, John Jason Jordan wrote:
> On Thu, 5 May 2016 06:48:54 -0800
> Marc Grober  dijo:
>
>> The APA Publication Manual (Section 3.03, Pg 62) mandates a Heading 3
>> style that that is bold and indented (1/2 an inch like a normal
>> paragraph), and then followed on the same line by the text.
> I believe there is a template for APA. Don't ask me where to find it,
> however. And I don't know if it will solve your problem. 
>



-- 
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] APA Heading 3 that does not use paragraph style

[John Jason Jordan]

On Thu, 5 May 2016 06:48:54 -0800
Marc Grober  dijo:

>The APA Publication Manual (Section 3.03, Pg 62) mandates a Heading 3
>style that that is bold and indented (1/2 an inch like a normal
>paragraph), and then followed on the same line by the text.

I believe there is a template for APA. Don't ask me where to find it,
however. And I don't know if it will solve your problem. 

-- 
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Robert Funnell]

Felipe -

The hidden text being discussed here is described at 
https://help.libreoffice.org/Writer/Hiding_Text

That doesn't seem to be what you're talking about?

- Robert

On Thu, 5 May 2016, Felipe T. Dorado wrote:


Hello Luuk  : )

On Thu, 5 May 2016 13:18:23 +0200, Luuk wrote:

L> On 05-05-16 11:12, Piet van Oostrum wrote:

L> > Save as .txt des save all text, including hidden text. Just try it out.

I have, Piet.

L> I think i have a different meaning of 'hidden text', than the average 
L> reader here  :-)


It would seem so.
Re-inventing the wheel isn't either smart nor efficient:

I wrote a file containing just:

"This an ODT file written in LibreOffice 5.1.
"

I saved it in LO native format: an_odt_file.odt
Then I saved it as text (plain, flat, ascii):   an_odt_file.txt

I listed the directory where I saved them and:

bytes   datefile
8628may  5 20:07an_odt_file.odt
49  may  5 20:07an_odt_file.txt

I opened the txt file with various text editors (nano, leafpad, gedit,
even notepad through wine) and have not been able to find any "hidden
text" ...  Just 49 bytes including spaces and Line Feed.
What do people understand by "hidden text"? The coding put there
by a word processor?
Saving a file as text is just that: saving it as text  (plain, flat, ascii)
with nothing else.

M$Win seems to produce strange things in how some users conceive files:
macros, scripts, programs, etc. just to strip the good old codes WordStar,
WordPerfect and many others  nowadays simply _hide away_ so the user cannot
see them. But they are there, doing their tasks.

Text is text. Just like this I've just written is text and nothing more.

Felipe  : )


--
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Felipe T. Dorado]

Hello Luuk  : )

On Thu, 5 May 2016 13:18:23 +0200, Luuk wrote:

L> On 05-05-16 11:12, Piet van Oostrum wrote:

L> > Save as .txt des save all text, including hidden text. Just try it out.

I have, Piet.
 
L> I think i have a different meaning of 'hidden text', than the average 
L> reader here  :-)

It would seem so.
Re-inventing the wheel isn't either smart nor efficient:

I wrote a file containing just:

"This an ODT file written in LibreOffice 5.1.
"

I saved it in LO native format: an_odt_file.odt
Then I saved it as text (plain, flat, ascii):   an_odt_file.txt

I listed the directory where I saved them and:

bytes   datefile
8628may  5 20:07an_odt_file.odt
49  may  5 20:07an_odt_file.txt
 
I opened the txt file with various text editors (nano, leafpad, gedit,
even notepad through wine) and have not been able to find any "hidden
text" ...  Just 49 bytes including spaces and Line Feed.
What do people understand by "hidden text"? The coding put there
by a word processor?
Saving a file as text is just that: saving it as text  (plain, flat, ascii)
with nothing else.

M$Win seems to produce strange things in how some users conceive files:
macros, scripts, programs, etc. just to strip the good old codes WordStar,
WordPerfect and many others  nowadays simply _hide away_ so the user cannot
see them. But they are there, doing their tasks.

Text is text. Just like this I've just written is text and nothing more.

Felipe  : )

-- 
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] Re: configure external image editor

[Felipe T. Dorado]

Hola Pedro  : )

On Mon, 2 May 2016 06:46:00 -0700 (MST), Pedro escribió:

P> Apparently LibreOffice simply opens the image with the program
P> associated to the image type (could be png, jpg, etc) on your user
P> preferences (at the OS level)
P> This means that the menu option is not clear.

Yeap.
 
P> In fact the current "Edit with External Tool..." option seems like an
P> incomplete work. Even if you do Edit the image with the external program,
P> you will have to reinsert the edited image manually because simply
P> closing the external editor will not do that (as seems to be implied by
P> the menu option).

So it seems, yes.


P> Therefore you have two options: you could consider this a Bug and request
P> the menu option to be renamed to the more accurate text "Open with
P> associated external program" OR you could do an Enhancement Request and
P> ask the developers to add an option to LibreOffice where the user
P> defines the path to an external editor (e.g. Gimp) which is actually
P> used for editing.

Since I found the option in the menu this second behaviour is what one would
expect. I think however that it would somehow bloat the program with
something not really needed: much simpler is advising the user to prepare
the image before inserting it in the doc.

So after looking up the possible bug report in bugzilla,  finding
https://ask.libreoffice.org/en/question/11669/how-to-set-image-external-editor/
I followed your advice and added a comment to
https://bugs.documentfoundation.org/show_bug.cgi?id=51096
which is already almost 4 years old ...

P> Of course the second option involves a lot more work because it not only
P> requires to add that option to the Options dialog but would also require
P> that after editing the image, the modified image would be updated in the
P> document...

Yes, and it would result in bloating.

P> Curiously having an "Edit with External Tool..." option would seem that
P> there should be an Edit option (where LibreOffice's own Draw would used
P> as the logical Internal Tool)

It's the reasonable thing to do.

P> Maybe in the future?

Thanks a  lot, Pedro.
Gracias, Pedro.

Felipe  : )

-- 
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] Calc HH:MM:SS to decimal

[Luuk]

On 05-05-16 18:52, Bruce Hohl wrote:

Try this in cell A2 "=VALUE(A1)*24"

On Thu, May 5, 2016 at 12:44 PM, Russell  wrote:


does anyone know if there is a formula for a cell that will transform the
HH:mm:ss from another cell into a decimal equivalent?

example:

Cell A1 has 10:45:20

Cell A2 would change to 10.75

or

Cell A1 07:26:15

Cell A2 would change to 7.44 (or round it up 7.5)

Thanks

Russell




see (for more info) point 4 of "[Tutorial] Ten concepts that every Calc 
user should know 
"

( https://forum.openoffice.org/en/forum/viewtopic.php?t=39529 )

4. Times in cells
A cell can contain a clock time, but the time is really stored as the 
corresponding fraction of a day. For example 6 AM is stored as 0.25 
because it is ¼ of the way from midnight to midnight, but it is 
displayed as 6:00:00 AM. You can use Format → Cells → Numbers → Category 
→ Time to display clock times in many formats, for example H:MM or HH:MM 
or HH:MM:SS, and any of these can have an optional AM/PM if you don't 
want to use 24-hour (military) time. A cell can contain both a date and 
a time. The value in the cell is the sum of the integer for the date and 
the fraction for the time. Format date/time cells by combining a date 
format and a clock time format. For cells which represent durations 
(difference of two clock times), the value could be more than one day, 
that is larger than 1, or even negative. The previously mentioned clock 
time formats display only the positive fraction; Calc adds or subtracts 
whole days until the time is between 00:00:00 and 23:59:59. To display a 
duration which exceeds 24 hours or is negative, you must enter the first 
part of the time format in brackets in the Format code field: [HH]:MM:SS 
or [HH]:MM or [HH] or [MM]:SS or [MM] or [SS]. There is no cell format 
which displays durations as days with hours/minutes/seconds. Be sure to 
remove the AM/PM format code from duration cells since they don't 
represent clock times, and always use one of the bracketed formats.




--
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] Calc HH:MM:SS to decimal

[Bruce Hohl]

Try this in cell A2 "=VALUE(A1)*24"

On Thu, May 5, 2016 at 12:44 PM, Russell  wrote:

> does anyone know if there is a formula for a cell that will transform the
> HH:mm:ss from another cell into a decimal equivalent?
>
> example:
>
> Cell A1 has 10:45:20
>
> Cell A2 would change to 10.75
>
> or
>
> Cell A1 07:26:15
>
> Cell A2 would change to 7.44 (or round it up 7.5)
>
> Thanks
>
> Russell
>
>
>
> --
> 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
>

-- 
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] Calc HH:MM:SS to decimal

[Russell]

does anyone know if there is a formula for a cell that will transform 
the HH:mm:ss from another cell into a decimal equivalent?


example:

Cell A1 has 10:45:20

Cell A2 would change to 10.75

or

Cell A1 07:26:15

Cell A2 would change to 7.44 (or round it up 7.5)

Thanks

Russell



--
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] Digital Signatures

[Marc Grober]

Does your certificate path point to your default profile?
What versions of OS, LO, FF are you using?

On 5/5/16 4:52 AM, Jack Wallen wrote:
> Hello everyone!
>
> So I've been trying to work out the whole digital signature mess on
> LibreOffice. I created a self-signed digital signature using gpg and
> imported it into both Firefox and Thunderbird. No matter what I do,
> LibreOffice cannot see the certificate. Is there something I'm missing
> here? Will LibreOffice not work with self-signed CAs? I've googled
> this and have yet to come up with a solution.
>
> Thank you for any help you can offer.
>
> Jack
>



-- 
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] APA Heading 3 that does not use paragraph style

[Marc Grober]

The APA Publication Manual (Section 3.03, Pg 62) mandates a Heading 3
style that that is bold and indented (1/2 an inch like a normal
paragraph), and then followed on the same line by the text.

That means one cannot use a paragraph style, as the paragraph needs to
actually be normal body text (Default in most cases).  If  one uses a
generated ToC, then the text that is style with the Heading styles is
used in the ToC, so you don;t want a paragraph that looks like normal
but for which you bold the first bit.

Seems to me there was a way to style text as a heading level
(specifically for ToC purposes), without making it a paragraph style, 
but I can't recall how that was done.



-- 
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] on Recovery

[Xen]

One year ago Calligra had a feature (and probably still has) of 
presenting a same kind of recovery dialog to the user.


I couldn't tell in advance what was in the recovery and what was in the 
source.


I pressed open without recovering.

I realized I had lost changes.

The recovery file had already been deleted.

This is Russian Roulette, this is a Casino.

You have to make a blind guess what's gonna be what, and if you press 
the wrong button, you're fucked.


I mean please everyone, change this system. Whatever software you have 
or are working on, change this system that seems to be pervasive across 
open source apps.


Don't recover files that are identical. Perform a diff for fucks sake.

Do just anything that makes it better, please. But if you tell the 
vim crowd, they will laugh you in your face, and maybe this happens here 
too, I don't know.


Also wanted to say that I think the mailing list overview page of 
LibreOffice is just outstanding. I absolutely love the colour (green) 
and the layout and visual design of the page (body) is just beyond 
excellent. I don't much like the monochrome looking logo (Reminds me of 
Breeze, and pretty much everyone hates it) and the top bar could be 
better too, but the entire body of the page including the footers and 
all is just amazingly done. The only thing that would ever need changing 
would be the top bar. Doesn't quite entirely agree with it. Anyway.


I guess this is a statement about the entire website and I am not 
writing to the design team but absolute kudos for this visual appearance 
and the great ease with which to find information and to subscribe.


Regards,

Bart.


Xen schreef op 05-05-2016 14:43:



--
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] Digital Signatures

[Jack Wallen]

Hello everyone!

So I've been trying to work out the whole digital signature mess on 
LibreOffice. I created a self-signed digital signature using gpg and 
imported it into both Firefox and Thunderbird. No matter what I do, 
LibreOffice cannot see the certificate. Is there something I'm missing 
here? Will LibreOffice not work with self-signed CAs? I've googled this 
and have yet to come up with a solution.


Thank you for any help you can offer.

Jack

--
*Jack Wallen*
Award winning author of dark, twisty fiction,
tech writer, podcaster, and audiobook narrator
Find out more on Get Jack'd 

--
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] on Recovery

[Xen]

In OpenOffice, the two downright most annoying features were to me:

1. Having to put in credentials for being saved to a document.

This is gone from LibreOffice, thanks god.

2. Recovery.

The recovery feature is pretty much useless and downright annoying.

I have a system that currently crashes often, so every time I open my 
document, it gets recovered.



First of all the choice of needing to recover presented to the user 
before he/she can see the document, is just silly.


The program "vim" has the same. Out of the million times the recovery 
thing was presented to me, the only times when I lost data was when I 
recovered something that I had already written to and the recovery was 
actually older, from my perspective. Yes I did lose text, no matter how 
little it was in that instance.


There is no point to recovering if you don't know what's in it. The 
least you could do is to tell a person what has changed between 
versions, but:


I really wanted to call this stupid. It is just downright stupid.

It has existed for as long as I can remember and it is just equally as 
stupid still.


It is still equally as stupid. Just stupid, stupid , stupid.

Putting an extra space in there on purpose. Cause I'm stupid too. So we 
can both be stupid now. ;-).




There's no point to this recovery system. The last time it started to 
recover, it then couldn't find the recovery file (in ~/.config/) and 
then said it had recovered successfully. Well, how good you are!


It is an unnecessary step and only frustrates. It does not even check 
whether the files have changed. Most of the times there are no changes 
because my system doesn't crash unless I do something to it (usually) 
and I have my changes saved.


Vim also tries to recover files that haven't changed (because I never 
even entered edit mode) and the only lesson you learn from it is to 
always press delete. This is not about Vim, it is about LibreOffice, but 
I am stupid.


If I could press delete on LibreOffice too, I would do it. Not the 
entire program this time, only the recovery file that makes no sense and 
90% of the time I will know it makes no sense to begin with.


But you are forced to go through these unnecessary steps. And maybe you 
can turn it off, fine, I'm sure you can.


But it serves no purpose to anyone really. It would even be better if it 
just created backups in the same directory upon each save and just used 
that or offered that or by ill chance just inform the user of that if 
you have nothing better.


Even a dropdown that said "view changes" would be better. Even a dialog 
checking changes if it wants to recover at all, would be better. 
Anything you imagine would probably be better including throwing the 
source document away but having a backup of it that you can load.


Yes, even automatic recovery without the annoying dialog would be 
better.


I mean it is just an opinion here. But OpenOffice has existed since at 
least 2000 from my memory, and it has *always* bugged the hell out of 
me.


And there is still no point to that system. None at all.

--
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Luuk]

On 05-05-16 11:12, Piet van Oostrum wrote:

Luuk wrote:
  >
  > Are you saying that there are still 'hidden formated text' things in the
  > textfile that is created when one does do 'File/SaveAs/.txt' ??
  >
Save as .txt des save all text, including hidden text. Just try it out.


I think i have a different meaning of 'hidden text', than the average 
reader here  :-)


--
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: free text editor (was: [libreoffice-users] delete hidden formated text in odt)

[Piet van Oostrum]

Luuk wrote:
 > 
 > Are you saying that there are still 'hidden formated text' things in the 
 > textfile that is created when one does do 'File/SaveAs/.txt' ??
 > 
Save as .txt des save all text, including hidden text. Just try it out.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


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