[users] Re: Sections

2010-11-28 Thread Joe Smith
On 11/28/2010 11:03 AM, Harold Fuchs wrote: I've read some of the documentation on Sections in OOo Writer but I've decided I don't understand the thinking behind them. Perhaps some would explain it to me: If I create a new blank Writer document, type a few lines and then insert a section, a few

[users] Re: increased line spacing when applying bullets - why?

2010-06-21 Thread Joe Smith
On 06/10/2010 04:23 AM, Cor Nouws wrote: Hi all, Maybe someone here knows why the line spacing is increased when bullets are applied? ... I've been working (off on) at something of a howto on OOo Writer's lists. Here's the section that I did for this problem:

[users] Re: Removing space from Writer formula

2010-06-21 Thread Joe Smith
On 06/21/2010 08:17 AM, Dotan Cohen wrote: In the following Writer formula there exists a space between the %mu and the m (for micrometers): d_0.95 = 20 %mu m How can the user remove the space? With the upcoming release (3.3, or the developer snapshots leading up to it), a new command is

[users] Re: increased line spacing when applying bullets - why?

2010-06-21 Thread Joe Smith
On 06/21/2010 04:18 PM, John Kaufmann wrote: In a message dated 2010.06.21 09:53 -0500, Joe Smith wrote: Maybe someone here knows why the line spacing is increased when bullets are applied? ... I've been working (off on) at something of a howto on OOo Writer's lists. Here's the section

[users] Re: doubling up a table?

2010-03-12 Thread Joe Smith
On 03/12/2010 04:35 PM, McLauchlan, Kevin wrote: OOo 3.2 on Windows XP Pro X64 I have a small document that includes a narrow 2-column table, consisting of a heading row and 54 rows of content. I wanted to make the table double-wide and bring the lower 27 rows up to occupy the new columns 3

[users] Re: Bracketing List Items Together

2010-03-08 Thread Joe Smith
On 03/08/2010 04:29 AM, Harold Fuchs wrote: In Writer (3.1.1 currently), how can I bracket two or more list-items together with a large curly brace placed at the *right* of the longest item? Thus: List item 1) List Item Number 2 ) This text refers to all three items This

[users] Re: Bracketing List Items Together

2010-03-08 Thread Joe Smith
On 03/08/2010 02:20 PM, Harold Fuchs wrote: Thanks; where do I get the curly bracket graphics from? Or is there an easy way to make them? How, please? Look on the Drawing toolbar, under Symbol Shapes. You may need to activate the Drawing toolbar in Writer: View Toolbars Drawing. If

[users] Re: Do different versions of OO.o do number formats differently???

2010-02-01 Thread Joe Smith
On 01/29/2010 05:18 AM, Joe(theWordy)Philbrook wrote: It would appear that on Jan 29, Brian Barker did say: At 12:13 28/01/2010 -0500, Joe(theWordy)Philbrook wrote: It drives me to distraction whenever my date is converted from: 11:20 am to 11:20:00 AM ... If I understand you correctly,

[users] Re: Issue 77811

2009-11-25 Thread Joe Smith
On 11/24/2009 07:25 PM, JOE Conner wrote: ... What I want to be able to do is import a style and incorporate it within my own new document (F-11) dropdown list of styles. ... It would be nice if the Load Styles function was available for Calc, but you work around the problem using File

[users] Re: Pictures inside frames - Anchor To Frame

2009-11-08 Thread Joe Smith
On 11/07/2009 03:55 AM, John Kaufmann wrote: ... Border is not an independent entity from Area; on the contrary, Paragraph area is bounded by the paragraph borders, and Page area is bounded by the page borders. because the selection set is not orthogonal, the model doesn't compute; it runs into

[users] Re: Draw and Text Boxes.?

2009-10-23 Thread Joe Smith
On 10/23/2009 03:58 AM, Harold Fuchs wrote: 2009/10/23 James Elliottjames.elli...@wn.com.au A question on Text Boxes ... ... oops! ... the whole text box has disappeared, gone, along with all my carefully selected margins ... poof! - gone! ... When you create the text box, put a line

[users] Re: Writer user guide update to OOo 3.2 - use of arbitrary paragraph styes for outlining

2009-10-20 Thread Joe Smith
On 10/20/2009 08:15 AM, Michele Zarri wrote: Hello All, As the subject states, I am in the process of updating the Writer user guide (www.oooauthors.org) to include some new features introduced since OOo 3.0. At present I am looking at the capability of allocating to a paragraph style its own

