Re: [libreoffice-users] does lo store information in case of crash on linux

[Girvin Herr]

Jindam,

This a good question that I would like to hear the answer to also.

In the meantime, I suggest that sometimes valuable troubleshooting 
information can be had from the program itself, but it must be started 
from an XTerm console to read it. In the past, I have discovered file 
read errors and library problems using this method. Another possibility 
is to create a script which opens LibreOffice, but redirects console 
output to a file. Sometimes that works. However, if the program crashes, 
that may not work either.


Good luck, and I hope someone responds with the answer to your question.

Girvin


On 7/21/22 11:18 PM, jindam, vani wrote:

i downloaded "Test file produced by EK RTF attached." and renamed 
"=_UTF-8_Q_test=2Ertf_=.bin" to "91074.rtf" from bug #91074. for some reason file 
extension is .bin. all other file extensions are downloading correctly. i tried to open in lo writer and it 
terminated my vnc session. i am running debian sid on userland app (android). so, is there any way to capture 
some kind of logs. in my present setup its impossible to use gdb, strace, valgrind, etc..


--
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] Re: [libreoffice-users] cells don’t auto-wrap

[Girvin Herr]

On 4/6/21 1:04 PM, Brian Barker wrote:

At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
I've got a spreadsheet with all cells formatted to auto-wrap, yet 
when I enter stuff into certain cells, it doesn't autowrap. And 
sometimes the cell just shows the last bit of what I've entered. When 
I right-click and check the cell, it does show it's set to auto-wrap.


I think the answer may be simple: that you have set the row height for 
the relevant cells to be insufficient to allow wrapping to happen. In 
this case, the last line of wrapped text is indeed what will appear in 
the cell. You need to tinker with row height to enable Calc to expand 
the row sufficiently to accept all your text.


I trust this helps.

Brian Barker


Double-click on the bottom line of the far left column (the row number 
column, not column "A") of the row needing enlargement. If you are on 
the line, the mouse pointer will change to the up-down arrow icon. Doing 
so should increase the row height to accommodate the text. (It will also 
decrease the row height if the text will allow it.)


Girvin



--
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] macros - where stored for Calc

[Girvin Herr]

On 1/10/21 3:18 AM, Johnny Rosenberg wrote:

Den sön 10 jan. 2021 kl 12:07 skrev Philip Jackson :


On 10/01/2021 08:49, Johnny Rosenberg wrote:

Den sön 10 jan. 2021 kl 08:35 skrev Tom Cloyd MS MA <

tomcloydm...@gmail.com>:

I recently moved my LO user profile to a new computer, but my Calc
macros were not to be found. I had to recreate them. I am about to
repeat this move with another computer. I REALLY want to move my macros
also, but somehow my backups is not catching them.

Please - where are they stored?

Here's what I replied:

Mine seem to be located at ~/.config/libreoffice/4/user/basic/
In ~/.config/libreoffice/4/user/basic/Standard I find my own global
macros. They are stored in XML format with file suffixes like xba, xlb,
xlc, xdl …
The xdl files are for dialogues, by the way.

I'm running Manjaro. I guess it could be slightly different in other
operating systems.

My LO templates spent years being in a subdirectory in the
~/.config/libreoffice/4/user/  structure but after an update (system or
LO, I can't remember now) they all apparently disappeared. Hunting around,
I found them in my home root directory  ~/Templates/


I upgrade relatively often and mine are still in
~/.config/libreoffice/4/user/template/
I don't remember if that was also true when I had Ubuntu (I'm on Manjaro
since 2016 or so), though.


Kind regards

Johnny Rosenberg



I don't recall ever having moved them there (but I cannot exclude it 100%)
but it seems as good a place as any.
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


Greetings,

IIRC, the LO default templates directory is in 
~/.config/libreoffice/4/user/template Looking at Tools > LibreOffice > 
Paths will confirm this and it is the place where it can be changed. The 
Open Desktop standard is in ~/Templates. I added ~/Templates to my LO 
Templates path with a semicolon separator, so my LO searches both places.


HTH

Girvin



--
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] Which Font Is Substituted?

[Girvin Herr]

John,

I am using Slackware Linux 14.2 (k4.4.227).

Do you have any font substitutions in LO's Options > LibreOffice > Fonts 
> Replacement table?


Note that "/usr/share/fonts/century-schoolbook/" is not a standard Xorg 
font directory. Xorg probably does not have this directory in its list 
of font directories to search. That may be why LO cannot find it. I 
found it in "/usr/share/fonts/100dpi/" as ncen*.pcf.gz. It is listed in 
the fonts.dir plain text file in that directory. If the font path is not 
in the X font directory search list, then X cannot supply it to LO. I 
suggest to place it in the correct directory or add the 
century-schoolbook directory to X's font directory list. To do that, if 
you have an xorg.conf file (/etc/X11/xorg.conf YMMV), look for the 
"FontPath" entries and add your path to it.


Another option is to run the font database manager, but I use that so 
little, I have forgotten how to do it.


I just checked and discovered my LibreOffice 6.2.8.2 does not have 
Century Schoolbook listed either. However, my Apache OpenOffice 4.1.6 
does have a "Century Schoolbook L" font listed. This implies that even 
if the font is in the correct directory, as in my case, LO is omitting 
it for some reason. Are you sure there is no entry in your font 
replacement table?
So, another option might be to install AOO and see if that works better 
for you.


HTH.

Girvin Herr


On 10/10/20 12:34 PM, John wrote:

I have a several chapters of a book that were originally composed
using an earlier version of LibreOffice using what I believe was the
"Century Schoolbook" font.  Now when I call them in for editing, the
font is shown in italics as "Times New Roman" with the note "The
current font is not available and will be substituted".

This is giving me a serious problem since the book contains many
drawings and framed images and these get re-flowed due to the
difference in the absolute height of the font being substituted. In
some cases the drawings are pages away from their correct location and
have to be towed back, which is time consuming and creates some other
problems too.

I checked and the Century Schoolbook font is installed where expected;
in the /usr/share/fonts/century-schoolbook/ directory.

I have not been able to figure out which font is being used for the
substitution, nor why the correct font cannot be found.

Can anyone help?

Details:
Linux Fedora 32 - workstation
LO 6.1.3.2

I am on a back level of Libre Office because we have hundreds of line
drawings in use in the .eps format that is no longer supported by LO
on newer releases.

Thanks in advance for any help!

Regards,

John







--
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] Template confusion - 6.3.4.2 on Ubuntu

[Girvin Herr]

On 2/20/20 10:19 PM, John Jason Jordan wrote:

On Thu, 20 Feb 2020 15:51:57 -0800
John Jason Jordan  dijo:


I have been using LO, and previously OO, since ~2002, and I currently
have 6.3.4.2 on Xubuntu 18.04, up to date. This version was installed
with the PPA supplied by LO.

Needing to figure out my numerous templates I searched for *.ott and
came up with files scattered all over. So my first question is, where
is the preferred location so I can corral them all in the same place?

And then I have a problem with the default Writer template
'Default.ott,' of which there is only one I practically never use
anything but Writer, and when I launch Writer it comes up with a new,
blank document based on the default template. This is as it should be,
but there is something in the default template that I need to change -
the settings for the First Line Indent style. It defaults to adding
seven points between paragraphs, but I must always change that to -0-,
in order to comply with university and publishing style guidelines. And
no, I do not want a special template for this; I just want to change
the settings for the default template.

I launched Writer, then closed the new, blank document and selected the
Default template for editing. Imagine my surprise when the setting for
First Line Indent showed -0- points for additional spacing between
paragraphs. Yet when I open a new document based on the default
template the setting for First Line Indent is always an additional
seven points between paragraphs.

What is going on here?

I found part of the problem. For some reason LO Writer was not using
the Default.ott file for the default template. I found how to force it
to use this template, but I never figure out which template it was
using for the default. But at least now a new document comes up with
the right settings for the First Line Indent style.

But so far I have failed to figure out where the default folder for
templates is. I'd really like to tidy things up.


John,

Did you look at
Tools > LibreOffice > Paths > Templates

My Slackware Linux uses the Open Desktop standard and has a Templates 
directory in my home directory. That is where I place my templates and 
set the LO/AOO Template path to it. Use a semicolon ";" to separate the 
existing path from the new path when editing the above template path in 
LO/AOO. I think the templates are searched in the path order, so both 
the original and your templates should be in the selection dialog after 
this is done.


I have found the LO and AOO template system to be a bit of a mystery to 
me. Luckily, I don't have to mess with it much. I managed to get it to 
work for me, but there are still some strangenesses about it - such as 
the "version" suffix placed on the template file. This version does not 
appear in the template list dialog, but it is shown in the directory 
filename where it is located. One must use a specific process to modify 
a template. It is not as simple as just opening it to edit as a regular 
document. See File > Templates.


I also seem to remember something special about the "default" template - 
that it is actually hardwired into the code and cannot be changed. One 
must create a fresh document using the "default" template as a base, 
change that document and save it as a template and then make it the 
"default" template. LO and AOO do this differently. In LO,  do:


File > Templates > Manage Templates

Right-click on the template you wish to make the new default, then 
select "Set As Default" in the popup.
Caveat: I have done this successfully in AOO, but not in LO yet. But it 
should work. Maybe someone else can clarify this procedure for LO, 
especially if I am incorrect.


HTH.

Girvin



--
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] Problem with chapter numbering and TOC.

[Girvin Herr]

Dave,

Have you added your new style to the TOC?

Right-click on the TOC. Select "Edit Index".

If "Protected against manual changes" is checked, you will have to 
uncheck it, OK and re-edit the TOC.


Select the "Type" tab if not already shown. Down under "Create from", 
check "Additional Styles" and then the "Assign styles..." box to the right.


You should see a list of the styles in your document, including your 
"New Chapter" style, on the left column ("Not applied") and the 
associated TOC levels (associated to styles in the Styles tab) to the 
right of the first column. Scroll down to find your style, "New 
Chapter", and use the ">|" or "|<" buttons to assign a contents level 
for your style by moving the style into the proper level column. I would 
guess the "1" column, since it is higher than the headings.


Since by default, "heading1" style is associated to contents level 1 and 
this procedure reassigns TOC level 1, You may need to manually associate 
the heading styles to the correct level also. Do the same for all the 
heading levels you use in the document, since they are all shifted up a 
level. Note that the more custom levels you have, the less heading 
levels you will have, since the limit is 10. One way around that, is to 
assign a single TOC level style to all heading levels. But that may 
limit the look of your TOC if you want different styles for different 
levels, such as indents.


It may take some experimentation with this to get what you want out of 
it. For instance, if you want the "New Chapter" contents style to look 
different than the stock styles, you may need to make a contents style 
specific for the TOC rather than the default "contents*" styles. Then in 
the "Styles" tab, change the New Chapter level (1) to use your new 
contents style. Use the "<-" button by selecting the level and then the 
style followed by the "<-" button to make the assignment.


When you are all done, re-check the Protected Against Manual Changes box 
and OK.


HTH.

Girvin Herr


On 11/13/19 10:58 PM, Dave Barton wrote:

I have set up chapter numbering as per the help page
https://tinyurl.com/vsq77lu and created a "New Chapter" page style.

After inserting a manual page break with the "New Chapter" page style I
set the first paragraph style to "Heading 1" and the correct chapter
name/number is displayed both on the page and in Navigator.

However, when I insert a TOC into the document no chapters appear in the
index.

Any thoughts or pointers would be welcome.

Thanks Dave





--
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] Libreoffice, task manager bar and the running application icon

[Girvin Herr]

Alex,

Sorry I didn't get back to you sooner. I was attending a conference the 
last 3 days.


There is a manpage for gtk-update-icon-cache which explains what it does 
and what to expect. Here is a snippet from that manpage:


-

gtk-update-icon-cache creates mmapable cache files for icon themes.

   It expects to be given the PATH to a icon theme directory 
containing an index.theme, e.g.
   /usr/share/icons/hicolor, and writes a icon-theme.cache 
containing cached information about the icons in

   the directory tree below the given directory.

   GTK+ can use the cache files created by gtk-update-icon-cache to 
avoid a lot of system call and disk
   seek overhead when the application starts. Since the format of 
the cache files allows them to be mmaped
   shared between multiple applications, the overall memory 
consumption is reduced as well.

-

I checked the LibreOffice 5.3 package file in /var/log/packages, which 
shows LibreOffice was installed into /opt, but the icons are installed 
into /usr/share/icons/gnome and /usr/share/icons/hicolor and 
/usr/share/icons/locolor . The script I gave you caches all three.


I think the problem you are experiencing may be caused by the old cache 
not reflecting the updated icons after you installed the LibreOffice 
update, thus xfce or kde fail to load the icon(s) and they will display 
the default icon. Running the script I suggested will re-sync the icon 
cache to your new icons.


No, I don't think you need to reboot after using the script. That is a 
windows-ism.


BTW: To keep the record straight, the icon-theme.cache file is not a 
script as you called it. So, you cannot execute it. In fact, it is not 
human-readable.


HTH.

Girvin


On 10/11/19 6:07 AM, mcmurchy1917techy wrote:

Hi Girvin

Thanks for the reply. I too use Slackware.

I've only got the /usr/share/icons/hicolor/icon-theme.cache script on 
my system. Do I need to reboot the machine for the change to take effect?


Alex

On 10/10/2019 19:20, Girvin Herr wrote:

Alex,

I am assuming you are using a Linux distro, since you mention kde and 
xfce. I am using Slackware Linux and xfce. I would first try running 
the following script as root to refresh the icon cache before you get 
too deep:


#!/bin/sh
# Cache the icons:
if [ -x /usr/bin/gtk-update-icon-cache ];  then
  for THEME in gnome locolor hicolor ; do
    if [ -e /usr/share/icons/${THEME}/icon-theme.cache ];  then
  /usr/bin/gtk-update-icon-cache  /usr/share/icons/${THEME} 
>/dev/null 2>&1

    fi
  done
fi

#
# Update the desktop database:
if [ -x /usr/bin/update-desktop-database ];  then
  /usr/bin/update-desktop-database  -q  /usr/share/applications
fi

#
# Update the mime database:
if [ -x /usr/bin/update-mime-database ];  then
  /usr/bin/update-mime-database  /usr/share/mime  >/dev/null 2>&1
fi


It won't hurt to refresh the desktop and mime databases also, as 
shown in the script. Historically when I suggested this to other 
users with icon problems, running this script cured their problems. I 
run this as part of my installation script when the LibreOffice 
package is installed, thus updating the databases at install time.


FYI, the icons are defined in the .desktop files for each of the 
LibreOffice apps in:


