[users] How to search a table and return a list of values?

2010-09-23 Thread Mark Phillips
Is there some magical combination of functions that allows one to search a table of values and return a list of values? My table has dates across the top row, and names down the side. Within the table are Y, N, or blank. I want to get the list of names based on the Y's in a particular column

Re: [users] Re: Need Help Adding Fonts

2009-09-28 Thread Mark Phillips
On Sun, Sep 27, 2009 at 5:20 PM, NoOp gl...@sbcglobal.net wrote: On 09/27/2009 12:50 PM, Mark Phillips wrote: I have OO v3.1.3 running on Debian testing. I need to install some Chemistry fonts - in particular ChemSanSerif.TTF and ChemSerif.TTF. I downloaded the fonts to my user

Re: [users] Re: Need Help Adding Fonts

2009-09-28 Thread Mark Phillips
On Mon, Sep 28, 2009 at 12:13 PM, NoOp gl...@sbcglobal.net wrote: On 09/28/2009 08:10 AM, Mark Phillips wrote: On Sun, Sep 27, 2009 at 5:20 PM, NoOp gl...@sbcglobal.net wrote: On 09/27/2009 12:50 PM, Mark Phillips wrote: I have OO v3.1.3 running on Debian testing. I need to install some

[users] Need Help Adding Fonts

2009-09-27 Thread Mark Phillips
I have OO v3.1.3 running on Debian testing. I need to install some Chemistry fonts - in particular ChemSanSerif.TTF and ChemSerif.TTF. I downloaded the fonts to my user directory, and then ran spadmin. I wen through the font adding ritual, but when I get to the part where I select the two font

[users] A Spreedsheet Question

2009-03-24 Thread Mark Phillips
How do I convert text in one cell into a reference to a particular sheet and use that reference to get the data from a cell in that sheet? I am using OO 2.4.1 on Debian testing. My use case: I have a spreadsheet with many data sheets (tabs), each with a date for the label - i,e, March 24 or April

Re: [users] Re: Need help changing versions of openoffice

2008-04-02 Thread Mark Phillips
Thanks - it all worked after removing the debian version and installing the oo version. Mark On Tue, 2008-04-01 at 17:32 -0700, NoOp wrote: On 04/01/2008 10:32 AM, Mark Phillips wrote: I installed Openoffice 2.2.1 from the Debian web site (I am running lenny). It seems that many

[users] Need help changing versions of openoffice

2008-04-01 Thread Mark Phillips
I installed Openoffice 2.2.1 from the Debian web site (I am running lenny). It seems that many of the database functions don't work in this version, and this is the latest version on the Debian web site. I tried them (downloading the mysql connector, but can't connect, and if I use a spreadsheet

[users] Need Help with Chart Legends

2007-11-01 Thread Mark Phillips
I am using OO v 2.2.1 on Debian Lenny. I have a massive spreadsheet and I need to extract certain cells into some bar charts. So far, I can do that, except I cannot seem to edit the legend text - it comes up as row 12, row 18, etc. Is there anyway to edit this text so I can give the labels some

Re: [users] Need Help with Chart Legends

2007-11-01 Thread Mark Phillips
On Thu, 2007-11-01 at 22:46 +, Brian Barker wrote: At 14:36 01/11/2007 -0700, Mark Phillips wrote: I am using OO v 2.2.1 on Debian Lenny. I have a massive spreadsheet and I need to extract certain cells into some bar charts. So far, I can do that, except I cannot seem to edit the legend

Re: [users] Re: Need Help with a Regular Expression

2007-09-22 Thread Mark Phillips
On Friday 21 September 2007 09:44, Joe Smith wrote: Mark Phillips wrote: I am using Dcount() to count the occurrences of some strings in a spreadsheet in OpenOffice Calc 2.0.3. I am using a regular expression to find the string I want. ... ... is there a way to modify my regular

Re: [users] Need help with bullets and tabs

2007-09-12 Thread Mark Phillips
On Tuesday 11 September 2007 18:59, Brian Barker wrote: At 17:37 11/09/2007 -0700, Mark Phillips wrote: How can I set up a decimal tab for a numbered list? In other words: I. Some text II. Some more text III. More text IV. More text

Re: [users] Need help with bullets and tabs

2007-09-12 Thread Mark Phillips
the paragraph style (in the numbering tab). Make sense? Yell if that's not enough to set you on the right track. - Naomi Mark Phillips wrote: How can I set up a decimal tab for a numbered list? In other words: I. Some text II. Some more text III. More text

[users] Need help with bullets and tabs

2007-09-11 Thread Mark Phillips
How can I set up a decimal tab for a numbered list? In other words: I. Some text II. Some more text III. More text IV. More text So all the periods line up? Thanks! -- Mark -

[users] Problems with Mail Merge

