Re: [libreoffice-users] Question about charts

[Remy Gauthier]

Hello,
It is not possible to see images on this list. If you e-mail me the
image directly, I will see if I can help you.
Regards,
Rémy.
Le mardi 19 mars 2024 à 23:07 -0300, Enzo Hirosse a écrit :
> Hello! I was using LibreOffice Writer and got stuck in a problem
> while
> using the charts, I don't understand how the percentage works when
> determining the values of the columns, everytime I set a value it
> displays
> a 100%, despite the total value of the Y axis, just like in the
> example
> below. Is there a way to change these percentages? so it shows the
> actual
> percentage comparing the value (ex. 9) to the total of the whole
> chart
> (ex.10)
> [image: image.png]
> 


-- 
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] Question about charts

[Enzo Hirosse]

Hello! I was using LibreOffice Writer and got stuck in a problem while
using the charts, I don't understand how the percentage works when
determining the values of the columns, everytime I set a value it displays
a 100%, despite the total value of the Y axis, just like in the example
below. Is there a way to change these percentages? so it shows the actual
percentage comparing the value (ex. 9) to the total of the whole chart
(ex.10)
[image: image.png]

-- 
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] Question about LibreOffice Calc 7.4.7 and hidden columns

[Tom]

On 8/18/23 6:47 PM, Mike Flannigan wrote:


Hiding and unhiding columns or rows anywhere on the spreadsheet
works fine with my Calc 6.4.7.2 on Linux Mint, even with "Freeze
rows and columns" in effect.  So I would say you found a bug.



Thanks for checking!

Peace...

Tom




On 8/14/23 13:08, users+h...@global.libreoffice.org wrote:

Hi!  My dad just contacted me about a problem he had with a 
spreadsheet with some hidden rows and columns.  He's running Calc 
7.4.7 on Windows 11.  Anyway, when he attempts to unhide some hidden 
columns, they won't unhide. He sent the spreadsheet to me and I found 
out the columns wouldn't unhide due to being "frozen".  By 
un-selecting "Freeze rows and columns", I was able to get the columns 
to appear.  I passed that information on to him and he was able to do 
the same.


Question:  should frozen columns be able to be hidden/shown when frozen?

He has since upgraded to LibreOffice 7.5.5.2.

Thanks in advance!

Peace...

Tom





--
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] Question about LibreOffice Calc 7.4.7 and hidden columns

[Mike Flannigan]

Hiding and unhiding columns or rows anywhere on the spreadsheet
works fine with my Calc 6.4.7.2 on Linux Mint, even with "Freeze
rows and columns" in effect.  So I would say you found a bug.


Mike


On 8/14/23 13:08, users+h...@global.libreoffice.org wrote:

Hi!  My dad just contacted me about a problem he had with a 
spreadsheet with some hidden rows and columns.  He's running Calc 
7.4.7 on Windows 11.  Anyway, when he attempts to unhide some hidden 
columns, they won't unhide.  He sent the spreadsheet to me and I found 
out the columns wouldn't unhide due to being "frozen".  By 
un-selecting "Freeze rows and columns", I was able to get the columns 
to appear.  I passed that information on to him and he was able to do 
the same.


Question:  should frozen columns be able to be hidden/shown when frozen?

He has since upgraded to LibreOffice 7.5.5.2.

Thanks in advance!

Peace...

Tom



--
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] Question about LibreOffice Calc 7.4.7 and hidden columns

[Tom]

Hi!  My dad just contacted me about a problem he had with a spreadsheet 
with some hidden rows and columns.  He's running Calc 7.4.7 on Windows 
11.  Anyway, when he attempts to unhide some hidden columns, they won't 
unhide.  He sent the spreadsheet to me and I found out the columns 
wouldn't unhide due to being "frozen".  By un-selecting "Freeze rows and 
columns", I was able to get the columns to appear.  I passed that 
information on to him and he was able to do the same.


Question:  should frozen columns be able to be hidden/shown when frozen?

He has since upgraded to LibreOffice 7.5.5.2.

Thanks in advance!

Peace...

Tom


--
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] Question about document paths

[Johnny Rosenberg]

Den tors 3 aug. 2023 kl 00:33 skrev Brooks, Bruce :

> I have recently purchased a new computer with the latest and greatest
> Windows 11 operating system. My old computer ran windows 11 and the
> LibreOffice path was C:\Users\Bruce's
> Lenovo5\OneDrive\Documents\Joanne\Goals for reading the bible.odt does
> not exist. The directory that it points to is basically up through
> C:\Users\Bruce's Lenovo5\OneDrive\Documents.
>
> With the new system it is "Bruce - Personal\Documents". All my files and
> folders are there but; LibreOffice can't find them. When I double click
> the file in folders it will open in LibreOffice and will save back
> correctly. The next time the file can't be found.
>
> How do I fix this? I tried to do the file path edit but that didn't seem
> to work.
>

I don't have Windows, and I never will, but exactly how do you open your
documents?
If you just click open and then navigate to the file and open it, it should
just open it.
If you click the ▼ symbol next to the open button and select it from there,
you are probably selecting the wrong file. I don't know what's the best way
to fix that, but here's what I would do:
Click the ▼ symbol next to the Open icon, then click Clear List (since the
stuff in the list are useless anyway), or if you prefer working with menus,
File → Recent Documents → Clear List.
Now open the document you want to work with, either by double clicking it
in your file manager (do they still call it ”explorer”?) or just File →
Open and then navigate to your document, or by clicking the Open icon and
then navigate to your file.
Next time you open LibreOffice, that file should be in your Recent
Documents list and you should be able to open it from there.
So basically you need to build your list of documents from scratch.

Or, if you really don't want to clear your list, you can search and replace
the old path with the new one in your registrymodifications.xcu file. On my
system it's at ~/.config/libreoffice/4/user/registrymodifications.xcu, but
I don't have a clue where Windows stores it. You could probably just search
for the file name in your file manager.

Anyway, inside that file, search for:

There's one line like that for each instance in your documents list.
Note that spaces in file names are represented with %20.
In your case I would try to do a ”search and replace all” like this:
Search for: C:\Users\Bruce's%20Lenovo5\OneDrive\
Replace with: Bruce%20-%20Personal\

If nothing is found, double check the line after the ” Thanks,
> Bruce Brooks
>
> --
> 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

[libreoffice-users] Question about document paths

[Brooks, Bruce]

I have recently purchased a new computer with the latest and greatest 
Windows 11 operating system. My old computer ran windows 11 and the 
LibreOffice path was C:\Users\Bruce's 
Lenovo5\OneDrive\Documents\Joanne\Goals for reading the bible.odt does 
not exist. The directory that it points to is basically up through 
C:\Users\Bruce's Lenovo5\OneDrive\Documents.


With the new system it is "Bruce - Personal\Documents". All my files and 
folders are there but; LibreOffice can't find them. When I double click 
the file in folders it will open in LibreOffice and will save back 
correctly. The next time the file can't be found.


How do I fix this? I tried to do the file path edit but that didn't seem 
to work.


Thanks,
Bruce Brooks

--
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] Question on better way for forumula with ods that auto imports csv file.

[Michael D. Setzer II]

Have a spreadsheet that imports data from a csv file into columns 
A, B, C.
Have various formulas in D thru J. Originally had it reference to 
cell using column with number. This worked, but found if would 
open sheet again with more lines in A,B, and C. That the last 
formulas would have the row number offset by the lines added in 
import. Only way I found to get it to always work is using the 
indirect option? Otherwise the copy of formulas would have 
incorrect rows.

=IF(AND(INDIRECT("B"())>10,INDIRECT("B"()-1)>0
),INDIRECT("A"())-INDIRECT("A"()-1),0)


++
 Michael D. Setzer II - Computer Science Instructor (Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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] Question RTF Contentcontrol in Writer

[susanne.mohn-lo]

Hallo , 

 

I am looking for the Rich Text content control in LibreOffice Writer Version
7.5.1.2. (Windows 11)

 

I have two questions: 

[1] Propertiess of the content control: 

Title: it appears above the control. 

Tag: How can I use the tag? 

 

[2] It has the property nested and can therefore accommodate objects such as
tables, graphics or other content controls.

If I insert a table or image into an rtf content control, it is replaced and
no longer exists.

 

Is this intended behaviour?

 

Greetings 

Susanne

 

_

Susanne Mohn 

 

 


-- 
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] Question about Saving Doc

[Richard England]

On 11/10/22 09:30, James Knott wrote:

On 2022-11-10 12:08, ddalem...@aol.com wrote:
I recently installed LibreOffice on my laptop and find that I cannot 
Save to a USB flashdrive for possible future editing AND delete the 
document from my laptop. Deleting document on my laptop (in 
LibreOffice) leaves anything I think I’ve Saved to usb drive blank as 
well. My wish is to create a document in LibreOffice and save it to 
usb flashdrive without it remaining on my computer, so that if I wish 
to edit any of it in the future I can retrieve the document via my 
usb flashdrive and modify as needed….without its content remaining in 
my laptop between creation and editing.

Pls help me understand how to do this.Thanks very much!

That sounds like it might be a permissions issue.  Can you write to 
USB from other apps?



Or it could be that the file system caches data and it hasn't been 
written to the flash drive before it is removed. Was the correct 
removal/dismount process followed for  you OS?


~~R


--
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] Question about Saving Doc

[James Knott]

On 2022-11-10 12:08, ddalem...@aol.com wrote:

I recently installed LibreOffice on my laptop and find that I cannot Save to a 
USB flashdrive for possible future editing AND delete the document from my 
laptop. Deleting document on my laptop (in LibreOffice) leaves anything I think 
I’ve Saved to usb drive blank as well. My wish is to create a document in 
LibreOffice and save it to usb flashdrive without it remaining on my computer, 
so that if I wish to edit any of it in the future I can retrieve the document 
via my usb flashdrive and modify as needed….without its content remaining in my 
laptop between creation and editing.
Pls help me understand how to do this.Thanks very much!

That sounds like it might be a permissions issue.  Can you write to USB 
from other apps?



--
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] Question about Saving Doc

[ddalem...@aol.com]

I recently installed LibreOffice on my laptop and find that I cannot Save to a 
USB flashdrive for possible future editing AND delete the document from my 
laptop. Deleting document on my laptop (in LibreOffice) leaves anything I think 
I’ve Saved to usb drive blank as well. My wish is to create a document in 
LibreOffice and save it to usb flashdrive without it remaining on my computer, 
so that if I wish to edit any of it in the future I can retrieve the document 
via my usb flashdrive and modify as needed….without its content remaining in my 
laptop between creation and editing.
Pls help me understand how to do this.Thanks very much!


Sent from the all new AOL app for iOS

-- 
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] Question on send to email option in linux..

[Philip Jackson]

On 18/07/2022 22:56, Michael D. Setzer II wrote:

On 18 Jul 2022 at 22:12, Philip Jackson wrote:

Date sent:  Mon, 18 Jul 2022 22:12:20 +0200
Subject:Re: [libreoffice-users] Question on send to
email option in linux..
From:   Philip Jackson
To: LibreOffice


On 18/07/2022 21:35, Michael D. Setzer II wrote:

Thanks for the reply. I have LibreOffice 7.2.7.2 version as
loaded by default for my Fedora 35 and also have
LibreOffice 7.3.4.2 downloaded from libreoffice.

With both I have tried a simple saved file with the word
test in it. File is saved. Have Tools / Options / Internet /
Email set to /usr/bin/WSENDTO (Thou I did also try using
the direct path to program as well.).

Strange - but in all the years I've been using LO Writer and email, I've never 
thought or had reason to look at that setting. But now that you've made me 
curious, I've had a look to see what I've got in Tools / Options / Internet / 
Email and it informs me that my email program is :  sensible-lomua.

I've no idea what that is. I've used Thunderbird in conjunction with Linux and 
LO for many years and it just worked.

Sorry.

Thanks again for the quick response. Don't know if it is
trying something else. In browser I can type
mailto:mi...@guam.net  and it pulls up email client with
no problem. Just seeing nothing with libreoffice, but the
macro works fine.


I thought I'd try to find out a bit more about 'sensible-lomua' which is what 
exists by default in my Tools / Options / Internet / Email.  I guessed that the 
lomua was Libreoffice mail user agent and apparently that has been inherited 
from OpenOffice where it was 'sensible-oomua'.

There was a bug opened in 2011 by someone who had a similar problem:

https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/841184

Their solution was simply to replace 'sensible-lomua' with 'thunderbird'  
(without the quotes and without any path).

Philip


--
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] Question on send to email option in linux..

[Michael D. Setzer II]

On 18 Jul 2022 at 22:12, Philip Jackson wrote:

Date sent:  Mon, 18 Jul 2022 22:12:20 +0200
Subject:Re: [libreoffice-users] Question on send to 
email option in linux..
From:   Philip Jackson 
To: LibreOffice 

> On 18/07/2022 21:35, Michael D. Setzer II wrote:
> > Thanks for the reply. I have LibreOffice 7.2.7.2 version as
> > loaded by default for my Fedora 35 and also have
> > LibreOffice 7.3.4.2 downloaded from libreoffice.
> >
> > With both I have tried a simple saved file with the word
> > test in it. File is saved. Have Tools / Options / Internet /
> > Email set to /usr/bin/WSENDTO (Thou I did also try using
> > the direct path to program as well.).
> 
> Strange - but in all the years I've been using LO Writer and email, I've 
> never thought or had reason to look at that setting. But now that you've made 
> me curious, I've had a look to see what I've got in Tools / Options / 
> Internet / Email and it informs me that my email program is :  sensible-lomua.
> 
> I've no idea what that is. I've used Thunderbird in conjunction with Linux 
> and LO for many years and it just worked.
> 
> Sorry.

Thanks again for the quick response. Don't know if it is 
trying something else. In browser I can type 
mailto:mi...@guam.net and it pulls up email client with 
no problem. Just seeing nothing with libreoffice, but the 
macro works fine. 

Thanks.



