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

[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

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:

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 https://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

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

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

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

[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

[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

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

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: