On Fri, 2017-12-01 at 19:56 +0100, Robert Großkopf wrote:
Hi Robert,
I appreciate your comments! Many thanks.
> What you perform with the query-editor isn't a query. A query
> shouldn't
> change the content of any table.
From a purist viewpoint, you are right, of course! My mind has been
On 01/12/2017 21:57, T. R. Valentine wrote:
I messed up. Should be:
Thank you for the correction. The formula, with a little amendment works
flawlessly.
=SUMIFS($D$7:$D$1000,$C$7:$C$1000,"=Sold",$D$7:$D$1000,"<0")
With this formula I can now search for a certain string in column C and
SUM
I messed up. Should be:
Assuming labels are in A1:A30, values in B1:B30
=SUMIFS(B1:B30,A1:A30,"=",B1:B30,">0")
replace with the 'certain text string'
- unless you are looking for a text string within the contents of
the cells with text. That would be more complicated. I'd go for a (if
On 1 December 2017 at 13:25, Hylton Conacher (ZR1HPC)
wrote:
> I have two adjacent columns where the first contains text and the second
> contains 9 digit numbers both above and below zero.
>
> I would like to SUM the contents of the second column provided it meets two
Hi,
I have two adjacent columns where the first contains text and the
second contains 9 digit numbers both above and below zero.
I would like to SUM the contents of the second column provided it meets
two criteria, namely that the first column contains a certain text
string and the number
Hi Dave,
> I need to use different computers belonging to other people to work on
> documents. I normally use LO Writer and would prefer to be able to use
> it in a browser without installing anything on the computers I'm using.
> I have access to a server and could do a server-side install to
Hi Harvey,
>
> Obviously, I found this behaviour (by accident) because I was looking
> for it, and because I needed it. Also obviously, my feeling is that
> LOBase is not doing itself a favour by restricting usage of SQL in this
> way. I would prefer a feature that allowed data manipulation via
>
I need to use different computers belonging to other people to work on
documents. I normally use LO Writer and would prefer to be able to use
it in a browser without installing anything on the computers I'm
using. I have access to a server and could do a server-side install to
make this
I am resending this as i didnt get it in my inbox and havent seen any replies
so i assume it didnt get through the first time.
G.
On Sat, 25/11/17, Gary Collins wrote:
Subject: Accessing cells in macro
To:
On Thu, 2017-11-30 at 15:50 +0100, Robert Großkopf wrote:
>
> ...
>
> It has never beeen intended that the query-editor is used for
> changing
> data. There is a feature-request for this:
> https://bugs.documentfoundation.org/show_bug.cgi?id=31398
> since 7 years.
> The risky feature is: the
10 matches
Mail list logo