Re: [libreoffice-users] What's with LO 7.3?

[Dan Lewis]

On 4/24/22 2:24 PM, MR wrote:

I know, pretty general subject...

I run Xubuntu 21.10 currently on my desktop and I've tried out LO 7.3
because I generally like to run the latest and greatest bleeding edge
available. I'm planning to upgrade to 22.04, but I see that 7.3.2 is the
default with Xubuntu 22.04, and that concerns me.


 All of the Linux distributions have an earlier version that what 
is available on the LibreOffice website. This is because they make some 
changes in the program before adding it to the latest version. Also 
consider that there is a cutoff date for each program included in a 
given version. Generally speaking that date is before the latest version 
of the LibreOffice website comes out.


 When I was working in the documentation project, I would regularly 
download the pre-release versions at this website. Right now I am using 
7.3.3.1 (April 13,2022) for Ubuntu which is Debian based. I think 
Xubuntu is also. I periodically check it for the latest updates. Since 
the version, that does not seem to have any more bad bugs in it, is used 
as the final release, I will be using the final release perhaps a month 
before the website  releases it to everyone.


https://dev-builds.libreoffice.org/pre-releases/deb/x86_64/

Dan



In Writer, the last worked position no longer matches correctly when I
reopen a doc I was working on before and closed. It seems to come up at a
random position somewhere near but not exactly where I was. This not
happened since 7.2 was fixed for this, somewhere around 7.2.2 IIRC. Even
when I was at the end of the doc, it reopens somewhere above that. This one
is easy to recover, not so much of it's supposed to be at a different
position where I actually was last editing.

Calc does not have this problem, but the newish 'recall last similar entry'
feature only partially matches the actual most recent, and it's not clear
how to accept that part and continue in the same cell. Tab and right arrow
both advance to the next cell, even if there's more to match in the current
cell. How do I accept the partial match and continue in the same cell
without retyping the whole match? That makes the partial match useless.

Any help, comments, suggestions welcome.

Thanks.

Mark



--
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] changing currency in a spreadsheet

[Dan Lewis]

On 4/24/22 5:26 PM, Dave Howorth wrote:

I have a financial spreadsheet that was designed in the USA but I live
in the UK. Is there any way in LO to change all the cells that are
formatted as numeric $ amounts to be the same format but using the
equivalent numeric £ format instead?

I don't think there's any logic in the spreadsheet that depends on the
currency, it's just doing numerical calculations on the values. But it
would be easier to look at if it was in £ rather than $ everywhere!

Cheers, Dave


 Try this: select the columns that contained the currency amounts. 
Then right click on one of them making sure that all of them are 
selected. Select "Format cells". When the dialog appear, look for the 
language setting. Change it from English(USA) to English(UK). Make sure 
the the Category is what you want it as well as the Format. Click OK, 
and save the spreadsheet.


Dan


--
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] Proper forum for feedback.

[Dan Lewis]

This is the email list that you should use for this. So, please tell us 
what your problem is.


Dan


On 4/6/22 9:38 AM, Michael Tiernan wrote:

I was recently working on a form for a database and I ran into some quirks
that had me cursing and I wondered if anyone wants the feedback (more
nicely worded of course) on the things that irked me during the build
process?

If so, where/how should this be channeled?

Thanks for everyone's time.



--
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] Off Line Help Installation

[Dan Lewis]

On 3/22/22 2:09 AM, Michael D. Setzer II wrote:

On 22 Mar 2022 at 7:56, Robert Großkopf wrote:

Date sent:  Tue, 22 Mar 2022 07:56:46 +0100
Subject:Re: [libreoffice-users] Off Line Help
Installation
To: users@global.libreoffice.org
From:   Robert Großkopf



Hi Joe,

file:///opt/libreoffice7.3/help/en-GB/text/shared/05/new_help.html?System=UNIX&DbPAR=WRITER&HID=.uno:HelpIndex#bm_id3806162



My guess is that you installed LibreOffice from an Ubuntu
repository, rather than the original libreoffice download site.
/tmp is a particularly stupid location - the clue is in the name.
It's temporary.

I downloaded the help file from LibreOffice.org. Joe


Hope not only the help file but both: The whole LO from LibreOffice.org
and not a part form Ubuntu and another part of LibreOffice.org.

So please have a look at file:///opt/libreoffice7.3/help ist there exist
any help. Then only the link is wrong. And the link will be set from the
main program.


Just wondering. I'm using Fedora and it has the has
7.1.8.1 as the default Libreoffice.
I've also installed 7.2.6.2 and 7.3.1.3 on the system, and
can run whichever one I want from Application Office
Menu.

This is one issue I have.  For each version I download the
version of the RPMs, and also download the local help
RPM as well. Extract the files, and then copy the help
RPM files to same location as the other rpms, and then
install. This puts the help files in the correct location.

Have a little script I use to automate process and create a
file I can copy to other systems to install.

newlib=$(ls -1 LibreOffice_$1*.gz |tail -n 1 | cut -f1,2 -d_)
mkdir $newlib
cd $newlib/
for a in ../$newlib*.gz ; do tar xvf $a ; done
for a in $(find . | grep "\.rpm") ; do mv $a .; done
rpm -Uvh *.rpm
tar -Jcvf ../$newlib.xz *.rpm
rm l*.rpm -f
rm LibreOffice_$1* -R -f
cd ..
rmdir $newlib

  Just to jump in late in this discussion, here is the script that I use to 
install help:

cd ~/Downloads/LO/LibreOffice_7.3.1.3_Linux_x86-64_deb_helppack_en-US/DEBS/
sudo dpkg -i *.deb

Note that at this stage, I have unzipped the 7.3.1.3 zipped file in the folder  
~/Downloads/LO/. You would have to change the address to the folder containing 
the helppack zipped file. Then use the terminal to run this two line command.


 I have a feeling that when you used dpkg to install the program 
that you may not have used it to then install help. I have a scrip that 
does both. Again, the location of the LibreOffice files has to be 
changed. The script then needs to be made executiable.


cd ~/Downloads/LO/LibreOffice_7.3.1.3_Linux_x86-64_deb/DEBS/
sudo dpkg -i *.deb
cd ~/Downloads/LO/LibreOffice_7.3.1.3_Linux_x86-64_deb_helppack_en-US/DEBS/
sudo dpkg -i *.deb


Dan

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Parallel Install 7.2 +7.3

[Dan Lewis]

It is the last line of bootstrap.ini that needs to be modified. This is 
something that I have been doing for a very long time. This is the line:


   UserInstallation=$SYSUSERCONFIG/libreoffice/4.

Since I am using Ubuntu, this is in the bootstraprc file. What I have 
been doing is to change the 4 to the version including major changes. 
For example, this is the line I use for 7.3.1.3:


   UserInstallation=$SYSUSERCONFIG/libreoffice/7.3.

For the 7.2.6.1, I use 7.2 instead of 7.3. This allows me to set the 
properties for these installations completely different. For example, 
one was used to open an embedded database while the other was used to 
connect to an HSQLDB version 2.+ when I needed to do so. Even so, I 
would not guarantee the results on windows since I have stopped using it.


Dan

On 3/10/22 7:11 AM, Dave Barton wrote:

MS have set their attack (so called security) software to cripple the
excellent Separate Install GUI program (Se Bug 147831). Now I have to
manually set up parallel installs of different versions. Unfortunately,
installing 7.3.1.3 and 7.2.6.2 in parallel causes them to create
unwanted common profiles. I suspect that the bootstrap.ini needs to be
modified to prevent this, but I am not sure what needs to be
added/changed in the ini file. Here are my bootstrap.ini files:

LibreOffice Fresh 7.3.1.3
"C:\Program Files\LibreOffice\program\soffice.exe"
[Bootstrap]
InstallMode=
ProductKey=LibreOffice 7.3
UserInstallation=$SYSUSERCONFIG/LibreOffice/4

LibreOffice Still 7.2.6.2
"E:\LibreOffice 7.2.6.2\program\soffice.exe"
[Bootstrap]
InstallMode=
ProductKey=LibreOffice 7.2
UserInstallation=$SYSUSERCONFIG/LibreOffice/4

LibreOfficeDev 7.4.0.0.alpha0
"E:\LibreOffice 7.4.0-A0\program\soffice.exe"
[Bootstrap]
InstallMode=
ProductKey=LibreOfficeDev 7.4
UserInstallation=$SYSUSERCONFIG/LibreOfficeDev/4

Obviously a VM is a kludge workaround that I prefer to avoid.

Any pointers would be welcome.

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

[libreoffice-users] Import script problems

[Dan Lewis]

 I use LibreOffice to connect to HSQLDB 2.6.1 on UBUNTU 20.04. The 
problem is with this SQL statement:


PERFORM IMPORT SCRIPT DATA FROM  { CONTINUE | 
STOP | CHECK } ON ERROR


 The following is one of the properties of my database:

jdbc:hsqldb:file:/media/dan/Storage/.database/2020personal/2020personal;

 The file that I want to import is Main-subform.cvs.

 I have place this file in the folder containing the 4 database 
files (data,log, properties, script). Then in Tools > SQL, I entered 
this statement:


PERFORM IMPORT SCRIPT DATA FROM 'Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;     and then


PERFORM IMPORT SCRIPT DATA FROM './Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;     and then


PERFORM IMPORT SCRIPT DATA FROM '../Main-subform.cvs' STOP ON ERROR; 
CHECKPOINT;


 None of them worked. So, where should the cvs file be placed or 
what should the path be for this file?


Dan


--
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] Use of Ctrl while selecting text fields in LO Base forms

[Dan Lewis]

Have you tried Crtl+Shift to select separate elements?

Dan

On 2/23/22 6:52 AM, Harvey Nimmo wrote:

While trying to edit form elements for LO Base I am expecting to be
able to select individual form elements, e.g. to align them, and size
them together. However, using the Ctrl button to select more than one
form element (e.g. text boxes) causes a second box, say, to be selected
and a previous box is deselected.

I thought that maybe my Ctrl key was broken, so I tried it on my file
manager. But there the Ctrl button can be used to select several files
at once, as expected. It suggests, therefore, a problem with
LibreOffice.

'Edit > Select All' causes nothing to be selected in the LO Base Form
Editor, whereas in the LO Writer it works as expected.

Does anyone know if there is a switch in the Forms editor in Base that
would activate the Select function? I have spent hours looking for a
possible remedy! Very frustrating!!

Version: 7.2.3.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 2; OS: Linux 5.3; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded

   







--
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] How to print a section of a SS

[Dan Lewis]

On 10/15/21 8:25 PM, John R. Sowden wrote:

I went to Format->Print Range--> define.  Failed
Went to Help (when all else fails) read, follow instructions, blank 
screen (no examples)


Help?,

John


What do you mean by SS? Which component of LibreOffice are you using? 
What version of LibreOffice are you using?


Dan


--
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] DATEADD function in HSQLDB

[Dan Lewis]

   I have am using Base to connect to HSQLDB 2.60 so I can use 
functions like this one. I have this query which calculates my account 
balances for the last day of the present month.


    SELECT "Data"."Account" "Account", SUM( "Data"."Amount" ) 
"Account Balance", SUM( "Data"."Budget" ) "Budget" FROM "Data", 
"Transactions" WHERE "Data"."Transactions_ID" = 
"Transactions"."Transactions_ID" AND "Transactions"."Date" <= LAST_DAY( 
CURRENT_DATE ) GROUP BY "Data"."Account" HAVING SUM( "Data"."Amount" ) 
<> 0 ORDER BY "Account" ASC


   What I want to do is to calculate these values for the last day of 
the previous month. I thought using DATEADD to calculate them. Even 
though I select the sql button (run sql directly), Base does not 
recognize the function. Specifically, I have tried to put the DATEADD 
functions within LAST_DAY.


    LAST_DAY(DATEADD('mm', 1, CURRENT_DATE)) ought to product the 
last day of the next month; a -1 should produce the last day of the 
previous month.


 Help will be much appreciated.

Dan


--
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: Where are my files?

[Dan Lewis]

   You sent this request to the wrong mailing list. It should have been 
to users@global.libreoffice.org. where general questions like yours are 
sent. You sent it to the mailing list for developers, the people who 
work on the code for LibreOffice. I have done so for you. How have you 
searched for these files, and do you know the names of them? Also, were 
you doing something in LibreOffice when it restarted? Have you used your 
operating system to search for the files, or did you just use 
LibreOffice? If you use windows, the files should be in your Document 
folder which is the default setting.


   For others on the mailing list: any replies you make to this 
question should include a CC to zhangyviv...@gmail.com as he is not 
likely yet subscribed to it.


  Dan

On 6/29/21 5:27 PM, Vivian Zhang wrote:

Hello.

LibreOffice restarted and now I can't find the files I have been 
working on for months now.


Very upsetting.

Not pleased.

Will be happy if you help me find my irreplaceable files.

Thank you.

___
LibreOffice mailing list
libreoff...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice


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

Re: [libreoffice-users] Disable Mail Merge Toolbar

[Dan Lewis]

   Yes, it is one of life's mysteries. It is one that I will not likely 
have very often. When I install a new version of LibreOffice, I modify 
the bootstrap file changing the version from 4 to what the actual 
version. Example: in my config folder: this contains 7.0 and 7.1. These 
may or may not be identical depending upon whether I change something 
in  the 7.0.x or 7.1.x version. What I do not know is exactly what the 
Window's installer does with the config files of the previous version. 
Are they just deleted? For that matter, when you are running in 
parallel, are there two config folders in Windows, one for the version 
running in parallel and one for the one that is not?


Dan

On 5/8/21 11:30 AM, Dave Barton wrote:

Hi Dan,

I appreciate you taking the time to look into this, but after several
hours of investigation I finally tracked down the culprit. Originally I
couldn't figure out why I didn't have this issue on my main Linux box.
So I started comparing my configurations for LO under Win 10 & PCLinuxOS
KDE, which as far as possible I try to keep in sync with each other. The
only noticeable difference was the default template being used.

It turns out that there was some kind of corruption in the default
template on the Win 10 machine and once I created a new default template
the Mail Merge toolbar issue disappeared. However, I am still left
wondering why the corrupted template impacted on version 7.1.3.2 and
version 7.1.2.2 was totally unaffected by it. Yet another of life's
little mysteries ;)

Best Regards
Dave

On 08/05/2021 15:49, Dan Lewis wrote:

I use LibreOffice 7.1.3.2 (x64) on Ubuntu (Debian version. I do not have
the same problem at all when opening a new Writer document. I do see
View > Toolbars > Mail Merge when opening a new text document, but it is
not checked as it appears yours is. Perhaps, it is the Window's version?
Give me a little time, and I will install this version on my Windows 10
part of my computer.

Dan


On 5/7/21 11:14 AM, Dave Barton wrote:

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Windows 10.0 Build 19042
UI render: Skia/Raster; VCL: win
Locale: en-IE (en_GB); UI: en-US
Calc: threaded

Whenever I start a new writer document the Mail Merge toolbar is always
visible. I have tried every trick I can think of to prevent this
happening. Destroying my user profile seems to be the only option

Is anyone else here experiencing this issue, or found a solution to
persistently visible toolbars?

Thanks & Regards
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] Disable Mail Merge Toolbar

[Dan Lewis]

