Re: [users] Funzione contabiltà

2005-11-04 Thread G. Roderick Singleton
On Thu, 2005-11-03 at 15:45 +0100, Mattia Zanella wrote: Vorrei sapere, se è possibile, per quale motivo nel foglio di calcolo di OpenOffice, nella formattazione delle celle, non è stata implementato il formato contabilità presente in Ms Office. tale formato permette di incolonnare il

Re: [users] Database feature

2005-11-04 Thread G. Roderick Singleton
On Wed, 2005-11-02 at 12:36 -0600, Dennis J. Tuchler wrote: G. Roderick Singleton wrote: On Wed, 2005-11-02 at 12:00 -0600, Dennis J. Tuchler wrote: Is OOo 2.0 furnished with a complete database feature or only a front end, requiring Mysql or some such database application?

Re: [users] two columns need fast help

2005-11-04 Thread G. Roderick Singleton
On Mon, 2005-10-31 at 17:13 -0500, my wrote: Dear Friends, I apologise for the need for fast help, but kid needs homework done for tomorrow and I have no clue how to do this, although I am sure googling would, had I the time, do it. He needs two colums, one called What I Read and the

Re: [users] Set OO2.0 as the default application for a document in Mac Os X

2005-11-04 Thread Roberto Demarchi
The problem I have is with the menu Get Info; this is the menu i normally use to set OO as the default application for documents with the same extension. In this menu there is the Open With: function. I select the Open With then I choose Open Office 2.0 as the application I want to use and the

[users] Re: Please Help With This Macro

2005-11-04 Thread Jack Gillis
- Original Message - From: Andrew Douglas Pitonyak [EMAIL PROTECTED] Newsgroups: gmane.comp.openoffice.questions Sent: Thursday, November 03, 2005 10:49 PM Subject: Re: Please Help With This Macro Jack Gillis wrote: I need help with this macro. Its purpose is to cycle through all

[users] Calc - sort on more than 3 columns

2005-11-04 Thread Gert Blij
Is this possible? Or is there a trick? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [users] sort rows by column

2005-11-04 Thread RLShadow
Using Ctrl+A will select all of your WORKSHEET, which isn't what you want to do. You want to select all of your data, not all of your worksheet. Actually, as long as your data are contiguous (no column or row gaps within it), all you have to do is select a single cell within your data.

[users] Writer and Base

2005-11-04 Thread Richard Martin
Hi, I dont know if this has been asked before but here goes anyway. I have reports I have to write every week and all the data is in the MySQL database. I have setup Base with the appropriate queries to retrieve the data. However how do i embed these in my reports so that when I open the

Re: [users] Writer and Base

2005-11-04 Thread Richard Martin
Hi, Sorry just to clarify I need to use Writer to write the reports. Thanks Richard Richard Martin wrote: Hi, I dont know if this has been asked before but here goes anyway. I have reports I have to write every week and all the data is in the MySQL database. I have setup Base with the

Re: [users] dates in oo 2.0

2005-11-04 Thread RLShadow
Hi Margaret, It sounds like what you're doing is inserting a date FIELD, rather than just typing in a date, is that correct? If so, here is how to specify the date format: Insert the date field (Insert Field Date) Right click on the field and select Fields ... Under Format, you can

Re: [users] OOo2.0 Position_Independent Right-Click menu.

2005-11-04 Thread Doug Thompson
Warwick Taylor wrote: You may be jumping to conclusions there Doug, the only WindowsOS I run is the one inside a Win4LinPro window under Xandros3.0, and we are unlikely to install OOo in there any time soon! Xandros has the primary OS in this office since 2002. Now just to be clear; in our

[users] Re: Manual available for OpenOffice.org 2.0

2005-11-04 Thread G. Roderick Singleton
On Wed, 02 Nov 2005 13:20:15 -0600, Mary Leete wrote: Hello! Congratulations to all who worked on OOo 2.0! It's fabulous! If anyone is looking for a great manual, Free Software For Dummies, includes about 200 pages on OpenOffice.org 2.0. It's newly published and received excellent

Re: [users] OOo2.0 Position_Independent Right-Click menu.

