[libreoffice-users] VLOOKUP/Data Pilot? problem

I'm doing QA in my office and I have a sheet filled with Employee IDs and a simple pass/fail score, like so: EmpID Pass/Fail 11 Pass 12 Pass 11 Fail 13 Fail What I want to do, is in a separate area of the sheet, have

Re: [libreoffice-users] VLOOKUP/Data Pilot? problem

it does, thanks. On Tue, Feb 19, 2013 at 10:06 PM, Brian Barker b.m.bar...@btinternet.comwrote: At 20:04 19/02/2013 -0700, John Meyer wrote: I'm doing QA in my office and I have a sheet filled with Employee IDs and a simple pass/fail score, like so: EmpID Pass/Fail 11

[libreoffice-users] Function for turning the text in an entire row red

I'm trying to write a macro that will turn an entire row's text red based upon a cell in that row. Is there a function available within the basic editor that will do that? -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: re. doc to pdf

Usually I think of the opening scene in Tom Jones, where the two doctors keep arguing over the patient about what's ailing him until he dies. On 5/14/2013 10:34 AM, anne-ology wrote: and a 'pair of ducks' swim o'er the pond ;-) [well, my mind tends to wander ;-) ] On

[libreoffice-users] VLOOKUP Problem

I have two columns. Column A displays the logon names being used and Column B contains all possible logons (technically it's on another sheet, but I'll simplify). What I want to appear on column C is a list of all logons that are not being used. For instance: COLUMNA: Frank Harry George

Re: [libreoffice-users] VLOOKUP Problem

I figured as much. That shouldn't be a problem as long as I make sure it fires on every update of column B. On Sat, Feb 2, 2013 at 8:53 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2013/2/2 John Meyer john.l.me...@gmail.com: I have two columns. Column A displays the logon names being

Re: [libreoffice-users] VLOOKUP Problem

BTW, this is off topic, but is there any way to configure GMail so when I hit reply I reply to the list and not to the person? On Sat, Feb 2, 2013 at 9:57 AM, John Meyer john.l.me...@gmail.com wrote: I'll try it out. Personally I don't know why I'm a neat freak in terms of not wanting blanks

Re: [libreoffice-users] VLOOKUP Problem

of the message On 2 February 2013 17:12, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2013/2/2 John Meyer john.l.me...@gmail.com: BTW, this is off topic, but is there any way to configure GMail so when I hit reply I reply to the list and not to the person? The new behaviour

Re: [libreoffice-users] Suggests

Developing it on your own is one thing; distributing it is quite another, http://msdn.microsoft.com/en-us/library/ff799534.aspx. Also, I don't like that interface; I think it was the worst idea MS came up with until somebody thought it would be a neat idea to turn a desktop into a mobile tablet

Re: [libreoffice-users] Would somebody be able to help a newbe to LibreOffice.

_W_indow-_F_reeze Place cursor underneath row you want to stay still. HTH On 11/7/2013 6:21 PM, Bill Gassner wrote: Hi All, Thanks for responding to my call for help. Here is the situation: I have a LibreOffice Cal sheet with rows 1-34 with text. Rows 35-40 with titles above 7 colums. Rows

Re: [libreoffice-users] Re: 64 bit

And there's also the Open Source Answer: if users think that such a project would be worthwhile they can band together, take the code, and try to port it themselves. On 11/8/2013 1:41 PM, Joel Madero wrote: Clearly the point didn't come across as I hoped. What I'm saying is that our

Re: [libreoffice-users] Subject: DRM books

Yeah, kinda OT, but Calibre is the best program for this. you can even e-mail your books to your Kindle. On 11/10/2013 7:20 AM, zuke wrote: On 11/09/2013 10:49 PM, Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Thanks Daniel LibreOffice really isn't the tool for

Re: [libreoffice-users] Engaging users: initial results of the survey

On 11/10/2013 11:46 AM, Charles-H. Schulz wrote: Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis:

Re: [libreoffice-users] Engaging users: initial results of the survey

good data underneath. On 11/12/2013 7:04 AM, Charles-H. Schulz wrote: Le Tue, 12 Nov 2013 06:57:20 -0700, John Meyer johnme...@pueblocomputing.com a écrit : On 11/10/2013 11:46 AM, Charles-H. Schulz wrote: Hello, As there were some exchanges about the survey here and as I advertised

