Re: [libreoffice-users] Converting jpg or png to high quality in Libre

[Luuk]

On 2-12-2021 02:37, Tom wrote:

On 12/1/21 5:21 PM, charles meyer wrote:

Hi my esteemed listmates,

I need to take a graphic I download (with permission) off a Website and
make it 1920x1080, or larger by the same ratio so its quality will be
higher.

It would be even better if I could convert it into 3840x2160.

Has anyone been able to accomplish this in Libre Writer? Libre Draw? 
Or a

FREE Windows tool?

I understand Photoshop can do that but I don't have Photoshop so I 
need to

accomplish this with something simpler like MS Paint.

Has anyone achieved these improved graphic results with MS Paint?

If so, could you pls share the steps?

I'm guessing it can  be done in GIMP but GIMP and I are not in 
sympatico.


Thank you kindly.


GIMP or ImageMagick are what I would use for this.  With ImageMagick, 
you can use the "convert" command to scale the image.  Just keep in 
mind, when you upscale an image, its quality will suffer since image 
data is being "created".   If you're not worried about that, either of 
those tools would work.  It's been a VERY long time since I've done 
this BUT there was a free Windows utility you could install that would 
add image scaling to the context menu of an image file.  So, you could 
right-click the file and choose the "scale" (whatever it's called) 
menu option to scale it up or down.


I just don't know if that utility exists still or if it's compatible 
with Windows 10 or 11.


This resize is now part of the Power Toys:

PowerToys Image Resizer utility for Windows | Microsoft Docs 



( https://docs.microsoft.com/en-us/windows/powertoys/image-resizer )




Peace...

"The Other" Tom




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

Re: [libreoffice-users] Sorting in Writer

[Luuk]

Unable to reproduce in LO 7.1.1

In which version of LO are you doing this?

On 23-4-2021 23:14, Pat Brown wrote:

Hi,
 I have a number of rows of text that I want to sort by row. My problem
is that some of the rows are also hyperlinks and when I run the sort it
puts all the hyperlink rows sorted and then the non-hyperlink rows. Is
there any way to get the sort to ignore the hyperlink code?

Thanks,

Paddy



--
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 crash on windows 10 related to a lock file

[Luuk]

On 26-3-2021 13:56, xplaster wrote:

Hi, I'm on windows 10 and windows crash when I click on libreoffice files,
the crash is related to a corrupted lock file that I found in c:\..something
in user folder..\roaming\libreoffice\4 and deleted it, it worked but it
happened again with another file, is there an ultimate solution to this
bug??

manythanks, ciao, Pier


Which file did you delete ?

(complete name, and not '... something in user folder...' ) you can 
replace 'Pier' with '' ) . 


This link tells you what to do if you have a corrupt user-profile:

LibreOffice user profile - The Document Foundation Wiki


( https://wiki.documentfoundation.org/UserProfile#Resolving_corruption )

Please try to get a new user-profile, and see if you can reproduce the 
problem






--
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] Restore Default AutoCorrect Settings

[Luuk]

On 19-3-2021 19:55, Dave Barton wrote:

On 19/03/2021 17:36, Luuk wrote:

On 19-3-2021 18:03, Dave Barton wrote:

I make a full backup of my main Windows 10 production machine every week
and store those backups for at least 3 weeks. For many years I have
found this to be a good insurance policy against most forms of
corruption. Unfortunately, LO has succeeded in defeating the benefits of
this policy.

For the past 3 weeks I have been working, mostly with Writer, in
blissful ignorance of the fact that my profile has been partially
corrupted. I say partially, because only the default "AutoCorrect >
Replace" options have disappeared, while the rest of my extensive
profile remains in perfect working order. Obviously, this condition has
existed for a least 3 weeks, because restoring my profile from backups
does not resolve the issue.

I really would like to avoid the pain of fully rebuilding my profile
from scratch, so if anyone can offer any pointers or tips about
restoring just I would be
extremely grateful.

Regards
Dave


You profile is stored in:

C:\Users\\AppData\Roaming\LibreOffice\4

you can rename this directory, and restart LO, then this directory will
be re-created (with the default).

Now you only have to find out where the autocorrect settins are in this
profile (if there are any...)

On my system the autocorrect things seem to be stored in:

"C:\Users\Luuk\AppData\Roaming\LibreOffice\4\user\autocorr\acor_nl-NL.dat"

At least, that was my conclusion when opening that file with 7-zip, and
seeing the contents of 'DocumentList.xml' which did contains a manually
added entry in the auto correct list.

Hi Luuk,

Thanks for taking the time to reply. I fully understand the structure of
the user profile and I see acor_en_GB.dat and acor_en_US.dat in the
autocorr subdirectory.

Fixes I have tried:

* Delete one or both those dat files, with a full system restart each time.

* Delete both the dat files and replace them with copies from a new
install on an identical machine.

All failed to restore the default "AutoCorrect > Replace" options.

There has to be some other configuration setting in the profile that
influences this option.

Getting late here, so tomorrow I will spend a "less than enjoyable" day
reconstructing my profile and writing a program to trigger a backup of
my good profile _*BEFORE*_ LO ever starts and gets the opportunity to
attack and corrupt my profile again.

Regards
Dave



Hi,

Maybe too late, but the path under Tools/Options/"LibrOffice/Paths"

has an "AutoCorrect" setting, which should be set to the UsersPath:

"C:\Users\\AppData\Roaming\LibreOffice\4\user\autocorr"

The internalpath is set to:

"C:\Program Files\LibreOffice\program\..\share\autocorr"  (or: "C:\Program 
Files\LibreOffice\share\autocorr")


In this latest directory i do see all default autocorrect files for different 
languages.


But unfortunately there seems to be another setting missing?


--
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] Restore Default AutoCorrect Settings

[Luuk]

On 19-3-2021 18:03, Dave Barton wrote:

I make a full backup of my main Windows 10 production machine every week
and store those backups for at least 3 weeks. For many years I have
found this to be a good insurance policy against most forms of
corruption. Unfortunately, LO has succeeded in defeating the benefits of
this policy.

For the past 3 weeks I have been working, mostly with Writer, in
blissful ignorance of the fact that my profile has been partially
corrupted. I say partially, because only the default "AutoCorrect >
Replace" options have disappeared, while the rest of my extensive
profile remains in perfect working order. Obviously, this condition has
existed for a least 3 weeks, because restoring my profile from backups
does not resolve the issue.

I really would like to avoid the pain of fully rebuilding my profile
from scratch, so if anyone can offer any pointers or tips about
restoring just the default "AutoCorrect > Replace" options I would be
extremely grateful.

Regards
Dave



You profile is stored in:

C:\Users\\AppData\Roaming\LibreOffice\4


you can rename this directory, and restart LO, then this directory will be 
re-created (with the default).


Now you only have to find out where the autocorrect settins are in this 
profile (if there are any...)


On my system the autocorrect things seem to be stored in:

"C:\Users\Luuk\AppData\Roaming\LibreOffice\4\user\autocorr\acor_nl-NL.dat"

At least, that was my conclusion when opening that file with 7-zip, and seeing 
the contents of 'DocumentList.xml' which did contains a manually added entry 
in the auto correct list.




--
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] Write Closed but Windows 10 won't provide safe to remove flash drive

[Luuk]

On 6-3-2021 22:36, charles meyer wrote:

This is both a Writer question and a Windows 10 issue.

I close Libre Writer and all the other  programs I had  opened but when I
click the flash drive icon in the "system tray" (lower right) to receive
the Safely remove the flash drive it keeps displaying  that I need to close
programs.

I've check each program along the toolbar (on the bottom) and none are open
but it still won't give the OK to pull the flash drive out.

I've Googled this and reads both that you can just pull the flash drive out
as its plug and play and others say the flash drive will stop working oif
you keep pulling it out with the "Safe to Remove" message.

Your thoughts and suggestions are greatly appreciated.



Using openfiles.exe (from Microsoft) you can see which files are open.

(link: 
https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/openfiles 
)



first you have to enable it using: openfiles /Local ON    (and do a reboot)

After that you can query with files are open using : openfiles /Query .

More details on how to use this are given on the link given above.




--
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: File Explorer – Day-week-month search for Libre files

[Luuk]

 

Clicking just right of 'Date modified' still shows a calendar  (I admit
never seen that calendar before)





-
Windows10 / LibreOffice  (latest?)
--
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] File Explorer – Day-week-month search for Libre files

[Luuk]

On 23-2-2021 23:14, charles meyer wrote:

Hi my esteemed list mates,



I’d like to be able to search in Windows 10 File Explorer for Libre Writer
and Calc files by day – wee – month.



On my work PC it was set up so when I open File Explorer there is a Date
modified icon on the taskbar with a graphic of  a calendar.



When you click on it, a drop-down menu appears displaying:

Today

Yesterday

This Week

This Month

Last Month

This Year

Last year



I’ve Googled this and none of the results explain how one creates this Date
modified icon on the taskbar.



Does anyone recall how they created that in their File Explorer?



Thank you!


Are you referring to the functionality described here:

Windows 10 tip: Search for any file by date | ZDNet 




I just notice that searching in File  Explorer with something like 
"datemodified:this week" is not working anymore 


Did Microsoft change this 'on purpose' or ...



--
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] Reopening document at last saved position

[Luuk]

Also, repositioning seems to not work when you have no information under 'User 
Data'. (That is leave all fields from 'Company' until 'Fax/email' empty)


When reopening a document, it will start at the top of that document.

LO 7.0.0.3 (x64)  Windows 10


On 15-10-2020 20:48, DaveB wrote:

Hi Steve,

Thanks for taking the time to check. It seems there might have been a
glitch on the Windows machine yesterday, because I couldn't replicate
the condition on a Linux machine, but after booting up the Windows
machine today the load at last saved position works as expected.

Best Regards
Dave

On 15/10/2020 19:17, Steve Edmonds wrote:

Hi Dave, on my 6.4.6.2 it is working as expected.
I have "Use data for document properties" checked. Not sure if it needs
to be.
steve

On 14/10/2020 02:02, DaveB wrote:

Clean installs of 6.4.6.2(x64) and 7.0.2.2(x64) on Win 10Pro(2004). User
Data in Options has been filled in both cases.

For several versions it has been the case that if User Data has been
filled, Writer documents would reopen at the same point within the
document when it was last saved. Has this changed and if so is there
alternative setting to have Writer documents reopen at the same position
as when last saved?

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] Create a relative hyperlink to file?

[Luuk]

On 19-9-2020 16:33, Dave Barton wrote:

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.

TIA

Dave

PS. Apologies if this is a duplicated post.



you need 3 '/', see: https://en.wikipedia.org/wiki/File_URI_scheme 



I should be: file:///abc.xyz
not: file://abc.xyz


--
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] Odd libreoffice directory under /usr/lib

[Luuk]

On 5-9-2020 23:07, MR ZenWiz wrote:

While looking into the issue I reported about LO 7 not starting
properly (which is SOLVED, thank you), I noticed another anomaly.

While chasing after the JRE load error that the --nologo option seems
to provoke, I discovered the following strange situation:

$ loc javaldx
/opt/libreoffice6.4/program/javaldx
/opt/libreoffice7.0/program/javaldx
/usr/lib/libreoffice/program/javaldx

("loc" is an alias I use to run "locate" with certain exclusions and
piped through more - not a problem.)


It is not an error, it is just a warning that it cannot find java.

to solve it use:

sudo apt install openjdk-8-jre

The 'documentation' is no really helpful ( a bit old):

https://wiki.documentfoundation.org/Faq/General/InstallJava




--
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] LO 7.0 fails to start with --nologo

[Luuk]

On 3-9-2020 18:48, MR ZenWiz wrote:

I saw this error when I tried to start LO 7.0 Calc from the command line:

$ /usr/bin/libreoffice --calc --nologo
/usr/bin/libreoffice: 191: exec: /usr/bin/oosplash: not found

I located oosplash and symlinked it to /usr/bin and got this:

$ sudo ln -s /opt/libreoffice7.0/program/oosplash /usr/bin/oosplash
$ /usr/bin/libreoffice --calc --nologo
Warning: failed to launch javaldx - java may not function correctly
ERROR 4 forking process


On Ubuntu18 i am getting:

$ /usr/local/bin/libreoffice7.0 --calc --nologo
javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx

And, after that calc starts normally.


Your installation seems to be defective? or it is having remains of 
another/older office product.



--
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] LO 7.0 fails to start with --nologo

[Luuk]

On 3-9-2020 18:48, MR ZenWiz wrote:

I saw this error when I tried to start LO 7.0 Calc from the command line:

$ /usr/bin/libreoffice --calc --nologo
/usr/bin/libreoffice: 191: exec: /usr/bin/oosplash: not found

I located oosplash and symlinked it to /usr/bin and got this:


I think oosplash is not part of LibreOffice 7.0

(It is not present under my Windows installation, and not on my Ubuntu18 system)

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

[Luuk]

