Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-01 Thread Harvey Nimmo
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

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
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

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread T. R. Valentine
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

Re: [libreoffice-users] Calc: Filtering formula

2017-12-01 Thread T. R. Valentine
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

[libreoffice-users] Calc: Filtering formula

2017-12-01 Thread Hylton Conacher (ZR1HPC)
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

Re: [libreoffice-users] libre-office in the browser?

2017-12-01 Thread Robert Großkopf
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

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-01 Thread Robert Großkopf
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 >

[libreoffice-users] libre-office in the browser?

2017-12-01 Thread Dave Stevens
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

[libreoffice-users] Re: Accessing cells in macro

2017-12-01 Thread Gary Collins
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:

Re: [libreoffice-users] Re: Base - a risky feature of the document display?

2017-12-01 Thread Harvey Nimmo
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