Re: [libreoffice-users] Engaging users: initial results of the survey

, 12 Nov 2013 07:29:47 -0700, John Meyer johnme...@pueblocomputing.com a écrit : You made a survey without a survey statistician on your team. Did you send out a request for such a person on the mailing lists to advise you before you put together the survey? Did you have a clear and concise

Re: [libreoffice-users] Engaging users: initial results of the survey

answered. If you seriously would like to get involved, you should - I mean it, there's no sarcasm. Best Charles. Le Tue, 12 Nov 2013 07:54:15 -0700, John Meyer johnme...@pueblocomputing.com a écrit : Okay, I point out problems and you're response is you don't like it you can

Re: [libreoffice-users] Re: Engaging users: initial results of the survey

On 11/11/2013 11:33 AM, Ken Springer wrote: After using LO for awhile, I found and filed a couple of bugs/issues. I wanted to contribute in the area of reporting issues, but I don't have the knowledge to fix them. I didn't expect those problems to go to the head of the line. But I *did*

Re: [libreoffice-users] Re: Engaging users: initial results of the survey

On 11/12/2013 2:39 PM, Ken Springer wrote: Here's the fault with this logic. I'm going to up the number of people for bug B just for illustrating my point. 50 people have issues with bug A. 5 people have issues with bug B. Extrapolate... 5 people with bug C, 5 with D, all the way though

Re: [libreoffice-users] Re: Engaging users: initial results of the survey

On 11/12/2013 6:24 PM, Ken Springer wrote: On 11/12/13 4:35 PM, John Meyer wrote: On 11/12/2013 3:02 PM, Ken Springer wrote: On 11/12/13 8:50 AM, John Meyer wrote: On 11/11/2013 11:33 AM, Ken Springer wrote: After using LO for awhile, I found and filed a couple of bugs/issues. I wanted

[libreoffice-users] Templates with pop up variables in Writer

I'd like to create a template that would pop up a couple of fill in fields (name, date) and automatically populate them in the new document. Is that possible? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

Re: [libreoffice-users] Templates with pop up variables in Writer

On Thu, 14 Nov 2013 15:02:36 -0700 John Meyer johnme...@pueblocomputing.com wrote: I'd like to create a template that would pop up a couple of fill in fields (name, date) and automatically populate them in the new document. Is that possible? Basically, I want two things: One capture two pieces

[libreoffice-users] SUMIF problem

=SUMIF(D1:D14,*Landline$,F1:F14) Will this match any text in D1 to D14 that ends with the word Landline? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: [libreoffice-users] Database Design

My $.05 (.02 adjusted for inflation): I'm seeing 3 tables SUBSCRIBERS SUBSCRIBER_ID SUBSCRIBER_NAME SUBSCRIBER_ADDRESS PUBLICATIONS PUBLICATION_ID PUBLICATION_NAME SUBSCRIPTIONS SUBSCRIBER_ID PUBLICATION_ID SUBSCRIPTION_START SUBSCRIPTION_END SUBSCRIPTION_DAYODELIVERY

Re: [libreoffice-users] Database Design

Also, I wouldn't even bother with putting up a table of driving instructions. I'd hook into Google's map driving capabilities. Don't reinvent the wheel unless you absolutely have to. On 11/17/2013 2:20 PM, James E Lang wrote: I have no experience designing a database. I hope this list is a

Re: [libreoffice-users] Re: Softmaker

On 11/20/2013 4:44 PM, Virgil Arrington wrote: I think it's time to look at word processing from a new model. Rather than continuing to mimic the typewriter in document creation, I think it's time we found ways to create documents for a wide range of reading options -- paper, computer screen,

Re: [libreoffice-users] Re: Softmaker

On 11/20/2013 5:39 PM, Doug wrote: On 11/20/2013 06:50 PM, John Meyer wrote: On 11/20/2013 4:44 PM, Virgil Arrington wrote: I think it's time to look at word processing from a new model. Rather than continuing to mimic the typewriter in document creation, I think it's time we found ways

Re: [libreoffice-users] embedding video

Have you tried converting the flv to mov or mp4? On 11/22/2013 9:21 AM, Marc Grober wrote: On LO 4.1.2.3 on OSX 10.9 I am exploring the various possibilities of embedding video. It would appear the ability to embed via URL to a remote source is not available, and I was able to embed an .mov