On 28-8-2020 15:40, Dan Lewis wrote:


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.


OnWindows:

C:\Users\\AppData\Roaming\LibreOffice\4




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] Java aches are back with LO7

[Luuk]

On 8-8-2020 04:04, Marc Grober wrote:

Have had a working and regularly upgraded LO6.x for quite a while now
using Oracle Java 12 and now 14.0.1 (MacOS Catalina)

Today I tried to move to LO7.0.0 and  BOINNNGG   I have received
the dreaded message...

This says that my installed java is DEFECTIVE and I should install a
working version.

Of course, my java installation is working JUST FINE and has been
functional with OpenOffice and Zotero.

So, there is obviously something that was tweaked in LO7 that does not
like Oracle java 14.0.1.

What might that be, and where might one find the issue documented?


The docs do not say anything about LO7 ,

and also do not say anything about a version after JAVA 8

https://wiki.documentfoundation.org/Faq/General/InstallJava#Using_macOS


 Java version support

 * For LibreOffice prior to v.6.3, minimal supported Java version is 5
   (clarification needed about older support history).
 * For LibreOffice v.6.3, minimal supported Java version is 6
 * For LibreOffice v.6.4, minimal supported Java version is 8




--
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 a bookmark to TOC

[Luuk]

On 2-8-2020 18:46, Office User wrote:

On 02/08/2020 15:34, Luuk wrote:

On 2-8-2020 13:06, User wrote:

Thanks Michael. I am sure there is a use for your method, but it is much
too complicated for my small requirement.

Unfortunately, I wasn't able to view your document, because the Google
dictatorship would not allow me to see it without creating one of their
malware accounts.

Regards
Dave


Malware is something COMPLETELY different ...

If you create such an account (i do not say you have to ), you still
have the possibility to only use it under 'special' circumstances.

Malware is something which gets used without permission(s)

Luuk,

Under no circumstances whatsoever will you ever lecture me about
whatever terminology I choose to use.

You obviously lack the intellect to comprehend what was meant by my
reference to Google.

Your commentary is both unnecessary, unwelcome.

I ask that you never again respond to anything I post to this list and
any attempt at private contact will be ignored.

Please let this be an end to this thread.

Dave

Thanks for your (positive) feedback on this matter. 

--
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 a bookmark to TOC

[Luuk]

On 2-8-2020 13:06, User wrote:

Thanks Michael. I am sure there is a use for your method, but it is much
too complicated for my small requirement.

Unfortunately, I wasn't able to view your document, because the Google
dictatorship would not allow me to see it without creating one of their
malware accounts.

Regards
Dave


Malware is something COMPLETELY different ...

If you create such an account (i do not say you have to ), you still have the 
possibility to only use it under 'special' circumstances.


Malware is something which gets used without permission(s).


--
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 a bookmark to TOC

[Luuk]

On 1-8-2020 16:18, Office User wrote:

On 01/08/2020 14:39, Luuk wrote:

On 1-8-2020 13:44, Office User wrote:

First, I do understand how to create a
    TOC based on heading levels, but what I am trying to work out is
    how to add some kind of flag/marker (I am using the term bookmark)
    to a paragraph in order to have it appear as the first entry in a
    TOC.To illustrate with a hypothetical example: An author wishes
to add
    a 1 paragraph dedication on a page at the start of a book and have
    the word "Dedication" appear as the first entry in the TOC, but
    does not want the word to appear on the dedication page in the
    form of a heading.It would be much appreciated if someone could
point me to a source
    of information about this, because my own searches have uncovered
    nothing.TIADave

Somtehing like this document:

https://gofile.io/d/KzdBTw

Thank you Luuk. Yes it does create the TOC entry I wanted, but an
alternative to white text on a white background would have been better.
There may be times when the document would be printed and the print
medium might not always be white. This would be one instance where
(otherwise useless) transparent text would be helpful.

Regards
Dave


OK, maybe it is inspiring someone to come with a better solution 




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

[Luuk]

On 28-7-2020 15:41, fudmier wrote:


How do you stop the updates.  ?



to Stop updates: Tools/Options/LibeOffice/Online Update   uncheck the boxes...




Tell me how to find the version of LO that is running. Maybe its 4 from the 
listing,

I

.
locate libreoffice   dir listing.

3) what version of LibreOffice?


To find the version of Libreoffice, just start Calc, and from the Menu choose 
Help/About 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] Re: question

[Luuk]

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)




--
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: version control of sorts: it is gone?

[Luuk]

On 22-7-2020 23:34, Michael Tiernan wrote:

The thing I've noticed is that even of the checkbox for "always save new
version" is set it doesn't do, as I supposed, save a new version when you
hit "Save", you actually have to go into the versions box and force it.

-- << MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan Non 
Impediti Ratione Cogatationis Women and cats will do as they please, and men 
and dogs should relax and get used to the idea. -Robert A. Heinlein Sorry 
for the unedited top post. Client forces it.


If you are really sorry for (unedited?) top posting, then do NOT bullshit us 
with 'Client forces it', because no one forces you to post!



The checkbox for "always save new version" is an inclomplete quote, it says:
"Always save new version on closing"

This means that a new version is only created when you close the document, 
which is another action than save your document.






--
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] Linux users might find themselves paying money to use LibreOffice one day

[Luuk]

On 20-7-2020 04:58, Mark LaPierre wrote:



You should see what Excel does to anything that looks like it could be a 
date.  We have a field that contains text like, "01-21-34", that Excel turns 
into Jan 21 2034 or some other silly thing like that.  There's no way to 
stop that from happening no matter how you format the column.


We had to write a C# program to handle the data because Excel couldn't 
figure out what to do with it.




Your lack of understanding on how to import this data to Excel, does not make 
Excel a bad product.




--
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] [Calc] Good way to turn hours+minutes into minutes?

[Luuk]

On 17-7-2020 14:37, Gilles wrote:

Hello,

I have a spreadsheet where time is formatted as HHhMM.

In the next column, I'd like to show this in minutes. What would be a good
way to achieve this?

Thank you.

https://i.postimg.cc/qRKCK14F/image.png



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



if A2 = "01h14"

Then the formula: =TIMEVALUE(REPLACE(A2;3;1;":"))*24*60

Will return: 74


Basically first replace 'h' for an ':'

timevalue returns the minutes since midnight.


--
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: Default font in draw

[Luuk]

The font is defined in the style being used. 

Use 'view/Styles' (F11) to see and/or change the style.





-
Windows10 / LibreOffice  (latest?)
--
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] date strings to date

[Luuk]

On 2-7-2020 00:53, James wrote:


I have a column of date strings like "Thu, Aug 1, 2020".
I want to convert them to a real date column.



Suppose the date is in B2, then:

=DATE(RIGHT(TRIM(B2);4);(FIND(TRIM(MID(B2;FIND(",";B2)+1;4));"JanFebMarAprMayJunJulAugSep")-1)/3+1;1)

You only need to:

1) Extend the monthnames ("JanFeb...") for the rest of the year

2) Fill in a formula for the day in the month (currently set to 1





--
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] Calling a libreoffice basic function from a python script

[Luuk]

This page shows the answer to your question:

https://stackoverflow.com/questions/2781689/how-to-return-a-result-from-a-vba-function 



On 17-5-2020 03:26, Jim wrote:
I started experimenting with calling a basic function from a python 
script. I was surprised that without to much trouble I got it to work 
to a certain extent.


I am working on linux Mint.

I started with a basic Sub I found. In it's original form it had 3 rgb 
values hard coded and it popped up a message box that displayed the 
color value from the rgb input. I rewrote it as a Function that took 
the rgb values as parameters.


Here is the basic:

Function ColorExampleFunc(r as long, g as long, b as long)
Dim lVar As Long
lVar = rgb(207,231,245)
msgbox "The color " & lVar & " consists of:" & Chr(13) &_
"red= " & red(lVar) & Chr(13)&_
"green= " & green(lVar) & Chr(13)&_
"blue= " & blue(lVar) & Chr(13) , 64,"colors"

end function

Here is the python:

#test_basic.py
import os

result = os.system('soffice 
"macro:///Standard.Module1.ColorExampleFunc(207,231,245)"')


This works as it will pop up the message box with the color value 
displayed. What I need to do is capture that color value (which is 
usually an eight digit number) in variable in the python script.


I printed result and it was equal to 0.

It's been a long time since I did anything in basic. I imagine I would 
have to get rid of the msgbox code and set the rgb values equal to a 
variable and then return them, but I'm not sure how to do it.


Does anyone know how to get the color value in the python script?

Thanks, Jim




--
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] Range names

[Luuk]

On 4-5-2020 09:43, Brian Barker wrote:

At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote:
Let's say I have a spreadsheet (I actually have several…) with a lot 
of cells and ranges already filled with data and formulas. One day I 
discover the range naming feature, so I name a few cell ranges. 
Shouldn't there be some easy way to replace every occurrence of those 
cell ranges in all my formulas?


I don't think any automatic system could do exactly what you probably 
want.


Say your range is A1:B5 on Sheet1 and suppose you name this as Name. 
You may think that "Name" is now synonymous with "A1:B5", but no: 
instead it is shorthand for "$Sheet1.$A$1:$B$5". There are thirty-two 
variations on "Sheet1.A1:B5" you may have in your spreadsheet, each 
including a different combination of those dollar signs. As you will 
know, each version behaves differently if you fill ranges from a cell 
with a formula containing it, or if you copy and paste from such a 
cell. So the differences are important. By including "Name" in a 
formula, you are choosing to imply the anchored or absolute version of 
the range.


In order to preserve the precise meaning and behaviour of your 
existing formulae, any automatic system should replace a spelled-out 
reference only when it includes all five dollar signs. But in practice 
one may rarely add all those dollar signs in formulae, instead using 
only as many are necessary for the filling or copying that one is 
expecting to need. I suspect you wouldn't be impressed if an automatic 
system failed to replace "A1:B5" or "A$1:B$5" with your newly defined 
"Name". But if it did, it would corrupt some spreadsheets that you or 
others might compose.


And when I say easy, I mean easier than doing search and replace on 
each one of them one by one. I can't find such a feature. Is there an 
extension for it?


When you do this, you would need to determine in each case whether the 
replacement by the range name would be appropriate. And an automatic 
system could not do that for you.



I'm going to write a macro for it, ...


Which of the thirty-two variations will it replace?


If every combination has a unique (range-)name,  who cares?

A1:B5 ==> range1

A1:B$5 ==> range2

A1$:B5 => someOtherRange





I trust this helps.

Brian Barker




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

Re: [libreoffice-users] Can Libreoffice Compress a PNG file?

[Luuk]

On 24-4-2020 15:11, M Henri Day wrote:
Den fre 24 apr. 2020 kl 08:22 skrev Luuk <mailto:luu...@gmail.com>>:



On 23-4-2020 06:06, Musical Neptunian wrote:
> I  make Twitch emotes in GIMP. They cannot be more than 25 Mb or
Twitch
> rejects them. I found a tutorial somewhere that said that
Libreoffice has a
> png compression tool. But when I put my png into LibreOffice I
got a whole
> load of symbol junk. So instead I used a free online tool that
reduced my
> png from 30 Kb to 7 Kb with no quality change. But could I have used
> anything in Libreoffice to do this?


I would never use LibreOffice for compressing images.

use any tool found on the internet, like:


https://stackoverflow.com/questions/19153122/image-compression-tools-via-command-line


Luuk, perhaps you could explain just why you would never use a 
LibreOffice too for compressing images. Doesn't the one suggested by 
Philip perform satisfactorily ?...


Henri


Just because LibreOffice is not an image-editor. It's about creating 
document, or spreadsheets.


Ik will also no use my bicycle to transport loads of goods, that's what 
trucks are for 




--
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] Can Libreoffice Compress a PNG file?

[Luuk]

On 23-4-2020 06:06, Musical Neptunian wrote:

I  make Twitch emotes in GIMP. They cannot be more than 25 Mb or Twitch
rejects them. I found a tutorial somewhere that said that Libreoffice has a
png compression tool. But when I put my png into LibreOffice I got a whole
load of symbol junk. So instead I used a free online tool that reduced my
png from 30 Kb to 7 Kb with no quality change. But could I have used
anything in Libreoffice to do this?



I would never use LibreOffice for compressing images.

use any tool found on the internet, like:

https://stackoverflow.com/questions/19153122/image-compression-tools-via-command-line 





--
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 in Libre Writer

[Luuk]

On 13-4-2020 18:12, charles meyer wrote:

Hi All,

I choose Select all or do Ctrl/A, then copy a Web site of text and live
links inot Writer and it appears with blue background so it's difficult to
read.



That depends on the website being copied...



If I copy/Paste Special it loses the live links.

There are no photos or other graphics on the page.


that should not be a problem.



I wanted to edit the text so I dind;t want to print it as a pdf.


--- because you only want to edit text?


or, am i missing something now?



Thanks.


Virus-free.
www.avast.com

Stop spamming virus-free, in this non-virus free world 