2005-11-04 Thread RLShadow
I'll cast my vote on the side of 2.0 mouse focus behavior. In a message dated 11/4/2005 7:37:32 AM Eastern Standard Time, [EMAIL PROTECTED] writes: All that aside, I think that another menu item to set focus behavior would only serve to confuse too many users. Better, I suggest, to fix

[users] Cell note

2005-11-04 Thread Chadley Wilson
Greetings I have selected show note, this is so that I can edit it. But now I don't know how to make it a popup again. Any ideas? Thanks Chadley - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

[users] base and i18n

2005-11-04 Thread Shoshannah Forbes
Does anyone know where can I find a document about using Base's i18n features? Things like defining the encoding of the database (or of the database connection), using non-English data/time etc.? I didn't see anything that seems relevant at documentation.openoffice.org, and the help

[users] Oobase Examples in oooforum.org (was:Re: [users] Superb magazine article about how to use OOBase...)

2005-11-04 Thread Pere Castanyer Sarda
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, 03 Nov 2005 08:04:45 -0700 Doug Thompson [EMAIL PROTECTED] wrote: The December, 2005, issue #61 of Linux Magazine has a great article by Dimitri Popov that is one of the best intros to OOBase I have seen. Don't turn away because of the

[users] Inserting Frame Placeholders from Conditional text Fields

2005-11-04 Thread Warwick Taylor
I have been able to manually insert Frame placeholders using InsertFieldsOtherFunctions (in OOo2) but I am now trying to insert Frame placeholders from within Conditional text Fields so that when conditions are meet the frames will show in mail merged documents. I am getting data base fields to

[users] Re: Incorrect date field import to Calc

2005-11-04 Thread Matej Cepl
G. Roderick Singleton wrote: Did yo send the example file off-line as asked? You could also check what format the column thinks it is using.I have seen some strange things happen with column formatting. I did. I do not think it has anything to do with formatting, but I will check it again.

Re: [users] Cell note

2005-11-04 Thread rlshadow
Are you on OOo 2.0? If so, check to see if you have the Help tool tips enabled. (Tools Options OpenOffice.org General. Then see if Tips is checked. If it is not checked, check it.) There's either a very odd feature or else a bug that makes it so that if you do not have Tips checked, you

Re: [users] Re: Manual available for OpenOffice.org 2.0

2005-11-04 Thread rlshadow
I'm pretty new on this list so I don't know what the community standards are, but I don't really view Mary's post as spam. To me, spam is sending out messages to zillions of random addresses about things like how to order Viagra, how to enlarge certain body parts, etc. Mary's post seems to

Re: [users] Re: Manual available for OpenOffice.org 2.0

2005-11-04 Thread Laurent Godard
Hi Gerry, Hi Mary this is a delicate point Gerry you're right. Advertising is not wanted on lists Mary thanks for writing a book on OOo Btw, Gerry may be you could officially invite Mary on joining us as she seems to have some interresting skills. For QA, documentation or user supports on a

[users] Start page numbering at page 4

2005-11-04 Thread Fajar Priyanto
Hi all, How can we setup OOo 2.0 so that page numbering starts on page 4? Because page 1-3 will be used for preface, and TOC with no page number. I tried use the First Page style, but it only valid for 1st page only. Can it be applied for page 2 and 3 too? Thank you very much, -- Fajar

Re: [users] excel

2005-11-04 Thread Gregory Forster
Yes. Just make sure that when you install OpenOffice, when the dialog box appears asking you if you want OpenOffice to open Microsoft Word, Excel and Powerpoint files, make sure you check them. Greg --- Gary Black [EMAIL PROTECTED] wrote: If I download Open office will I be able to receive

[users] Calc not displaying font colors

2005-11-04 Thread Steve Kopischke
I am using OOo 2.0 on WinXPPro. I created a very small Calc spreadsheet that is essentially a schedule table. When I change the font colors for certain cells, the colors change, but the changes are not displayed in the normal view. I can see them when I look at a print preview, but not

Re: [users] Start page numbering at page 4