I use LibreOffice 7.1.3.2 (x64) on Ubuntu (Debian version. I do not have 
the same problem at all when opening a new Writer document. I do see 
View > Toolbars > Mail Merge when opening a new text document, but it is 
not checked as it appears yours is. Perhaps, it is the Window's version? 
Give me a little time, and I will install this version on my Windows 10 
part of my computer.


Dan


On 5/7/21 11:14 AM, Dave Barton wrote:

Version: 7.1.3.2 (x64) / LibreOffice Community
Build ID: 47f78053abe362b9384784d31a6e56f8511eb1c1
CPU threads: 8; OS: Windows 10.0 Build 19042
UI render: Skia/Raster; VCL: win
Locale: en-IE (en_GB); UI: en-US
Calc: threaded

Whenever I start a new writer document the Mail Merge toolbar is always
visible. I have tried every trick I can think of to prevent this
happening. Destroying my user profile seems to be the only option

Is anyone else here experiencing this issue, or found a solution to
persistently visible toolbars?

Thanks & Regards
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

[libreoffice-users] Fwd: LibreOffice Fonts

[Dan Lewis]

 Forwarded Message 
Subject:LibreOffice Fonts
Date:   Mon, 19 Apr 2021 07:24:14 -0700
From:   Carl Spitzer {L Juno} 
Reply-To:   ly...@juno.com
Organization:   www.OCLUG.org Laptop
To: libreoff...@lists.freedesktop.org



I have a large collection of free fonts I wish to add only to
LibreOffice not to the entire Leap 15.2 system. How do I do that.

CWSIV



Choose to be safer online.
Opt-in to Cyber Safety with NortonLifeLock.
Plans starting as low as $6.95 per month.*
https://store.netzero.net/account/showService.do?serviceId=nz-nLifeLock&utm_source=mktg&utm_medium=taglines&utm_campaign=nzlifelk_launch&utm_content=tag995&promoCode=A23457
___
LibreOffice mailing list
libreoff...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

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

Re: [libreoffice-users] Two parallel text flows in one document possible?

[Dan Lewis]

the language setting is also in the Font tab for all paragraph styles. 
Did you notice this?


Dan

On 4/16/21 9:33 AM, John Kaufmann wrote:
Thanks, Dan. It's funny: I thought I knew styles, which are 
indispensable to any kind of serious writing, but never noticed that 
Language setting in the Character style Font tab.

Every day is a school day.
-John

On 2021-04-16 08:50, Dan Lewis wrote:
This requires knowing how to use styles. For the column in German, 
all of the styles you use (paragraph, heading, or character styles 
need to be modified to list German as the language. For the column in 
English, all of the styles you use (paragraph, heading, or character 
styles need to be modified to list English as the language.This 
results in two sets of styles, one for German and one for English. 
For detailed instructions on doing this, you need to download the 
latest Writer Guide or download the the chapter on styles and the 
chapters on styles from the Getting Started Guide. Or, you could just 
download the entire Writer Guide so you would have a good reference 
for other questions about Writer.


Dan

On 4/16/21 7:45 AM, John Kaufmann wrote:
Sorry, but I was hoping you would ask HOW the spell-check language 
is set separately on each column.

[I hate it when someone says "Of course" on an issue I don't see.] ;-)
Since you grasped it immediately, I'm afraid I must ask one of you: 
How do you do that?



On 2021-04-15 14:22, Ulf Dunkel wrote:
A two-column TABLE seems to be a very smart solution for this. 
Thank you, Harvey.


- - - - -

Am 15.04.21 um 12:09 schrieb Harvey Nimmo:

Hi,
I sometimes have to translate documents. So that I can see the
relationship of the texts I put one language on the right and the 
other

left on the page. For that I use a two-column table which works quite
well. Not sure if that is the most elegant solution for what you 
want.

Of course you can format each column as you want (e.g. with no table
borders), and the spell-check language can be set separately on each
column.

Greetings
Harvey


On Thu, 2021-04-15 at 11:42 +0200, Ulf Dunkel wrote:

Hello everyone.

I would like to write a book in German and English in parallel and
let
the German text flow on the left and the English text on the right,
or
two columns of German on the left and English on the right. Is that
technically possible in LO Writer? I haven't found anything about it
yet.

Best, Ulf










--
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] Two parallel text flows in one document possible?

[Dan Lewis]

This requires knowing how to use styles. For the column in German, all 
of the styles you use (paragraph, heading, or character styles need to 
be modified to list German as the language. For the column in English, 
all of the styles you use (paragraph, heading, or character styles need 
to be modified to list English as the language.This results in two sets 
of styles, one for German and one for English. For detailed instructions 
on doing this, you need to download the latest Writer Guide or download 
the the chapter on styles and the chapters on styles from the Getting 
Started Guide. Or, you could just download the entire Writer Guide so 
you would have a good reference for other questions about Writer.


Dan

On 4/16/21 7:45 AM, John Kaufmann wrote:
Sorry, but I was hoping you would ask HOW the spell-check language is 
set separately on each column.

[I hate it when someone says "Of course" on an issue I don't see.] ;-)
Since you grasped it immediately, I'm afraid I must ask one of you: 
How do you do that?



On 2021-04-15 14:22, Ulf Dunkel wrote:
A two-column TABLE seems to be a very smart solution for this. Thank 
you, Harvey.


- - - - -

Am 15.04.21 um 12:09 schrieb Harvey Nimmo:

Hi,
I sometimes have to translate documents. So that I can see the
relationship of the texts I put one language on the right and the other
left on the page. For that I use a two-column table which works quite
well. Not sure if that is the most elegant solution for what you want.
Of course you can format each column as you want (e.g. with no table
borders), and the spell-check language can be set separately on each
column.

Greetings
Harvey


On Thu, 2021-04-15 at 11:42 +0200, Ulf Dunkel wrote:

Hello everyone.

I would like to write a book in German and English in parallel and
let
the German text flow on the left and the English text on the right,
or
two columns of German on the left and English on the right. Is that
technically possible in LO Writer? I haven't found anything about it
yet.

Best, Ulf






--
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] How to round corners of rectangle shape in Draw?

[Dan Lewis]

It does not work for 7.0.5.2 (Debian) but it does work for AOO 4.1.7 as 
well.


A bug report is a very good idea.

Dan

On 4/10/21 10:56 AM, Dave Barton wrote:

On 10/04/2021 15:03, Dave Barton wrote:

Version: 7.1.2.2 (x64) / LibreOffice Community
Build ID: 8a45595d069ef5570103caea1b71cc9d82b2aae4
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster;
Also TDF created Linux edition.

In Draw I select a *RECTANGLE* shape from the Draw Functions toolbar and
draw a *RECTANGLE* shape on the page. With the *RECTANGLE* shape
selected, I open the "Position and Size" Dialog and select the "Slant &
Corner Radius" tab and find the "Corner Radius" option disabled.

So I consult our "Help" facility which tells me: "You can only round the
corners of a *RECTANGULAR* object."

It's been a few years (decades) since I took Geometry 101, but I am sure
a *RECTANGLE* shape is still a *RECTANGULAR* object :b.

Would some kind person enlighten me as to what I am missing?

TIA
Dave

Note:
This function Works perfectly in AOO 4.1.9
So maybe it's time to file yet another LO bug report.

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

[Dan Lewis]

   I also can scan something into Writer without any problem. I use 
7.1.2.1 at the present time using Ubuntu 20.04. This is on a notebook.


   My printer is connected through a network which also includes a 
tower computer. I have notice that when scanning to the tower does not 
have the ability to produce a preview; the laptop has not problem doing 
this. Both use the same O/S version using the same CD to install it on 
both of them. It is likely some setting that differs between the two.


Dan

On 4/5/21 4:42 AM, insomniacno1 wrote:

Version: 7.1.2.2 / LibreOffice Community
Build ID: 5751006d328844ba3fa6124ed263bbf122f0788a
CPU threads: 2; OS: Linux 4.4; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Even after update I still can't scan into Lo writer, is anyone looking into
why this is happening?

With kind regards

Jan



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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] Crash creating DB from Spreadsheet.

[Dan Lewis]

What we need is a list of the steps you used to create the crash. They 
must be specific. Begin with what you did to connect to the DB.


It maybe a problem associated with the Mac O/S. I used one of my 
spreadsheets with no links between cells. I then used Base to connect to 
this spreadsheet. I had no problems creating a query and form in Base.


Dan


On 4/2/21 7:36 AM, Michael Tiernan wrote:
Just checking before I file a bug report, anyone else seen (or know 
of) a fairly repeatable crash of LO when using a spreadsheet as the DB 
when creating a query or form?


In short, I have a simple(istic) spreadsheet with 27 columns, and 
(currently truncated to 16 rows).


When I attempt to create a DB and link it to that Boom.

(Yes, I'm collecting screenshots showing the sequence.)

Thanks for everyone's time.

Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded



--
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] Field Date does not update

[Dan Lewis]

Right click on the date and select Edit Fields from the context window. 
In the middle column, you should see two choices: Date(fixed) or Date. 
Select Date. This should give you what you want.


Dan

On 3/10/21 3:43 AM, Jupiter wrote:

Hi,

I am running libreoffice in Ubuntu 18.04, I inserted the field date to
an odt document, it setup the date at insert date time, but it did not
change the date when I open the file next day and after, how can I
make Field macro date to be updated based on the date of opening the
file?

Thank you very much.

Kind regards,

- j



--
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] multiple templates path and group policies

[Dan Lewis]

Yes, it is. But why would you want to do this? Using Control + Shift + N 
opens the Templates dialog. There you manage your templates including 
moving a template to the template of your choice. You can even create 
new categories or delete them. But you are still sure you want to do 
this, here is the place where you can do so.


Tools > Options > LibreOffice >Paths >Templates

Dan

On 2/1/21 2:43 AM, Susanne Mohn wrote:

Hallo !

  


Is it possible to define multiple templates path in LibreOffice ?

One for personal templates and one for Group templates?

  


We use Windows 10 and LO 7.

So it would be nice to define it with policies.

  


Greeting

Susanne

  


_

Susanne Mohn

  





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

Re: [libreoffice-users] Running LO 7.03 under xubuntu 18.04 32 bit

[Dan Lewis]

This link will take you to where you can download LO 6.4.7 for Windows. 
(As far as I know, there is not a Linux 32 bit version.)


Dan

On 11/13/20 22:00, John R. Sowden wrote:

How is this possible. 1 paptop and one desktop, same setup-both 32 bit.
Does the 64 bit LO 7.03 run on a 32 bit computer?

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

[libreoffice-users] Modifying a decimal field in a Base form

[Dan Lewis]

I have a database which contains the test results for my blood work. 
Also included in the data I receive are the normal ranges for each test. 
For example, potassium has a normal range of 3.5 to 5.2 What I want to 
do is to have three colors when displaying my potassium level. One for 
values <3.5, another for values between 3.5 and 5.2, and finally for 
values >5.2. The field is a formatted field. How do I change the Format 
code for the formatting property to do this?


Dan


--
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] Static vs. dynamic time

[Dan Lewis]

There is an option that I have found accidentally: If you want to enter 
the present time as static, use Insert > Time  or Ctrl+Shift+;


But if you want to enter the present time as dynamic use =NOW().

Dan

On 10/2/20 22:05, Michael D. Setzer II wrote:

Was looking for options on this, but haven't found exactly what I'm
looking for.
Closest I've found is Ctrl + ; that inserts current date
and Ctrl + Shift + ; that inserts the current time.
Both seem to be the fixed value?

But have found no way to do that in a formula??

Recall long ago in either Lotus or Quattro, you could use now() and then
{Calc} and it would convert the current time to the fixed value. But that
was long long ago. Macro recorder doesn't seem to record that kind of
stuff, and entering formulas don't either.



On 3 Oct 2020 at 10:31, Michael Manning wrote:

From:   Michael Manning 
Date sent:  Sat, 3 Oct 2020 10:31:58 +1000
Subject:Re: [libreoffice-users] Static vs. dynamic time
To: LibreOffice 


When I have needed a static date or time in Libreoffice Calc, I have found
that the only way to do this is to enter the date or time directly into the
spreadsheet and not to use a formula.

As an example of this, I have been using Calc to measure the drift of
timepieces compared to a time standard at weekly intervals over a 26 week
period.  I pre-enter the dates at which the measurements are to be made.
At the required date, I simply enter the time as shown on the timepiece and
the time as shown on the time standard at the same instance.  These times
are then converted to seconds and the difference between in seconds is then
calculated and charted to show the time drift.  These times and dates are
static and can be used for later referral.

I am not sure if there is a way to use a formula or macro to enter a static
date.  If there is, it is beyond my capabilities.  Entering dates and times
directly seems very straightforward to me.

Mike
email: michaelgmann...@gmail.com
Libreoffice https://www.libreoffice.org/




On Fri, 2 Oct 2020 at 19:41, Chimel  wrote:


Hi,

I use the formula IF(A1<>"";NOW()) copied to every cell of column B.
It gives me the correct time every time I type anything on a line of column
A.
But this is refreshed constantly by the time of the computer, not the time
I
typed something in column A.
I tried looking for a static version of NOW() or playing with iterations
(probably not correctly) or looking for a way to stop recomputing this
specific column to no avail.
Is there a way to set on column B the time of the typing on each line of
column A and keep it as a static time.

I am usually good with formulas, but this very basic need escapes me.
As far as usability is concerned, a STATICNOW() function seems much more
useful than the current NOW() function. Or inserting a 0,1 argument for
staticness or something.
So far, I am forced to type or insert the time manually each time.
Let me repeat it: Manually each time! Me!  ;)

Thanks,
Chimel.



--
Sent from:
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html

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


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






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

Re: [libreoffice-users] Create a relative hyperlink to file?

[Dan Lewis]

On 9/19/20 17:22, DaveB wrote:

On 19/09/2020 20:01, Robert Großkopf wrote:

Hi Dave,


I am trying to create a Writer document with a number of links to files
in the same directory as the odt file itself. Using absolute paths
everything works perfectly, but relative links (eg. file://abc.xyz)
always fail with a "not an *absolute* URL" error.

The links will be saved als relative links in the file. Try to move the
file to another folder - together with the other documents. It will work.

Have a look in the *.odt-file in content.xml:

Hi Robert,

Many thanks for taking the time to reply.

If you look at my original post and my reply to Regina the odt file and
the hyperlinked files are are already in the same directory, so I see no
reason why moving them to another location would change anything.

It really doesn't matter what appears in content.xml. The critical point
is that keyboard Ctrl+click on the hyperlink in the odt file generates a
"not an *absolute* URL" error.

Sorry if I have misunderstood or misinterpreted the explanation you and
Regina have kindly given, but I need to clearly explain this for
inexperienced users in the next edition of the official LibreOffice
Writer Guide.

Kind Regards
Dave


Personally, I think this is a bug. In Debian 64 bit, what you have found 
gives the same error for versions, 6.2.8, 6.3.6, and 7.0.1.


Dan



--
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: Calc: how do I?

[Dan Lewis]

Thanks to all three of you for answering my questions. It was a 
refresher course to say the least.


Dan

On 9/16/20 10:29, Dan Lewis wrote:
I have a dBase database with several tables. How do I open this 
database in Calc so that each table will have its own sheet?


Dan



--
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] Calc: how do I?

[Dan Lewis]

I have a dBase database with several tables. How do I open this database 
in Calc so that each table will have its own sheet?


Dan


--
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] Narrow equivalent in margins in Writer

[Dan Lewis]

On 8/30/20 15:22, John Jason Jordan wrote:

On Sun, 30 Aug 2020 21:07:38 +0200
Kolbjørn Stuestøl  dijo:


Den 30.08.2020 20:12, skreiv Robert Funnell:

In the page style you can modify the left and right margins in the
same way as you modify the top and bottom margins. Does that not do
what you want?

Or perhaps using the arrows (triangles) on the ruler just below the
tool lines on top of the side is what you are looking for. Select the
text and slide the arrows on the ruler to where you want the left or
right margins.
I am not using MS Word (although I am using Windows) so perhaps I
misunderstood your question.

And once you have a blank page with the margins you want, save it as a
page style. Now it's just one click to apply it. Or you can apply a
keyboard shortcut to apply the page style.


John: Are you talking about saving that blank page with the narrow 
margins set as a template? This way, double clicking this template will 
automatically open a new document with the narrow margins.


Dan


--
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] Configuring LO

[Dan Lewis]

Perhaps _Getting Started with LibreOffice_ is the guide you need. Find, 
download, and study to find out how to make changes in this program.


I thought LO already is by default: its appearance is someone's taste, 
and you are the other person that needs to override what you think 
stinks. LO is configured so that it can be changes can be made. This way 
you can have your choices applied to your installation, and I can have 
mine. I should not have to use your choice anymore than you have to use 
mine.


Now to the important part: how to change the appearance to how an 
individual wanted it to look. In Linux, the configuration files are 
found in /home/user name/.config/libreoffice/4/User. Before installing a 
newer version over an older one, made a copy of the User folder. Then 
after installation, move this folder back to the 4 folder. This will 
retain the configurations you want. While I have Windows 10 on a dual 
boot, I do not use it enough to research where the configuration files 
are on it.


Dan

On 8/28/20 08:20, Malcolm Moore wrote:

One of the things I hate about LO is by default it looks awful ( my opinion )
How can I configure it ( on Linux and Windows ) so that all users get the same 
appearance
without them having to do anything but then can over ride it if they think
my taste sucks ;-)

If there is a guide someone can point me to I would appreciate it

Ta

Mal
All communications, incoming and outgoing, may be recorded and are monitored 
for legitimate business purposes. The security and reliability of email 
transmission cannot be guaranteed. It is the recipient's responsibility to scan 
this e-mail and any attachment for the presence of viruses. Westcliff High 
School for Girls exclude all liability for any loss or damage whatsoever 
arising or resulting from the receipt, use or transmission of this email.



--
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] Thin Line under Heading - Border Line?

[Dan Lewis]

You are working with the wrong style. You need to change the style for 
the title heading. This style should have several Tabs which include 
Font Effects which is where you need. There look for the title 
underlining. The drop down list to its right contains the type of 
underlining, and the next drop down list contains the possible colors 
that can be used.


Dan

On 8/15/20 3:43 PM, charles meyer wrote:

I'm trying to recreate that thin grey line which appears below a title
heading on Wikipedia pages.

ex. https://en.wikipedia.org/wiki/Book

Is that considered a Border Line in Libre Writer?

If so, I tried to create one following these steps
https://help.libreoffice.org/Common/Defining_Borders_for_Tables_and_Table_Cells

But, after I highlight my heading and the click Table, the Properties under
that is all grayed out.

Thank you.



--
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 Base (previously copying data from Calc to Base)...

[Dan Lewis]

Comments inline:

On 7/31/20 20:14, zed wrote:
Thank you to all the members who replied so promptly to my request for 
help.  It is very much appreciated.


One member sent me advice of another method to achieve what I wanted 
and I am delighted to say it worked and I now have a database with the 
fields I need, with one Table and one Form. I'm delighted with what I 
have achieved but have a couple of queries.


I have a field named "Location" in which I enter the declared location 
of a Youtube channel owner. In Calc, the name of a Location is 
remembered and if I start typing it again it automatically appears.  
It doesn't happen in Base. Is there a way to "auto-complete" in Base?
You can accomplish this using a list box. It is somewhat limited in that 
the  table linked to this box contains all of the locations. (A combo 
box is suppose to do this, but this is not always working correctly.)


One other thing I am having difficulty with,because of my current lack 
I used it for the first time this morning and have come across a small 
problem.of knowledge of databases, is how to sum a column of figures.


I have a field named "No." and another named "First" and I want to 
choose a start date from the field "First" and get the sum of the 
numbers in the field "No"  Is this possible, please?


For this I recommend a query. The two fields for it would be "No" and 
"First". For "No", select the function "sum". For "First", its criterion 
should be:  >mm/dd/yy where this is the start date. Make sure that the 
"First" column does NOT have a check mark for visibility.


There is now a Base User Guide. (6.4) which should be able to answer 
your questions. This mailing list has people to answers questions as 
well. You can download the entire guide or individual chapters; ODT and PDF


https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide

Dan




Regards from New Zealand on a very cold but fine winter's afternoon,

Zed




--
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: Connecting to a MySQL database with native password using LO 6.4.6.1

[Dan Lewis]

On 7/29/20 10:41, Dan Lewis wrote:
I am having problems connecting directly to the MySQL server (8.0.21) 
with this version of LibreOffice. I had no problems before upgrading 
to version 6.4.6.1. There is no problem while using the Mac OS nor 
when using the connector for MariaDB. I am wondering if someone using 
the Windows OS has a problem.


I can make a connection if I use the MySQL J connector (8.0.21)using 
my native password. Under this same set up, I can also connect using 
another user which uses the SHA2 password. Both of these are using 
LibreOffice 6.4.6.1.
I also have version 7.0.0.2 (7.0RC2) installed. The direct connector 
will not allow me to access MySQL, but the MySQL J connect allows access 
with the same password.


System: Ubuntu 18.04 LTS 64 bit, MySQL components are all the latest 
(8.0.21) updated the middle of June. The LIbreOffice version is a 
prereleased version which had been downloaded and installed last 
Thursday.


Dan



--
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] Connecting to a MySQL database with native password using LO 6.4.6.1

[Dan Lewis]

I am having problems connecting directly to the MySQL server with this 
version of LibreOffice. I had no problems before upgrading to version 
6.4.6.1. There is no problem while using the Mac OS nor when using the 
connector for MariaDB. I am wondering if someone using the Windows OS 
has a problem.


I can make a connection if I use the MySQL J' connector using my native 
password. Under this same set up, I can also connect using another user 
which uses the SHA2 password. Both of these are using LibreOffice 6.4.6.1.


System: Ubuntu 18.04 LTS 64 bit, MySQL components are all the latest 
(8.0.21) updated the middle of June. The LIbreOffice version is a 
prereleased version which had been downloaded and installed last Thursday.


Dan


--
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 Table (drop-down list) Help

[Dan Lewis]

I suggest using LibreOffice Help. For this you must be either connected 
to the Internet when opening Help or have installed the Help download 
for your LibreOffice version.


Using F1, open Help. Select Writer as the module. Enter "drop-down list" 
in the selection box. What you should see is one link with the heading 
Global above it. To the right you will see a lot of information on 
creating a form.


If this is not what you want to do, then it is not possible to do what 
you want.


Dan

On 7/28/20 18:35, R5chwabe wrote:

Hello!

I would like to know (if possible) how to insert a drop-down list in a cell,
from my table in the writer. Like the function (Data -> Validation -> List
of Values) in Calc. I would like to insert it directly into Writer, so I
don't need to link or something. If anyone can gently help me, i will be
gratefull. Thanks!



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



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

[Dan Lewis]

Absolutely, but 20.04.1 LTS is a minor upgrade which has some of the 
bugs of 20.04 that have been fixed prior to the cut off date set for 
20.04.1. I have checked the box which will produce  the notice that a 
new version is available. I do not get this notice until the *.04.1 
minor upgrade is available.


An example of this occurred several years ago. The *.04 version (I do 
not remember the year) failed to contain the proper driver for a 
specific monitor. This was added before  the *.04.1 minor upgrade came out.


On 7/28/20 18:54, Joe wrote:
Ubuntu 20.04 LTS has been available since April. The next due out is 
20.10, not due until October 2020.


On 7/28/20 8:43 AM, Dan Lewis wrote:


On 7/28/20 05:31, Luuk wrote:


On 27-7-2020 20:27, fudmier wrote:


On 2020-07-27 11:39 a.m., fudmier wrote:


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



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





hard to tell without knowing some things like:

1) what is the size of this worksheet?

2) how much internal memory do you have on your machine?

3) what version of LibreOffice?


With 'linux 16.04' you probably mean Ubuntu 16.04 ? This means you 
should upgrade before April 2021 (see: 
https://wiki.ubuntu.com/Releases)


Ubuntu 20.04.1 is due out in the next couple of weeks unless the 
covid 19 virus is slowing things down...


Dan




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

[Dan Lewis]

On 7/28/20 05:31, Luuk wrote:


On 27-7-2020 20:27, fudmier wrote:


On 2020-07-27 11:39 a.m., fudmier wrote:


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



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





hard to tell without knowing some things like:

1) what is the size of this worksheet?

2) how much internal memory do you have on your machine?

3) what version of LibreOffice?


With 'linux 16.04' you probably mean Ubuntu 16.04 ? This means you 
should upgrade before April 2021 (see: https://wiki.ubuntu.com/Releases)


Ubuntu 20.04.1 is due out in the next couple of weeks unless the covid 
19 virus is slowing things down...


Dan


--
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] recovery problems

[Dan Lewis]

First of all, you should first open LibreOffice again. This time instead 
of clicking OK to file recovery, Click Cancel. There is something wrong 
with the last saved version of a document. When clicking Cancel, that 
version is deleted by LibreOffice. This may solve by itself. Otherwise 
you may need to close LibreOffice and then go to the configuration files 
found in /home/(your user name)/.config/libreoffice/4/. There you should 
find a folder named User. It contains all of the configurations files. 
Rename this folder this folder and restart LIbreOffice which will create 
a new User folder. At this point, you should use Tools > Options to 
change any of the configurations you had earlier set here since deleting 
the User folder also deleted them.


Dan

On 7/15/20 10:01, pete wrote:

Hi folks

having issues with  libreoffice

It was working fine  type a letter in printed it out saved closed   no problem .

Came to write another letter 2 weeks later it some up with the file recovery
dialoge  click ok it goes away  comes to the next recovery window  filename
tell it to carry on  it returns to the previous window  . i have tried
uninstalling it  "pacman -R libreoffice " then reinstalled still the same

i need this to work i have a lot of thigs to sort out  and it is making life
that was already difficult even harder



  running on Arch Linux
Version: 6.4.5.2
Build ID: 6.4.5-2
CPU threads: 8; OS: Linux 5.7; UI render: default; VCL: kf5;
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded


Thanks  Pete .



--
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] Base/HSQL table with more than two dimensions?

[Dan Lewis]

What I see, you are talking about three tables which contain data: 
readings, days, and years. A fourth table should be created containing 
three foreign keys for these three tables. What you need for this data 
is a relational database which Base can create. Just make sure you 
normalize these tables. You might want to read up on relational 
databases to see how to do this.


Dan

On 6/24/20 02:28, John Kaufmann wrote:
A lectionary is an ordered set of readings, typically using a cycle of 
three or more years, to cover the Bible. In a four-year cycle the 
years are simply designated {A,B,C,D}, and for each day in a year 
readings are prescribed from different parts of the Bible. For any 
year, storing the readings in a database table is straightforward in 
two dimensions [fields (readings) x records (days)], and it is simple 
to SELECT the set of readings (usually from four different fields) for 
any day.


Obviously it is possible to do this in one table per year (say, four 
tables for four years), but since the pattern of records and fields is 
the same for all years, that is clumsy and should be unnecessary. It 
should be possible to do a table of three dimensions, of which the 
third dimension is the year {A,B,C,D} in the cycle, so that one could 
compare the readings for any given day across all years. But I don't 
see how to extend tables into three (as in this case) or more 
dimensions. Can someone point me in the right direction?  [It seems 
like this kind of database design issue should be common to a lot of 
domains.]


Thanks,
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] Tab stops

[Dan Lewis]

Tools > Options > LibreOffice Writer > Formatting Aids > Tabs

You may not have this property checked. Other than that, it may depend 
upon your OS. Tab stops appear in my horizontal ruler in 6.3.6.3, 
6.4.4.2, and 7.0 Beta 1. All three are Debian and from the LibreOffice 
website (pre-release versions).


Dan

On 6/14/20 20:09, Steve Edmonds wrote:

Thanks Dan, I have been doing this since the ruler is not showing the
tab stops, but each adjustment means adding a new tab and deleting the
old one. Much easier if I could just slide the tab in the ruler.
Steve

On 15/06/2020 11:44, Dan Lewis wrote:

If you were to open the paragraph style that you use for your text,
you would find several tabs (pages). One of them is labeled Tabs.
There you can define the tab positions that you desire.

Dan

On 6/14/20 19:17, Steve Edmonds wrote:

Hi, I could not see bugs listed so assume I am missing something.
Tab stops are not showing in the ruler in my document, if I copy/paste
the text to a new document they do show, in another similar document
they show, so I assume some how I have turned their display off. How do
I turn them back on.

I am assuming there is no way to edit a tab position in the paragraph
dialogue, I'm adding a new tab, deleting the old tab, closing the
dialogue (there is no Apply button, just OK), checking the layout then
opening the paragraph dialogue again.

Steve






--
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] Tab stops

[Dan Lewis]

If you were to open the paragraph style that you use for your text, you 
would find several tabs (pages). One of them is labeled Tabs. There you 
can define the tab positions that you desire.


Dan

On 6/14/20 19:17, Steve Edmonds wrote:

Hi, I could not see bugs listed so assume I am missing something.
Tab stops are not showing in the ruler in my document, if I copy/paste
the text to a new document they do show, in another similar document
they show, so I assume some how I have turned their display off. How do
I turn them back on.

I am assuming there is no way to edit a tab position in the paragraph
dialogue, I'm adding a new tab, deleting the old tab, closing the
dialogue (there is no Apply button, just OK), checking the layout then
opening the paragraph dialogue again.

Steve




--
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] Probem with LibreOffice 6.4.4 and Windows 10 2004

[Dan Lewis]

Could it be a lack of memory? I have a MacBook that does something 
similar. In my case, there is 2 GB RAM with a Ubuntu 16.04 32 bit OS. 
One of two things seem to make sense to me: either some of the sticks of 
RAM has become defective, or the OS wants to use more RAM than is available.


Dan

On 6/10/20 05:27, ycollette.nos...@free.fr wrote:

The first updates for 2004 have been applied this morning.
Impress still stop working after 2 minutes (the interface is frozen  ... but 
still working because I see a popup when I try to close impress).

I restarted libreoffice in repair mode and nothing has changed ...

Hope 6.4.5 will fix this mess.

- Mail original -
De: "ycollette nospam" 
À: users@global.libreoffice.org
Envoyé: Dimanche 7 Juin 2020 08:02:48
Objet: [libreoffice-users] Probem with LibreOffice 6.4.4 and Windows 10 2004

