Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Alan B
David, A follow up to my first reply. I wanted to investigate a bit more to see if I could produce a macro that actually incremented values in column B based on the corresponding cell in column D being changed. This works for me incrementing the value in col B by +1 when the value in column D on

Re: [libreoffice-users] How to visualize columns without exponential numbers with E-0...

2019-12-12 Thread Jason
On Wed, Dec 11, 2019 at 11:36:11AM -0700, GioMBG wrote: > Hi All, > hope to find ALL You fine, > first I'm not a mathematician, > I just open a xlsx file where I see a lot of numbers, I suppose in > exponential mode... > for example I see : > 1.6E-05 ( what I suppose are in exponential ) > I would

[libreoffice-users] Libre base report writer

2019-12-12 Thread Peter
Years ago when I first used Libre Base it had a built in reporting software. Yhe later versions do not include this. Is this software still available and if so how do I get it and install it? Regards Peter Goggin -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] LO Base: Boolean Report values

2019-12-12 Thread Harvey Nimmo
On Thu, 2019-12-12 at 20:28 +0100, Robert Großkopf wrote: > Hi Harvey > > > > I was just about to answer that I had tried that and it did not > > work, > > until I noticed your square brackets []. That did the trick!! You > > are > > wonderful. > > > > But where is that documented? > > Don't kno

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Michael H
Generally, The following should work, but spelling or spacing differences won't be ignored. any difference in the name will be treated as a new reviewer. IF(A1=A2,B1+1,1) On Tue, Dec 10, 2019 at 10:51 PM zed wrote: > Hi! > > Using LibreOffice v6.0.7.3 on Linux Mint v19.2 Mate > > I have a spre

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Alan B
Hi David, As I understand it you have values in column B and dates in column D. When a new date is entered in a cell in column D or an existing date is changed you want the cell on the corresponding row in column B to increase by 1. e.g. B1 = 5, D1 = May 5, 2019 change D1 and B1 becomes 6. - or -

Re: [libreoffice-users] LO Base: Boolean Report values

2019-12-12 Thread Robert Großkopf
Hi Harvey > > I was just about to answer that I had tried that and it did not work, > until I noticed your square brackets []. That did the trick!! You are > wonderful. > > But where is that documented? Don't know wher I found it, when I created the Base-Handbook. But have a lokk for the English

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Johnny Rosenberg
Den tors 12 dec. 2019 kl 05:38 skrev zed : > Brian Barker wrote: > > > At 17:49 11/12/2019 +1300, David Noname wrote: > > > I have a spreadsheet in Calc ... It has Columns ... B - No, formatted > > > number general ... > > > > > > Is there a formula that I can enter in Column B which will increas

Re: [libreoffice-users] LO Base: Boolean Report values

2019-12-12 Thread Harvey Nimmo
On Thu, 2019-12-12 at 19:46 +0100, Robert Großkopf wrote: > Hi Harvey, > > try this: > Write into Data > Data field > > IF([NameOfBoolField];"y";"n") > > Regards > > Robert > -- > Homepage: http://www.familiegrosskopf.de/robert Hi Robert, I was just about to answer that I had tried that and

Re: [libreoffice-users] LO Base: Boolean Report values

2019-12-12 Thread Robert Großkopf
Hi Harvey, try this: Write into Data > Data field IF([NameOfBoolField];"y";"n") Regards Robert -- Homepage: http://www.familiegrosskopf.de/robert -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubs

[libreoffice-users] LO Base: Boolean Report values

2019-12-12 Thread Harvey Nimmo
I wonder if anyone knows how to solve this little problem? I am trying to construct a report from a Table/Query in Base. Amongst other data there are five boolean flags (Type Yes/No[BIT] to be printed from each record. Thinking that it would take up too much space on the paper together with the l

Re: [libreoffice-users] LibreOffice Calc - Date - increase number times...

2019-12-12 Thread Brian Barker
At 17:35 12/12/2019 +1300, David Noname wrote: Thank you for your prompt reply, Brian. It is much appreciated No probs! Perhaps I didn't explain myself clearly enough. In simple terms, I want to know whether there is any way that when I enter a new date in Column D it will automatically inc

[libreoffice-users] adapting userinterface by uno or registry

2019-12-12 Thread Martin Kofahl
Hello I'm running libreoffice controlled by uno and would like to modify the user interface under certain conditions. So using uno or adjusting the users registrymodifications.xcu are my preferred techniques to accomplish the following: a) the menu item file > "save as" needs always to be hidden o