[libreoffice-users] re: calc: index column A with column B

2021-01-28 Thread James
I want to find the row in column A that corresponds to the row of a value in column B. eg. rowAB 1 10 22 2 20 15 3 30 3000 4 40 10 =some_function('A',minimum_function(B)); where

Re: [libreoffice-users] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

2021-01-28 Thread John Kaufmann
On 2021-01-28 16:47, John Kaufmann wrote: What is sychropopular?  Do you mean synchrophasor? ... My profound apologies to the list for that. I have no idea how this list was added to the distribution of that reply to an (HMTL) mail from IEEE Power and Energy Society. -- To unsubscribe

[libreoffice-users] Re: Meet the 2020 IEEE PES Wanda Reder Pioneer Power Award Recipient

2021-01-28 Thread John Kaufmann
What issychropopular?  Do you meansynchrophasor?-John Kaufmann1-724-433-0459On 2021-01-28 16:00, IEEE Power and Energy Society wrote: #outlook a { padding: 0; }.ReadMsgBody { width: 100%; }.ExternalClass { width: 100%; }.ExternalClass, .ExternalClass p, .ExternalClass span, .ExternalClass

Re: [libreoffice-users] LO 6.4.7.2 Calc: Where is a cell referenced elsewhere in s file?

2021-01-28 Thread Johnny Rosenberg
Den tors 28 jan. 2021 kl 01:05 skrev Steve Edmonds < steve.edmo...@ptglobal.com>: > Hi Hylton. > If you use find/replace you can search for a reference (i.e.B4) and > search all sheets with the find next. Remember to search for B$4 also in > case any formulae contain this reference format. >

[libreoffice-users] Writer - Customize date format in a date field form control

2021-01-28 Thread Juan Antonio
Hello. Is there any way to customize the /date format/ when we insert a /date field form control/? For example, I would like to put a date format like /Thu 28 january/ . There are some formats in the Date format drop-down that appears in Properties of Date Field, but it does not include the

Re: [libreoffice-users] What does LibreOffice recognize as a column delimiter?

2021-01-28 Thread Michael H
re: Field Separator The unicode tab (Ux0009) should be the best 'field separator.' re: Formatting. If this is like dictionary info (word, type, long definition) you should carefully consider making it paragraphs and separate those fields with a tab. If your data is more like a list (month,

Re: [libreoffice-users] What does LibreOffice recognize as a column delimiter?

2021-01-28 Thread Dave Barton
Original Message From: Jeffrey Walton [mailto:noloa...@gmail.com] Sent: Thursday, January 28, 2021, 12:02 UTC To: users@global.libreoffice.org Subject: [libreoffice-users] What does LibreOffice recognize as a column delimiter? > Hi Everyone, > > I have a Writer document with a

Re: [libreoffice-users] What does LibreOffice recognize as a column delimiter?

2021-01-28 Thread Michael D. Setzer II
I put the data in a file called tabel1.csv Then imported the data into Calc (Vertical Bar is 124) The following command loaded the file into a calc spreadsheet. libreoffice --infilter=CSV:124,34,76,1 tabel1.csv Then copied it into writer. Tried to do it with --writer, but it results in just text

[libreoffice-users] What does LibreOffice recognize as a column delimiter?

2021-01-28 Thread Jeffrey Walton
Hi Everyone, I have a Writer document with a Table inside. The table is large at about 3 columns x 500 rows. When I attempt to highlight the table cells and paste the data from a single 1 x 1500 source LibreOffice mishandles populating the table. I'm generating the data from a C++ program so I