Re: [libreoffice-users] Feature Request - Categories for special characters

On 11/21/2013 11:37 PM, Doug wrote: I always think of # as being a sharp sign I always think of a tic-tac-toe game. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

marketing targets... ideas? On Friday, November 29, 2013 8:31 PM, John Meyer john.l.me...@gmail.com wrote: I didn't know we considered trialware cunning. On Fri, Nov 29, 2013 at 10:04 AM, James Knott james.kn...@rogers.comwrote: Tom Davies wrote: Also on newer machines MS have

Re: [libreoffice-users] Re: Cost of MS Office relative to LO, was: Fwd: Re: moving to new version of MS Office

I'm thinking we've got troll-sighting On 11/30/2013 10:25 AM, jomali wrote: Once again, Umas, you set up a straw man and demolish him! FOSS means Free and Open Source Software. It doesn't necessarily refer to software created by some pure amateur in his garage. As long as the creator

Re: [libreoffice-users] saving documents written in Thai

On 12/14/2013 8:35 AM, Dale Erwin wrote: Recently, I've been trying to learn Thai and have set up an alternate Thai keyboard layout. All works pretty well until I try to save a document written in Thai. It seems to save OK, but when I open it later, all the Thai text is represented by small

Re: [libreoffice-users] Re: looking for sdw-compatible, Linux version of Libre Office

Wouldn't a better solution be a batch converter you could run on the rare occasion you needed one of those formats? On 12/17/2013 12:31 PM, Kracked_P_P---webmaster wrote: I have the Archive page bookmarked. I figured that downloading the older version[s] of LO would be easier than looking

[libreoffice-users] Bonus calculator in Calc

A while back I posted up about calculating bonuses based upon a lookup. now, I need to add an additional step. Every once in a while, agents get additional bonuses for sales outside of the normal commission ladder. Here's the layout of the main sheet A B C

Re: [libreoffice-users] Bonus calculator in Calc

for as much of this sort of thing as possible because it makes it easier to adjust the formulae in the future Regards from Tom :) On 18 December 2013 20:22, John Meyer johnme...@pueblocomputing.com wrote: A while back I posted up about calculating bonuses based upon a lookup. now, I need to add

Re: [libreoffice-users] Bonus calculator in Calc

Let's assume I can't get IT to install the JRE for database access. On 12/18/2013 4:48 PM, Tom Davies wrote: Hi :) Why not use Base to read the 2 existing sheets? Then let it do the bit it does best? Regards from Tom :) On 18 December 2013 23:46, John Meyer johnme...@pueblocomputing.com

Re: [libreoffice-users] How to Stop Automatic Capitalization?

On 12/26/2013 7:33 AM, Jonathan Levi wrote: Can someone please explain to me how I change LO's insistence on capitalizing words following a period, even if I don't want it? (i.e., Yest. evening is replaced by Yest. Evening.) TIA, Jonathan Tools-Autocorrect Options-Options-Uncheck Capitalize

Re: [libreoffice-users] Additional KSSS for an Auction Question

Sounds like more of problem that would be solved by Base. On 1/24/2014 10:46 AM, Pikov Andropov wrote: We would like the Kingsoft Spreadsheet (KSSS) to have the following columns: A. Name B. Amount of winning bid C. Code for item purchased D. Description of item purchased E. Starting bid We

[libreoffice-users] Sorting by groups

Is it possible to do a sort based on a subtotal that occurs every nth line as opposed to every line? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: [libreoffice-users] VLOOKUP and HTML cutcopypasta

Will try that when I go back to work. Thanks. On 2/1/2016 1:28 PM, Steve Edmonds wrote: Are you pasting straight to calc?. Sometimes I have found I need to paste special into writer as HTML and then copy/past that table into calc. Steve On 2016-02-02 07:26, John Meyer wrote: I'm using

[libreoffice-users] Replacing the first character, did I stumble onto the right answer

I was trying to find a way to find and replace the beginning single tick in a column of cells, and out of frustration and trying to set up step one in a longer scheme of steps, I tried this: Find ^. Replace & It seemed to work instantly for some unknown reason. Exactly what did I do? -- To