--
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] record durations, not time of day

[Luuk]

On 1-8-2019 05:05, Alan B wrote:

If entered just as you've typed, it seems all the formats presume hrs,
minutes, and seconds. Applying the time formats don't cause the display you
wish because the "3" is presumed hours and the "5", minutes.

Enter instead 0:3:5

Then this custom format should do:
MM:SS displays 03:05

Available ready made formats display as follows...
[HH]:MM:SS.00 displays 00:03:05.00
MM:SS.00 displays 03:05.00
[HH]:MM:SS displays 00:03:05
HH:MM:SS displays 00:03:05
HH:MM displays 00:03


When using square brackets in hours ('[HH]')  the time does not stop at 
23:59


25:00 with format [HH]:MM will show 25:00

when using format HH:MM, it will show 01:00


--
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: "/" character disappears in Writer

[Luuk]

On 21-6-2019 16:12, V Stuart Foote wrote:

txemaclon wrote

Hello,
This is my first post, so greetings to everyone.
After a lot of years using Microsoft products, i recently moved to Linux
Mint and also to Libreoffice.
I find a little problem using Writer. When i type "/" into a filesystem
path
(example: /home/user/) it disappears and the characters change tu
italics.
How could i change this behavior? (I could not find it at "options",
either
searching at this forum).
Regards;

You will find that in Tools -> AutoCorrect -> AutoCorrect Options
on the Options tab two check boxes (M - while modifying, T - while typing)
for the stanza "Automatic *bold*,/ italic/,- strikeout-,_underline_"

Just uncheck, and OK to apply. Remember to revert if you need the feature
otherwise.


I did not know this 'feature' existed, so i uncheck it!

Now i need to find a way to know that i should uncheck this when there 
is a need to reset my userprofile 
(https://wiki.documentfoundation.org/UserProfile)




Stuart




--
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: insert non-breaking semi-space

[Luuk]

On 16-6-2019 23:47, Dave Howorth wrote:

On Sun, 16 Jun 2019 22:09:12 +0200
Luuk  wrote:


But, to /me and i am only talking about Windows here, as long as the
key in mentioned here
(https://support.microsoft.com/en-ca/help/12445/windows-keyboard-shortcuts)
than i call it universal 

Well, as I never use Windoze, I don't call it universal :)

If was talking about 'Windows'.

--
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: insert non-breaking semi-space

[Luuk]

On 16-6-2019 16:36, Dave Howorth wrote:

On Sun, 16 Jun 2019 08:41:42 +0200
Luuk  wrote:
  

Thanks for the explanation.

There are other function which are useless in the menu, like i.e.
CTRL+C. Most (read 'all') users will use their keyboard.

Not true. Copy does not have a universal accelerator unfortunately,
sometimes it is Shift+Ctrl+C or other things. So I sometimes use the
menu in applications that I'm not completely familiar with.


I knew someone would 'complain' about this statement 

Luckily you gave an example which i never came to use (AFAIK), and 
luckily you did not say Ctrl+Insert which still works (most of the 
times) under Windows because of legacy.


But, to /me and i am only talking about Windows here, as long as the key 
in mentioned here 
(https://support.microsoft.com/en-ca/help/12445/windows-keyboard-shortcuts) 
than i call it universal 




--
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: insert non-breaking semi-space

[Luuk]

On 16-6-2019 17:01, Johnny Rosenberg wrote:

Den sön 16 juni 2019 kl 08:43 skrev Luuk :



There are other function which are useless in the menu, like i.e.
CTRL+C. Most (read 'all') users will use their keyboard.


That's not my experience. I'd rather say that most user's will use the
right click menu, only a few (like myself) use the keyboard for that. It's
very frustrating to look at. People are writing and they need to copy some
text, they move their hand to the mouse and it all takes like forever.
Those users of computer must be dumb. They have a tool which with they 
can do their job quickly, and than they start using a  mouse to copy.


Kind regards

Johnny Rosenberg



--
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: insert non-breaking semi-space

[Luuk]

On 16-6-2019 05:59, V Stuart Foote wrote:

Luuk wrote

Why did this option not get a 'reserverd place in the menu' ? together
with the shortcut-key reference (

+X) ?

An option like

+C is only known to all people (more than 75 % ??),
because the shortcut key is next to it in the menu!

Hmm, interesting question.  The BZ tdf#73691 sheds no light, and I can't
remember any discussion of adding it to a menu. But it was prominently
advertised in the release notes for 5.1
<https://wiki.documentfoundation.org/ReleaseNotes/5.1#Unicode_character_input_with_Alt.2BX>

The actual .uno:UnicodeNotationToggle command is available to assign in
Customization receiving default en-US name in Customization of "Toggle
Unicode Notation" and can be added to Menu, Toolbars, and Context menu. It
shows for LibreOffice globally as +x -- Command Name and the keyboard
shortcut are localized and configured by os.

  I could possibly see it assigned to the Standard toolbar, adjacent to the
Special character dialog button.
But, I'm not sure how it could be ussed from menu, and which menu -- Insert,
Format or even Tools -- would hold it. Checked, and it does _not_ appear on
any MS Office menus.

So kind of seems the enhancement of the BZ issue was fully implemented--with
no functional reason to add it to a menu just to expose the shortcut.

Stuart


Thanks for the explanation.

There are other function which are useless in the menu, like i.e. 
CTRL+C. Most (read 'all') users will use their keyboard.


About the position of 'ToglleUnicodeNotation' in the menu (if that ever 
becomes an issue ),  the 'edit' menu is a better place, because it's 
not inserting something.



Luuk



--
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: insert non-breaking semi-space

[Luuk]

On 15-6-2019 17:06, V Stuart Foote wrote:

Eric Beversluis wrote

Thanks. Looks like I want to use “thin space” Hex 200A. Is there an easy
way to do that from the keyboard? None of the ways I’ve used on Linux or
Windows seem to work.

Eric Beversluis


Johnny Rosenberg wrote

https://apple.stackexchange.com/questions/183045/how-can-i-type-unicode-characters-without-using-the-mouse
Kind regards

More simply, if you know the Unicode point desired, U+200A --it can be
directly entered into LibreOffice and then toggled directly. The shortcut in
Windows, Linux is: +x.

If macOS we had to use a different shortcut:  CMD+Option+x

(implemented in tdf#73691 as modified, macOS assigned internally in
LibreOffice source to use  X_MOD1_MOD2).

That should allow you to directly enter a known Unicode glyph, just be
mindful that if working with a font that does not define a glyph you'll be
dependent on font fallback and/or will receive an "undefined glyph"
placeholder on document canvas.

Stuart

Why did this option not get a 'reserverd place in the menu' ? together 
with the shortcut-key reference (+X) ?


An option like +C is only known to all people (more than 75 % ??), 
because the shortcut key is next to it in the menu!



--
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 non-breaking semi-space

[Luuk]

On 15-6-2019 16:21, Johnny Rosenberg wrote:

Den lör 15 juni 2019 kl 02:27 skrev Eric Beversluis <
ebe...@researchintegration.org>:


On June 14, 2019 at 19:59:43, T. R. Valentine (trvalent...@gmail.com)
wrote:

On Fri, 14 Jun 2019 at 18:45, Eric Beversluis
wrote:


I want to insert a non-breaking semi-space when I have a single

quotation mark next to

a double quotation mark:

John reported, “‘I think you can’t,’ he said.”

Is it possible to do this in libreoffice writer on Mac, so the two

quotation marks are

slightly spaced? I’m not having any luck searching for this.

Eric Beversluis
Short fiction at www.ericbeversluis.com

Look in the Unicode block of 'General Punctuation. There are a slew of
different-sized spaces available. You should be able to insert the one
of your choice.

--
T. R. Valentine
A rich heart may be under a poor coat.

Thanks. Looks like I want to use “thin space” Hex 200A. Is there an easy
way to do that from the keyboard? None of the ways I’ve used on Linux or
Windows seem to work.



https://apple.stackexchange.com/questions/183045/how-can-i-type-unicode-characters-without-using-the-mouse
Kind regards

Johnny Rosenberg


And Windows users can use this (if you only can remember hexcodes)

https://en.wikipedia.org/wiki/Unicode_input#In_Microsoft_Windows

This makes it possible to enter the hexcode via your keyboard, so you 
will get an "A" when entering ALT  "+" "41" (without the double quotes)


Luuk



Eric Beversluis



--
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] Vertical text in Writer on updated Linux Mint (19.1)

[Luuk]

On 9-6-2019 14:01, M Henri Day wrote:
Den sön 9 juni 2019 kl 11:53 skrev M Henri Day <mailto:mhenri...@gmail.com>>:


Den sön 9 juni 2019 kl 11:09 skrev Luuk mailto:luu...@gmail.com>>:


On 9-6-2019 09:04, M Henri Day wrote:
>> After upgrading to LO 6.2.4,2 on Linux Mint 19.1, I found
to my surprise
>> that I was neither able to attach the Vertical text icon to
the Writer
>> Toolbar, nor implement the function. I don't encounter this
problem running
>> LO 6.2.4.2 on my Windows 10 (v 1903) machines. Has anyone
else seen
>> anything similar ? Any suggestions ?...
>>
>> Henri
>>
If it is not shown here:


https://bugs.documentfoundation.org/buglist.cgi?bug_status=__all__=vertical%20text_id=966418=Importance=LibreOffice_format=specific

or search needs to be done more precise... 


Luuk, I took your response to be a suggestion that I report a bug,
which I've now done :
https://bugs.documentfoundation.org/show_bug.cgi?id=125810

Henri


My apologies ; the address to which I attempted to link above was 
https://bugs.documentfoundation.org/show_bug.cgi?id=125810 


Henri

Thanks for reporting,

--
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] Vertical text in Writer on updated Linux Mint (19.1)

[Luuk]

On 9-6-2019 09:04, M Henri Day wrote:

After upgrading to LO 6.2.4,2 on Linux Mint 19.1, I found to my surprise
that I was neither able to attach the Vertical text icon to the Writer
Toolbar, nor implement the function. I don't encounter this problem running
LO 6.2.4.2 on my Windows 10 (v 1903) machines. Has anyone else seen
anything similar ? Any suggestions ?...

Henri


If it is not shown here:

https://bugs.documentfoundation.org/buglist.cgi?bug_status=__all__=vertical%20text_id=966418=Importance=LibreOffice_format=specific

or search needs to be done more precise... 



--
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] Formula returns incorrect result

[Luuk]

On 9-6-2019 04:41, Carl Winerich wrote:

I'm trying to
   calculate the Equation of Time (EoT) to determine the difference
   between LAN (Local Apparent Noon) and GMT/UT-1  Greenwich Mean
   Time.  Then I want to plot the EoT curve (a project for later, not
   now)The following is the formula I use on my calculator.  The formula
   gives a "close enough" EoT9.87xsin(2x360(3-81)÷365)-7.67 x 
sin(360(3-81)÷365+78.7)=
   -4.584625249 (or -4 minutes 35.1 seconds...plus or minus)Calc 
doesn't give the same answer.  Here's the formula in 
calc;=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))The
 answer it returns is: -2.1488359093Can you tell me what the correct layout 
of the format in calc is?Thank you,Peter



Count the '(' and the ')'

=9.87*SIN(RADIANS(2*360*(3-81)/365)-7.67*SIN(RADIANS(360*(3-81)/365+78.7)))

should be

=9.87*SIN(RADIANS(2*360*(3-81)/365))-7.67*SIN(RADIANS(360*(3-81)/365+78.7))





--
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] percent to whole fraction

[Luuk]

YES, LCM() that's the function i was looking for...

I did not know it that function exists, probably because it's name in my 
Dutch version of EXCEL is KGV(). :-[


(see: 
https://www.excel-function-translation.com/index.php?page=english-dutch.html 
)



On 26-4-2019 22:54, Johnny Rosenberg wrote:

Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg 
:
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :


Let me rephrase the question ;)

In the 'example' line we see:

56  30228/151

The actual cell contents are:

56 302 0,18543046357615894039735099337748

Is it possible to get the values '28' and '151' as show by the
fraction-formatter?


Are we allowed to use the first two numbers (56 and 302 in this case) or
only the fraction (0,185…)?
Are we allowed to create our own cell functions?
Is the maximum values 999/999 or are higher numbers allowed?
Do you want one number (28) in one cell and the other number (151) in
another cell or what?


If you can use the original numbers (56 and 302 in the example above),
here's a short example:
A1=56
B1=302
C1=LCM(A1;B1)/B1 ⇨ 28
D1=LCM(A1;B1)/A1 ⇨ 151

Kind regards

Johnny Rosenberg



Kind regards

Johnny Rosenberg






On 26-4-2019 19:01, Luuk wrote:

Is there an option to convert a cell with format 'Fraction' to text?

example:

a b   'a/b

52297 52/297
56302 28/151
66311 66/311

in this third line, i want to get '28' and '151'

i tried TEXT(C2;""), and FIND("/";C2;1),


