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
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
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?
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
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
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 -
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
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
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
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
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
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
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
13 matches
Mail list logo