Re: [users] outline numbering - related to Outlining?
James wrote: > On 10/14/09 00:02, Barbara Duprey wrote: >> James wrote: >>> I'm having numbering problems. :-( >>> >>> lockie.ca/test/OOoutline.odt >>> >>> Highlight the first line and select the Heading1 style. >>> Second line gets Heading2. >>> Third line gets Heading1. >>> Fourth line gets Heading2. >>> >>> I want it to be numbered: >>> 1. >>> 1.1 >>> 2. >>> 2.1 >>> >>> but I get: >>> 1. >>> 1.1 >>> 2. >>> 1.2 >> >> If you go to Tools > Outline Numbering, Numbering tab, for a >> particular paragraph style and level, you can set "Separator after" >> as you want. I think that should do it for you. > > Thanks, the problem is the second level. > The problem will disappear when Outlining (like in M$Word since Word 7) is implemented. It is already a request that is 7 years old, but a stillbirth. http://www.openoffice.org/issues/show_bug.cgi?id=3959 (Opened: Wed Apr 10 19:39:00 + 2002) The outline numbering you are using now is a sad alternative to real outlining (and do not come with the Navigator as outliner!). See the long discussions in the feature request since Apr 10 19:39:00 2002. This is the only reason that many who need to write extensive outlined documents still remain with M$Word (with Wine on CrossOver Office). I became an older MacBook recently, and there are some software packages for outlining on Mac as well, but no outlining is available for Mac on OOo or NeoOffice (OOo branch for Mac) either. :-( Al
[users] OpenOffice 3.0.0 (9358): back it up or save data like Kbd shortcuts
Moving to Kubuntu Hardy. Would like to replace its standard version of OOorg 2.4 with my current 3.0.0. Is it possible to back it up and restore it into Hardy, or at least to somehow preserve things like my custom keyboard shortcuts? john herron _ Kubuntu 7.04 Feisty Fawn Linux 2.6.20-17 generic KDE 3.5.6 - OpenOffice v 3.0.0
[users] The page format is changed when use OOo 3.x to open the .doc file
Dears, I have many .doc files created by MS office 2003, I have table in the .doc file, now I uninstalled MS Office from my PC and replaced as OOo3.x, when I use OOo Writer to open the .doc files I found the page format is changed, Only one page if we open a.doc file use MS Office 2003, and it became two pages when I open a.doc file use OOo Writer. How can I open a.doc with OOo Writer that same as use MS Office 2003, only show us one page not two. Best Regards! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
On Monday 19 October 2009 21:18:37 Harold Fuchs wrote: > jomali wrote: <<>> > > steven.kopisc...@sbcglobal.net> wrote: > >> Andreas Saeger wrote: > >>> Tony Li wrote: <<>> > Hmm. I can get drag & drop to work on a selection of cells but not > on a selection of *rows* or *columns*. If I drag while a *column* > or *row* is selected, the selection just gets bigger or smaller - > rows/columns are added or removed from the selection depending on > the direction of the drag. What am I missing here? > Harold, If you click on a column "header" or a row "header" [namely the "A", "B", "C" etc for a column and 1, 2, 3 for the rows] to select the whole column [or row], click and hold the mouse over the selected cells in the column [or row] - which would, in this case, be all the cells in the column/row - then, you can drag the column/row. Is this what you were wanting to do, or have I missed the point entirely ? In the latter case, my apologies. -- Pradeep Srinivas on 20 Oct 2009, Tuesday, IST (which is GMT +05:30) --- Art arises when the secret vision of the artist and the manefestation of nature agree to find new shapes -- Khalil Gibran, Lebanese American artist, poet; 1883-1931 born Gibrān Khalīl Gibrān bin Mikhā'īl bin Sa'ad --- Signature block is /auto/ /generated/ from the Unix utility *fortune* fortune run at 06:10 IST on 20 Oct 2009, Tuesday - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: How to insert cut cells in Cacl
John Kaufmann wrote: In a message dated 2009.10.19 16:14 -0500, Andreas Saeger wrote: That works for cells, but I can't make it work for columns/rows. Agreed. With whole columns/rows you seem to need cut (or copy) & paste and, in this case, you must insert the new column/row before pasting. Dragging a column just adds/removes columns to/from the selection. It works for me with rows and columns. You can't drag columns and rows, but you can select them and then drag the resulting range selection. That is, a range of multiple /incomplete/ rows and columns - a rectangle of cells - correct? Complete or incomplete does not matter. A range is a rectangle or a vector(row/column) of cells. You can't drag entire rows, but the range that gets selected when you click a row header. Same with columns. Unlike Excel, you can grab a highlighted range anywhere in the highlighted area. In Excel you have to grab the range's border. Unlike Excel, you can not drag the single active cell. You've got to highlight the single cell first (Ctrl+Click). - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Default tab stops
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 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 paragraph's tab stops using the Format > Paragraph dialog >> window is like a sharp stick in the eye--use the rulers instead. > Why is it better to define a Paragraph style's tab stop(s) [which, to use the rulers, must be defined to AutoUpdate, correct?] with the rulers rather than numerically? Mainly for two reasons: 1) You can clearly see what you're doing. If I have paragraphs containing two distinct items separated by a tab, and I want the items to appear in two neat columns, I can simply click on the ruler and drag the tab stop to a position that's wide enough for all the items in the left column; I can easily see everything I need to set the tab stop at an appropriate position. Changing the tab stop later is just as easy. 2) The tab dialog is difficult to use. The dialog's design makes it impossible to edit a tab stop. You have to delete the stop and add it again, in the process, losing the alignment and leader settings. Further, the change/view cycle is awkward: You have to open the dialog, make a guess at the position, then confirm with OK and check how it looks--then, if it's not right, rinse and repeat. You're right that using the ruler to edit the tab stops in a style is a bit of a nuisance. I generally just grit my teeth and use the Edit Style dialog, or move the tab(s) with the ruler and then update the style manually. I don't much like the idea of auto-updating styles, so I haven't tried that route. For a one-off job, I just use direct formatting from the ruler--nothing wrong with that, IMO. On 10/19/2009 03:04 PM, Michael Adams wrote: ... Setting a paragraph's tab stops using the Format> Paragraph dialog window is like a sharp stick in the eye--use the rulers instead. Not if you want precise distances. Some are happy with near enough being good enough - others want anally perfect. OT Comments below*. Very true. If you need precise positions, you have to use the dialog. There is a lot of support for an enhancement[*] to make the rulers snap to some convenient spacing--0.1" or 0.1cm, something like that. That would make it reasonably easy to get precise stops from the ruler. If you need more than one or two stops in a paragraph, you may be better off with a table. Yes, perhaps i should have. I wanted a scale of numbers equally spaced across one line in the document. I can think of a few ways to do that; what's best would likely depend on what you need the scale for. If you wanted to use tabs, you're right: It would probably be easier to just enter the positions in the dialog. * Sir Isaac Newton, the renowned alchemist, is the one that did the experiment where he poked a sharp stick (a bodkin) into his eye socket. Fascinating. ;-) [*] Issue 24070: Items on ruler (i.e. tab stops, paragraph indent, table borders) should snap. http://qa.openoffice.org/issues/show_bug.cgi?id=24070 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
In a message dated 2009.10.19 16:14 -0500, Andreas Saeger wrote: That works for cells, but I can't make it work for columns/rows. Agreed. With whole columns/rows you seem to need cut (or copy) & paste and, in this case, you must insert the new column/row before pasting. Dragging a column just adds/removes columns to/from the selection. It works for me with rows and columns. You can't drag columns and rows, but you can select them and then drag the resulting range selection. That is, a range of multiple /incomplete/ rows and columns - a rectangle of cells - correct? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: How to insert cut cells in Cacl
Harold Fuchs wrote: Steven Kopischke wrote: Harold Fuchs wrote: That works for cells, but I can't make it work for columns/rows. Agreed. With whole columns/rows you seem to need cut (or copy) & paste and, in this case, you must insert the new column/row before pasting. Dragging a column just adds/removes columns to/from the selection. It works for me with rows and columns. You can't drag columns and rows, but you can select them and then drag the resulting range selection. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Default tab stops
Joe, I had not idea that "Default tab stops" could yield so much insight into the design of OO and Writer, but Michael Adams' excellent point - based on a perfectly valid application of periodic tab stops [which, it is true, could be done as a table], puts the original question perfectly: In a message dated 2009.10.19 11:54 -0500, Joe Smith wrote: 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 would enlighten us ... 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. ... So then why are they supported at the program level? And, as they are supported at the program level, why not at the user's document/paragraph level? After all, tab stops - default or otherwise - are clearly a concern for the use (as Michael's example reminds us), not for the program. Having already accepted the idea of default periodic tab stops, what is gained by Writer denying their employment at the level of the user's intent - document-wide, page-wide, frame-wide or paragraph-wide? John - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Technical futures of OpenOffice.org calc
Олег Пашута wrote: Hello OpenOffice.org, Ineedto know technical features of Open Offce calc, such as for MS Office Excel (example below): http://office.microsoft.com/en-us/excel/HP051992911033.aspx please,giveme the direct link to this information or give methe answerbefore you place this subject on the openoffice.org web-site, if it is not yet there. Thanks before! You can find the specs for OpenOffice.org at http://specs.openoffice.org/ , though not in the same form as your example. HTH -- Andy Brown La Mesa, CA 91942 www.the-martin-byrd.net/openoffice.org.html OpenOffice.org Community Distributor CD/OEM Distribution Project member Documentation Project member Marketing Project member User Experience Project member - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Default tab stops
On Mon, 19 Oct 2009 11:54:43 -0400 Came this utterance formulated by Joe Smith to my mailbox: > 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 would enlighten us on this > > aspect. Please. > > 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. > > If you need tab stops--content aligned vertically at a specific > position--you should set a specific tab stop for it. Writer will copy > that setting when you start a new paragraph, or better, define a style > that you can apply as needed. > > It may seem less convenient than just "pressing Tab until things line > up," but this way you'll have much better control over the layout and > spend less time fiddling around trying to get things lined up. > > Setting a paragraph's tab stops using the Format > Paragraph dialog > window is like a sharp stick in the eye--use the rulers instead. Not if you want precise distances. Some are happy with near enough being good enough - others want anally perfect. OT Comments below*. > If you need more than one or two stops in a paragraph, you may be > better off with a table. Yes, perhaps i should have. I wanted a scale of numbers equally spaced across one line in the document. > More on setting tabs in Writer: > http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Format_paragraphs > * Sir Isaac Newton, the renowned alchemist, is the one that did the experiment where he poked a sharp stick (a bodkin) into his eye socket. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Technical futures of OpenOffice.org calc
Hello OpenOffice.org, Ineedto know technical features of Open Offce calc, such as for MS Office Excel (example below): http://office.microsoft.com/en-us/excel/HP051992911033.aspx please,giveme the direct link to this information or give methe answerbefore you place this subject on the openoffice.org web-site, if it is not yet there. Thanks before! -- Best regards, Олег mailto:midih...@ukr.net - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Trouble entering data in Base
That seems OK. I suggest you ask your question to the BASE support users list: us...@dba.openoffice.org Joe Arnold Roth wrote: The Index is INT. Size is 10 and auto increment is on. "JOE Conner" wrote in message news:4adbe250.40...@gmail.com... Arnold Roth wrote: I have been entering data into a table using a form. The data are all in one table and the form has links to all the fields in the table except for the autoincrementing primary key field. I have sporadically been entering the data with no problems but after entering about 10 records I reoponed the form and entered another record and got an error message about not being able to enter the record because of a non-unique index field. I don't seem to be able to get around this error. I noticed that when I open the form it thinks I am on record 1 instead of record 11. I'm stumped. Can anyone tell me what the problem might be? Thanks in advance for your help. What is the size allocated for your autorecord file? INT? LONGINT? DOUBLE? LONG DOUBLE? - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Default tab stops
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... In a message dated 2009.10.19 11:54 -0500, Joe Smith wrote: 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 would enlighten us ... 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 paragraph's tab stops using the Format > Paragraph dialog window is like a sharp stick in the eye--use the rulers instead. Why is it better to define a Paragraph style's tab stop(s) [which, to use the rulers, must be defined to AutoUpdate, correct?] with the rulers rather than numerically? John - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: header and footers
Brian Barker posted some pretty detailed instructions on creating page styles to do what you need on July 11 (msg. 199958). On 10/19/09 users-digest-h...@openoffice.org wrote: Subject: header and footers From: Jurgen Heerink Date: Mon, 19 Oct 2009 07:25:53 + To: Hi, Could someone pls help with with the following problem. I am creating a report but I don't want to have a header and footer on the first 3 pages. So from the 4th till the last, as well as the page numbering. Thanks in advance, Jurgen - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: header and footers
Jurgen: You'll need to create two page styles: one for the first 3 pages without header/footer and page number, and one beginning with page four which has the desired header/footer and page numbering. It's not very intuitive, but once you get the hang of it, it works pretty well. Create the styles first (use the Help function) and then apply them to the desired pages. Look at the list archives; there are some detailed explanations of using styles for this purpose in the past 6 months or so. HTH. -Michael On 10/19/09 users-digest-h...@openoffice.org wrote: Subject: header and footers From: Jurgen Heerink Date: Mon, 19 Oct 2009 07:25:53 + To: Hi, Could someone pls help with with the following problem. I am creating a report but I don't want to have a header and footer on the first 3 pages. So from the 4th till the last, as well as the page numbering. Thanks in advance, Jurgen - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
AVG_8 Says No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.21/2445 - Release Date: 10/19/09 06:40:00 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
Steven Kopischke wrote: Harold Fuchs wrote: Steven Kopischke wrote: jomali wrote: I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. The drag and drop experience may not be unique to Excel, but the "you must insert columns before cut & paste" is, in my experience, unique to OOo Calc. Perhaps before cut & paste but drag & drop seems to be different. See Calc's Help under Drag & Drop > Moving Cells. The effect you get depends on the keys you hold down as you release the mouse button - Ctrl, Alt & Shift in different combinations. That works for cells, but I can't make it work for columns/rows. Agreed. With whole columns/rows you seem to need cut (or copy) & paste and, in this case, you must insert the new column/row before pasting. Dragging a column just adds/removes columns to/from the selection. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Default tab stops
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 would enlighten us on this aspect. Please. 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. If you need tab stops--content aligned vertically at a specific position--you should set a specific tab stop for it. Writer will copy that setting when you start a new paragraph, or better, define a style that you can apply as needed. It may seem less convenient than just "pressing Tab until things line up," but this way you'll have much better control over the layout and spend less time fiddling around trying to get things lined up. Setting a paragraph's tab stops using the Format > Paragraph dialog window is like a sharp stick in the eye--use the rulers instead. If you need more than one or two stops in a paragraph, you may be better off with a table. More on setting tabs in Writer: http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Format_paragraphs
Re: [users] Re: How to insert cut cells in Cacl
Harold Fuchs wrote: Steven Kopischke wrote: jomali wrote: I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. The drag and drop experience may not be unique to Excel, but the "you must insert columns before cut & paste" is, in my experience, unique to OOo Calc. Perhaps before cut & paste but drag & drop seems to be different. See Calc's Help under Drag & Drop > Moving Cells. The effect you get depends on the keys you hold down as you release the mouse button - Ctrl, Alt & Shift in different combinations. That works for cells, but I can't make it work for columns/rows. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
jomali wrote: I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. John On Mon, Oct 19, 2009 at 10:27 AM, Steven Kopischke < steven.kopisc...@sbcglobal.net> wrote: Andreas Saeger wrote: Tony Li wrote: Dears, could somebody give the tips on how to insert cut cells in cacl, My requirement is: 1) Select on row / column in cacl, and click cut 2) Insert the cut row / column to another place like between column A and column B without overwriting the content in column B. One of the weaknesses of OOo is that you have to insert the rows/columns before cutting and pasting. SK - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Hmm. I can get drag & drop to work on a selection of cells but not on a selection of *rows* or *columns*. If I drag while a *column* or *row* is selected, the selection just gets bigger or smaller - rows/columns are added or removed from the selection depending on the direction of the drag. What am I missing here? -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
Steven Kopischke wrote: jomali wrote: I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. The drag and drop experience may not be unique to Excel, but the "you must insert columns before cut & paste" is, in my experience, unique to OOo Calc. Perhaps before cut & paste but drag & drop seems to be different. See Calc's Help under Drag & Drop > Moving Cells. The effect you get depends on the keys you hold down as you release the mouse button - Ctrl, Alt & Shift in different combinations. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] header and footer from page 4
On Mon, 19 Oct 2009 10:04:19 + Came this utterance formulated by Jurgen Heerink to my mailbox: > > Hi, > > I have problems with the headers and footers in Open Office and I have > no idea how to solve it, I read all the information on the internet > but it still does not work for me. > > I am creating a report and I want the page numbering and the headers > and footers starting from page 4. First page is Title, 2nd a > confidentiality agreement and the 3rd is the table of contents. So the > report _starts_ at page 4. > > Could someone pls help me cause I am totally stuck at the moment_ > In OpenOffice.org this is achieved through two different page styles. One without the header and/or footer and one with them. You can read up on page styles: http://documentation.openoffice.org/ Specifically chapters 6 and 7 in the writers guide. You can download the complete book as a PDF: http://documentation.openoffice.org/manuals/userguide3/0200WG3-WriterGuide.pdf or the individual chapters: http://documentation.openoffice.org/manuals/userguide3/index.html More specifically read the subheadings "The Styles and Formatting Window", "Applying Page Styles" in chapter 6 and "Working with Page Styles" in chapter 7. This is not something you are expected to be familiar with if you have come from Microsoft Word. Word does not have the power of styles applied to pages. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
jomali wrote: I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. The drag and drop experience may not be unique to Excel, but the "you must insert columns before cut & paste" is, in my experience, unique to OOo Calc. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: How to insert cut cells in Cacl
I don't know that this is unique to OOo, since that's the way Excel (2000) works as well. I just tried it to refresh my memory, since I rarely use Excel anymore. However, in Excel, if you try to drag & drop a column, you get a warning about replacing the data in the target column. In Calc, there is no warning. The moved column's data silently replaces the old column's data, leaving a blank column behind. John On Mon, Oct 19, 2009 at 10:27 AM, Steven Kopischke < steven.kopisc...@sbcglobal.net> wrote: > Andreas Saeger wrote: > >> Tony Li wrote: >> >>> Dears, could somebody give the tips on how to insert cut cells in cacl, >>> >>> My requirement is: >>> >>> 1) Select on row / column in cacl, and click cut >>> >>> 2) Insert the cut row / column to another place like between column A >>> and column B without overwriting the content in column B. >>> >>> >> One of the weaknesses of OOo is that you have to insert the rows/columns > before cutting and pasting. > > SK > > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >
Re: [users] Re: How to insert cut cells in Cacl
Andreas Saeger wrote: Tony Li wrote: Dears, could somebody give the tips on how to insert cut cells in cacl, My requirement is: 1) Select on row / column in cacl, and click cut 2) Insert the cut row / column to another place like between column A and column B without overwriting the content in column B. One of the weaknesses of OOo is that you have to insert the rows/columns before cutting and pasting. SK - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: How to insert cut cells in Cacl
Tony Li wrote: Dears, could somebody give the tips on how to insert cut cells in cacl, My requirement is: 1) Select on row / column in cacl, and click cut 2) Insert the cut row / column to another place like between column A and column B without overwriting the content in column B. Best Regards! Tony Li Use drag&drop and drop with the Alt-key being pressed. Ctrl+Alt+Drop copies the cells in between the target columns. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Special formats in Base
Thanks jomali. I'm such an idiot. That should have been obvious but it got
right by me.
- Original Message -
From: "jomali"
Newsgroups: gmane.comp.openoffice.questions
To:
Sent: Saturday, October 17, 2009 9:46 AM
Subject: Re: Special formats in Base
You're doing nothing wrong, Arnold. The display format of the data is one
thing and the data in the database is another. Why would you want to waste
space in the database to store the parentheses, spaces and dash in the
phone
number when you can interpret it as you wish on output?
John
On Fri, Oct 16, 2009 at 7:47 PM, Arnold Roth wrote:
I have created a form to enter data where one of the fields is a
telephone
number. In setting up the table, I entered a custom format as
"("xxx")"xxx"-". This shows as I expected (area code in parentheses
followed by the digits) in the format box.
When I enter phone numbers in the form, they simply appear in the table
as
a string of numbers without the formatting.
Can anyone tell me what I'm doing wrong? Thanks
Arnold Roth
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to insert cut cells in Cacl
2009/10/19 Tony Li > Thanks, Harold, but when paste, that will overwrite the existing data > > Best Regards! > Tony Li > Not if you do #5 (Insert row/column) first; the data get pasted into the new (inserted) row/column because it is still selected from #3 (the actual row/column you selected in #3 gets moved down/right and the new row/column acquires the focus i.e. becomes the selected row/column (it also acquires the row/column number/letter of the moved row/column). > > -Original Message- > From: Harold Fuchs [mailto:hwfa.openoff...@googlemail.com] > Sent: Monday, October 19, 2009 4:55 PM > To: users@openoffice.org > Subject: Re: [users] How to insert cut cells in Cacl > > 2009/10/19 Tony Li > > > Dears, could somebody give the tips on how to insert cut cells in cacl, > > > > > > > > My requirement is: > > > > 1) Select on row / column in cacl, and click cut > > > > 2) Insert the cut row / column to another place like between column A > > and column B without overwriting the content in column B. > > > > > > 1. Select the row/column > 2. Edit>Cut (or Right click>Cut) > 3. Select the row/column *before which* the data are to go > 4. Right click the selected row/column > 5. Insert Row/column > 6. Edit>Paste (or Right click>Paste) > > Note that step #2 cuts the data but does not remove the column/row. That > would need an extra step. > > > > -- > Harold Fuchs > London, England > Please reply *only* to users@openoffice.org > > > - > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
[users] header and footer from page 4
Hi, I have problems with the headers and footers in Open Office and I have no idea how to solve it, I read all the information on the internet but it still does not work for me. I am creating a report and I want the page numbering and the headers and footers starting from page 4. First page is Title, 2nd a confidentiality agreement and the 3rd is the table of contents. So the report ’starts’ at page 4. Could someone pls help me cause I am totally stuck at the moment… Thanks in advance! Jurgen _ Nieuws, entertainment en de laatste roddels. Je vind het op MSN.nl! http://nl.msn.com/
RE: [users] How to insert cut cells in Cacl
Thanks, Harold, but when paste, that will overwrite the existing data Best Regards! Tony Li Before printing, think about Environmental Responsibility -Original Message- From: Harold Fuchs [mailto:hwfa.openoff...@googlemail.com] Sent: Monday, October 19, 2009 4:55 PM To: users@openoffice.org Subject: Re: [users] How to insert cut cells in Cacl 2009/10/19 Tony Li > Dears, could somebody give the tips on how to insert cut cells in cacl, > > > > My requirement is: > > 1) Select on row / column in cacl, and click cut > > 2) Insert the cut row / column to another place like between column A > and column B without overwriting the content in column B. > > > 1. Select the row/column 2. Edit>Cut (or Right click>Cut) 3. Select the row/column *before which* the data are to go 4. Right click the selected row/column 5. Insert Row/column 6. Edit>Paste (or Right click>Paste) Note that step #2 cuts the data but does not remove the column/row. That would need an extra step. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] How to insert cut cells in Cacl
2009/10/19 Tony Li > Dears, could somebody give the tips on how to insert cut cells in cacl, > > > > My requirement is: > > 1) Select on row / column in cacl, and click cut > > 2) Insert the cut row / column to another place like between column A > and column B without overwriting the content in column B. > > > 1. Select the row/column 2. Edit>Cut (or Right click>Cut) 3. Select the row/column *before which* the data are to go 4. Right click the selected row/column 5. Insert Row/column 6. Edit>Paste (or Right click>Paste) Note that step #2 cuts the data but does not remove the column/row. That would need an extra step. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
[users] How to insert cut cells in Cacl
Dears, could somebody give the tips on how to insert cut cells in cacl, My requirement is: 1) Select on row / column in cacl, and click cut 2) Insert the cut row / column to another place like between column A and column B without overwriting the content in column B. Best Regards! Tony Li
Re: [users] Default tab stops
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, but found no option in the paragraph > dialogue box or in the styles for paragraphs as suggested by help. Had > to cludge it with tools-options for the whole program. > > OO.o3.1.1 on WS2k8 box. Anthing i missed? > > > Errrm. yes, I think so. For a selected paragraph: Format>Paragraph>Tabs For a Paragraph Style: Modify>Tabs In either case you can now add (use the Add button) different types of tab stops at your chosen positions. The only thing I can't find a way to do is to specify, for example "every 1/2 inch". Perhaps someone else would enlighten us on this aspect. Please. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
[users] Default tab stops
Had a little trouble setting default tab stops in writer today. I wanted to set them for one paragraph only, but found no option in the paragraph dialogue box or in the styles for paragraphs as suggested by help. Had to cludge it with tools-options for the whole program. OO.o3.1.1 on WS2k8 box. Anthing i missed? -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Open Office Licence agreemet
Diego Alterisi wrote: In addition we would like to know how to respond to eventual inquiry required from BSA or authority. I would guess you could tell the BSA to take a running jump - AFAIK they would have no authority to make any audit of software that is freely available and distributable. That would be beyond their remit.. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] header and footers
On Mon, 19 Oct 2009 07:25:53 + Came this utterance formulated by Jurgen Heerink to my mailbox: > > Hi, > > > > Could someone pls help with with the following problem. > > I am creating a report but I don't want to have a header and footer on > the first 3 pages. > > So from the 4th till the last, as well as the page numbering. > You will have to use the power of Page Styles. I recommend reading up on them in the documentation project. -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] header and footers
Hi, Could someone pls help with with the following problem. I am creating a report but I don't want to have a header and footer on the first 3 pages. So from the 4th till the last, as well as the page numbering. Thanks in advance, Jurgen _ Gratis emoticons voor in je Messenger! http://www.msnmessengerexperience.nl/chuck/