2007-04-25 Thread Mark Phillips
I am using OO v 2.0.3 on Linux (Debian). I want to do an email merge with an html email document. I have 2 fields in a spreadsheet - a name, and email address, and a unique member_id for each name. The unique member+id goes into a link to a web page like this: a

Re: [users] Toolbars keep popping up!

2006-11-11 Thread Mark Phillips
On Friday 10 November 2006 17:14, Fred Moore wrote: On Friday 10 November 2006 6:35 pm, Terry wrote: Mark Phillips wrote: I just started using OO 2.0.3 and different formatting toolbars keep popping up as I work in a document. I have to close the toolbar before I can access

Re: [users] Toolbars keep popping up!

2006-11-11 Thread Mark Phillips
in either the help files or this list. With that said, at the end of the day, everyone needs to find the tool that best fits their needs. What word processor fits your needs better than Writer? Cheers, and thanks for your post! -- Mark Phillips [EMAIL PROTECTED] 602 524-0376 cell 480 945-9197 fax

[users] Toolbars keep popping up!

2006-11-10 Thread Mark Phillips
I just started using OO 2.0.3 and different formatting toolbars keep popping up as I work in a document. I have to close the toolbar before I can access the document again. How the heck do I stop these toolbars from popping up? It is really annoying! Thanks! -- Mark Phillips [EMAIL PROTECTED

[users] How do I remove duplicates in a spreadsheet?

2006-01-08 Thread Mark Phillips
such as don't forget registration is on Jan 21. -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] Re: Re: How do I get OO v2 documents to open when double clicked?

2005-12-27 Thread Mark Phillips
provide! Mark On Monday 26 December 2005 07:16 pm, Matej Cepl wrote: Mark Phillips wrote: Can you send me the OO 2.0 entries that correspond to the entries above for OO 1.0? application/vnd.oasis.opendocument.text odt application/vnd.oasis.opendocument.text-template ott application

Re: [users] Re: Re: Re: How do I get OO v2 documents to open when double clicked?

2005-12-27 Thread Mark Phillips
the problem - I am now back with KDE! Thanks tons! I will try the file associations for OO 2.0 tomorrowwith a lot more care this time! Thanks again!! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax

[users] How do I get OO v2 documents to open when double clicked?

2005-12-26 Thread Mark Phillips
I just upgraded to openoffice 2.0 and when I double click on .odt files they are not opened automatically as my version 1.0 files did. How do I associated .odt files with openoffice? I am running Debian Linux with KDE 3.3. Thanks! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED

Re: [users] Re: How do I get OO v2 documents to open when double clicked?

2005-12-26 Thread Mark Phillips
me the OO 2.0 entries that correspond to the entries above for OO 1.0? Thanks! Mark On Monday 26 December 2005 03:50 pm, Matej Cepl wrote: Mark Phillips wrote: I just upgraded to openoffice 2.0 and when I double click on .odt files they are not opened automatically as my version 1.0 files

Re: [users] Need help getting data into Avery labels

2005-12-22 Thread Mark Phillips
] For additional commands, e-mail: [EMAIL PROTECTED] -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Need Help with Mail Merge

2005-12-22 Thread Mark Phillips
line. However, not all the addresses need two lines. If a record in the database has a null for addr_2, then I don't want a blank line on the label. How do I tell OO to skip the field if it is null? Thanks -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax

[users] Need help getting data into Avery labels

2005-12-21 Thread Mark Phillips
the table. Any suggestions would be greatly appreciated. Oh, BTW I am not an evil junk mail marketer - this little project is for my wife to keep track of her Christmas card mailing! Thanks! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax

Re: [users] Need help getting data into Avery labels

2005-12-21 Thread Mark Phillips
! - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax - To unsubscribe, e-mail: [EMAIL PROTECTED

[users] Need Help installing 2.0

2005-12-20 Thread Mark Phillips
also looked on the backports website, and nothing jumped out at me as well. I searched the openoffice site and could not find references that said - get the documentation here! Thanks! -- Mark Phillips Phillips Marketing, Inc [EMAIL PROTECTED] 602 524-0376 480 945-9197 fax

Re: [users] Re: Need Help installing 2.0

2005-12-20 Thread Mark Phillips
Matej, Thanks - it worked just fine! How do I set up sources.list to make sure I get updates for this file? Thanks! Mark On Tuesday 20 December 2005 01:17 pm, Matej Cepl wrote: http://packages.debian.org/unstable/doc/openoffice.org-help-en-us -- Mark Phillips Phillips Marketing, Inc [EMAIL

[users] Need help extracting a range of cells from a spreadsheet

2005-03-09 Thread Mark Phillips
I have a master softball schedule in a spreadsheet with columns labeled: GameID DateTime Division Field HomeTeam VisitorTeam I need to extract all the rows for a certain division and team (which can appear in either the HomeTeam or VisitorTeam column) to another spreadsheet so I