2005-11-04 Thread Dan Lewis
On Friday 04 November 2005 10:25 am, Fajar Priyanto wrote: Hi all, How can we setup OOo 2.0 so that page numbering starts on page 4? Because page 1-3 will be used for preface, and TOC with no page number. I tried use the First Page style, but it only valid for 1st page only. Can it be

Re: [users] Terrible Bug in Calc!!!

2005-11-04 Thread Gregory Forster
Also, when you delete ALL OpenOffice (using Control Panel/Add Remove software) and modify the registry, don't forget about using Windows Explorer to delete all the OpenOffice files in C:\Documents and Settings\user\Application Data subdirectory, \user\ being your name. Then delete all the files in

Re: [users] excel

2005-11-04 Thread Dan Lewis
On Thursday 03 November 2005 08:31 am, Gary Black wrote: If I download Open office will I be able to receive e-mails sent in excel? From another member of this mailing list: ~~~ Yes. Just make sure that when you install OpenOffice, when the dialog box

[users] Changing multiple formulas

2005-11-04 Thread Michael S. Koeris
Hey all, is it possible to change the function in multiple cells and keep the addressing the same? Thanks Mike

[users] Re: Changing multiple formulas

2005-11-04 Thread David Chapman
I am not sure if I understand the question - but I'll answer what I think was asked In A2 let's say you have =SUM($A$1;B2) When you drag this formula down, the $A$1 component of the formula is constant, but the B2 component is auto incremented through C2, D2 etc When dragging formulae and

Re: [users] Changing multiple formulas

2005-11-04 Thread Anthony Chilco
Hi Michael, If you want to keep the formulae in the same cells but change it, you can select the cells and use search and replace. tc Michael S. Koeris wrote: Hey all, is it possible to change the function in multiple cells and keep the addressing the same? Thanks Mike

[users] Inserting Special Characters (Windows)

