Re: [libreoffice-users] side by side tables

Thanks for reply; i have indeed used cell mreging to achieve tewuired formatting, but as for sections, that's given me something new to play around with. On Wed, 26/9/18, Brian Barker wrote: Subject: [libreoffice-users] side by side tables To: user

[libreoffice-users] table spacing default?

Hi For nearly all my tables i set the spacing below the table to 0.5 cm. It would be nice if i could have this as a default rather than have to set it individually for each new table, but i haven't found a way to do this. Is it possible? Thanks /Gary -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Personas

Hi Folks, Firefox Personas (renamed Themes) no longer work in LO and there is a proposal [1] to deprecate or replace them. However, I have 2 in my LO profile on Windows, which I would like to have them in LO on a new Linux install. I have copied the images into the equivalent Linux directory and e

[libreoffice-users] IF doesn't respect AND?

Hi, I have a spreadsheet of two tabs with tab 1 named 'Data' and the other named 'Summary'. The purpose of this spreadsheet group is to record all credit card account transactions on the 'Data' sheet and then see what value or transaction slips have not bee submitted by suppliers i.e. the goo

Re: [libreoffice-users] Personas

Hi Dave, Le 27/09/2018 à 16:38, DaveB a écrit : Hi Folks, Firefox Personas (renamed Themes) no longer work in LO and there is a proposal [1] to deprecate or replace them. However, I have 2 in my LO profile on Windows, which I would like to have them in LO on a new Linux install. I have copied t

Re: [libreoffice-users] Personas

Original Message From: Jean-Francois Nifenecker To: DaveB , LibreOffice Users Date: Thu, 27 Sep 2018 18:06:09 +0200 > Hi Dave, > > Le 27/09/2018 à 16:38, DaveB a écrit : >> Hi Folks, >> >> Firefox Personas (renamed Themes) no longer work in LO and there is a >> proposal [1]

Re: [libreoffice-users] Personas

Hi Jean-Francois, Sadly, it did not work. My results are in-line with your previous message. On 27.09.2018 17:06, Jean-Francois Nifenecker wrote: > Hi Dave, > > Le 27/09/2018 à 16:38, DaveB a écrit : >> Hi Folks, >> >> Firefox Personas (renamed Themes) no longer work in LO and there is a >> propo

Re: [libreoffice-users] IF doesn't respect AND?

Hi Hylton. There is an ISBLANK() function that will test if the cell is blank. Safer might be to test IF UPPER($Data.F$3:F$1000)  NOT "Y" Check the help on SUMFS also for multiple test criteria as you could test for ISBLANK(), is not "y", is not "Y" Is there a reason you are not entering the d

Re: [libreoffice-users] side by side tables

If I understand your question correctly Turn on and . This will make it easier to see what's happening. Read http://ask.libreoffice.org/en/question/60604/create-a-page-starting-with-2-columns-and-finishing-with-1-column/ This will result in even columns. Then in each column after "I

Re: [libreoffice-users] Personas

Dave, Le 27/09/2018 à 20:25, DaveB a écrit : Sadly, it did not work. My results are in-line with your previous message. I have had situations where it didn't work at once but did finally. The symptom is, indeed, that the Expert settings are not saved. Here's my current setting: libreoffice_

[libreoffice-users] why not everything kept during upgrade

I was running 6.0.6 version on Ubuntu 18.04.  I downloaded the and installed 6.1.2, like normal. The recent documents were saved and available to the new version. Yet, the color palettes I had were not placed into the new "share/palette" folder. I added them - again - to that folder so I can

Re: [libreoffice-users] IF doesn't respect AND?

Hi Hylton, You can transform your fomula in C3 of your Summary sheet like this: =SUMIFS(Data.C$3:Data.C$1000,Data.$A$3:Data.$A$1000,CONCATENATE("=",$A3 ,"*"),Data.$F$3:Data.$F$1000,CONCATENATE("<>","Y")) This formula will add the values in the data column, provided the RECON is not "Y" (which is wh