> 
> > /usr/bin/WSENDTO has this.
> > #!/bin/bash
> > echo $0 $1 $2 $3
> > /home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDT
> > O.EXE $1
> >
> > Strange thing is that absolutely nothing happens. No box
> > opens, and nothing in way of a error message is showing
> > up.. But with my simple macro - running it opens the
> > email client and has the document attached with no
> > problem...
> >
> > Simple Macro
> > Sub Mailto
> > Dim oDoc As Object
> > Dim Path$
> > oDoc = ThisComponent
> > Path$ = oDoc.getURL()
> > If oDoc.HasLocation() Then
> > shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
> > SENDTO.EXE " (Path$,8,100) )
> > Else
> >Print "The document has not yet been stored"
> > End If
> > End Sub
> >
> > Tools / Marco / Run and selecting it opens the email client
> > with the file attached..
> >
> > Not getting anything is what confuses me. Would expect
> > something to show on screen, but nothing. The macro
> > calls same program and takes the passed parameter, and
> > does trim theFILE://  off the parameter.
> >
> >
> >> +
> >>>Michael D. Setzer II - Computer Science Instructor
> >>> (Retired)
> >>>mailto:mi...@guam.net
> >>>mailto:msetze...@gmail.com
> >>>Guam - Where America's Day Begins
> >>>G4L Disk Imaging Project maintainer
> >>>http://sourceforge.net/projects/g4l/
> >>> ++
> >>>
> >>>
> >>>
> >>>
> 
> -- 
> 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


++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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] Question on send to email option in linux..

[Stephan Bergmann]

On 7/18/22 21:35, Michael D. Setzer II wrote:
[...]

Thanks for the reply. I have LibreOffice 7.2.7.2 version as
loaded by default for my Fedora 35 and also have
LibreOffice 7.3.4.2 downloaded from libreoffice.

With both I have tried a simple saved file with the word
test in it. File is saved. Have Tools / Options / Internet /
Email set to /usr/bin/WSENDTO (Thou I did also try using
the direct path to program as well.).

/usr/bin/WSENDTO has this.
#!/bin/bash
echo $0 $1 $2 $3
/home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDT
O.EXE $1

Strange thing is that absolutely nothing happens. No box
opens, and nothing in way of a error message is showing
up.. But with my simple macro - running it opens the
email client and has the document attached with no
problem...


LO doesn't actually call /usr/bin/WSENDTO with the document's pathname 
as an argument (as one might expect).  What rather happens, for better 
or worse (see CmdMailSuppl::sendSimpleMailMessage at 
), 
is that LO calls its senddoc helper script (see 
) 
with lots of arguments, among them `--mailclient` `/usr/bin/WSENDTO`.


And that senddoc script then tries to guess from the given mail client's 
basename what program that is, and knows how to pass it along all the 
other arguments, potentially specifying the mail's to, cc, body, 
attachment, etc.  But that senddoc script doesn't know anything about a 
mail client with basename WSENDTO, so gives up and tries something like 
xdg-email instead, but which apparently doesn't lead to any success with 
your setup, either.



--
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] Question on send to email option in linux..

[Philip Jackson]

On 18/07/2022 21:35, Michael D. Setzer II wrote:

Thanks for the reply. I have LibreOffice 7.2.7.2 version as
loaded by default for my Fedora 35 and also have
LibreOffice 7.3.4.2 downloaded from libreoffice.

With both I have tried a simple saved file with the word
test in it. File is saved. Have Tools / Options / Internet /
Email set to /usr/bin/WSENDTO (Thou I did also try using
the direct path to program as well.).


Strange - but in all the years I've been using LO Writer and email, I've never 
thought or had reason to look at that setting. But now that you've made me 
curious, I've had a look to see what I've got in Tools / Options / Internet / 
Email and it informs me that my email program is :  sensible-lomua.

I've no idea what that is. I've used Thunderbird in conjunction with Linux and 
LO for many years and it just worked.

Sorry.


/usr/bin/WSENDTO has this.
#!/bin/bash
echo $0 $1 $2 $3
/home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDT
O.EXE $1

Strange thing is that absolutely nothing happens. No box
opens, and nothing in way of a error message is showing
up.. But with my simple macro - running it opens the
email client and has the document attached with no
problem...

Simple Macro
Sub Mailto
Dim oDoc As Object
Dim Path$
oDoc = ThisComponent
Path$ = oDoc.getURL()
If oDoc.HasLocation() Then
shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
SENDTO.EXE " (Path$,8,100) )
Else
   Print "The document has not yet been stored"
End If
End Sub

Tools / Marco / Run and selecting it opens the email client
with the file attached..

Not getting anything is what confuses me. Would expect
something to show on screen, but nothing. The macro
calls same program and takes the passed parameter, and
does trim theFILE://  off the parameter.



+

   Michael D. Setzer II - Computer Science Instructor
(Retired)
   mailto:mi...@guam.net
   mailto:msetze...@gmail.com
   Guam - Where America's Day Begins
   G4L Disk Imaging Project maintainer
   http://sourceforge.net/projects/g4l/
++






--
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] Question on send to email option in linux..

[Michael D. Setzer II]

On 18 Jul 2022 at 18:25, Philip Jackson wrote:

Date sent:  Mon, 18 Jul 2022 18:25:45 +0200
Subject:Re: [libreoffice-users] Question on send to 
email option in linux..
To: users@global.libreoffice.org
From:   Philip Jackson 

> Could there be a problem with your installation of LO?
> 
> I'm using LO Writer 6.4.7.2 on UbuntuStudio 20.04 and the Send to email
> works fine. Clicking the File > 'Send to email' opens a write window in my
> Thunderbird mail client with the document already attached. 
>

Thanks for the reply. I have LibreOffice 7.2.7.2 version as 
loaded by default for my Fedora 35 and also have 
LibreOffice 7.3.4.2 downloaded from libreoffice.

With both I have tried a simple saved file with the word 
test in it. File is saved. Have Tools / Options / Internet / 
Email set to /usr/bin/WSENDTO (Thou I did also try using 
the direct path to program as well.).

/usr/bin/WSENDTO has this.
#!/bin/bash
echo $0 $1 $2 $3
/home/msetzerii/.wine/drive_c/PMAIL/Programs/WSENDT
O.EXE $1

Strange thing is that absolutely nothing happens. No box 
opens, and nothing in way of a error message is showing 
up.. But with my simple macro - running it opens the 
email client and has the document attached with no 
problem...

Simple Macro
Sub Mailto
Dim oDoc As Object
Dim Path$
oDoc = ThisComponent
Path$ = oDoc.getURL()
If oDoc.HasLocation() Then 
shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
SENDTO.EXE " (Path$,8,100) )
Else
  Print "The document has not yet been stored"
End If
End Sub
 
Tools / Marco / Run and selecting it opens the email client 
with the file attached..

Not getting anything is what confuses me. Would expect 
something to show on screen, but nothing. The macro 
calls same program and takes the passed parameter, and 
does trim the FILE:// off the parameter. 


> Philip
> 
> On 18/07/2022 12:14, Michael D. Setzer II wrote:
> > Was trying to get the option to work, but after setting the
> > program for Internet email nothing  happened when I
> > tried to send to email. No message No Error.
> >
> > Created a macro that does seem to work, but is very
> > basic. Just copied stuff I found on web, so some parts
> > might be better. First writer macro I've done. Usually do
> > macros in calc.
> > Found code getURL that gets path to file that must be
> > saved already. Probable a command to get it without the
> > file://  but found another thing to remove that.
> > Then it is just a matter of calling the WSENDTO.EXE
> > program and adding the full path to the already save file.
> > That brings up the Pegasus Email client, and adds the
> > document as an attachment.
> >
> > Sub Mailto
> > Dim oDoc As Object
> > Dim Path$
> > oDoc = ThisComponent
> > Path$ = oDoc.getURL()
> > If oDoc.HasLocation() Then
> >Print "The Document URL is " & oDoc.getURL()
> >uWithoutProto = Split(oDoc.getURL(),"file://")(1)
> > shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
> > SENDTO.EXE " & uWithoutProto)
> > Else
> >Print "The document has not yet been stored"
> > End If
> > End Sub
> >
> > Has print statements from original code, that could be
> > removed. The WSENDTO.EXE is the mapi client that
> > works in windows and works from firefox.  Surprized that
> > nothing shows with libreoffice.
> >
> > Thanks.
> >
> > ++
> >   Michael D. Setzer II - Computer Science Instructor
> > (Retired)
> >   mailto:mi...@guam.net
> >   mailto:msetze...@gmail.com
> >   Guam - Where America's Day Begins
> >   G4L Disk Imaging Project maintainer
> >   http://sourceforge.net/projects/g4l/
> > ++
> >
> >
> >
> >
> 
> --
> -

Re: [libreoffice-users] Question on send to email option in linux..

[Philip Jackson]

Could there be a problem with your installation of LO?

I'm using LO Writer 6.4.7.2 on UbuntuStudio 20.04 and the Send to email works 
fine. Clicking the File > 'Send to email' opens a write window in my 
Thunderbird mail client with the document already attached.

Philip

On 18/07/2022 12:14, Michael D. Setzer II wrote:

Was trying to get the option to work, but after setting the
program for Internet email nothing  happened when I
tried to send to email. No message No Error.

Created a macro that does seem to work, but is very
basic. Just copied stuff I found on web, so some parts
might be better. First writer macro I've done. Usually do
macros in calc.
Found code getURL that gets path to file that must be
saved already. Probable a command to get it without the
file://  but found another thing to remove that.
Then it is just a matter of calling the WSENDTO.EXE
program and adding the full path to the already save file.
That brings up the Pegasus Email client, and adds the
document as an attachment.

Sub Mailto
Dim oDoc As Object
Dim Path$
oDoc = ThisComponent
Path$ = oDoc.getURL()
If oDoc.HasLocation() Then
   Print "The Document URL is " & oDoc.getURL()
   uWithoutProto = Split(oDoc.getURL(),"file://")(1)
shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
SENDTO.EXE " & uWithoutProto)
Else
   Print "The document has not yet been stored"
End If
End Sub

Has print statements from original code, that could be
removed. The WSENDTO.EXE is the mapi client that
works in windows and works from firefox.  Surprized that
nothing shows with libreoffice.

Thanks.

++
  Michael D. Setzer II - Computer Science Instructor
(Retired)
  mailto:mi...@guam.net
  mailto:msetze...@gmail.com
  Guam - Where America's Day Begins
  G4L Disk Imaging Project maintainer
  http://sourceforge.net/projects/g4l/
++






--
--
   author of "The Circle of Fifths" for improvising 
musicians
  Get it here https://www.books2read.com/u/bWnRM4

  auteur : "Le Cycle des Quintes" pour musiciens improvisateurs
  disponibilité : https://www.books2read.com/u/bw8rv9
--

--
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] Question on send to email option in linux..

[Michael D. Setzer II]

Was trying to get the option to work, but after setting the 
program for Internet email nothing  happened when I 
tried to send to email. No message No Error.

Created a macro that does seem to work, but is very 
basic. Just copied stuff I found on web, so some parts 
might be better. First writer macro I've done. Usually do 
macros in calc.
Found code getURL that gets path to file that must be 
saved already. Probable a command to get it without the 
file:// but found another thing to remove that.
Then it is just a matter of calling the WSENDTO.EXE 
program and adding the full path to the already save file.
That brings up the Pegasus Email client, and adds the 
document as an attachment. 

Sub Mailto
Dim oDoc As Object
Dim Path$
oDoc = ThisComponent
Path$ = oDoc.getURL()
If oDoc.HasLocation() Then
  Print "The Document URL is " & oDoc.getURL()
  uWithoutProto = Split(oDoc.getURL(), "file://")(1)
shell("/home/msetzerii/.wine/drive_c/PMAIL/Programs/W
SENDTO.EXE " & uWithoutProto)
Else
  Print "The document has not yet been stored"
End If
End Sub

Has print statements from original code, that could be 
removed. The WSENDTO.EXE is the mapi client that 
works in windows and works from firefox.  Surprized that 
nothing shows with libreoffice. 

Thanks.

++
 Michael D. Setzer II - Computer Science Instructor 
(Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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] Question about Saving XLSX files in Calc 7.2.4 and 'extra rows'

[Tom]

Hi!  I recently edited an Excel spreadsheet in LibreOffice Calc 7.2.4.1 
on Windows 10 and after saving the updated XLSX file, I imported it into 
Office 365 Excel online (the free version available if you have a 
Hotmail account) and noticed the "print friendly" PDF version reported 
having 188 pages!  When I view the same spreadsheet in Calc and use the 
print preview function, everything fits on one page.


So, I'm not sure if Calc is saving the XLSX file in a "funky" way or if 
Office 365 Excel online (free version) is "confused".  :) lol   I added 
some rows to the main sheet, updated some footer text, removed some 
rows, from the main sheet, and turned off some borders in the last row 
of the sheet.  I can't imagine any of that would cause the weird 
behavior I'm seeing in Excel 365 online.


Has anyone else seen this kind of behavior?

Thanks in advance!

Peace...

"The Other" Tom


--
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] question about generating documents live on server

[Marcin Giedz]

Hi there,

in our framework (mainly C++/python based) we use html + xml + xstl to
generate pdf files - different types like agreements, appendices, etc. It's
quite painful when it comes to any change in such a document specially when
a template is sent in doc/odt files.

I was wondering if there is a chance to use libreoffice solution and fill
such documents online on the server and converting them to pdf files? I
understand odt is actually zip archive and we can unzip it, replace
content.xml with proper data and zip it back. But perhaps there are other
methods/solutions we can use to process odt files more natively ?


Many thx
Marcin

-- 
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] Question about Calc and Data Validity

[Tom]

Hi!  So, I need to create a spreadsheet with a column of drop-down 
values.  I found how to do that using the "Data > Validity" menu 
option.  I created a drop-down menu column and it works fine.    Of 
course, I need to export this as an Excel file and I found Excel handles 
drop-down menus differently.  *sigh*


So, I was able to define the drop-down menu in Calc using the Excel 
approach and it works fine (albeit ugly).


My question: has anyone had any experience with exporting spreadsheets 
with drop-down menus in a column to Excel format? Did it work?  Was it 
problematic?


Thanks in advance!

Peace...

"The Other" Tom


--
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] Question on INDIRECT()

[Steve Edmonds]