On 26-4-2019 00:45, Remy Gauthier wrote:

Hi,

I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.

I hope this helps.

R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :

I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"



--
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] percent to whole fraction

[Luuk]

reply inserted in your post.

On 26-4-2019 22:42, Johnny Rosenberg wrote:

Den fre 26 apr. 2019 kl 20:37 skrev Luuk :


Let me rephrase the question ;)

In the 'example' line we see:

56  30228/151

The actual cell contents are:

56 302 0,18543046357615894039735099337748

Is it possible to get the values '28' and '151' as show by the
fraction-formatter?


Are we allowed to use the first two numbers (56 and 302 in this case) or
only the fraction (0,185…)?
As long as the result is 28 and 151 (the numbers shown in the fraction), 
of course you can use 56 and 302, because the vale 0.185 is the same as 
56/302

Are we allowed to create our own cell functions?

I hope they are not needed, but if they are

Is the maximum values 999/999 or are higher numbers allowed?

I do not see a need to specify a maximum value right now...

Do you want one number (28) in one cell and the other number (151) in
another cell or what?

Yes, as said, i want two numbers



Kind regards

Johnny Rosenberg






On 26-4-2019 19:01, Luuk wrote:

Is there an option to convert a cell with format 'Fraction' to text?

example:

a b   'a/b

52297 52/297
56302 28/151
66311 66/311

in this third line, i want to get '28' and '151'

i tried TEXT(C2;""), and FIND("/";C2;1),


On 26-4-2019 00:45, Remy Gauthier wrote:

Hi,

I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.

I hope this helps.

R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :

I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"



--
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] percent to whole fraction

[Luuk]

Let me rephrase the question ;)

In the 'example' line we see:

56  302    28/151

The actual cell contents are:

56 302 0,18543046357615894039735099337748

Is it possible to get the values '28' and '151' as show by the 
fraction-formatter?




On 26-4-2019 19:01, Luuk wrote:


Is there an option to convert a cell with format 'Fraction' to text?

example:

a   b   'a/b

52  297 52/297
56  302 28/151
66  311 66/311

in this third line, i want to get '28' and '151'

i tried TEXT(C2;""), and FIND("/";C2;1),


On 26-4-2019 00:45, Remy Gauthier wrote:

Hi,

I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.

I hope this helps.

R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :

I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"




--
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] percent to whole fraction

[Luuk]

Is there an option to convert a cell with format 'Fraction' to text?

example:

a   b   'a/b

52  297 52/297
56  302 28/151
66  311 66/311

in this third line, i want to get '28' and '151'

i tried TEXT(C2;""), and FIND("/";C2;1),


On 26-4-2019 00:45, Remy Gauthier wrote:

Hi,

I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.

I hope this helps.

R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :

I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"




--
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] CSV import trouble (numbers & locale)

[Luuk]

On 24-4-2019 05:43, Drew Jensen wrote:

Howdy,

Well, I'm using LibreOffice 6.2.3 (with Ubuntu) and have created a csv file
with two data rows
12.12
12.123

Then set my global locale to Italian(Italy) and try to open the csv file.
(which is using a tab to separate values btw)
If in the dialog box I change the defaulted Italian(Italy) locale to
English(USA) everything works as expected, with the data in the now
Italian(Italy) local file:
12,12
12,123

If I do not set the locale in the import dialog to a locale which used the
'.' for decimal it does not work properly.

But if doing it in that order does is not working on the MAC then I would
say yes you should open an issue in the bug tracker.

Best wishes,

drew


After opening a CSV file, The 'column type' can be set (see atached 
picture.)


The data in the columns (12.12 and 12.123) is imported using the decimal 
separator of the language of you locale, in my case 'Dutch' (=decimal ",")


test.csv

--
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] Calc: moving/sorting rows on Sheet1 don't update formulas on Sheet2 that refer to them

[Luuk]

On 10-4-2019 05:32, Tim Deaton wrote:

Steve & Brian, thanks for your replies.

Despite decades of working on spreadsheets, I can't say I expected 
it.  But then, it's the first time I'd found myself in this particular 
scenario.  But after your first sentence, I think I can see the logic 
- even though I wish the spreadsheet was smarter.


I actually am doing a lookup from Sheet2.  But the food names on 
Sheet1 is the index column, and I'm using the lookup function to pull 
the calories, carbs, etc into Sheet2.  That's why I was sorting Sheet1 
on the food names - both to make it easier for VLOOKUP to find a 
match, and to make it easier for me to create the link between the two 
sheets.


Unless someone has any other suggestions, I guess I'll have to 
remember to insert new rows wherever my noew foods need to be, and/or 
to use ALT+SHIFT to drag new rows to where I should have inserted them 
before I created them.  I'll probably also need to regularly use 
|Paste Special| to convert those formulas pulling the food names into 
Sheet2 into hard text, since this is more fragile than I expected it 
to be.


Perhaps there's a way to setup a pull-down pick-list to pull the food 
names into Sheet2?  Perhaps I can investigate that later.


-- Tim

You should not be doing a lookup from sheet2, but you should do it from 
sheet 1


Simple Example:

Sheet1:

Three columns

A Date; i.e. 10-04-2019   ('DD-MM-', or whatever dateformat you are 
using)


B Food; ie. 'pasta', 'pizza'

C Carbohydrates; formula: 
=IF(ISERR(VLOOKUP(B2;Food.$A$1:$B$50;2;0));"?"; 
VLOOKUP(B2;Food.$A$1:$B$50;2;0))



Sheet2:

Two columns

A Food; i.e. 'pasta','pizza','macaroni', etc

B Carbohydrates;  the carbohydrates in the food...


After this sorting sheet1, or sheet2 is no problem.

The only 'problem' i have with spreadsheets is that i am always 
referring to fixed ranges (like the $A$1:$B$50), which fail after adding 
more than 50 lines ;)








40




--
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] Concatenate Function inCalc

[Luuk]

On 2-4-2019 19:33, Robert Großkopf wrote:

Hi Luuk,


In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value
of a1

This should be reported a a bug...

So please report this, if you could see the buggy behaviour in LO
6.2.2.2 also. I can't report it, because I couldn't reproduce it with LO
6.2.2.2.

Regards

Robert


I decided not to report this as a bug.

Then only 'bug' i could find is that CONCAT is missing from the help,

where CONCATENATE leads to:
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060110.html?System=WIN=CALC=SC_HID_FUNC_VERKETTEN#bm_id3153084


I (anyone) want to create a bug, you can do it here:
https://bugs.documentfoundation.org/enter_bug.cgi


--
Luuk




--
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] Concatenate Function inCalc

[Luuk]

On 2-4-2019 16:54, Robert Großkopf wrote:

Hi Michael,

This thread is about CONCATENATE being disfunctional in that it accepts
ranges, but does not act on them correctly. Please stop referring to CONCAT
as the reason that CONCATENATE is broken.

Please red the first mail of jonathon.
"With previous versions of LibO, concatenate(b1:b200) would concatenate
all cells between b1 and b200."
He has been looking for a functinality of CONCAT and wanted to use
CONCATENATE, which neverd worked in this way.

I try to help to solve this problem.

And by the way: the function CONCATENATE gives "#VALUE!" on my system
with OpenSUSE 15, 64bit rpm Linux.

In 6.2.0.3 on Windows, the function CONCATENATE(a1:a3) returns the value 
of a1


This should be reported a a bug...





--
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] Version: 6.2.0.3 - Calc: strange delay in execution of data>sort function

[Luuk]

On 7-3-2019 04:16, Tom Cloyd wrote:

I recently updated to this version, and immediately noted that upon
invocation of the main menu data>sort function to sort a group of rows
there is about a 2 second delay before anything happens. The number of rows
being sorted seems unrelated to the delay. I've never seen this behavior
before, ever. Normally, LO's Calc is quick and snappy on my system, so this
execution delay is a jolt, and after a while just plain annoying.

Has anyone else noticed this? Has anyone a clue as to what's happening?

Tom

SYSTEM:
OS: GNU/Linux, kernal 4.15.0-42-generic x86_64 GNU/Linux, LinuxMint 19
(tara) (Ubuntu bionic)

Acer Swift 3 laptop - model SF314-54 (x86_64)
Processor: 3.4 GHz Intel Core i5 (4 processors)
RAM: 8 GB DDR4
Hard Drive: Flash Memory Solid State - Micron_1100_MTFD size: 256.1GB
Graphics: Card: Intel UHD Graphics 620



I do not see this under Windows 10 (LO Version 6.2.0.3)

And also not under Linux (openSUSE Leap 15)(LO Version 6.2.1.2)

so, i do not have a clue ;)


--
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] Help needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


In EXCEL you can do this:

A   B   C
1   2   3
=A2+3   =B2+3   =C2+3

(I used CTRL+T to show formulas, you should see the values 4,5,6)

When you select A1:C3, and choose 'Insert'/'Table'

After this, typing the value 7 in cell 'A4', en pressing 'Enter' results 
in the fields B4 and C4 being updated with the same formula as in row 3.


How can this be achieved in LibreOffice Calc ?






--
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] Help needed with Excel spreadsheet

[Luuk]

On 6-3-2019 17:48, Tom Williams wrote:

On 3/6/19 8:26 AM, Tom Williams wrote:

I know it's odd to ask for Excel help in this mailing list but I need
help locating a LibreOffice Calc function/feature in Excel.  :)

I'm helping a friend create a billing invoice and since I'm a Linux
user, I'm using Calc to build the template.  So far, it's working well
and given I'm not an Excel user, I find myself struggling some in
getting Excel to "behave".  Anyway, I recently discovered the "/Expand
reference when new rows are inserted/" in Calc.  It does exactly what I
needed.   When I add/remove a row in/from the spreadsheet, my total
"SUM()" formula is updated automagically.

Does the equivalent feature exist in Excel?  What I've found is, when
adding rows *after* the last row in my SUM() formula, the new row is
excluded from the SUM() formula.   So, my formula is "=SUM(D7:D27)".
Once I add row 28, I need the SUM() formula to be updated to
"=SUM(D7:D28)".  Conversely, when row 28 is removed, I want the SUM()
formula to be updated to "=SUM(D7:D27".   In Calc, the "/Expand
reference when new rows are inserted/" feature does this work for me.

I did some web searching and found this article:

https://www.extendoffice.com/documents/excel/3895-excel-update-formula-when-inserting-rows.html

but I hope to find an easier and more flexible way to accomplish what I
need.  Or is that approach what I really should use?

Thanks in advance!

Peace...

"The Other" Tom



Nevermind!  I found this:

https://bettersolutions.com/excel/formulas/automatic-expansion.htm

That should do what I need!

Thanks anyway!  :)

Peace...

"The Other" Tom


When i was reading above, i thought you were search for subtotals.

Excel has also a function named SUBTOTAL()

https://support.office.com/en-us/article/subtotal-function-7b027003-f060-4ade-9040-e478765b9939




--
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] message about "This document contains macros."

[Luuk]

Today i added a worksheet to a libreoffice-calc document.

After saving/re-opening this document i get the message as in the 
subject of this mail.


Why?

i do not see any macro's, when looking under:

Tools/Macros/Edit/

And also , there are no macros in this document, and have never been 
there, in this document 


This is in LibreOffice 6.2.0.3 (x86) (Windows 10)

Should i file a bug?



--
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] automatic font selection in macro

[Luuk]

On 13-2-2019 06:55, Thomas Blasejewicz wrote:

Addition
On 2019/02/13 13:26, Andrew Pitonyak wrote:
if I wrote a macro that inserts the letter 'X', I would not expect 
the insertion to specify the font unless I went out of my way to do so.


* Japanese font -> I was just playing around and this is NOT what I want.
This is what LibreOffice has recorded:

sub insertalpha
rem 
--

rem define variables
dim document   as object
dim dispatcher as object
rem 
--

rem get access to the document
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

rem 
--

dim args1(1) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Symbols"
args1(0).Value = "α"
args1(1).Name = "FontName"
args1(1).Value = "ＭＳ Ｐゴシック"

dispatcher.executeDispatch(document, ".uno:InsertSymbol", "", 0, args1())

rem 
--
rem dispatcher.executeDispatch(document, ".uno:InsertSymbol", "", 0, 
Array())



end sub




I created a bug report after reading above.

is here: https://bugs.documentfoundation.org/show_bug.cgi?id=123527

it seems that 'automatic font selection in macro' works as i would 
expect. The character inserted seems to be of choosen font, and the font 
choosen before entering the 'insert/special character' screen is set back.


But there seems to be (a small) bug in selecting the correct character 
from the 'insert/special character' screen.





--
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] Why do adding OXT palettes, not show alpha sorted?

[Luuk]

On 11-2-2019 22:05, Tim-L wrote:
I am working on making color palettes - via individual or collection 
OXT files.


The problem is when I add them to LibreOffice 6.2.0.3, the font color 
drop down list of palettes is not sorted in any way, except the one 
that came with LO are the last ones shown.