[users] Re: Default tab stops

2009-10-19 Thread Joe Smith
On 10/19/2009 04:07 AM, Harold Fuchs wrote: 2009/10/19 Michael Adamsmbad...@paradise.net.nz Had a little trouble setting default tab stops in writer today. I wanted to set them for one paragraph only, ... ... The only thing I can't find a way to do is to specify, for example every 1/2 inch.

[users] Re: Default tab stops

2009-10-19 Thread Joe Smith
On 10/19/2009 02:35 PM, John Kaufmann wrote: Joe, I've learned that you think about these things at a pretty deep level, so I try to make sure I understand the nuances... I'm no expert, by any means; I'm just interested in using OOo effectively. In a message dated 2009.10.19 11:54 -0500, Joe

[users] Re: Annotating a structured list

2009-10-06 Thread Joe Smith
On 10/06/2009 02:36 AM, John Kaufmann wrote: ... ...OO's handling of a hierarchical list changes depending on whether the list has some level-indicating character (numbers, letters, bullets, ...) or whether 'None' is selected in the style Options Numbering. In the latter case, which is used in

[users] Re: Annotating a structured list

2009-10-05 Thread Joe Smith
On 10/05/2009 02:03 AM, John Kaufmann wrote: ... ... I don't understand what you mean by 'hierarchical', beside outline-style indentation, which is still there when I view it. So sorry - that question came from first viewing your example in OO 2.2, which is what was on the computer (not

[users] Re: Annotating a structured list

2009-10-02 Thread Joe Smith
On 10/02/2009 12:56 AM, John Kaufmann wrote: ... In WordPerfect, even with such a structured list (what WordPerfect calls an Outline), one can Indent after any list member to a common point on the line, as shown above. I have been wasting a lot of time trying to see how to do this kind of

[users] Re: Annotating a structured list

2009-10-02 Thread Joe Smith
On 10/02/2009 02:35 PM, John Kaufmann wrote: In a message dated 2009.10.02 13:20 -0500, Joe Smith wrote: In WordPerfect, even with such a structured list (what WordPerfect calls an Outline), one can Indent after any list member to a common point on the line, as shown above. I have been wasting

[users] Re: Paragraph with enclosed list

2009-09-26 Thread Joe Smith
On 09/26/2009 03:20 AM, John Kaufmann wrote: Let me digress to ask what should be a basic question ... ... Is that the way it is supposed to be done? That looks about right. In this case, I think there's actually another step. When you Insert Frame, then apply a frame style that changes

[users] Re: Paragraph with enclosed list

2009-09-25 Thread Joe Smith
On 09/25/2009 08:03 AM, John Kaufmann wrote: ... What is desired is that a paragraph with embedded list look overall like a paragraphs without embedded list. This means, for example, that between the list description and list elements there be no end-of-paragraph spacing, while the last list

[users] Re: Paragraph with enclosed list

2009-09-25 Thread Joe Smith
On 09/25/2009 10:58 PM, John Kaufmann wrote: ... - I can make the frame, and put the list in it; so far, so good. - I can anchor the frame to a character - but which character to make it stay where is belongs, ... The anchor is _as_ character, not _to_ character. An object anchored as

[users] Re: Draw: polygon crop