Hello,

I've installed LibreOffice 6.4.4 on Windows 10.
Everything was fine until I install the 2004 update.
Now, when I start LibreOffice, everything is fine during 2 minutes and after 
that, the UI starts to become unresponsive.
First, the dropdown entries are empty and then, the UI became totally 
unresponsive.
If I try to kill LibreOffice, a blank "do you wan't to save your document" pops 
up but without text and without Yes / No buttons.

Do you have any workaround for this problem ?

I tried to reinstall 6.4.3 but the problem is the same with this version too.

Best regards,

YC



--
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] Bullets indentation

[Dan Lewis]

    Please be more specific with your complaint. Amount of indentation 
is controlled by a style. Each level of a bullet style can set at a 
specific distance from the left margin. But do you know how to use styles?


Dan

On 6/10/20 04:30, sundaresh wrote:

The indentation of bullet's, which I need the most does not work.
All level's of indentation take place in the same margin.
This is frustrating.
I have the latest version installed.



--
Sent from: 
http://document-foundation-mail-archive.969070.n3.nabble.com/Users-f1639498.html



--
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] [ANNOUNCEMENT]: Base Guide 6.2 is now available for download

[Dan Lewis]

   There are three formats to choose from: ODT, PDF, and EPUB.

https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide

Base Guide 6.4 should be ready within the next few months.

Dan


--
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] Setting font color for a range of values (Base)

[Dan Lewis]

Yes, I am. Actually I do not think this can be done in an formatted 
field in an individual control. I know that negative currency is not red 
even when that property is selected. It does work for a table control 
though. I think I will try this a little later today.


Dan

On 5/6/20 12:56, Robert Großkopf wrote:

Hi Dan,


I have a form with the results of medical test that are run each time I
see the doctor. Each one of them has a "good" range. What I want to do
is to have one color for those which are lower than the range, one in
the range, and one which is above the range.

I have seen this done in the past, but I don't remember what it is.

Could it be you are looking for the formatted field? It uses this
function for currency values, but it is also possible to set it for
other (numeric) values.

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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Setting font color for a range of values (Base)

[Dan Lewis]

I have a form with the results of medical test that are run each time I 
see the doctor. Each one of them has a "good" range. What I want to do 
is to have one color for those which are lower than the range, one in 
the range, and one which is above the range.


I have seen this done in the past, but I don't remember what it is.

Dan


--
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] The bootstraprc/bootstrap.ini configuration variables

[Dan Lewis]

On 4/14/20 01:28, John Kaufmann wrote:
For "Installing several versions of LibreOffice in parallel" 
, the wiki 
discusses editing bootstraprc (Linux) or bootstrap.ini (Windows), 
changing the "UserInstallation" variable using configuration variables 
$SYSUSERCONFIG and $ORIGIN.


The implication of the discussion seems to be that these variables are 
part of a configuration language that is familiar to the reader.  But 
it's not familiar to me, and I'm having trouble to find the 
documentation (probably because my terminology is imprecise). Can 
someone point me in the right direction?


I think that there is an easier way to install several versions of 
LibreOffice in parallel, perhaps not in Windows or Mac. Presently I have 
the installation files in /opt/: 6.2, 6.3, 6.3.4. and 6.4. I can run all 
four at the same time if I so desire.


How did I do this? all but 6.3.4 were installed normally with one 
exception: I changed the last line in bootstraprc using a text editor as 
an administrator.


UserInstallation=$SYSUSERCONFIG/libreoffice/4 became 
UserInstallation=$SYSUSERCONFIG/libreoffice/6.3 for LibreOffice 6.3. 
Obviously the end of this line for each of the other versions was 6.2, 
or 6.4 respectively. When a particular version was first started, the 
configuration folder is created as a subfolder of /home/.config/


For version 6.3.4, this was more involved. First I followed the link 
that you have mentioned to install this version in parallel within the 
folder containing the installation files. 
(LibreOffice_6.3.4.1_Linux_x86-64_deb/DEBS/Install. This created as a 
subfolder libreoffice6.3/ which is its installation folder. Then I also 
followed the same instructions to install the help files for this 
version in parallel. Next I moved the help folder to the libreoffice6.3 
installation folder (/home/username/.config/libreoffice/) which made the 
help files available to this parallel version of 6.3.4 when it is run.


Next to the last step: Modify the bootstraprc last line to

UserInstallation=$SYSUSERCONFIG/libreoffice/4 became 
UserInstallation=$SYSUSERCONFIG/libreoffice/Direct. (I wanted to use 
this particular version to connect to MySQL using the direct connection. 
Other versions are either using either connecting to MySQL using JAVA or 
connecting to HSQLDB 2.5.0.)


Last step: As administrator, I moved the libreoffice6.3 folder that I 
had created to the /opt/ folder.


There may well be something listed here that could be used for Windows 
or Mac, I do not know.


Dan


--
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] Font colors on Windows vs. Linux

[Dan Lewis]

I use the Ubuntu O/S; LibreOffice 6.3.5.1 and 6.4.1.1 are from the LO 
website. In both cases, the standard pallet contains 12 columns and 10 rows.


Dan

On 3/1/20 2:36 PM, Steve Edmonds wrote:

I notice the same thing, but my linux version is 6.3 from the openSUSE
repository and not the LO website and the win 10 install is 6.4 so I
could not say that that hasn't caused the difference. I have noticed the
palettes changing over time and a while back I created my own custom
palette (including company branding colours) so I could have consistency.
steve

On 02/03/2020 07:19, Cuyahoga Falls wrote:

I have two laptops running LibreOffice. One is a Sony Vaio with LO
6.0.6.x and Linux Mint 18. The other is a Lenovo with LO 6.0.7.x and
Windows 10.

I recently opened an Impress Presentation on my Windows machine to
work on. At one point, I wanted to change the color of my font on one
of my slides. I went to the font color icon on the toolbar and clicked
the down arrow. I immediately noticed that the selection of available
colors was different that that available on my Linux computer.

To be more specific, if I click on the font color icon on the Windows
computer, I get a selection of available colors arranged in 12 columns
by 10 rows. For this example, I am using the colors available in the
palette called "standard." The top row shows 12 shades of gray. In the
second row, the color choices are "Yellow," "Gold," "Orange," "Brick,"
"Red," "Magenta," "Purple," "Indigo," "Blue," "Teal," "Green," and
"Lime." Then under each color column are boxes called Light  or
Dark  followed by a number. So, for example, if I look at the
"Blue" column, the top color is represented simply as "Blue." Below it
are color boxes called "Light Blue 4," Light Blue 3," and so on down
to "Light Blue 1," then followed by "Dark Blue 1," up to "Dark Blue
4." Each column is similarly arranged under its respective color.

On my Linux computer, the "standard" palette consists of 12 columns by
15 rows of colors. The color row below the row of gray, is represented
by the colors, "Yellow," "Orange," "Red," "Pink," "Magenta," "Purple,"
"Blue," "Sky Blue," "Cyan," "Turquoise," "Green," and "Yellow Green."
Then below each main color are boxes ranging from  1 to 
9 with no light or dark designations.

In short, the "standard" font color palette on LO in Windows is
different from the "standard" palette on LO in Linux Mint. Moreover,
the color represented as "Blue" on my Windows machine is decidedly
different than the color called "Blue" on the Linux machine.

I must say I have been using both computers for over a year now and I
often share LO files between the two computers. It was only recently
-- in the past week -- that I noticed the difference in standard color
palettes. I could have sworn that the two palettes were the same in
the past, but I can't think of anything I could have done to cause the
Windows LO "standard" color palette to suddenly change.

In an attempt to "fix" things, I downloaded and installed LO 6.3.4.2
to my Windows computer, and also renamed my user profile. Neither had
any effect on the way the "standard" font-color is represented.

I know this is longer than anyone would like, but if anyone can
confirm similar behavior on their Windows vs. Linux installations of
LO, or recommend any action, I would appreciate it.

Virgil







--
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] Copying & Pasting PNG files into Libre Writer

[Dan Lewis]

Does Edit > Link exist? If so, use this to embed the PNG file in the 
Writer document. You should be able to copy the PNG from the message 
body and past to a Writer document. Then copy the text as well.


Dan

On 2/20/20 10:15 AM, charles meyer wrote:

Hi All,

I want to save my gmail messages which have PNG files in the message body
but when I copy/paste into Libre Writer 6.2.5.2 (x86) it does not paste the
PNG into the new file, it saves the url to that PNG graphic in red.

Is there something I need to install with LO to save the graphic "pictures"
in LO so I cna voew them as a graphic/photo other than a a red line of url?

Thank you.

Charles.



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

[Dan Lewis]

On 1/26/20 6:26 AM, H. Stoellinger wrote:

Hello,
I see that 6.4.3 is available. I cannot see any language versions. Am 
I missing something?

Thanks for your help
H. Stoellinger


Actually it is 6.4.0.3. No, there are not language versions available 
for Windows. There are for Debian which I use so I did not notice this 
at first. I'm not sure what is the hold up for this. You might want to 
check back periodically to see if they have been added.


Dan


--
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] font formats

[Dan Lewis]

Two things come to mind when I reread your original email: "I am using 
6.3, vanilla ubuntu". Is the default font the same one as the default 
font for the Ubuntu system? What happens if you change the Ubuntu 
default to the font you want to use? What happens if you download 
LibreOffice 6.3 from the LibreOffice web site. Will you still have this 
problem?


Dan

On 1/11/20 6:34 AM, John Sweeney wrote:


I have selected all the text in the paragraph, tried ctrl-m, tried reapplying 
the paragraph style, opening the paragraph style and changing the font and then 
apply, none of these things affect the font.


On January 10, 2020 11:29:56 AM UTC, Pieter van Oostrum 
 wrote:

John Sweeney  writes:


I am using 6.3, vanilla ubuntu. I continue to have a lot of problems
getting the font of a paragraph to obey the paragraph style

instruction,

instead it tends to default to a font called "Default paragraph font"

or

something else and no amount of removal of direct formatting or using
ctrl-m helps. Anyone got any ideas?

Is this the Default paragraph style, or your own style?
If it is your own style, did you select the text and apply this
paragraph style to all the text? Otherwise the paragraph will be in the
default style.
You apply a style to the selection by double clicking on the style in
the Styles and Formatting side pane or in the Style selector.
Also your own style will have to specify itself for Next Style,
otherwise the next paragraph will again be the default style.
--
Pieter van Oostrum
www: http://pieter.vanoostrum.org/
PGP key: [8DAE142BE17999C4]


--
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] font formats

[Dan Lewis]

Is it something that you could share? Perhaps another pair of eyes would 
help. I would personally like to try; send me a copy directly if you want.


Dan

On 1/11/20 6:28 AM, John Sweeney wrote:
Thanks for helping. I am not a new user. I have been using Linux since 
1994 or so and libreOffice or is predecessor for 15 years or so. I am 
very familiar with paragraph styles. This problem continues to beat me.


On January 10, 2020 3:32:58 PM UTC, Dan Lewis 
 wrote:


On 1/9/20 11:39 PM, John Sweeney wrote:

I am using 6.3, vanilla ubuntu. I continue to have a lot of
problems getting the font of a paragraph to obey the paragraph
style instruction, instead it tends to default to a font
called "Default paragraph font" or something else and no
amount of removal of direct formatting or using ctrl-m helps.
Anyone got any ideas? 



Your problem is obviously not direct formatting at all: it is with the
style that has been applied to this paragraph. All you have to do is to
change the font this style uses to get the font that you want.

F11 will open the Styles dialog on the right side of LIbreOffice. Make
sure that paragraph styles is selected (far left icon at the top).
Select the offending paragraph. The style that controls the attributes
of this paragraph is highlighted. Right click the style and select
"Modify..." Click the Font tab and then select the font you want to use
from the list. Close this dialog.

I have been rather detailed because I am not sure you know how to change
the properties of a style. I would also recommend (if you have not done
so already) that you download the Styles chapter in the Getting Started
Guide. The Writer Guide has one or two chapters on styles as well. It
would be a good resource.

Dan


--
Sent from my Android device with K-9 Mail. Please excuse my brevity. 


--
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] font formats

[Dan Lewis]

On 1/9/20 11:39 PM, John Sweeney wrote:

I am using 6.3, vanilla ubuntu. I continue to have a lot of problems
getting the font of a paragraph to obey the paragraph style instruction,
instead it tends to default to a font called "Default paragraph font" or
something else and no amount of removal of direct formatting or using
ctrl-m helps. Anyone got any ideas?


Your problem is obviously not direct formatting at all: it is with the 
style that has been applied to this paragraph. All you have to do is to 
change the font this style uses to get the font that you want.


F11 will open the Styles dialog on the right side of LIbreOffice. Make 
sure that paragraph styles is selected (far left icon at the top). 
Select the offending paragraph. The style that controls the attributes 
of this paragraph is highlighted. Right click the style and select 
"Modify..." Click the Font tab and then select the font you want to use 
from the list. Close this dialog.


I have been rather detailed because I am not sure you know how to change 
the properties of a style. I would also recommend (if you have not done 
so already) that you download the Styles chapter in the Getting Started 
Guide. The Writer Guide has one or two chapters on styles as well. It 
would be a good resource.


Dan


--
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] Libre base report writer

[Dan Lewis]

Ubuntu does NOT contain the Base module in their version of LIbreOffice; 
you have to download and install it. That file is libreoffice-base. Make 
sure that when you download this that libreoffice-base-core is also 
downloaded and installed. If you use Synaptic, doing this should not be 
very hard at all. "sudo apt install libreoffice-base" will also 
accomplish. After this is done, you should have no problems with running 
your reports.


Dan

On 12/13/19 10:24 AM, Peter wrote:
Yes. But if I select report libre base errors out and stops working. I 
have several reports which are in the menu system. They no longer work 
and if I select them libre base stops working. My version of Libre 
Office was installed from the ububtu repository.


Regards

Peter

On 13/12/19 11:48 pm, Dan Lewis wrote:


On 12/12/19 8:31 PM, Peter wrote:
Years ago when I first used Libre Base it had a built in reporting 
software. Yhe later versions do not include this. Is this software 
still available and if so how do I get it and install it?


Regards

Peter Goggin

When a base file is opened, the main window contains a vertical list 
on the left side containing four items: Table, Query, Form, and 
Report. The last one is the reporting software. Is this what you also 
see?


Dan








--
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] Libre base report writer

[Dan Lewis]

On 12/12/19 8:31 PM, Peter wrote:
Years ago when I first used Libre Base it had a built in reporting 
software. Yhe later versions do not include this. Is this software 
still available and if so how do I get it and install it?


Regards

Peter Goggin

When a base file is opened, the main window contains a vertical list on 
the left side containing four items: Table, Query, Form, and Report. The 
last one is the reporting software. Is this what you also see?


Dan



--
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] Strange behavior in Writer 6.3.1

[Dan Lewis]

Looks like I made a mistake. A blank Writer document persists when 
opening a used Writer document using 6.3.2.1 but not when using 6.2.6.2. 
I may not have paid close enough attention as to which version I was 
using at that time. (I can actually run both at the same time.) Ubuntu 18.04


Dan