Hi Rob, did you ever get this answered.
You could use something like the below for the cells with a '+' in them.
Assuming below is row 4, vertical bars are cell borders.
|25+15|=VALUE(LEFT(A4,FIND("+",A4)-1))+VALUE(RIGHT(A4,LEN(A4)-FIND("+",A4)))|

If you need it to be generic for with/without the + then you could use 
an IF to check, shown below for row 5.

=IF(ISNUMBER(A5),A5,VALUE(LEFT(A5,FIND("+",A5)-1))+VALUE(RIGHT(A5,LEN(A5)-FIND("+",A5

Steve

On 18/10/2021 12:13, Rob Jasper wrote:

Hi list-users,

I have the following question:

I have in column A value either a number, or string in the format  +, 
in col B I want to calculate what’s in Col A
e.g.:

   10   10
12+72   84
   33   33
66+72   138

So, I tired the formula =INDIRECT(“=“) but I only get REF!
What am I doing wrong here, and how can I achieve 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] Question on INDIRECT()

[Johnny Rosenberg]

Den lör 23 okt. 2021 kl 21:38 skrev Steve Edmonds <
steve.edmo...@ptglobal.com>:

> Hi Rob, did you ever get this answered.
>

I answered it, but unfortunately I failed (again) to send it to the group.
Sorry for that.
I'll see if I can find it and send it again, but to the group this time.
I use Gmail's web interface and I always forget that I need to ”Reply to
all” for the group to get it. For almost all the other mailing lists I'm
subscribed to, just hitting ”Reply” does the job, so that's what I'm used
to. That's why this happens so often. Not saying that this or that is right
or wrong, just explaining why this fails so often for me… :)

Again, sorry for all that. I'll try to get a little better at this…


Kind regards

Johnny Rosenberg


> You could use something like the below for the cells with a '+' in them.
> Assuming below is row 4, vertical bars are cell borders.
>
> |25+15|=VALUE(LEFT(A4,FIND("+",A4)-1))+VALUE(RIGHT(A4,LEN(A4)-FIND("+",A4)))|
>
> If you need it to be generic for with/without the + then you could use
> an IF to check, shown below for row 5.
>
> =IF(ISNUMBER(A5),A5,VALUE(LEFT(A5,FIND("+",A5)-1))+VALUE(RIGHT(A5,LEN(A5)-FIND("+",A5
>
> Steve
>
> On 18/10/2021 12:13, Rob Jasper wrote:
> > Hi list-users,
> >
> > I have the following question:
> >
> > I have in column A value either a number, or string in the format
> +, in col B I want to calculate what’s in Col A
> > e.g.:
> >
> >10 10
> > 12+72 84
> >33 33
> > 66+72 138
> >
> > So, I tired the formula =INDIRECT(“=“) but I only get REF!
> > What am I doing wrong here, and how can I achieve 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
>

-- 
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] Question [not!] on INDIRECT()

[Brian Barker]

At 01:13 18/10/2021 +0200, Rob Jasper wrote:

I have the following question:


If, as here, you prepare your question as a reply to a previous 
message when it is nothing of the sort, it will be lost in the 
previous thread and may not be seen by possible helpers.


I have in column A value either a number, or string in the 
format  +,  ...


Nauru? Norwich postcodes? National Rail? Noise reduction?


... in col B I want to calculate what's in Col A
e.g.:
  1010
12+72   84
  3333
66+72   138

So, I tired the formula =INDIRECT("=") but I only get REF! What 
am I doing wrong here, ...


Probably thinking INDIRECT() does something different from what it does.


... and how can I achieve what I want?


First solution: don't enter your data like that in the first place.

I don't think there is any simple method to do what you ask in a 
general fashion. If, as you suggest, the operator is always "+", you could use

=IF(ISNUMBER(A1);A1;LEFT(A1;FIND("+";A1)-1)+MID(A1;FIND("+";A1)+1;99))
You could make this simpler if you knew that the numbers in the 
expressions were always of two digits.


I trust this helps.

Brian Barker


--
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] Question on INDIRECT()

[Rob Jasper]

Hi list-users,

I have the following question:

I have in column A value either a number, or string in the format  +, 
in col B I want to calculate what’s in Col A
e.g.:

  1010
12+72   84
  3333
66+72   138

So, I tired the formula =INDIRECT(“=“) but I only get REF!
What am I doing wrong here, and how can I achieve 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] Question

[Andrew Pitonyak]

I believe the default is no... Check your settings... Cannot check now (away 
from computer)

Also, excel macros are not 100 percent supported.

⁣Get BlueMail for Android ​

On Oct 6, 2021, 7:19 AM, at 7:19 AM, sleepy  wrote:
>Does LibreOffice Calc have macros turned on by default? I accidently
>opened
>a xlsx file using Calc and I'm a really paranoid and think the file is
>infected I meant to download it but I accidently opened it
>
>-- 
>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] Question

[Harvey Nimmo]

I'm not quite sure how I understand this answer to sleepy's question.
Is it "No, macros are off by default" or "Yes...but..."?
"Excel VBA not likely to run..": I assume it is not designed to run
Excel VBA?

Cheers
Harvey

On Wed, 2021-10-06 at 09:05 -0400, Alan B wrote:
> Default in LO 7.1.5.2
> 
> Security level High - Only signed macros from trusted sources allowed
> to
> run.
> 
> Plus not 100% compatible with Excel. Excel VBA not likely to run in
> Calc.
> (Formulas are a different story. Much better cross product support.)
> 
> On Wed, Oct 6, 2021, 7:36 AM sleepy  wrote:
> 
> > Does LibreOffice Calc have macros turned on by default? I
> > accidently opened
> > a xlsx file using Calc and I'm a really paranoid and think the file
> > is
> > infected I meant to download it but I accidently opened it
> > 
> > --
> > 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] Question

[Alan B]

Default in LO 7.1.5.2

Security level High - Only signed macros from trusted sources allowed to
run.

Plus not 100% compatible with Excel. Excel VBA not likely to run in Calc.
(Formulas are a different story. Much better cross product support.)

On Wed, Oct 6, 2021, 7:36 AM sleepy  wrote:

> Does LibreOffice Calc have macros turned on by default? I accidently opened
> a xlsx file using Calc and I'm a really paranoid and think the file is
> infected I meant to download it but I accidently opened it
>
> --
> 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

[libreoffice-users] Question

[sleepy]

Does LibreOffice Calc have macros turned on by default? I accidently opened
a xlsx file using Calc and I'm a really paranoid and think the file is
infected I meant to download it but I accidently opened it

-- 
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] Question about testing changes made to MS Word documents

[Tom]

On 9/14/21 5:54 AM, James Knott wrote:

On 2021-09-13 11:38 p.m., Tom Williams wrote:

So, what's a good/reliable way to test changes saved in DOCX format in
Writer?   Is using Word online, as I did, akin to loading it in MS Word
2016?  I believe the document was last edited in MS Word 2016 before it
was sent to me.


What I did was install the free Word viewer.
https://www.microsoft.com/en-ca/p/doc-viewer/9n69kfjds28z#activetab=pivot:overviewtab 



Apparently, it's now called Doc Viewer.  I'm not sure how it compares 
with the Word viewer.





Thanks for the reply and for the link!  I'll try it out!

Peace...

"The Other" Tom


--
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] Question about testing changes made to MS Word documents

[James Knott]

On 2021-09-13 11:38 p.m., Tom Williams wrote:

So, what's a good/reliable way to test changes saved in DOCX format in
Writer?   Is using Word online, as I did, akin to loading it in MS Word
2016?  I believe the document was last edited in MS Word 2016 before it
was sent to me.


What I did was install the free Word viewer.
https://www.microsoft.com/en-ca/p/doc-viewer/9n69kfjds28z#activetab=pivot:overviewtab

Apparently, it's now called Doc Viewer.  I'm not sure how it compares 
with the Word viewer.



--
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] Question about testing changes made to MS Word documents

[Tom Williams]

How-dee!   I have a question about testing changes made to MS Word
documents.   Someone sent me a Word DOCX file that needed to be updated
and I managed to update it in LibreOffice Writer 7.1.5.2 on Ubuntu 21.04
Linux.  I wanted to test the saved file by loading it in MS Word.  Since
I don't have access to MS Office, I uploaded it to Word online using my
Hotmail account.  The document loaded but when I went to print it, the
generated PDF was pretty much trashed.

So, what's a good/reliable way to test changes saved in DOCX format in
Writer?   Is using Word online, as I did, akin to loading it in MS Word
2016?  I believe the document was last edited in MS Word 2016 before it
was sent to me.

Thanks in advance!

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Question on Command Line options for Writer??

[Michael D. Setzer II]

I've done things with Calc, and it has options to set how 
the importing of csv files goes..


Was chatting with a person that was trying to convert odt 
to pdf files via command line. That was actually simple.


libreoffice --headless --convert-to pdf filename.odt


Issue was that it uses the last options that was used from 
program.


63229 Aug92019 lisarequest.odt(Original ODT File)
55911 Aug92019 lisarequest2.pdf (Exported from GUI)
124092 Feb3 01:46 lisarequest3.pdf (Exported from
Command Line but last time had set the option to create hybrid)
66932 Feb3 03:26 lisarequest.pdf(Changed option in GUI to 
remove the check on hybrid, exited program, redid command line 
option)


Have looked for a way to do this on command line, but everything 
I've found seems to say you have to do it in the GUI settings??


With calc, I have a script that uses
libreoffice --infilter=CSV:59,34,76,1true$f.csv
That opens the csv file with the exact options I need.


Perhaps writer can do the same, but I've not found how??


Thanks.




-- 
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] Question about tab order in form in Writer

[Tom]

On 1/10/21 10:13 PM, Tom wrote:
Hi! I'm working on converting a 20 page document into a PDF form.  I'm 
using the form design mode of LibreOffice Writer 7.0.3 on Windows 10 
to add the various form fields.   At the time I started this, I 
thought I had to manually set the tab order on each form field. After 
investing some odd behavior with tab order in forms, I learned Writer 
will automatically set the tab order of the form fields.


I have since upgraded to LibreOffice 7.0.4.  My question:  is it 
possible to "reset" the tab order values I set manually?  If not, is 
it possible to "undo" or remove the tab order values I set on each 
form field?  I'm only 2 pages into my document, fortunately. :)


Thanks in advance!  Happy New Year! :)

Peace...

"The Other" Tom


Well, I found my answer.  I needed to use the "Tab Order" dialog window 
to control the tab order of the form fields.    I found the information 
here:


https://help.libreoffice.org/6.3/en-US/text/shared/02/01170300.html

Using the "Automatic Sort" function, I was able to effectively "reset" 
my manual tab order.  Then, I was able to fine tune the tab order by 
moving fields up or down.  The fields are identified by field name.


Peace...

"The Other" Tom


--
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] Question about tab order in form in Writer

[Tom]

Hi!  I'm working on converting a 20 page document into a PDF form.  I'm 
using the form design mode of LibreOffice Writer 7.0.3 on Windows 10 to 
add the various form fields.   At the time I started this, I thought I 
had to manually set the tab order on each form field.  After investing 
some odd behavior with tab order in forms, I learned Writer will 
automatically set the tab order of the form fields.


I have since upgraded to LibreOffice 7.0.4.  My question:  is it 
possible to "reset" the tab order values I set manually?  If not, is it 
possible to "undo" or remove the tab order values I set on each form 
field?  I'm only 2 pages into my document, fortunately. :)


Thanks in advance!  Happy New Year! :)

Peace...

"The Other" Tom


--
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] Question on getting a list of all the macro commands

[Michael D. Setzer II]

Does a file with them exist in full or part.
Was recently looking thru menus and found something interesting that I 
had not noticed before.
Data / Calculate / Formula to Value

I did a test, and it did what I wanted, so recorded the macro.
Strangely, the command to do the Formula to Value was there, but it had 
rem in front of it, so macro would not work as recorded. Removed the 
rem, and it worked fine?? So, this can duplicate the F9 Enter option for 
some things. 

sub xx12
rem --
rem define variables
dim document   as object
dim dispatcher as object
rem --
rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem --
rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "StringName"
args1(0).Value = "=sum(k2:k57)"
dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args1())
dispatcher.executeDispatch(document, ".uno:ConvertFormulaToValue", "", 0, 
Array())
end sub

My main macro in this sheet takes a set of data from a web site. that is placed 
in a2:o64.
Only need data in a2:d64 and the total of data in K2;K57. So, macro delete 
columns E to O.
But need to save total of K2:K57. Had been entering formula manually, and using 
F9 to convert it.
Just need to put this code in main macro to automate how process to the macro I 
have linked to 
Shift-F4. Updates covid data from 50 states, D.C., and 5 Territories.. So, run 
it as data changes.
Perhaps there are lots of other such processes outthere. 
Still find it strange that the recorder recorded it, but did it as a remark??

Thanks again..

-- 
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] Question on getting a list of all the macro commands

[Jean-Francois Nifenecker]

Hello Mike,

Le 29/11/2020 à 18:33, Michael D. Setzer II a écrit :

Does a file with them exist in full or part.


nope. Well, not that I know of. The LibO API (application programming 
interface) is a quite complex beast.



Was recently looking thru menus and found something interesting that I
had not noticed before.
Data / Calculate / Formula to Value


I did a test, and it did what I wanted, so recorded the macro.


The LibreOffice macro recorder is a *very* limited tool, which has 
nothing to see with some other Office suite recorder. The LibO recorder 
just records your actions in the GUI (keyboard and mouse actions) and 
translates them using a special object, the Dispatcher.


The resulting code has very little to see with actual macro code you 
might write to accomplish the very same actions in "purer" Basic.


This doesn't mean the recorder is useless. I use it everytime I need a 
quickly automated process. But don't rely on it to manage (not so) 
complex processes.


If you want to delve in Basic macro coding, as an English-speaking user 
you should read Andrew Pitonyak's books. Check Andrew's website here: 
https://www.pitonyak.org/oo.php.
His macro document is a collection of predefined macros, while his book 
is more elaborated. Both are highly recommended reads!


For a quick start, you might also find the 9 reference sheets available 
from the LibO extension pages handy:

https://extensions.libreoffice.org/?Tags%5B%5D=173


HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
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] Question on getting a list of all the macro commands

[Michael D. Setzer II]

Does a file with them exist in full or part.
Was recently looking thru menus and found something interesting that I 
had not noticed before.
Data / Calculate / Formula to Value