2009-09-17 Thread Joe Smith
On 09/17/2009 02:42 PM, L Duperval wrote: ... I want the cropped picture to appear inside the polygon. ... Place a copy of the polygon over the image, and do Modify Shapes Intersect. This does not do a true clipping of the image by the polygon (see Issue 104035:

[users] Re: Alternate Font Source

2009-09-07 Thread Joe Smith
On 09/07/2009 01:56 AM, Joseph A Nagy Jr wrote: ... Is there any way in the configuration that I could specify (and have OOo reliably read) an alternate font directory?... Check in the OOo section under the Start menu for something called spadmin. If it's not there, you'll have to run it from

[users] Re: Alternate Font Source

2009-09-07 Thread Joe Smith
On 09/07/2009 12:39 PM, Joseph A Nagy Jr wrote: ... I've encountered a problem. That program isn't there. ... Ugh. Did you try a file search for it? It's not normally needed anymore, and I know there was some discussion of phasing it out altogether, but it's still distributed with the Linux

[users] Re: Calc: Array Problem

2009-08-31 Thread Joe Smith
On 08/31/2009 06:49 AM, Karti wrote: Dear Joe, Thanks for the clarification. Is it possible to translate this http://www.cpearson.com/excel/betternetworkdays.aspx in calc? Sorry, that's more than I can get into right now. There are some basic things there that don't even look familiar to me;

[users] Re: Calc: Array Problem

2009-08-28 Thread Joe Smith
On 08/28/2009 07:16 AM, Karti wrote: Hi, The following formula works perfectly in Excel but it does not work in Calc. {=Row(1:12)} Also the following doesn't work in Calc, {=Row(Indirect(1:12))} ... You can use =ROW(A1:A12) or =ROW(INDIRECT(A1:A12)); they should work in Excel as well. You can

[users] Re: Write: How to manage Sections?

2009-08-26 Thread Joe Smith
On 08/26/2009 06:15 AM, Alex Zachopoulos wrote: I have this Write file which I am putting together, and I would like to keep it organized with Sections, so that I can apply different settings to each section, such as page borders, headers footers etc. ... I am trying to figure out how I can

[users] Re: Calc: Empty Cells

2009-08-15 Thread Joe Smith
On 08/15/2009 01:23 AM, Tamblyne wrote: I'm trying to copy certain cells from one sheet to another. If the first cell is empty, I want the second cell to be empty, too, ... Testing for empty cells can be a real mess, because there are various degrees of emptiness and the means of testing for

[users] Re: Vlookup

2009-07-04 Thread Joe Smith
On 07/04/2009 12:36 AM, NoOp wrote: ... So he sent me both files. Problem is that the vlookup spreadsheet has a hardcoded link to the user directory and instead of #NAME error, I get a Error:501 (Invalid character) Any chance that the file path on the original system contains a 'funny'

[users] Re: Row number of last non-blank cell in column?

2009-06-24 Thread Joe Smith
On 06/24/2009 01:31 PM, Mark Knecht wrote: Hi, I wonder if anyone knows of a function I might use to find the row number of the last non-blank cell in a column? ... Try =MAX(NOT(ISBLANK(A1:A65536))*ROW(A1:A65536)) as an array formula--use Ctrl+Shift+Enter to enter the formula. Joe

[users] Re: OOo Writer: saving and opening documents

2009-06-23 Thread Joe Smith
On 06/23/2009 05:16 AM, AG wrote: ... I suppose another issue is the length of time it takes to autosave: with 3Gb of RAM and a further 3Gb allocated to my swap partition, one would think that there'd be plenty of memory for OOo to use in the save process I can only guess, but I believe

[users] Re: Impress: animate text box

2009-06-23 Thread Joe Smith
On 06/23/2009 08:12 AM, Dotan Cohen wrote: A non-techie user wants to start using Impress to make slides for his presentations. Until now he has been making .bmp slides in Paint! He wants to know if Impress can animate a slide like this: ... ... if someone could say yes, this is possible that

[users] Re: OOo Writer: saving and opening documents

2009-06-22 Thread Joe Smith
On 06/19/2009 06:50 AM, AG wrote: ... How do I set it up so that when I open a document it defaults to opening it at the place I last worked on - i.e. the end of the document? OOo Writer tries to be smart here: if the document is opened by its author, the editing cursor and view are restored

[users] Re: Problem extracting the hour from a cell

2009-05-19 Thread Joe Smith
John Meyer wrote: ... I am trying to extract the hour from a cell and put it into a second column, but when I use the HOUR() function all it returns is 12:00:00 AM This is a little tricky. Times in a spreadsheet are stored internally as fractions of one day. So all times, and all the times

[users] Re: Problem extracting the hour from a cell

2009-05-19 Thread Joe Smith
Joe Smith wrote: ... Strangely, Calc chooses to display the result as if it were a time instead of just a normal decimal value. ... Oops, my bad. It's not Calc's fault at all. The original spreadsheet had formatted the result as a time, thus the integer results displayed as a time 12:00:00

[users] Re: Inserting a list number in another location in a document

2009-04-10 Thread Joe Smith
Timur Tabi wrote: On Thu, Apr 9, 2009 at 11:21 AM, Joe Smith j...@martnet.com wrote: ... You can also copy/paste any of the paragraphs from the list to another location and it will retain its identity as part of the original list. That does not work. When I paste the text, it does include

[users] Re: Inserting a list number in another location in a document

2009-04-09 Thread Joe Smith
Timur Tabi wrote: ... The trouble I'm having is inserting LX4. There does not appear to be a way to directly insert that LX4 into a new block of text. You can use the Format Painbrush from the toolbar to mark a paragraph as part of an existing list. With the editing cursor in the existing

[users] Re: oocalc howto swich display formula/value

2009-04-02 Thread Joe Smith
Alain Baeckeroot wrote: I need to often switch my display from formula to value... Is there a way to add a button for this in one toolbar, or defined a keyboard shortcut ? According to the help, it's available as Ctrl+` (that's a back-quote; the leftmost key on the number row--on US

[users] Re: Dates In Calc

2009-03-31 Thread Joe Smith
JOE Conner wrote: Dave Barton wrote: ... Format an empty Calc cell with an ISO 8601 date format (ie. -MM-DD) and then type, or paste, a date in US format (ie. MM/DD/) into the cell and the date is displayed as entered. Reformatting the cell after the date is entered does not change it

[users] Re: Calc font questions

2009-03-27 Thread Joe Smith
Eustace wrote: ... Yes but in the Writer the bold font looks OK. I don't see why it shouldn't in Calc. It seems to me that they only have to replace the revelant code of the Calc with that of the Writer... For me, both Writer and Calc show the same problem with Lucida Console: the bold

[users] Re: Calc font questions

2009-03-26 Thread Joe Smith
Brian Barker wrote: At 22:09 25/03/2009 -0400, Eustace Fril wrote: OOo3 Calc: I have set as default font (template) for OOo Lucida Console 12. In the Writer everything is OK, in the Calc however: ... You mean bigger sideways, don't you? Interesting. Happens for me, too (3.0.1, Win XP

[users] Re: Excel File Import into Calc

2009-03-20 Thread Joe Smith
S Perry wrote: ... I checked line by line. They LOOKED the same. I then inserted a new column and subtracted the second result from the first, expecting 0, row by row. Instead, the result was the value that appeared in both cells... most of the time. ... It's hard to be sure without having

[users] Re: Excel File Import into Calc

2009-03-20 Thread Joe Smith
Gene Young wrote: Joe Smith wrote: ... Note: The cell format does not determine whether a cell holds a numeric value or a text value. That is determined by Calc's examination of the data when it is entered, and /nothing/ after will change its value type. Actually you can change

[users] Re: Need help with formula syntax

2009-03-10 Thread Joe Smith
John Jason Jordan wrote: ... I finally got it to work with this syntax: left lbrace alignl stack {`left [ +approximant right ]~___ X_0~]rsub stem # `left [ +nasal right ]~___ X_0~]rsub stem # `left [ binom {+syllabic} {+front} right ]~___ X_0~]rsub stem # ` {___ _stem left [ +syllabic right

[users] Re: Bug?

2009-03-09 Thread Joe Smith
JOE Conner wrote: ... It seems to me that the Open Document format specifications should have nailed the format down precisely. Otherwise, the document can not fully portable. The ODF Formula specification specifies the semicolon as the function argument separator. However, the syntax

[users] Re: OOo3 non-root install

2009-02-09 Thread Joe Smith
andrew.m.g...@l-3com.com wrote: I'm trying to install OpenOffice.org 3.0.1 without root access, but it isn't working for me, not without some extreme hackery. ... I am using CentOS 4.7. Root is not available to me. Do you need to use rpm? This produced a runable OOo for me: $ (cd

[users] Re: Address Labels have the wrong page size.

2009-02-07 Thread Joe Smith
NoOp wrote: ... I reckon that someone should file a bug. Search in the bug database shows some issues back in 2003, but nothing recent that I can find. A search of Writer issues with 'label page size' in the summary gave these (and a few other similar ones): Avery Letter Size 5160 Label

[users] Re: [Impress] Is it possible to have a link to page 8 of presentation from page 16 and vice versa?

2009-02-07 Thread Joe Smith
Michele Zarri wrote: ... There are two ways to achieve this. ... There is one other way: insert the repeated slide as a link 1) File Save 2) Insert File, then choose the same file as the current document 3) Select the slide you want to repeat from the list 4) Make sure the Link options is

[users] Re: Two decimal numbers added give non two decimal number... bug?

2009-02-05 Thread Joe Smith
Ely Schoenfeld wrote: ... I was already trying to fix the problem using ROUND in some places, like multiplications and divisions, but I steel had differences in my calculation (bigger than 0.01) at the end. Now I see that I have to add round to some places that I didn't thought to. ... You may

[users] Re: A little discussion on Calc and empty cells

2009-02-03 Thread Joe Smith
Ambrogio De Lorenzo wrote: ... So I expect that if I use sumif(A1:A5;;B1:B5) should sum values in B1:B5 only if the corresponding cells in column A is empty. ... It is true that OOo3 has changed the way empty cells are handled, but your situation is not a result of that (as far as I can

[users] Re: Using unicode from keyboard

2009-01-29 Thread Joe Smith
John Jason Jordan wrote: ... To find the Unicode number for a character go to Insert Special Character and browse through all the characters until you find the one you need. ... You may want to take a look at the standard Character Map application; it's under Accessories in the desktop menu

[users] Re: Dots in horizontal center of page

2009-01-29 Thread Joe Smith
Dotan Cohen wrote: I have a page with two columns that I must physically print and cut down the vertical middle. Therefore I would like to print a dot in the horizontal center top of the page and another in the horizontal center bottom of the page. I cannot find any facility for doing this in

[users] Re: datetime in one field

2009-01-21 Thread Joe Smith
Brian Barker wrote: ... Date and time values are stored in Calc as fractional numbers of days; they display as they do only because of the cell formatting. ... Along with Brian's nice explanation, you may want to bookmark

[users] Re: Calc Challenge, Average using an array lookup not working...

2009-01-12 Thread Joe Smith
Rogier van Vlissingen wrote: Well, you got me experimenting, but this isn't it yet, but I did some editing to clarify the problem: ... On Sun, 11 Jan 2009 16:29:31 -0500, Erik Remmelzwaal ... I assume that your lookups return both corner coordinates of the array as a string like B2 and C5 You

[users] Re: Calc Challenge, Average using an array lookup not working...

2009-01-12 Thread Joe Smith
Joe Smith wrote: ... For a sample sheet, see http://www.martnet.com/~jes/temp/range_select_example.ods Or, editing your attached sample: http://www.martnet.com/~jes/temp/EverGreen_576E165_ECR+evalV0.50_edit.ods Joe

[users] Re: How do you merge to a directory

2009-01-07 Thread Joe Smith
Barbara Duprey wrote: S Perry wrote: This is also called in MS Word a catalog. ... snip OOo's mail merge has this kind of capability ... once you create a table with the fields inserted from the database, and with the final cell of the row ending with the next record field, it should fill in

[users] Re: How do you merge to a directory

2009-01-05 Thread Joe Smith
Brian Barker wrote: At 17:30 04/01/2009 -0800, Allan Abrahamse wrote: How do I use openoffice writer to create a directory ... I don't know that you can use Mail Merge in this way - at least, not directly. Here is a slightly messy workaround, ... I have also just used copy/paste to

[users] Re: copying a single cell array formula by dragging it down

2008-12-10 Thread Joe Smith
Ken Jolliffe wrote: I have written a simple single cell array formula but when I drag it down to copy to the cells below the relative reference does not change ... Calc handles drag-fills of array formulas differently than normal formulas. It expands the area covered by the original array

[users] Re: WRITER: Search for Special Characters, Invisible Characters, Character Styles, Markers of Type X

2008-12-09 Thread Joe Smith
VLM TechSubs wrote: We are exploring the search (ctrl-f) function in Writer. We see how to search for many things, but not yet for special characters (em dash, ellipsis), invisible characters (end of paragraph and the like), character styles, or for, say, markers of a given type. You've

[users] Re: Formating Fields

2008-12-09 Thread Joe Smith
Bob Estes wrote: I have found a problem in formating input fields. ... Does anyone have any ideas on how to correct this problem? Yow. This task is a 'perfect storm' of things that Writer does badly. Here's a sample with two different approaches: - A two-column table with a calculation that

[users] Re: Determine version from command line

2008-12-02 Thread Joe Smith
James Montgomery wrote: ... I was hoping there was something as simple as ./soffice --version. Close: $ ooffice -help OpenOffice.org 2.4 680m18(Build:9364) ... $ ooo241 -help OpenOffice.org 2.4 680m17(Build:9310) ... This doesn't show the minor version number which is visible in the Help

[users] Re: WRITER: Neutral settings for Character Styles

2008-11-30 Thread Joe Smith
VLM TechSubs wrote: ... Is there a way to create character styles, such that only specified font properties are affected? Yes, although the user interface is awkward and there are some glitches which can make it difficult to manage effectively. In the Styles and Formatting dialog, with the

[users] Re: set date format as default

2008-11-15 Thread Joe Smith
Brian Barker wrote: ... But the claim I was trying to make still stands: that -MM-DD is easily available in OpenOffice, ... A matter of opinion, but I don't think easily is the appropriate adjective here. It's embarrassing that a task as simple and as common as inserting the current

[users] Re: Reducing complexity of formula in Calc

2008-11-11 Thread Joe Smith
Brian Barker wrote: ... If so, you can do this using an array formula. Enter this into your result cell: =SUM(C2:G2*(C2:G2-1))/(SUM(C2:G2)*(SUM(C2:G2)-1)) ... Nicely done! Just one pointless point: The numerator SUM(C2:G2*(C2:G2-1)) is equivalent to SUMPRODUCT(C2:G2;C2:G2-1) in

[users] Re: How to manually remove the lock on a file?

2008-11-04 Thread Joe Smith
Ulrich Becker wrote: ... But where is this lock information stored and how can I remove it? I prefer not to have that sort of leftovers in a hidden database ... To lock a document file named letter2mom.odt, Ooo 3 will create a lock file alongside the document called .~lock.letter2mom.odt#

[users] Re: [OOo Draw] Importing custom shapes

2008-10-15 Thread Joe Smith
Bart Friederichs wrote: Cor Nouws wrote: Bart Friederichs wrote (15-10-2008 14:28) I would like to extend the shapes I have in OOo Draw. I found already shapes in .odg files (http://lautman.net/mark/coo/index.html), but I cannot find how I could import them in my shape-toolbar. How do I get

[users] Re: [OOo Draw] Importing custom shapes

2008-10-15 Thread Joe Smith
Bart Friederichs wrote: ... You can add shapes to the Gallery from a drawing by drag drop, but you still have to do it one shape at a time. That doesn't seem to work. Could you be just a little more specific? ;-) Well, let me guess that OOo's slightly peculiar drag and drop interface is

[users] Re: Table formating: whole page

2008-10-12 Thread Joe Smith
Dotan Cohen wrote: Sorry for the delay. We have a new baby in the family! Yow! Congratulations! Here's a shot based on the linked sections document: http://www.martnet.com/~jes/public_html/temp/quarter_page.odt Quoth the server, 404. Arr. My duh.

[users] Re: Table formating: whole page

2008-10-10 Thread Joe Smith
Dotan Cohen wrote: I have a page that must be divided into four equal parts, two vertically and two horizontally (2x2). Is there a 'smart' way of doing this? I have tried all the table formating options that I could find and the best that I could do was to measure and set the width and height

[users] Re: Repeating data in OOo Writer

2008-10-07 Thread Joe Smith
Dotan Cohen wrote: ... How can I have [it] so that I can simply update one list and the others update automatically? ... One way would be to use the technique that Writer uses for label sheets. A section can get its contents through a link to another section. So you make one section the

[users] Re: Round of in Calc

2008-10-02 Thread Joe Smith
Erling Larsen wrote: ... This work fine but my problem is, that i need the second decimal to be either 0 or 5. Your calculation works, but it is more complicated than it needs to be. Calc always stores times as decimal values, but in days, not hours. All you should need is

[users] Re: Is there Calc function to chose variable from the table on the base of 2 search criteria in the first row and the column?

2008-09-29 Thread Joe Smith
Andis wrote: I'm looking if there is easy possibility to chose variable from the table, like in example below, ... Maybe something like this: =INDEX(RegData; MATCH(Height;RegHeights;1); MATCH(Species;RegSpecies;0)) The first MATCH produces the row number; the second the column. Joe

[users] Re: Conditional sum of products?

2008-09-22 Thread Joe Smith
Mark Knecht wrote: ... I need to get the sum of column 1 * column 2 but only when the value in column 1 is either negative or positive. Hmm, either negative or positive? SUMPRODUCT(A1:A5; B1:B5) will do that, since your condition is true for every number I can think of. If you mean only

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
Joe Smith wrote: James Elliott - WA Rural Computers wrote: When I saved a Calc spreadsheet in Excel format to send to my Accountant, the SUMPRODUCT formulas did not work because a Calc formula like this: =SUMPRODUCT(A1:A3000; B1:B3000) was converted to : =SUMPRODUCT(A1:A3000, B1:B3000) ie

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
James Elliott - WA Rural Computers wrote: ... So, in Calc (forget Excel) we can use either of these formats, can we?: =SUMPRODUCT(A1:A3000; D1:D3000=TEST) or =SUMPRODUCT((A1:A3000)*(D1:D3000=TEST)) Am I correct? Yes, I believe that is correct. Logical tests in Calc always produce numeric

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
James Elliott - WA Rural Computers wrote: ... ie. I made it read: =SUMPRODUCT(chqDEBIT,chqCODE=A13,chqDATE=$D$4,chqDATE=$D$5) and the formula no longer worked! The sumproduct total I had in that cell just disappeared - no error message, just no result. If you're working in Calc then you

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-18 Thread Joe Smith
James Elliott - WA Rural Computers wrote: When I saved a Calc spreadsheet in Excel format to send to my Accountant, the SUMPRODUCT formulas did not work because a Calc formula like this: =SUMPRODUCT(A1:A3000; B1:B3000) was converted to : =SUMPRODUCT(A1:A3000, B1:B3000) ie semicolons ;

[users] Re: Having trouble indenting text in documents.

2008-09-13 Thread Joe Smith
Jim Allan wrote: Joe Smith wrote: Also, it would be nice if Writer supported this as an actual list (a dictionary list in HTML). Writer provides no good way to sort the list, or even to manually re-order it. Highlight what you want to include in your list and then use Tools → Sort Each

[users] Re: Having trouble indenting text in documents.

2008-09-12 Thread Joe Smith
Jason Cipriani wrote: ... What is the most convenient way to format this document like above as I'm entering the text? Just a point of information, since others have already answered the question. Writer includes pre-defined styles for this: List Heading and List Contents. Also, it would

[users] Re: Customize Status bar

2008-09-08 Thread Joe Smith
emf wrote: ... I have style Heading 2 between 2 paragraphs. The style of the paragraphs is double spaced. I want to position the heading exactly between the end line of the first paragraph and the last line of the second paragraph. ... Thanks for trying to help me see how this works.

[users] Re: Customize Status bar

2008-09-07 Thread Joe Smith
emf wrote: How do I customize the Status toolbar (the one at the bottom of the window) in the OOWriter so that it will show the position of the cursor (Page, Line, Position on the line) like in WP? ... While I respect the fact that many people ask for this feature, I have yet to hear a

[users] Re: Using variables in Writer, specifically in the equation editor

2008-08-30 Thread Joe Smith
Dotan Cohen wrote: 2008/8/30 Michele [EMAIL PROTECTED]: Remember that you have to press F9 or Tools Update Fields to... guess what? update the fields :-) Fields are otherwise updated before you print, when you save the document and at some other events (maybe). I just discovered this one

[users] Re: OOo slows down on a page which has eps figure

2008-08-28 Thread Joe Smith
H.S. wrote: ... In conclusion, if an eps file with a preview is used in OOo, OOo does not slow down on the page which contains that file but also it retains the low res in the exported PDF file. Printing the document gives the right eps in the output though. This is the expected behavior. If

[users] Re: OOwriter equivalent of html p tag?

2008-08-21 Thread Joe Smith
Larry Evans wrote: ... Is there a way to just say I want another paragraph under the existing list item? Look on the Bullets and Numering toolbar, there's a button with the tooltip Insert Unnumbered Entry. You can also do this with the keyboard: when you type Return to start a new

[users] Re: Import TAB-delimited files into Calc

2008-08-21 Thread Joe Smith
Tim Johnson wrote: Hi: Have files with following format: First line: column names, delimited by TABs, no text qualifiers Following lines: cells delimited by TABS. I would like to import such a file into calc. ... For importing text data in Calc, I use and recommend this: 1) Insert Sheet From