Re: [libreoffice-users] Replacing the first character, did I stumble onto the right answer

Nothing, which it did (aka deleted it). On Feb 20, 2016 8:52 AM, "Brian Barker" <b.m.bar...@btinternet.com> wrote: > At 06:19 20/02/2016 -0700, John Meyer wrote: > >> I was trying to find a way to find and replace the beginning single tick >> in a column of c

Re: [libreoffice-users] Replacing the first character, did I stumble onto the right answer

Not doubting that. I'll run a few other examples and see if I can post a screenshot. On Feb 20, 2016 7:22 PM, "Brian Barker" <b.m.bar...@btinternet.com> wrote: > At 15:23 20/02/2016 -0700, John Meyer wrote: > >> Nothing, which it did (aka deleted it). >> >

[libreoffice-users] VLOOKUP and HTML cutcopypasta

I'm using a VLOOKUP to filter and find data from a spreadsheet where I am cut-copy-pasting the information from a website (tabular format) and I am getting an NA back. Is there a common problem I should be looking for with this type of import? Thanks. -- To unsubscribe e-mail to:

Re: [libreoffice-users] Re: Converting a document to .pdf

No worries, we all have our "duh gee George" moments, as I like to frame them. On 2/1/2016 4:07 PM, jantrem wrote: Duh... Not sure how I missed THAT. good thing it doesn't bite! Jan -- View this message in context:

[libreoffice-users] Adding decimal minutes to regular minutes and hours (calc)

Hi, I have a project where I am trying to calculate the total amount of work hours for a project based upon the timestamp of calls throughout the day. The time at which the calls is placed is in hh:mm:ss while the duration of the call is in decimal time. I need to take the last call of the

Re: [libreoffice-users] Programming guide for LibreOffice 4.1

Thanks to all who provided the information. I've been busy crunching out this project and haven't had time to reply. On 3/6/2016 9:14 AM, Piet van Oostrum wrote: John Meyer wrote: > I'm trying to write a macro for LibreOffice 4.1. Which programming > guide should

[libreoffice-users] Programming guide for LibreOffice 4.1

I'm trying to write a macro for LibreOffice 4.1. Which programming guide should I use? thanks. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: [libreoffice-users] Re: Adding decimal minutes to regular minutes and hours (calc)

So if I'm getting this right, I would just do something like this: A B 1 Last Call: 5:58:16 2 Duration: 6.24 Total:: =B1 + B2 (and format as needed) On 4/6/2016 8:07 AM, Andreas Säger wrote: Am 06.04.2016 um 15:36 schrieb John Meyer: Hi, I have a project

Re: [libreoffice-users] Calc HH:MM:SS to decimal

This actually worked incredibly well for my problem. On 5/5/2016 10:52 AM, Bruce Hohl wrote: Try this in cell A2 "=VALUE(A1)*24" On Thu, May 5, 2016 at 12:44 PM, Russell wrote: does anyone know if there is a formula for a cell that will transform the HH:mm:ss from

[libreoffice-users] Pivot table conditional formatting

Is there any way to have conditional formatting stick with a pivot table that is constantly updating the amount of data? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines +

[libreoffice-users] Open XLS directly into LibreOffice 4.1 vs double clicking on it in Windows

I have LibreOffice set up at work to default open XLS files. When I do a double click, it gives me the normal import options but otherwise goes fine. If I try to directly open that file in LibreOffice Calc, however, it kicks it out to Writer. Is this a known bug in LO? -- To unsubscribe

Re: [libreoffice-users] Open XLS directly into LibreOffice 4.1 vs double clicking on it in Windows

being generated by a component, dhtmlxgrid (https://docs.dhtmlx.com/grid__index.html, again prior version) so the XLS file may not be completely clean. On 3/26/2017 11:01 AM, Tanstaafl wrote: On 3/23/2017, 6:59:59 PM, John Meyer <john.l.me...@gmail.com> wrote: I have LibreOffice set up a

Re: [libreoffice-users] Copy-Paste(special) times in Calc.

Usually when I'm pasting in time into a cell formatted for time, I'll paste special. The worst that happens is that the time is affixed with a single quote mark. Then I find and replace "^." with "&" (no quote marks). On 3/29/2017 2:32 PM, Steve Edmonds wrote: Hi. Playing with the