I did a test, and it did what I wanted, so recorded the macro.
Strangely, the command to do the Formula to Value was there, but it had 
rem in front of it, so macro would not work as recorded. Removed the 
rem, and it worked fine?? So, this can duplicate the F9 Enter option for 
some things.


sub xx12
rem --
rem define variables
dim documentas object
dim dispatcher as object
rem --
rem get access to the document
document= ThisComponent.CurrentController.Frame
dispatcher = createUnoService(com.sun.star.frame.DispatchHelper)


rem --
rem --
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name =StringName
args1(0).Value ==sum(k2:k57)
dispatcher.executeDispatch(document,.uno:EnterString,, 0, args1())
dispatcher.executeDispatch(document,.uno:ConvertFormulaToValue,, 0, Array())
end sub


My main macro in this sheet takes a set of data from a web site. that is placed 
in a2:o64.
Only need data in a2:d64 and the total of data in K2;K57. So, macro delete 
columns E to O.
But need to save total of K2:K57. Had been entering formula manually, and using 
F9 to convert it.
Just need to put this code in main macro to automate how process to the macro I 
have linked to 
Shift-F4. Updates covid data from 50 states, D.C., and 5 Territories.. So, run 
it as data changes.
Perhaps there are lots of other such processes outthere.
Still find it strange that the recorder recorded it, but did it as a remark??


Thanks again..


-- 
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] Question on value comand and Err:502

[Alan B]

Haven't found documentation to confirm but I believe your first example
=value(1+1) is recognized as a formula, the formula is processed and the
result converted to a value.

It works for me if I enter =value(sum(1,1)) the cell displays 2 and
=CELL("type",), pointed at that cell, displays v

If I format a cell as text, enter a decimal digit, e.g. 2, and point
value() at that cell it returns the number 2.

If i point cell("type",) at the cell containing digits that are
formatted as text the result is "l" (lower case L).

If I point cell("type",) at the value() formula that points at the
text formatted digits it returns v.

So, I would say that value() converts a number formatted as text to a
value, converts a formula that results in a number to a value, but will not
recognize a formula written as a text string and convert the string to
produce the value.

On Mon, Nov 23, 2020 at 11:50 PM Michael D. Setzer II 
wrote:

> Put a more complex question, and got no responses yet.
> So, here it is in simplest form
> =value(1+1)  converts the 1+1 to 2
> But =value( ) fails with Err:502 is text "1+1" is used or i a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a text
> string to a value? Is there another command, or am I doing something
> wrong?
>
> Contents of a simple spreadsheet
>
> 2   "=value(1+1)
> Err:502 "=VALUE("1+1")
> "1+1TRUE=ISTEXT(A3)
> Err:502 "=value(a3)
>
>
> ++
>  Michael D. Setzer II - Computer Science Instructor (Retired)
>  mailto:mi...@guam.net
>  mailto:msetze...@gmail.com
>  Guam - Where America's Day Begins
>  G4L Disk Imaging Project maintainer
>  http://sourceforge.net/projects/g4l/
> ++
>
>
>
>
> --
> 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
>
>

-- 
Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

-- 
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] Question on value command and Err:502

[Brian Barker]

At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:

Put a more complex question, and got no responses yet.


You have to admit that your description and layout were pretty foggy! 
Did anyone understand it?



So, here it is in simplest form
=value(1+1) converts the 1+1 to 2
But =value( ) fails with Err:502 if text "1+1" is used or if a cell 
containing the text 1+1 is used??
I've looked thru command, and this seems to be the one to convert a 
text string to a value?


It is. But the text string "1+1" is not a value expressed as text but 
a numerical expression in text form. And VALUE() does not undertake 
to evaluate such expressions.



Is there another command, ...;


What you need instead is the EVALUATE() function. (PS: It doesn't exist!)

I think the fact that VALUE(1+1) entered as part of a formula does 
what it does is a lucky side effect. Clearly in this case LibreOffice 
is doing something similar to the automatic editing that is done when 
any material is entered into a spreadsheet cell. I'm talking about 
this sort of thing: when you type "+02" (no quotes) into a cell 
formatted as Number, you see just 2. The "1+1" in this case is being 
entered into a cell (as part of a formula), not arising as the result 
of some calculation.


I trust this helps.

Brian Barker


--
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] Question on value command and Err:502

[Dave Howorth]

You'd probably get more help if you made your emails understandable!

Below is what I see from you ...
(with some > quote marks on the left hand side)
I can't even tell what you wrote in addition to what Brian wrote, let
alone begin to interpret what you're asking. 

On Wed, 25 Nov 2020 00:02:04 +1000
"Michael D. Setzer II"  wrote:

> =On 24 Nov 2020 at 13:05, Brian Barker wrote:
> 
> 
> Date sent:60;Tue, 24 Nov 2020 13:05:46 +
> To:;=users@global.libreoffice.org
> From:60;Brian Barker;b.m.bar...@btinternet.com
> Subject:;Re: [libreoffice-users] Question on value command 
> and Err:502
> 
> 
> At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:
> Put a more complex question, and got no responses yet.
> 
> 
> You have to admit that your description and layout were pretty foggy!
> Did anyone understand it?
> 
> 
> So, here it is in simplest form
> =value(1+1) converts the 1+1 to 2
> But =value( ) fails with Err:502 if text1+1is used or if a cell
> containing the text 1+1 is used??
> I've looked thru command, and this seems to be the one to convert a
> text string to a value?
> 
> 
> It is. But the text string1+1is not a value expressed as text but
> a numerical expression in text form. And VALUE() does not undertake
> to evaluate such expressions.
> 
> 
> Is there another command, ...;
> 
> 
> What you need instead is the EVALUATE() function. (PS: It doesn't
> exist!)
> 
> 
> I think the fact that VALUE(1+1) entered as part of a formula does
> what it does is a lucky side effect. Clearly in this case LibreOffice
> is doing something similar to the automatic editing that is done when
> any material is entered into a spreadsheet cell. I'm talking about
> this sort of thing: when you type=+02(no quotes) into a cell
> formatted as Number, you see just 2. The1+1in this case is being
> entered into a cell (as part of a formula), not arising as the result
> of some calculation.
> 
> 
> As you mention, and as I found the evaluate command is what other 
> spreadsheets have that would seem to handle this, but libreoffice
> calc doesn't??
> 
> 
> Have just been playing with that GPS to Decimal problem, and was 
> trying to get a simplier process to do it.
> 
> 
> Have made a number of macros, that can do it just fine, but they have 
> long formulas. Was looking to do it with a set of regex commands.
> Commands did what I wanted, but can't get it to calculate the result..
> 
> 
> Best I've gotten So Far.
> Raw Data in column A
> 0315'090E
> Have a Macro that puts formula in column
> B=REGEX(REGEX(REGEX(REGEX(REGEX(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),,+),',/60+ot;),CHAR(34),/3600),[EN],),[OSW],*(-1))
> That creates the Forumula 03+15/60+090/3600
> But value in macro fails if put around it, and using value on the
> cell, or even a cell, where the data is copied fails. So, it is not
> being seen as a formula. Seems Value only works on a string that only
> contains digits and nothing else?? And as you said. LibreOffice
> doesn't have evaluate as others do.So, macro does what I want, but no
> way I've found to automatically get it to convert to the value. I can
> do the following steps to get the result I want. After running the
> macro I can manually do the following: F2,F9,CR,HOME,=,CR
> That puts the cell in edit mode, then F9 calculates it to the text
> formula and enter, the Home to go to the beginning, insert an = to
> convert it from a text cell to an actual format, and then enter to
> get the final result as digit values.
> 
> 
> But again, LibreOffice doesn't have the keypress option to add that.
> Other methods work fine, just was trying something different.
> Just thought there would be some kind of command to do it..
> 
> 
> Additionally, it probable is a flux that value(1+1) worked, probable
> does calculation first, and then sees nothing to convert. When it see
> as string, it probable checks for non-digits, and thus fails
> automatically..
> 
> 
> Thought there might be something else. Not an issue that effects me,
> but thought it would be interesting to figure out..
> 
> 
> Have a nice day and be safe..
> 
> 
> 
> 
> I trust this helps.
> 
> Brian Barker
> 
> 
> 
> 
> --
> 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] Question on value command and Err:502

[Michael D. Setzer II]

=On 24 Nov 2020 at 13:05, Brian Barker wrote:


Date sent:60;Tue, 24 Nov 2020 13:05:46 +
To:;=users@global.libreoffice.org
From:60;Brian Barker;b.m.bar...@btinternet.com
Subject:;Re: [libreoffice-users] Question on value command 
and Err:502


At 14:48 24/11/2020 +1000, Michael D. Setzer II wrote:
Put a more complex question, and got no responses yet.


You have to admit that your description and layout were pretty foggy!
Did anyone understand it?


So, here it is in simplest form
=value(1+1) converts the 1+1 to 2
But =value( ) fails with Err:502 if text1+1is used or if a cell
containing the text 1+1 is used??
I've looked thru command, and this seems to be the one to convert a
text string to a value?


It is. But the text string1+1is not a value expressed as text but
a numerical expression in text form. And VALUE() does not undertake
to evaluate such expressions.


Is there another command, ...;


What you need instead is the EVALUATE() function. (PS: It doesn't exist!)


I think the fact that VALUE(1+1) entered as part of a formula does
what it does is a lucky side effect. Clearly in this case LibreOffice
is doing something similar to the automatic editing that is done when
any material is entered into a spreadsheet cell. I'm talking about
this sort of thing: when you type=+02(no quotes) into a cell
formatted as Number, you see just 2. The1+1in this case is being
entered into a cell (as part of a formula), not arising as the result
of some calculation.


As you mention, and as I found the evaluate command is what other 
spreadsheets have that would seem to handle this, but libreoffice calc 
doesn't??


Have just been playing with that GPS to Decimal problem, and was 
trying to get a simplier process to do it.


Have made a number of macros, that can do it just fine, but they have 
long formulas. Was looking to do it with a set of regex commands.
Commands did what I wanted, but can't get it to calculate the result..


Best I've gotten So Far.
Raw Data in column A
0315'090E
Have a Macro that puts formula in column 
B=REGEX(REGEX(REGEX(REGEX(REGEX(INDIRECT(ADDRESS(ROW(),COLUMN()-1)),,+),',/60+ot;),CHAR(34),/3600),[EN],),[OSW],*(-1))
That creates the Forumula
03+15/60+090/3600
But value in macro fails if put around it, and using value on the cell, or even 
a 
cell, where the data is copied fails. So, it is not being seen as a formula. 
Seems 
Value only works on a string that only contains digits and nothing else?? And 
as 
you said. LibreOffice doesn't have evaluate as others do.So, macro does what I 
want, but no way I've found to automatically get it to 
convert to the value.
I can do the following steps to get the result I want.
After running the macro I can manually do the following:
F2,F9,CR,HOME,=,CR
That puts the cell in edit mode, then F9 calculates it to the text formula and 
enter, the Home to go to the beginning, insert an = to convert it from a text 
cell 
to an actual format, and then enter to get the final result as digit values.


But again, LibreOffice doesn't have the keypress option to add that.
Other methods work fine, just was trying something different.
Just thought there would be some kind of command to do it..


Additionally, it probable is a flux that value(1+1) worked, probable does 
calculation first, and then sees nothing to convert. When it see as string, it 
probable checks for non-digits, and thus fails automatically..


Thought there might be something else. Not an issue that effects me, but 
thought it would be interesting to figure out..


Have a nice day and be safe..




I trust this helps.

Brian Barker




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

[libreoffice-users] Question on value comand and Err:502

[Michael D. Setzer II]

Put a more complex question, and got no responses yet.
So, here it is in simplest form
=value(1+1)  converts the 1+1 to 2
But =value( ) fails with Err:502 is text "1+1" is used or i a cell 
containing the text 1+1 is used??
I've looked thru command, and this seems to be the one to convert a text 
string to a value? Is there another command, or am I doing something 
wrong?

Contents of a simple spreadsheet

2   "=value(1+1)
Err:502 "=VALUE("1+1")
"1+1TRUE=ISTEXT(A3)
Err:502 "=value(a3)


++
 Michael D. Setzer II - Computer Science Instructor (Retired) 
 mailto:mi...@guam.net
 mailto:msetze...@gmail.com
 Guam - Where America's Day Begins
 G4L Disk Imaging Project maintainer 
 http://sourceforge.net/projects/g4l/
++




-- 
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] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6

[Tom Williams]

On 10/2/20 7:55 AM, Tom Williams wrote:
> On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote:
>> Le 2020-10-01 01:13, Tom Williams a écrit :
>>> Hi!  A friend of mine sent me an Excel 365 spreadsheet to get my help to
>>> add a formula.  The spreadsheet is "simple", in that it had about 90
>>> rows of data, with only one column being a numeric value.  Everything
>>> else was plain text.  I added the formula (to sum the numbers in the one
>>> numeric column) and when I saved the file, in XLSX format, I noticed the
>>> file size was smaller.
>>>
>>> Here is what I found:
>>>
>>> Original file: 22kb
>>>
>>> Calc 6.4.6 on Ubuntu 20.04:  16kb
>>>
>>> Calc 5.1.6 (I think) on Mint 18.3:  9kb
>>>
>>> Why would saving the file in Calc reduce the file size?
>>>
>>> Thanks in advance!
>>>
>>> Peace...
>>>
>>> "The Other" Tom
>>>
>>> -- 
>>> /When I leave, I don't know what I'm hoping to find,
>>> And when I leave, I don't know what I'm leaving behind.../
>> Hello Tom
>>
>> A pleasure to have a librarian lol, well already the previous versions
>> of LibreOffice converted to Ms Office format are necessarily more
>> dancing in size as you have noticed, I will advise you to publish the
>> latest version of LibreOffice 7.0.1.2
>>
>> then to come back to your question I don't have a screenshot but I
>> send you mine which also shows a document at the base ods of 33.6 kiB
>> converted to xlsx format of 26.9 kiB but when you look at the content
>> level the xlsx version is in excel zip so compressed at the base where
>> the xlsx size will be smaller than the ods version in size because it
>> is compressed at the source.
>>
>> I hope to have answered your concern if not please specify your
>> question to me with screenshots so that I understand well why it is
>> not a question.
>>
>> cordially
>> Sandra LOUVEZO
> Thanks for the reply!  I'll try LibreOffice 7 and see what happens. I
> think I have it installed in a virtual Windows 10 environment I
> sometimes use.
>
> Thanks!
>
> Peace...
>
> "The Other" Tom
>
So, I tried this in LibreOffice 7.0.1 on Windows 10 and found the
spreadsheet saved to a file size of 17kb.    This isn't a "problem" or
anything and I was mostly curious about the difference in file size.  :)

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6

[sandralouve]

Le 2020-10-01 01:13, Tom Williams a écrit :
Hi!  A friend of mine sent me an Excel 365 spreadsheet to get my help 
to

add a formula.  The spreadsheet is "simple", in that it had about 90
rows of data, with only one column being a numeric value.  Everything
else was plain text.  I added the formula (to sum the numbers in the 
one
numeric column) and when I saved the file, in XLSX format, I noticed 
the

file size was smaller.

Here is what I found:

Original file: 22kb

Calc 6.4.6 on Ubuntu 20.04:  16kb

Calc 5.1.6 (I think) on Mint 18.3:  9kb

Why would saving the file in Calc reduce the file size?

Thanks in advance!

Peace...

"The Other" Tom

--
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../


Hello Tom

A pleasure to have a librarian lol, well already the previous versions 
of LibreOffice converted to Ms Office format are necessarily more 
dancing in size as you have noticed, I will advise you to publish the 
latest version of LibreOffice 7.0.1.2


then to come back to your question I don't have a screenshot but I send 
you mine which also shows a document at the base ods of 33.6 kiB 
converted to xlsx format of 26.9 kiB but when you look at the content 
level the xlsx version is in excel zip so compressed at the base where 
the xlsx size will be smaller than the ods version in size because it is 
compressed at the source.


I hope to have answered your concern if not please specify your question 
to me with screenshots so that I understand well why it is not a 
question.


cordially
Sandra LOUVEZO

--
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] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6

[Tom Williams]

On 10/2/20 7:32 AM, sandralo...@vivaldi.net wrote:
> Le 2020-10-01 01:13, Tom Williams a écrit :
>> Hi!  A friend of mine sent me an Excel 365 spreadsheet to get my help to
>> add a formula.  The spreadsheet is "simple", in that it had about 90
>> rows of data, with only one column being a numeric value.  Everything
>> else was plain text.  I added the formula (to sum the numbers in the one
>> numeric column) and when I saved the file, in XLSX format, I noticed the
>> file size was smaller.
>>
>> Here is what I found:
>>
>> Original file: 22kb
>>
>> Calc 6.4.6 on Ubuntu 20.04:  16kb
>>
>> Calc 5.1.6 (I think) on Mint 18.3:  9kb
>>
>> Why would saving the file in Calc reduce the file size?
>>
>> Thanks in advance!
>>
>> Peace...
>>
>> "The Other" Tom
>>
>> -- 
>> /When I leave, I don't know what I'm hoping to find,
>> And when I leave, I don't know what I'm leaving behind.../
>
> Hello Tom
>
> A pleasure to have a librarian lol, well already the previous versions
> of LibreOffice converted to Ms Office format are necessarily more
> dancing in size as you have noticed, I will advise you to publish the
> latest version of LibreOffice 7.0.1.2
>
> then to come back to your question I don't have a screenshot but I
> send you mine which also shows a document at the base ods of 33.6 kiB
> converted to xlsx format of 26.9 kiB but when you look at the content
> level the xlsx version is in excel zip so compressed at the base where
> the xlsx size will be smaller than the ods version in size because it
> is compressed at the source.
>
> I hope to have answered your concern if not please specify your
> question to me with screenshots so that I understand well why it is
> not a question.
>
> cordially
> Sandra LOUVEZO

Thanks for the reply!  I'll try LibreOffice 7 and see what happens. I
think I have it installed in a virtual Windows 10 environment I
sometimes use.

Thanks!

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Question about saving Excel 365 (.xlsx) files in LibreOffice Calc 6.4.6

[Tom Williams]

Hi!  A friend of mine sent me an Excel 365 spreadsheet to get my help to
add a formula.  The spreadsheet is "simple", in that it had about 90
rows of data, with only one column being a numeric value.  Everything
else was plain text.  I added the formula (to sum the numbers in the one
numeric column) and when I saved the file, in XLSX format, I noticed the
file size was smaller.

Here is what I found:

Original file: 22kb

Calc 6.4.6 on Ubuntu 20.04:  16kb

Calc 5.1.6 (I think) on Mint 18.3:  9kb

Why would saving the file in Calc reduce the file size?

Thanks in advance!

Peace...

"The Other" Tom

-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Question about libreoffice

[Italo Vignoli]

You can find the procedure to install LibreOffice on your Chromebook in
this article: https://linuxhint.com/install_linux_apps_chromebook/.

As an alternative, you can install LibreOffice using Flatpack, which is
described in this article: https://flatpak.org/setup/Chrome%20OS/.

I hope this helps. Best regards.

On 9/5/20 11:15 PM, Daniel SOUSA PAULO CASIMIRO wrote:
> I have Chrome Os and I want what can I do to install libreoffice?
> 

-- 
Italo Vignoli - LibreOffice Marketing & PR
mobile/signal +39.348.5653829 - email it...@libreoffice.org
hangout/jabber italo.vign...@gmail.com - skype italovignoli
GPG Key ID - 0xAAB8D5C0
DB75 1534 3FD0 EA5F 56B5 FDA6 DE82 934C AAB8 D5C0

-- 
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] Question about libreoffice

[Daniel SOUSA PAULO CASIMIRO]

I have Chrome Os and I want what can I do to install libreoffice?

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

[fudmier]

On my linux 16.04 box .. each time i perform any function that involves 
switching between tabs, or between certain activities within the same A
tab my computer goes into Oh shit mode.. it disables my keyboard 
activity, and the disk goes to spinning,, the background of the 
spreadsheet goes into grey mode, and it sometimes takes two or three 
minutes before the full control reappears and the background returns 
back from greyed out to white again.



is this this has been going on since last November.. but it has reached 
epidemic proportions .. and has rendered Libre office useless on my machine



--
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] Question about signed documents

[Joshua Kramer]

QWhat's interesting about this is you can use a a smartcard to sign your
documents.  Libreoffice supports standard PIV smart cards (at least under
Linux).  If you have everything configured right, you can use an x509 that
is resident on the smart card to sign the document.  This can provide much
higher security, especially if the smart card is configured with a PIN.

Also keep in mind that the document is not "read only" with the signature.
It is completely possible to open a signed document, not realize it's
signed, accidentally insert a period somewhere, and resave it.  As soon as
you modify a signed document the signature is dropped.

On Thu, Jan 31, 2019, 12:08 PM James Knott  On 01/31/2019 11:54 AM, Tom Williams wrote:
> > Now, this is interesting.  So, the digital signing you describe would
> > generate a digital version of my signature?  I have experience with
> > digitally signing a document, using a third party service, like
> > DocuSign.  In those cases, a "signature" font is used to represent my
> > actual signature.  I initially though the digital signing LibreOffice
> > supported added a digital signature to the document, itself, providing
> > some verification that I am who I claim to be.  Does it also add the
> > signature, in the manner you describe?
>
> No, it doesn't generate a digital version of your signature.  It uses a
> process, related to encryption, to generate a signature of the entire
> document, that verifies it could have only come from you.  This is
> commonly done with X.509 digital certificates, which are traceable back
> to some top level certificate authority.  As an example of a bank
> perhaps, they'd issue you your own public/private keys, which could be
> traced back to the bank and to the top level authority beyond.  Since
> that signature couldn't possibly have come from anyone else, it is your
> signature.
>
> You may want to read up on how public/private key encryption works and
> X.509 certificates.
>
> https://en.wikipedia.org/wiki/X.509
>
> --
> 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
>

On Thu, Jan 31, 2019, 12:08 PM James Knott  On 01/31/2019 11:54 AM, Tom Williams wrote:
> > Now, this is interesting.  So, the digital signing you describe would
> > generate a digital version of my signature?  I have experience with
> > digitally signing a document, using a third party service, like
> > DocuSign.  In those cases, a "signature" font is used to represent my
> > actual signature.  I initially though the digital signing LibreOffice
> > supported added a digital signature to the document, itself, providing
> > some verification that I am who I claim to be.  Does it also add the
> > signature, in the manner you describe?
>
> No, it doesn't generate a digital version of your signature.  It uses a
> process, related to encryption, to generate a signature of the entire
> document, that verifies it could have only come from you.  This is
> commonly done with X.509 digital certificates, which are traceable back
> to some top level certificate authority.  As an example of a bank
> perhaps, they'd issue you your own public/private keys, which could be
> traced back to the bank and to the top level authority beyond.  Since
> that signature couldn't possibly have come from anyone else, it is your
> signature.
>
> You may want to read up on how public/private key encryption works and
> X.509 certificates.
>
> https://en.wikipedia.org/wiki/X.509
>
> --
> 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] Question about signed documents

[James Knott]

On 01/31/2019 11:54 AM, Tom Williams wrote:
> Now, this is interesting.  So, the digital signing you describe would
> generate a digital version of my signature?  I have experience with
> digitally signing a document, using a third party service, like
> DocuSign.  In those cases, a "signature" font is used to represent my
> actual signature.  I initially though the digital signing LibreOffice
> supported added a digital signature to the document, itself, providing
> some verification that I am who I claim to be.  Does it also add the
> signature, in the manner you describe?

No, it doesn't generate a digital version of your signature.  It uses a
process, related to encryption, to generate a signature of the entire
document, that verifies it could have only come from you.  This is
commonly done with X.509 digital certificates, which are traceable back
to some top level certificate authority.  As an example of a bank
perhaps, they'd issue you your own public/private keys, which could be
traced back to the bank and to the top level authority beyond.  Since
that signature couldn't possibly have come from anyone else, it is your
signature.

You may want to read up on how public/private key encryption works and
X.509 certificates.

https://en.wikipedia.org/wiki/X.509

-- 
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] Question about signed documents

[James Knott]

On 01/31/2019 11:50 AM, Tom Williams wrote:
> The reason I asked is, I've never considered the need to digitally
> sign a document I created or modified in LibreOffice.

At least one bank I'm aware of allows digital signing of documents.  So,
you might download a form to open an account, take out a loan, etc. fill
it out and digitally sign it.

Also, think about the current practice of many lawyers and other
professionals, who still fax documents.  It would be far more secure
than any fax could be.  In fact, given how easy it is to edit scanned
images, spoof phone numbers, etc., there's no way fax can be considered
secure these days.  Yet, people still use them.


-- 
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] Question about signed documents

[Tom Williams]

On 1/31/19 7:50 AM, James Knott wrote:

On 01/31/2019 10:33 AM, Tom Williams wrote:

Hi!  I recently learned LibreOffice 6 supports PGP signed documents.
My question:  why would anyone want to digitally sign a document?

When you take out a loan, etc., don't you sign the document?  There are
many times you sign things.  This is just  a digital way to verify you
did.  Without this, you'd have to print out the document, sign it and
then get it to the recipient.  With digital signing, you digitally sign
it and then can email it, right from LibreOffice.

Now, this is interesting.  So, the digital signing you describe would 
generate a digital version of my signature?  I have experience with 
digitally signing a document, using a third party service, like 
DocuSign.  In those cases, a "signature" font is used to represent my 
actual signature.  I initially though the digital signing LibreOffice 
supported added a digital signature to the document, itself, providing 
some verification that I am who I claim to be.  Does it also add the 
signature, in the manner you describe?


Thanks!

Peace...

"The Other" Tom


--
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

--
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] Question about signed documents

[Tom Williams]

On 1/31/19 7:38 AM, hy...@lactose.homelinux.net wrote:

Tom Williams writes:

why would anyone want to digitally sign a document?

The two most obvious answers are:

(*) confirm authorship
(*) verify integrity of contents

I'm sure there are plenty of other reasons as well.


Thanks for the reply.  :)   The reason I asked is, I've never considered 
the need to digitally sign a document I created or modified in 
LibreOffice.  So, I was wondering why anyone would want to do so.  Your 
examples make sense.


Peace...

"The Other" Tom

--
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

--
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] Question about signed documents

[James Knott]

On 01/31/2019 10:33 AM, Tom Williams wrote:
> Hi!  I recently learned LibreOffice 6 supports PGP signed documents. 
> My question:  why would anyone want to digitally sign a document?

When you take out a loan, etc., don't you sign the document?  There are
many times you sign things.  This is just  a digital way to verify you
did.  Without this, you'd have to print out the document, sign it and
then get it to the recipient.  With digital signing, you digitally sign
it and then can email it, right from LibreOffice.



-- 
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] Question about signed documents

[hymie]

Tom Williams writes:
>why would anyone want to digitally sign a document?

The two most obvious answers are:

(*) confirm authorship
(*) verify integrity of contents

I'm sure there are plenty of other reasons as well.

--hymie! http://lactose.homelinux.net/~hymiehy...@lactose.homelinux.net

-- 
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] Question about signed documents

[Tom Williams]

Hi!  I recently learned LibreOffice 6 supports PGP signed documents.  My 
question:  why would anyone want to digitally sign a document?


Peace...

"The Other" Tom

--
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

--
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] Question about Installation glitch upgrading from LO 5.x to LO 6.0.6.2

[David B Teague sr]

Hi LibreOffice Users:

My system:
64 bit Windows 7 Home Premium
LibreOffice 6.0.6.2
off line help for LO 6.0.6

Installation glitch upgrading from LO 5.x to LO 6.0.6.2

Started Installer, process displayed UAC dialog.  I answered "Yes"

Installer proceeded up to a point, then failed, stating the installer 
did not have sufficient privilege to access C:\Program Files\LibreOffice


I clicked "retry" several times to no avail, then backed out. A retry 
also failed. In casting about for a solution, I happened to reboot.


Then I recalled that inaccessible files are sometimes removed or made 
accessible after a reboot. I retried installation, LO 6.0.6.2 installed 
quickly along with off line help


My Question: Should I have known this might or would occur?  And could 
this glitch have been predicted and users warned?


