[libreoffice-users] Re: How to fill in "Read filter criteria from"

2016-09-26 Thread Larry Evans
On 09/26/2016 02:41 PM, Bruce Hohl wrote: Is there some other way to get a check range? Yes, to 'AND' setup your Advanced filter range like this: date | check no | check no | | >=1000 | <=1100 | Ah! Never thought of repeating the column headers. If you install the LO help there is

[libreoffice-users] Re: How to fill in "Read filter criteria from"

2016-09-26 Thread Larry Evans
On 09/25/2016 10:21 AM, Larry Evans wrote: On 09/25/2016 09:39 AM, Larry Evans wrote: On 09/24/2016 07:28 AM, jorge wrote: I'm sorry, ... it looks worst Jorge Rodríguez El sáb, 24-09-2016 a las 12:20 +, jorge escribió: Hi again: I hope in this way you can see better my last e

[libreoffice-users] Re: How to fill in "Read filter criteria from"

2016-09-25 Thread Larry Evans
On 09/25/2016 09:39 AM, Larry Evans wrote: On 09/24/2016 07:28 AM, jorge wrote: I'm sorry, ... it looks worst Jorge Rodríguez El sáb, 24-09-2016 a las 12:20 +, jorge escribió: Hi again: I hope in this way you can see better my last e-mail: At first you have to copy the headers

[libreoffice-users] Re: How to fill in "Read filter criteria from"

2016-09-25 Thread Larry Evans
50 >>>12 >>>38 >>> Advanced Filter:(Read Filter Criteria From) >>> Province >>> Sells >>> Costs >>> Profits >>> >>> >>> >>>> 20 I'm guessing that this is: > 20 and it's a row u

[libreoffice-users] Re: Formulas displaying in a cell

2016-09-24 Thread Larry Evans
On 09/24/2016 03:19 PM, Larry Evans wrote: On 01/07/2016 11:23 AM, Harv wrote: Please ignore this note. I found the problem. Please enlighten us. I'm just now having a similar problem.\ I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell. I've tried =ABS(b3

[libreoffice-users] How to fill in "Read filter criteria from"

2016-09-24 Thread Larry Evans
I selected Data>Filter>Advanced Filter; however, I had no idea what to do next. I selected Help button, which sent my browser to: https://help.libreoffice.org/index.php?title=5.1/Calc/Advanced_Filter=en-US=UNIX=5.1#bm_id3151113 which was, again, no help. How do I fill out the "Advanced

[libreoffice-users] Re: Formulas displaying in a cell

2016-09-24 Thread Larry Evans
On 01/07/2016 11:23 AM, Harv wrote: Please ignore this note. I found the problem. Please enlighten us. I'm just now having a similar problem.\ I've tryed =TEXT(b3,"###.##") and just the formula appears in the cell. I've tried =ABS(b3) and just the formula appears in the cell. I'm guessing

[libreoffice-users] Re: [calc]password protection default on

2016-05-03 Thread Larry Evans
On 05/03/2016 02:13 PM, Larry Evans wrote: I'm on ubuntu 14.04LTS. My libreoffice calc about shows: Version: 4.2.8.2 I opened a new calc file, put 100 in A1, then tried to save it; however, it then asked for a password. I don't remember changing anything that said, "for all future

[libreoffice-users] [calc]password protection default on

2016-05-03 Thread Larry Evans
I'm on ubuntu 14.04LTS. My libreoffice calc about shows: Version: 4.2.8.2 I opened a new calc file, put 100 in A1, then tried to save it; however, it then asked for a password. I don't remember changing anything that said, "for all future calc documents, require a password". How can I

[libreoffice-users] Re: Java still broke on LibreOffice 5.1.1

2016-03-12 Thread Larry Evans
On 03/11/2016 11:51 AM, Larry Gusaas wrote: > > > On 2016-03-11, 4:18 AM Alexander Thurgood wrote: >> Le 11/03/2016 01:47, Larry Gusaas a écrit : >>> LibreOffice 5.1.1 on Macs still doesn't recognize Java Runtime >>> Environment (JRE 1.8.0_73 & OS X ver.10.11.3) >>> >>> You need to fix this bug.

[libreoffice-users] Re: how to print in landscape?

2016-03-03 Thread Larry Evans
On 03/03/2016 05:12 PM, Larry Evans wrote: > Thanks for your help Regina. > > On 03/03/2016 03:41 PM, Regina Henschel wrote: >> Hi Larry, >> >> Larry Evans schrieb: >>> After selecting the [Page Preview] option, I get a screen showing >>> how

[libreoffice-users] Re: how to print in landscape?

2016-03-03 Thread Larry Evans
Thanks for your help Regina. On 03/03/2016 03:41 PM, Regina Henschel wrote: > Hi Larry, > > Larry Evans schrieb: >> After selecting the [Page Preview] option, I get a screen showing >> how the page would look when output by my printer. > > No, it does not. It i

[libreoffice-users] how to print in landscape?

2016-03-03 Thread Larry Evans
After selecting the [Page Preview] option, I get a screen showing how the page would look when output by my printer. On that screen, there's a [Format Page] entry on the 2nd line; however, when I click on that, nothing happens. I want to change the format to landscape. Also, even after I

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

2016-01-26 Thread Larry Evans
On 01/26/2016 07:18 AM, Andreas Säger wrote: > Am 26.01.2016 um 11:47 schrieb Larry Evans: >> I've checked that the value returned by the YIELD function: >> >> https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD >> >> can be gotten by using [Tools&

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

2016-01-26 Thread Larry Evans
On 01/26/2016 08:42 AM, Larry Evans wrote: > On 01/26/2016 07:18 AM, Andreas Säger wrote: >> Am 26.01.2016 um 11:47 schrieb Larry Evans: >>> I've checked that the value returned by the YIELD function: >>> >>> https://help.libreoffice.org/Calc/Financial_

[libreoffice-users] Re: [calc] is there a GOAL_SEEK function somewhere?

2016-01-26 Thread Larry Evans
On 01/26/2016 09:02 AM, Larry Evans wrote: > On 01/26/2016 08:42 AM, Larry Evans wrote: >> On 01/26/2016 07:18 AM, Andreas Säger wrote: >>> Am 26.01.2016 um 11:47 schrieb Larry Evans: >>>> I've checked that the value returned by the YIELD function: >>>&

[libreoffice-users] [calc] is there a GOAL_SEEK function somewhere?

2016-01-26 Thread Larry Evans
I've checked that the value returned by the YIELD function: https://help.libreoffice.org/Calc/Financial_Functions_Part_Two#YIELD can be gotten by using [Tools>Goal Seek...] and the PV function: https://help.libreoffice.org/Calc/Financial_Functions_Part_One#PV Is there some way I could use a

[libreoffice-users] Re: Can the most up-to-date LO import and print pdfs?

2015-10-13 Thread Larry Evans
On 02/25/2015 12:02 PM, V Stuart Foote wrote: > In a sense. LibreOffice Draw runs filters that read the PDF rendering it > into an ODF drawing document--.ODG extension. > I opened a new Draw doc and searched for how to import a pdf. There was something about filters under Tools>XML filter

[libreoffice-users] Re: [calc]mmult with transpose arg drops last row

2014-01-17 Thread Larry Evans
On 01/13/14 11:47, Larry Evans wrote: I've a spreadsheet with 2 3x2 matridces side by side (A1:D3). I want to mmult(A1:B3;transpose(C1:D3)); however, the result has the last row truncated. IOW, the resulting matrix is 2x3 instead of 3x3. [snip] Filed a bug report: https

[libreoffice-users] Re: a LibO/Calc problem (SOLVED)

2014-01-13 Thread Larry Evans
On 01/13/14 05:10, Pertti Rönnberg wrote: Thank you Paul and Brian for your interesting answers and for your kindness to send them so soon. I have not checked them yet but I am sure that both of them give me what I was looking for. I see thepros and cons in Paul's method: by splitting the

[libreoffice-users] [calc]mmult with transpose arg drops last row

2014-01-13 Thread Larry Evans
I've a spreadsheet with 2 3x2 matridces side by side (A1:D3). I want to mmult(A1:B3;transpose(C1:D3)); however, the result has the last row truncated. IOW, the resulting matrix is 2x3 instead of 3x3. The spreadsheet also has the transpose stored separately in cells A5:C12, and then the mmult

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/05/14 16:53, mariosv wrote: Please take a look to documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 10 Linking Calc Data Linking to registered data

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 07:50, Larry Evans wrote: On 01/05/14 16:53, mariosv wrote: Please take a look to documentation: https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide Chapter 10 Linking Calc Data Linking to registered data sources

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 10:59, Larry Evans wrote: On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data... the OK button remains disabled. How can I link

[libreoffice-users] Re: [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-06 Thread Larry Evans
On 01/06/14 11:20, Larry Evans wrote: On 01/06/14 10:59, Larry Evans wrote: On 01/06/14 09:02, Alex Thurgood wrote: Le 05/01/2014 18:32, Larry Evans a écrit : Hi Larry, In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb

[libreoffice-users] [calc]when link to external data, which is libreoffice .odb file, OK button disabled

2014-01-05 Thread Larry Evans
In calc, when I try to insert a link to: ~/evansl/prog_dev/LibreOffice/database/products_supplier.odb from the InsertLink to external Data... the OK button remains disabled. How can I link to an existing database which was created with Libreoffice? My os infor is:

[libreoffice-users] mysterious foreign key integrity constraint violation

2013-12-30 Thread Larry Evans
I've 2 tables: Table:Products with ProductName as primary key. ProductName Inventory --- - product1 100 product2 200 Table:Suppliers with SupplierName as primary key. SupplierName PhoneNumber --- supplier1 111- supplier2 222-

[libreoffice-users] Re: mysterious foreign key integrity constraint violation

2013-12-30 Thread Larry Evans
On 12/30/13 18:21, Regina Henschel wrote: Hi Larry, Larry Evans schrieb: I've 2 tables: Table:Products with ProductName as primary key. ProductName Inventory --- - product1 100 product2 200 Table:Suppliers with SupplierName as primary key. SupplierName PhoneNumber

[libreoffice-users] Re: What's syntax of xforms Edit Element Constraint Condition?

2013-10-14 Thread Larry Evans
On 10/12/13 09:45, Larry Evans wrote: I'm using LibreOffice 3.5.7.2 with Build ID: 350m1(Build:2) running on ubuntu: ~/temp $ uname -a Linux evansl-Inspiron-531 3.2.0-54-generic #82-Ubuntu SMP Tue Sep 10 20:08:42 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux When creating an XML Form Document, I'm

[libreoffice-users] What's syntax of xforms Edit Element Constraint Condition?

2013-10-12 Thread Larry Evans
I'm using LibreOffice 3.5.7.2 with Build ID: 350m1(Build:2) running on ubuntu: ~/temp $ uname -a Linux evansl-Inspiron-531 3.2.0-54-generic #82-Ubuntu SMP Tue Sep 10 20:08:42 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux When creating an XML Form Document, I'm having trouble using the editor for