/opt/libreoffice5.3/share/xdg/*.desktop

Look for the "Icon=" entry in the desktop file. Additionally, you may 
have defined additional desktop files in ~/Desktop . This directory 
is where the desktop shortcuts may have been copied/placed by you to 
your desktop.


And the icon files are in:

/usr/share/icons

Note that libreoffice5.3 is the version I happen to be using. 
Substitute your version as needed. Note also that these are for my 
Slackware system. Your distro may place them elsewhere, but it should 
be similar.


HTH.

Girvin


On 10/10/19 2:49 AM, mcmurchy1917techy wrote:

I've got a problem that's bugging me.

The initial problem was that if I started calc, it started as 
expected except that in the task manager bar, which displays the 
running applications, I see an icon with a X and a circle through 
it, I suspect this icon is the default icon for running 
applications, the icon I'm expecting in the task manager bar is the 
calc icon. The Base and Impress icons displayed as expected.


The icon for writer displayed perfectly.

It bugged me so much yesterday that I decided to temporarily change 
from kde4 to xcfe. I started up Calc and got what I suspect was the 
default icon not the calc icon. Started writer got the default icon 
not the writer icon.


Returned to kde4.

This time. Started up Calc andgot the icon with a X and a circle 
through it not the calc icon - same as before. Started up Writer 
andgot the icon with a X and a circle through it not the writer 
icon, whereas previously I would have got the writer icon. The same 
was seen with the Base and Impress icons which were displayed as the 
X a

Re: [libreoffice-users] Libreoffice, task manager bar and the running application icon

[Girvin Herr]

Alex,

I am assuming you are using a Linux distro, since you mention kde and 
xfce. I am using Slackware Linux and xfce. I would first try running the 
following script as root to refresh the icon cache before you get too deep:


#!/bin/sh
# Cache the icons:
if [ -x /usr/bin/gtk-update-icon-cache ];  then
  for THEME in gnome locolor hicolor ; do
    if [ -e /usr/share/icons/${THEME}/icon-theme.cache ];  then
  /usr/bin/gtk-update-icon-cache  /usr/share/icons/${THEME} 
>/dev/null 2>&1

    fi
  done
fi

#
# Update the desktop database:
if [ -x /usr/bin/update-desktop-database ];  then
  /usr/bin/update-desktop-database  -q  /usr/share/applications
fi

#
# Update the mime database:
if [ -x /usr/bin/update-mime-database ];  then
  /usr/bin/update-mime-database  /usr/share/mime  >/dev/null 2>&1
fi


It won't hurt to refresh the desktop and mime databases also, as shown 
in the script. Historically when I suggested this to other users with 
icon problems, running this script cured their problems. I run this as 
part of my installation script when the LibreOffice package is 
installed, thus updating the databases at install time.


FYI, the icons are defined in the .desktop files for each of the 
LibreOffice apps in:


/opt/libreoffice5.3/share/xdg/*.desktop

Look for the "Icon=" entry in the desktop file. Additionally, you may 
have defined additional desktop files in ~/Desktop . This directory is 
where the desktop shortcuts may have been copied/placed by you to your 
desktop.


And the icon files are in:

/usr/share/icons

Note that libreoffice5.3 is the version I happen to be using. Substitute 
your version as needed. Note also that these are for my Slackware 
system. Your distro may place them elsewhere, but it should be similar.


HTH.

Girvin


On 10/10/19 2:49 AM, mcmurchy1917techy wrote:

I've got a problem that's bugging me.

The initial problem was that if I started calc, it started as expected 
except that in the task manager bar, which displays the running 
applications, I see an icon with a X and a circle through it, I 
suspect this icon is the default icon for running applications, the 
icon I'm expecting in the task manager bar is the calc icon. The Base 
and Impress icons displayed as expected.


The icon for writer displayed perfectly.

It bugged me so much yesterday that I decided to temporarily change 
from kde4 to xcfe. I started up Calc and got what I suspect was the 
default icon not the calc icon. Started writer got the default icon 
not the writer icon.


Returned to kde4.

This time. Started up Calc andgot the icon with a X and a circle 
through it not the calc icon - same as before. Started up Writer 
andgot the icon with a X and a circle through it not the writer icon, 
whereas previously I would have got the writer icon. The same was seen 
with the Base and Impress icons which were displayed as the X and a 
circle through it.


By switching from kde4 to xfce and then back again, I've made matters 
worse.


My question is where does the desk top environments get these icons 
from? How can I get the calc and writer icons displaying in the task 
manager bar


Alex






--
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] Cannot get summed values in a Base report

[Girvin Herr]

On 5/16/19 7:12 AM, Robert Großkopf wrote:

Hi Girvin,

However, when I try these parameters in the new report, when I select
"Accumulation" in the Function field, it changes "Data Field" to
"[AccumulationCostReport]" and the Function and Scope fields go blank.

Seems to be the right function. You could see the content of the
function when opening the report-navigator. The function must be
available there. Should look like
[Cost]+[AccumulationCostReport]
... but could be there is a field without content. If you add NULL (not
0) to the function the result will be NULL.

You could send me a database-example with some dummy-data. I would have
a look at it.

The best way to get the whole sum of all values is to create a view for
the content of the report. The sum will be a part of the view, not
created in the report.

Regards

Robert


I finally gave up on this, No matter how I formatted it, I either got 
nothing, or only the first record's value (the initial value). I made 
sure all records had the relevant fields non-Null, and checked the data 
in the report for any blank (Null) values to verify that. I tried moving 
the sum field to the page footer from the report footer to get a running 
tally on each page, but I got the same results on all pages - either 
blank or the initial value. I even had hope in this:


https://forum.openoffice.org/en/forum/viewtopic.php?f=42&t=45572

But alas, it does the same thing. The odd thing is that my older reports 
are not consistent. Several use different forms of this summing (user 
defined and Accumulation functions), yet they all work for their 
reports. I tried using the same methods to sum in my new report, but 
none of them worked. Strange. So, I gave up on trying to total the 
record values.


Thanks for the replies.
Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] [SOLVED?] Problem with text formatting in Report.

[Girvin Herr]

Greetings,

I think I have a solution. I did some research on the Pentaho report 
generator that is used in the LO Base Report Generator with emphasis on 
their formula syntax. The following formula placed in the report field's 
properties "Data" tab in "Data field..." seems to do what I need:


IF(LEN([Suffix])>0;"-"&[Suffix] ;"")

This tests the length of the text string (Suffix) and if not 0 then 
outputs the string prefixed with a dash. The ampersand (&) concatenates 
text strings. If the string length is zero, it outputs the NULL string. 
I tried outputting the string here without the dash to be sure I got all 
data, as in:,


IF(LEN([Suffix])>0;"-"&[Suffix] ;[Suffix])

but it fails for some reason, outputting "false"  when the string length 
is 0 instead.


As I said, it seems to be working, unless I breathe on it!

Thanks for all the suggestions.
Girvin


On 5/15/19 3:17 PM, Girvin Herr wrote:

Greetings,

I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).

I have a database with a text field which may or may not be null. What 
I want to do is to prefix a dash "-" before the text if the text field 
is not null. At first, I tried this format:


;;;"-"@

Somewhere, not by me, it got changed to:

[>0]"";[<0]"";"";"-"@

However, this does not work. I get the text when not null, but not the 
dash in either case.


Is there another way to do this?

Thanks.

Girvin Herr





--
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] Problem with text formatting in Report.

[Girvin Herr]

On 5/16/19 11:12 AM, Johnny Rosenberg wrote:

Den tors 16 maj 2019 kl 00:22 skrev Girvin Herr :


Greetings,

I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).

I have a database with a text field which may or may not be null. What I
want to do is to prefix a dash "-" before the text if the text field is
not null. At first, I tried this format:

;;;"-"@

Somewhere, not by me, it got changed to:

[>0]"";[<0]"";"";"-"@

However, this does not work. I get the text when not null, but not the
dash in either case.


If I format a cell like your first example and enter a letter in that cell,
let's say ”k”, I get:
-k

If I enter a number, the cell remains blank. Is this the behaviour you are
looking for?

The format string doesn't change if I don't change it.

If I set it to [>0]"";[<0]"";"";"-"@ I get the same result, and I should
since the two means exactly the same thing.

Can you give an example that doesn't work?



Kind regards

Johnny Rosenberg




Is there another way to do this?

Thanks.

Girvin Herr



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


Johnny,

Thanks for your response.

I should have been more clear in my original posting. I am not trying to 
do this in Calc. I am trying to do it in Base Report Generator.


I have a text field in the database which I want to prefix with a dash 
(-) if, and only if, there is text (not NULL) in that field.


None of the examples you gave will work as I expect (and as the number 
formatting help implies) in my context (with Base Report Generator). No 
matter how I format it, the result is strange and almost indeterminate. 
Sometimes if the text field is alpha-numeric, the result is "-" without 
the text. Other times it is the text without the "-" prefix. Sometimes 
when the text field is numeric-only, the result is the text without the 
"-". Sometimes not one of these. As I said, indeterminate results.


Not getting a number when encountered is not what I am looking for. In 
all cases, if there is text there, I want it to be in the report. Also, 
I do not want the dash prefix, if there is no text to be in the report.


So, I am not sure what is going on. It almost looks like a bug with the 
unexpected results. It also appears the formatting for the Report 
Generator behaves differently than for Calc.


Thanks.

Girvin



--
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] Problem with text formatting in Report.

[Girvin Herr]

Remy,

Greetings.

I tried your suggestion, but it didn't work as expected. LO Report 
Builder did replace "[<>""]-@" with
"[<>0]-@;General", similar to what you experienced. However, the result 
is strange and almost indeterminate. Sometimes if the text field is 
alpha-numeric, the result is "-" without the text. Other times it is the 
text without the "-" prefix. Sometimes if the text field is 
numeric-only, the result is the text without the "-". Strange.


I then tried changing the format to "[<>0]"-"@;General" (quotes around 
dash) with the same results.


Then I tried "[<>0]"-"@;Standard" as your Calc experiment changed, and 
LO changed it to

"[<>0]"-"@;StanDarD", with the same results.

So, I am not sure what is going on. It almost looks like a bug with the 
unexpected results.


Thanks.
Girvin


On 5/15/19 5:03 PM, Remy Gauthier wrote:

Greetings,

I tried this in calc (which I am assuming you are using), and it seems 
to work for what you describe:


[<>""]-@

The interesting thing is that calc changed it afterwards to

[<>0]-@;Standard

but it still seems to work.

I hope this helps.

Rémy.
Le mercredi 15 mai 2019 à 15:17 -0700, Girvin Herr a écrit :

Greetings,
I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).
I have a database with a text field which may or may not be null. What I
want to do is to prefix a dash "-" before the text if the text field is
not null. At first, I tried this format:
;;;"-"@
Somewhere, not by me, it got changed to:
[>0]"";[<0]"";"";"-"@
However, this does not work. I get the text when not null, but not the
dash in either case.
Is there another way to do this?
Thanks.
Girvin Herr


--
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] Cannot get summed values in a Base report

[Girvin Herr]

Greetings,

I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).

I have been able to do this in the past, but I seem to have "lost the 
bubble" on this and I can't find where I learned it from. I need to 
print a total sum of a field in all records at the end of a Base report. 
Looking at another report of mine that works, the "Data" tab for the 
summation field is:


Data Field Type        Function
Data Field                Cost
Function                   Accumulation
Scope                  Report

However, when I try these parameters in the new report, when I select 
"Accumulation" in the Function field, it changes "Data Field" to 
"[AccumulationCostReport]" and the Function and Scope fields go blank.


When I run the report with this, the summation field is blank.

Since this is in the Report Builder, the Help is useless.

Can someone explain the process to get this done?

Thanks.
Girvin Herr



--
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] Problem with text formatting in Report.

[Girvin Herr]

Greetings,

I am using LibreOffice 5.3.4.2 on Slackware Linux 14.2 (K4.4.75).

I have a database with a text field which may or may not be null. What I 
want to do is to prefix a dash "-" before the text if the text field is 
not null. At first, I tried this format:


;;;"-"@

Somewhere, not by me, it got changed to:

[>0]"";[<0]"";"";"-"@

However, this does not work. I get the text when not null, but not the 
dash in either case.


Is there another way to do this?

Thanks.

Girvin Herr



--
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] Page number messed up in LO Writer 6.2.1/2 and 6.1.5

[Girvin Herr]

Mark,

Try

View > Field Names

which toggles field names on and off.

Girvin


On 4/10/19 3:08 PM, MR ZenWiz wrote:

I've been LO Writer for a long time for, among other things, a few
novels I am writing.

Just now I noticed that the page number field in the header no longer
contains the page number itself, it contains the shaded text "Page
Numbers".

This is new as of LO 6.2.1 and 6.2.2, and kind of defeats utterly the
ability to use this field for page numbering.

I tried deleting it and re-inserting, both with Insert -> Page Number
and Insert -> Field -> Page Number.  Same result.

I have attached a brand new .ods document with the same problem - all
I did was insert the page number in a fresh header.  See also the
attached screen image.

For S&G, I reinstalled LO 6.1.5, but it does the same thing with the
older files, and also with a brand new file.

I'm running this on Xubuntu 18.04.2 in a VB VM (here at work - I'll
check again when I get home).

WTH?

Mark Richter, Senior Staff Engineer
http://www.linkedin.com/in/markrichter1
Registered Linux User #472807 http://counter.li.org/
FSF Member #12694 http://www.fsf.org
LO recurring contributor



--
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] Writer into Calc

[Girvin Herr]

On 3/21/19 12:04 AM, Brian Barker wrote:

At 19:20 20/03/2019 -0400, Charles Meyer wrote:
Has anyone been able to "import" or "insert" content from Writer 
(tables) into Calc so there are no extra spaces, fits on the same one 
page, etc. in Calc as it does on one page in Writer?


Very probably not! Formatting in spreadsheets is entirely different 
from that in text documents. But you can easily paste material from a 
table in a text document into cells of a spreadsheet. Then you can 
reformat the material in the spreadsheet appropriately.


Why would you want to do this? Pagination comes into the story only 
when you print your document. If the text document is paginated as you 
wish, why not print that? I can more easily imagine a need for the 
opposite: pasting an image of (part of?) a spreadsheet into a text 
document.


This sounds like a task that needs to be rethought from the beginning: 
consider exactly what you are trying to do. Would it be better to 
start with the spreadsheet?


I trust this helps.

Brian Barker


Another option is to use the OLE (Object Linking and Embedding) 
function. This feature allows taking an existing spreadsheet and insert 
it into a Writer document. I know this is the opposite the OP asked for, 
but it may be a possible solution. Historically, I have had mixed 
results with the LO OLE feature, so it may need some experimentation to 
get it to work as needed. Here is how:


Insert > Object > OLE Object > LibreOffice x.x Spreadsheet

I would choose "Create from file" and maybe "Link to file". That way, a 
Calc file is used by Writer, but can still be maintained by Calc. 
Without Link to file, Writer will create a local spreadsheet in the 
document and not use a separate file, so Calc would not have access to 
it outside the document. How it works is that clicking on the OLE 
spreadsheet in Writer will bring up a Calc-like editor where the 
spreadsheet data can be edited. Exiting this editor will return the the 
Writer document mode. All without exiting the document. That may have 
some advantages, so it will need to be decided by the OP which type 
function is needed.


I checked, and Calc does have the insert OLE function, but the Writer 
option is "LibreOffice x.x Text", which may just insert the Writer 
document into a spreadsheet cell. I am guessing, having never used that 
function in Calc. Both features will need some experimentation.


HTH.
Girvin Herr



--
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] Auto recovery problem

[Girvin Herr]

Carl,

I have experienced this endless auto-recovery on startup problem before. 
Whenever I got it, I "reset" my user profile and it stopped doing it. 
Offhand, I don't remember the exact steps to do that, but a search of 
this forum should turn up the procedure or maybe someone out there who 
knows it can give it to you. I have developed the process of 
occasionally saving the good profile in a directory somewhere so I can 
just copy it back to resolve such a problem and still keep my settings.


HTH.

Girvin Herr


On 2/4/19 4:13 PM, Carl Paulsen wrote:
Windows 10.  I think the LO version is either 6.1.4 or the previous 
one. Note that earlier in the day I was struggling with the same 
problems and saw that LO was telling me there was a new release. So in 
desperation I upgraded, which I think was to 6.1.4.  That computer is 
down for the night but I can check again tomorrow.  In any case that 
didn't fix it.


Note that I eventually got the system to work...sometimes.  I had 
de-registered the databases for my other issue, cleared the 
auto-recovery, started working with new files and got them to work 
sometimes.  An example is a label document, where I saved the labels 
as a LO Writer document with the merge fields in it, and merged to a 
full sheet.  That document continues to open with the auto-recover for 
itself, whether I discard the recovery point or not.  When it opens it 
seems to work fine.


With another document, a merge letter, I saved it with merge fields in 
place.  That one appears to open without the auto-recovery, though 
this one opened with merge data in the place of the fields.  And in 
this case I at some point I exchanged databases so I could build a 
merged file with a second data set. What seems like is happening is 
the documents get saved and closed, and then there's some kind of flag 
in the file that didn't get reset by the save, which marks it as 
damaged/needing recovery.  So it triggers the auto-recovery system 
even when it's not needed.


Carl


On 2/4/19 6:06 PM, Dan Lewis wrote:
Two things are needed to help you: your version of LibreOffice, and 
your operating system.


Dan

On 2/4/19 4:43 PM, Carl Paulsen wrote:
I'm trying to create a mail merge document for a letter.  I'm adding 
fields directly to retain formatting control and NOT have to deal 
with a text block which is how the wizard inserts addresses.  I've 
had some success after a LONG time trying to figure out how to do 
this.  Documentation is a bit lacking on this approach.


The real problem is happening when I try to close and then reopen 
the document.  The file appears to close fine but when I try to 
reopen it, LibreOffice seems to think the file is damaged.  I can 
recover and the file opens fine, but same thing happens when I try 
to reopen again.  I can also "discard" the auto-recovery which 
should fix the auto-recover so it doesn't come up again, but in fact 
it DOES.  Even when discarding recovery points, the program 
continues to think there's a problem with the file and re-opens the 
auto recovery.


I can't find any way to deal with this problem.  BTW, it seems that 
I finally figured out how to generate the merged letters, so I 
assume the file is basically OK.  But I still get the auto-recovery 
screen.


I'd love to get this to stop.  It's a hassle, slows me down, and 
doesn't show LO at it's best when I'm showing friends and clients.


Carl








--
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] Can't change printer properties - paper

[Girvin Herr]

Greetings,

I have run into this problem in the past, but forgot how to resolve it. 
I am running LO 5.3.4.2 on Linux. I have just installed a new printer, 
an Alps MD-1000 color printer. I created a document with an inserted 
image in color in OpenOffice and I am having a problem printing it at 
1200x600 there, so I figured I would try it in LibreOffice to see if it 
has the same problem. The document opens fine in LO, but when I try to 
print it using Ctrl-P, selecting the MD-1000 printer and then 
"properties", the "Paper" tab options are all greyed out and 
unchangeable. This was not happening in OpenOffice. Note that the 
"Device" tab options are not greyed out.


The only work-around to a similar problem I have notes on is to select 
the paper size in Format > Page, but that is not a solution in this 
case, since the printer print dialog Paper options include more options 
than just paper size. They include the DPI resolution also. These are 
not options in the Format > Page dialog.


What is the solution to get these options back again?


Thanks.
Girvin Herr



--
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] Summing currency fields in base

[Girvin Herr]

Adam,

I am not sure where you are wanting this total. There may be other 
methods to do this, but I prefer to do this calculation in a query. I 
use separate queries for reports and forms so a change in one does not 
affect the other. First, you need to create a query, if you have never 
created a query, then there is a learning curve you need to go through 
to create one. You could start by using the wizard to create the query 
and then save it and quit it. Then you can edit it in "Design Mode". 
Once in the Design mode, you can verify that your table is in the upper 
frame and your table field names are in the lower frame with the 
"Visible" block checked. This will get you what you have now and you can 
build on it. You need to add a field to the bottom frame with your 
formula in the "Field" block. For your example, it would look like  
"(fee1+fee2)" (no quotes). You probably don't need the parens either, 
but it is safe. Then, in the  "Alias" block of this new column, you need 
to add your new field name. In your example, it would be "Total" , again 
no quotes. Make sure the "Visible" block is checked or the total result 
will not be passed out of the query. If you already have a "Total" field 
in your table, then you need to have another, unique, name.


Then you need to have your form attach itself to the query rather than 
the table. You do this by opening the form in "Edit" mode and selecting 
the "Form" icon. At this time, you should have a popup called "Form 
Properties". Select the "Data" tab and in the "Content type" list select 
"Query". Then select your new query in the "Content" list. Then you can 
add the new "Total" field to your form. Doing so in a report is similar.


This is just a short description. You should be familiar with LO queries 
to do this. All of this may be documented well by now. So, read up on it 
if you want to create a query.


Note: One should never have calculated fields in a database. It wastes 
space.


Note also that I am using Mariadb (MySQL). If you are using the LO 
bundled database server, then this may be different.


HTH.

Girvin



On 10/11/18 11:39 AM, Adam Fenn wrote:

I have three currency fields - 'Fee1', 'Fee2' and 'Total'.  How do I add fee1 
and fee2 together and put the result automatically into the Total field?

TIA
Adam.


--
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] What happened to Base report copy-paste?

[Girvin Herr]

Drew,

Thanks for your quick response.

Yes, it still looks like I can run my reports, so this is not a workflow 
show-stopper. However, it is a productivity (or lack of) issue. Starting 
from scratch to make a new report with a minor change, such as a new 
"sort", when I could just copy and modify an existing report, is not fun.


AHA! I just thought of a work-around and it seems to work. I opened the 
existing report in "Edit" mode and then did a "Save-As" on it and got 
the new report, which I can now edit without affecting the old report.


Thanks for the help and inspiration.
Girvin Herr



On 09/22/2018 01:17 PM, Drew Jensen wrote:

I don't mysql up and running and a slightly newer LibreOffice
Version: 5.4.7.2
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2;

Also a slightly older version
5.3.0 Alpha

This is under Ubuntu 18.04, and I also checked with a couple of newer
versions of LibreOffice, again though only with hsql and firebird embedded
(in some of the newer versions) databases.

I have no problem doing a copy/paste of a report, either into the same ODB
or into a different ODB.

So it is only reports. I assume you can run those RB reports with your
current installation without problem.



On Sat, Sep 22, 2018 at 3:57 PM Girvin Herr  wrote:


Greetings,

I am running LO 5.3.4.2 under Linux 4.4 and gtk2 2.24.31 and with
Mariadb 10.0.35 and the mysql-connector-java 5.1.4.2 driver.

I just realized I can no longer copy a Base report and paste it as a new
report for modification. I do not get the "Insert as" dialog popup to
change the destination report name. No error, no nothing - as if I never
did the paste. I tried the mouse popup, ctrl-v, and the edit > Paste
functions. None worked. This feature works for all but reports. This
worked fine on older versions, but I do not know where it broke. What
happened to this valuable feature and is there another way to do a
report copy-paste?

Thanks.
Girvin Herr



--
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] What happened to Base report copy-paste?

[Girvin Herr]

Greetings,

I am running LO 5.3.4.2 under Linux 4.4 and gtk2 2.24.31 and with 
Mariadb 10.0.35 and the mysql-connector-java 5.1.4.2 driver.


I just realized I can no longer copy a Base report and paste it as a new 
report for modification. I do not get the "Insert as" dialog popup to 
change the destination report name. No error, no nothing - as if I never 
did the paste. I tried the mouse popup, ctrl-v, and the edit > Paste 
functions. None worked. This feature works for all but reports. This 
worked fine on older versions, but I do not know where it broke. What 
happened to this valuable feature and is there another way to do a 
report copy-paste?


Thanks.
Girvin Herr



--
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] Set JRE in LibreOffice

[Girvin Herr]

On 05/26/2018 11:47 PM, Robert Großkopf wrote:

Hi *,

I 'm using the internal database for deveopement of databases, with
pupils in scool and for some little projects, which only need a
standalone-database. For "normal" use I also prefer MariaDB. The native
driver had some (little) problems here so I switched to JDBC. I am using

jdbc:mysql://«hostname»:3306/«databasename»?autoReconnect=true

to connect to MariaDB and don't loose the connection to the server.

Problem for MariaDB/MySQL: You have to know much about SQL or you must
create the tables with PHPMyAdmin or something else for using
Innodb-tables and create relationships between them.

Regards

Robert

Robert,
Your "Problem for MariaDB/MySQL" has not been my experience. Yes, LO 
will not create the database. That must be done with the MariaDB/MySQL 
tools. I use the "mysql" tool and the "GRANT" and "CREATE DATABASE" 
commands to create my empty database. As you say, there are other tools 
available to do this. Use whatever tool fits your "hand". After the 
database is created, Base can be used to do all the rest: create tables, 
add relationships, etc. I did need to learn a bit of SQL to do some 
sorting of lists (tables) so they are alphabetically listed in the forms 
I made. I found the book "Teach Yourself SQL in 24 Hours" by Ryan 
Stephens and Ron Plew, published by Sams, to be of value to me.


To create the relationships, I use the "Queries" "Database" option of 
Base and the "Tasks" options. I prefer to start with the "Create Query 
in Design View" to do most of the work. In this option, the screen has 
two main windows. The top window is for adding tables and relationships. 
The bottom window is for specifying the Query output fields. Then, 
instead of specifying the table directly in a form or report data 
source, I reference the query for the form or report's data source 
input. This part of Base is very nice to use. Base then creates the SQL 
for you. If you really need to see or edit the SQL for the query, you 
can do that by editing in SQL mode. You can switch between the SQL 
editing mode and the "Design" editing mode with the Turn Design View 
Off/On icon. You can even "Run" the SQL or design to verify the output 
is what you expected with the "Run Query" icon. Slick.


BTW: I am currently running Mariadb 10.0.34 with mysql-connector-java 
5.1.42 and LO 5.3.4 and AOO 4.1.5 under Slackware Linux 14.2 
(k4.4.118_smp). I have a database with many tables and relationships and 
several Base forms for data entry/maintenance on each table. I have 
several reports with different data sorting to sort the table data by 
different fields. Each report and form has their own query. Several of 
my tables have thousands of records. Most of my tables contain critical 
inventory data that I need in my work. So, my Base usage is not trivial 
and losing it, including the report generation, would be painful to me.


HTH.
Girvin



--
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] Set JRE in LibreOffice

[Girvin Herr]

On 05/26/2018 02:59 AM, Tom Davies wrote:

Hi :)

Snip

Base is supposed to MUCH better when using an external back-end - it's what
Base was originally designed for and it's where Base beats Access.
Annoyingly that seems to be a little known fact that doesn't get picked up
on by people marketing LO.  Oddly hsqldb as an external back-end (ie
installing the most recent version into the OS and getting it from the
hsqldb project themselves, instead of using the old twisted version
hard-coded into LO) tends to be quite fantastic - but it is totally
dependent on Java and Java is a nightmare. So the move away from the
twisted old version of hsqldb to firebird is great news.

Snip

Hi Tom,
History lesson as I remember it: I suppose OO/AOO/LO wanted a built-in 
database engine to better compete with Access, which had the Jet engine 
built-in. Choosing hsqldb must have had its reasons back then. Going 
back before OO, StarOffice had its own built-in database engine, Adabase 
D, but I never could get it to work. (Granted, I was a database newbie 
back then and my problems may not have been StarOffice's fault.) I was 
glad to get OO (back then) working with MySQL about 2005. BTW: I think 
there was a crude and circuitous way to get Access 1.1 to talk to an 
external database server via a "connector" system. But I never tried to 
do it before I converted my databases to MySQL and never looked back.


My experience: I have always used LO with MySQL as my backend (aka 
server) with the Java connector between them. Actually, I am now using 
Mariadb, as this is what Slackware Linux distributes now. I have not had 
any problems with my database system, after the initial configuration 
learning curve. It works. Therefore, hsqldb and now the proposed switch 
to the firebird backend are a non-issue for me, as long as LO will 
continue to support the external server paradigm. But that is me. Others 
may require the built-in engine paradigm.


For years, LO, has been reporting an imminent built-in (aka "native") 
support for MySQL so that the Java connector is no longer needed. 
However, that functionality seems to be another myth.


Girvin Herr



--
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] Set JRE in LibreOffice

[Girvin Herr]

I keep seeing this fallacy of "only Base requires Java" repeated in this 
forum and so this is to keep the record straight. This may not be true, 
unless LO has changed in this area from 5.2.7. I can no longer test it. 
From my experience back in July of 2017, some of the configs in Tools > 
Options also seem to need Java. When I was having problems with LO Base 
crashing after a Linux Kernel security update which turned out to affect 
Java, I tried to use a tools config or two and some crashed the same way 
- implying they also used Java. IIRC, it was when I clicked on Internet 
> MediaWiki. So there may be other areas of LO in addition to Base that 
seem to use Java.


I remember a while back, LO was making an effort to remove Java 
requirements. Some progress to that end has been made over the years, 
but I suspect there are still some threads connecting LO to Java, 
besides Base.


Girvin Herr


On 05/25/2018 10:21 AM, zahra a wrote:

hello.
i read somewhere that libreoffice 64 bit and 32 bit both supports java
32 bit version.
i recommend you that download java 32bit and test it that does it
resolve your issue.
however, thanks God, java is required only for base and other
applications and features of libreoffice, dont need java.

On 5/23/18, Robert Großkopf  wrote:

Hi Thomas,


The Java website allows you download the newest version, but does NOT
ask about 32/64-bit installation.
(I presume it detects that automatically)

No, it seems it doesn't. I haven't any Windows running here, but heard a
lot of wrong Java for LO, because 64bit and 32bit problem. Seems the
automatic download of Java mostly installs 32bit-Java.

Have a look here for Java for 64bit and try:
https://www.java.com/de/download/manual.jsp

... it isn't /de for you, but you have to search for "All Java downloads".

Regards

Robert
--
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
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






--
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] LibreOffice - patches

[Girvin Herr]

Greetings,

In regards to FOS (Free and Open Source) Wine. (I have no experience 
with the proprietary and $$$ CodeWeavers version.) About 14 years ago I 
tried to get Wine running on my Linux computer to support M$ Access and 
the many hours of time I invested getting my databases usable on Access. 
I failed. At that time, the Wine developers seemed to be focusing on 
windows-based games, not the M$ office programs. I could not get Access 
to run under that version of Wine. I ended up converting my Access 
databases to MySQL and have not looked back at wine or any M$ programs 
since. Admittedly, in the 14 intervening years, the Wine developers may 
have changed their focus from gaming and it could now support the M$ 
office programs. This is just a suggestion to beware and check it out to 
see if it works first before jumping to Wine and "burning your bridges".


Girvin Herr



On 03/27/2018 05:53 AM, Tom Davies wrote:

Hi :)
I heard that just one part of the British Government (the local councils?)
'had to' pay M$ 6 million to be able to keep using Xp for just 1 more
year!! Presumably they are continuing to pay that annually because the cost
of upgrading, and then continuing to run all their legacy programs.
Apparently one part of the Dutch Government is doing something similar.

Ironically if they moved to any Gnu&Linux or even Mac it is highly likely
that their legacy apps would work for free(ish) through "WINE".  For a
relatively small amount CodeWeavers would give a greater level of certainty
with that or/and employ some permanent devs "in house" to focus on whatever
issues crop up with them - but that might involve increasing their local
workforce which is politically complicated (especially if their work was
then fed back into the OpenSource project.

Most of us don't have 6 million in chump-change to throw away on projects
shrouded in secrecy that have no foreseeable end-date - let alone one that
has minimal investment in our countries future and for a product that is
certain to be dropped at random over some profit-driven or political whim
of a foreign organisation!

Regards from
Tom :)








On 27 March 2018 at 00:09, toki  wrote:


On 03/26/2018 07:56 PM, Tanstaafl wrote:


  I'm pretty sure "mainstream support" ended a few years ago.  Quite

what that means seems very unclear.


It isn't that hard.

If what I was told was true, in 2010, Microsoft was still providing Tier
3 support to a customer that used MS Dos 5.0, and a different customer
that used Win95. (I suspect that in both cases, the support was a
license fee for source code, and the paying customer did the bug fixes,
etc. themselves.)

As such, the precise meaning can change, depending upon circumstances.


MAYBE unless they are a large multinational corporation or government

customer.

a) If you hadn't put the qualifier "government" in, I could have pointed
you at one organization that has that. However, I suspect that Microsoft
provides that support, more because to not do so will result in an
unwinnable lawsuit, than because they want to.

b) Microsoft has several tiers of support. In theory, individuals,
SOHOs, and SMBs can purchase support for any tier. However, simple
economics restricts Tier 3 to big governments and bigger corporations.
This is the level at which bug fixes, etc. are dealt with ASAP.


Long term support means just critical/security updates.

The big issue with "long term support", is how "long term" is defined.
Personally, I wouldn't call 18 months "long term", but marketing people
apparently think so.

jonathon



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




--
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] LO calc, how to copy partial sheet onto a new sheet

[Girvin Herr]

On 03/02/2018 01:26 PM, Brian Barker wrote:

At 16:03 02/03/2018 -0500, Bonly "Art" Bonly wrote:
I've developed a spreadsheet to manage my diet. I foolishly put 
several groups of columns that belong on a separate page onto sheet 
1.complete with formulas, proper formatting etc. How do I move 
the groups of columns and rows (with formulas and formatting info) 
onto a new sheet? I can do it using the Paste Special command, but 
the formulas come out all wrong, and would require a massive amount 
of re-edits to produce usable results, most of the problems are the 
formulas.


It's difficult to know without being aware of all details, but here 
are some ideas:


o Copy and paste using Paste Special, as you suggest, but tick the 
Link option in the Paste Special dialogue. That way, the new sheet 
will refer back to values in the original.


o Make a complete copy of the original sheet: right-click the sheet 
tab and select Move/Copy Sheet... . Delete material from both sheets 
as required.


o Use a careful combination of the above schemes.

If your spreadsheet is sensibly designed, correcting any formulae 
should generally require attention only to one instance and the use of 
the Fill function.


I trust this helps.

Brian Barker



Greetings,
Optionally for bullet #2, I find it easy to click on the upper left 
block where the row and column IDs converge (left of "A" and above "1"). 
This selects the entire sheet. I then use Ctrl+c to copy everything, 
then go to the blank sheet, click on the upper left block on that sheet 
to select it and use Ctrl-v to insert the data and formatting. Note that 
I found that this does not copy the Print Range settings.

HTH.
Girvin Herr


--
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] Save auto recovery information

[Girvin Herr]

My beef with autosave is that it seems to start saving just as I start 
typing and it does not save my keystrokes while it is saving and I don't 
notice it is saving. I end up after the autosave, having to evaluate 
what keystrokes worked and what didn't, and redoing the keystrokes that 
got ignored. I still find the autosave benefits outweigh these 
aggravations, though, so I have it enabled all the time.


Girvin Herr



On 02/17/2018 04:52 AM, Tom Davies wrote:

Hi :)
+1 to all points there!  I hadn't thought through my suggestions!

The autosave thing is something that annoys me more than it helps.  I don't
like my machine putting me on hold when it suddenly decides it needs to do
something.  I tend to switch features like this off where I can and then
just try to make sure I do my own saving and backups on my schedule rather
than on the machine's.

Regards from
a Tom :)


On 17 Feb 2018 10:05, "Peter Hillier-Brook"  wrote:


On 17/02/18 09:17, Tom Davies wrote:

Hi :)
I'm not sure how to open as read-only myself but i'd guess a right-click
either per file or on a group of selected files prolly has something.

Select "Open File" within Libre Office: in the dialogue box, in the
lower left hand corner is a clue and yes, it does function with multiple
selected files.


I think chmod might help change which user "owns" the files - or put them
on a volume/drive/folder that is mounted read-only - but that all seems a
bit extreme.

It's more than a bit extreme, but changing the permissions on the
reference files would work, with possible side-effects. i.e. Libre
Office would probably try to auto-save and might regularly bleat about
its inability to do so.


You could change the time-delay or completely eliminate the auto-save
feature.  Such options used to be in;
Tools - Options - ...
or something like that and prolly still are.

Not a good idea if one wanted to auto-save the "live" document, however
depress F1 and search for "auto" in Help.


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




--
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] LO not finding my scanner

[Girvin Herr]

Another datapoint:

I tried it with LO 5.3.4.2 under xfce and Slackware 14.2 Linux with my 
Epson 1660 Photo USB scanner and it worked fine with Insert > Media > 
Scan > Select Source.


Girvin Herr


On 02/07/2018 03:12 PM, Dave Barton wrote:

After seeing Tim's post I checked and Insert > Media > Scan > Select
Source... opens an empty dialog and Insert > Media > Scan > Request...
silently fails.
Version: 6.0.0.3 (x64) Build ID:
64a0f66915f38c6217de274f0aa8e15618924765 CPU threads: 8; OS: Windows
6.1; UI render: GL;

No issues with scan in either AOO or MS Office on the same machine.

Dave

On 07.02.2018 22:50, Joe Conner wrote:

Did you use the menu tree INSERT -> MEDIA -> SCAN?


On 02/07/2018 02:25 PM, Tim-L wrote:

I just installed 6.0.0.3 64-bit DEB for Ubuntu MATE 16.04LTS.

I was looking at some things and I went to "Insert/Media/Scan/Select
Source".  LO could not find my Canon TS9020 printer/scanner. I even
opened the printer's scan utility and still LO could not find the
scanner.

This is the first time I looked into using a scanner withing LO, so I
do not know if it is a 6.0.0 issue or 5.4.4 or earlier issue.

Any ideas?






--
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] Using the IBM line drawing set in Libreoffice

[Girvin Herr]

Greetings,

Try Courier. It is a fixed font and my Insert > special character list 
has the characters you need listed near the bottom.


HTH.

Girvin Herr



On 01/20/2018 02:33 PM, John R. Sowden wrote:
Arial has a couple of problems, one-I understand it is a microsoft 
font, 2-it is a proportional font, 3- it is a sans serif font.


How am I supposed to trnasfer the characters to my document?

John



On 01/20/2018 11:58 AM, Steve Edmonds wrote:

Do you mean the characters a bit like below (if they show on the list)
╚ ═
═╣

Insert, special character, arial, about 3/4 the way down.

steve

On 21/01/18 08:05, James Knott wrote:

On 01/20/2018 12:56 PM, John R. Sowden wrote:

I have a lot of forms created in WordStar using the line drawing
characters in the IBM fixed font character set.  I now need to create
some of these forms in LO.  Can't find a reference in the help dos.

I haven't heard of those characters in a very long time.  Does anyone
still use them?

BTW, it's been well over 20 years since I last saw Wordstar.











--
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] installed disc usage for LO

[Girvin Herr]

On 01/02/2018 08:06 AM, Virgil Arrington wrote:


On 01/02/2018 10:32 AM, James Knott wrote:

My first hard drive was 30 MB.  I also used PC-Write at home.  I used
Wordstar 2000 & Word Perfect at work.  I also maintained mini-computer
systems, including DEC VAX 11/780.


When my father ordered his first computer, he ordered a 10 mg. hard
drive. When he received it, it had a 20 mg. hard drive. They explained
that the 10 mg. had become obsolete since he ordered it and gave him a
20 mg. at no additional cost. He thought he had died and gone to PC heaven.

I also used PC-Write, both at home and at work. I worked as a lawyer and
wrote all of my legal documents and court briefs using that wonderful
little shareware program.

Obviously, LO can do much, much more than PC-Write ever could, but I
think it a shame that, after nearly a quarter century of development, my
quad-core laptop running LO on Linux is no faster than my old Toshiba
286 laptop running PC-Write and DOS. Admittedly, I'm comparing text
processing with text processing. I realize that, with graphical
interfaces, networks and Internet, more is required of today's
technology, but I often wonder. In terms of actual productivity -- i.e.,
getting work done, which for me meant word processing and an occasional
spreadsheet -- I was more proficient 25 years ago than I am now.

I recall back in those days reading an article that claimed that DOS
users made better writers than Mac users. The argument was that DOS
users focused on content (that was all they had), whereas Mac users
focused on appearance (since they could). I can relate for, these days,
I spend a lot of time tinkering with fonts, styles, etc., instead of
actually writing.

Virgil


I, too, sometimes get nostalgic for the "heady" old days of computing. I 
started in the late 70s with hand-coding programs on an Intel 8080 
system. I then graduated to CP/M-80 on an S100 Zilog Z80 processor 
system. I then built my own PC-XT from components in the mid 80s and PC 
technology has been progressing ever since. I keep a MS-DOS computer 
around to talk to a device programmer with proprietary DOS-based 
application software, just in case I need to program an EPROM or PAL 
chip. I still think the Cromemco Z-80 Macro Assembler which ran on 
CP/M-80,  is the best macro assembler I have ever used, so I created a 
CP/M-80 Z80 software emulator which runs on my Linux desktop, just in 
case I have a need to assemble a Z-80 program or maybe run a CP/M-80 
program or two. That emulator runs so fast on my desktop that a fairly 
large assembly is done virtually before I can release the Enter key. 
Would I go back? Heck no!


BTW: My Linux desktop has a 1TB hard disk and with a ton of large files 
on it, it is only 20% used. My only concern is backing up so much data 
each month. I am using 128GB USB Flash sticks, alternating monthly 
backups (odd and even months) between two 128GB sticks. I can get almost 
a year's backups from two computers on them. I am awaiting the 256GBs or 
512Gbs soon.


Girvin Herr


--
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] Re: Fixing 5.0 appearance

[Girvin Herr]

On 12/23/2017 05:54 AM, Virgil Arrington wrote:


On 12/23/2017 01:25 AM, Dave Barton wrote:

Even better if the day ever comes when we can have styles list undocked
from the sidebar, in the same way as Navigator.

Dave


Sort of like the way it was *before* the UI was improved.

A suggestion to developers:

I would be very slow to change a program's user interface. End users
learn a given interface and, over time, become very proficient with it
(I think back to my DOS days when I could make PC-Write sing and dance
with those Wordstar Ctrl-Key combinations). Then, someone comes along
and decides to improve the UI by moving everything around (including
moving the "Ctrl" away from its original position next to the "A" key).
Several years ago, MS did this when it introduced its Ribbon, which
forced end users to relearn their UI, which also meant *unlearning* many
of the methods by which they had previously grown very productive. I
think this is one reason Emacs and Vim are so popular with their
respective users; the interface remains consistent over the years.

One reason I like LibreOffice is because its developers seem to have
been very slow to make unnecessary changes to the UI. For that, I offer
a hearty thank you.

That said, I think the sidebar was at least incomplete in its
implementation, with no ability for the user to select the particular
sidebar he wanted as default (i.e., styles vs. properties.) I will
welcome a fix when it comes.

I seem to remember seeing the sidebar first on Apache OpenOffice and
thinking, "This is one reason I prefer LO." Then, on my next LO upgrade,
I saw the sidebar and was bummed. Did LO copy the sidebar from AOO, or
was it the other way around.

Virgil


Virgil,
Your posting brought back a faint memory of that sidebar. I squashed it 
long ago when it was first introduced and haven't seen it since. I had 
to bring up AOO and check for it. You can squash it with the little icon 
on the left margin of the sidebar. There are < and > icons that expand 
or squash the sidebar respectively. Yes, when squashed there is still a 
bit of wasted main window on the right side for these icons, but that is 
the sacrifice for options.

HTH.
Girvin Herr

--
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] Focus issues on Linux

[Girvin Herr]

On 12/23/2017 12:11 PM, Dave Howorth wrote:

On Sat, 23 Dec 2017 11:38:32 -0800
John Jason Jordan  wrote:




On Sat, 23 Dec 2017 10:59:12 -0800
Girvin Herr  dijo:


At this point I should also add that there has long been a bug with
floating toolbars on all Linux installations that I know of - that
is, if you have a toolbar floating it defeats the normal focus
actions of the Linux X-windows GUI. An example would make this more
clear. Let us suppose that I have only one Writer document window
open on the screen. While working on it I discover that I need to
use another program, e.g., Firefox, so I switch to a Firefox
window, leaving the Writer document on the screen. The Firefox
window will come up on top of the Writer document, as it should,
but when I later minimize the Firefox window I see the Writer
document is now completely visible again, but focus has not been
restored to it. And that means that clicking on its icon in the
Xfce panel will not minimize it until I click on the window to
restore its focus. Also, when I later restore a Writer document
window quite often the floating formatting toolbar fails to
appear. I can go into View > Toolbars and I see that it is still
checked, but to get it back I have to un-check it, then re-check
it. And when I restore a document to the screen by clicking on it
in the Xfce panel it comes up on the screen, but again without
focus. I wish there was a hotkey to open the Formatting toolbar,
like F11 for the Styles toolbar, but I can't find one. I tried to
create one, but I failed.

I have lived with this bug since forever, with all versions on OO
and now LO. I was hoping that this would have finally been fixed
in the new LO 5.4, but it remains unchanged. And a few years ago I
asked on one of these lists and after much discussion I tracked
the problem down to my floating toolbars, that is, if none of my
floating toolbars are on the screen the document window takes
focus as it should, like all other application windows. Also, the
problem is specific to each individual document window, e.g., as I
write this I have three Writer documents open, I closed the
floating toolbars on one of them and that window then took focus
properly, but I left the toolbars on the other two documents and
they still did not take focus properly.

I, too, use xfce4 and this window focus problem might not be an LO
issue. I use several other apps and have experienced this
frustrating focus problem with them too. I usually don't notice it
until after I type some text and discover the text is not showing up
in the window I expected. It would be an interesting datapoint if
someone in this forum who uses KDE or another Linux desktop would
confirm or deny they experience it with those desktops.

That is very interesting. I have hundreds and hundreds of applications
installed, as I do a lot of writing and desktop publishing, as well as
working with video and multimedia. LO is the only app where the focus
problem happens for me, although it does sometimes happen on web
pages, but that is surely a problem with the html code written by the
site developer. The browser itself has no problem when restored after
being minimized. I also have two computers, a laptop and a desktop,
both with Xubuntu 14.04, and I have the same focus problem on both of
them.

Yes, it would be very interesting to hear from other Linux users. We
might need to take this to another venue if the problem is not related
to LO. I originally researched this and discovered the connection
between the focus problem and floating toolbars at least a couple
years ago and I no longer remember where I asked - surely one of the
OO or LO listservs, and possibly the Ubuntu and/or Xfce forums.

I should also add that I don't believe that I ever filed a bug report.

Well I use linux but I use the openbox window manager and I don't see
any problems like this. I also use focus-follows-mouse so it may be you
need to be more specific about versions of everything and settings of
all options in order to narrow down exactly what is causing your
problems.

I just switched to Focus Follows Mouse "mode" and I like it so far. It 
may solve my frustration quotient. I just tested it with gschem and it 
does work to focus from the un-docked window to the main window with the 
mouse. Thanks for the suggestion.

Girvin


--
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] Focus issues on Linux

[Girvin Herr]

On 12/23/2017 11:38 AM, John Jason Jordan wrote:



On Sat, 23 Dec 2017 10:59:12 -0800
Girvin Herr  dijo:


At this point I should also add that there has long been a bug with
floating toolbars on all Linux installations that I know of - that
is, if you have a toolbar floating it defeats the normal focus
actions of the Linux X-windows GUI. An example would make this more
clear. Let us suppose that I have only one Writer document window
open on the screen. While working on it I discover that I need to
use another program, e.g., Firefox, so I switch to a Firefox window,
leaving the Writer document on the screen. The Firefox window will
come up on top of the Writer document, as it should, but when I
later minimize the Firefox window I see the Writer document is now
completely visible again, but focus has not been restored to it. And
that means that clicking on its icon in the Xfce panel will not
minimize it until I click on the window to restore its focus. Also,
when I later restore a Writer document window quite often the
floating formatting toolbar fails to appear. I can go into View >
Toolbars and I see that it is still checked, but to get it back I
have to un-check it, then re-check it. And when I restore a document
to the screen by clicking on it in the Xfce panel it comes up on the
screen, but again without focus. I wish there was a hotkey to open
the Formatting toolbar, like F11 for the Styles toolbar, but I can't
find one. I tried to create one, but I failed.

I have lived with this bug since forever, with all versions on OO and
now LO. I was hoping that this would have finally been fixed in the
new LO 5.4, but it remains unchanged. And a few years ago I asked on
one of these lists and after much discussion I tracked the problem
down to my floating toolbars, that is, if none of my floating
toolbars are on the screen the document window takes focus as it
should, like all other application windows. Also, the problem is
specific to each individual document window, e.g., as I write this I
have three Writer documents open, I closed the floating toolbars on
one of them and that window then took focus properly, but I left the
toolbars on the other two documents and they still did not take
focus properly.

I, too, use xfce4 and this window focus problem might not be an LO
issue. I use several other apps and have experienced this frustrating
focus problem with them too. I usually don't notice it until after I
type some text and discover the text is not showing up in the window I
expected. It would be an interesting datapoint if someone in this
forum who uses KDE or another Linux desktop would confirm or deny they
experience it with those desktops.

That is very interesting. I have hundreds and hundreds of applications
installed, as I do a lot of writing and desktop publishing, as well as
working with video and multimedia. LO is the only app where the focus
problem happens for me, although it does sometimes happen on web
pages, but that is surely a problem with the html code written by the
site developer. The browser itself has no problem when restored after
being minimized. I also have two computers, a laptop and a desktop,
both with Xubuntu 14.04, and I have the same focus problem on both of
them.

Yes, it would be very interesting to hear from other Linux users. We
might need to take this to another venue if the problem is not related
to LO. I originally researched this and discovered the connection
between the focus problem and floating toolbars at least a couple years
ago and I no longer remember where I asked - surely one of the OO or LO
listservs, and possibly the Ubuntu and/or Xfce forums.

I should also add that I don't believe that I ever filed a bug report.

For the record, I am using Slackware 14.2 Linux (k4.4.88) and xfce 4.12 
on an AMD dual-core Athlon 8GB RAM desktop workstation. The other apps I 
have seen this behavior on are gschem, an electronic engineering 
schematic capture program, and LibreCAD. Both of these programs switch 
window focus at odd, but seemingly consistent, times, like after a 
command is executed it will switch to a related un-docked window, where 
I will have to switch back to the main window to continue my work. 
Annoying. I have not used LO in the manner of this thread, so I cannot 
comment on the focus problem in LO.
I have never filed a bug-report on it anywhere either, probably because 
it is not fatal, just annoying.

HTH.
Girvin Herr


--
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] Re: Fixing 5.0 appearance

[Girvin Herr]

On 12/23/2017 10:26 AM, John Jason Jordan wrote:


At this point I should also add that there has long been a bug with
floating toolbars on all Linux installations that I know of - that is,
if you have a toolbar floating it defeats the normal focus actions of
the Linux X-windows GUI. An example would make this more clear. Let us
suppose that I have only one Writer document window open on the screen.
While working on it I discover that I need to use another program, e.g.,
Firefox, so I switch to a Firefox window, leaving the Writer document
on the screen. The Firefox window will come up on top of the Writer
document, as it should, but when I later minimize the Firefox window I
see the Writer document is now completely visible again, but focus has
not been restored to it. And that means that clicking on its icon in the
Xfce panel will not minimize it until I click on the window to restore
its focus. Also, when I later restore a Writer document window quite
often the floating formatting toolbar fails to appear. I can go into
View > Toolbars and I see that it is still checked, but to get it back I
have to un-check it, then re-check it. And when I restore a document to
the screen by clicking on it in the Xfce panel it comes up on the
screen, but again without focus. I wish there was a hotkey to open the
Formatting toolbar, like F11 for the Styles toolbar, but I can't find
one. I tried to create one, but I failed.

I have lived with this bug since forever, with all versions on OO and
now LO. I was hoping that this would have finally been fixed in the new
LO 5.4, but it remains unchanged. And a few years ago I asked on one of
these lists and after much discussion I tracked the problem down to my
floating toolbars, that is, if none of my floating toolbars are on the
screen the document window takes focus as it should, like all other
application windows. Also, the problem is specific to each individual
document window, e.g., as I write this I have three Writer documents
open, I closed the floating toolbars on one of them and that window then
took focus properly, but I left the toolbars on the other two
documents and they still did not take focus properly.



Greetings,
I, too, use xfce4 and this window focus problem might not be an LO 
issue. I use several other apps and have experienced this frustrating 
focus problem with them too. I usually don't notice it until after I 
type some text and discover the text is not showing up in the window I 
expected. It would be an interesting datapoint if someone in this forum 
who uses KDE or another Linux desktop would confirm or deny they 
experience it with those desktops.


Girvin Herr


--
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] Why are the people who answer users' questions are not getting counted?

[Girvin Herr]

Hi Tom,

I prefer the email-based mailing list because I get all the messages 
posted. From my experience on web-based forums, I will get, maybe, one 
email message about a new thread and then nothing. With them, I must 
keep polling the website and searching for new threads and/or messages 
regularly. It's a pain. I'm sorry, I don't have time for that. So I keep 
using this email list forum. It is more convenient for me.


As far as the recognition goes, this thread is the first I heard of any 
"rewards" for posting help for user problems. I don't expect any reward 
for my help to others. My reward is helping others as payback for all 
the help I got in the past and future from this forum.


Girvin Herr



On 12/10/2017 08:15 AM, Tom Davies wrote:

Hi :)
There is nothing new in this.

People providing User Support or Technical Support through these mailing
lists have never been recognised as being a useful part of TDF or the
LibreOffice community.

Similarly the Documentation Team and some others get no recognition nor
support from TDF.

So there is no reason to expect any of these mailing lists to close or
change at all.


I don't know why the Ask 'Bot' thing is different.  It was a new and
'trendy' thing that users were allegedly finding much more normal and
easier to use.  Many of the people doing the actual work of answering
questions found it painful because there was no way for them to chat or
help each other out so it was difficult to build-up team spirit or learn
from each other and so on.  So it's a very desolate and isolating system
that is not much fun for volunteers.

Another advantage here is that we sometimes get feedback on the quality of
our answers or on how well we welcomed people in to the community or
whatnot.

I get the impression that this mailing-list is more rewarding without
needing some fake points system to rate us and to potentially create
divisions and stuff like that.  I guess the AskBot needs the points&badges
system because it's the only feedback they can get.

Regards from
a Tom :)

On 8 Dec 2017 20:15, "Joe Conner"  wrote:


Interesting: I had no idea this even existed.

Blessings, Joe


On 12/08/2017 08:48 AM, Luuk wrote:


I also do not use Ask Libreoffice

But i do have (some) badges... ( 1gold, 1silver, 3 bronze)

But, most important question, what can i do with those badges

BTW the link to 'Ask LibreOffice' is: https://ask.libreoffice.org




On 08-12-17 16:56, Tim-L wrote:


On the "Projects" list, there is a link to the claiming of badges.

One thing I saw was the fact that people who help others in this list is
not counted for claiming badges. I do not use "Ask LibreOffice", yet, that
is the only place to help users if you want to claim a badge. As I said, I
do not use Ask LibreOffice, just the email list service. There are a lot
people here that help users.  I do not know how many of these users are
answering these questions over the ones who answering on Ask LibreOffice.

If only the people using Ask LibreOffice get recognized for helping
others, it seems to me that people who help others on this list are not
counted as helping others.  Are these lists no longer the place to help
users and will be dropped soon? That is the only way I can get my head
around the fact that the helpers are not counted in the "badge page"
https://wiki.documentfoundation.org/Badges/2017-11






--

A smile - is a sign of joy.
A hug - is a sign of love.
A laugh - is a sign of happiness.
And a friend like me??
...that's just a sign of good taste!!

Blessings, Joe Conner
Joshua 24:15 "...as for me and my house, we will serve the LORD."


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
subscribe/
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




--
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] Re: Reports Libre Base

[Girvin Herr]

Peter,

Here are some links to the threads I posted on LinuxQuestions.org about 
this matter. The thread title is (in case you want to search for it 
instead of logging into LinuxQuestions):


*Problem with the 4.4.75 kernel security upgrade dated 26 June 2017 (SSE 
2017-177-01)*


https://www.linuxquestions.org/questions/slackware-14/problem-with-the-4-4-75-kernel-security-upgrade-dated-26-june-2017-sse-2017-177-01-a-4175610351/

And somehow this one got separated from the main thread:
https://www.linuxquestions.org/questions/slackware-14/problem-with-the-4-4-75-kernel-security-upgrade-dated-26-june-2017-sse-2017-177-01-a-4175610351/page2.html#post5771382

The fix, as stated in the response from "bormant" on the 08-07-17, 11:25 
AM posting, is to add
"stack_guard_gap=6" to the LILO "append=" statement. If you are not 
using Lilo, then this may look differently. The idea is to pass this 
statement to the kernel when it boots. The second link is from a *buntu 
user and has a link to a ubuntu answer to adding this argument to Grub, 
the *buntu boot loader.

https://askubuntu.com/questions/19486/how-do-i-add-a-kernel-boot-parameter/19487#19487

There is one caveat to this fix I should have mentioned in my first 
response. The problem only shows up on 32-bit Linux, not 64-bit. So, if 
you are running 64-bit Linux, this may not help. The alternate solution 
would be to switch to 64-bit Linux, but then that could open up another 
can of worms. I have been sticking to 32-bit because of the 32-bit apps 
that I rely on.


I said it was technical.

HTH.
Girvin



On 11/28/2017 12:35 PM, Peter wrote:
Generally I allow all updates that come through.  How do I add the 
kernal boot parameter? Is there any documentation that will guide me 
through this process?


Peter

On 29/11/17 06:47, Girvin Herr wrote:

Peter,

What indication do you have that LO crashes?
Does it lock up or disappear (a hard crash)?

If the former, LO may just be taking a long time to process 
something. Patience is a virtue. I have some reports that search on 
database string fields that are quite slow to process the report. I 
can go out and have a cup of coffee and maybe it will be done when I 
return.


If the latter, there is a known security fix problem with Linux 
kernels later than about 4.4.75 and Java. This problem affected 
LibreOffice, but not OpenOffice, from my experience. There is a fix, 
but it is technical, regarding stack frame gap size settings. The fix 
is to add a kernel boot parameter to your booter (Lilo or Grub or 
whatever). If you updated your *buntu since LO last worked, this may 
be your problem.


HTH.
Girvin Herr



On 11/27/2017 09:25 PM, Peter wrote:
Base is installed and for my financial database the only problem I 
have is reports. I followed the advice and installed the packages. 
This made no difference. When I open the data base and select a 
previously defined report the data bases crashes. If  I use the 
report creation facility when I select the report wizard again the 
data base crashes.


Does base log these failures and if so where can I look at it?

My fishing data base opens but I cannot open fofms , tables , 
queries etc.


This problem with Base has occurred in the last 12 months.

Any suggestions on what to do next will be gratefully received.


Peter




On 28/11/17 09:20, Keith Bates wrote:
I use Ubuntu 17.04 also, including the Libreoffice packages 
installed directly from Ubuntu. The default install excludes Base, 
and if you can't open a database, it seems like you don't have Base 
installed. sudo apt install libreoffice-base should fix that,


For reports the packages you need are libreoffice-report-builder 
and libreoffice-report-builder-bin. Use sudo apt install 
libreoffice-report-builder* and they should install.



Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I 
assumed that this wouls automatically install all necessary 
packages. a=There is nothing that I can find in the__Ubuntu 
Software Repository that appears to relate to reports for 
LibreBase.  How can i find out what packages I have installed and 
what packages are required forreports to work.  I have an old data 
base which has not been uses since January 2015 which I tried to 
open today. This will no longer open for any thing , no forms or 
views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and 
reinstalled it

but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert

















--
To unsubscribe e-mail to: users+unsub

Re: [libreoffice-users] Re: Reports Libre Base

[Girvin Herr]

Peter,

First, I have both Apache OpenOffice (AOO) and LibreOffice (LO) 
installed on my Slackware Linux computer. I mostly use AOO, but when I 
do my database reports, I open up LO to process them with the LO Base 
Report Builder. I do this because AOO does not have a stable Report 
Builder (see below) and LO does. So far, in more than a decade of use, I 
have not had any document compatibility problems between the two apps. 
We can thank the Open Document people and how strongly the app writers 
conform to the Open Document standards for that.


In my experience, the database support file (the .odb file) that 
contains all the app support stuff and gui definitions for the database 
is compatible between the two apps. So, there should be nothing to do in 
your Base gui to switch. Actually, I copied my .odb file from AOO to use 
with LO when I installed LO and I keep them both in separate 
sub-directories, just to be sure either does not get corrupted from the 
other app. I makes a good backup too.


That said, I have no experience with the LO or AOO internal database 
server (aka "engine", "back end", etc.). I use the external Mariadb 
(MySQL) server for my databases, so switching the clients (AOO and LO) 
is not a problem for me. If you are using the internal database server, 
I would strongly suggest saving your database first and then opening it 
on AOO to see if it works. You can always restore the database with your 
saved database if things go terribly wrong.


Keep in mind that OpenOffice does not have a Report Builder bundled in 
like LibreOffice does. There is an old extension (Oracle Report Builder) 
available that is advertised as compatible up to AOO 3.x, but is claimed 
by some to still work with the latest AOO 4.x version. I have not tried 
it yet and even then, it may not be as stable or up-to-date as the one 
bundled in with LO.

https://extensions.openoffice.org/en/project/oracle-report-builder

HTH. Good luck.
Girvin


On 11/28/2017 12:31 PM, Peter wrote:
Definitly a hard crash. When restarted it goes into a recovery 
process.  If I install Open Office will it work with the Lire Base 
data bases or would I need to export the data and recreate new data 
bases?


Peter

On 29/11/17 06:47, Girvin Herr wrote:

Peter,

What indication do you have that LO crashes?
Does it lock up or disappear (a hard crash)?

If the former, LO may just be taking a long time to process 
something. Patience is a virtue. I have some reports that search on 
database string fields that are quite slow to process the report. I 
can go out and have a cup of coffee and maybe it will be done when I 
return.


If the latter, there is a known security fix problem with Linux 
kernels later than about 4.4.75 and Java. This problem affected 
LibreOffice, but not OpenOffice, from my experience. There is a fix, 
but it is technical, regarding stack frame gap size settings. The fix 
is to add a kernel boot parameter to your booter (Lilo or Grub or 
whatever). If you updated your *buntu since LO last worked, this may 
be your problem.


HTH.
Girvin Herr



On 11/27/2017 09:25 PM, Peter wrote:
Base is installed and for my financial database the only problem I 
have is reports. I followed the advice and installed the packages. 
This made no difference. When I open the data base and select a 
previously defined report the data bases crashes. If  I use the 
report creation facility when I select the report wizard again the 
data base crashes.


Does base log these failures and if so where can I look at it?

My fishing data base opens but I cannot open fofms , tables , 
queries etc.


This problem with Base has occurred in the last 12 months.

Any suggestions on what to do next will be gratefully received.


Peter




On 28/11/17 09:20, Keith Bates wrote:
I use Ubuntu 17.04 also, including the Libreoffice packages 
installed directly from Ubuntu. The default install excludes Base, 
and if you can't open a database, it seems like you don't have Base 
installed. sudo apt install libreoffice-base should fix that,


For reports the packages you need are libreoffice-report-builder 
and libreoffice-report-builder-bin. Use sudo apt install 
libreoffice-report-builder* and they should install.



Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I 
assumed that this wouls automatically install all necessary 
packages. a=There is nothing that I can find in the__Ubuntu 
Software Repository that appears to relate to reports for 
LibreBase.  How can i find out what packages I have installed and 
what packages are required forreports to work.  I have an old data 
base which has not been uses since January 2015 which I tried to 
open today. This will no longer open for any thing , no forms or 
views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the p

Re: [libreoffice-users] Re: Reports Libre Base

[Girvin Herr]

Peter,

What indication do you have that LO crashes?
Does it lock up or disappear (a hard crash)?

If the former, LO may just be taking a long time to process something. 
Patience is a virtue. I have some reports that search on database string 
fields that are quite slow to process the report. I can go out and have 
a cup of coffee and maybe it will be done when I return.


If the latter, there is a known security fix problem with Linux kernels 
later than about 4.4.75 and Java. This problem affected LibreOffice, but 
not OpenOffice, from my experience. There is a fix, but it is technical, 
regarding stack frame gap size settings. The fix is to add a kernel boot 
parameter to your booter (Lilo or Grub or whatever). If you updated your 
*buntu since LO last worked, this may be your problem.


HTH.
Girvin Herr



On 11/27/2017 09:25 PM, Peter wrote:
Base is installed and for my financial database the only problem I 
have is reports. I followed the advice and installed the packages. 
This made no difference. When I open the data base and select a 
previously defined report the data bases crashes. If  I use the report 
creation facility when I select the report wizard again the data base 
crashes.


Does base log these failures and if so where can I look at it?

My fishing data base opens but I cannot open fofms , tables , queries 
etc.


This problem with Base has occurred in the last 12 months.

Any suggestions on what to do next will be gratefully received.


Peter




On 28/11/17 09:20, Keith Bates wrote:
I use Ubuntu 17.04 also, including the Libreoffice packages installed 
directly from Ubuntu. The default install excludes Base, and if you 
can't open a database, it seems like you don't have Base installed. 
sudo apt install libreoffice-base should fix that,


For reports the packages you need are libreoffice-report-builder and 
libreoffice-report-builder-bin. Use sudo apt install 
libreoffice-report-builder* and they should install.



Keith


On 28/11/17 08:45, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I 
assumed that this wouls automatically install all necessary 
packages. a=There is nothing that I can find in the__Ubuntu Software 
Repository that appears to relate to reports for LibreBase.  How can 
i find out what packages I have installed and what packages are 
required forreports to work.  I have an old data base which has not 
been uses since January 2015 which I tried to open today. This will 
no longer open for any thing , no forms or views or tables can be 
opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert











--
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] Re: Reports Libre Base

[Girvin Herr]

Peter,

I don't know about *buntu, but I download, repackage and install the 
standard Linux LibreOffice from the LO website for my Slackware Linux 
system and it includes the report builder already bundled into it. There 
is no separate report builder plugin package to install. I am using the 
LO 5.3.4.2 report builder and it works fine out of the box. For the 
record, OpenOffice does not bundle the report builder and still uses a 
3rd-party plugin for that function. If that plugin is not installed, OO 
will pop up a message about it not being available. That said, I am 
pretty sure that the LO report builder uses Java. Could your problem be 
a Java (JRE) issue?


Did you "register" the old database in the new LO?
Use Tools > LibreOffice Base > Databases and "New" to register it if it 
is not in the list.
You may also have to setup your new Base, especially if you are using an 
external database server (aka "back-end"). I assume you are using the 
internal database engine, which I cannot help with. I am using the 
external Mariadb (MySQL) server.


Girvin Herr


On 11/27/2017 01:45 PM, Peter wrote:
I reinstalled Libre Office  Base from the Ubuntu repository. I assumed 
that this wouls automatically install all necessary packages. a=There 
is nothing that I can find in the__Ubuntu Software Repository that 
appears to relate to reports for LibreBase.  How can i find out what 
packages I have installed and what packages are required forreports to 
work.  I have an old data base which has not been uses since January 
2015 which I tried to open today. This will no longer open for any 
thing , no forms or views or tables can be opened.


Peter

On 28/11/17 04:50, Robert Großkopf wrote:

Hi Peter,


Libre Base 1:5.1.6~rc2-0ubuntu1~xenial2

Ubuntu 16.4

When I first found the problem I removed LibreBase and reinstalled it
but the problem with reportsremained the  same.

This is a special Ubuntu-version of LO. Have a look into your
packagemanager. Did you install all packages for the
libreoffice-report-builder? Have heard there isn't only one package,
which should be installed for reports with the Ubuntu-version of LO.

Regards

Robert






--
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] Re: Cannot open an encrypted basic library -> 100% CPU

[Girvin Herr]

On 10/16/2017 09:24 PM, Frédéric Bron wrote:

I have changed from Fedora 25 to Fedora 26 and I want to reinstall my
LibreOffice Basic libraries. It works fine with the unencrypted ones.

This is wrong: in fact, I import but the modules are empty.

apparently, this is not due to linux update but to LibreOffice update.
Macros working well with 5.2 version do not work with 5.3 version
(tested on linux F26 and Windows).
What's wrong with 5.3?

Greetings,
I am currently using Slackware Linux 14.2 (k4.4.88), LO 5.3.4.2, mariadb 
10.0.32, and mysql-connector-java 5.1.42.


Not sure this is your problem, but it sounds familiar. I have learned 
that there is a possibility that at least some LO macros are Java-based. 
If that is so, then your Linux kernel update may have broken LO, 
actually, the Java interface. This is ill-behaved, since a kernel update 
should never break Java or LO. I believe that LO is doing something 
ill-behaved or the LO code is making some bad assumptions about the 
stack frame gaps. For me, this has happened in LO 5.2 as well as 5.3, so 
it is not LO version-dependent, at least not the later releases.


When I updated my Slackware Linux 14.2 (k4.4.38) to kernel 4.4.75, LO 
Base started crashing hard, but OpenOffice did not. My investigation 
discovered that a Linux kernel security fix in k4.4.75  that increased 
the inter-stack gap was causing the problem. To make a long story short, 
there are two solutions that I know of:

1. Switch to 64-bit Linux, which does not seem to have this problem.
2. Add " stack_guard_gap=6" to the 32-bit kernel boot parameters. Which 
reduces the inter-stack gap to where Java/LO can operate.


This has been documented in the Slackware forum on LinuxQuestions.org. 
Search for my thread:


   *Problem with the 4.4.75 kernel security upgrade dated 26 June 2017
   (SSE 2017-177-01) *

on https://www.linuxquestions.org/ .

Ever since I have done #2, I have not had any LibreOffice Base crashes.

Note that in addition to Base crashes, I discovered some of the Tools -> 
Options dialogs crashed too, especially the "Internet" options. So Java 
must be used for more than just Base or macros. But this problem 
definitely crashes LO when trying to connect to my external Mariadb 
(MySQL) database.


HTH.
Girvin Herr


--
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] Mysql Native Connector for LO 5.4

[Girvin Herr]

On 09/08/2017 09:10 AM, H. Stoellinger wrote:

Hello,
I have been using LO-Base with all the available connectors to MySQL 
databases for years
(as a relatively happy customer!). Now I am having trouble using JDBC 
in my client-server
environment together with LO 5.4.1. Is there a native connector 
(64-bit, Linux-Mint 18.2)?

Thanks for the good work and regards from Salzburg
H. Stoellinger

Greetings,
For what it's worth, I am using 32-bit Linux LO 5.3.4.2 with the Oracle 
mysql-connector-java 5.1.42 driver and mariadb 10.0.30 and it works 
fine. Mariadb has their own connector-java driver, but since I have 
something that works, I have not bothered to investigate it. The 
so-called LO "native" driver has been promised for years and as far as I 
can tell, it is still a myth.


HTH.
Girvin Herr


--
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] Changing Default Page Size

[Girvin Herr]

On 09/06/2017 10:17 AM, Budge wrote:
Please could somebody tell me where to change the default page size.  
I am in UK and want A4 as the default but I keep getting "letter".
I do not wish to create a new template and put it in "My Templates" 
and make that the default.  I want to change the default setting at 
the lowest level possible.

Where is this set please?
Budge


Format -> Page -> Page

You could also change the page style, but the above should work.
HTH.
Girvin Herr


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)

[Girvin Herr]

Greetings,

I am not sure how or why this is affecting your formulas, but the period 
"." character is a meaningful character to Calc. It is used in sheet 
references, as in:


=Projects.D2
 ^

Where "Projects" is the sheet name and "D2" is the cell reference in 
that sheet.


Something may be confusing Calc, although I agree, it shouldn't be doing 
that and I do not know the remedy to prevent it from evaluating 1.5 as 
sheet 1, cell 5, which also sounds strange. Maybe that is why you are 
getting the errors. Calc expects a column letter before the 5 and it 
isn't there. There must be some way to force Calc to assume the 
formula's cell is numeric and not a cell reference. Maybe someone else 
has the solution.  Good luck.


HTH.

Girvin Herr



On 07/29/2017 12:57 PM, bunk3m wrote:

Hello Regina and Jorge,

Thank you for your help and suggestions.  I apologize for the delay as 
I didn't get the emails until I received the daily digest this 
afternoon. I have quoted both your posts in order to keep them 
together but this post is getting rather long.


I have tried your suggestions and I'm still unable to get a basic 
decimal calculation to work.


But now I am getting "#NAME?" for the cell containing "=1+1.5".

Interestingly enough, if I put "=1+20" it does give me "21" as an answer.

What it doesn't like about the decimal place I don't understand. This 
is very strange.


I tried using a comma "," instead as a decimal separator but that 
didn't work either.


Perhaps I should delete all the preferences and all the extensions in 
the Application Support folder??  Then I would have a "new" install?


Thanks again and regards,
B.

On 29.07.2017 06:00, rb.hensc...@t-online.de wrote:

Hi,

bunk3m schrieb:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel 
fine

and Apple Numbers.  Mac settings are to show decimal as "."

I have some LO Calc sheets that were created a few years ago that are
OK.  It seems to be some change in the last few versions??

Would you know if there are any override settings in the LO 
Preferences?

 I can't find it if it exists.


There exists the setting in Tools > Options > Language Settings > 
Languages, where you can determine the decimal separator key.


In addition there is a setting "Ignore system input language", but I 
don't know, what effect it has.


Another setting is in the cell properties in Format > Cells. On the 
tab "Numbers" you find top right a "Language" drop-down list. You can 
determine the language for numbers independent from UI. Do not use 
the "Default - xyz" but select the correct language explicitly.


That the places I know, which might influence it.

Kind regards
Regina




On 29.07.2017 06:00, jrodriguez1...@gmail.com wrote:

Hi again:

I suggest to do this in the Language-Language settings:

*User Interface: Select English US

*Locale Settings: English (Canada)

*Decimal Separator Key: uncheck

*Default Currency: Default CAD (English or French)

*Default Language for Documents: A English Canada or French

*Ignore system input language: check

I did this in my LO, and restart LO, and then LO accept " . " 
as decimal separator key


I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 18:14, jorge Rodríguez escribió:

Hi:

In LO Preference (Menu-Tools-Options-Language settings), you can 
find some ways to customize your settings.


I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 16:11, bunk3m escribió:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel 
fine and Apple Numbers.  Mac settings are to show decimal as "."


I have some LO Calc sheets that were created a few years ago that 
are OK.  It seems to be some change in the last few versions??


Would you know if there are any override settings in the LO 
Preferences?  I can't find it if it exists.


Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually 
that kind of issues are define with the Operative System. Try to 
find how is it define it in you Mac. Probably is as " , " and you 
have to change to " . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc. I trying to migrate over from 
Excel but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error. If 
I save the file as an xlsx and open in Excel it calculates OK and 
give 2.5.  If I then open the xlsx in LO, it still says "Invalid 
Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we

Re: [libreoffice-users] Re: LibreOffice Base crashes unexpected

[Girvin Herr]

On 07/21/2017 08:36 AM, Alexander Thurgood wrote:

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex





Greetings,
I got this link from a responder to my LinuxQuestions.org posting about 
this matter:

https://lkml.org/lkml/2017/7/3/1010
It appears even Linus Torvalds is not aware of the LO problems with this 
bug, at least not as of July 3rd. It may be a good thing for people at 
LO to "enlighten" him.


I've heard that another solution, other than to back up to a previous 
kernel as I have done, is to switch to 64-bit. This problem allegedly 
does not affect 64-bit Linux. I am running 32-bit and have no intention 
of changing at this time.

Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LibreOffice Base crashes unexpected

[Girvin Herr]

On 07/21/2017 08:36 AM, Alexander Thurgood wrote:

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex





Greetings,
I can confirm this bug on Slackware too, with the 4.4.75 kernel security 
update. I had a thread going here a few weeks ago asking for help on 
this problem. My solution was to back out the 4.4.75 kernel upgrade and 
go back to the 4.4.38 kernel. That fixed my problem.


Girvin



--
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] Problem with LibreOffice 5

[Girvin Herr]

On 07/17/2017 12:16 PM, Tim-L--Elmira-NY wrote:


I am having trouble with my Feb 2010 AMD quad core desktop.  It 
started out as Ubuntu 9.10.  I now have it set up for 14.04LTS. The 
big issue with going beyond that - i.e. 16.04 - is the fact that the 
upgrade craps out during the install process.  I have to have 13.10 or 
earlier to get my Canon MG6220 drivers to work. Then I get to 
update/upgrade it to 14.04LTS.  Then I must stop or crash the install 
and have problems with GRUB thinking that it had a good install for 
16.04 when it does not work at all.  At least now I have very little 
on the 250 GB OS's drive that gets lost.  I stopped using it for 
emails after that.  It is just a files server now - sort of.



Have you tried linuxquestions.org for support?
http://www.linuxquestions.org/
I use Slackware, not Ubuntu, but I have gotten some good support from lq 
in the past on a problem or two that stumped me. They may be able to 
help you with your upgrade installation.


To say something in support of software driver developers, I can imagine 
it is a daunting task to continue to support old hardware. Much of it is 
long gone to the trash collection or electronic recycling - especially 
mechanical devices that wear out, and driver developers probably no 
longer have an instance of a particular piece of old hardware to test 
their drivers with. Even if they had, the quantity of different devices 
and models could become a time-consuming task to test each and every 
one. In this day of new stuff coming on the market quickly, obsoleting a 
previous version, I imagine it is quite difficult to keep supporting the 
old stuff and some things slip through the cracks.


That said, I have quite a lot of old stuff and sympathize with what you 
are saying. I am satisfied with not buying the latest gadget as soon as 
it comes on the market and tossing out something that is still working. 
I always remember the wise words of Adam Osborne: "He, who lives on the 
cutting edge of technology, gets sliced to bits!"


Girvin Herr


--
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] Problem with LibreOffice 5

[Girvin Herr]

Tom,

Not just windows. I had a similar problem with, I can't remember if it 
was LibreOffice or OpenOffice on Linux years ago. After I installed it 
as root, I discovered the system directory permissions were all changed 
to 400 or some such - which means only the owner (root) can read them - 
no write or execute for anybody. Needless to say, that brought my system 
down and I too, had to do a lot of manual file permission changes. Thank 
goodness for the "-R" argument to "chmod" to change all recursively. 
From then on, I always build/package programs as a normal user first, 
not root. That way I get a lot of "Permission Denied" messages if some 
package installation is ill-behaved. My packaging scripts also change 
all package file permissions and owners to sane values before it is 
packaged. Since I instituted this policy, I have not had my system 
compromised by bad packages, and I build hundreds of them. Once bitten, 
twice shy.


Girvin Herr



On 07/09/2017 02:33 PM, Tom Davies wrote:

Hi :)
There was a Win 10 update that messed up the permissions in one of the
places i volunteer at.

I have no idea how to fix it.  I think we went through each individual
folder to reset the permissions but that sounds like a very inefficient and
highly error-prone way of trying to fix it generally.  Still, 'everyone'
loves Windows.

Regards from
Tom :)



On 9 July 2017 at 17:46, Tom Williams  wrote:


On 07/08/2017 02:56 AM, MICHAEL HELY wrote:

I am having trouble with this suite.   Normally I have been able to

open, amend, and save a document without any problem.However, in the
last week or so I can only open a document in read-only form.   To change
the contents I have to open a copy for editing, save that under a different
name, delete the original, and then rename the new document to fit in with
my filing system. This is time consuming, and very inconvenient.

The only event that I can identify as a possible cause is that about the

same time there was an automatic update to Windows 10, and there might be
some incompatablity between the updated Windows and LibreOffice.(I have
since installed the latest update to LibreOffice5, but to no avail;  the
problem is still there).However that is only a wild guess! I would
be grateful for your advice and a remedy

regards
M. Hely


I have two basic questions:

  1. Have you confirmed the original file wasn't already "read-only"
 before attempting to open it?
  2. Are you opening files from the file system or directly from an email
 attachment?


These are things you have probably already thought of but I want to ask
anyway.  :)   I've run LibreOffice 5 on a couple of Windows 10 systems
and have been able to open, edit, and save documents without issue.

Peace...

"The Other" Tom

--
/When we dance, you have a way with me,
Stay with me... Sway with me.../

--
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] Re: LO 5.2.6 crashes when logging in to mysql with Base - SOLVED

[Girvin Herr]

On 07/06/2017 06:41 PM, Virgil Arrington wrote:

On 07/06/2017 07:32 PM, Girvin Herr wrote:

My tests today showed that the latest Slackware Linux kernel security
upgrade 4.4.75 kernel is the culprit.

The upgrade manager on my Linux Mint 18 gives each package update a
priority level, 1 being the highest and 5 the lowest. The manager then
checks the upgrades it recommends installing. Since I installed Mint
nearly a year ago, the kernel upgrades have always been rated 5 and
never has the upgrade manager recommended that I install a kernel
upgrade. It also warns that kernel regressions can cause bad things to
happen. Since my computer is working fine, I have never clicked to
upgrade my kernel.

Virgil



Virgil,
I take computer security seriously, so when I see a security upgrade is 
available, I usually install it asap. That said, my experience with 
kernel upgrades has not been all that positive. Whenever something 
disastrous has happened, it usually has been after a kernel upgrade. I 
would guess my success rate is about 50% for kernel upgrades - whether I 
screw up the process, like forgetting to run LILO before rebooting, or 
in this case, a compromised kernel package. 50% is not a good success 
rate. Upgrades are risky, so your policy is probably a good one and I 
may assume that same policy from now on. Actually, I did have that 
policy a few years ago, but I got complacent from success and it bit me. 
I will have to revisit it. In general I agree with you - if it ain't 
broke, don't fix it.


Another aspect is that Slackware spends months, if not years, testing 
each new release to be sure it is a well-integrated and working set of 
packages. Updates, or what Slackware calls "patches", are not as fully 
tested because they need to get out fast, especially in the case of 
security patches. So, I doubt they are tested as thoroughly as for the 
distro release. Some "gotchas" are bound to slip through.


Note that what I am talking about are security updates, not non-security 
updates. The latter are totally optional. The former have a certain 
amount of risk if _not_ installed.


Note also that Slackware does not have an automatic update manger. I use 
the Linux security website, linuxsecurity.com ( 
http://www.linuxsecurity.com). The site lists the Slackware security 
updates by date released and then I go to my favorite Slackware mirror 
site, download the packages, check the gpg signatures, and install them. 
I usually do this once a month, just before I do my monthly backup. 
Actually, I install them _after_ the backup, so if something goes really 
badly, I can restore the backup and be where I was before the upgrades. 
Luckily, that has never been the case, but Murphy's law prevails, so I 
continue the policy.


Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base - SOLVED

[Girvin Herr]

That was one of the first things I tried. No joy. LO still crashed.

Now the good (sort-of) news. My tests today showed that the latest 
Slackware Linux kernel security upgrade 4.4.75 kernel is the culprit. LO 
on my laptop was working fine until I installed the kernel upgrade. 
After the upgrade, the laptop's LO crashes just as my workstation does.


I just returned to the previous kernel, tried LO, and it is now working 
again - no crashes. Whew!

That just goes to show you that even security upgrades can bite you.

Thanks to all who helped with suggestions to solve this problem.

Girvin Herr



On 07/06/2017 02:29 PM, Remy Gauthier wrote:

Hi,

Don't know if it's going to help you, but I have experienced some 
unexplainable crashes in the past which were "cured" by erasing the 
user configuration folders/data in ~/.config/libreoffice. Word of 
caution: erasing that folder will reset all settings to their default 
value. And I do mean all of them. One test you could do is to rename 
the folder, launch LO and see if the problem still exists; if it does, 
erase the new config folder and rename your previous one back, at 
least you will not loose anything.


I hope this helps.

Rémy Gauthier.

Le jeudi 06 juillet 2017 à 13:24 -0700, Girvin Herr a écrit :

Paul,

No, I haven't seen that. I filed it away for future reference if I ever
look at ODBC again, thanks. I looked at ODBC years ago and decided the
JDBC Connector was better suited for me. It has been working for me for
a long time until now.

I still think my problem lies in the many Slackware packages, both
security and non-security, I installed on my workstation between when LO
was last working on June 19 and the day before I noticed it stopped
working, July 4. This morning, I verified LO 5.2.6.2 does work on my
Slackware Linux laptop with updates installed up to the beginning of
May. That is about a month before the last time LO worked, so it should
be a good starting point. My plan is to install the Slackware updates
one at a time, checking if LO is still functional between each one. When
and if LO stops working, the package I just installed is most likely the
culprit and I can back it out again, hopefully restoring LO to
functionality. I can then try backing out the same package on my
workstation and hopefully get it working again. At least that is my plan.

Thanks again.
Girvin


On 07/06/2017 10:57 AM, Paul D. Mirowsky wrote:
Nothing specific, but it is an edge case sometimes missed when 
updating/adding other linux software. Have you seen 
https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odbc-connector-for-mariadb-in-base/ 
On 7/6/2017 1:11 PM, Girvin Herr wrote:
Thanks for your response. groups? In what way? Anything specific I 
should be aware of from your experience? Does something with LO 
require a special group, like k3b "suggests" a "burner" group, 
which I would need to be a member of to burn CDs? I just checked 
the group file and didn't see anything out of the ordinary or any 
group I should be a member of and am not. Since this problem seems 
ubiquitous across many LO versions and across other user accounts 
on my machine that I tested, I am now doubting this issue is a LO 
problem. Although it may be a problem which only LO encounters, 
since no other apps, including AOO, are having any problems. I am 
going off to do some troubleshooting with another similar computer 
which has not been updated yet since the end of March. Hopefully, 
it will work and I can incrementally install the security updates 
one at a time while retesting LO for crashing after each 
installation. Hopefully, the culprit update package will show 
itself. So, I may be off for a while, but if I discover anything, I 
will post it here on this thread. I will keep your suggestion in 
mind as I am troubleshooting. Thanks. Girvin On 07/06/2017 07:54 
AM, Paul D. Mirowsky wrote:
Just a shot in the dark. May want to look to see all proper groups 
are set. On 7/5/2017 6:56 PM, Girvin Herr wrote:

On 07/05/2017 02:14 AM, Alexander Thurgood wrote:

Le 05/07/2017 à 01:20, Girvin Herr a écrit : Hi Girvin,
Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I 
try to log in to Mariadb to access my database, LO crashes 
hard. This worked fine in 5.1.6 and it still works now in 
OpenOffice 4.1.3. I checked the Java config under Options and 
it is fine. I tried deleting the profile directory and starting 
from scratch. It still crashed. LO also crashes when I use the 
"Test Connection" button in the database configuration dialog 
to try to log in to Mariadb. Any ideas before I return to 5.1.6? 
Could be several things, although off the cuff, LO5.2.x was 
known to crash in certain circumstances with JDKu112, so either: 
- revert back to LO5.1.x or else - try updating your JDK to a 
much more recent one and see if that makes a difference with 
LO5.2.x, or else - move to LO5.3.x and a current

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

[Girvin Herr]

Paul,

No, I haven't seen that. I filed it away for future reference if I ever 
look at ODBC again, thanks. I looked at ODBC years ago and decided the 
JDBC Connector was better suited for me. It has been working for me for 
a long time until now.


I still think my problem lies in the many Slackware packages, both 
security and non-security, I installed on my workstation between when LO 
was last working on June 19 and the day before I noticed it stopped 
working, July 4. This morning, I verified LO 5.2.6.2 does work on my 
Slackware Linux laptop with updates installed up to the beginning of 
May. That is about a month before the last time LO worked, so it should 
be a good starting point. My plan is to install the Slackware updates 
one at a time, checking if LO is still functional between each one. When 
and if LO stops working, the package I just installed is most likely the 
culprit and I can back it out again, hopefully restoring LO to 
functionality. I can then try backing out the same package on my 
workstation and hopefully get it working again. At least that is my plan.


Thanks again.
Girvin


On 07/06/2017 10:57 AM, Paul D. Mirowsky wrote:
Nothing specific, but it is an edge case sometimes missed when 
updating/adding other linux software.


Have you seen 
https://ask.libreoffice.org/en/question/79135/how-do-i-set-up-a-odbc-connector-for-mariadb-in-base/



On 7/6/2017 1:11 PM, Girvin Herr wrote:
Thanks for your response. groups? In what way? Anything specific I 
should be aware of from your experience? Does something with LO 
require a special group, like k3b "suggests" a "burner" group, which 
I would need to be a member of to burn CDs? I just checked the group 
file and didn't see anything out of the ordinary or any group I 
should be a member of and am not.


Since this problem seems ubiquitous across many LO versions and 
across other user accounts on my machine that I tested, I am now 
doubting this issue is a LO problem. Although it may be a problem 
which only LO encounters, since no other apps, including AOO, are 
having any problems. I am going off to do some troubleshooting with 
another similar computer which has not been updated yet since the end 
of March. Hopefully, it will work and I can incrementally install the 
security updates one at a time while retesting LO for crashing after 
each installation. Hopefully, the culprit update package will show 
itself. So, I may be off for a while, but if I discover anything, I 
will post it here on this thread. I will keep your suggestion in mind 
as I am troubleshooting.


Thanks.
Girvin


On 07/06/2017 07:54 AM, Paul D. Mirowsky wrote:

Just a shot in the dark.

May want to look to see all proper groups are set.



On 7/5/2017 6:56 PM, Girvin Herr wrote:



On 07/05/2017 02:14 AM, Alexander Thurgood wrote:

Le 05/07/2017 à 01:20, Girvin Herr a écrit :

Hi Girvin,


Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try 
to log
in to Mariadb to access my database, LO crashes hard. This worked 
fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked 
the Java

config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also 
crashes
when I use the "Test Connection" button in the database 
configuration

dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that 
makes

a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.


Why do I mention a Java problem ? Because the devs changed the 
version
number recognition pattern for JDK/JVM instantiation somewhere 
between
5.1 and 5.2, and this is what caused crashing for some. This was 
fixed
in 5.3. Of course, it could all be specific to your Slackware 
setup...


Alex



Alex,
Thanks for your prompt response. I have been working on this 
problem all morning. I first upgraded jdk-8u112 with jdk-8u131 with 
the same results. I then tried LO 5.2.7.2 with the same results. I 
then tried LO 5.3.4.2 with the same results. I then upgraded the 
MySQL Connector from 5.1.40 to 5.1.42 with the same results. 
Nothing I do seems to affect whatever is causing LO to crash. I 
also started LO from a console to see if LO spit out any pertinent 
messages when it crashed - none.


Whatever is happening here, it is broad. I even tried to use my 
OpenOffice Base odb file with the same LO results. Now this file 
works fine in AOO.


There are two datapoints I had not thought of when I posted my 
message yesterday. One is that I successfully edited and printed a 
report on 6/19/17 with LO 5.2.6.2. So, it was working at that time.


The other is that I upgraded glibc from version 2.23 build 1 to 
2.23 build 2 yesterday, before I noticed LO

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

[Girvin Herr]

Thanks for your response. groups? In what way? Anything specific I 
should be aware of from your experience? Does something with LO require 
a special group, like k3b "suggests" a "burner" group, which I would 
need to be a member of to burn CDs? I just checked the group file and 
didn't see anything out of the ordinary or any group I should be a 
member of and am not.


Since this problem seems ubiquitous across many LO versions and across 
other user accounts on my machine that I tested, I am now doubting this 
issue is a LO problem. Although it may be a problem which only LO 
encounters, since no other apps, including AOO, are having any problems. 
I am going off to do some troubleshooting with another similar computer 
which has not been updated yet since the end of March. Hopefully, it 
will work and I can incrementally install the security updates one at a 
time while retesting LO for crashing after each installation. Hopefully, 
the culprit update package will show itself. So, I may be off for a 
while, but if I discover anything, I will post it here on this thread. I 
will keep your suggestion in mind as I am troubleshooting.


Thanks.
Girvin


On 07/06/2017 07:54 AM, Paul D. Mirowsky wrote:

Just a shot in the dark.

May want to look to see all proper groups are set.



On 7/5/2017 6:56 PM, Girvin Herr wrote:



On 07/05/2017 02:14 AM, Alexander Thurgood wrote:

Le 05/07/2017 à 01:20, Girvin Herr a écrit :

Hi Girvin,


Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try 
to log

in to Mariadb to access my database, LO crashes hard. This worked fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the 
Java

config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also crashes
when I use the "Test Connection" button in the database configuration
dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that makes
a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.


Why do I mention a Java problem ? Because the devs changed the version
number recognition pattern for JDK/JVM instantiation somewhere between
5.1 and 5.2, and this is what caused crashing for some. This was fixed
in 5.3. Of course, it could all be specific to your Slackware setup...

Alex



Alex,
Thanks for your prompt response. I have been working on this problem 
all morning. I first upgraded jdk-8u112 with jdk-8u131 with the same 
results. I then tried LO 5.2.7.2 with the same results. I then tried 
LO 5.3.4.2 with the same results. I then upgraded the MySQL Connector 
from 5.1.40 to 5.1.42 with the same results. Nothing I do seems to 
affect whatever is causing LO to crash. I also started LO from a 
console to see if LO spit out any pertinent messages when it crashed 
- none.


Whatever is happening here, it is broad. I even tried to use my 
OpenOffice Base odb file with the same LO results. Now this file 
works fine in AOO.


There are two datapoints I had not thought of when I posted my 
message yesterday. One is that I successfully edited and printed a 
report on 6/19/17 with LO 5.2.6.2. So, it was working at that time.


The other is that I upgraded glibc from version 2.23 build 1 to 2.23 
build 2 yesterday, before I noticed LO crashing. But I tried 
returning to the old glibc version and LO still crashed, so I doubt 
glibc was the cause. The other Slackware packages that I changed 
yesterday are: bind, irssi, mozilla-firefox, openvpn, sudo, the Linux 
kernel, httpd, libcgroup, libcrypt, mkinitrd, mozilla-thunderbird, 
nasm, and pkg-config. None of these should have affected LO, but...


There is something else going on besides Base crashing. I was 
checking the "Tools" | "Options" with nothing loaded and when I got 
to the bottom item, "Internet" | "MediaWiki", LO crashed when I 
selected it. I wasn't even close to MySQL or Base at the time.


BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and Java, 
8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a lack of 
resources. Besides, as I said, OpenOffice is still running fine. My 
problem with using AOO, is that it does not have the Base Report 
Generator I need to print my reports.


Hope this helps narrow this problem down. I am about to issue a bug 
report on this. It is certainly repeatable, if frustrating.

Thanks.
Girvin








--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LO 5.2.6 crashes when logging in to mysql with Base

[Girvin Herr]

On 07/05/2017 02:14 AM, Alexander Thurgood wrote:

Le 05/07/2017 à 01:20, Girvin Herr a écrit :

Hi Girvin,



Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log
in to Mariadb to access my database, LO crashes hard. This worked fine
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java
config under Options and it is fine. I tried deleting the profile
directory and starting from scratch. It still crashed. LO also crashes
when I use the "Test Connection" button in the database configuration
dialog to try to log in to Mariadb.

Any ideas before I return to 5.1.6?

Could be several things, although off the cuff, LO5.2.x was known to
crash in certain circumstances with JDKu112, so either:
- revert back to LO5.1.x or else
- try updating your JDK to a much more recent one and see if that makes
a difference with LO5.2.x, or else
- move to LO5.3.x and a current JDK.


Why do I mention a Java problem ? Because the devs changed the version
number recognition pattern for JDK/JVM instantiation somewhere between
5.1 and 5.2, and this is what caused crashing for some. This was fixed
in 5.3. Of course, it could all be specific to your Slackware setup...

Alex



Alex,
Thanks for your prompt response. I have been working on this problem all 
morning. I first upgraded jdk-8u112 with jdk-8u131 with the same 
results. I then tried LO 5.2.7.2 with the same results. I then tried LO 
5.3.4.2 with the same results. I then upgraded the MySQL Connector from 
5.1.40 to 5.1.42 with the same results. Nothing I do seems to affect 
whatever is causing LO to crash. I also started LO from a console to see 
if LO spit out any pertinent messages when it crashed - none.


Whatever is happening here, it is broad. I even tried to use my 
OpenOffice Base odb file with the same LO results. Now this file works 
fine in AOO.


There are two datapoints I had not thought of when I posted my message 
yesterday. One is that I successfully edited and printed a report on 
6/19/17 with LO 5.2.6.2. So, it was working at that time.


The other is that I upgraded glibc from version 2.23 build 1 to 2.23 
build 2 yesterday, before I noticed LO crashing. But I tried returning 
to the old glibc version and LO still crashed, so I doubt glibc was the 
cause. The other Slackware packages that I changed yesterday are: bind, 
irssi, mozilla-firefox, openvpn, sudo, the Linux kernel, httpd, 
libcgroup, libcrypt, mkinitrd, mozilla-thunderbird, nasm, and 
pkg-config. None of these should have affected LO, but...


There is something else going on besides Base crashing. I was checking 
the "Tools" | "Options" with nothing loaded and when I got to the bottom 
item, "Internet" | "MediaWiki", LO crashed when I selected it. I wasn't 
even close to MySQL or Base at the time.


BTW: I am running a Dual-core Athlon CPU, 32-bit ix86 Linux and Java, 
8GB RAM, and 10% of 1TB disk space used. So it shouldn't be a lack of 
resources. Besides, as I said, OpenOffice is still running fine. My 
problem with using AOO, is that it does not have the Base Report 
Generator I need to print my reports.


Hope this helps narrow this problem down. I am about to issue a bug 
report on this. It is certainly repeatable, if frustrating.

Thanks.
Girvin


--
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] LO 5.2.6 crashes when logging in to mysql with Base

[Girvin Herr]

Greetings,

I am running LO 5.2.6.2 under Linux 4.4 (Slackware 14.2) with Oracle JDK 
1.8u112, MySQL_Connector_Java 5.1.40, and Mariadb 10.0.30.


Now that I upgraded to LO 5.2.6.2 from LO 5.1.6, every time I try to log 
in to Mariadb to access my database, LO crashes hard. This worked fine 
in 5.1.6 and it still works now in OpenOffice 4.1.3. I checked the Java 
config under Options and it is fine. I tried deleting the profile 
directory and starting from scratch. It still crashed. LO also crashes 
when I use the "Test Connection" button in the database configuration 
dialog to try to log in to Mariadb.


Any ideas before I return to 5.1.6?

Thanks.
Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] re: Libre Office - 5.3.3

[Girvin Herr]

zahra,

Yes, I use Slackware Linux exclusively on all of my computers.  I was 
surprised there is a LO 5.2.7.2 released.  I was not expecting that, so 
I have not been keeping up.  I will download it as soon as I can.  
Thanks for mentioning it.


I normally use OpenOffice (AOO) for most of my work, since there are 
some bugs in LibreOffice (LO) since 4.x  that I find frustrating.  
Mainly, that it does not restore my last session properly, where AOO 
still does.  However, AOO no longer bundles the Base Report Generator in 
their package and LO still does.  So I keep LO installed for my 
quarterly database reports that I generate.  Other than that. LO and AOO 
are interchangeable to me.


HTH.

Girvin Herr



On 06/02/2017 11:56 PM, zahra a wrote:

hi.
i think the most stable version currently is 5.2.7.2
but i decided to use 5.2.6.1 forever and never update it!

do you use linux?
i dont have direct link for downloading this version on linux, because
i use windows.
hope that help and God bless you!

On 6/3/17, charles meyer  wrote:

Girvin and Steve,

Thank you so much for all your details re: version differences!

Best,

Charles.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted






--
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] Libre Writer - go to a certain page in a text document

[Girvin Herr]

On 06/03/2017 07:13 AM, libreoffice-ml.mbou...@spamgourmet.com wrote:

zahra a wrote:

hello.
i have question.
mark, you mentioned that in libreoffice 5.3 control+g is go to page.
and also control+shift+f5 is for go to page too. am i right?


That's what worked for me.


also how can someone use navigator in 5.3


View > Navigator, or press F5 (the shortcut shown next to that option 
on the view menu). It's also one of the options on the sidebar.



and for me who i use 5.2,
how can i go to a specific page?


I don't have a copy of 5.2 around to check, but I'd assume it would be 
similar to either 5.1 or 5.3.


I am running 5.2.6.2 on Slackware Linux.  F5 brings up the Navigator 
dialog.  At the top is a window to enter a page number, then press Enter 
and it will go to that page.

HTH.
Girvin Herr


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Libre Office - 5.3.3

[Girvin Herr]

On 06/01/2017 10:54 AM, charles meyer wrote:

Thank you all for sharing your experiences with LO 5.3.3

Which LO version would you suggest I upgrade to from my 3.1?

Is LO 5.2 a safer option with most bugs worked out?

Thank you!

Charles.


Charles,
My rule is to use the version ending in 6 or greater.  That is x.x.6.  
Usually, that is where development stops for that series. Therefore, it 
is the most stable.  I am currently running 5.2.6.2. When 5.3.6 is 
released, I will upgrade to it.


"He, who lives on the cutting edge of technology, gets sliced to bits." 
- Adam Osborne


HTH.
Girvin Herr


--
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] Impress can't print to Postscript

[Girvin Herr]

Greetings,

This sounds to me to be less of a "fail" than a limitation, unless LO 
advertises that Impress will write a PostScript file format.  Then it 
could be called a "fail" and should have a bug report submitted on it.


To get you going if you really must have PostScript, you might try 
pstoedit, a vector file format converter. http://www.pstoedit.net/  It 
may convert (external to LO) a PDF file to a PS file for you.  I use it 
to convert a PostScript CAD drawing for printing to a DXF CAD drawing 
for editing in LibreCAD and it works fine for that.  There may be other 
converters out there.


HTH.
Girvin Herr



On 05/22/2017 09:34 AM, tedc wrote:

Using LibreOffice 5.0.6.2 under CentOS 7.x. Impress can only print to a
printer or to a PDF.  Even though I specify printing to a Postscript file
via
File / Print / Options / Print to file
then
General / Properties / Device / Printer language type / Postscript (level
from driver)
then specify the file name as
foo.ps
the result is always a PDF. This is a big fail.



--
View this message in context: 
http://nabble.documentfoundation.org/Impress-can-t-print-to-Postscript-tp4215005.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] style per sheet for different types of numbers

[Girvin Herr]

On 04/30/2017 09:14 PM, Brian Barker wrote:

At 11:46 01/05/2017 +0900, Thomas Blasejewicz wrote:
Naturally there are ordinary numbers like age (50 etc.), but there 
are also dates like first visit etc. I would like to apply the same 
style to every sheet.

However, numbers I can set ONLY to "Date", ...


No: if you want numbers to be numbers and to display as numbers, you 
would set the cell format to Number. There is surely no rationale is 
setting the format of such cells to Date?


... in which case "50" suddenly turns into some incomprehensible 
figure, ...


I don't understand this. You would fail to see 50 only if you had 
chosen some unsuitable cell format.


... or to "Numbers", in which case then the date is converted into a 
number that does not make any sense to me (although by now I know, 
there is a rationale behind that number).


For cells containing dates, you would want the cells to be formatted 
as Date (or conceivably Text).


Is there a way to set up a cell style (page styles do not have any 
settings for numbers, fonts etc.) that can handle BOTH standard 
numbers and dates?


Yes: that is the default situation. If you enter a number it will be 
saved as and be displayed as a number. If you enter something that 
LibreOffice recognises as a date, it will be saved as and displayed as 
a date - with the cell format being automatically changed to Date.


Or do I have to format every single column in every single sheet by 
hand?


Yes and no. Generally, you will *want* to do this. Being able to set 
different cell formats for different types of data is a useful feature 
of spreadsheet programs - not something to be avoided or worked 
around. Using cells styles can be a good idea, but you cannot expect a 
single cell format to serve all purposes. If it could, there would be 
no point in different cell formats existing.


Here's a idea. What you appear to need to do is to duplicate the cell 
formats that you have arranged in one sheet in other sheets. How about 
this?


o With the original sheet displayed, go to Edit | Sheet > | 
Move/Copy... (or right-click the sheet tab and select Move/Copy Sheet...)


o Select Copy and choose where to place your new sheet.

o On the new sheet, delete the data to leave a sheet with identical 
cell formatting. You can do this in various ways. You may wish to 
retain column headings and other data. You may wish to retain 
formulae: do this using Edit | Delete Content... (or press Delete) 
rather than Backspace and then choose in the Delete Contents panel 
exactly what you want done.


I trust this helps.

Brian Barker



Greetings,
What I do in these cases, is to create a new tab (sheet) at the end (far 
right tab) and rename it "Boiler" for boilerplate.  I then copy a 
formatted sheet into the "Boiler" sheet and delete the data. Then, when 
I need a new sheet, I insert the new sheet and copy the "boiler" sheet 
format into the new sheet.  This saves deleting the data each time a new 
sheet is added.
Note that in my experience, the Print Ranges settings do not copy over 
and need to be changed for each new sheet.

HTH.
Girvin Herr



--
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] Libre Draw - arrow creation

[Girvin Herr]

On 04/13/2017 09:50 AM, charles meyer wrote:

I’m trying to create/insert an arrow into a .png file using Libre Draw.

But, it’s not working.

I click the chosen arrow along the left in the Drawing toolbar and the
cursor changes from the usual I-beam to cross hairs.

I then move the cursor to where I want one end of the line or arrow to be,
and then I press the left mouse button to try to drag the mouse to the
other end of the line or arrow position but it moves the entire photo.

If I Right click the mouse, it cancels everything.

I tried first with the thin black arrows (choosing the diagonal one) in the
boxes along the left of the screen and then tried with the thick blue
arrows but neither worked.

I’m not sure what step (if any) I’m missing?

Thank for your help.

Charles.

I had this problem a long time ago.  The solution was in the layers 
concept.  The layers are the tabs at the lower left of the drawing 
area.  It looks like the default layers are "Layout", "Controls", and 
"Dimension Lines".  However, you can add layers to these.  The object, 
your png file, must be "locked" once you have it where you want it, to 
prevent it from being modified.  You right-click on the layer tab 
containing the png object and then select "Locked" from the options.  
From then on, anything on this layer may not be modified and anything 
you add on a different layer, can be edited on top of the locked object 
without moving it.  You may need to "Bring to front" an added object if 
it is behind the png object.   The object in the locked layer will not 
be selectable with this option.


Now, how to change a layer for a selected object, I cannot remember.  
Here is what the help says:



 Moving Objects to a Different Layer

Drawings in OpenOffice Draw support layers.

1.

   Click and hold the object until its edges flash.

2.

   Drag the object to the name tab of the layer you want to move it to.

3.

   Release the object.


You can see what layer a selected object is on at the bottom status 
line.  For example, There is a
"Slide 1/1 (Layout)" where "(Layout)" is the currently selected object's 
layer.


The help seems to be pretty good on layers.  I would suggest reading it.

HTH.
Girvin


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LibreOffice Viewer Roadmap

[Girvin Herr]

Greetings Tom,

I can attest that Base works well with MySQL/Mariadb (M/M).  I 
understand that Base still requires the Java Connector 
(mysql-connector-java) to talk M/M to the server (aka "Back End").  At 
least that is how I still have Base configured.  There was talk of a 
"native" Base driver for MySQL, but to my knowledge, that has not been 
deployed to date.


Girvin


On 04/06/2017 10:27 AM, Tom Davies wrote:

Hi :)
Ok, so is it just SQLite that is an odd exception or was the general 'rule'
i gave completely wrong?

I'm under the impression that Base works well with Postgresql,
MySQL/MariaDb, Hsqldb (as an external back-end), Firebird and many/most(??)
others? Also that the kinda default way iof using Base is to use some
external back-end - despite an internal one being hastily thrown on years
ago in order to downgrade Base to be more like Access?

Regards from
Tom :)



On 6 April 2017 at 17:48, toki  wrote:



On 04/06/2017 07:05 AM, Alexander Thurgood wrote:


the main problem with SQLite in relation to its use in LO is its lack of

strong data typing

Data typing and SQLite are mutually exclusive concepts.


in SQLite, which doesn't bode well when trying to determine whether the
string is a date, a timestamp, a large number, or some other kind of

As far as SQLite is concerned, there is no difference between an
integer, and an mp4 video file.

For those who don't pay attention to what they are doing, such things
can have unexpected, and occasionally undesirable results.

There is that fringe minority, that sees such data ambiguity as a virtue.

jonathon

--
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] LO won't open - claims Default.ott is corrupt

[Girvin Herr]

On 03/31/2017 12:16 PM, John Jason Jordan wrote:

On Fri, 31 Mar 2017 17:17:30 +0100
Tom Davies  dijo:


Renaming the user-profile will remove all the add-ons but it's
probably a good idea anyway.
Copying the default.ott from the working computer was brilliant imo,
as was trying to rename the previous one to see what happened.  I
wonder if renaming the whole folder that default.ott is in might make
LO regenerate the whole of that sub-folder?
Some sort of reinstall might dislodge something and fix it but
generally reinstalling tends to keep the user-profile (incl
Extensions/add-ons) intact so it might not do anything useful for this.
So unless Brian or Regina or someone like that weighs in then going for
Virgil's idea is likely to be the best 'first' step.  You can always
rename the user-profile (or chunks of it) back.
Good luck and regards from Tom :)

Thanks to Tom and everyone else who offered suggestions. I finally bit
the bullet and restarted the computer (I hate that because I have so
many things going on). Afterwards the problem was solved except for the
Default.ott.old file (my renaming). Writer happily opened the 'corrupt'
documents and, after I renamed Default.ott.old back to Default.ott it
opens without bitching about the missing file.

All is right in my world again. And as if it was a sign from the
computer gods, as soon as the problem was resolved the morning clouds
parted and the sun came out. Now I'm going for a walk to celebrate my
victory over evil bugs.

I do wish I knew what happened to cause this. It would be good to let
the devs know, but alas, this will probably remain a mystery.

Phase of the moon?  SEU (Single Event Upset) from Cosmic rays?  Once in 
a long while, I must restart my Slackware Linux machine when it doesn't 
work right after booting.  (I shut mine down every night.) So, it does 
happen with Linux, but not very often.  I would say about once or twice 
a year for me.  I chalk it up to a SEU from a Cosmic ray hitting a vital 
memory cell or two at this 4400-foot altitude.

Glad you solved your problem.
Girvin Herr


--
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] Upgrade loses fonts

[Girvin Herr]

On 02/14/2017 05:40 PM, Rich Shepard wrote:

On Tue, 14 Feb 2017, Tim---Kracked_P_P---webmaster wrote:


I did not see "tuffy" in the font list within LibreOffice till I looked
into the usr/share/fonts/truetype and /opentype. I never knew I had some
of these fonts till I looked. There are some of these fonts that were in
my ".font" folder and also in the "usr/share/. . ." folder. Most of the
".font" folder fonts are not in the "usr/share/ . ." list.


  I've never used ~/.font/; all the fonts installed on the system are in
/usr/share/fonts/ subdirectories. All in one place.

  Now I need the 5.1.4 tarball to re-install that version.

Rich


Rich,
I don't know where you got your Slackware package to install or if you 
created it yourself, as I do.  Or you installed the RPM directly.  I use 
SlackBuilds.org for my Slack packages.  Here is S14.1 LO 5.1.4:


https://www.slackbuilds.org/result/?search=libreoffice&sv=14.1

There is a link to the LO website where you can download 5.1.4. Alas, it 
is no longer available or broken.  I did some drilling work for you and 
here is 5.1.6 on a mirror site, which is supposed to be the stable version:


http://ftp.ussg.indiana.edu/tdf/libreoffice/stable/5.1.6/rpm/x86/

Another point is that I was told that the most stable LO is x.x.6+. 
Since 5.3 is not there yet, I will wait until 5.3.6 is released or try 
5.2.6.  I am currently running LO 5.1.6.2 on My Slackware 14.2 system.  
Like you, it runs fine.


I also am confused as to why you seem to have lost fonts in 
/usr/share/fonts.  You are not running LO as root are you?  That path 
and all the files in there should only have root write permissions.  
Running LO as a user should not remove fonts from that directory.  I 
have not looked at 5.3 yet, so I do not know what the distribution 
package would overwrite when installed as root.  I always look at the 
package innards before I install it to see if there are any nasties in 
there which could cause problems.  I have been burned in the past by 
packages that do nasty things.  I just looked at my LO 5.1.6.2 Slackware 
package that I created and there is no /usr/share/fonts directory, so it 
could not overwrite anything when installed.


Alas, reinstalling LO 5.1.4 will probably not restore your missing 
fonts.  Good luck.


HTH.
Girvin Herr






--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO 5.3 glitches

[Girvin Herr]

I can confirm Paul's solution.  I use Slackware Linux and xfce4 for my 
desktop.  xfce provides a similar popup when the .desktop file is not 
+x.  I routinely change the *.desktop files to +x to quiet the xfce 
complaints.


IMHO, This is not exactly a LO problem.  Sure, they could ship the 
distro with all .desktop files +x but that is not the proper solution, 
nor is it LO's responsibility.  The proper solution is to get the 
packager to make the change, or do it yourself as a part of system 
configuration.


As for changing the .desktop properties, such as the text or icon, that 
information is embedded into the .desktop file, which, as you 
discovered, is owned by root and cannot be changed without being root.  
I would suggest making a user-editable version by changing the symlink 
to the .desktop file in your ~/Desktop directory to a copy of the 
.desktop file itself.  Just find the desktop file and copy it into your 
~/Desktop directory.  Doing the copy should change the permissions to 
your user permissions.  If not, then you may have to be root to change 
them.  When you have a user version, then you can change the .desktop 
properties, including its filename which may be used as the desktop icon 
text.  Here, I am assuming your desktop abides by the opendesktop 
standards, which include the ~/Desktop directory.  xfce does and so does 
kde.  If not, you may have to find out where your desktop places the 
.desktop files displayed on the desktop.


HTH.

Girvin Herr



On 02/03/2017 06:38 AM, Paul D. Mirowsky wrote:

Try changing the Icon properties set to allow execute.

This may help.


On 2/2/2017 7:36 PM, Dave Stevens wrote:

Minor ones, the download and install were fine and that fixed my lack
of spell-checking that I was complaining of here a while back.

I'm using Linux Mint 18. The new icons for version 5.3 showed up in the
start menu and they work. My boot process ends at a desktop so I like
to have a LO Writer icon on the desktop so I can start there if I want.
I popped up the start menu, went into "office" then with the mouse
over the LO Writer icon, dragged it to the desktop, leaving me with a
desktop icon as launcher. Clicking on the desktop icon gives a dialog
box with a message, "untrusted application launcher" and "The
application launcher 'libre-office5-3writer.desktop' has not been marked
as trusted. If you do not know the source of this file, launching it
may be unsafe." Below are two buttons, "Launch anyway" and "Cancel" I
always launch and it works fine. Still it would be nice to make it
trusted.

Also the icon has a little lock emblem in the top right corner.
Ordinarily I expect to see that when I'm running as a user and trying
to launch a program owned by root. And finally I'd like to be able to
change the icon image and label text but an attempt to rename through
the icon properties dialogue box leaves me with a message box telling me
the item could not be renamed and 'unable to rename desktop file.'

All small stuff the upgrade is still very worthwhile.
TIA

Dave








--
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] LibreOffice help menu

[Girvin Herr]

On 01/24/2017 01:46 PM, Dave Howorth wrote:

On Wed, 25 Jan 2017 09:36:49 +1300
Mike Adams  wrote:


In between Uninstalling and Installing if you choose this route i
would look to reset the User Profile Data as well. Information here:
https://wiki.documentfoundation.org/UserProfile#Default_locations

This isn't Windows! I'm not reinstalling something that my distro has
installed unless I first know exactly what has gone wrong, if anything.

My personal suspicion is that this still looks like a build error.



Dave,
I understand where you are coming from, and I agree with you that it 
looks like a build problem.  I currently run LO 5.1.6.2 on a Slackware 
Linux system.  For years, I have been building my own Slackware 
installation packages from the downloaded LO "rpm" binaries.  When I 
download the LO program, I always download the corresponding LO help 
package along with it.  I have a shell script that takes those two 
distributions and makes a single Slackware installation package.  I have 
never seen the symptoms you describe you are having, so my guess is that 
the helppack did not get built or installed into your LO distribution.


As for the "reset the user profile" answer, that seems to be the stock 
knee-jerk reaction to strange LO behavior for years.  Instead of 
deleting my user profile (which is more than one file and I have never 
been told exactly which file is the culprit), what I do, is to move (or 
copy-delete) the profile directory, ~/.config/libreoffice/4 (if you are 
using LO 4+) on my Slackware system, to a temporary directory and start 
LO again.  These files are not part of the LO distribution, but are 
created by LO when it does not find them on startup.  Thus "resetting" 
them to the default configuration hard-coded into LO.  If that works, 
then you get to reconfigure LO to your liking and all is well.  If not, 
you can move the saved files back (after closing LO) and you are back to 
where you are now.  Consider it a diagnostic procedure.  So, it is a bit 
different than a windows environment: reboot for everything.


HTH.
Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Mysql Connector Java version

[Girvin Herr]

On 01/12/2017 09:03 AM, Alexander Thurgood wrote:

Le 12/01/2017 à 12:21, Alexander Thurgood a écrit :



Hmm, with LO5.1.6 and Java112, I seem to recall quite a serious crashing
problem...a bug that was corrected for 5.1.5, but not integrated to
5.1.6 when it branched off. Unfortunately, as 5.1.x is EOL, this won't
be fixed for those versions. THe problem doesn't affect current 5.2.3 or
5.3.x.


I forgot to mention that the crashing in LO5.1.6 was on OSX.

Alex



I forgot to mention that I am running Slackware Linux 14.2 32-bit x86 
(k4.4.14).
While waiting, I installed the 5.1.40 connector with JDK 1.8u112 and it 
does work with Apache OpenOffice 4.1.3, but I did not extensively test 
it yet.  I just did about the same with LO 5.1.6 and it is working about 
the same - not extensive testing.

So far - so good.

My policy is to use only the x.x.6+ versions of LO, since they are 
supposed to be the most stable.  So, I would have to wait for 5.2.6 for 
this potential bug fix.


Thanks for the responses.

Girvin Herr



--
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] Mysql Connector Java version

[Girvin Herr]

Greetings,

I am upgrading software and I downloaded the MySQL_connector_java driver 
version 5.1.40 for use in connecting LO 4.4.7 or 5.1.6 Base to my MySQL 
databases.  Previously, I have been using version 5.1.18, which worked 
fine.  Has anyone had experience with the 5.1.40 version and can verify 
it will work with Base?


I also installed java 1.8u112, previously 1.8u40. Any known problems 
with 8u112 and LO?


Thanks.

Girvin Herr


--
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] LinuxQuestions.org Members Choice Awards - "Office Suite of the Year" - vote

[Girvin Herr]

On 01/08/2017 05:29 PM, John R. Sowden wrote:
I have been using LO since the beginning of its time, OO since its 
beginning of time, and Star Office before that.  BUT, a close 
relative, who uses Windows and MSO, uses it because: (a) It's a bother 
to learn something new, (b) the files don't always show up right, (c) 
her other colleagues (school teacher) use MS O, so they discus doing 
things using MS O, and (d) most importantly, using 'something 
different' gets in the way of her doing her job (excellent school 
teacher).  I mention this because I feel that these are real facts of 
life when it comes to being a pioneer, using Linux and LO, or even LO 
under Windows.  I use Linux mainly because of the freedom based on 
technology, not structure based on profits.


John


+1
As for those who stick with microsoft: Use whatever tool fits your hand.
I, personally, haven't found anything msOffice can do that OpenOffice 
and LibreOffice can't do.  The UI is just different. Much of what AOO 
and LO do do, I don't use.  My concern is that AOO and/or LO are trying 
too hard to keep up with msOffice and are becoming feature bloated too, 
to the detriment of fixing bugs.  AOO and LO are great programs in their 
own right.  'nuff said.

Girvin Herr


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Bouncing messages from users@global.libreoffice.org

[Girvin Herr]

Luuk,

These are automated messages that indicate the LibreOffice mail-list 
server could not deliver some messages to you at your registered email 
address.  The problem cleared up and you got this message from it.  It 
is letting you know which message(s) did not get delivered to you 
(50942).  You could use that number to look up the message and retrieve 
it, if you like.


That said, as far as I know, there is nothing fatal about these messages.

HTH.
Girvin Herr



On 12/19/2016 12:17 PM, Luuk wrote:

Why twice the same message?

Why this message at all?

What am i missing?

On 19-12-16 17:00, users+ow...@global.libreoffice.org wrote:
Hi, this is the Mlmmj program managing the 


mailing list.

Some messages to you could not be delivered. If you're seeing this
message it means things are back to normal, and it's merely for your
information.

Here is the list of the bounced messages:
- 50942
- 50942








--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How do I install the current Linux version

[Girvin Herr]

On 10/30/2016 10:56 AM, Ken Springer wrote:

On 10/29/16 8:04 PM, Girvin Herr wrote:

On 10/29/2016 06:52 PM, gordon cooper wrote:

Hi again Ken,
   There is some odd going on here. I don't use LO
very
often, most of my writing is done with Lyx, which then outputs as a
PDF and I print from there.  Have just looked at LO and found that
when it was asked to print, to either my little  Brother laser,or an
elderly HP Deskjet, the landscape paper option was greyed out,
just like yours.  These results came on a desktop, running MX-15
Linux.  Looked as if LO was deciding that the files would fit onto
portrait and not giving me the option to change.

I'll do some more digging. Think I have LO on a laptop with XP,
will dig it out .Perhaps somebody else will pop upon the forum
with an answer.

Gordon



This was brought out in an earlier thread.  Go to Print -> options tab
and check "Use only paper size from printer preferences."

That should enable paper sizes and orientation selection in the print
dialog.


It does not.  :-(

However, I discovered I can go to the printer's defaults, and set 
landscape there, choose the "Use only..." setting in LO, and I get the 
landscape layout when the spreadsheet is printed.


What I'm taking away from this is, it is a problem with LO 5.0.x that 
comes with Mint 17.3 Rosa.


So I still need to go somewhere to find out how I install the current 
version after I have it downloaded.


Thanks for the help and suggestions, everyone.


Yes, you must select landscape in LO (Format -> Page)  to format the 
document/page and you must select landscape in the print dialog to 
select the printer paper size/orientation.  If you don't then you get 
the symptoms you described in your OP.  This is not a bug.  It makes 
good sense.


The grayed out paper size/orientation in the print dialog I responded 
to, is a separate issue brought up by Gordon and seemed to have started 
with LO 5.x.  Don't know about 4.x.  LO 3.x did not exhibit this 
"feature" AFAIK.  OpenOffice 4.x does not exhibit this either, but then 
it is a different beast now.

Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: How do I install the current Linux version

[Girvin Herr]

On 10/29/2016 06:52 PM, gordon cooper wrote:

Hi again Ken,
   There is some odd going on here. I don't use LO 
very

often, most of my writing is done with Lyx, which then outputs as a
PDF and I print from there.  Have just looked at LO and found that
when it was asked to print, to either my little  Brother laser,or an
elderly HP Deskjet, the landscape paper option was greyed out,
just like yours.  These results came on a desktop, running MX-15
Linux.  Looked as if LO was deciding that the files would fit onto
portrait and not giving me the option to change.

I'll do some more digging. Think I have LO on a laptop with XP,
will dig it out .Perhaps somebody else will pop upon the forum
with an answer.

Gordon


This was brought out in an earlier thread.  Go to Print -> options tab 
and check "Use only paper size from printer preferences."


That should enable paper sizes and orientation selection in the print 
dialog.


HTH.

Girvin



--
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] Cannot edit a template ott file

[Girvin Herr]

On 10/06/2016 02:10 PM, Ken Heard wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 2016-10-06 00:37, jorge wrote:

Hi Ken and all:

It would be because the template is only for read, not for edit. In
this case you have to save with other name and then edit.

I hope this help,

Regards,

Jorge Rodríguez

What is the sense of having an edit button if it cannot be used to
edit something, in this case ott files?

Ken


-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iEYEARECAAYFAlf2vbwACgkQlNlJzOkJmTckCQCeK9dvOPbn0yh+9tQP/l/Tgh58
bQ4An3QLzuuC8ieEStbQ5r8X0/Ln+2d0
=HuJ8
-END PGP SIGNATURE-


Ken,

Well, you can do that.  But I think it will become a document (odt), not 
a template (ott).  Templates are treated differently than documents in 
LO, so you can't just open and save them like documents.  No, the best 
way to edit templates is through the Template Manager.


From the main page (no open documents) try Templates > Edit Templates 
and select the template you want to edit.


Or if a document is open, use File > Templates > Manage. In the Template 
Manager, select the template to edit then select the "Edit" button to 
open it for editing.


When you save the edited template, use the Save or Save As button as you 
would a document.  There are probably other ways to do this, but I think 
the key here is to make sure you open the template with the Template 
Manger, not like a regular document.


Note that if you make a template from a document, you must use the File 
> Templates > Save as Template process, not just save a document with a 
.ott suffix.


HTH.

Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Trial of LibreOffice

[Girvin Herr]

On 10/04/2016 07:20 PM, James Knott wrote:

On 10/04/2016 10:06 PM, V Stuart Foote wrote:

James Knott wrote

Neither of them currently uses soffice.  LibreOffice uses libreoffice
and OpenOffice uses openoffice4.

Sorry, Dave is correct.

Those actually are names of the AppData folders holding the user profile,
both programs on Windows builds use a mixed--soffice.exe launcher and
soffice.bin runtime.

And yes they conflict when both are fully installed/configured in Windows
registry--HKCU and HKLM/Software and especially if an instance of one or the
other is running an soffice.bin process of its QuickStarter.



Well, the KDE menu uses those commands, rather than soffice and they
also work at the command line.  If I use soffice, I get LibreOffice.
/usr/bin/libreoffice is a symlink to /lib64/libreoffice/program/soffice,
but /usr/bin/openoffice4 is a binary.


James,

Maybe not.  Have you looked at your /usr/bin/openoffice4 ?

On my Slackware system, I have a /usr/bin/openoffice4 file and it is a 
shell script which invokes /opt/openoffice4/program/soffice with "$0" as 
an argument.


Shell scripts are marked executable, but they are not a binary. You can 
read them as plain text.


Girvin Herr




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Trial of LibreOffice

[Girvin Herr]

Tom et al.,
I looked at this a while back and discovered that on my Slackware 
system, LO and AOO are installed into separate sub-directories in /opt, 
with symlinks in /usr/bin with different names pointing to the 
appropriate soffice.  soffice seems to be some sort of legacy name from 
the old Star Office days.  I, too, wonder why it is not changed to be 
something more unique.  However, I am not privy to the inner workings of 
these programs nor organizations.  The symlinks are an adequate work-around.

Girvin Herr


On 10/04/2016 08:35 AM, Tom Davies wrote:

Hi :)
Thanks :)  I think it used to be quite noticeable.  Whichever one was open
first (including quick-starter if that was enabled) would stay fine but the
2nd instance wouldn't open, or would get part-way open and then crash.

I think the problem was caused by LibreOffice and OpenOffice (and i think
the various forks which have now mostly merged back into LO or AOO afaik)
using the same command to open;
soffice
Since this would attempt to re-open the same program/suite in the same
program-folder but also trying to be whichever one you'd tried to open 2nd
it would all get very confusing for the poor machine.  It's possibly
entirely different from that but that is the way i understood it at the
time from various people trying to explain it.

So if you've not noticed that sort of thing happening then you are probably
fine.
Regards from
Tom :)

On 1 October 2016 at 12:18, James Knott  wrote:


On 09/30/2016 11:21 AM, V Stuart Foote wrote:

TomD wrote

There is no harm in having both LibreOffice and OpenOffice installed
alongside each other.
...

Actually they do not get along all that well, but will coexist if you
perform a custom installation and disable the "Quick Starter" feature

from

in the Optional Components section both--and also clear the "File Type"
dialog of checks to not assign a program association.



I have both installed on both Linux and Windows.  No issues I've noticed.


--
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] Re: Trial of LibreOffice

[Girvin Herr]

On 09/30/2016 02:23 PM, Steve Edmonds wrote:



On 2016-10-01 04:21, V Stuart Foote wrote:

TomD wrote

There is no harm in having both LibreOffice and OpenOffice installed
alongside each other.
...

Actually they do not get along all that well, but will coexist if you
perform a custom installation and disable the "Quick Starter" feature 
from

in the Optional Components section both--and also clear the "File Type"
dialog of checks to not assign a program association.

Stuart

I have had then running side by side on Linux fine for a few years, no 
special install. I still have to keep OO to cater for functionality 
dropped from LO and it works fine.

Steve


+1.

AOO 4.1.2 + LO 5.0.6.3 + Slackware Linux 14.1 (k3.10.103). However, I do 
not use the "Quick Starter" - my choice.  ...And vice-versa: LO still 
has the Base Report Generator, AOO does not. So I keep them both for the 
features I like and rely upon.


Girvin Herr



--
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] Drawing electrical symbols (images on dropbox)

[Girvin Herr]

On 09/29/2016 10:34 AM, Martin Marmsoler wrote:

Hello,

I'm trying to draw a schematic with electrical symbols. First I draw the
symbol and then I placed the glue points and then I created a group of the
hole symbol. I created a new theme in the gallery and moved the symbol in
this (pic1, 1.). But when I try to use the symbol and drag them out of the
gallery the glue points don't exist anymore (pic1, 2.). I can make just a
connection to the points of the border (Is there a possibility to delete
this points?). Is there a possibility to save the glue points too?
I took some symbols like the inductor out of the "freie-schaltzeichen"
library and there the preview of the symbols looks much better(pic2, left)
then my one (pic2,right) when I drag my symbols into a new library. How can
I get the same quality of symbol previews?
Here you can find the images:
https://drive.google.com/open?id=0B_vrp_7db9bBVmtGbmtUZmJBRWs

Best regards

Martin


Martin,

This sounds like using the wrong tool.  Have you looked at gEDA:

http://www.geda-project.org/

What you want is gschem, the schematic capture application.  I use it 
all the time for drawing schematics, and it includes a symbol library, 
however, your own symbols are easily created and used.  You don't say 
what your OS is, but there is a windows version of gEDA available.


HTH.

Girvin Herr




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Girvin Herr]

On 09/28/2016 03:06 AM, Philip Jackson wrote:

On 27/09/16 21:30, Girvin Herr wrote:

Greetings,

Where are you getting this Template Changer 1.2.7x?

When I go to the LO home page and then the extensions page, all I see is
still the 1.2.6 version for LO 3.3 dated 2013 and a warning that it has
not been updated for over a year!  As far as I know, this 1.2.6
extension is not compatible with LO 4.x or 5.x.


I quote from an email by Wiebe van der Worp of 7 April 2016 :


"... you need to use this link for a working Template Changer:
http://bugs.documentfoundation.org/attachment.cgi?id=103039";

That is where I got my version 1.2.7 from

HTH
Philip



Wiebe & Philip,

Thanks for the response.  I downloaded both the 1.2.7b and 1.2.7c 
versions.  I will make a Slackware package of it to install on my system 
with LO 5.0.6.3 and try it out.


I normally use the load styles option, but now and then, when I open a 
document, I get a popup saying the template has changed and it allows me 
to cancel or update the document template.  If I chose cancel, it sets a 
bit in the document to never allow this popup again for this document.  
The Template Changer was the only option to restore this popup option.  
I made the mistake years ago, thinking "Cancel" was the safe option and 
not knowing the consequences, to choose Cancel for some documents.  I no 
longer know which ones, since I didn't keep records of what I had opted 
for each document.  And so, I could still run into documents that have 
no way to restore this update feature or update the template without the 
Template Changer.


This is a strange and unintuitive place to find a working extension.  
Any plans to put it in the usual place for extensions under the LO home 
page to make it easier for users to find?


Thanks again.
Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Girvin Herr]

On 09/27/2016 07:02 AM, Philip Jackson wrote:

On 27/09/16 00:50, Wiebe van der Worp wrote:


3: File > Properties shows the right template.

Sometimes this happens, sometimes not. I've tried a few tests and can't
say what it depends on.

LO: Version: 5.2.1.2 Build ID: 1:5.2.1~rc2-0ubuntu1~xenial0, but as far
as I know it worked fine too in LO 5.1.

I think you must be using a later version from a ppa other than the main
Ubuntu repository - or else UbuntuStudio 16.04 differs from Ubuntu 16.04
in the LO selection.

Philip, are you using the TemplateChanger from the link mentioned at the
top? The file is template-changer-1.2.7c.oxt, so version 1.2.7c.

I just rechecked in Tools > extension manager and my template changer
says 1.2.7 although my download is 'template-changer-1.2.7c.oxt'
Just to be on the safe side, I removed and reinstalled the extension -
it still says 1.2.7 so I guess that's what 1.2.7c says.

My current concern is to pass a template I've developed to someone else.
I think the only safe way to do so, is to have place holder text (lorem
ipsum) in the template with an example of each style applied.

Philip


Greetings,

Where are you getting this Template Changer 1.2.7x?

When I go to the LO home page and then the extensions page, all I see is 
still the 1.2.6 version for LO 3.3 dated 2013 and a warning that it has 
not been updated for over a year!  As far as I know, this 1.2.6 
extension is not compatible with LO 4.x or 5.x.


Girvin Herr



--
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] 5.2 64bit DEB will not allow paper size selection

[Girvin Herr]

On 09/21/2016 05:03 AM, Tim---Kracked_P_P---webmaster wrote:

On 09/17/2016 02:06 PM, Girvin Herr wrote:

On 09/17/2016 03:30 AM, Jean-Baptiste Faure wrote:

Le 16/09/2016 à 21:43, Tim---Kracked_P_P---webmaster a écrit :

Today, I was working on a 11x17 inch tabloid paper poster.  I am using
Ubuntu 16.04 MATE 64bit running LO 5.2.0.4.  The paper size of the
document was the tabloid size.  When I went to print the document 
to my
HP printer [13x19 inch max] the paper size drop down menu was 
grayed out

and set for US Letter size.

Did you try to check the third option in the Option tab of the print
dialog : "Use only paper size from printer preferences" ?

Best regards.
JBF



Yes.  That worked.

However, it does not seem to be a global setting.  It appears one 
must set this option for each print, or at least for each document if 
the setting is embedded in the document. I have not tested that. A 
global setting option does not seem to be in the Tools > Options > 
Print menu.  How does one set this as the default?


BTW, On my LO 5.0.6.3, it is the 4th option down.  My 3rd option is 
"Use only paper _tray_ from printer preferences".


Regards.
Girvin Herr




OK, to answer several posts . . .

I do not have the HP printer set for tabloid in the Ubuntu printer 
driver settings - set for Letter, even though it has tabloid paper in 
the tray.


NO I do not have any settings stating to use only the loaded printer 
paper size.


One quirk is, now that I exported to PDF as a tabloid paper size, now 
the paper size box that is grayed out shows 11x17 inch [tabloid] size 
paper, not letter size, for the tabloid sized document.  NOW, the 
grayed out paper size is showing Letter size for the letter size 
document.  SO, it looks like there is some quirky bug somewhere, 
either in LO or in the Ubuntu printer drivers.





Are you using CUPS as your printer driver?
I had a problem with an app that did not allow me to configure the 
printer options in its print dialog, which was critical to selecting the 
11x17 size I wanted from a normally letter size by default printer.  I 
solved my problem by creating a logical printer in CUPS which I 
configured to default to 11x17 paper for this printer.  So now, whenever 
I want to print an 11x17 size in an app that doesn't allow or implement 
11x17 selection, I just select the 11x17 logical printer in the list of 
printers.  That works fine in my case.  It may be your workaround 
solution.  If your ubuntu is not using CUPS, then YMMV.


HTH.

Girvin Herr



--
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] 5.2 64bit DEB will not allow paper size selection

[Girvin Herr]

On 09/17/2016 03:30 AM, Jean-Baptiste Faure wrote:

Le 16/09/2016 à 21:43, Tim---Kracked_P_P---webmaster a écrit :

Today, I was working on a 11x17 inch tabloid paper poster.  I am using
Ubuntu 16.04 MATE 64bit running LO 5.2.0.4.  The paper size of the
document was the tabloid size.  When I went to print the document to my
HP printer [13x19 inch max] the paper size drop down menu was grayed out
and set for US Letter size.

Did you try to check the third option in the Option tab of the print
dialog : "Use only paper size from printer preferences" ?

Best regards.
JBF



Yes.  That worked.

However, it does not seem to be a global setting.  It appears one must 
set this option for each print, or at least for each document if the 
setting is embedded in the document. I have not tested that. A global 
setting option does not seem to be in the Tools > Options > Print menu.  
How does one set this as the default?


BTW, On my LO 5.0.6.3, it is the 4th option down.  My 3rd option is "Use 
only paper _tray_ from printer preferences".


Regards.
Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Line spacing on Writer

[Girvin Herr]

On 09/13/2016 06:54 PM, Steve Edmonds wrote:

I found my documents (LO) accumulated a pile of rubbish, styles, etc. 
from documents I import from. Copy/pasting from word docs copies the 
styles into the LO doc.
When I merge content from multiple documents (.doc, .docx, .odt, PDFs) 
into my documents I use an intermediary document to cleanse the 
copy/pasted content and apply the styles I want before copy/pasting 
again into my final document and this way my final document only has 
the look and styles I want.

steve


Greetings,

This post gave me an idea to look at the find command (Edit > Find and 
Replace... or Ctrl-F) dialog to see if it would search for a particular 
style.  I discovered that it does, under More Options!  I ran some tests 
and it does highlight the text with the selected style.  This could be a 
way to find and change those pesky imported styles.  When all are 
changed to the wanted style, then one could delete the now unused 
style.  I discovered long ago that LO will not delete a style which is 
in use (duh).  Finding all of them had been my problem until now.  
Possibly selecting a new style and "Replace All" may solve your problem, 
or at least make it less labor-intensive.


HTH.

Girvin Herr



--
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] Page formatting in writer goes nuts

[Girvin Herr]

On 09/04/2016 02:34 PM, Wiebe van der Worp wrote:

On 04-09-16 20:26, Bo Siltberg wrote:
I have a large document with lots of pictures currently using LO 
5.1.5.2.

After doing some editing, the page formatting function kicks in
automatically but does a bad job, inserting page breaks randomly and 
lots

of empty pages in sequence.


I am not sure it finishes, it looks like the process times out, or 
worse, crashes.


You could try to use a master document (.odm) with smaller 
sub-documents. It does not solve the problem, formatting is still 
stopping, but reformatting every sub-document/satellite can be forced 
after opening the odm, before exporting to pdf and or printing. On the 
other hand, if your document just opens correctly, you are probably 
creating extra work with this procedure.


From http://listarchives.libreoffice.org/global/users/msg46555.html

===
* Open document
* Update index
* Update selection for every satellite (using navigator)
* Update index again
* Export to PDF for printing and distribution
===


I have got the impression that it is the pictures LO has
problem with since most of these extra page breaks are made where 
there are

pictures nearby.


I agree. And calculating columns goes wrong too in certain large 
documents.



I have tried anchored them to the paragraph or as a
character without any effect that I can see. Closing and reopen the
document clears the problem as the initial page formatting works fine.


I did some testing with the large LO-manuals from 
https://www.libreoffice.org/get-help/documentation/. They don't suffer 
from this problem, despite the large amount of pictures. This is 
described further in the link to the thread above. These pictures are 
in a frame, with the frame anchored as (not to) character, always 
followed by an enter.


Unfortunately this causes a lot of white space left and or right from 
the frame when small pictures or listings are involved.




Greetings,
I have a document that has many tables of only two columns of about 1 
inch wide.  I set up a Section for each table and formatted the section 
as three page columns to spread the table data over the page and not 
waste paper.  As I add rows to the tables, the tables should expand 
serpentine fashion across the page and when the page fills, it should 
continue on the next page.  What I was occasionally experiencing was 
something similar to what you are seeing.  The tables would prematurely 
advance to the next page before filling the current page, or continue on 
the next page in other than the first section column, and blank pages 
would appear which could not be edited (the cursor could not be put in 
them), but were printed (negating the purpose of saving trees).  This 
anomaly continued to my latest LO 5.0.6.3.  The last time I experienced 
this problem, I found the Tools -> Update -> Page Formatting option and 
having nothing to lose, tried it.  I was pleasantly surprised that the 
pages were reformatted correctly with no blank pages and the table flow 
problems were corrected.


HTH.
Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Where is the LibreOffice.org gpg public key?

[Girvin Herr]

On 08/07/2016 02:39 PM, V Stuart Foote wrote:

Girvin,

gpg2 --keyserver hkp://keys.gnupg.net --recv-keys AFEEAEA3

C:\Program Files (x86)\GNU\GnuPG>.\gpg2.exe --keyserver hkp://keys.gnupg.net
--recv-keys AFEEAEA3
gpg: requesting key AFEEAEA3 from hkp server keys.gnupg.net
gpg: key AFEEAEA3: public key "LibreOffice Build Team (CODE SIGNING KEY)
" imported
gpg: no ultimately trusted keys found
gpg: Total number processed: 1
gpg:  imported: 1  (RSA: 1)

or you can open the archive and copy text to a file with .asc
extension--then import the certificate.

http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xF434A1EFAFEEAEA3

Same record of key AFEEAEA3

Stuart

=-ref-=
http://nabble.documentfoundation.org/Where-are-the-file-checksums-tc4100881.html




--
View this message in context: 
http://nabble.documentfoundation.org/Where-is-the-LibreOffice-org-gpg-public-key-tp4190282p4190354.html
Sent from the Users mailing list archive at Nabble.com.


Stuart,
I got it!  Per Piet's suggestion, similar to yours, I changed the 
keyserver and used the key ID rather than the org and my gpg was 
successful in getting and importing the public key.  Now the check with 
the .asc file is successful.  Thanks to all who have helped in this.


Now, how can we get this procedure on the website so others don't have 
to go through what I had to do to get the key?


Thanks for your help.
Girvin




--
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] Where is the LibreOffice.org gpg public key?

[Girvin Herr]

On 08/07/2016 02:19 PM, Piet van Oostrum wrote:

Girvin Herr wrote:
  >
  > Piet,
  >
  > I tried this and got:
  >
  > 502:$gpg2 --verify libreoffice-translations-5.0.6.3.tar.xz.asc
  > gpg: Signature made Wed 04 May 2016 03:22:04 PM PDT using RSA key ID
  > AFEEAEA3
  > gpg: Can't check signature: No public key
  >
  > This is what I have been getting each time I try to check the LO files.
  > "...No public key" is my problem.  I need the public key to import to my
  > gpg to complete the check.  I tried the:
  >
  > 504:$gpg --keyserver  hkp://subkeys.pgp.net  --search-keys libreoffice.org
  > gpg: searching for "libreoffice.org" from hkp server subkeys.pgp.net
  > gpg: keyserver timed out
  > gpg: keyserver search failed: keyserver error
  >
  > I just tried it again using documentfoundation.org but got the same
  > timeout result.
  >
  > I need to find the libreoffice.org public key to unlock the check process.
  >

OK, I was partly wrong.
It appears that I had the public key already downloaded. But even if I delete 
that key the gpg2 --verify will fetch it for me, but it gets it from keyserver 
hkp://keys.gnupg.net

And you cannot use libreoffice.org as search key, because that's not in the key.
Use the ID: gpg2 --keyserver  hkp://keys.gnupg.net  --search-keys AFEEAEA3
or bu...@documentfoundation.org

The key identifies as:
LibreOffice Build Team (CODE SIGNING KEY) 
  4096 bit RSA key F434A1EFAFEEAEA3, created: 2010-10-11

Hope this helps.


Piet,

That was it!  I changed the keyserver and used the ID and gpg found the 
key and imported it.  The check with the .asc file now works.  For some 
reason, my gpg will not automatically fetch the key from the .asc file.  
I must manually import it.  It may be that way for security reasons.


Thank you very much.
Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Where is the LibreOffice.org gpg public key?

[Girvin Herr]

On 08/06/2016 07:55 PM, V Stuart Foote wrote:

The MirrorBrain meta page for each build has a link to the GPG public
signature, as well as MD5, SHA1, SHA256 HASH

This as applied to 5.0.2.4

http://downloadarchive.documentfoundation.org/libreoffice/old/5.2.0.4/win/x86_64/LibreOffice_5.2.0.4_Win_x64.msi.asc

This is the link to the meta page for the Windows x64 build of 5.2.0.4

http://downloadarchive.documentfoundation.org/libreoffice/old/5.2.0.4/win/x86_64/LibreOffice_5.2.0.4_Win_x64.msi.mirrorlist

And you can find similar for all builds in the project archive.

http://downloadarchive.documentfoundation.org/libreoffice/old/



--
View this message in context: 
http://nabble.documentfoundation.org/Where-is-the-LibreOffice-org-gpg-public-key-tp4190282p4190286.html
Sent from the Users mailing list archive at Nabble.com.

I am aware of this.  These are the public check files (.asc), not the 
Public Key file.  I need the Public Key to import into gpg to allow it 
to use the ".asc" check files.  Both are needed to verify the downloaded 
file.  The Public Key file could be something like 
"Libreoffice-gpg-key", but it could be named anything.  For example, I 
have the following public key files:


Slackware-gpg-key
slackbuilds.org.GPG-KEY

I use these to check software updates from those sites.  I need to do 
the same for libreoffice.  If LO.o is supplying the public check files, 
it must have the public key available somewhere.


Thanks.
Girvin Herr



--
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] Where is the LibreOffice.org gpg public key?

[Girvin Herr]

On 08/07/2016 03:03 AM, Piet van Oostrum wrote:

Girvin Herr wrote:

  > Greetings,
  >
  > I keep running into a brick wall with this and I shouldn't be.  I
  > searched high and low for a place to download the LibreOffice.org gpg
  > Public Key file to no avail.  My searches of past threads regarding the
  > subject were not successful.  Since the download files on the LO website
  > have the gpg check files (.asc), I must assume the Public Key resides
  > somewhere and it should be easy to find, not kept secret.  In fact, the
  > location should be advertised along with the files to download or in a
  > relevant and prominent web page location.  I need it to verify the files
  > I download are not corrupt or insecure.  Does any one here know where I
  > can get the LO.o gpg Public Key?

Just do a gpg --verify on the .asc file and it gives you the key ID:

LibreOffice $ gpg2 --verify LibreOffice_5.2.0_MacOS_x86-64.dmg.asc
gpg: assuming signed data in 'LibreOffice_5.2.0_MacOS_x86-64.dmg'
gpg: Signature made Fri 29 Jul 08:21:07 2016 CEST using RSA key ID 
F434A1EFAFEEAEA3
gpg: Good signature from "LibreOffice Build Team (CODE SIGNING KEY) 
" [unknown]

Then you can fetch the key from one of the key servers, if you want. It's not 
really necessary.

Of course this doesn't guarantee that the key really belongs to the LO 
Development team.
But the fact that the signature is downloaded from the LO site should be enough 
guarantee.


Piet,

I tried this and got:

502:$gpg2 --verify libreoffice-translations-5.0.6.3.tar.xz.asc
gpg: Signature made Wed 04 May 2016 03:22:04 PM PDT using RSA key ID 
AFEEAEA3

gpg: Can't check signature: No public key

This is what I have been getting each time I try to check the LO files.  
"...No public key" is my problem.  I need the public key to import to my 
gpg to complete the check.  I tried the:


504:$gpg --keyserver  hkp://subkeys.pgp.net  --search-keys libreoffice.org
gpg: searching for "libreoffice.org" from hkp server subkeys.pgp.net
gpg: keyserver timed out
gpg: keyserver search failed: keyserver error

I just tried it again using documentfoundation.org but got the same 
timeout result.


I need to find the libreoffice.org public key to unlock the check process.

Thanks.
Girvin Herr





--
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] Where is the LibreOffice.org gpg public key?

[Girvin Herr]

Greetings,

I keep running into a brick wall with this and I shouldn't be.  I 
searched high and low for a place to download the LibreOffice.org gpg 
Public Key file to no avail.  My searches of past threads regarding the 
subject were not successful.  Since the download files on the LO website 
have the gpg check files (.asc), I must assume the Public Key resides 
somewhere and it should be easy to find, not kept secret.  In fact, the 
location should be advertised along with the files to download or in a 
relevant and prominent web page location.  I need it to verify the files 
I download are not corrupt or insecure.  Does any one here know where I 
can get the LO.o gpg Public Key?


Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Girvin Herr]

dBase files are plain text, but they have a specific format, which 
varies with version (feature add-ins).  I did some research on the file 
format when I was trying to decide how I wanted to approach resurrecting 
my files. Another option is to use the old dBase 1.x under dosemu under 
Linux.  Actually, that may be the easiest way to do it, but maybe not 
the long-lasting correct way.


Girvin


On 08/04/2016 09:57 PM, Walther Koehler wrote:

My doctors office uses a dBase based system for administration, keeping
patient records and so on. It has integrated LO for many purposes, i.e.
medical letters. As I was told, reading those dbf files using scripts is easy
(dbf_dump), modifying dbf files from outside the program however tedious,
they use LO base for that purpose. Unfortunately, the SQL commands for dBase
are limited.

Walther




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Girvin Herr]

On 08/04/2016 09:16 AM, toki wrote:

On 02/08/2016 16:39, Ken Springer wrote:

Now that you mentioned dBase, you may, or may not, be aware that LO has
a dBase option.  But a limitation to it that I found is that older

I didn't know this, but must admit dBase is probably not the best answer.

For most individuals, dBase3 is adequate. Perhaps a little slow, but
with current hardware, not spectacularly so. However, the major
stumbling block is that there is even less LibO documentation for it,
than there is for Base.

jonathon


I used dBase in the 80s and I must assume that since it still seems to 
have a demand, that users are still out there and happy with it.  It did 
have some nice features, such as the programming capability, which is 
why I tried to import my files into LO rather than reinvent the wheel.  
I suspect most of the users are "on the other side of the pond", since I 
rarely hear of dBase users here in the US.  Then again, Fortran is still 
active too.  It takes a long time for that flywheel to coast to a stop.


Girvin



--
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] Compatibility of LO Base with Access databases

[Girvin Herr]

On 08/02/2016 03:02 PM, tonybsa wrote:

In defence of LibreOffice Base.
Unlike Ian I have had very good results with Base.

Over the last 8 years I have used Base as a a "front end" to a MySQL database 
in 5 different countries for different projects.

One database was for the New Ireland (PNG) Provincial Government Old Age & 
Disabled Pension fund. 170,000 records updated and maintained by two dedicated data 
entry people, but accessed by approximately 35 other users. LibreOffice Base on 
Windows 10, 8 and XP PC, on Ubuntu 12.04 PC, on Macintosh OS X laptop. All 
connecting via ethernet and wireless to a Ubuntu 12.04 Server.

Another similar situation with Ministry of Tourism, Tonga collecting data on 
visitors to Tonga and also used for tourism venture's licensing and 
administration and conventions. 25 users connecting LibreOffice Base to MySQL 
on FreeBSD server, with Windows and Ubuntu PCs.

Full administration for 5 divisions in Sanma Provincial Council, Santo, 
Vanuatu. Including HR, Accounts, Youth, Disabilities, Planning, etc. 75 staff 
members, plus external users, with LibreOffice Base connecting to MySQL on 
Ubuntu 14.04 server from Windows (10, 8.1, XP), Ubuntu 12.04 and Macintosh PCs.

Now I used Access (Base not available) at Kokopo Business College for student 
records. Created a database for College Library with Base on Ubuntu PCs 
connecting to central MySQL database via Fibre Optics.

Had real trouble trying to set this up with Access for multiple users (25 
teachers, 10 admin staff).
When I got LibreOffice Base I had similar problems with using the HSQLDB engine.

I found that connecting Base to MySQL was very easy and I had real problems 
trying to connect Access.
I could also use Base on Linux machines and update all my colleagues to a 
consistent operating system.

You can not export Access forms, reports, macros, etc to use with Base but you 
can export all the data from Access and import it into Base very easily.

Sorry to keep on!!! I have had good results with LibreOffice Base connecting to 
an external database. I also make extensive use of Macros with Base.

Just in case you are wondering -- I am retired and about to have my 75th 
birthday so not just straight out of Uni.!!!

Thanks for listening

Tony Bray
tony...@mac.com
MacBook Pro 15 inch Mid 2009
2.8 GHz Intel Core 2 Duo, 4 GB RAM,
Mac OS X  10.11.6
LibreOffice 5.0.6
Scribus 1.4.4
Libre Project 1.5.19
Parallels Desktop 11.02
Ubuntu 14.04
LibreOffice 4.4.4
MySQL, PHP, Apache


I will second that defense of Base.  Tony's experience is much broader 
than mine, so counts for more points.  I only maintain two inventory 
databases with several tables each on a single Slackware 14.1 Linux 
machine.  Many of these inventory tables have more than 1000 records and 
growing.  I am connecting LO Base to a mariadb local server with the 
mysql-connector-java connector and, unlike Ian, in the over one decade 
of use I have never had a data loss or a crash of any sort that took my 
data or the Base forms or reports. It is very stable, which is good, 
because I rely on these databases very much.  I consider them critical.  
The Report Builder is another story, but it has never corrupted my data, 
and it is improving with time.  Long live Base's connection options.


BTW, Tony.  I am also retired and only 2 years younger than you, with a 
birthday coming up soon.

Girvin Herr



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Girvin Herr]

On 08/01/2016 11:35 AM, Jaroslaw Staniek wrote:

On 1 August 2016 at 00:16, Girvin Herr
 wrote:


Ken,
One thing about Kexi.  I looked at it a few weeks ago and discovered that
Kexi has a capability of reading Access database files to some degree.
However, it reads and converts the access database into its own internal
database.  Kexi has no capability to interface to and use an external
database server (aka "Back End") such as Mariadb or MySQL, as LO Base does.

Hi,
If you mean ability to connect without generating any metadata as in
pure frontends, and being a SQL frontend, then yes. The internal
database is created on first use, however it still can be the server
database possibly running on the same server like the original one,
it's just not the same database.

I recommend https://en.wikipedia.org/wiki/Kexi#Features - 2.x supports
MySQL, PostgreSQL, xBase and MS SQL/Sybase backends (it does so
without limiting itself to capabilities of ODBC/JDBC).

KEXI 3 would be able to do open databases "in place", just not 3.0.
Still, it would not be called a db frontend however transmitting
unchecked/raw SQL strings back and forth; it would be still more a
different type of software: an integrated app creator / environment,
so a slightly more high-level tool.


Jaroslaw,
What I found back on July 4th (and today) is this snippet from the Kexi 
FAQ, Q1.2:


http://kexi-project.org/wiki/wikiview/index@kexifaq.html

"- *Currently you can not "open" (i.e. connect to) databases created 
outside of Kexi. You can only import the tables and data*. "


That tells me that databases other than Kexi can only be imported 
(converted to Kexi format and maintained internal to Kexi, not Kexi 
maintaining the server version).  When Kexi states that they support 
databases like  "MySQL, PostgreSQL, xBase and MS SQL/Sybase", I must 
assume they mean that Kexi can import and convert such databases, not 
connect to their server and maintain the server versions.  There is a 
big difference.


My Kexi research was precipitated by confirming that AOO 4.1.2 had a 
broken Report Builder and it looked like it was not going to be fixed 
anytime soon.  This was a show-stopper for me.  My Slackware 14.1 Linux 
comes with Kexi 2.7.4, so I naturally looked at it.  I was searching for 
another Mariadb client option to see what Kexi could do for me, since I 
was having problems with LO 4.x+.  When I discovered the above FAQ 
statement, it told me I could not use Kexi in my application.  I was not 
going to get "locked in" to another integrated application like MS 
Access.  It could be that at some time in the future Kexi will have the 
connection capability that I require and I may revisit it.


In case you're interested, I ended up using AOO 4.1.2 for documents, 
which doesn't have the problems I am having with LO 4+, and LO 5.0.6 for 
my databases, which has a working Report Builder (Kudos to the devs for 
fixing the lines in reports not WYSIWYG problem).


Girvin





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Girvin Herr]

On 07/31/2016 07:36 PM, Ken Springer wrote:

I understand the concept of Front End/Back End, but never have dealt 
with it.  Nor have I ever used MySQL, Mariadb, or others.  Access and 
a bit of dBase is all I've ever used, and in general, even then that's 
more power than I've ever needed.



Ken,
Actually, IIRC, Access has both a client and server built in.  The user 
isn't normally aware of it.  In my experience with Access 1.1, the 
server is called the "Jet" server.  Today's Access may no longer use the 
Jet server, but I am sure something like it is still in there 
somewhere.  I must admit the Access bundled concept is addictive.  As a 
newbie to databases back in the 90s, I liked it and it was a shock and a 
learning experience to wean myself off of it and go with the industry 
standard forms of client/server architecture and the SQL language.  
Since then I have learned a lot and find the latter concept very 
powerful.  In your case, if Access and dBase had/have more power than 
you ever needed and that power is all that you will ever need, then the 
LO internal HSQLDB engine is probably a good choice for your application.


Now that you mentioned dBase, you may, or may not, be aware that LO has 
a dBase option.  But a limitation to it that I found is that older 
versions of dBase files are not supported.  I have some old dBase 1.x 
files with dbase programs that will not load into LO, let alone run.


Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Compatibility of LO Base with Access databases

[Girvin Herr]

On 07/31/2016 12:49 PM, Ken Springer wrote:

On 7/30/16 3:30 PM, jorge wrote:

Hi:

On GNU / Linux / Ubuntu, and of course in other distributions, there are
to program that you would probe because could help you to export Access
DB to open document:

1) MDBtools (View and export MSAccess db)

2) Kexi of Caligra Suite that say it is able to read MS Access db


Thanks, jorge.  I'll have to check with my "conspirator" on how much 
effort in learning he's willing to do to create a Linux database.


Ken 


Ken,
One thing about Kexi.  I looked at it a few weeks ago and discovered 
that Kexi has a capability of reading Access database files to some 
degree.  However, it reads and converts the access database into its own 
internal database.  Kexi has no capability to interface to and use an 
external database server (aka "Back End") such as Mariadb or MySQL, as 
LO Base does.


I am using LO Base as a database client (aka "Front End") on Linux and 
connected to my Mariadb database server using a Java "connector" 
driver.  I do this because the LO internal HSQDB has limitations that 
MySQL and Mariadb do not have.  You may consider this if your 
database(s) are large or complex.


Years ago, I had my data in an access (1.1) database and needed to port 
my data to MySQL.  I managed it by using the option in access to output 
the database as a comma-separated file, much like a spreadsheet ".csv" 
file.  I then was able to set up MySQL to import this file into its 
database format.  Of course, as some others have noted, the forms and 
reports needed to be recreated.  At this time, OpenOffice (before LO was 
available) did not have a database client which would work with MySQL, 
so I chose an open source client called Rekall and had to recreate my 
data entry forms and reports.  It was labor intensive, but needed to be 
done.  Then Rekall went bust and I had to find another client.  By then, 
OpenOffice had Base, which would talk to my MySQL database engine.  I 
did not need to do anything with my MySQL database, but I did have to 
recreate all of my data entry forms and reports yet again - more labor.  
So, the bottom line is that any time you change database clients, expect 
to recreate the data entry forms and reports.  There is no standard for 
them.  One big advantage to using an external database such as MySQL or 
Mariadb, is that they use standard SQL, while the LO Base HSQDB database 
server uses a non-standard version of SQL.  So, using HSQDB could lock 
you in to it.


My databases are critical to me.  All of my database software decisions 
were based on being able to easily port my data to another client or 
server and not need to recreate it.  Depending on the size of your 
database, that could take much more time than recreating just the forms 
and reports.


Hope this helps with your decision.  Good luck.
Girvin Herr


--
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] Restoration problem between sessions

[Girvin Herr]

Paul,
Thanks for the suggestion.  My reply delay is due to this week being 
filled with appointments and I have not had the time to investigate 
this.  It has made me think of a few other possibilities to try, 
though.  If and when I get any more information, I will post it.

Thanks.
Girvin


On 07/25/2016 11:56 AM, Paul D. Mirowsky wrote:
Perhaps you have a ~/.bash_profile that you can modify by adding 
"Exec=libreoffice5.0 %U" to it.


I have little experience with Xfce, but I understand this is where 'at 
login' commands are to appear.



On 7/25/2016 2:36 PM, Girvin Herr wrote:

Paul,
Thanks for the suggestion.  Someone else suggested that and I 
discovered in my Xfce desktop, that option is already checked. Just 
for grins, I tried unchecking it and there was no difference.


I think the problem has to do with that "session=" argument that LO5 
does not like.  Xfce is passing it, but LO5 is not accepting it.  The 
".desktop" file uses the %U argument.


   ...
   Exec=libreoffice5.0 %U
   ...

I suspect the two methods of starting LO5 are different and that is 
why it works when I use the desktop icon, which uses the ".desktop" 
file, but not when Xfce is restoring the last session.


Thanks.
Girvin



On 07/25/2016 06:54 AM, Paul D. Mirowsky wrote:

Hello Girvin

In Xfce, when you click on the logout button on the taskbar there is 
a checkbox "Save session for future logins"...


Would this be a way to solve your problem?



On 7/21/2016 3:37 PM, Girvin Herr wrote:

Greetings,

I am running Slackware Linux 14.1 (K3.10.17), Xfce 4, and 
Libreoffice 5.0.6.3 (binary .rpm download from LO website).


I prefer to keep several oft-used LO files open all the time. These 
files are open when I shut down the session. When I start the next 
session, LO will not autoload these files and in fact will not run 
at all.  When I then start LO5 manually from the desktop icon, 
these files are opened. I created a log of the Xfce output from the 
startup, which included the startup of LO5 and got the following 
snippet:


...

LibreOffice 5.0.6.3 490fc03b25318460cfc54456516ea2519c11d1aa

Unknown option: --session=2c07016df-92b0-47a4-8398-8d806cdb3d0c 









--
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] Where is everyone?

[Girvin Herr]

Hello Kracked,

I remember you from 2 years ago.  I am sorry to hear you are having 
health problems.  I hope you get better soon.


The list has picked up since I wrote this. That makes me feel better.  
You are correct that maybe no one here has a solution to this technical 
problem.  I try this forum first, before I go elsewhere or give up.  I 
will let my posting run a while longer and see if I get any solutions.  
If not, I may look into submitting a bug report.  The devs may be able 
to resolve it in a future release.


Thanks and take care.
Girvin



On 07/25/2016 09:43 AM, Tim---Kracked_P_P---webmaster wrote:

Hello Girvin

I am one of those who no longer read these posts daily.  This is due 
to health and equipment issues.


As you have been told of before, somethings there are not a lot of 
posts in this forum every day.  Sometimes there are not many people on 
this list that have a solution you need.  I had one issue that took 
several weeks to get an answer, since it was a very specific to my OS 
and printer.  Sometimes it just happens this way.



On 07/22/2016 04:25 PM, Girvin Herr wrote:

Greetings,

I have just re-joined this forum since dropping it 2 years ago due to 
email provider censoring issues.  Back then it was vibrant and I was 
able to get good answers to my LO problems quickly and I was able to 
help others with problems.  Now, since I resubscribed, I saw less 
than 10 postings downloaded on my first day, but nothing since.  I 
posted a message yesterday, and it was echoed to me but that is it.  
Is this not the proper place to post LO user questions?  If not, what 
is?


Thanks.
Girvin Herr









--
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] Restoration problem between sessions

[Girvin Herr]

Paul,
Thanks for the suggestion.  Someone else suggested that and I discovered 
in my Xfce desktop, that option is already checked. Just for grins, I 
tried unchecking it and there was no difference.


I think the problem has to do with that "session=" argument that LO5 
does not like.  Xfce is passing it, but LO5 is not accepting it.  The 
".desktop" file uses the %U argument.


   ...
   Exec=libreoffice5.0 %U
   ...

I suspect the two methods of starting LO5 are different and that is why 
it works when I use the desktop icon, which uses the ".desktop" file, 
but not when Xfce is restoring the last session.


Thanks.
Girvin



On 07/25/2016 06:54 AM, Paul D. Mirowsky wrote:

Hello Girvin

In Xfce, when you click on the logout button on the taskbar there is a 
checkbox "Save session for future logins"...


Would this be a way to solve your problem?



On 7/21/2016 3:37 PM, Girvin Herr wrote:

Greetings,

I am running Slackware Linux 14.1 (K3.10.17), Xfce 4, and Libreoffice 
5.0.6.3 (binary .rpm download from LO website).


I prefer to keep several oft-used LO files open all the time. These 
files are open when I shut down the session.  When I start the next 
session, LO will not autoload these files and in fact will not run at 
all.  When I then start LO5 manually from the desktop icon, these 
files are opened.  I created a log of the Xfce output from the 
startup, which included the startup of LO5 and got the following 
snippet:


...

LibreOffice 5.0.6.3 490fc03b25318460cfc54456516ea2519c11d1aa

Unknown option: --session=2c07016df-92b0-47a4-8398-8d806cdb3d0c 



--
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] Where is everyone?

[Girvin Herr]

On 07/24/2016 10:19 AM, fudmer rieley wrote:

Open source needs to get to cracking on the cad / cam software

bricad is excellent but it does not handle architecture very well.

it may not take much to develop an architecture front end to bricad
someone interested to work on this..

fudmer,
This is a bit off-topic, but if you are looking for a 2D drawing editor, 
I might suggest Librecad:

http://librecad.org/cms/home.html
I have been using it for a while and, after the learning curve, have 
done some mechanical drawings.  It is similar to autocad and by default 
uses the common dxf file format.  It also has an architectural symbol 
library available, but I still had to create some of my own symbols for 
my architectural drawings.  Doing so is not very difficult.

HTH.
Girvin Herr


--
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] Where is everyone?

[Girvin Herr]

On 07/22/2016 09:12 PM, Felmon Davis wrote:

On Fri, 22 Jul 2016, Girvin Herr wrote:


Bruce,
Thanks for the response.
Yes, I have ask.libreoffice.org bookmarked also.  It is another 
resource.  This forum has benefited me in the past, and I prefer to 
stay with it.  As I said, I have been away for about 2 years and I 
was not sure what had happened to the forum in that time. I have 
spent the last year off-and-on trying to sign up again through my 
at&t/yahoo email provider, but my subscription requests have been 
going into a black hole.  I never even got the subscription 
confirmation replies.  I suspected the problem was with at&t/yahoo 
again, similar to 2 years ago, so I had a friend, who was not with 
at&t/yahoo, test the subscription process and it worked for him.  
That was when I had proof that the problem was with at&t/yahoo.  I 
suspect they are blacklisting this forum for whatever reason, but 
they never told me they were doing it.  I am in the process of 
shutting down my at&t/yahoo email service and, as you can see in the 
header, I am in the process of switching to FastMail.  They seem to 
be working fine.


Thanks again and take care.
Girvin


possible cause:

"In an attempt to block email spoofing attacks on yahoo.com addresses, 
Yahoo began imposing a stricter email validation policy that 
unfortunately breaks the usual workflow on legitimate mailing lists."


Lucian Constantin
IDG News Service Apr 8, 2014 6:10 AM

<http://www.pcworld.com/article/2141120/yahoo-email-antispoofing-policy-breaks-mailing-lists.html> 



f.


Felmon,

Yes, but the effect of this at&t/yahoo policy is to censure their 
customers.  at&t had never informed me of this policy. I had to figure 
it out from the unusual silence I was experiencing.  These at&t/yahoo 
policies are not in my interests, so I am dumping at&t/yahoo as soon as 
I can.


Thanks for the link.  It was enlightening.

Thanks.
Girvin


--
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] Where is everyone?

[Girvin Herr]

Bruce,
Thanks for the response.
Yes, I have ask.libreoffice.org bookmarked also.  It is another 
resource.  This forum has benefited me in the past, and I prefer to stay 
with it.  As I said, I have been away for about 2 years and I was not 
sure what had happened to the forum in that time.  I have spent the last 
year off-and-on trying to sign up again through my at&t/yahoo email 
provider, but my subscription requests have been going into a black 
hole.  I never even got the subscription confirmation replies.  I 
suspected the problem was with at&t/yahoo again, similar to 2 years ago, 
so I had a friend, who was not with at&t/yahoo, test the subscription 
process and it worked for him.  That was when I had proof that the 
problem was with at&t/yahoo.  I suspect they are blacklisting this forum 
for whatever reason, but they never told me they were doing it.  I am in 
the process of shutting down my at&t/yahoo email service and, as you can 
see in the header, I am in the process of switching to FastMail.  They 
seem to be working fine.


Thanks again and take care.
Girvin


On 07/22/2016 05:36 PM, Bruce Hohl wrote:

Girvin,
There also exists the busier forum ask.libreoffice.org 
 but like you I prefer mailing lists ... 
and this is a good mailing list where questions often receive solid 
responses.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Fwd: Re: [libreoffice-users] Restoration problem between sessions

[Girvin Herr]

Paul,
Thanks for the response.
I checked and this option is already checked by default.  So, it doesn't 
look like that is the problem.  Or are you suggesting I uncheck it and 
see if LO5 comes up automatically at the next session where now it 
doesn't come up at all?
I will try it, but I am not sure how that would affect the rest of my 
desktop.  So, it may not be a long-term solution for me.

Thanks for the suggestion.
Girvin

Hello Girvin

In Xfce, when you click on the logout button on the taskbar there is a 
checkbox "Save session for future logins"...


Would this be a way to solve your problem?



On 7/21/2016 3:37 PM, Girvin Herr wrote:

Greetings,

I am running Slackware Linux 14.1 (K3.10.17), Xfce 4, and Libreoffice 
5.0.6.3 (binary .rpm download from LO website).


I prefer to keep several oft-used LO files open all the time. These 
files are open when I shut down the session.  When I start the next 
session, LO will not autoload these files and in fact will not run at 
all.  When I then start LO5 manually from the desktop icon, these 
files are opened.  I created a log of the Xfce output from the 
startup, which included the startup of LO5 and got the following snippet:


...

LibreOffice 5.0.6.3 490fc03b25318460cfc54456516ea2519c11d1aa

Unknown option: --session=2c07016df-92b0-47a4-8398-8d806cdb3d0c

Usage: soffice [options] [documents...]

Options:
--minimizedkeep startup bitmap minimized.
--invisibleno startup screen, no default document and no UI.
--norestoresuppress restart/restore after fatal errors.
--quickstart   starts the quickstart service
--nologo   don't show startup screen.
--nolockcheck  don't check for remote instances using the installation
--nodefaultdon't start with an empty document
--headless like invisible but no user interaction at all.
--help/-h/-?   show this message and exit.
--version  display the version information.
--writer   create new text document.
--calc create new spreadsheet document.
--draw create new drawing.
--impress  create new presentation.
--base create new database.
--math create new formula.
--global   create new global document.
--web  create new HTML document.
-o open documents regardless whether they are templates or 
not.

-n always open documents as new files (use as template).

--display 
  Specify X-Display to use in Unix/X11 versions.
-p 
  print the specified documents on the default printer.
--pt  
  print the specified documents on the specified printer.
--view 
  open the specified documents in viewer-(readonly-)mode.
--show 
  open the specified presentation and start it immediately
--accept=
  Specify an UNO connect-string to create an UNO acceptor through 
which

  other programs can connect to access the API
--unaccept=
  Close an acceptor that was created with --accept=
  Use --unnaccept=all to close all open acceptors
--infilter=[:filter_options]
  Force an input filter type if possible
  Eg. --infilter="Calc Office Open XML"
  --infilter="Text (encoded):UTF8,LF,,,"
--convert-to 
output_file_extension[:output_filter_name[:output_filter_options]] 
[--outdir output_dir] files

  Batch convert files (implies --headless).
  If --outdir is not specified then current working dir is used as 
output_dir.

  Eg. --convert-to pdf *.doc
  --convert-to pdf:writer_pdf_Export --outdir /home/user *.doc
  --convert-to "html:XHTML Writer File:UTF8" *.doc
  --convert-to "txt:Text (encoded):UTF8" *.doc
--print-to-file [-printer-name printer_name] [--outdir output_dir] files
  Batch print files to file.
  If --outdir is not specified then current working dir is used as 
output_dir.

  Eg. --print-to-file *.doc
  --print-to-file --printer-name nasty_lowres_printer --outdir 
/home/user *.doc

--cat files
  Dump text content of the files to console
  Eg. --cat *.odt
--pidfile file
  Store soffice.bin pid to file.
-env:[=]
  Set a bootstrap variable.
  Eg. -env:UserInstallation=file:///tmp/test to set a non-default 
user profile path.


Remaining arguments will be treated as filenames or URLs of documents 
to open.

...

As can be seen in the list of valid options, --session is not one of 
them.  I suspect that --session is what the Xfce desktop uses to pass 
last session state information for startup.


LO 3.x would do this without any problems, but ever since LO 4.x, I 
have had this problem.


Is there a solution for this?

Thanks.
Girvin Herr






--
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] Where is everyone?

[Girvin Herr]

Stuart,
Thanks for the reply.
Whew!  I was beginning to think I was the only one on the list. Since I 
wrote this, I have seen some activity here, including your response.  I 
have signed up for the Nabble site, but I prefer mail lists.  With the 
list, I get replies to my postings in my email inbox.  As far as I am 
aware, Nabble does not have this notification feature and I have to keep 
polling the site for replies to my postings.


Thanks again.
Girvin


On 07/22/2016 01:36 PM, V Stuart Foote wrote:

Grivin,

Still the right place, just not much activity.

Of course you can always follow along, or query old activity for this and other 
project ML via our Nabble archive.

http://nabble.documentfoundation.org/Users-f1639498.html

Stuart


From: Girvin Herr 
Sent: Friday, July 22, 2016 3:25 PM
To: LibreOffice Users
Subject: [libreoffice-users] Where is everyone?

Greetings,

I have just re-joined this forum since dropping it 2 years ago due to
email provider censoring issues.  Back then it was vibrant and I was
able to get good answers to my LO problems quickly and I was able to
help others with problems.  Now, since I resubscribed, I saw less than
10 postings downloaded on my first day, but nothing since.  I posted a
message yesterday, and it was echoed to me but that is it.  Is this not
the proper place to post LO user questions?  If not, what is?

Thanks.
Girvin Herr



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