Warmest Regard
David Teague

--
nil significat nisi oscillat
do wop, do wop, do wop! -- Duke Ellington



--
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] Question about tables and page margins in Writer

[Tom Williams]

Thanks for the tip!  I'll give it a try.

Peace...

"The Other" Tom

On 08/12/2018 03:41 PM, Remy Gauthier wrote:
> Hi,
>
> You could insert a 1-inch header that is empty. You can alter the page
> style or directly format the page:
>
> Format -> Page -> Header, then:
>
> - Header ON
> - Autofit height: OFF
> - Height: 1 inch
>
> Note that I am using LO 6.0, so it might be slightly different for you
> but I think that those settings will work in your version.
>
> I hope this helps.
>
> Rémy.
> Le dimanche 12 août 2018 à 13:40 -0700, Tom a écrit :
>> Hi!  I'm running Writer 5.1.6.2 on Linux Mint 18 and had a question
>> about tables and page margins.  I'm creating a playlist in Writer and
>> have an image filling the entire background of the page.  I have 0
>> margins so the image covers all available whitespace.  I have a table
>> with a header row that repeats on each page.  Everything looks fine
>> except when the table spills over to page #2.  The header row is
>> repeated but the top of the table is flush against the top of the page. 
>> I would like a 1", maybe, gap between the top of the table, on page #2,
>> and the top of the page.
>>
>> Any idea on how to accomplish this?
>>
>> Thanks!
>>
>> Peace...
>>
>> "The Other" Tom
>>
>>


-- 
/When I leave, I don't know what I'm hoping to find,
And when I leave, I don't know what I'm leaving behind.../

-- 
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] Question about tables and page margins in Writer

[Remy Gauthier]

Hi,

You could insert a 1-inch header that is empty. You can alter the page
style or directly format the page:

Format -> Page -> Header, then:

- Header ON
- Autofit height: OFF
- Height: 1 inch

Note that I am using LO 6.0, so it might be slightly different for you
but I think that those settings will work in your version.

I hope this helps.

Rémy.
Le dimanche 12 août 2018 à 13:40 -0700, Tom a écrit :
> Hi!  I'm running Writer 5.1.6.2 on Linux Mint 18 and had a question
> about tables and page margins.  I'm creating a playlist in Writer and
> have an image filling the entire background of the page.  I have 0
> margins so the image covers all available whitespace.  I have a table
> with a header row that repeats on each page.  Everything looks fine
> except when the table spills over to page #2.  The header row is
> repeated but the top of the table is flush against the top of the page. 
> I would like a 1", maybe, gap between the top of the table, on page #2,
> and the top of the page.
> 
> Any idea on how to accomplish this?
> 
> Thanks!
> 
> Peace...
> 
> "The Other" Tom
> 
> 
-- 
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] Question about tables and page margins in Writer

[Tom]

Hi!  I'm running Writer 5.1.6.2 on Linux Mint 18 and had a question
about tables and page margins.  I'm creating a playlist in Writer and
have an image filling the entire background of the page.  I have 0
margins so the image covers all available whitespace.  I have a table
with a header row that repeats on each page.  Everything looks fine
except when the table spills over to page #2.  The header row is
repeated but the top of the table is flush against the top of the page. 
I would like a 1", maybe, gap between the top of the table, on page #2,
and the top of the page.

Any idea on how to accomplish this?

Thanks!

Peace...

"The Other" Tom


-- 
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] Question about document/template interaction

[leleu]

I think I read once about

Something as

 * Save the file under another name (to be sure not to loose it).
 * Open again and delete any content.
 * Save as a (new) template.


Je la 31/03/2018 21:29, anne-ology skribis :

Here's hoping you'll receive a response soon;
   I wish I could help, but I don't know any thing(s) which might
solve your issue.

Surely somebody on this list can help you, I've been awaiting a
response to my query, & still waiting with hopefulness.




From: John Herron <paradox.her...@bluewin.ch>
Date: Mon, Mar 26, 2018 at 12:09 PM
Subject: [libreoffice-users] Question about document/template interaction
To: users@global.libreoffice.org


LibreOffice 5.1.6.2 / 5.3.5.2 on Linux Lite.

I wrote a document based on a specific template.
As I did so, I added four new styles to the document.

Is there a way to automatically incorporate these new styles into the
specific template,
such that when I create a new document based on it, the new styles will be
included in it?

Thanks for helping.

John Herron



--
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Question about document/template interaction

[anne-ology]

   Here's hoping you'll receive a response soon;
  I wish I could help, but I don't know any thing(s) which might
solve your issue.

   Surely somebody on this list can help you, I've been awaiting a
response to my query, & still waiting with hopefulness.




From: John Herron <paradox.her...@bluewin.ch>
Date: Mon, Mar 26, 2018 at 12:09 PM
Subject: [libreoffice-users] Question about document/template interaction
To: users@global.libreoffice.org


LibreOffice 5.1.6.2 / 5.3.5.2 on Linux Lite.

I wrote a document based on a specific template.
As I did so, I added four new styles to the document.

Is there a way to automatically incorporate these new styles into the
specific template,
such that when I create a new document based on it, the new styles will be
included in it?

Thanks for helping.

John Herron

-- 
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Question about document/template interaction

[Brian Barker]

At 19:09 26/03/2018 +0200, John Herron wrote:
I wrote a document based on a specific template. As I did so, I 
added four new styles to the document. Is there a way to 
automagically incorporate these new styles into the specific 
template, such that when I create a new document based on it, the 
new styles will be included in it?


o Open the document.
o Delete all its text (or as much of it as appropriate).
o Save the denuded document (but still containing its styles) as a 
template - presumably over the existing one.


Alternatively, you can import styles from one document to another - 
in this case from your existing document to a new document intended 
to become your template - using the Load Styles facility, accessible 
from the drop-down menu from the New Style from Selection button in 
the Styles and Formatting window.


I trust this helps.

Brian Barker


--
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/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Question about document/template interaction

[John Herron]

LibreOffice 5.1.6.2 / 5.3.5.2 on Linux Lite.

I wrote a document based on a specific template.
As I did so, I added four new styles to the document.

Is there a way to automagically incorporate these new styles into the specific 
template,
such that when I create a new document based on it, the new styles will be 
included in it?

Thanks for helping.

John Herron


--
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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] question about recieving proffessional support and helping you:

[Regina Henschel]

Hi Zahra,

you will find a lot of answers in our Wiki.

zahra a schrieb:

hello every one.
i have some questions about proffessional support from developers.
how we can contact them?


https://www.libreoffice.org/get-help/professional-support/

Besides the phone numbers given there, you can contact a lot of 
professional developers on IRC, see 
https://wiki.documentfoundation.org/Website/IRC



how we should pay the money for resolving specific bug?
and how many dollars we should pay for this?


That depends on the kind of support you are looking for and on the contract.


is it possible to developers fix for us specific bug in our desire version?


Yes. It is open source and you can alter it to your needs.


and do other people benefit from the new patch for solving bug?
or if its not, how we can download our desire version with our desire fix?


The community hopes to get such patches, but there is no legal 
requirement. If you will redistribute the version, you have to respect 
the license.



and also is it possible that all people who know programming,
contribute codes and fixes to your program?


Of cause! That is how open source works. Please look at the section 
"Getting started with development" on 
https://wiki.documentfoundation.org/Development



is there any condition required for accepting there codes?


Yes, you have to mail a license statement.


is it possible even for novice programmers?


Yes.


i sincerely appreciate your help and God bless you all.


Is this a general question about open source, or do you have a special 
concern?


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] question about recieving proffessional support and helping you:

[zahra a]

hello every one.
i have some questions about proffessional support from developers.
how we can contact them?
how we should pay the money for resolving specific bug?
and how many dollars we should pay for this?
is it possible to developers fix for us specific bug in our desire version?
and do other people benefit from the new patch for solving bug?
or if its not, how we can download our desire version with our desire fix?
and also is it possible that all people who know programming,
contribute codes and fixes to your program?
is there any condition required for accepting there codes?
is it possible even for novice programmers?
i sincerely appreciate your help and God bless you all.
-- 
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] question about navigator.

[zahra a]

hello every one.
i have a question which its answer is very essential and the problem
is very critical for me.
if  i use libreoffice 5.0 and 5.1, after exiting on windows xp,
libreoffice crashes!
i read bugzilla and found that they told this problem occure when
sidebar is active.
i unchecked sidebar and it did not resolve problem for me.
i myself discovered the solution!
and i wish that developers also read.
if they dont read, i appreciate you if you send this for them.
the solution is navigator should always be checked.
i discovered it and activated it and the problem is completely resolved.
but unfortunately i missed my settings and i dont remember what i did.
now, i go to the view menu and press enter on navigation button and it
becomes activated.
after i close libreoffice, the program again crashes and navigator its
still unchecked!
what should i do to navigator be checked and activated for me forever?
i sincerely appreciate you and pray for you request divine infinite
mercy in my five times obligatory every day prayers.

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

Re: [libreoffice-users] Question on wildcards

[Rob Jasper]

OK-

I created 1 tab with all years concatenated, and replaced the 'year-sheets' to 
select from the main concatenated list.

Thanks to all for the reactions.

Rob.

On 6 feb. 2017, at 13:48, Bruce Hohl wrote:

> For more compactness, maybe you could create a maxifs() pointed to each
> sheet then a maxifs() against those maxifs() results.  I agree with Brian
> on the point of keeping all data in one sheet if practical.  With that
> approach it's still possible to have separate tabs for each year for the
> analysis and calculation.
> 
> On Sun, Feb 5, 2017 at 7:03 PM, Brian Barker 
> wrote:
> 
>> At 22:46 05/02/2017 +0100, Rob Jasper wrote:
>> 
>>> I am looking for a way to use MAXIFS over the equivalent ranges in
>>> multiple tabs. Something like:
>>> =COUNTIF('2*'.E$2:E$200;C2)
>>> Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004,
>>> etc.), range E2:E200 give me the number of occurrences of the value define
>>> in C2. Is this at all possible?
>>> 
>> 
>> A simple workaround is to assemble copies of the relevant ranges from
>> multiple sheets on a single summary sheet. (After all, the value you are
>> trying to derive definitely relates to the data generally, not to any
>> specific year.) Then the function reference is simple. Instead of simply
>> copying values, you will want to create formulae in the summary sheet to
>> harvest values from the individual sheets. That way, the values on the
>> summary sheet will automatically update as you work on the individual
>> sheets.
>> 
>> Or you could use one sheet instead of multiple, yearly sheets in the first
>> place. After all, 1 January 2003 comes as soon after 31 December 2002 as 31
>> December 2002 did after 30 December 2002. Contrary to the theories of some
>> partygoers, nothing particularly discontinuous happens to time at the new
>> year!
>> 
>> I trust this helps.
>> 
>> Brian Barker
>> 
>> 
>> 
>> --
>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
>> ubscribe/
>> 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


-- 
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] Question on wildcards

[Bruce Hohl]

For more compactness, maybe you could create a maxifs() pointed to each
sheet then a maxifs() against those maxifs() results.  I agree with Brian
on the point of keeping all data in one sheet if practical.  With that
approach it's still possible to have separate tabs for each year for the
analysis and calculation.

On Sun, Feb 5, 2017 at 7:03 PM, Brian Barker 
wrote:

> At 22:46 05/02/2017 +0100, Rob Jasper wrote:
>
>> I am looking for a way to use MAXIFS over the equivalent ranges in
>> multiple tabs. Something like:
>> =COUNTIF('2*'.E$2:E$200;C2)
>> Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004,
>> etc.), range E2:E200 give me the number of occurrences of the value define
>> in C2. Is this at all possible?
>>
>
> A simple workaround is to assemble copies of the relevant ranges from
> multiple sheets on a single summary sheet. (After all, the value you are
> trying to derive definitely relates to the data generally, not to any
> specific year.) Then the function reference is simple. Instead of simply
> copying values, you will want to create formulae in the summary sheet to
> harvest values from the individual sheets. That way, the values on the
> summary sheet will automatically update as you work on the individual
> sheets.
>
> Or you could use one sheet instead of multiple, yearly sheets in the first
> place. After all, 1 January 2003 comes as soon after 31 December 2002 as 31
> December 2002 did after 30 December 2002. Contrary to the theories of some
> partygoers, nothing particularly discontinuous happens to time at the new
> year!
>
> I trust this helps.
>
> Brian Barker
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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: [libreoffice-users] Question on wildcards

[Brian Barker]

At 22:46 05/02/2017 +0100, Rob Jasper wrote:
I am looking for a way to use MAXIFS over the equivalent ranges in 
multiple tabs. Something like:

=COUNTIF('2*'.E$2:E$200;C2)
Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004, 
etc.), range E2:E200 give me the number of occurrences of the value 
define in C2. Is this at all possible?


A simple workaround is to assemble copies of the relevant ranges from 
multiple sheets on a single summary sheet. (After all, the value you 
are trying to derive definitely relates to the data generally, not to 
any specific year.) Then the function reference is simple. Instead of 
simply copying values, you will want to create formulae in the 
summary sheet to harvest values from the individual sheets. That way, 
the values on the summary sheet will automatically update as you work 
on the individual sheets.


Or you could use one sheet instead of multiple, yearly sheets in the 
first place. After all, 1 January 2003 comes as soon after 31 
December 2002 as 31 December 2002 did after 30 December 2002. 
Contrary to the theories of some partygoers, nothing particularly 
discontinuous happens to time at the new year!


I trust this helps.

Brian Barker


--
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] Question on wildcards

[Rob]

Hi,

I am looking for a way to use MAXIFS over the equivalent ranges in multiple 
tabs. 
Something like:

=COUNTIF(‘2*'.E$2:E$200;C2)

Explanation: For all ranges in tabs with name 2.* (2002, 2003, 2004, etc.), 
range E2:E200 give me the number of occurrences of the value define in C2

Is this at all possible?


-- 
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] Question about Dialog Component Example in API examples

[Adrian Alvarado Ramírez]

Good morning,

