[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 spe

[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 [ +s

[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 y

[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: 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 SP3).

[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 chara

[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 to

[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 keyboard

[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: 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 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 the numbering. I

[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 i

[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

[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 a

[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 tha

[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: 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.

[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' cha

[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 fo

[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 ma

[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

[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; I

[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 f

[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: 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: http://qa.openoffice.org

[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 elem

[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 ch

[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 th

[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 ann

[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 show

[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 mine)

[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

[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 Adams 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". Perhaps someone else wou

[users] Re: Default tab stops

2009-10-19 Thread Joe Smith
d 2009.10.19 11:54 -0500, Joe Smith wrote: > >> The concept of "default tab stops" or "tab at every half-inch" are >> only supported at the application level, not per paragraph, and you >> will do well to avoid them in any case. >> ... >> Setting a

[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 ou

[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 Elliott 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 (border) around it: ... ... Whe

[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 run

[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 > Tem

[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, the

[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 y

[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 and

[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: http://www.martnet.com/~jes

[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 avai

[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 l

[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: OOwriter equivalent of html 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 paragra

[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] 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 an

[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: 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 convi

[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. Sorry,

[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 wo

[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 To

[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 ";" replac

[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 numeri

[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 n

[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: 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.

[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 =MROUND(H7*24;0.0

[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 mast

[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 ac

[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. http://www.martnet.com/~jes/temp/quarter_p

[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 the

[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 c

[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: 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 wh

[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 d

[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 c

[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: 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 lumped

[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 ad

[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 for

[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 repli

[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." ... 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: 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"

[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

[users] Re: date&time 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 http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_D

[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 men

[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 OOo

[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 tell

[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: 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 Res

[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 i

[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 $TARGET_DIR

[users] Re: Draw dividing a foot into 12 inchs

2006-11-25 Thread Joe Smith
Steve King wrote: ... How do I change the settings so that it takes 12 clicks to move 1 foot? The arrow keys have nothing to do with any scale or grid settings. AFAIK, they move by a fixed #pixels and so move a distance that varies with the inverse of the viewing zoom. I believe you will f

[users] Re: Turning off ALL auto formatting in OO 2.0.4?

2006-11-25 Thread Joe Smith
[EMAIL PROTECTED] wrote: ... moved to the "AutoFormat" option, and unchecked "While typing", ... This did not help. ... OO is trying to be helpful, but is instead greatly hindering the process of transcribing my thoughts. ... If Format > AutoFormat > While typing is unchecked, and OOo is sti

[users] Re: 2.0.4 has lost keyboard input for special characters

2006-11-25 Thread Joe Smith
Neil Redgate wrote: ... Therefore I think 2.0.4 has lost the ability to recognise this keypad combination. ... Same here (2.0.4 on Fedora). Filed as Issue 69468: http://qa.openoffice.org/issues/show_bug.cgi?id=69468 Doesn't seem to be much interest in even acknowledging it, much less fixing

[users] Re: OO Draw on I-mac Intel How to print the same scale I select onscreen.

2006-11-27 Thread Joe Smith
Steve King wrote: ... How do I set the program to print an inch if I draw an inch? What happens now? At least for me, with 2.0.2 on Fedora Linux 5, if I draw a 3" square, I get a 3" square on paper as well. Make sure you have any scaling options turned off in both the OOo and the system pr

[users] Re: Font for Greek Letters in Formula

2006-11-28 Thread Joe Smith
Rick Bilonick wrote: > I don't want to use MS Word at all but I do want my OOo documents converted correctly to a .doc file that will be viewable in MS Word. ... Any word processor document format is a poor choice for distribution: they depend too much on external resources (fonts, locale, li

[users] Re: Bug regarding Bullet styles

2006-11-28 Thread Joe Smith
Christof Schmidt wrote: ... There is no way to alter the standard behaviour that OpenOffice.org 2.0 has when setting the bullets style and other formats of a list. ... Yes. There is an active issue that should resolve the default bullet size in the near future: http://qa.openoffice.org/issue

[users] Re: Font for Greek Letters in Formula

2006-11-28 Thread Joe Smith
Rick Bilonick wrote: ... Unfortunately they would all choose to use MS Word so I'm not keen on suggesting it. ... Hey, I sympathize. Make your case for everyone using OOo; ask them to pitch in and buy you MS Office if that's what they want to use, or a better computer so you can run Windows v

[users] Re: Reporting mistakes in documentation

2006-11-28 Thread Joe Smith
Terry wrote: Tony wrote: Where is the best place, or what is the best way, to report typos etc. in user_guide2_draft.pdf? Probably, file an issue, the component being "documentation". Where did you get the PDF file? Right on the OOo manuals page (http://documentation.openoffice.org/manuals

[users] Re: Font for Greek Letters in Formula

2006-11-29 Thread Joe Smith
Rick Bilonick wrote: ... When I specify "Symbol", the actual symbol displayed looks different from both OpenSymbols and Standard Symbol L. When I do this, the symbols show up OK in MS Word. If I use OpenSymbols or Standard Symbol L then they don't show up in text. It sounds like both OOo and Wo

[users] Issuezilla: Any documentation on regular expressions?

2006-11-29 Thread Joe Smith
In Issuezilla (http://qa.openoffice.org/issues/query.cgi): I would like to search for issues related to tab stops. If I search for 'tab' as a word/string, I get a gazillion hits that deal with 'table's. I would like to specify that 'tab' must appear as a word by itself, however neither of the

[users] Re: Font for Greek Letters in Formula

2006-11-29 Thread Joe Smith
Rick Bilonick wrote: When I specify "Symbol", the actual symbol displayed looks different from both OpenSymbols and Standard Symbol L. When I do this, the symbols show up OK in MS Word. If I use OpenSymbols or Standard Symbol L then they don't show up in text. Ok, I had access today to an XP sy

[users] Re: Font for Greek Letters in Formula

2006-11-30 Thread Joe Smith
Rick Bilonick wrote: ... Thanks. But I don't understand what you mean by "unicode code points." Could you give me a concrete example for one symbol? Sorry, I meant to do that. A "code point" is just the index assigned to a particular glyph. In ASCII (and Unicode) the letter 'a' is assigned t

[users] Re: Problem with the property "Repeat Heading" in a Writer table

2006-11-30 Thread Joe Smith
[EMAIL PROTECTED] wrote: ... If I create a table and set that property on the first row, when I save the file as Rich Text Format (RTF), that property is lost. ... Any suggestions? Uh, don't use RTF? Add a vote for Issue 55088 http://qa.openoffice.org/issues/show_bug.cgi?id=55088

[users] Re: DOCKED TOOLBARS

2006-12-01 Thread Joe Smith
Pramathesh Ambasta wrote: I don't want toolbars to suddenly appear, sensing the context. I want toolbars to be docked always (unless I choose to make them float). How do I enable this? Short answer: you can't. You can inactivate a toolbar using View > Toolbars: if the toolbar has no check-mar

[users] Re: Conditional Formatting in Calc

2006-12-03 Thread Joe Smith
mpkirby wrote: ... I want the text in a cell to be red if the value in it is more than 10% over the value in the neighboring cell. ... Suggestions? ... First you have to define a named style. You can format a cell as you want it to look, then use the Stylist (F11) to define a style from the

  1   2   3   4   >