Here is a link for what I am talking about.

http://libreoffice-na.us/font-color-palette-unsorted.jpg

Is there a reason why the list of color palettes is not sorted?

Any way to get it sorted, or do this needs to be done on the 
design/coding side?


Here is the start of my palette collection and individual one is OXT 
files.


http://libreoffice-na.us



I do see a sorted list , starting with

'costom'

than 'A' - 'Z'

than 'a' - 'z'

than 'Document colors'

(i just upgraded from 6.0.? to 6.2.0.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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Does something like this exist for LO?

[Luuk]

On 5-2-2019 02:55, bunk3m wrote:

On 04.02.2019 06:30, Luuk wrote:


On 2-2-2019 21:53, bunk3m wrote:
I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for 
each individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) 
that runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies. Thank you 
in advance.




I did forget to mention that this tool: 
https://github.com/nerik/google-timeline-to-csv


works with the: "Location History.json"

from: https://takeout.google.com/



Thank you Luuk.  After all my Googling, I never found this project.

I will see if I can figure out how to get this google-timeline-to-cvs 
to work.  I don't code so this will be a challenge.  I have no idea 
how to install dependencies after doing a download of this project.


Any suggestions appreciated.

Thanks again.
B.


Install nodejs (see https://nodejs.org/en/)

Download, and install 'google-timeline-to-csv' in a directory.

Now when you do this:

'node index.js'

You might get an error about missing library's.

To install those missing library's type:

'npm install fs path xmldoc json2csv moment'

(npm should be installed together with nodejs)






--
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] Does something like this exist for LO?

[Luuk]

On 2-2-2019 21:53, bunk3m wrote:
I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for each 
individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) 
that runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies.  Thank you in 
advance.




I did forget to mention that this tool: 
https://github.com/nerik/google-timeline-to-csv


works with the: "Location History.json"

from: https://takeout.google.com/




--
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] Does something like this exist for LO?

[Luuk]

On 2-2-2019 21:53, bunk3m wrote:
I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for each 
individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) 
that runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies.  Thank you in 
advance.



This is a project which is 3 years old:
https://github.com/nerik/google-timeline-to-csv

it should be easy to import a csv in LibreOffice if above code shuold work.



--
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: [libreoffice-website] capabilty to execute macro on a "server" version of libreoffice

[Luuk]

On 6-1-2019 17:36, Drew Jensen wrote:

On Sun, Jan 6, 2019 at 10:54 AM Bruno Patin - wanadoo <
bruno.pa...@wanadoo.fr> wrote:


Hi,


Howdy,



I would like to know if there exists roadmap that would allow to create
a server version of libreoffice that would execute macros job on office
docs. It would mean a version not using all the interface part of
libreoffice that would be much more compact. The goal would be to
process many files using remote services or on some files to automate
some processing such as creation of html files. Is there something
foreseen? Is it totally ridiculous? Has it been done and I do not find
the correct documentation?


First - redirecting the reply email to the User mailing list (the website
ML you originally posted to is for issues regarding the LibreOffice website
not the application).

Second - LibreOffice has always had the ability to run in what is referred
to as 'headless' mode. This means there is no GUI active while all the
document processing functions are available. The application even has
command line options specifically designed to take ODF files and generate
other fie types (html for instance) from them, in this non-GUI mode. This
feature is used as a backend for web applications today in production
environments. You can also call macros (sriptis) from the command line and
again if the macro is written properly can run just fine in this headless
mode.

Finally - I don't personally have a bunch of links for you with information
on setting that up but expect others on the users list will.

Best wishes,

Drew



Thanks in advance

Bruno


--
To unsubscribe e-mail to: website+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/website/
Privacy Policy: https://www.documentfoundation.org/privacy



C:\Program Files\LibreOffice\program>soffice --help

LibreOffice 6.1.3.2 86daf60bf00efa86ad547e59e09d6bb77c699acb

Usage: soffice [argument...]
   argument - switches, switch parameters and document URIs 
(filenames).


Using without special arguments:
Opens the start center, if it is used without any arguments.
   {file}  Tries to open the file (files) in the components
   suitable for them.
   {file} {macro:///Library.Module.MacroName}
   Opens the file and runs specified macros from
   the file.

Getting help and information:
   --help | -h | -?    Shows this help and quits.
   --helpwriter    Opens built-in or online Help on Writer.
   --helpcalc  Opens built-in or online Help on Calc.
   --helpdraw  Opens built-in or online Help on Draw.
   --helpimpress   Opens built-in or online Help on Impress.
   --helpbase  Opens built-in or online Help on Base.
   --helpbasic Opens built-in or online Help on Basic scripting
   language.
   --helpmath  Opens built-in or online Help on Math.
   --version   Shows the version and quits.
   --nstemporarydirectory
   (MacOS X sandbox only) Returns path of the temporary
   directory for the current user and exits. Overrides
   all other arguments.

General arguments:
   --quickstart[=no]   Activates[Deactivates] the Quickstarter service.
   --nolockcheck   Disables check for remote instances using one
   installation.
   --infilter={filter} Force an input filter type if possible. For example:
   --infilter="Calc Office Open XML"
   --infilter="Text (encoded):UTF8,LF,,,"
   --pidfile={file}    Store soffice.bin pid to {file}.
   --display {display} Sets the DISPLAY environment variable on UNIX-like
   platforms to the value {display} (only supported 
by a

   start script).

User/programmatic interface control:
   --nologo    Disables the splash screen at program start.
   --minimized Starts minimized. The splash screen is not 
displayed.

   --nodefault Starts without displaying anything except the splash
   screen (do not display initial window).
   --invisible Starts in invisible mode. Neither the start-up 
logo nor
   the initial program window will be visible. 
Application

   can be controlled, and documents and dialogs can be
   controlled and opened via the API. Using the 
parameter,

   the process can only be ended using the taskmanager
   (Windows) or the kill command (UNIX-like 
systems). It

   cannot be used in conjunction with --quickstart.
   --headless  Starts in "headless mode" which allows using the
   application 

Re: [libreoffice-users] what's the best way to make charts of spreadsheet data

[Luuk]

On 4-1-2019 18:54, Regina Henschel wrote:

Hi Dave,

Dave Howorth schrieb am 02-Jan-19 um 18:12:

[..]

My spreadsheet data is in columns. Column A is the dates and column B
is the times. Then ten columns of humidity data and eleven columns of
temperature data. There are currently just over 5000 rows of samples.

Making the chart was extremely slow. Every time I changed the Name of a
line of the chart I had to wait whilst it cycled through several steps
to make the change. Initially when I removed some empty columns from
the data range, it took an age to do so. etc.


Each data item produces an object, which is selectable in edit mode of 
the chart. Your data produce 5000*(10+11)=105000 objects. That cannot 
be fast.


What is the purpose of the chart? You do not need 105000 objects to 
illustrate something.


With 5000 items in x-direction a lot of them will be on top of others. 
My screen has only 1920 dots width and yours?


The fact that a screen has only (a limited) number of pixels, has 
NOTHING to do with how many items are used, or can be used,  in a graph.


Maybe the user has a A0-plotter to print this graph?

This should still be possible with software like LibreOffice, or the 
should kill the option to create graph's



just 2 cents


--
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's the best way to make charts of spreadsheet data

[Luuk]

On 2-1-2019 18:12, Dave Howorth wrote:

The Y-axis is reasonable from 0 to 120, although it would be nice to
trim the blank space at the top a bit, since the data can't exceed 100.


Right click on the Y-Axis, and choose 'Format Axis'

A popup will be schown where you can set Minimum- and Maximum value for 
the Axis (and more)




--
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 2-digit options

[Luuk]

On 29-12-2018 15:18, Thomas Blasejewicz wrote:

Good evening
I am using Calc to maintain a list of patients including entries like 
name, age, date of birth etc.

I tried to set a consistent style to about 20 different sheets.
Sheet styles do not allow to adjust font etc.

I choose character style to set the desired font for all sheets.
Problem:
I DID set a certain "date format"
and
a certain "number format".

However, this gives me either an incomprehensible 5-digit number for 
the dates (of birth),
or alternatively a similarily incomprehensible 5-digit number for the 
age = 2 digits.


I found under:
Tools - Options - General -> a "Two digit options":


   Year (two digits)

Defines a date range, within which the system recognizes a two-digit 
year.


In LibreOffice, years are indicated by four digits, so that the 
difference between 1/1/99 and 1/1/01 is two years. This *Year (two 
digits)* setting allows the user to define the years in which 
two-digit dates are added to 2000. To illustrate, if you specify a 
date of 1/1/30 or later, the entry "1/1/20" is recognized as 1/1/2020 
instead of 1/1/1920.


That may be wonderful in certain situations, but leaves me having to 
choose between the "age" (MOST of my patients have a 2-digit age!!!) 
or "date of birth" of my patients.
And, naturally, having to format those columns by hand, for all sheets 
(and maybe all eternity)

AND ... my patients turn out to have a VERY strange "date of birth":
70 ("age" translates into ) 1900/3/10
25                                   1900/1/24
33                               1900/2/1    (I am sure, there is 
some logical rule, but I cannot see it)
The above cited help section does NOT indicate any way of how to 
*DISABLE *that function.

Is there a way to do so?
I tried to just delete the number in the year field. THAT did not work.
Any help would be greatly appreciated.

Thank you.
Thomas




A date is kept, internally, as a number.

So if a cell contains 33, nd is displayed as a date, you will get 
'1900/2/1', which is 33 days after counting the days started.



BTW: Why are you storing age ? Next year all your patients are one year 
older. Is it not much better to just store birthdates?





--
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] Calc week number problem

[Luuk]

On 22-12-2018 21:56, . wrote:

I found a LO Calc spreadsheet that provides the year’s day number,
 remaining days and week number. It's attached herein.Depending upon the 
year it’s tedious to move each week number, which
 begins on Sunday, so that the week number is in the row which
 contains a Sunday.Is there a way to modify the sheet in columns F, J, N, 
R, V, Z so
 that beside each “Sun” (the row in which “Sun” appears) the correct
 week number will be provided? Thanks,Peter (at least I think that's my name...today) 
  p { margin-bottom: 0.1in; line-height: 120%; }p.western { font-family: 
"Ubuntu"; }p.cjk { font-size: 10pt; }



In F8, the formula:

=IF(WEEKDAY(C8;1)=1;WEEKNUM(C8;1);"")

Copy the formula down until F77 (without F39:F46), and change is for the 
other week columns.



--
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] Icons in message box

[Luuk]

On 17-12-2018 20:53, Johnny Rosenberg wrote:

It seems like the MsgBox function ignores icons.


*Sub Test*




*Dim iReply As IntegeriReply=MsgBox("Do you feel like pressing the
Yes button?", _  MB_YESNO OR MB_ICONQUESTION OR
MB_DEFBUTTON2, _  "Your choice")*
*End Sub*

I expect a message button with a Yes and a No button. the latter being
default. I also expect the message box to display a big question mark.
The constants I'm using are described in the file
”/usr/lib/libreoffice/help/en-US/text/sbasic/shared/03010102.html” (at
least on Manjaro Linux), and I will include them here:

MB_OK

0

Display OK button only.

MB_OKCANCEL

1

Display OK and Cancel buttons.

MB_ABORTRETRYCANCEL

2

Display Abort, Retry, and Ignore buttons.

MB_YESNOCANCEL

3

Display Yes, No, and Cancel buttons.

MB_YESNO

4

Display Yes and No buttons.

MB_RETRYCANCEL

5

Display Retry and Cancel buttons.

MB_ICONSTOP

16

Add the Stop icon to the dialog.

MB_ICONQUESTION

32

Add the Question icon to the dialog.

MB_ICONEXCLAMATION

48

Add the Exclamation Point icon to the dialog.

MB_ICONINFORMATION

64

Add the Information icon to the dialog.

128

First button in the dialog as default button.

MB_DEFBUTTON2

256

Second button in the dialog as default button.

MB_DEFBUTTON3

512

Third button in the dialog as default button.

Seems like all the MB_ICONxxx options are ignored.
I just want to find out if this is a bug or not. Maybe the problem is my
theme or something, so I just wonder if this works for anybody else.
Thanks.


Kind regards

Johnny Rosenberg



I do see the question mark.

I'm not using a theme.


--
Luuk


--
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-closing user dialogue (macro, Basic)

[Luuk]

On 9-12-2018 19:02, Johnny Rosenberg wrote:

Hi!
For some reason I can't figure this out…

I have made a simple dialogue with two buttons and a numeric field. Those
buttons triggers two different subroutines that does two different things
and then closes the entire dialogue.

I want the dialogue to close automatically after ten seconds if neither of
the buttons have been pushed. The remaining time is to be displayed in the
numeric field mentioned above.

However, I couldn't find a way to trig a function ”when nothing else
happens”. Here's what I want to do:
Dialogue opens.
User does nothing, so a subroutine is called checking the remaining time
and displays it in the numeric field.
User still doesn't do anything and the above repeats until remaining time
is zero, then the dialogue is closed.