The example links "Dialog Component Example", in the API example page (
http://api.libreoffice.org/examples/DevelopersGuide/examples.html#BasicandDialogs)
are broken. Mi question is:  there are changes in the API, and these
examples will be restored, or this functionality will not be supported
anymore?

Thank you in advance for the help,

-- 
*Ing. Adrián Alvarado Ramírez*
*Ingenierio en Ciencias de la Computación e Informática*
*Carné 7091*

-- 
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] Question about .docx password security in libre office.

[Jeffrey Deutsch]

A addendum: Does the answer change for documents saved in .doc format?

Jeff Deutsch
Speaker & Life Coach
A SPLINT - ASPies LInking with NTs
http://www.asplint.com

"Listen to the universe while it whispers before it has to shout."
Marion Grobb Finkelstein, Communication Catalyst --
http://www.MarionSpeaks.com

On Tue, Aug 2, 2016 at 4:01 PM, Vladimir 
wrote:

> Hi,
>
> I use Libre Office regularly and for compatibility with my friends I save
> documents in .docx format with a password.
>
> I use Libre Office Version: 5.1.4.2
>
> Do Libre Office protect password encrypted .docx documents with 128-bit key
> AES protection when the .docx documents are made with Libre Office and not
> with Microsoft Office ?
>
> Thanks in advance for your answer.
> Vladimir.
>
> --
> 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] Question about .docx password security in libre office.

[Vladimir]

Hi,

I use Libre Office regularly and for compatibility with my friends I save
documents in .docx format with a password.

I use Libre Office Version: 5.1.4.2

Do Libre Office protect password encrypted .docx documents with 128-bit key
AES protection when the .docx documents are made with Libre Office and not
with Microsoft Office ?

Thanks in advance for your answer.
Vladimir.

-- 
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] Question About Trojan Detection

[nasrin khaksar]

hi.
i read in one website if i am not make a mistake in libreofficeportable.org
that avast anti virus for its poor detection of trogens recognizes
libreoffice as trogen!

On 6/3/16, Tanstaafl  wrote:
> On 6/3/2016 11:13 AM, Joel Madero  wrote:
>> It'd be great if you inform McAfee about this - they consistently seem
>> to have issues with over aggressive detections that mislead users.
>
> Not to mention the fact that it misses lots of real threats.
>
> Anyone who uses Mcafee or Norton should rethink their decision.
>
> --
> 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
>


-- 
Those who follow the Messenger-Prophet, the Ummi, whom they find
written down with them in the Taurat and the Injeel [who] enjoins them
good and forbids them evil, and makes lawful to them the good things
and makes unlawful to them impure things, and removes from them their
burden and the shackles which were upon them; so [as for] those who
believe in him and honor him and help him, and follow the light which
has been sent down with him, these it is that are the successful.
holy quran, chapter 7, verse 157.
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

RE: [libreoffice-users] Question About Trojan Detection

[Jerry Greenberg]

Hi,

I will be doing that.  I found out early this morning the same as you are 
mentioning. This is frightening, especially if you are dependent on the 
computer for your family and work. 

Thanks! 

Jerry Greenberg



-Original Message-
From: Joel Madero [mailto:jmadero@gmail.com] 
Sent: Friday, June 03, 2016 11:14
To: Jerry Greenberg <jerry...@total.net>; users@global.libreoffice.org
Subject: Re: [libreoffice-users] Question About Trojan Detection

It'd be great if you inform McAfee about this - they consistently seem to have 
issues with over aggressive detections that mislead users.

Best,

Joel

On 6/3/2016 12:27 AM, Jerry Greenberg wrote:
>
> I downloaded Libre Office on two computers.
>
> McAfee Scan picked up "RDN/Generic Downloader.x"
>
> Download Site:
> http://www.libreoffice.org/download/libreoffice-fresh/
>
>
> The Explanation of the Trojan:
> http://www.mcafee.com/threat-intelligence/malware/default.aspx?id=2175
> 696
>
>
> Thanks!
>


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


-- 
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] Question About Trojan Detection

[Tanstaafl]

On 6/3/2016 11:13 AM, Joel Madero  wrote:
> It'd be great if you inform McAfee about this - they consistently seem 
> to have issues with over aggressive detections that mislead users.

Not to mention the fact that it misses lots of real threats.

Anyone who uses Mcafee or Norton should rethink their decision.

-- 
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] Question About Trojan Detection

[Joel Madero]

It'd be great if you inform McAfee about this - they consistently seem 
to have issues with over aggressive detections that mislead users.


Best,

Joel

On 6/3/2016 12:27 AM, Jerry Greenberg wrote:


I downloaded Libre Office on two computers.

McAfee Scan picked up "RDN/Generic Downloader.x"

Download Site:
http://www.libreoffice.org/download/libreoffice-fresh/


The Explanation of the Trojan:
http://www.mcafee.com/threat-intelligence/malware/default.aspx?id=2175696


Thanks!




---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


--
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] Question About Trojan Detection

[Tom Davies]

Hi :)
It's another false-positive.
Regards from
Tom :)

On 3 June 2016 at 08:27, Jerry Greenberg  wrote:

>
> I downloaded Libre Office on two computers.
>
> McAfee Scan picked up "RDN/Generic Downloader.x"
>
> Download Site:
> http://www.libreoffice.org/download/libreoffice-fresh/
>
>
> The Explanation of the Trojan:
> http://www.mcafee.com/threat-intelligence/malware/default.aspx?id=2175696
>
>
> Thanks!
>
> --
>
> Jerry Greenberg
>
>
> --
> 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] Question About Trojan Detection

[Jerry Greenberg]

I downloaded Libre Office on two computers.

McAfee Scan picked up "RDN/Generic Downloader.x"

Download Site:
http://www.libreoffice.org/download/libreoffice-fresh/


The Explanation of the Trojan:
http://www.mcafee.com/threat-intelligence/malware/default.aspx?id=2175696


Thanks!

--

Jerry Greenberg


--
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] question about "Binary URP bridge disposed during call" error

[Stephan Bergmann]

On 03/04/2016 08:00 PM, Shawn Cao wrote:

I am wondering why "m_xDesktop->loadComponentFromURL()" sometimes get stuck and 
how to generate debugging information when it get stuck?


Debugging a "got stuck" situation is relatively easy: attach a debugger 
to the stuck process, generate backtraces for all its threads, and 
analyze from there.


--
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] question about "Binary URP bridge disposed during call" error

[Shawn Cao]

Hi Stephan,

I redo the batch testing and you are right: my program killed soffice.bin after 
waiting 2 minutes and can't open 
a file for printing through  "m_xDesktop->loadComponentFromURL()". And the 
function then throw a "Binary URP bridge disposed during call" exception.  (And 
no LibreOffice crash happen for my new printing program. )

This issue happened randomly and most of the time the same file can be opened 
correctly.  

Basically, the testing case is to start soffice.bin and print 10 files then 
close it. The testing case will be repeated thousands time. 
If I restart soffice.bin every time a printing job finished, 
"loadComponentFromURL()" always return quickly. 

I am wondering why "m_xDesktop->loadComponentFromURL()" sometimes get stuck and 
how to generate debugging information when it get stuck?
  
Best Regards,

Shawn

-Original Message-
From: Stephan Bergmann [mailto:sberg...@redhat.com] 
Sent: Wednesday, February 24, 2016 6:40 AM
To: Shawn Cao <s...@printeron.com>; users@global.libreoffice.org
Subject: Re: [libreoffice-users] question about "Binary URP bridge disposed 
during call" error

On 02/23/2016 03:18 PM, Shawn Cao wrote:
> Because each testing will open and close LibreOffice, I am not sure 
> how to attach WinDbg with those evanescent processes. Fortunately, 
> Windows will generate dump file for each LibreOffice crash. I open 
> dump file with WinDbg and please refer to attachment for the trace 
> result. I tested 5.1.1.1 and will test latest Dev version soon.

> STACK_TEXT:
> 00e7f2e8 76c23fc8 kernelbase!RaiseException+0x48
> 00e7f348 6a0f9339 msvcr120!_CxxThrowException+0x5b
> 00e7f388 659c020c 
> ucbhelper!com::sun::star::ucb::UniversalContentBroker::create+0x16c
> 00e7f3ec 659b9d36 ucbhelper!ucbhelper::Content::Content+0x46
> 00e7f424 6766a40f mergedlo!`anonymous namespace'::content+0x6f 
> 00e7f45c 67669ec3 mergedlo!utl::UCBContentHelper::Kill+0x73
> 00e7f4c8 66b0ab84 
> mergedlo!desktop::Desktop::RemoveTemporaryDirectory+0x14
> 00e7f4d0 66b0780d mergedlo!desktop::Desktop::doShutdown+0x21d
> 00e7f520 66b025fc mergedlo!desktop::Desktop::Main+0xe3c
> 00e7f69c 67a05886 mergedlo!ImplSVMain+0x46
> 00e7f6c4 67a05c39 mergedlo!SVMain+0x29
> 00e7f6d0 66b1c599 mergedlo!soffice_main+0x79
> 00e7f740 0018101e soffice+0x101e
> 00e7f794 768b3744 kernel32!BaseThreadInitThunk+0x24
> 00e7f7a8 771b9e54 ntdll!__RtlUserThreadStart+0x2f
> 00e7f7f0 771b9e1f ntdll!_RtlUserThreadStart+0x1b

Hm, that's rather odd.

For one, this crash is during "clean" termination of the soffice.bin process, 
i.e., at a time when your external code should no longer communicate with the 
soffice.bin process anyway.  (Or is your external code designed in a way that 
it might call com.sun.star.frame.XDesktop.terminate while some printing 
activity is still in progress?)

For another, I see no way how
com::sun::star::ucb::UniversalContentBroker::create could throw an exception 
there during shutdown.  It should already have been called during 
initialization, from Desktop::Main -> Desktop::RegisterServices 
-> configureUcb, and if that had already failed with an exception, that
would have caused a call to FatalError, which immediately terminates the 
process via _exit.

Are you sure that that crash dump correlates to a "Binary URP bridge disposed 
during call" exception in your client, or could it be from a "harmless" crash 
of an soffice.bin instance after your client code had already disconnected (so 
might normally go rather unnoticed, except for leaving behind a crash dump)?

-- 
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] question about "Binary URP bridge disposed during call" error

[Stephan Bergmann]

On 02/23/2016 03:18 PM, Shawn Cao wrote:

Because each testing will open and close LibreOffice, I am not sure
how to attach WinDbg with those evanescent processes. Fortunately,
Windows will generate dump file for each LibreOffice crash. I open
dump file with WinDbg and please refer to attachment for the trace
result. I tested 5.1.1.1 and will test latest Dev version soon.



STACK_TEXT:
00e7f2e8 76c23fc8 kernelbase!RaiseException+0x48
00e7f348 6a0f9339 msvcr120!_CxxThrowException+0x5b
00e7f388 659c020c 
ucbhelper!com::sun::star::ucb::UniversalContentBroker::create+0x16c
00e7f3ec 659b9d36 ucbhelper!ucbhelper::Content::Content+0x46
00e7f424 6766a40f mergedlo!`anonymous namespace'::content+0x6f
00e7f45c 67669ec3 mergedlo!utl::UCBContentHelper::Kill+0x73
00e7f4c8 66b0ab84 mergedlo!desktop::Desktop::RemoveTemporaryDirectory+0x14
00e7f4d0 66b0780d mergedlo!desktop::Desktop::doShutdown+0x21d
00e7f520 66b025fc mergedlo!desktop::Desktop::Main+0xe3c
00e7f69c 67a05886 mergedlo!ImplSVMain+0x46
00e7f6c4 67a05c39 mergedlo!SVMain+0x29
00e7f6d0 66b1c599 mergedlo!soffice_main+0x79
00e7f740 0018101e soffice+0x101e
00e7f794 768b3744 kernel32!BaseThreadInitThunk+0x24
00e7f7a8 771b9e54 ntdll!__RtlUserThreadStart+0x2f
00e7f7f0 771b9e1f ntdll!_RtlUserThreadStart+0x1b


Hm, that's rather odd.

For one, this crash is during "clean" termination of the soffice.bin 
process, i.e., at a time when your external code should no longer 
communicate with the soffice.bin process anyway.  (Or is your external 
code designed in a way that it might call 
com.sun.star.frame.XDesktop.terminate while some printing activity is 
still in progress?)


For another, I see no way how 
com::sun::star::ucb::UniversalContentBroker::create could throw an 
exception there during shutdown.  It should already have been called 
during initialization, from Desktop::Main -> Desktop::RegisterServices 
-> configureUcb, and if that had already failed with an exception, that 
would have caused a call to FatalError, which immediately terminates the 
process via _exit.


Are you sure that that crash dump correlates to a "Binary URP bridge 
disposed during call" exception in your client, or could it be from a 
"harmless" crash of an soffice.bin instance after your client code had 
already disconnected (so might normally go rather unnoticed, except for 
leaving behind a crash dump)?


--
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] question about "Binary URP bridge disposed during call" error

[Stephan Bergmann]

On 02/18/2016 04:07 PM, shawn wrote:

We utilize LibreOffice SDK 5.0 64 C++ to print documents with LibreOffice
5.1.0.3 .  During batch testing, I print a odt file over and over again. The
problem is the program throw exception "Binary URP bridge disposed during
call" from time to time. This exception happens on *Windows 10* and doesn't
happen on Windows Server 2012 or Windows Server 2012 R2.


That exception typically indicates that LO's soffice.bin process 
crashed.  See 
 
how to get a backtrace for a crashing soffice.bin; maybe that could give 
us some clue why it crashes.


--
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] question about libreoffice 4.3 and automatic spell check

[nasrin khaksar]

hi every one.
thanks for your helpful answers and i wish devine mercy and blessings for you.
i appreciate all of you for your help.

On 2/19/16, nasrin khaksar  wrote:
> hi dave.
> your answer is complete, and helpful too.
> because of accessibility reasons, i should use libreoffice 4.3.0.2 and
> above.
> because the previous versions need java and java access briedge and i
> dont know how to use them.
> but 4.3 and later versions, fortunately, thanks god, by his grace and
> mercy and thanks to  the developers dont know these extra components
> and are accessible by default reasonably except for some problems that
> i reported before to bugzilla.
> and you mentioned, that i go to the tools, auto correct options, then
> options tab and select which one i want to be checked or not.
> i tested this, but unfortunately nvda does not read the options and
> only says checkbox check or not.
> for shortcuts and read only mode, your solution was great and i did
> not know them before.
> thanks and god bless you.
>


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10 verses 57 and 58.

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