On 9/25/19 5:48 AM, Helmut Leininger wrote:

On 9/25/19 2:36 AM, waterbearer54@gmx.com9jK30(#own9Dhj wrote:

Enviar: martes 24 de septiembre de 2019 a las 22:33
De: "MR ZenWiz" 
Para: LibreOffice 
Asunto: [libreoffice-users] Strange behavior in Writer 6.3.1

Since 6.3.1 came out, the new blank document window persists, making
it an annoying extra step to close that unnecessary LO window since
the blank new document does not go away on its own.


I have also seen this (Mageia 8). I could not find a corresponding
bug report, but given the possible labels, they may be one. Perhaps
someone on the dev team who follows this list could comment?


It may be something that creeped into LO but has not remained. I am
using 6.3.2.1 which is a pre-release version. I do not get the same
result as you. The blank page disappears when I open an already
existing writer file. So be patient, 6.3.2 will be released in the
near future.

I have been working with the LO Documentation team for many years, and
that is why I know how to download both the daily builds and
pre-release versions. I had to in order to do my research for what I
write.

Dan




--
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] Strange behavior in Writer 6.3.1

[Dan Lewis]

On 9/25/19 2:36 AM, waterbearer54@gmx.com9jK30(#own9Dhj wrote:

Enviar: martes 24 de septiembre de 2019 a las 22:33
De: "MR ZenWiz" 
Para: LibreOffice 
Asunto: [libreoffice-users] Strange behavior in Writer 6.3.1

Since 6.3.1 came out, the new blank document window persists, making
it an annoying extra step to close that unnecessary LO window since
the blank new document does not go away on its own.


I have also seen this (Mageia 8). I could not find a corresponding bug report, 
but given the possible labels, they may be one. Perhaps someone on the dev team 
who follows this list could comment?

It may be something that creeped into LO but has not remained. I am 
using 6.3.2.1 which is a pre-release version. I do not get the same 
result as you. The blank page disappears when I open an already existing 
writer file. So be patient, 6.3.2 will be released in the near future.


I have been working with the LO Documentation team for many years, and 
that is why I know how to download both the daily builds and pre-release 
versions. I had to in order to do my research for what I write.


Dan


--
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] Resize object symmetrically?

[Dan Lewis]

On 9/12/19 16:47, Johnny Rosenberg wrote:

Den tors 12 sep. 2019 kl 18:35 skrev Dan Lewis :


Strange, when I create a square image, I can shift+drag to resize the
image symmetrically. This is using 6.3.1.2. In my case, I released the
mouse button *before* shift. I did this with a corner and both sides
(top and bottom). The order of which (shift, mouse) is released does
matter when using anyone of the sides. It does not matter when using the
corner. Release shift before the mouse produces a rectangle. Releasing
the mouse first produces a larger square.

Dan



Okay, so now I tested this with 6.2.6.2. Here are my results:
*Corner*
Releasing Shift first: *Square*
Releasing mouse button first: *Rectangle*
*Side*
Releasing Shift first:  *Rectangle *
Releasing mouse button first:  *Rectangle *

So it's at least possible to drag and release to a square, but the result
is NOT the same as the pre-drawn square that you see while moving the mouse.
I think this feature needs a little more work. It's not a perfect "what you
see is what you get", as far as I'm concerned. Why the pre-drawing if the
result is going to be something else anyway?


Johnny Rosenberg


 I just retested this with 6.2.6.1 (pre-release from the LO website). I 
get a square using either side or a corner when releasing the mouse 
button first. Perhaps this is the difference: I continue to hold down 
the shirt key until the square is redrawn. It is the exact same size as 
what it was just before releasing the mouse.


Personally, I still think that using the Position and Size dialog to set 
the size desired.


Dan



On 9/12/19 10:35, Johnny Rosenberg wrote:

Seems to be a bug. Shift + drag in either a corner or a side should work,
and it looks like it works until you release the mouse button. Maybe you
should file a bug report.

Den tors 12 sep. 2019 kl 14:29 skrev Blue Upsilon <
blue.upsi...@protonmail.com>:


Let's say I insert a square or image to my slide or document.
I want to resize it symmetrically,
like let's say I want to make it larger vertically and as click & hold

and

drag down I want it to not just get bigger vertically down but
symmetrically up too;  by help of pressing a key.

Most visual editors have this like InkScape or MS office, etc.
(In InkScape you press Shift and drag and it resizes in both

directions.)

Does LO have this?  (I've tried searching online and trying different

key

combinations to no avail...)

Thanks in advance,
Blue Upsilon
--
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



--
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] Resize object symmetrically?

[Dan Lewis]

Strange, when I create a square image, I can shift+drag to resize the 
image symmetrically. This is using 6.3.1.2. In my case, I released the 
mouse button *before* shift. I did this with a corner and both sides 
(top and bottom). The order of which (shift, mouse) is released does 
matter when using anyone of the sides. It does not matter when using the 
corner. Release shift before the mouse produces a rectangle. Releasing 
the mouse first produces a larger square.


Dan

On 9/12/19 10:35, Johnny Rosenberg wrote:

Seems to be a bug. Shift + drag in either a corner or a side should work,
and it looks like it works until you release the mouse button. Maybe you
should file a bug report.

Den tors 12 sep. 2019 kl 14:29 skrev Blue Upsilon <
blue.upsi...@protonmail.com>:


Let's say I insert a square or image to my slide or document.
I want to resize it symmetrically,
like let's say I want to make it larger vertically and as click & hold and
drag down I want it to not just get bigger vertically down but
symmetrically up too;  by help of pressing a key.

Most visual editors have this like InkScape or MS office, etc.
(In InkScape you press Shift and drag and it resizes in both directions.)

Does LO have this?  (I've tried searching online and trying different key
combinations to no avail...)

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



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

Re: [libreoffice-users] Resize object symmetrically?

[Dan Lewis]

On 9/12/19 08:27, Blue Upsilon wrote:

Let's say I insert a square or image to my slide or document.
I want to resize it symmetrically,
like let's say I want to make it larger vertically and as click & hold and drag 
down I want it to not just get bigger vertically down but symmetrically up too;  by 
help of pressing a key.

Most visual editors have this like InkScape or MS office, etc.
(In InkScape you press Shift and drag and it resizes in both directions.)

Does LO have this?  (I've tried searching online and trying different key 
combinations to no avail...)

Thanks in advance,
Blue Upsilon


A simple method although it does not involve dragging. Right click the 
image. Select "Position and Size" from the context menu. Now you have 
two choices:

1) Select "Keep ratio" and enter either the height or width values.
2) Enter the height and width values.

Dan


--
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] List down?

[Dan Lewis]

I have been receiing several messages daily for months.

Dan

On 8/15/19 07:28, M Henri Day wrote:

Den tors 15 aug. 2019 kl 12:45 skrev Thomas Blasejewicz :


Good evening
Is the list down?
I have not received a single message in almost a week.

Thomas


I'm still receiving messages - save when I'm not, but then I usually get a
message with a number that I fail to understand how I am expected to use,
telling me that everything is back to normal if I see it

Henri



--
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] Table fields from Mariadb to Base

[Dan Lewis]

On 7/16/19 1:54 PM, Harvey Nimmo wrote:

I am connecting a Base client (Version: 6.1.3.2) to a remote mariadb
using the MySQL (JDBC) connector.

A form I had generated in Base needed a new field that had to be added
to the source (Base) query and the related (Mariadb) table.

Having added the new field to the table using the Base client, I
expected it to appear in the query which is of the form (SELECT * FROM
). It didn't until I closed Base and restarted it.

Is this a bug? Known or new?

Best Regards

Harvey


I did not have any problem with this. I did this:

1) Created a new query from a current table in my database, Commentary. 
Use SQL, I added

    SELECT * FROM `Bible`.`Commentary` `Commentary`

2) Added a field to Commentary table.

3) Saved the table.

4) Saved the database. (Did you do this?)

5)I opened the query. (If your query was already open, you should have 
clicked the Run button.)


Dan


--
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] Re: Reveal code, old macros convert them to LO

[Dan Lewis]

On 7/6/19 5:18 AM, Uwe Brauer wrote:

Den tors 4 juli 2019 kl 18:16 skrev John :
If you use styles the way it's intended, you won't have those problems in
the first place. I have never had them (as far as I remember), even when I
was not using styles properly. Direct formatting should generally be
avoided, if you ask me.

Yes if you only work with odt documents. But if you force to deal with
docx and you run into problems, that feature might be useful.


I have a .docx file that I experimented with. These are the things that 
I did with it.


1) Opened the .docx file in LO 6.2.5.1, and saved it as a .odt file.

2) Used Control+A to select the entire document.

3) Right clicked the text and then selected "Clear Direct Formatting".

4) Used LO to reformat the document to match the original documents layout.

I did run into problems with hyperlinks as they retained the original 
format especially the font and font size. To get around that, I 
recreated the hyperlinks along side of the originals. Then I erased the 
originals.


If you want, I could take a look at your document to see what could be 
done with it.


Dan


--
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 "My Templates"?

[Dan Lewis]

On 6/19/19 4:21 PM, James Knott wrote:

I recently updated LibreOffice to v6.1.3.2 on openSUSE 15.1.  One thing
I've noticed is my own templates are now mixed in with the provided
templates.  Why was this done?  I now have to sort through several
templates, that I have no use for, to find the ones I created.


   I make a habit of using the LibreOffice versions from 
www.libreoffice.org rather than from my operating system. i have found 
over the years that O/S versions have some bugs that LO versions do not. 
This may be the case here.


   More importantly, I also use the Manage Templates options. This 
gives me two drop down lists in which to restrict which templates are 
displayed. The first  contains a list of applications. The second one 
contains a list of categories which includes My Templates. All of my 
templates are Documents, so I select this it. Under Categories, I select 
My Templates. When I view the templates displayed, only one of them is 
not my personal created templates: Standard. So, I do not get the same 
results as you have.


   You might also be able to move the undesirable templates to other 
categories.


Dan



--
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] How to format fields?

[Dan Lewis]

What component of LO have you been using to do this? (Writer [mail 
merge], Calc, Base) More specifics would be nice in terms of the step 
you took to create the documents.


Dan

On 5/17/19 4:32 AM, Oszkó Albert wrote:

Hi all,

I have quite a few certificates containing several data. I inserted 
them as fields (name, birth date etc.) There should also be the number 
of the certificate, which I formatted as follows: "aB-"0#"/2019". I 
expected that aB-01/2019 will appear on the first document but only 
figures 1,2 etc. appeared. What's gone wrong? In the past years I used 
the same formatting (with the then existing version of LO) and it worked.


Thanks for the help

Albert




--
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] "Add to dictionary" doesn't work

[Dan Lewis]

Tools > Options > Language settings > Writing Aides. Under User-defined 
dictionaries, click New. Name your new dictionary. You do not have to 
select a language for this dictionary unless necessary. [All] will work 
in all languages. Click OK.


Now when you right click on a new technical term, you again click "Add 
to Dictionary". This time you will see a list of dictionaries including 
the one you created. Click it to add the term to you new dictionary.


Dan

On 4/19/19 2:51 PM, John wrote:

Running LO 6.1.3.2 on Fedora 28 workstation.

I am editing a number of technical documents which include words not in the
Libre Office dictionary so when I encounter them I click "add to dictionary".

That works fine so long as the current file is open but as soon as I close the
file the dictionary forgets about the words that I have added and the next
document shows all the technical words as spelling errors.

Is this a known error?

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] Tabs in selection of text

[Dan Lewis]

On 4/3/19 8:37 PM, Carl Paulsen wrote:
I have a number of "paragraphs" of text (job listing section of a 
resume) for which I'd like to add tab stops.  I select the lines and 
click the tab stop I want, then click in the ruler, but nothing 
happens.  I see no menu item to format tabs, though I did stumble into 
one dialog box with Tabs that required manual setting and it was 
unclear just where those tabs would be applied.  In any case, I can't 
find that any more.


In the help document 
(https://help.libreoffice.org/Common/Inserting_and_Editing_Tab_Stops) 
it says for changing one or more paragraphs: "Select the paragraphs, 
then click inside the ruler."  That is most definitely not working.  
Finally, if I clear all formatting, I get the default tab stops and 
could re-format the entire section that way.  But that's a bit of work 
given all the formatting I'd lose.


What do I do to quickly and simply edit tab stops, and why is it so 
difficult in LO?


FYI I find the Styles aspect of LibreOffice to be entirely unintuitive 
and I've never been able to work with them.  I realize that should be 
a goal but it's not possible in my current timeline.


Thank you!


   I missed this when this thread was started. Your 'FYI' statement is 
probably the real reason for all of your problems. LibreOffice is 
designed to use styles for text creation and/or editing. Manual 
formatting can create so many more problems than using styles. Besides 
they are harder to solve. The 'Getting Started Guide' has at least one 
chapter on styles as does the 'Writer Guide'. When I first began working 
on the documentation for OpenOffice.org (early 2000's) and later 
LibreOffice, I used this chapters to learn how to use styles. I have 
never regretted. I would like to know what is 'unintuitive' with styles. 
I am thinking it might be that you think in terms of lines of type 
verses groups of paragraphs.


  You also may have some problems with the concept of nesting. Each 
paragraph has specific set of characteristics that applies to every 
character of the paragraph; it ends with a paragraph break. Character 
styles are used to give specific characteristics to a continuous set of 
characters within the paragraph.


   Perhaps it might be unintuitive for you to think that each member of 
a list can also be a separate paragraph. Yet this might be the best way 
to give you document the formatting you want it to have.


Dan


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

[Dan Lewis]

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

Re: [libreoffice-users] Base/Firebird Queries broken

[Dan Lewis]

To begin with, what is the query's SQL. Someone might be able to 
discover the problem from there. In addition, knowing the properties of 
each one of the tables could also help solve it.


On 1/14/19 6:23 PM, Paul D. Mirowsky wrote:
I have shifted one of my database to Firebird using the advanced 
'migration' tool as a test.


One query I am testing is a join of 4 tables.

Series
Series
Series
Series

Date
Date Date

Time
Time Time

Criterion: Series 134, Select True

I do have Alias fields, but understand from net search that they are 
disregarded by Firebird.


I have waited 5 minutes for the query to process, but it only results 
in a blank screen or not responding.


Windows 7 64 bit. LibreOffice Version: 6.1.3.2 (x64)

The query did work with HSQLDB.

Any hint as to where I'm going wrong.

Thanks

Paul








--
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] Cell style background colour

[Dan Lewis]

On 1/3/19 11:14 AM, Dan Lewis wrote:

Inline post

On 1/2/19 7:17 PM, Johnny Rosenberg wrote:
Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker 
:



At 22:58 01/01/2019 +0100, you wrote:

... I can't find how to add colours to the
background colour palette. In older LibreOffice
versions, or maybe it was even Apache
OpenOffice, I could add colours in Tools -> Options… -> somewhere, ...

Yup: at Tools | Options... | LibreOffice | Colours.


Exactly, and it's gone now since version 5.something.


     Colors can be added to the Custom pallet with colors you name. 
These are available in Base, Impress, and Writer. Once you have 
created and named them, they are available for Font colors and 
Background colors in the Formatting toolbar in Calc.


 I recommend you open a new document in Writer. Styles > Edit 
Style. Click the Color Button. Select the RGB values you desire on the 
right side of the dialog. Click the Pick button (bottom right). This 
puts the new color in the Resent Colors box on the left side. Click 
this color there and then click the Add button. Enter you color name 
in the popup window and click OK.


 There is a drop down list with the names of color pallets that 
are available for your use. One of them in the Custom pallet.


Dan


 Styles > Edit Style > Area is the correct path to take. (I forgot 
about "Area", sorry.)


Dan







... but it seems to be removed. I miss quite a
few colours in the colour selection area in
(right click a style) -> Modify… -> Background
-> Background colour, so I want to add my own
and give them names (other than "#15a3b7" or
similar). I'm pretty sure I could do that in old
versions, and I guess it's still possible in
today's versions, I just seem to not being able
to figure out how… What am I missing here?

The Getting Started Guide says "You can [...]
change individual colors to your own taste. To do
this, use the Area dialog by selecting Format >
Area on the Menu bar or clicking the Area icon on
the Sidebar, then selecting the Colors tab." (The
Calc Guide - currently at 4.1 - does not appear to have caught up.)