[users] dependency failure for recent DEV300 rpm installs

2008-06-24 Thread Joe Smith
The last couple of OOo 3.0 snapshots have failed to install using my usual routine; I get an error like so (on Fedora 9): # cd DEV300_m20_native_packed-1_en-US.9318/RPMS # rpm -ivh --prefix=/mnt/extra/opt/DEV300_m20 *.rpm error: Failed dependencies: ooobasis3.0-calc is needed by

[users] Re: dependency failure for recent DEV300 rpm installs

2008-06-24 Thread Joe Smith
NoOp wrote: It's in the deb's as well. See: http://www.openoffice.org/issues/show_bug.cgi?id=90955 http://www.openoffice.org/servlets/ReadMsg?list=releasesmsgNo=12153 I'm downloading m21 now to see if it also has the problem. There is at least on OOo project member that doesn't believe this to

[users] Re: writer, table formulas: copy formulas as in scalc

2008-06-18 Thread Joe Smith
Uwe Brauer wrote: ... Does not work for me OO 2.3 on Linux Kubuntu. How are you doing this exactly? I'm using Fedora-packaged 2.4.1 but I don't remember ever noticing that formulas were not adjusted, nor can I find any issues recently fixed. I copy/pasted entire table cells, not just the

[users] Re: writer, table formulas: copy formulas as in scalc