Re: [libreoffice-users] question about libreoffice 4.3 and automatic spell check

[nasrin khaksar]

hi dave.
your answer is complete, and helpful too.
because of accessibility reasons, i should use libreoffice 4.3.0.2 and above.
because the previous versions need java and java access briedge and i
dont know how to use them.
but 4.3 and later versions, fortunately, thanks god, by his grace and
mercy and thanks to  the developers dont know these extra components
and are accessible by default reasonably except for some problems that
i reported before to bugzilla.
and you mentioned, that i go to the tools, auto correct options, then
options tab and select which one i want to be checked or not.
i tested this, but unfortunately nvda does not read the options and
only says checkbox check or not.
for shortcuts and read only mode, your solution was great and i did
not know them before.
thanks and god bless 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: [libreoffice-users] question about libreoffice 4.3 and automatic spell check

[nasrin khaksar]

hi brian.
your answer was very complete, useful and efficient specially about
automatic spell checking.
but i did not find standard toolbar and i dont know where it is exactly.
for read only mode, because the persian pdf documents are not
accessible for me and also i want to my documents will be remained
accessible for me too.
for this reason i prefer to dont export them as pdf.
thanks and god bless you.

On 2/18/16, Brian Barker  wrote:
> At 11:05 17/02/2016 +0330, Nasrin Khaksar wrote:
>>in libreoffice 4.4 and above, an option added for activate or
>>deactivate automatic spell check in the tools menu that i can select
>>whether i want automatic spell check to be checked or not. what's
>>about version 4.3? how can deactivate automatic spell check in
>>versions before 4.4?
>
> There are many ways to do this:
>
> o Toggle the AutoSpellCheck button in the Standard toolbar. Or remove
> the tick from Tools | Options... | Language Settings | Writing Aids |
> Options | Check spelling as you type.
>
> o If your text is in a language for which you have no spelling
> dictionary, you can set the text language appropriately and the
> relevant text will then not be checked for spelling.
>
> o You can set the language of your text - or parts of it - to "None
> (Do not check spelling)".
>
> Note that text language can be set in various ways: as a character
> property, a character style property, or a paragraph style property
> (but not a paragraph property, although an entire paragraph can be
> given a language setting using the character property, of course).
> The default language applies only in the absence of any of these settings.
>
>>is it possible to save a document in read only mode? for example: i
>>write and save my document in read only mode to becomes unchangeable
>>like pdf documents?
>
> Once you have saved your document, you can set the file as read-only
> outside LibreOffice. But note that this setting is an operating
> system property, so it will not survive your sending the file to a
> correspondent, for example.
>
> But if you put your text into a "section" (using Insert |
> Section...), you can protect that with a password, which prevents the
> text being modified. There is no reason why all of a document's text
> should not be in a section or series of sections.
>
> Mind you, if you want others to see the document without the
> possibility of modification, why not export it as PDF anyway?
>
> I trust this helps.
>
> Brian Barker
>
>
> --
> 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
>
>


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10 verses 57 and 58.

please visit 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] question about "Binary URP bridge disposed during call" error

[shawn]

Hi everybody,

We utilize LibreOffice SDK 5.0 64 C++ to print documents with LibreOffice
5.1.0.3 .  During batch testing, I print a odt file over and over again. The
problem is the program throw exception "Binary URP bridge disposed during
call" from time to time. This exception happens on *Windows 10* and doesn't
happen on Windows Server 2012 or Windows Server 2012 R2.

By the way, the exception also happens with other files, and it happens on
32-bit version too. 

The basic printing code is:

m_xDocument = m_xDesktop->loadComponentFromURL(
   Url, 
   
   OUString(
RTL_CONSTASCII_USTRINGPARAM("_blank") ),
   0,   
   
loadProperties );

try{
Reference< XPrintable > xprintable( m_xDocument, UNO_QUERY);
xprintable->print( m_xPrintProperties );
WaitForPrintComplete();//xPrintable->getPrinter() and check printer
property
}
catch ( Exception& exception )
{
throw new MyExceptionClass(1, exception.Message.getStr());//"Binary URP
bridge disposed during call"
}

if (m_xDocument != NULL) {  m_xDocument->dispose();}
 

Thanks!

Shawn
 



--
View this message in context: 
http://nabble.documentfoundation.org/question-about-Binary-URP-bridge-disposed-during-call-error-tp4175905.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] question about libreoffice 4.3 and automatic spell check

[Brian Barker]

At 11:05 17/02/2016 +0330, Nasrin Khaksar wrote:
in libreoffice 4.4 and above, an option added for activate or 
deactivate automatic spell check in the tools menu that i can select 
whether i want automatic spell check to be checked or not. what's 
about version 4.3? how can deactivate automatic spell check in 
versions before 4.4?


There are many ways to do this:

o Toggle the AutoSpellCheck button in the Standard toolbar. Or remove 
the tick from Tools | Options... | Language Settings | Writing Aids | 
Options | Check spelling as you type.


o If your text is in a language for which you have no spelling 
dictionary, you can set the text language appropriately and the 
relevant text will then not be checked for spelling.


o You can set the language of your text - or parts of it - to "None 
(Do not check spelling)".


Note that text language can be set in various ways: as a character 
property, a character style property, or a paragraph style property 
(but not a paragraph property, although an entire paragraph can be 
given a language setting using the character property, of course). 
The default language applies only in the absence of any of these settings.


is it possible to save a document in read only mode? for example: i 
write and save my document in read only mode to becomes unchangeable 
like pdf documents?


Once you have saved your document, you can set the file as read-only 
outside LibreOffice. But note that this setting is an operating 
system property, so it will not survive your sending the file to a 
correspondent, for example.


But if you put your text into a "section" (using Insert | 
Section...), you can protect that with a password, which prevents the 
text being modified. There is no reason why all of a document's text 
should not be in a section or series of sections.


Mind you, if you want others to see the document without the 
possibility of modification, why not export it as PDF anyway?


I trust this helps.

Brian Barker


--
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] question about libreoffice 4.3 and automatic spell check

[Tim---Kracked_P_P---webmaster]

I found the spell check options in
Tools>Options>Language Settings>Writing Aids>Options
and check or uncheck the various options.

I am using 5.0.4.2 on a Ubuntu 15.10 64bit system.


On 02/17/2016 02:37 PM, Dave Liesse wrote:

Pedro,

I'm still using v4.0.0.3.  In this version, at least, I think you can 
get to the automatic spell check options you're looking for by going 
to Tools ... Autocorrect Options ... Options (tab).  In that screen 
you have the opportunity to specifiy what corrections are active 
during typing and during manual correcting.


If that's not what you mean, and you're looking for whether or not 
spellcheck runs automatically all the time, that's handled through an 
item on the standard menu bar.  You'll see two icons with a check mark 
and the letters ABC; one of these has a red squiggly line.  The one 
without the line runs spellcheck (just like pressing F7), the other 
toggles automatic checking on and off.


For a list of shortcut keys go to Help (press F1), search on "keyboard 
shortcuts", then select "Shortcut Keys for LibreOffice Writer".  This 
gives you a list of the standard shortcuts; it won't show any 
customized ones.


There doesn't seem to be any foolproof way of setting a file to 
read-only.  You can set a document to be opened read-only by going to 
File ... Properties ... Security (tab) and checking the "Open file 
read-only" box.  Other users can only open it as read-only, but they 
can make a copy and then save it with the original file name. To be 
fair, I think this workaround exists with almost any program, not just 
LO.


Dave



On 2/16/2016 23:35, nasrin khaksar wrote:

hi every one.
i have three questions and hope that you help me in these cases like
previous times.
1/ in libreoffice 4.4 and above, an option added for activate or
deactivate automatic spell check in the tools menu that i can select
whether i want automatic spell check to be checked or not.
whats about version 4.3? how can deactivate automatic spell check in
versions before 4.4?
2/ how can i see full list of libreoffice writer shortcuts?
and 3/ is it possible to save a document in read only mode?
for example: i write and save my document in read only mode to becomes
unchangable like pdf documents?
thanks for your help and god bless you 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: [libreoffice-users] question about libreoffice 4.3 and automatic spell check

[Dave Liesse]

Pedro,

I'm still using v4.0.0.3.  In this version, at least, I think you can 
get to the automatic spell check options you're looking for by going to 
Tools ... Autocorrect Options ... Options (tab).  In that screen you 
have the opportunity to specifiy what corrections are active during 
typing and during manual correcting.


If that's not what you mean, and you're looking for whether or not 
spellcheck runs automatically all the time, that's handled through an 
item on the standard menu bar.  You'll see two icons with a check mark 
and the letters ABC; one of these has a red squiggly line.  The one 
without the line runs spellcheck (just like pressing F7), the other 
toggles automatic checking on and off.


For a list of shortcut keys go to Help (press F1), search on "keyboard 
shortcuts", then select "Shortcut Keys for LibreOffice Writer".  This 
gives you a list of the standard shortcuts; it won't show any customized 
ones.


There doesn't seem to be any foolproof way of setting a file to 
read-only.  You can set a document to be opened read-only by going to 
File ... Properties ... Security (tab) and checking the "Open file 
read-only" box.  Other users can only open it as read-only, but they can 
make a copy and then save it with the original file name. To be fair, I 
think this workaround exists with almost any program, not just LO.


Dave



On 2/16/2016 23:35, nasrin khaksar wrote:

hi every one.
i have three questions and hope that you help me in these cases like
previous times.
1/ in libreoffice 4.4 and above, an option added for activate or
deactivate automatic spell check in the tools menu that i can select
whether i want automatic spell check to be checked or not.
whats about version 4.3? how can deactivate automatic spell check in
versions before 4.4?
2/ how can i see full list of libreoffice writer shortcuts?
and 3/ is it possible to save a document in read only mode?
for example: i write and save my document in read only mode to becomes
unchangable like pdf documents?
thanks for your help and god bless you 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: [libreoffice-users] question about libreoffice 4.3 and automatic spell check

[Bo Siltberg]

For 2/, you can open Tools -> Customise -> Keyboard. However, it wont give
you a nice readable overview of all shortcuts.


2016-02-17 8:35 GMT+01:00 nasrin khaksar :

> hi every one.
> i have three questions and hope that you help me in these cases like
> previous times.
> 1/ in libreoffice 4.4 and above, an option added for activate or
> deactivate automatic spell check in the tools menu that i can select
> whether i want automatic spell check to be checked or not.
> whats about version 4.3? how can deactivate automatic spell check in
> versions before 4.4?
> 2/ how can i see full list of libreoffice writer shortcuts?
> and 3/ is it possible to save a document in read only mode?
> for example: i write and save my document in read only mode to becomes
> unchangable like pdf documents?
> thanks for your help and god bless you all.
>
>
> --
> O people! there has come to you indeed an admonition from your Lord
> and a healing for what is in the breasts and a guidance and a mercy
> for the believers.
> Say: In the grace of Allah and in His mercy-- in that they should
> rejoice; it is better than that which they gather.
> holy quran, chapter 10 verses 57 and 58.
>
> please visit 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
>

-- 
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] question about libreoffice 4.3 and automatic spell check

[nasrin khaksar]

hi every one.
i have three questions and hope that you help me in these cases like
previous times.
1/ in libreoffice 4.4 and above, an option added for activate or
deactivate automatic spell check in the tools menu that i can select
whether i want automatic spell check to be checked or not.
whats about version 4.3? how can deactivate automatic spell check in
versions before 4.4?
2/ how can i see full list of libreoffice writer shortcuts?
and 3/ is it possible to save a document in read only mode?
for example: i write and save my document in read only mode to becomes
unchangable like pdf documents?
thanks for your help and god bless you all.


-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10 verses 57 and 58.

please visit 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] Question on bugs

[Malcolm Moore]

 
This has always puzzled me :-

Why does LO list bugs by 'earliest version affected' ?
If you look at the bug list for 5.1 for example, it shows
119 bugs.  There are a number of bugs that 5.1 has 
that don't show on the list as they are recorded as affecting
earlier versions. Why would anyone working on 5.1 look
for a bug that is down as affecting 4.1 or something.
An issue that came up the other day in both 5.0.4 and 5.1RC2
is actually first recorded as affecting 4.4.0 which by their
roadmap went end of life in the middle of last year. 
 
Ta


Mal 


-- 
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] question about the best version of libreoffice:

[nasrin khaksar]

hi every one.
i tested many versions of libreoffice since version 4.2.5
all versions have there advantages and in cases there bugs and limitations.
whats the best version of libreoffice since version 4.3.0.4 according
to your experience?
whats the best version with more stability, reliability and with less
bugs and crashes, compatible even with the old and not powerful
computers and also sutable for none professional home users?
i only use writer and only use writer for reading books, articles etc
and for writing.
thank you and god bless you all.

-- 
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

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

Re: [libreoffice-users] question about the best version of libreoffice:

[Philip Rhoades]

nasrin,


On 2016-01-20 19:05, nasrin khaksar wrote:

hi every one.
i tested many versions of libreoffice since version 4.2.5
all versions have there advantages and in cases there bugs and 
limitations.

whats the best version of libreoffice since version 4.3.0.4 according
to your experience?
whats the best version with more stability, reliability and with less
bugs and crashes, compatible even with the old and not powerful
computers and also sutable for none professional home users?
i only use writer and only use writer for reading books, articles etc
and for writing.



Please leave superstitious nonsense (like the stuff below) out of posts 
to lists that are about real-world technology.


P.



thank you and god bless you all.

--
O people! there has come to you indeed an admonition from your Lord
and a healing for what is in the breasts and a guidance and a mercy
for the believers.
Say: In the grace of Allah and in His mercy-- in that they should
rejoice; it is better than that which they gather.
holy quran, chapter 10.

please visit al-islam.org


--
Philip Rhoades

PO Box 896
Cowra  NSW  2794
Australia
E-mail:  p...@pricom.com.au

--
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] question about the best version of libreoffice:

[James Knott]

On 01/20/2016 03:15 AM, Philip Rhoades wrote:
> Please leave superstitious nonsense (like the stuff below) out of
> posts to lists that are about real-world technology.

+1


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