Any suggestions?



I do not think its possible to create a user-defined event in a Macro in 
LibreOffice.



The docs say nothing about how it can be done.

https://wiki.openoffice.org/wiki/Documentation/DevGuide/Basic/Adding_Event_Handlers

https://help.libreoffice.org/Basic/Event-Driven_Macros




--
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: Adding keyboard shortcut

[Luuk]

On 9-12-2018 15:21, W. Robert J. Funnell, Prof. wrote:

On Sun, 9 Dec 2018, V Stuart Foote wrote:


Rich Shepard wrote

The *delete* you want is assigned in LibreOffice via the "Backspace"
function, aka a *rubout*.

Not quite. The backspace key deletes the character to the left of the
cursor's position while the Del key deletes the character to the right of
the cursor's position. I want to make ctrl-d function like the Del key.

Yes sorry, that is correct. They are different deletions. The "Delete"
performs what is also called a "forward delete".
Have looked at the project source code.  The forward delete action is among
a class of actions directly implemented in the edit shell and assigned to
the keyboard (symkey) for the Delete key.

It is not  available to assign to additional Keyboard shortcut or menu
entry.

Doing so would require creation of an UNO commond to perform the deletion,
that would be available for use in UI customization.

That seems like something that should be corrected. What other actions
are directly implemented like that?

In the meantime, would it work to define a macro that does
forward-character and then backward-delete, and bind it to Ctrl-D?

- Robert

Creating a Macro that does do just that would introduce a (maybe) 
unwanted feature.


Executing this while the cursor is at the last position of a document, 
the forward-character wil do nothing, but the backward-delete will 
remove the last chaacter of your document (if any).



--

For the interested people in the macro i used to test this:

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

rem --
dim args1(1) as new com.sun.star.beans.PropertyValue
args1(0).Name = "Count"
args1(0).Value = 1
args1(1).Name = "Select"
args1(1).Value = false

dispatcher.executeDispatch(document, ".uno:GoRight", "", 0, args1())

rem --
dispatcher.executeDispatch(document, ".uno:SwBackspace", "", 0, Array())

rem --
rem dispatcher.executeDispatch(document, ".uno:MacroDialog", "", 0, Array())

end sub


--
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] Exporting .pdf

[Luuk]

On 11-8-2018 22:00, Spleen wrote:
> Dear all,
>
> I'm new here and don't really know if this is the correct way of looking
> for help.
>
> I'm having troubles with exporting pdf from a .doc file. It only happens
> with Gudea font and only with the letter 'à': this is simple not visible
> in the pdf.
>
> Do you know a way to fix this? I use LibreOffice on Linux Mint 17.3
> 64bit. Tried to reinstall the font but the problem remains.
>
> Thanks a lot,
>
> Spleen
>
>
>

I found the gudea font here:
https://fonts2u.com/gudea.font

When i create a document with the next letters:

éèë

óòö

áàä

íìï

úùü



And export it to PDF, i do see something like the above,
but the 'o' and 'a' line (second and thirg line) is empty.

Must have to do something with the font?
I'm on Windows 10 with LO 6.0.6.2








éèë óòö áàä íìï úùü

-- 
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 Macro folder behavior

[Luuk]

On 22-7-2018 23:48, Peggy wrote:
> I selected some all capitalized text in a title, wanting to make a macro to
> change it to initial caps. Ran the macro, stopped it and it worked. Went to
> the macros under "My macros" in the library to assign a shortcut key.

Repeat the key combination SHIFT+F3, wil also get this done.


This is a test. (SHIFT+F3)
THIS IS A TEST. (SHIFT+F3)
this is a test. (SHIFT+F3)
This Is A Test. (SHIFT+F3)
THIS IS A TEST. (SHIFT+F3)
this is a test.


Tools/Autocorrect/Apply will change it back to:
This is a test.




-- 
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] Basic : How to throw an events ?

[Luuk]

On 7-7-2018 19:58, Patrick Gelin wrote:
> Hi,
>
> I know how to catch Event from formula by exemple, but I would like to
> throw events myself with my code. I know also I've got the possibility
> to use patterns like observator but if I could throw event it will be
> nice ! Do you know an Uno service to use to throw events ?
>
> Patrick
>

There are lost thrown here:
https://api.libreoffice.org/examples/DevelopersGuide/examples.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] Executable File?

[Luuk]

On 7-6-2018 17:06, DaveB wrote:
> On 07.06.2018 15:38, Peggy wrote:
>> I need to choose the file that opens Libre Office writer for a another
>> program's option. I can't recognize which file it is in my progarms. Can
>> you tell me the name of the file I should choose?
>> Thank you,
>> Peggy
> Hi Peggy,
>
> Assuming you are using some version of Windows, Look for a file called
> swriter.exe
>
> The historical reason for the leading "s" is that the original software,
> on which today's code is based, was called StarOffice and the word
> processor component was called StarWriter.
>
> Regards
> Dave
>
>
>

soffice.exe --help

The '--help' gives some info on the possible option that can be used,
and alos this can be used to start other Libreoffice-componentens (like
i.e. Calc)



-- 
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] Language not "picked" correctly

[Luuk]

Chrome was just meant as an example, addin the correct language to your
favorite browser should do the trick for that browser too... ;-)


On 4-6-2018 20:22, Tim-L wrote:
> When I made a clean install on this laptop for Ubuntu 18.04, I did not
> install Vivaldi.
>
> I had it on the old setup for a while, but only used once, when I
> actually downloaded it.  So, I did not install it, yet{?}.
>
> It is weird that my Ubuntu install shows en_GB instead of en_US. Your
> Ubuntu/Debian based OS gets .rpm instead .deb.  I get my problem with
> the latest repository version of Firefox - 60.0.1.
>
> I do not use Chromium, but add Chrome for those web sites who refuses
> to allow Firefox to be used.
>
> On 06/04/2018 10:36 AM, Graham Luffrum wrote:
>> I use Vivaldi under LinuxMint and when I download LO for some reason
>> I get
>> offered the rpm files, which at first foxed me.  With Vivaldi it is not
>> possible to choose different flavours of English and so I have to change
>> not only the rpm to deb, but also the language.  Both Chromium and
>> Firefox
>> on the other hand come up with both the right file type and language.
>>
>> Graham
>>
>>
>> On 3 June 2018 at 19:36, Tim-L  wrote:
>>
>>> I use Firefox.
>>> I do have Chrome and a few others I test every so often, but Firefox is
>>> the one I have been using for many years now.
>>>
>>> Henri added that I should go and chose the language option. Yes I
>>> can do
>>> that, and did so, but how many of the people who download LO will
>>> not think
>>> about that till they try to install the help packs?
>>>
>>> I have seen this issue, if I remember correctly, over the past few
>>> weeks
>>> and kept forgetting to ask about this.
>>>
>>>
>>> On 06/03/2018 12:12 PM, Luuk wrote:
>>>
>>>> when using Chrome, specify the corrrect language in your browser
>>>>
>>>> - goto chrome://settings/
>>>> - select advanced
>>>> - find 'langages'
>>>>
>>>> LibreOffice seems to be offered in the  first language you have
>>>> there
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On 2-6-2018 21:30, Tim-L wrote:
>>>>
>>>>> I am currently using Ubuntu 18.04 - - Language - en_US.UTF-8(en_US)
>>>>>
>>>>> When I go to the download page for the newest LO version 6.0.4 x86_64
>>>>> (deb)  I keep getting the English (GB) version files.
>>>>>
>>>>> It has shown up with both Ubuntu 16.04 and 18.04 installs.
>>>>>
>>>>> ---
>>>>>
>>>>> https://www.libreoffice.org/download/download/
>>>>>
>>>>> Supplementary Downloads:
>>>>>
>>>>>   Translated User Interface: English (GB) (Torrent, Info)
>>>>>   Help for offline use: English (GB) (Torrent, Info)
>>>>>
>>>>>
>>>>>
>>> -- 
>>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>>> Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-un
>>> subscribe/
>>> Posting guidelines + more:
>>> https://wiki.documentfoundation.org/Netiquette
>>> List archive: https://listarchives.libreoffice.org/global/users/
>>> 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] Language not "picked" correctly

[Luuk]

when using Chrome, specify the corrrect language in your browser

- goto chrome://settings/
- select advanced
- find 'langages'

LibreOffice seems to be offered in the  first language you have there





On 2-6-2018 21:30, Tim-L wrote:
>
> I am currently using Ubuntu 18.04 - - Language - en_US.UTF-8(en_US)
>
> When I go to the download page for the newest LO version 6.0.4 x86_64
> (deb)  I keep getting the English (GB) version files.
>
> It has shown up with both Ubuntu 16.04 and 18.04 installs.
>
> ---
>
> https://www.libreoffice.org/download/download/
>
> Supplementary Downloads:
>
>     Translated User Interface: English (GB) (Torrent, Info)
>     Help for offline use: English (GB) (Torrent, Info)
>
>


-- 
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 interface font size

[Luuk]

On 12-5-2018 04:55, Thomas Blasejewicz wrote:
> Good morning
> Just installed LibreOffice 6.0.4 (on the computer where I had problems
> with copying).
>
> Because I am getting older and my vision deteriorates,
> the fist thing I always do with new/upgraded software is to increase
> interface font size.
>
> I know how to increase the size of the icons in the menu bars,
> but unfortunately I could not yet figure out how to increase the
> interface font size.
> There seems to be no such item under "Options"
>
> Could somebody please direct me to the relevant setting (in the hope,
> there IS such setting).
> Thank you
> Thomas
>
>

In Windows 10 you can increase the size of the fonts for all
applications using:
- rightcLick the windows logo, and choos System
- choose Display
- under 'Change the size of text, apps, and other items', choose a
higher percentage (i.e. 125%)


-- 
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] Deleting columns in empty spreadsheet

[Luuk]

On 2-5-2018 19:35, Krunose wrote:
> On 02.05.2018 18:56, Luuk wrote:
>> On 2-5-2018 16:51, Krunose wrote:
>>> Hi,
>>>
>>> I just tried to delete all columns but first two in empty spreadsheet
>>> and seams that Delete columns option after selecting empty columns and
>>> right clicking is doing nothing.
>>>
>>> Is it possible to have only two columns in Calc and handful of rows
>>> the same way it's possible in Google Sheets?
>>>
>>> I'm using LO 5.4.6 on GNU/Linux Debian Stretch.
>>>
>>> Kruno
>>>
>>>
>> Deleting is not possible,
>> But hiding is!
>>
>> There should be no (functional) difference in hiding, or deleting, those
>> columns
>>
>
> Well, then Delete columns is misleading and should be grayed out in
> such specific situations...
>
> Thanks on the answer,
> Kruno
>
>
No, it should not be greyed out, because checking if there IS content in
one of those columns takes 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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Deleting columns in empty spreadsheet

[Luuk]

On 2-5-2018 16:51, Krunose wrote:
> Hi,
>
> I just tried to delete all columns but first two in empty spreadsheet
> and seams that Delete columns option after selecting empty columns and
> right clicking is doing nothing.
>
> Is it possible to have only two columns in Calc and handful of rows
> the same way it's possible in Google Sheets?
>
> I'm using LO 5.4.6 on GNU/Linux Debian Stretch.
>
> Kruno
>
>

Deleting is not possible,
But hiding is!

There should be no (functional) difference in hiding, or deleting, those
columns

-- 
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] How many of you deal with the Linux Users Group [Facebook]?

[Luuk]

On 30-4-2018 17:11, James Knott wrote:
> On 04/30/2018 08:32 AM, Virgil Arrington wrote:
>> Today, I will be drafting the final exam for my students. I will use LO 
>> Writer for the task. I will then email it to my students and they will 
>> type their answers right onto the computer file and email it back to me. 
>> I need to get the file to my students in a format they can easily use 
>> with their computers. I will use .DOC for this purpose because it's the 
>> easiest solution to this situation.
> Recent versions of MS Office are supposed to be able to work with Open
> Document files.  Have you tried to see what happens when you use it with
> ODF files?
>

i tried to open and ods (with Excel2013), lay-out was wrong, but it worked!



-- 
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] How many of you deal with the Linux Users Group [Facebook]?

[Luuk]