2008-06-17 Thread Joe Smith
Uwe Brauer wrote: ... 5 6 sum(A3:B3) However although I can in writer define formulas in tables, this particular feature seems not to be implemented. ... Formula references are adjusted in Writer just as they are in Calc, however the formula syntax is quite different in Writer: the formula

[users] Re: Calc: Find lower of 2 numbers.

2008-06-09 Thread Joe Smith
Jerry Feldman wrote: ... something like =if(150 = $a$1;150;$a$1) ... =MIN(150;$A$1) Joe - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Re: keeping characters together

2008-05-27 Thread Joe Smith
Rolf Schumacher wrote: good news, Jim ... Jim Allan wrote: ... I cannot duplicate this problem in OpenOffice.org 3.0 Beta. That is when I type space followed by “/REF/” and, and then insert the letter “A” again and again before this, the “ /REF/” jumps to the next line as a unit. If I remove

[users] Re: keeping characters together

2008-05-27 Thread Joe Smith
Jim Allan wrote: Can’t duplicate this, if there is a space before the first slash. ... Maybe this screencast will clarify http://www.martnet.com/~jes/temp/OOo_word_wrap.ogg Apologies in advance if that's not viewable; just let me know. Joe

[users] Re: keeping characters together

2008-05-25 Thread Joe Smith
Rolf Schumacher wrote: ... How to tell Writer to keep the five letters together on one line? One workaround is to put the word in a frame. With no borders and no extra spacing, it can be made to work. Defining a frame style, and an AutoText for inserting them, can help a lot. Joe