2005-11-04 Thread John Jordan
I have OO.o 1.9 on my Linux laptop and 2.0 on my Windows 2000 desktop. On the Linux version I can enter a special character by holding Shift+Ctrl and typing the hex code. For example, Ctrl+Shift+02A4 gives me the d-yogh ligature (assuming I'm in a font that contains that character). But when I

Re: [users] Re: Changing multiple formulas

2005-11-04 Thread rlshadow
I'm also not sure if I understand the question, but my interpretation was differnent than David's. We may both be wrong! I interpreted the question as: I have a number of equations that SUM a group of numbers, and I want to change the equations to calculate the standard deviation of the same

[users] labels ?

2005-11-04 Thread Keone Michaels
The labels on some of the command boxes don't appear such as when you save a file, the three buttons on the bottom show up as lines? This is okay on command boxes i am familiar with but on the ones i don't know i have guess the functions.. how do i resolve this? Otherwise the program is

Re: [users] Re: Calc / Excel Question

2005-11-04 Thread Brian Carey
Hi Rob, Another thing you could consider is using a text box. This approach has some advantages, such as giving you complete control over size and placement independent of column widths and keeping text which exists as one logical unit together rather than breaking it accross several cells.

[users] Problem with Calc

2005-11-04 Thread Rick
One thing I didn't like about Calc in 1.5 is that if you had Sheet three open, for example, and hit PRINT, it printed all pages from Sheet 1 on though the whole book. You could identify page numbers, but these didn't usually number from what you would think page one to be. Rick

Re: [users] Terrible Bug in Calc!!!

2005-11-04 Thread Chad Smith
On 11/4/05, Gregory Forster [EMAIL PROTECTED] wrote: Also, when you delete ALL OpenOffice (using Control Panel/Add Remove software) and modify the registry, don't forget about using Windows Explorer to delete all the OpenOffice files in C:\Documents and Settings\user\Application Data

[users] Re: Inserting Special Characters (Windows)

2005-11-04 Thread Randomthots
John Jordan wrote: I have OO.o 1.9 on my Linux laptop and 2.0 on my Windows 2000 desktop. On the Linux version I can enter a special character by holding Shift+Ctrl and typing the hex code. For example, Ctrl+Shift+02A4 gives me the d-yogh ligature (assuming I'm in a font that contains that

Re: [users] Outline numbering chapter vs appendix

2005-11-04 Thread john fisher
Anybody with a workaround, correction, guidance? thanks John On Thu, 2005-11-03 at 09:51 -0800, john fisher wrote: trying to have different section heading text at outline level 1: Consistently in OOwriter 1.13 1.14, various betas, and now 2.0 I am unable to create chapter and appendix

Re: [users] Base Query Question

2005-11-04 Thread Brian Carey
Take a look at Queries-Parameter Queries in the Help system. If you want to use the name of the column in your prompt, just put a ? in the criteria. Otherwise put =[Enter_Name], for example, in the criteria. (As I recall, this was the same syntax in Access, but I could be wrong.) Brian

[users] Re: Manual available for OpenOffice.org 2.0

2005-11-04 Thread Ain Vagula
G. Roderick Singleton wrote: On Wed, 02 Nov 2005 13:20:15 -0600, Mary Leete wrote: Hello! Congratulations to all who worked on OOo 2.0! It's fabulous! If anyone is looking for a great manual, Free Software For Dummies, includes about 200 pages on OpenOffice.org 2.0. It's newly published

Re: [users] Disable save as and save menu

2005-11-04 Thread Brian Carey
Dan Lewis wrote: On Thursday 03 November 2005 06:55 am, Dan Casan wrote: Is this possible to disable save as and save from the menu of OpenOffice ? I just want documents to be modified and printed and not able to be saved. Thank you. - Yahoo! FareChase -

Re: [users] Funzione contabilt

2005-11-04 Thread Brian Carey
Mattia, I believe that you want the currency symbol to left-justify in a cell and the numbers to right-justify. Assuming you don't get a better solution elsewhere, you could achieve the same effect by using 2 columns, one with the currency symbol and one for the numbers. Brian G. Roderick

Re: [users] Calc - sort on more than 3 columns

2005-11-04 Thread Brian Carey
Gert Blij wrote: Is this possible? Or is there a trick? TIA Gert - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Hi Gert, You could try to sort twice. ie. if you want

RE: [users] Disable save as and save menu

2005-11-04 Thread Roger Ross
why not allow the users write access only to a scratch file that is regularly deleted? -Original Message- From: Brian Carey [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 11:00 AM To: users@openoffice.org Subject: Re: [users] Disable save as and save menu Dan Lewis wrote: On

[users] Test MacOOo/NeoO Font-Line Spacing Differences!

2005-11-04 Thread James Greenidge
Greetings All! I need a solution. Since doing shows better than explaining; On Mac OOo 2.0r3 create a three-page+ Courier 12 document 57 lines deep with a header with a blank line underneath, a top margin of .3 inches and bottom margin of .8 inches. All pages should maintain a 57 line

[users] Import of Calc tables into Writer.

2005-11-04 Thread Jacek
Is it possible to import a part of Calc table into a Writer without embedding it as an OLE object. I'd like to have it as ordinary Writer table. If I also could preserve formatting, while doing it it would be great.

[users] Start Menu Integration

2005-11-04 Thread Peter Douglas
Re: OpenOffice 2.0 on WinXP Pro SP2. OpenOffice 1.x had options for Open Document and From Template which I would pin to the Start menu, achieving the same functionality as Office's New Office Document and Open Office Document icons. In OpenOffice 2, this appears to be only available via the

Re: [users] Calc not displaying font colors

2005-11-04 Thread Ourfergusons
I have noticed that when I use bold for cells smaller than 10 they do not show up as bold. What am I doing wrong? - Original Message - From: Steve Kopischke [EMAIL PROTECTED] To: users@openoffice.org Sent: Friday, November 04, 2005 11:35 AM Subject: [users] Calc not displaying font

Re: [users] Import of Calc tables into Writer.

2005-11-04 Thread RLShadow
Try copying the block of cells you want, going to Writer, then Paste Special, and choose Formatted Text (RTF). In a simple test I just did, it preserved some formatting but not all. Bold came through OK, but font size changes did not. Dick, Webster, NY This should bring the date into

[users] Auto-save vs. Auto-recovery

2005-11-04 Thread Alex Mandel
OpenOffice 2.0 has replaced the 1 feature that sold me on it. Auto-save, true saving of your document on a timer. This is the reason I use and recommend OpenOffice over Microsoft. It has now been replaced by Auto-recovery save. which is the exact reason I can't stand to use MS Office.

Re: [users] Auto-save vs. Auto-recovery

2005-11-04 Thread Steve Kopischke
I never trust the Auto-Save settings in any application. Ctrl-S is my friend. SJK on 11/04/05 14:34 'Alex Mandel' wrote: OpenOffice 2.0 has replaced the 1 feature that sold me on it. Auto-save, true saving of your document on a timer. This is the reason I use and recommend OpenOffice over

Re: [users] Problem with Calc

2005-11-04 Thread Keith Bainbridge
Rick Try highlightinh the area you want to print, thten select 'print highlighted area' There is an option in tools|settings to tell Calc to print only the current page if you want that ALWAYS. On Fri, 4 Nov 2005 13:09:48 -0500 Rick [EMAIL PROTECTED] wrote: One thing I didn't like about

Re: [users] Problem with Calc

2005-11-04 Thread Wangshanpo
Of course you could also use Print...Options...print only selected sheets. Keith Bainbridge wrote: Rick Try highlightinh the area you want to print, thten select 'print highlighted area' There is an option in tools|settings to tell Calc to print only the current page if you want that

Re: [users] Calc not displaying font colors

2005-11-04 Thread Dwight E Chadbourne
Return Receipt Your Re: [users] Calc not displaying font colors document:

[users] Re: Auto-save vs. Auto-recovery

2005-11-04 Thread Alex Mandel
It's not a matter of trust - I'm fairly ctl-s happy myself. But auto-save is a backup of those of us that get a little forgetful or absent minded in the multi-tasking world, and for some users I've worked with, the only thing that keeps them from losing their edits. Alex Steve Kopischke

Re: [users] Cell note

2005-11-04 Thread Dave Barton
On Fri, 2005-11-04 at 09:30 -0500, [EMAIL PROTECTED] wrote: Are you on OOo 2.0? If so, check to see if you have the Help tool tips enabled. (Tools Options OpenOffice.org General. Then see if Tips is checked. If it is not checked, check it.) There's either a very odd feature or else a

Re: [users] Start page numbering at page 4

2005-11-04 Thread G. Roderick Singleton
On Fri, 2005-11-04 at 23:25 +0700, Fajar Priyanto wrote: Hi all, How can we setup OOo 2.0 so that page numbering starts on page 4? Because page 1-3 will be used for preface, and TOC with no page number. I tried use the First Page style, but it only valid for 1st page only. Can it be

Re: [users] Import of Calc tables into Writer.

2005-11-04 Thread Dave Barton
On Fri, 2005-11-04 at 21:23 +0100, Jacek wrote: Is it possible to import a part of Calc table into a Writer without embedding it as an OLE object. I'd like to have it as ordinary Writer table. One way I have found to do this, is to copy the sheet range to the clipboard, then in Writer Paste

[users] [OTAnn] Groups:New Developments at Roomity

2005-11-04 Thread shenanigans
I was interested in getting feedback from current communities of Roomity.com and let you know the recent improvements we are working on for better interface. Roomity.com v 1.5 is a web 2.01/RiA poster child community webapp. This new version adds broadcast video, social networking such as

[users] Howto - Descriptive Statistics Calc

2005-11-04 Thread Paul Campbell
Does OO 2 Calc support a capability similiar to MS for Descriptive Statistics ? I am sure I can write a macro to do them, but wondered if there was an add-on similiar to MS already created. - To unsubscribe, e-mail: [EMAIL

Re: [users] Howto - Descriptive Statistics Calc

2005-11-04 Thread Dan Lewis
On Friday 04 November 2005 04:58 pm, Paul Campbell wrote: Does OO 2 Calc support a capability similiar to MS for Descriptive Statistics ? I am sure I can write a macro to do them, but wondered if there was an add-on similiar to MS already created. Specifically, what descriptive

[users] Re: Howto - Descriptive Statistics Calc

2005-11-04 Thread David Chapman
Some pointers for you to get started FORECAST , TREND, GROWTH: http://www.openofficetips.com/blog/archives/2005/10/basic_functions_15.html Regression analysis: Linear formulae http://www.openofficetips.com/blog/archives/2005/04/regression_anal.html SLOPE, INTERCEPT, CORREL:

Re: [users] Howto - Descriptive Statistics Calc

2005-11-04 Thread Paul Campbell
In Excel, Tools - Data Analysis - Descriptive Statistics Tools - Data Analysis - Histogram Dan Lewis wrote: On Friday 04 November 2005 04:58 pm, Paul Campbell wrote: Does OO 2 Calc support a capability similiar to MS for Descriptive Statistics ? I am sure I

Re: [users] Manual available for OpenOffice.org 2.0

2005-11-04 Thread James E. Lang
G. Roderick Singleton wrote at 14:54 on 2 Nov 2005: On Wed, 2005-11-02 at 13:20 -0600, Mary Leete wrote: Hello! Congratulations to all who worked on OOo 2.0! It's fabulous! If anyone is looking for a great manual, Free Software For Dummies, includes about 200 pages on

Re: [users] Start page numbering at page 4 [Solved]

2005-11-04 Thread Fajar Priyanto
On Friday 04 November 2005 23:41, Dan Lewis wrote: I would think that you want a few page styles. Use First Page for the first page. Use another Page Style for your TOC and Preface. (I am assuming you want the Preface to follow the TOC.) Then crreat a third Page Style for the body of your

[users] OpenOffice.org mailing list guidelines was: Re: [users] Re: Manual available for OpenOffice.org 2.0

2005-11-04 Thread Jacqueline McNally
Ain Vagula wrote: G. Roderick Singleton wrote: On Wed, 02 Nov 2005 13:20:15 -0600, Mary Leete wrote: Hello! Congratulations to all who worked on OOo 2.0! It's fabulous! If anyone is looking for a great manual, Free Software For Dummies, includes about 200 pages on OpenOffice.org 2.0.

Re: [users] Start page numbering at page 4 [Solved]

2005-11-04 Thread G. Roderick Singleton
On Sat, 2005-11-05 at 07:44 +0700, Fajar Priyanto wrote: On Friday 04 November 2005 23:41, Dan Lewis wrote: I would think that you want a few page styles. Use First Page for the first page. Use another Page Style for your TOC and Preface. (I am assuming you want the Preface to follow

Re: [users] Howto - Descriptive Statistics Calc

2005-11-04 Thread Joe Conner
See: http://ooextras.sourceforge.net/downloads/english/index.php?command=downloadreal=RepeatedMeasuresANOVA.stc Paul Campbell wrote: Does OO 2 Calc support a capability similiar to MS for Descriptive Statistics ? I am sure I can write a macro to do them, but wondered if there was an add-on

[users] Landscape in portrait

2005-11-04 Thread Zoltán Kócsi
Is it possible to tell OO that in a Writer document, that is portrait, I want a page to be landscape (e.g. I have a wide but not too high table or a drawing that is better represented in landscape as in portrait) *but* I do not want the headers and footers to change from the portrait top and

Re: [users] Start page numbering at page 4 [Solved]

2005-11-04 Thread Fajar Priyanto
On Friday 04 November 2005 23:41, Dan Lewis wrote: I would think that you want a few page styles. Use First Page for the first page. Use another Page Style for your TOC and Preface. (I am assuming you want the Preface to follow the TOC.) Then crreat a third Page Style for the body of your

Re: [users] Re: Inserting Special Characters (Windows)

2005-11-04 Thread John Jordan
On 4 Nov 2005, at 12:24, Randomthots wrote: John Jordan wrote: I have OO.o 1.9 on my Linux laptop and 2.0 on my Windows 2000 desktop. On the Linux version I can enter a special character by holding Shift+Ctrl and typing the hex code. For example, Ctrl+Shift+02A4 gives me the d-yogh

[users] Re: Database feature

2005-11-04 Thread Asif Lodhi
Hi Brewster, On 11/3/05, wbg [EMAIL PROTECTED] wrote: On Thu, 2005-11-03 at 03:33, Dan Lewis wrote: X .., I saw no mention of any sort of Global Update feature - i.e.,