On 30-4-2018 05:15, Tim-L wrote:
> On 04/29/2018 01:17 PM, Luuk wrote:
>>
>> On 29-4-2018 17:23, James Knott wrote:
>>> On 04/29/2018 10:23 AM, Tim-L wrote:
>>>> There was a question in it about wondering how to get the users of
>>>> Linux to save LibreOffice files to Microsoft Word formats.
>>> Why would we want to, unless we had to?  The whole point of the Open
>>> Document formats was to be a non proprietary method that anyone can
>>> use.  Unlike MS formats, ODF is fully open.  Perhaps you should go to a
>>> site called Groklaw and read about all the nonsense with MS forcing
>>> their new spec through ISO, to make it a standard, when even their own
>>> implementation didn't comply with it.
>>>
>>>
>>> I use ODF formats unless I have a need to use MS, such as uploading
>>> documents to a web site that does not accept ODF.
>>>
>>>
>> You did forget to ask Tim-L what Facebook has to do with this problem
>> ...
>>
>> ;)
> I read a "question" about LibreOffice and then answered it.  From that
> last statement, it could seem to be a negative response of unfriendly
> people. I hope that is was meant as a joke.
>
>
> Who can afford to buy MS Office these days.
>
> So, if your kids need to write papers that require MS Office formats,
> then Open Document Formats will not do.  I know that over half of our
> local schools still have a MSO that did not even think about
> supporting a .odt document. So you either need to save it as DOC or
> DOCX to work with those computers.
>
> Why Facebook?  Well I was talking about using Linux for its security
> option of needing a Root Password to install packages. Just give the
> users Firefox, Skype, and LibreOffice.  Thats it. Then there was the
> comment about not remembering how to make sure the users defaulted to
> MSO formats, instead of trying to remember to save it to DOC/DOCX
> instead of ODT.
>
> You would not believe that info, and questions, that get on a Facebook
> Linux support group. One thread I am keep monitoring is what is the
> best distro of Linux and why.
>
>
>

You are trying to find a solution to a problem.
The problem is the wrong choice of the school ('only DOC or DOCX documents')
Try to solve the problem, and try not to find a work-around as solution.






-- 
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] How many of you deal with the Linux Users Group [Facebook]?

[Luuk]

On 29-4-2018 17:23, James Knott wrote:
> On 04/29/2018 10:23 AM, Tim-L wrote:
>> There was a question in it about wondering how to get the users of
>> Linux to save LibreOffice files to Microsoft Word formats.
> Why would we want to, unless we had to?  The whole point of the Open
> Document formats was to be a non proprietary method that anyone can
> use.  Unlike MS formats, ODF is fully open.  Perhaps you should go to a
> site called Groklaw and read about all the nonsense with MS forcing
> their new spec through ISO, to make it a standard, when even their own
> implementation didn't comply with it.
>
>
> I use ODF formats unless I have a need to use MS, such as uploading
> documents to a web site that does not accept ODF.
>
>

You did forget to ask Tim-L what Facebook has to do with this problem ...

;)


-- 
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] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

[Luuk]

On 28-4-2018 09:14, Luuk wrote:
> On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote:
>> Hi,
>>
>> I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable
>> me to draw graphs based on rainfall received per year, up until the
>> date prior to today. The figures also allow me to compare current
>> rainfall to date to the same period in a previous year. I agree I
>> should probably use Base but I do not think it would have solved the
>> issue.
>>
>> **Example Data***,
>> Month,Day,M/D,2016,2017,2018,Average('16->'17)
>> Apr,1.04/01,3,0,1,1.5
>> Apr,2,04/02,0,8,0,4
>> ,,
>> ,,
>> ,,
>> Apr,26,04/26,0,0,20,0
>>
>> Assuming today is Apr 2nd, a formula to count how many days of rain
>> there were in the current month would be =COUNTIF($F$2:$F2,">0"). The
>> Total amount of rain that fell on that number of days, being 1, was
>> 1mm, or taking it further 60% of the average rainfall to date for the
>> month.
>>
>> Assuming today is Apr 27, a formula to count how many days of rain
>> there were in the current month is unknown, especially as there are
>> undoubtedly values in the other un-shown 81 cells i.e. 3yrs and 27
>> remaining days?
>>
>> Basically take the starting cell reference $F$2 and add the number of
>> events that were ">0" to get the end reference for the COUNTIF formula.
>>
>> =COUNTIF($F$2:Add number of items ">0" to the starting line reference
>> 2, to get the end of the COUNTIF range) i.e. being Apr 27, whilst
>> there may be 26 days between the beginning of Apr and today i.e.
>> Today()-1, there are only two instances in the above table where ">0"
>> for a particular year, thus making 2 the number of days it rained, to
>> receive the SUM of the 2018 rainfall being 21mm
>>
>> I have Googled silly but my GFu is lacking something as the solution
>> evades me, even after reading the LibreOffice help files.
>>
>> For reference the formula to count the number of days from 1st Apr to
>> Yesterday:
>> =DAYS(TODAY(),"2018-04-01")
>>
>> I have uploaded the file to
>> <https://drive.google.com/file/d/1tnwBOvl2QTYeS4wkMQlg63J9oTK_UxOw/view?usp=sharing>
>> for folk to view. quite willing to upload the spreadsheet
>>
>> I will need to re-write at least 36 formulae being one for each month
>> of three years, but then hopefully I can leave column AC and
>> concentrate on entering the data correctly and optimising the graphs.
>>
>> Ideally I think I need a formula to give me the number of days between
>> $F$2 and 'TODAY() -1' and add that number to the cell reference to
>> create the end of the COUNTIF range.
>>
>> I hope you can point me in a direction that will help.
>>
>> Regards
>> Hylton
>>
> This can be solved using the INDIRECT function
>
> Example
> A1: 1
> B1: 2
> C1: 3
> D1: "A1:C1"
> E1: =AVERAGE(INDIRECT(D1))
>
> This will result in E1 showing the average value of cells A1:C1
>
>
>
or, another example

if you change B374 to: 01-01-2016
and B375 to: EOMONTH(B374;0)+1
and copy B375 to B376:B385, and change Format cell to 'MMM'

C374: ="D3:D"&(2+A374)
C375:
="D"(3+EOMONTH(B374;0)+1;"01-01-2016")&":D"(3+EOMONTH(B375;0)+1;"01-01-2016")
copy C375 to C376:C385

change D374 from '=SUM(D$3:D$33)' to '=SUM(INDIRECT(B374))'
copy D374 to D375:D385

Then values in your sheet should look like this (range A374:D386):
31  jan *D3:D33*1
28  feb D34:D63 0
31  mrt D63:D94 59
30  apr D94:D12444
31  mei D124:D155   19
30  jun D155:D185   137
31  jul D185:D216   151
31  aug D216:D247   83
30  sep D247:D277   51
31  okt D277:D308   15
30  nov D308:D338   3
31  dec D338:D369   44
365 *Total* 
607


-- 
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] Calc: Calculate number of days until yesterday IE TODAY-1 to assist in array determination for COUNTIF?

[Luuk]

On 27-4-2018 18:04, Hylton Conacher (ZR1HPC) wrote:
> Hi,
>
> I am running LibreOffice 5.4.6.2 and am using a spreadsheet to enable
> me to draw graphs based on rainfall received per year, up until the
> date prior to today. The figures also allow me to compare current
> rainfall to date to the same period in a previous year. I agree I
> should probably use Base but I do not think it would have solved the
> issue.
>
> **Example Data***,
> Month,Day,M/D,2016,2017,2018,Average('16->'17)
> Apr,1.04/01,3,0,1,1.5
> Apr,2,04/02,0,8,0,4
> ,,
> ,,
> ,,
> Apr,26,04/26,0,0,20,0
>
> Assuming today is Apr 2nd, a formula to count how many days of rain
> there were in the current month would be =COUNTIF($F$2:$F2,">0"). The
> Total amount of rain that fell on that number of days, being 1, was
> 1mm, or taking it further 60% of the average rainfall to date for the
> month.
>
> Assuming today is Apr 27, a formula to count how many days of rain
> there were in the current month is unknown, especially as there are
> undoubtedly values in the other un-shown 81 cells i.e. 3yrs and 27
> remaining days?
>
> Basically take the starting cell reference $F$2 and add the number of
> events that were ">0" to get the end reference for the COUNTIF formula.
>
> =COUNTIF($F$2:Add number of items ">0" to the starting line reference
> 2, to get the end of the COUNTIF range) i.e. being Apr 27, whilst
> there may be 26 days between the beginning of Apr and today i.e.
> Today()-1, there are only two instances in the above table where ">0"
> for a particular year, thus making 2 the number of days it rained, to
> receive the SUM of the 2018 rainfall being 21mm
>
> I have Googled silly but my GFu is lacking something as the solution
> evades me, even after reading the LibreOffice help files.
>
> For reference the formula to count the number of days from 1st Apr to
> Yesterday:
> =DAYS(TODAY(),"2018-04-01")
>
> I have uploaded the file to
> 
> for folk to view. quite willing to upload the spreadsheet
>
> I will need to re-write at least 36 formulae being one for each month
> of three years, but then hopefully I can leave column AC and
> concentrate on entering the data correctly and optimising the graphs.
>
> Ideally I think I need a formula to give me the number of days between
> $F$2 and 'TODAY() -1' and add that number to the cell reference to
> create the end of the COUNTIF range.
>
> I hope you can point me in a direction that will help.
>
> Regards
> Hylton
>

This can be solved using the INDIRECT function

Example
A1: 1
B1: 2
C1: 3
D1: "A1:C1"
E1: =AVERAGE(INDIRECT(D1))

This will result in E1 showing the average value of cells A1:C1




-- 
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] [Copying slides from one presentation to another]

[Luuk]

> From: Virgil Arrington 
> Date: Wed, Apr 4, 2018 at 7:08 AM
> Subject: Re: [libreoffice-users] [Copying slides from one presentation to
> another]
> To: "users@global.libreoffice.org" 
>
>
> I'm confused as to the flow of the discussion, and I'm not at all sure I
> know what the issue is, but I have no problem inserting an entire
> Impress presentation into another Impress presentation.
>
> Here's how I do it with LO 5.1.6 on my Linux Mint machine:
>
> First, I open one Impress presentation file. I then make sure that the
> "Slide Panel" is visible by clicking on the menu "View", "Slide Panel"
>
> I then click on the slide in the Slide Panel where I want to insert
> another Impress presentation, keeping in mind that the inserted
> presentation will appear *after* the slide I click on in the Slide
> Panel. From my experience, inserting a second presentation only works if
> my cursor focus is in the Slide Panel.
>
> Then, on the menu, I click "Insert", "File...", which on my machine is
> down toward the bottom of the Insert menu list. From the resulting
> dialog box, I select the Impress presentation I want to insert and then
> I am presented with another dialog box from which I can select certain
> slides from the inserting file. If I want the entire presentation, I
> simply click on "Ok," and the file is inserted into the original
> presentation file after the slide I had selected in my Slide Panel.
>
> Virgil

The 'file'option is missing in LO 6.0.2.1 (at least on Windows)


-- 
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] avoiding recalculate on loading of Calc files

[Luuk]

make sure this is not checked  (before saving):
Data/Calculate/AutoCalculate

When re-opening, there should not be an automatic  recalclulation

On 07-02-18 13:26, Philip Jackson wrote:
> Using Calc 5.1.6.2
>
> I would like a Calc file to load without recalculating so that I can
> recalculate manually at a moment of my choosing.
>
> While trying to find how to do this, I came across mention of
> AutoCalculate in the on-board help files (F1) - it refers to "Tools -
> Cell Contents - Autocalculate"  but this does not exist on my version of
> Calc.
>
> I found Tools > Options > LibreOffice Calc > Formula which provides an
> option for 'never recaculate' for ODF spreadsheets (Not saved by
> LibreOffice). The corresponding entry in the F1 Help says as a tip -
>
>  "LibreOffice saved ODF spreadsheets will honor Never recalculate and
> Always recalculate options".
>
> I have that set to Never recalculate but it is not honoured by Calc.
>
> Any suggestions for preventing recalc on load will be much appreciated.
>
> Philip
>


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

Re: [libreoffice-users] macro to only change month

[Luuk]

On 28-01-18 16:30, Johnny Rosenberg wrote:
> 2018-01-28 15:45 GMT+01:00 Luuk <luu...@gmail.com
> <mailto:luu...@gmail.com>>:
>
> You can write a FUNCTION to get next month
>
> Function FirstOfNextMonth(dDate as Date) as Date
>     if Month(dDate)>=12 then
>         FirstOfNextMonth = DateSerial(Year(dDate)+1, 1, 1)
>     else
>         FirstOfNextMonth = DateSerial(Year(dDate), Month(dDate)+1, 1)
>     end if
> End Function
>
>
> When you use = FirstOfNextMonth(Now()) is will return 01-02-2018  (if
> your date-format = DD-MM-)
>
>
> Just note that your function always returns the first day of the
> calculated month. I'm not sure the OP wants that, but maybe I'm wrong.
>
>
It's named 'FirstOfNextMonth()'with a reason! ;)
Also note that this 'example' function can be adapted to return another
date (whatever the OP wants).

To return 'NextMonth()' next question should be solved:
What is next month, if current date is 31 januari?
a) 28 februari, of 29 februari, depending on the year being a leap year
or not
b) 3 march 2018, (31 days after 31 januari)
c) something else.

The same question for 31 march, and other months which have a NextMonth
with less days than the current month.



-- 
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] macro to only change month

[Luuk]

You can write a FUNCTION to get next month