Does this not work?

Yes, but that was obviously not what I was asking for, that is change 
the
suggested colours in the modifying background colour of a style 
dialogue.




I trust this helps.

But it didn't, since the answer was not related to my question (or 
maybe I

just didn't understand the answer).



Brian Barker - privately




--
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] Cell style background colour

[Dan Lewis]

Inline post

On 1/2/19 7:17 PM, Johnny Rosenberg wrote:

Den tis 1 jan. 2019 kl 23:29 skrev Brian Barker :


At 22:58 01/01/2019 +0100, you wrote:

... I can't find how to add colours to the
background colour palette. In older LibreOffice
versions, or maybe it was even Apache
OpenOffice, I could add colours in Tools -> Options… -> somewhere, ...

Yup: at Tools | Options... | LibreOffice | Colours.


Exactly, and it's gone now since version 5.something.


     Colors can be added to the Custom pallet with colors you name. 
These are available in Base, Impress, and Writer. Once you have created 
and named them, they are available for Font colors and Background colors 
in the Formatting toolbar in Calc.


 I recommend you open a new document in Writer. Styles > Edit 
Style. Click the Color Button. Select the RGB values you desire on the 
right side of the dialog. Click the Pick button (bottom right). This 
puts the new color in the Resent Colors box on the left side. Click this 
color there and then click the Add button. Enter you color name in the 
popup window and click OK.


 There is a drop down list with the names of color pallets that are 
available for your use. One of them in the Custom pallet.


Dan





... but it seems to be removed. I miss quite a
few colours in the colour selection area in
(right click a style) -> Modify… -> Background
-> Background colour, so I want to add my own
and give them names (other than "#15a3b7" or
similar). I'm pretty sure I could do that in old
versions, and I guess it's still possible in
today's versions, I just seem to not being able
to figure out how… What am I missing here?

The Getting Started Guide says "You can [...]
change individual colors to your own taste. To do
this, use the Area dialog by selecting Format >
Area on the Menu bar or clicking the Area icon on
the Sidebar, then selecting the Colors tab." (The
Calc Guide - currently at 4.1 - does not appear to have caught up.)

Does this not work?


Yes, but that was obviously not what I was asking for, that is change the
suggested colours in the modifying background colour of a style dialogue.



I trust this helps.


But it didn't, since the answer was not related to my question (or maybe I
just didn't understand the answer).



Brian Barker - privately




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

[Dan Lewis]

Perhaps you need to begin over as far as you fields are concerned. First 
of all, you only need two fields in the table: Fee1 and Fee2. You also 
need a primary key which is listed first. Fee1 and fee2 need to be given 
the properties you want for them. The primary key has to have "entry 
required" selected. I prefer it to also have this property: INTEGER. 
Save the table. When I did this, I named the table, Currency, and the 
primary key, ID.


Second, create a query in SQL View. Use this SQL statement:

SELECT "ID", "Fee1", "Fee2", "Fee1" + "Fee2" AS "Total" FROM "Currency"

Save the query giving it a name other than Currency. (You can not have a 
table and query with the same name.)


Running the query, the ID field has . You can not enter 
values for Fee1 and Fee2. Typing  after entering values for Fee1 
and Fee2 will place the sum in the Total column.


Now you can either use the Form wizard to create a form from the query 
or use Girvin's suggestion for connecting your present form to the query.


Dan

On 10/13/2018 07:07 AM, Adam Fenn wrote:

On 11 Oct 2018, at 23:39, Girvin Herr  wrote:

I am not sure where you are wanting this total.

I want it in the same form as fee1 and fee2.


First, you need to create a query,

I'm familiar with this.


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.

When I try to add the field using the Add Field icon LO crashes without fail. 
Is there a way around this?

Thank you for your help 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





--
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] side by side tables

[Dan Lewis]

On 09/26/2018 03:42 PM, libreoffice-ml.mbou...@spamgourmet.com wrote:

Gary Collins wrote:

Hi
Ive found out how to resize tables so they dont take up the full page 
width (though to be honest i usually find it easier and more flexible 
to simply include an additional  empty column to right and left and 
adjust widths as required) but what i would really like to be able to 
do is to have two (or perhaps more) tables juxtaposed horizontally. 
Is there a way to align tables horizontally (without resorting to 
frames, which i tend to find are a right pain in the proverbials)?

Im currently using version 5.2.2.2 build 1:5.2.2-0ubuntu2.1
Thanks
Gary


If you're set on avoiding frames, this won't help, but to be honest 
I'd do it with each table in a separate frame. If you set the width 
and height of the frame to the minimum allowed and tick the "AutoSize" 
box for each, it will automatically adjust to the size of the table. 
Then anchor and position the frames as required.


There will be a blank paragraph after the table, which prevents the 
height of the frame from being reduced to only just fit the table. 
That can be removed by placing the cursor in the bottom right cell of 
the table and pressing Ctrl+Shift+Del.


By default, frames have a border and padding between the outside of 
the frame and its contents. You might want to remove those for this 
purpose.


Once one frame is set up as needed, it might be easier to copy and 
paste that as required rather than adding new frames and reformatting 
them.


   If you do this often, you probably should consider using AutoText. 
(Control+F3) I have used it to inserting specific sized tables over and 
over again. Actually, you should be able to do what you want with either 
frames or tables multiple times.


Dan

--
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] New features in 6.1.0 Re: [libreoffice-l10n] Text for "New Features" page for translation, after LO 6.1 release

[Dan Lewis]

On 08/08/2018 11:37 AM, M Henri Day wrote:

Den ons 8 aug. 2018 kl 17:22 skrev James Knott :


I see the same thing.

On 08/08/2018 11:13 AM, Paul D. Mirowsky wrote:

FYI

11:08 AM EST

YouTube video is not displaying.

Results in message "If playback doesn't begin shortly, try restarting
your device" in Firefox.

Interestingly enough, if you move your cursor over the time line, it
display image from video.

Hope this helps.


On 8/8/2018 7:44 AM, Tom Davies wrote:

Hi :)
Mike Saunders and the rest of the marketing team (and translators) have
made a video showing the new features in LibreOffice 6.1.0.

https://www.youtube.com/watch?v=JvoCpnwGNFU

I think some of the new features are things that have been asked about
quite recently- and might mean we have better answers for those
questions
now.

Be wary though !!  This is the .0 release and it's only just been
releasedtoday so this is THE point at which the most unexpected and
unlikely breakages of functionality may occur !  It is also the BEST
time
to try out he new version AWAY from your regular install preferably on a
system you don't rely on for work or in a sandboxed area (Gnu&Linux has
MANY different ways of creating safe-areas to try things out in).

It is THE time that the most devs are focusing on this new release so
it's
the best time to find bugs or features that have gone wonky and post
bug-reports about them.

This is also a good time to join the QA Team to help them with
filing&admin
tasks, and perhaps asking bug-reporters for relevant information that
might
help the devs handle their request and generally help with first
responses.

Good luck and regards from
a Tom :)




On Wed, 8 Aug 2018 at 11:13, Mike Saunders <
mike.saund...@documentfoundation.org> wrote:


On 07/08/2018 16:01, Mike Saunders wrote:

2) There is a new video for LibreOffice 6.1; I'll provide the updated
URL tomorrow just before launch.

Here it is:

https://www.youtube.com/watch?v=JvoCpnwGNFU

Mike


Clicking Mike's link above runs the YouTube video without any problem on
Firefox on my 64-bit Linux Mint 19 installation

Henri

I am not having any problems watching the video either on Firefox, 64 
bit Ubuntu 18.04. I just finished watching.


Dan


--
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] broken file associations after installing the new version.

[Dan Lewis]

On 07/19/2018 12:57 AM, Tim-L wrote:
When I removed LibreOffice 6.0.3 from my Ubuntu 18.04 system, and then 
installed 6.0.5, the first time I opened a ODT document, it showed the 
ebook library package "Calibre" as the default package to open the ODT 
document.


SO, any ideas why after removing 6.0.3 and then installing the newest 
version 6.0.5 would not assign ODT files to Writer?  I know Calibre 
will convert between types of documents/books, but never knew about 
ODT files - if it does at all.  I know that once last year, when I 
installed a different package that could open the ODT file AFTER I 
installed the newest version of LibreOffice. I had to re-install that 
version of LO to get the file properties to list the correct packages.


Of course, today I just took one ODT file and changed the default 
package for it, which hopefully change it for all of the ODT files.


Still, how come I had the problem in the first place.  Shouldn't the 
install of LibreOffice on Ubuntu-Mate 18.04LTS grab the package 
preference for each of the default office file type? Both ODF and MS 
Office?  It should, right?


If this "not associating file types" during install is a bug, then it 
needs to be fixed.  I think people who have a good skill set, for both 
Windows and Linux, should know how to "manually" set the file 
association to the correct package/program.  The problem to me is 
those who are not as skilled, who find this broken association and 
"freak out".


I know many here in my apartment building who would "freak out" and 
then ask me to help them. I know more in the community who barely know 
how to install a package using Windows and a self-running CD/DVD, let 
alone being able to download the proper version of LibreOffice for 
their system, and then install it.




   I think I know what happened. When you removed 6.0.3 from your 
computer, you removed the file association between LibreOffice and the 
ODT files. This association is "open this type file with LibreOffice 
6.0.3". There is also a second level of file associations which is 
"other recommended applications". Calibre fits into that catagory. (I 
have used it to convert ODT files into ePUB format many times.) If, as I 
think, calebre was the top program in that list, it stands to reason 
that calibre would become the default package to open ODT files.
   It would seem that the most installation of 6.0.5 would to list it 
in the second level of file associations. I sometimes have more than one 
version of libreoffice on my computer. Then when I right click on an ODT 
file, I am given one of them as the default package. If I select "open 
with other application", I see all versions of libreoffice listed. 
(Right now I would see libreoffice 6.0 and 6.1.0 [which is RC1].)
   I should mention that upon installing a new version of libreoffice, 
I also modify the bootstraprc file so that a new folder of 
configurations files is written in ~/.config/libreoffice/. Right now in 
this folder, I have the following folders: 6HSQL and 6.1. The former is 
config files for 6.0.5 which I use for running hsqldb 2.4.1 as the 
backend for Base. The latter is for RC1. (I probably installed the RC1 
version in parallel and then using sudo moved the installation to /opt/.)


Dan

--
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] My Templates?

[Dan Lewis]

On 07/09/2018 09:23 AM, Virgil Arrington wrote:

On 07/08/2018 05:12 PM, James Knott wrote:

On 07/08/2018 04:52 PM, toki wrote:

* /home/ your-user-name /.config/libreoffice/4/user/template/

Found 'em there.  However, that does nothing for the problem of removing
My Templates, so that my templates are not mixed in with a bunch of
supplied templates that I don't use.

I don't understand the trend, not just here, but in other things too, of
breaking things that have worked well and replacing them with things
that are dumbed down or broken.

My Templates was very useful.  How could anyone be so unbelievably
stupid as to think removing it was an "improvement"?



I'm using LO 6.0.3.2 on Linux Mint and I still have "My Templates." It
just takes a couple steps to get there.

If I click on "File" > "Templates" > "Manage Templates", I am met with a
dialog box with templates. The default view on my computer shows all
templates of a given type (Document, Spreadsheet, etc.). In the upper
right corner of the dialog box is a drop down box. It seems to default
to "All Categories," but if I click on the drop down arrow, I can select
"My Templates" and then see only the templates I have created.

So, I think "My Templates" is still there; it just doesn't pop up by
default as I seem to remember it did in the past.

Virgil

Here is my thought. I am starting Libreoffice 6.05.2. No templates. I 
happen to have a folder containing all of my created templates. Then, I 
used Manage Templates as you did. That is when I clicked the Import 
button. First I selected My Templates as the place where I wanted to 
import them. I browsed to my template "repository" and selected all of 
the templates I wanted and imported all of them at one time. Like you 
said, when the selection on the Manage Templates page was All 
categories, I saw all of the templates: mine as well as all of the 
others. And as you said, selecting "My Templates" shows only mine.


Here is something that I also discovered that you might also consider. I 
closed Manage Templates. Then I reopened it. It opened at "My 
Templates". I have a feeling that whatever choice you use as to what 
type of templates you want to see is the same thing you will see the 
next time. I have done this twice with the same result.


I have also create more categories by going to the template folder you 
mentioned above. I created a subfolder there to contain templates with a 
similar property. Then I moved them into it. When I opened "Manage 
Templates" again, the name of that folder appeared in the drop down 
list. I suppose this is called organization...


Dan


--
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] Insert current date

[Dan Lewis]

On 05/21/2018 10:46 AM, Dan Lewis wrote:

On 05/21/2018 09:57 AM, HBarr wrote:

Thanks Robert, that's very helpful.

Now, how would I change the result to -MM-DD?

Regards,

Howard

 This is a little more difficult, but not by much.

 Right click the date.
 Select Additional formats in the Format column.
 Enter what you want in the Format Code box.
 Click OK.

 If you then want to convert this to AutoText after changing the 
date format,

 Ctl+F3 opens AutoText dialog
 Type the name of it in the Name box.
  Modify the Shortcut name if desired.
  Click the AutoText button and select New(text only) from the 
list.

  Click closed.

Dan

OK, I left out one important point:
   After right clicking the date created by Ctrl+7, select 
Fields from the menu.

   Then select Additional formats in the Format column...

Dan


On 21 May 2018 at 21:50, Robert Großkopf  
wrote:

Hi Peggy,

there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.

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

Re: [libreoffice-users] Insert current date

[Dan Lewis]

On 05/21/2018 09:57 AM, HBarr wrote:

Thanks Robert, that's very helpful.

Now, how would I change the result to -MM-DD?

Regards,

Howard

 This is a little more difficult, but not by much.

 Right click the date.
 Select Additional formats in the Format column.
 Enter what you want in the Format Code box.
 Click OK.

 If you then want to convert this to AutoText after changing the 
date format,

 Ctl+F3 opens AutoText dialog
 Type the name of it in the Name box.
  Modify the Shortcut name if desired.
  Click the AutoText button and select New(text only) from the 
list.

  Click closed.

Dan


On 21 May 2018 at 21:50, Robert Großkopf  
wrote:

Hi Peggy,

there is no macro needed.

Open a Writer-document
Go to
Tools > Customize > Keyboard
Type in "Functions": 'Date'
Now look for a free Shortcut-Key, for example Ctrl+7.
Click "Modify" on the right.
Click "Save".

Now you could insert the current date with Ctrl+7.

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

Re: [libreoffice-users] New LibreOffice Book

[Dan Lewis]

On 03/25/2016 05:22 PM, libreoffice-ml.mbou...@spamgourmet.com wrote:

Bruce Byfield wrote:

On Friday, March 25, 2016 01:51:25 PM James Knott wrote:

On 03/25/2016 01:42 PM, Dave Liesse wrote:

This is my busy season at work so I haven't had a lot of time, yet,
but I downloaded the PDF version and took a quick look at a couple of
chapters I need the most.  I'm quite impressed.  Good job!


An epub version would be nice.  I find they work better on tablets 
than pdf.


I hope an epub version is coming. However, porting highly-formatted 
material

to .epub format can be difficult, so it's going to take some time.

If anybody has any advice, I would appreciate hearing it.


Calibre  is an open source ebook manager 
which can import various formats, including ODT, and convert to 
various formats, including EPUB. I haven't used it much; about the 
most I've done is convert a couple of CHM (Windows help) files to AZW3 
to read on a Kindle, which seemed to work reasonably well. On the 
Kindle, images are scaled to fit on the page, but a press-and-hold 
allows them to be enlarged to full screen and zoomed in further to see 
detail. I don't know how well it does with complex documents, but may 
be worth trying.


 I have used calibre to convert Getting Started with Base from ODT 
to ePUB format.


Dan

--
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] Hidden Section Problem

[Dan Lewis]

 Please send a copy of the database to me personally, and I will 
see what I can discover from it.


Dan

On 03/01/2016 02:57 PM, anne-ology wrote:

When clicking on this URL, a blank box appears ...
   then clicking on the file icon, 4 images are listed, but none are
available to open.

What are we supposed to see & what is your question?
   or are you checking to see if they are hidden?



From: Amit Rane 
Date: Tue, Mar 1, 2016 at 9:16 AM
Subject: [libreoffice-users] Hidden Section Problem
To: "users@global.libreoffice.org" 


Dear All,Please find the attached linkhttps://
drive.google.com/file/d/0Bz4iVhgemIkoMzF0bWJQVjdRYk0/view?usp=sharing.
I have made Database file.In this file i have created a form.In this form i
have created two section namely GenerateId Section and Library Section.I
have made this sections Hidden.Even though the section are hidden still
some part of section are visible in the upper left hand corner.I am using
LO 5.1
Awaiting for a solution.Thanks A lotGod Bless U All




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

Re: [libreoffice-users] Linking a Form to another table

[Dan Lewis]

On 01/07/2016 04:15 PM, Ian Whitfield wrote:s.

Hi All

I take from the lack of any replies to my post of a few days back that 
either anyone who can help out is still on Christmas Holidays or this 
just can not be done ??


Ianw
Pretoria RSA

  In reality your question does not make very much sense. A form has a 
table that to which it is linked. The form's controls are linked with 
the fields of that table.a
   Do you have another table with the same fields that you want to use 
instead of the table you now have linked to the same form.

   Please explain why you want to do this.

Dan

--
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] Lost connection to Database.

[Dan Lewis]

On 10/20/2015 11:02 AM, Ian Whitfield wrote:

Hi All

Due to problems with Kernel updates I have rebuilt my system using the 
last ISO disk I had, (2014-12).


I re-installed the ISO formatting the complete drive, updated the 
system via Synaptic to bring it up to date and restored all my 
backed-up data to /home. I then restored the MySQL folder under 
/var/lib that contains my Database.


I then updated LO to the latest version = 5.0.2.2
  But did you tell LO where the JDBC driver is located? Tools > 
Options > Advanced >Class Path > Add Archive. The browse to where the 
driver is located. Click Open. Click OK to close Class Path and again to 
close the dialog. Close LO. Restart LO.


But now when trying to connect to my database I get the error "The 
JDBC driver could not be loaded"


mysqld is set in Services to run on Boot, Skip networking is commented 
out in /etc/my.cnf.
Current driver in Base Options is set to - 
com.sun.star.comp.sdbc.JDBCDriver (with pooling enabled).

Any suggestions please??

PCLOS 32-bit. KDE,

Thanks

IanW
Pretoria RSA




--
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] Reset for tracked changes

[Dan Lewis]

On 09/30/2015 04:57 AM, Mike Cowlishaw wrote:

I have been experimenting with tracked changes and they look ideal for
indicating Editor's changes to a Standard document.  However, I cannot see
how to 'reset' the track once changes have been approved.   It seems one can
either show all changes ever made to the document, or none at all?

'Show changes since a given date' would probably be OK, but as the
timestamps in the XML are in local time(!) it would have to be used with
care ...

Mike Cowlishaw
 Did you notice that the Manage Changes dialog contains a column 
labeled Date? It is really a timestamp.


Dan

--
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] AutoText crashes

[Dan Lewis]

On 09/12/2015 02:32 PM, Sylvain Bromberger wrote:

AutoText used to work well, but now when I click on it in Edit (writer) it
crashes LibreOffice writer. I am currently located where I cannot download
5. Is there any remedy? Thanks in advance for any help.

Sylvain

   Are you perhaps using a computer made by Apple? I have a MacBook 
that I use. This means that instead of Control+F3 key combination, I 
have to use Control+F3+Fn. With some testing, this three key combination 
does not crash Writer, but it minimizes it. I found that I could use 
AutoText by using Edit > AutoText instead of the shortcut keys.


Dan

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

[libreoffice-users] Re: Unable to use Writer as a publication tool

[Dan Lewis]

On 08/06/2015 11:56 PM, V Stuart Foote wrote:

@madrosh,



The major bug I have is applying a "register-true" to an entire document
at a time. I use OL to put together a periodical, with columned text and
many images (which are put in frames and anchored to specific pages).

It is LO not OL,  or better LibreOffice.

Believe the best practice is to work within frames anchored to top or bottom
of page and activate register-true.  László Németh's Typography toolbar .oxt
extension seems to still work correctly in 5.0.0,  suggests using the
Graphite based Libertine G or Biolinum G fonts.



Is the problem related to the fact I am taking older OO files and
attempting to do this?

That probably doesn't help.



  I don't want to invest heavily in new projects until I get the bugs
sorted out. I find I am taking older files (in order to create a 2nd
edition of an older manuscript) and redoing every paragraph to get the
document to register true. In 4.3.7, the changes would simply not stay
after I saved the document.

Not sure if  details are embedded in ODF as style (and so are persistent and
move with the document), or it is a registry setting and would be held per
document in the user profile.  If the later, could explain the issue.



I tried saving in  ODT and DOC and DOCX formats, it didn't seem to matter.
Now in 5.0, not only do the changes not save if I go back and register the
paragraphs, but OL crashes every time.

You should work in an ODT for stability in formatting.   Using DOC or DOCX
requires filter export of document, and again to import. The round trip can
be very disruptive to stable formatting you're looking for.  If LibreOffice
5.0.0 is crashing--that is a bug and needs to be reported in Bugzilla



Also had some issues in 4.3.7 with image frames migrating, also related to
these revisions of older documents.
Is this all known behaviour? Are there still bugs outstanding if I were to
work on new projects and try to register the text?

Don't see a lot of issues reported in BZ, but that could just be that the
"register-true" feature for grid alignment in printed publications is not
widely know.  BZ  bug tdf#66434
suggests that
is the case.

Please report any specific bugs you identify. This seems to be an under
appreciated feature of LibreOffice.



--
View this message in context: 
http://nabble.documentfoundation.org/Unable-to-use-Writer-as-a-publication-tool-tp4156533p4156542.html
Sent from the Dev mailing list archive at Nabble.com.
___
LibreOffice mailing list
libreoff...@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice
 This question should have been sent to 
users@global.libreoffice.org  instead of 
the developer mailing list. As you can see, I have sent a copy of this 
email to the proper mailing list.
 The answer to your question is found in how to use styles. These 
topics are covered in the Getting Started Guide and the Writer Guide. 
Between these two guides, there are three chapters on how to use styles. 
https://wiki.documentfoundation.org/Documentation/Publications is the 
link you need to get them.
 Specifically, the "Default Style" paragraph style has a tab 
"Indenting and Spacing". At the bottom of it is a checkbox under the 
heading "Resister-true." Click it to activate it. If all of your 
paragraph styles are based upon the "Default Style" paragraph style, 
this should apply register-true to the whole document. Double check with 
the references that I mention above to be sure.


Dan

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

Re: [libreoffice-users] Question about LO Writer and "complex documents"

[Dan Lewis]

On 07/24/2015 09:31 AM, Tom Williams wrote:

Greetings!  With all of the recent discussion about Linux being a viable
alternative to Windows, in today's computing world, I've read many
comments about whether or not LibreOffice is a good alternative to MS
Office.  Some say yes, others say no.   One common comment made by those
who say no is Writer isn't good for "complex documents".  For "basic"
word processing, it's fine.

Question:  in what ways does LO Writer "fail" at editing or creating
"complex documents"?

Does anyone here have any experience with LO Writer and "complex
documents"?  If so, what has your experience been (either good or bad)?

I know I haven't actually defined "complex documents" but I haven't seen
any definition of that in any of the comments I've read either.  So,
I'll leave the definition up to whatever you would consider a "complex
document".  :)

I've submitted on LO Writer bug where Writer didn't handle Word
documents with pages with different page orientations well.  I was
helping a friend with a term paper and most of the paper was in portrait
orientation, but a few pages were in landscape.  LO Writer treated the
entire document as either portrait or landscape but couldn't handle the
mixture of both. I think that's been fixed, since I reported the bug.
That's been about my only experience with a "complex document".

Thanks!

Peace...

"The other" Tom
 Is the problem with Complex documents really about the complexity, 
or is it about using LO and?Word on a complex document?
 I have been working with ODF Authors to create documentation for 
OpenOffice.org and then LibreOffice. I consider these document to be 
complex.


Dan

--
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] Form navigator button not working in LO base

[Dan Lewis]

On 05/10/2015 03:20 PM, Paul Fearnley wrote:

I have been successfully designing forms with subforms in LO Base using the
form navigator. Strangely the form navigator has just stopped working. When
I click on the icon, nothing happens. No further information is displayed.


I have rebooted, uninstalled LO and reinstalled version 4.4.3.2, created a
new test database from scratch and the form navigation button still fails
to do anything. All the other icons in the form design toolbar work.


Help!


Thanks,


Paul Fearnley

What operating system are you using? My navigator button works. (Ubuntu 
15.04, LibreOffice 4.3.3.1.) Base has not had any changes made in it 
between 4.4.3.1 and 4.4.3.2.


Dan

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

Re: [libreoffice-users] calc and bookkeeping

[Dan Lewis]

On 12/07/2014 08:12 AM, Wiebe van der Worp wrote:

First post, not sure it is the right place, hi there!

For 2015 I would like to keep a shadow bookkeeping in Calc in order to 
check our bookkeeping program for a while.


Input: In order to keep things simple: three columns with Description, 
Amount and a LedgerCode.


Output: Sums per LedgerCode

Several solutions are thinkable of, such as conditional testing and 
lookups. However, if the list grows and contains thousands of lines it 
will influence performance.


The question: What is the most efficient approach in order to keep the 
sheet alive after adding record 2384?


Example:
LedgerCode: 1, 2, 3
---
1€ 100,00
2€ 65,00
3€ 22,00
---
DescriptionAmountLedgerCode
booking 1€ 100,001
booking 2€ 50,002
booking 3€ 20,003
booking 4€ 10,002
booking 5€ 5,002
booking 6€ 2,003


 Rather than use Calc, I recommend using Base with a simple database.
You will need one table (table1) containing four fields: Description, 
Amount, LedgerCode, and PK (primary key)
 Then you will need a query to obtain your results. the SQL for the 
query is


Select SUM("Amount"), "LedgerCode" FROM table1 GROUP BY "LedgerCode" 
ORDER BY "LedgerCode"


 I could create this and send it to you off list if you want.

Dan



--
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] Lost Pass Word

[Dan Lewis]

On 11/26/2014 01:39 AM, Isaac Cajina wrote:

I need to open some documents and I do not remember my pass word. I need
you help.
Thanks.

 There is a reason for encrypting a document: to prevent others 
from seeing it if they do not know the password. LibreOffice does an 
excellent job of this. Most likely you will not be able to open these 
documents. The only hope you have is have used a simple password that 
has a significant value in your life and you go through what these are 
trying them as passwords. Otherwise, it would take access to a super 
computer running for a few hours to break the password. (This is expensive.)


Dan

--
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 Writer, how to insert horizontal line

[Dan Lewis]

On 11/15/2014 10:57 AM, William Drago wrote:
I'm trying to insert a horizontal line into my LO document. The help 
says:


1. Click in the document where you want to insert the line.
2. Choose *Insert - Horizontal Rule*

see: https://help.libreoffice.org/Writer/Inserting_a_Horizontal_Line

Well, there's no Horizontal Rule under insert. So how is this done?

Thanks,
-Bill

  Try this:

1. Use the F11 key to open the Styles and Formation window.
2. At the bottom of this window, change "Automatic" to "All Styles."
3. Go down through the list of paragraph styles until you find 
"Horizontal line."

4. Place the cursor on the empty line where you want it to be.
5. Double click "Horizontal line" .

Dan

--
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] outline numbering

[Dan Lewis]

 Comment inline

On 11/08/2014 01:21 PM, Virgil Arrington wrote:


On 11/08/2014 11:12 AM, libreoffice-ml.mbou...@spamgourmet.com wrote:

Are all the documents (old and new) in ODF Text (.odt) format? Or are 
the older ones in Word (.doc) or OpenOffice 1.0 (.sxw) format? I'm 
wondering if the options shown depend on the format of the document.


Both are (and were originally created as) .ODT files. The old one was 
originally created on OpenOffice.org (I think 3.2) about 7 years ago.




Perhaps try opening one of the older documents and use File > Save 
As... to give it a new name, ensuring ODF Text Document is selected 
for the file type. Then close, and open the newly saved document. 
Does it now have the new options?


No change in the old file.

By looking at the contextual help, it's apparent that there are 
different options available based on the original file. .DOC files and 
newer .ODT files seem to get the new option ("numbering followed by") 
while older .ODT files have the older options ("width of numbering").


But, once a file gets saved with a given outlining method, it seems to 
to keep that method forever. The only way it seems to change it is to 
insert the file into a empty document based on a template having the 
desired method.
 There is an extension you can install for LibreOffice that will 
permit you change the template of a document. Could you create the 
template you want that has the newer outlining method and then assign 
this new template as the template for an older file. Would this change 
the outlining method in the older file. I have not tried it yet myself. 
It might work.


Dan




May be worth trying even if the original document is ODF, since it 
might be an older version of ODF. I'm not sure though whether using 
save as would save the new file in the same ODF version as the 
original or whether the new version would be converted to ODF 1.2.


If there's nothing confidential in them, are you able to post 
examples of an older and a newer document, showing each set of 
options? I'm not likely to have much time to look into them myself 
for a few weeks, but perhaps others might spot some difference.


