Re: [libreoffice-users] Footnote formatting

2018-08-24 Thread Eddie
On Thu, 23 Aug 2018 17:55:33 + Virgil Arrington wrote: > Eddie, > > Go up to "Tools", "Footnotes and Endnotes" and you can control the > spacing after the Footnote Character from there. Hey, that works like a charm! Thanks! > I'd love to read that paper when you're done. Sounds

Re: [libreoffice-users] Spell checking etc does not work

2018-08-24 Thread Marco A.G. Pinto
Yes, Try to download the latest English extension from: https://extensions.libreoffice.org/extensions/english-dictionaries And use the Extension Manager to install it. Tell me if this fixes the issue. Thanks! Kind regards,     >Marco A.G.Pinto   --- On

Re: [libreoffice-users] Spell checking etc does not work SOLVED

2018-08-24 Thread Ken Heard
On 2018-08-24 13:02, Ken Heard wrote: My OS is Debian Stretch.  My version of LibreOffice is 1:5.2.7-1+deb9u4 from the stretch-backports depository. The installed version of hunspell GB has the same as the version number as LO. The US version is 20070829-7. I can open the Spelling window with

Re: [libreoffice-users] Spell checking etc does not work SOLVED

2018-08-24 Thread Ken Heard
On 2018-08-24 13:02, Ken Heard wrote: My OS is Debian Stretch.  My version of LibreOffice is 1:5.2.7-1+deb9u4 from the stretch-backports depository. The installed version of hunspell GB has the same as the version number as LO. The US version is 20070829-7. I can open the Spelling window with

[libreoffice-users] Spell checking etc does not work

2018-08-24 Thread Ken Heard
My OS is Debian Stretch. My version of LibreOffice is 1:5.2.7-1+deb9u4 from the stretch-backports depository. The installed version of hunspell GB has the same as the version number as LO. The US version is 20070829-7. I can open the Spelling window with F7. At the top of the window is a

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Brian Barker
At 17:19 24/08/2018 +0200, Hylton Conacher wrote: Formula worked perfectly, ... Good-oh! ... HATS off to you Brian. Thanks, but hats off to the SUMPRODUCT() function really. My final formula: =SUMPRODUCT(INT($Data.$A$3:$A$30/100)=$A4,$Data.D$3:D$30) to display it a sheet different to

Re: [libreoffice-users] Re: Base: setting up a home pantry dbase

2018-08-24 Thread lunixbox
Both thank you, will keep my busy. On 24-08-18 10:42, Robert Großkopf wrote: Hi Alex, lunixbox, OK, so as I now understand it, you want a running total of all items with a given Item-ID (hence the inventory aspect). I haven't answered to this because I have problems to understand ... Hope you

Re: [libreoffice-users] Cannot open LO - SOLVED

2018-08-24 Thread Ken Heard
On 2018-08-23 11:06, Ken Heard wrote: My OS is Debian Stretch.  My version of LibreOffice is 1:5.2.7-1+deb9u4 from the stretch-backports depository. Just now when I tried to open LO I received the following message: The application cannot be started. [context = "shared"] caught unexpected

Re: [libreoffice-users] Cannot open LO- SOLVED

2018-08-24 Thread Ken Heard
On 2018-08-23 16:37, Steve Edmonds wrote: Hi. Just a suggestion here, try temporarily renaming your configuration folder (mine is in ~/.config/libreoffice/4-suse/) in case the clash is occurring there. Steve On 24/08/18 03:06, Ken Heard wrote: My OS is Debian Stretch.  My version of

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Hylton Conacher (ZR1HPC)
Greetings Brian, To assist I redo my example data: Date:Text :A :B 20180803:Cattle Baron:430.00:BLANK 20180805:Dischem :BLANK :1233.39 20180805:Checkers :BLANK:606.71 20180901:PNP :2000.00 :BLANK 20181001:WW : BLANK

Re: [libreoffice-users] Adding Features

2018-08-24 Thread Philip Jackson
On 21/08/18 04:08, daleday wrote: > In the older versions I had, there were two search and replace functions. > > One was the simple magnifying glass and the other was a pair of binoculars. > This second was my favorite and I want to find out if it is possible to get > it back. > > So, how can I

Re: [libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Brian Barker
At 08:59 24/08/2018 +0200, Hylton Conacher wrote: I have data in 4 columns titled Date:Text:A:B. A typical row example is: 20180822:PNP:blank:500.00 OR 20180822:PNP:500.00:blank A row will only have a value in column A or B, never both on the same row. There may be multiple rows with the same

Re: [libreoffice-users] Re: Base: setting up a home pantry dbase aditional info

2018-08-24 Thread Robert Großkopf
Hi Alex, lunixbox, > > OK, so as I now understand it, you want a running total of all items > with a given Item-ID (hence the inventory aspect). I haven't answered to this because I have problems to understand ... Hope you are right. > > I would recommend that you read Robert Grosskopf's Base

[libreoffice-users] Re: Base: setting up a home pantry dbase aditional info

2018-08-24 Thread Alexander Thurgood
Le 23/08/2018 à 16:22, lunixbox a écrit : Hi, > Let say beans  barcode 234   =  Item-ID  2    Going in box-ID 1 ,then > the next item-ID 2 in box-ID 1  ETC. so you get a box-ID(x) = box-id(x) > +1  but the braindrain i get  is How to get the selected box-ID  into > the formula to add one item

[libreoffice-users] Add column values according to part of date value

2018-08-24 Thread Hylton Conacher (ZR1HPC)
Using LibreOffice Calc 6.0.6.2 on macOS High Sierra. I have data in 4 columns titled Date:Text:A:B A typical row example is: 20180822:PNP:blank:500.00 OR 20180822:PNP:500.00:blank A row will only have a value in column A or B, never both on the same row. There may be multiple rows with