Function FirstOfNextMonth(dDate as Date) as Date
    if Month(dDate)>=12 then
        FirstOfNextMonth = DateSerial(Year(dDate)+1, 1, 1)
    else
        FirstOfNextMonth = DateSerial(Year(dDate), Month(dDate)+1, 1)
    end if
End Function


When you use = FirstOfNextMonth(Now()) is will return 01-02-2018  (if
your date-format = DD-MM-)


On 27-01-18 22:26, bjlockie wrote:
> I keep a spreadsheet with a monthly budget.
> Each month I copy a month to make a new month.
> I use Fill  to change the dates to the new month.
> This is not ideal because sometimes there are 2 rows for the same day and
> Fill changes the 2nd day.
> I need a macro just to change the month and not the day.
>
> Eg.
> Jan 1 2018 | debit | ...
> Jan 1 2018 | credit card | ...
> Jan 2 2018 | credit card | ...
>
> Using Fill to get a new section for Feb results in:
> Feb 1 2018 | debit | ...
> Feb 2 2018 | credit card | ...
> Feb 3 2018 | credit card | ...
>
> What I want is:
> Feb 1 2018 | debit | ...
> Feb 1 2018 | credit card | ...
> Feb 2 2018 | credit card | ...
>
>
>
>
> --
> Sent from: http://nabble.documentfoundation.org/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/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

[Luuk]

It's a crappy site anyways, because my username does not show here:

https://ask.libreoffice.org/nl/users/?sort=name=4


On 08-12-17 17:48, Luuk wrote:

I also do not use Ask Libreoffice

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

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

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




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


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

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


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








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

Re: [libreoffice-users] Why are the people who answer users' questions are not getting counted?

[Luuk]

I also do not use Ask Libreoffice

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

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

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




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


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

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


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






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

Re: [libreoffice-users] Re: Another LO anti-feature

[Luuk]

why 1000 ?

an option to make it not show at all is very much a better option


On 22-12-16 00:13, V Stuart Foote wrote:

For 5.2.4 search/replace will not show more that 1000 results to resolve
tdf#92160

=-ref-=

https://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-5-2=1a093a2c06c30c17e483614e36a75907e7d0991f

https://cgit.freedesktop.org/libreoffice/core/commit/?id=ba68e6dd7ad99ef2a2720f327813d13550b98966




--
View this message in context: 
http://nabble.documentfoundation.org/Another-LO-anti-feature-tp4203317p4203336.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] Re: Bouncing messages from users@global.libreoffice.org

[Luuk]

But, as i asked, why do i get a message that 50942 has bounced TWICE?

How do i find the bounced message? I don't see a messagenumber here:  
http://listarchives.libreoffice.org/global/users/


But, if 'The problem cleared up and you got this message from it. '...
Why can this process inform me about the fact that the problem has gone,
but 
If the problem has gone, automated stuped thing, than please 
automagically resend the message you where trying to send.
and not some bullshit message that you where not able to , but now are 
able to  :-):-(:-[:-[:-[


Luuk

On 20-12-16 21:31, Girvin Herr wrote:

Luuk,

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


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

HTH.
Girvin Herr



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

Why twice the same message?

Why this message at all?

What am i missing?

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

mailing list.

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

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











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

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

[Luuk]

Why twice the same message?

Why this message at all?

What am i missing?

On 19-12-16 17:00, users+ow...@global.libreoffice.org wrote:

Hi, this is the Mlmmj program managing the 
mailing list.

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

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





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

Re: [libreoffice-users] Version 5.2.3

[Luuk]

Maybe a good answer to this can be given if you specified the location 
from where you are downloading .


On the download page i only see a link to  a  tar.xz version
( http://www.libreoffice.org/download/libreoffice-fresh/ )


On 04-11-16 02:00, MR ZenWiz wrote:

I tried to download the tar.gz file for this and Chrome says it's
dangerous or malevolent or something and won't let it complete the
download.

Whazzupwidat?

Thanks.
MR




--
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] extracting data from uri

[Luuk]

On 18-07-16 18:20, Paolo Debortoli wrote:

Hi.  I am working on a calc sheet and need to insert data from an url:

https://finance.google.com/finance/info?client=ig=NASDAQ%3aAAPL


I  guess it generates a csv output  (in the browser it is like:
// [ { "id": "22144" ,"t" : "AAPL" ,"e" : "NASDAQ" ,"l" : "99.92" ,"l_fix" : "99.92" ,"l_cur" : "99.92" ,"s": "0" ,"ltt":"12:13PM EDT" ,"lt" : "Jul 18, 12:13PM EDT" ,"lt_dts" : "2016-07-18T12:13:44Z" 
,"c" : "+1.14" ,"c_fix" : "1.14" ,"cp" : "1.15" ,"cp_fix" : "1.15" ,"ccol" : "chg" ,"pcls_fix" : "98.78" } ]).   I would need to isolate the  number with 'l' label and insert it into a cell.

I also tried menu -> link external data -> url;  it opens the page, sees the 
table, but doesn't show it in the dialog box (with the checkbox 'update every x 
seconds'   bug??).

Thanks if you can help.

Paolo




The data you see is in JSON format
https://en.wikipedia.org/wiki/JSON

someone tried to make an extension for it 2 years ago, but it seems to 
be not released right now:

http://extensions.libreoffice.org/extension-center?path=%2FLibreOffice-Extensions-and-Templates%2Fextension-center_type=PSCProject=json



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

Re: [libreoffice-users] Calc HH:MM:SS to decimal

[Luuk]

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

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

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


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

example:

Cell A1 has 10:45:20

Cell A2 would change to 10.75

or

Cell A1 07:26:15

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

Thanks

Russell




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

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

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




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

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

[Luuk]

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

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


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


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

Re: [libreoffice-users] advanced filter to filter out huge amount of not equal data

[Luuk]

On 30-01-16 01:12, gordom wrote:

Hello everyone.
How to filter out data in Calc to exclude huge series of data?
If I want to filter out not equal data now, I use advanced filter. I 
put an operator "<>"in front of criteria data and transpose these 
criteria from rows to columns. What can I do if I have thousands of 
criteria records and there are simply not enough columns in spreadsheet?
Of course I can divided data into several spreadsheets but I want to 
avoid that. Any help will be appreciated.

Regards,

gordom



What 1024 criteria are not enough to solve your problem?

Can you share (a piece) of your problem? Maybe someone knows a smarter 
way to solve your problem using Calc.





--
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: LOBase Query - Left or Right Join?

[Luuk]

On 01-01-16 22:08, Paul Steyn wrote:

Hi Don,

Your SELECT statement is indeed incorrect; it seems as though you don't
fully understand joins (I could be mistaken, but your syntax is off
by enough to suggest this).

Firstly, choose a format for your SELECT statement to make it easier to
read. I've reformatted it below using one such formatting standard that
I've used in the past, but you can of course choose your own. The
important thing is that it isn't simply one large blob of text.

Secondly, use table aliases. After the table name in the FROM clause,
you can include a table alias, which you can use elsewhere (including in
the SELECT clause) to refer to the table. These are often much shorter
than the table names, making the whole statement easier to read. Also,
if you are including a table more than once (for different join
conditions), I think you are required to have aliases to distinguish
between the two table uses. You are actually doing this in your
statement, and it gives rise to an ambiguity.

Thirdly, JOINs are complicated, as there are many options: INNER
JOINs, LEFT, RIGHT and FULL OUTER JOINs, CROSS JOINs, NATURAL JOINs,
etc.

https://en.wikipedia.org//wiki/Join_(SQL)

The most common (in my experience) are INNER and LEFT OUTER JOINs.
Don't worry about the rest for now.

Think of it this way:

For inner joins, with the condition in the FROM clause

(i.e. FROM tableA a INNER JOIN tableB b on a.id = b.id)

You are adding all rows from tableA to a result set, then, for each row
in tableB that matches the condition, you are adding all the fields
from tableB to that row of the result set (if more than one row matches
a row in the result set, the existing row is duplicated). If a row in
the result set doesn't match any rows in tableB, it is removed from the
result set.

For OUTER JOINS, of the form:

FROM tableA a LEFT OUTER JOIN tableB b on a.id = b.id

You are doing the same thing, except that should a row in the result
set not match any rows in tableB, it is not discarded from the result
set, and instead NULL values are used for all fields that would
otherwise have come from tableB.



You are absolutely right, but the *syntax* is different in LO 
see link i posted earlier

--
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] LOBase Query - Left or Right Join?

[Luuk]

On 01-01-16 13:08, Don Parris wrote:

Hi all,

I have a set of tables for contacts, and a somewhat complex query that
seeks all the available contact information on a subset of the contacts.
By "incomplete result set", I mean I have one contact that does not show up
in the query results, but should.

I know why: that contact has phone and e-mail information, but does not yet
have a record in the address table.  Everyone else who has an address
record in the address table shows up in the results.  I would like to see
what information *is* available (regardless of whether or not there is an
address record (or even if there is an address, but no phone/email
information).

I am fairly sure I need to change the join type (using LEFT or RIGHT) on
the relevant table(s), just not sure how exactly.  My current query is
(built in Design View, copied from SQL View):





In design mode, right-click on the link between two tables, and click 
'edit'...



If you want to manually edit the SQL, the syntax is shown here:
https://help.libreoffice.org/Common/Special_Settings#Use_Outer_Join_syntax_.27.7BOJ_.7D.27


--
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: LOBase Query - Left or Right Join?

[Luuk]

reply below

On 01-01-16 18:06, Don Parris wrote:

Update:  I did try re-writing the query with LEFT/RIGHT JOINS, but all I
get are syntax errors.  Maybe I have my SQL statement incorrect?

SELECT "tCoreCategory"."category", "tCntEntity"."entity_name",
"tCntPerson"."first_name", "tCntPerson"."last_name",
"tCntAddress"."location_name", "tCntAddress"."address1"
FROM "tCntEntityCategory" JOIN "tCntEntity" ON
"tCntEntityCategory"."entity_id" = "tCntEntity"."entity_id" AND
"tCntEntityCategory" JOIN "tCoreCategory" ON
"tCntEntityCategory"."category_id" = "tCoreCategory"."category_id" AND
"tCntEntityPerson" JOIN "tCntEntity" ON "tCntEntityPerson"."entity_id" =
"tCntEntity"."entity_id" AND
"tCntEntityPerson" JOIN "tCntPerson" ON "tCntEntityPerson"."person_id" =
"tCntPerson"."person_id" AND
"tCntContactAddress" LEFT JOIN "tCntEntity" ON
"tCntContactAddress"."entity_id" = "tCntEntity"."entity_id" AND
"tCntContactAddress" LEFT JOIN "tCntPerson" ON
"tCntContactAddress"."person_id" = "tCntPerson"."person_id" AND
"tCntContactAddress" LEFT JOIN "tCntAddress" ON
"tCntContactAddress"."address_id" = "tCntAddress"."address_id" AND
"tCoreCategory"."category" LIKE 'Internal -%';





This was the second link i gave you

it says:
Example
|select Article.* from {oj item LEFT OUTER JOIN orders ON 
item.no=orders.ANR}


The link was:
https://help.libreoffice.org/Common/Special_Settings#Use_Outer_Join_syntax_.27.7BOJ_.7D.27

i do not see any '{', 'oj', '}' in your statement
|

--
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] command line options

[Luuk]

On 24-12-15 02:18, John R. Sowden wrote:
I want a link (launcher?) on my ubuntu 14.04 box to run LO in a 
directory that I specify without opening a specific file.  I entered 
the "working directory" and the approved execution name 
(/usr/bin/libreoffice).  Problem is LO comes up in, I think, the last 
directory that I used.  How do I get it to come up the the directory I 
specify in the desktop launcher.


John






I think LibreOffice will always start to open documents in the path 
specified under:

Tools/Options  LibreOffice/Paths/My Documents

a comple list of start options can be seen by entering:
'libreoffice --help'
on a shell-prompt



--
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] Creating Labels

[Luuk]

On 29-11-15 15:11, Herbie wrote:

Is there anyway to create address labels within Libre Office

Thanks



https://ask.libreoffice.org/en/question/32886/how-do-i-create-labels-from-a-spreadsheet/



--
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-how to delete a carriage return in a cell of a table

[Luuk]

On 14-11-15 10:39, yahoo-pier_andreit wrote:
on my PC=Dell latitude E6510, RAM=8Gb, GPU=GT218 NVS 3100M, CPU=i7 Q 
720 @ 1.60GHz, OS=opensuse 13.2 KDE= 4.14.9
with libreoffice Version: 5.0.3.1 Build ID: 00m0(Build:1) Locale: 
en-US (en_US.UTF-8)
I have a table with 2 columns and about 10 rows and I cannot delete 
carriage returns (the non printable character lsimilar to q ) in the 
cells, so the cells result with two lines.

how can I delete this character to have a single line row??
manythanks,  :-) ciao  :-) pier



tyr using the 'backspace', and not the 'delete' button

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