I'll try to put something together to post to demonstrate the issues.

btw, does this list accept screen shots in emails? If so, I can just 
send an email showing the different dialog boxes.


Virgil



--
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] Java LO and OSX

[Dan Lewis]

On 11/06/2014 04:33 PM, Virgil Arrington wrote:


On 11/6/2014 3:14 PM, Marc Grober wrote:

Sorry I changed the subject line there... I have never been able to get
the list to copy me with my posts and I just forgot that I had the post
in Sent mail.


I am having the same problem. I never see my own posts to the list. 
This is new behavior for my system.


I recently had a problem where my old email address stopped receiving 
emails from the list entirely. I tried unsubscribing and resubscribing 
to no avail.


Then, I just signed up with a new email address, but now the list 
never sends me a copy of my own emails. The only way I know I've 
posted is if somebody responds.


Virgil
 If you use IMAP for gmail, you will have a folder named [Gmail] 
which contains a subfolder All Mail. There you would see both the emails 
you sent and those you have received.


Dan

--
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 Writer - Bold activates by itself

[Dan Lewis]

On 11/04/2014 01:33 PM, jerryvb wrote:

"However, LO also remembers the style of the last entry on the line, and
applies it to the
next paragraph as well. To see this in action, perform jerryb's procedure,
but type some text in normal style after the bold text on the first line.
You will see the normal style applied to the next paragraph. "


Indeed, you are right. If, after turning bold off at the end of the first
line. I press Enter once, then press Space once, then press Enter once more,
then press Up one time, the Bold does NOT come on.

I still think this is a bug and not normal. By manually turning Bold off at
the end of the first line, it should stay off until it is manually turned
back on. I tend to think that it should never come on automatically, unless,
like someone said, it is embedded into a style.
 I do not get the same results, but maybe I am doing things 
differently in 4.2.7 and 4.3.3:

Ctrl+B to made the line bold.
Type some words.
Ctrl+B after typing the last character.
Enter once.
Type some words.

 This last line is NOT bold. Maybe you should not be typing  
twice.


Dan

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

Re: [libreoffice-users] Calc SUM Function

[Dan Lewis]

On 10/27/2014 07:55 AM, Adrenolin wrote:

So I can select an area of a column "=SUM(B2:B50)" and have it add and
produce a total in say B51. Thats fine but fairly simplistic and I need
more. Completely new to spreadsheets and how to do this stuff.

1. Can I add ALL of Column B, Minus B1 and have the total of the column
display in B1?
 You should use the first row to label your columns and and put 
your total for Cost Each in B2

 Use this formula in your first paragraph:
a) Click B2 to select it.
b) Enter this into B2:  =SUM(B3:1048576) [1048576 is the last row in 
a Calc sheet]


2. Column B is a Cost/Each, C is Quantity, D is Shipping & E is Total Cost.
Is there a way to multiply B & C then add D and display in E for each row?
Yes, I understand C would have to be at least 1 or greater and not empty. :)

 This is basic algebra plus one additional step:
a) Click E3 to select it.
b) Enter this into E3: =B3*C3+D3  using the  key [This gives the 
total cost for row 3]
c) Drag the "handle" down the column to copy this formula into each row 
of the E column.


 When you enter the formula into cell E3, a black box appears 
around E3 with a small black at the bottom right corner which we call a 
"handle". Click on it and drag it down the column. One note: it is going 
to take some time for Calc to copy the formula into the 1048573 rows.
 Someone else may know of a way to copy the formula into all the 
rows more quickly.
 This could also be done with a database. The data would be entered 
into a table. Then in a query you could have four columns: Cost/Each, 
Quantity, Shipping and Total Cost. The last column would apply the 
formula you need to each row of your table.


Dan


Any detailed explanation, tip, link to a how-to would be so appreciated!
I've only found a few examples and pretty basic.

Thanks



--
View this message in context: 
http://nabble.documentfoundation.org/Calc-SUM-Function-tp4127023.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] Tab defaults change when pasting into Writer from some other applications

[Dan Lewis]

On 10/26/2014 02:13 PM, Brian Barker wrote:

At 13:51 26/10/2014 -0400, Tim Deaton wrote:

I'm currently running LO v4.2.6.3 on Windows 7, 64-bit, SP1.

I use Writer primarily to create notes for Bible study lessons. In 
that process, I often copy text into Writer from other programs (most 
likely e-Sword and TheWord (two free Bible software programs which, I 
think, both use the SQLite open-source database program).  The 
template I use for this has the default tab-stop setting 
(Tools|Options|LO Writer|General) set to 0.25 inch.


My problem is that when copying text passages from those (and perhaps 
other) programs into LO, that default tab-stop gets reset to 0.5 
inch, so that I have to go into the Options to change it back after 
each copy/paste.  I don't know when exactly this behavior started, 
but I do know this resetting did not happen when I was using OOo and 
then LO 3.x.  It either started with LO 4.0 or 4.1.


I'm not sure why you would want to use default tab stops at all. They 
are so close that you often need to add multiple consecutive tab 
characters, and this is surely a recipe for your documents being 
fragile and not robust to changes of font, paper size, printer, 
platform, and so on? Tab stops are a property of paragraph styles. Why 
not set up a paragraph style with just the tab stops you actually need 
and then apply this style to the text (very easily done) immediately 
after pasting?


I trust this helps.

Brian Barker


 What about using paste special  the "Unformated text" option after 
creating the paragraph style you want?


Dan

--
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] Final Release: MySQL/MariaDB Native Connector for Linux

[Dan Lewis]

   Today, I have changed the status of this connector from Release 
Candidate #1 to Final Release.
   This should be used with LibreOffice 4.2.x and 4.3.x that are 
downloaded from the LibreOffice website. LibreOffice that is downloaded 
from a Linux repository can use the MySQL native connector that its 
repository also contains. My version may also work with their version of 
LibreOffice.


Dan

--
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] Writer 4.6.2.3 Failure With Word Document

[Dan Lewis]

On 10/18/2014 08:41 PM, Stephen Morris wrote:

On 10/15/2014 10:09 AM, Tom Davies wrote:

Hi :)
The macros are very specific to that 1 specific version of MS 
Office.  To

use the file in MSO 2007 or 2013 or 365 then you might need to have the
macro rewritten.

If you had them rewritten for LibreOffice then you probably wouldn't 
ever
need to rewrite them again, except to add improvements or the fairly 
rare

times that a relevant bit of functionality got completely rewritten in a
different way.

Is there any chance of posting the macro's code into an email for this
public mailing list to have a look at?  People sometimes have 
suggestions

about what might need to be changed or even some coding suggestions
sometimes!


When Writer crashes it used to often be due to Java.  Is it possible to
turn java off for a bit?
Tools - Options - Advanced/Java
and then untick the box that enables java in LibreOffice.  If the 
program

grumbles about it then you can always switch it back on the same way.

Another possibility is the memory settings
Tools - Options - Memory
and just ramp everything up quite a lot.  Maybe not the number of 
steps you

can take back but the amount of ram per object and the total ram allowed
for the whole document seem like good ones to increase!

Regards from
Tom :)
Thanks for the reply Tom, reading your response has prompted me that 
there may be some pertinent information I had forgotten to include. 
Because the document is a work document in needed to leave it in word 
format, so I was trying to save it as a .docm document so that it 
could be used back at work. As Writer appeared not to be able to 
handle the document I opened the document in Word 2013 which handled 
the document quite happily.


Another issue I had was the document had track changes activated 
without any changes in the document having been committed. This 
process seems to function differently in each of Word 2002, Word 2010 
and Word 2013 and Writer didn't seem to be able to handle this 
functionality at all. Edit -> Changes -> Show is selected by default 
(I'm assuming this is Writer's equivalent of Track Changes, if it 
isn't then I can't find any support for that) but Writer did not show 
any of the changes that had been done, it displayed the document as if 
all the changes had been committed. For example, all the text that had 
been deleted, instead of showing the text with a line through them as 
Word does, Writer did not display the text at all.
I have just done a test now with Writer using its native format, with 
Edit -> Changes -> Show / Record options selected and it seems to be 
recording changes by user albeit that it doesn't know who the user is 
(probably because I haven't specified that information in its 
configuration), but even though it is doing this recording if I delete 
any text I have typed in, it just removes the text rather than showing 
it as deleted.


regards,
Steve





On 14 October 2014 23:44, Stephen Morris  
wrote:



Hi,
 I have a sensitive Architectural Design document created in 
Word 2010
that contains macros, hence it is a .docm file. I have opened this 
document
in Writer 4.6.2.3 and whenever Writer autosaves or I manually save 
the save
process crashes Writer. Is there anything I can look at to try to 
determine
why? Because of the nature of the document it is not something that 
I can

release.

regards,
Steve 
  Writer "knows" who is doing the editing when it is both showing 
and recording any changes being made. This information is gotten from 
Tools > Options > LibreOffice > User Data. (This is the reason why you 
should have some data entered in the User Data page.) So, when the 
person who wrote the original text deletes something, Writer deletes it. 
However, if the document is edited on a different computer, it will show 
the deletion because the User Data is different. Furthermore, the 
editing is done using a different font color. So, if three people are 
editing the same document that has both show and record changes, it will 
contain three font colors.


Dan

--
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: Re: MySQL/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)

[Dan Lewis]

On 10/17/2014 03:00 AM, Stefan Gruber wrote:

Dan Lewis schrieb:

Do you use the opensuse repositories for LibreOffice

Yes, opensuse-factory with current LO 4.3.2.2.

Stefan
 Opensuse makes changes in LibreOffice before putting it in their 
repositories. That could be the problem. Then again, you should have a 
mysql connector in the repositories that work with the Opensuse's 
version of LO. (My OS is Ubuntu, and my repositories list two mysql 
connectors for their version of LO with one of them being based upon 
python.)


Dan

--
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/MariaDB Native Linux connector for LibreOffice 4.2 and 4.3 (32 and 64 bit)

[Dan Lewis]

On 10/16/2014 04:21 PM, Stefan Gruber wrote:

Hi,

Tom Davies schrieb am Mittwoch, 15. Oktober 2014 17:50:

Has anyone been able to test this out yet?

Is it possible to test-drive these connectors without breaking an existing
database?  Errr, i'm not going to be able to test them myself so i was
just mildly curious.

I just installed Dans connector on my machine with a fresh-installed MariaDB
and actual LibreOffice 4.3.
I can connect to the database and add tables as expected.

But the table show only zeros in all columns, that are not text/string-type.
I can type in new values, they get into the real table but stay displayed as
zero.
So no further test possible for now.
I'm afraid the distributed standard connector works the same wrong way, so
this might be an issue of LibreOffice 4.3 itself or opensuse.

It worked properly with my production machines with LO 4.1.

Stefan
 Do you use the opensuse repositories for LibreOffice or do you 
download it from the LibreOffice website? This might make a difference.


Dan

--
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] parallel text in side by side pages

[Dan Lewis]

On 10/15/2014 08:26 AM, Ginterak wrote:

Dan,
If I place 1000 words in the left page, the words are still going to overflow 
onto the right page - I am not sure what your idea is actually accomplishing.
 In my reply, I keyed on having the original on the left page and 
the translation on the right page. By having these appear side by side, 
one can see both at the same time and compare them if desired.
 What seems to be obvious to me is that the number of words 
required for a given thought in different languages can be different. So 
what would be a full page for one language may be less than or more than 
a page. So there is no guarantee that the the same thoughts will be 
contained in side by side pages. So, what purpose does having original 
and translation being side by side? It is quite possible that in a 
rather long article, some of the side by side pages may not have any 
thoughts in common.
 My thoughts came from how a Bible program handles this situation. 
For example, I have German and English translations of the Bible side by 
side. There the same verses are shown for them. Sometimes there are 
extra spaces on the German side, and sometimes there are extra on the 
English side. I also have a German-English New Testament from the 
1800's. It also has the same print layout.
 A very important question is: What is the purpose of having the 
original and the translation side by side? This should determine the layout.


Dan

On Oct 14, 2014, at 9:22 AM, Dan Lewis  wrote:

On 10/14/2014 12:15 PM, Marc Grober wrote:
Is there is technical solution to running parallel text in side by side
pages (the best example would be a text with a translation where you
have the original on one page and the translation on the facing page.
This is done easily enough in columns, but there must be some way to
pass two threads of raw text to a section in which one thread is passed
only to odd pages and the other only to even pages,  or are we stuck
with alternating the text manually and inserting a gazillion page breaks?

 I think that page styles will do it. Open an untitled document in Writer. Use the F4 key to open the Styles and Formating 
Window. Click the "Page Styles" icon at the top of this window. Double click "First Page" from the lists of 
page styles to apply this style to the page. Then right click "First Page" and select Modify from the context menu. 
Change the "Next Style" property to "Left Page". Click OK.
 This should do it. Enter the original text on the left pages and the 
translations on the right pages.
 The reason this works is because of styles. They insure that each left page is 
followed by a right page which is followed by a left page... Writer is designed to begin 
with the first page on the right, so you need the "First Page" to fulfill this 
need. From then on the left and right pages will follow correctly. (No page breaks are 
needed.)
 In the bottom right corner of the Writer window are three icons of pages. 
The one of the right is the one you should click if it is not highlighted. This 
places two pages in the window beginning with a right page first followed by a 
left right page combination.

Dan

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

[Dan Lewis]

On 10/14/2014 12:58 PM, Jay Ridgley wrote:

Folks,

My wife has her recipes in LO Writer. My question is is it possible to 
sort on the 1st line of a page? That way she can keep them alphabetically
 This can also be done with a form in Base. The simple way is to 
have two fields in a table: the recipe name, and a text box to contain 
all of the writing. Then create a form from this table. The field for 
the recipe names can be sorted alphabetically. This sorting is done 
automatically any time the form is opened, refreshed, or new recipe added.


Dan

--
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] parallel text in side by side pages

[Dan Lewis]

On 10/14/2014 12:15 PM, Marc Grober wrote:

Is there is technical solution to running parallel text in side by side
pages (the best example would be a text with a translation where you
have the original on one page and the translation on the facing page.
This is done easily enough in columns, but there must be some way to
pass two threads of raw text to a section in which one thread is passed
only to odd pages and the other only to even pages,  or are we stuck
with alternating the text manually and inserting a gazillion page breaks?

 I think that page styles will do it. Open an untitled document in 
Writer. Use the F4 key to open the Styles and Formating Window. Click 
the "Page Styles" icon at the top of this window. Double click "First 
Page" from the lists of page styles to apply this style to the page. 
Then right click "First Page" and select Modify from the context menu. 
Change the "Next Style" property to "Left Page". Click OK.
 This should do it. Enter the original text on the left pages and 
the translations on the right pages.
 The reason this works is because of styles. They insure that each 
left page is followed by a right page which is followed by a left 
page... Writer is designed to begin with the first page on the right, so 
you need the "First Page" to fulfill this need. From then on the left 
and right pages will follow correctly. (No page breaks are needed.)
 In the bottom right corner of the Writer window are three icons of 
pages. The one of the right is the one you should click if it is not 
highlighted. This places two pages in the window beginning with a right 
page first followed by a left right page combination.


Dan

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