[users] Re: How do I open .txt files in OO Writer?

2008-05-20 Thread Joe Smith
Jason Cipriani wrote: ... While that works, too, that's about as acceptable as opening the file in Notepad then copy + pasting it. File - Open isn't the kind of thing that should require a workaround at all. ... If you're using OOo Writer as a text editor (open text file, edit text, save

[users] Re: How do I open .txt files in OO Writer?

2008-05-19 Thread Joe Smith
Jason Cipriani wrote: ... Therefore it appears that OO Writer chokes (quite consistently on my system at least, I've been able to intentionally reproduce it 100% now) on text files with LF line endings under Windows, and for some reason attempts to open them in OO Calc instead (to rant, OO

[users] Re: Why does OOo need /proc?

2008-05-08 Thread Joe Smith
Michelle Konzack wrote: ... Problem: OOo need it! Question: Why? Why? is hard to say; what? is much easier: $ strace -o log ooffice -help OpenOffice.org 2.4 680m12(Build:9286) ... $ grep '/proc' log open(/proc/meminfo, O_RDONLY) = 3 open(/proc/meminfo, O_RDONLY) = 3

[users] Re: Why does OOo need /proc?

2008-05-08 Thread Joe Smith
Joe Smith wrote: ... $ grep '/proc' log open(/proc/meminfo, O_RDONLY) = 3 open(/proc/meminfo, O_RDONLY) = 3 open(/proc/meminfo, O_RDONLY) = 3 Oops--sent a few seconds too soon. Since /proc/meminfo is just ascii text, you could at least try replacing it with a static

[users] Re: Import/Export vs Open/Save ?

2008-04-15 Thread Joe Smith
Harold Fuchs wrote: ... Please, what is the difference between Open/Save on the one hand and Import/Export on the other? In OOo, the terms have very specific meanings--far more specific than the English words themselves. When OOo has program code that supports both reading and saving in a

[users] Re: Writer: Character Style Questions

2008-04-10 Thread Joe Smith
Scott Meyers wrote: ... I really do try to consult the documentation before posting, but I rarely find what I am looking for. Even now that I better understand what the Standard button on the paragraph and character style dialogs does, I can't find a description of it in the online help, the

[users] Re: Writer: Character Style Questions

2008-04-10 Thread Joe Smith
Scott Meyers wrote: Joe Smith wrote: The best resource I know of is the one you're using right now: user-to-user QA, either here, or one of the web forums: UCF: http://user.services.openoffice.org OOoForum: http://www.oooforum.org I read this list via the Gmane newsgroup interface, which I

  1   2   3   4   >