[users] Calc problem

2007-10-16 Thread noranross
Hi I am running Windows XPand OO2.3 I am writing a complex calc system and am having severe problems. I create macros and they are placed automatically in my program Ross1.standard I also have macros in MyMacros.Standard.Module1 that i wish to use. When i try to assign macros to a push button I

Re: [users] Calc problem

2007-03-31 Thread Marc Hug
I am not sure if I understand the problem. What you call window, is it a Note (that you can create in Calc with Insert Note) ? If so, maybe I could help you. If your notes are cells (e.g. A6, or D17 etc.), the problem is not the same. Marc H. John Gregson a écrit : I have been using

Re: [users] Calc problem

2007-03-31 Thread Cor Nouws
Hi John John Gregson wrote: When I select this 'Note window', in Calc, I get 8 green squares, and an Anchor icon at the upper left corner. The size of this 'Window' is 7 col x 8 rows The cursor changes to one with 4 tiny arrows. How do I edit my text in this window? three possibilities: -

Re: [users] Calc problem

2007-03-31 Thread Hagar de l'Est
As you may already know (see your thread on the web-based forum), this is a known bug for the 2.2 : http://qa.openoffice.org/issues/show_bug.cgi?id=74740 Hagar Le 31.03.2007 00:08, John Gregson a écrit : I have been using MS Office for years, but not at a very high level. I have just

Re: [users] Calc problem

2007-03-31 Thread John Gregson
Cor. - Original Message - From: Cor Nouws [EMAIL PROTECTED] To: users@openoffice.org Sent: Saturday, March 31, 2007 2:04 AM Subject: Re: [users] Calc problem Hi John John Gregson wrote: When I select this 'Note window', in Calc, I get 8 green squares, and an Anchor icon

Re: [users] Calc problem

2007-03-31 Thread John Gregson
] = - Original Message - From: Hagar de l'Est [EMAIL PROTECTED] To: users@openoffice.org Sent: Saturday, March 31, 2007 2:08 AM Subject: Re: [users] Calc problem As you may already know (see your thread on the web-based forum), this is a known bug for the 2.2 : http

[users] Calc problem

2007-03-30 Thread John Gregson
I have been using MS Office for years, but not at a very high level. I have just downloaded and started using Open Office 2.2; Windows version. I am having a bit of a problem, no doubt caused by my lack of knowledge. I imported a spreadsheet from MS Excel 2003 into Calc without any problems.

Re: [users] Calc problem

2007-03-30 Thread TerryJ
John Gregson wrote: I have been using MS Office for years, but not at a very high level. I have just downloaded and started using Open Office 2.2; Windows version. I am having a bit of a problem, no doubt caused by my lack of knowledge. I imported a spreadsheet from MS Excel 2003 into

Re: [users] Calc problem

2007-03-30 Thread Brian Barker
At 15:08 30/03/2007 -0700, John Gregson wrote: When I select this 'Note window', in Calc, I get 8 green squares, and an Anchor icon at the upper left corner. The cursor changes to one with 4 tiny arrows. You are almost there! You've selected the note; in this state, you can move or resize

Re: [users] Calc problem

2007-03-30 Thread John Gregson
Terry - Original Message - From: TerryJ [EMAIL PROTECTED] To: users@openoffice.org Sent: Friday, March 30, 2007 5:56 PM Subject: Re: [users] Calc problem John Gregson wrote: I have been using MS Office for years, but not at a very high level. I have just downloaded and started

Re: [users] Calc problem

2007-03-30 Thread TerryJ
John Gregson wrote: Terry - Original Message - From: TerryJ [EMAIL PROTECTED] To: users@openoffice.org Sent: Friday, March 30, 2007 5:56 PM Subject: Re: [users] Calc problem John Gregson wrote: snip I imported a spreadsheet from MS Excel 2003 into Calc without any

[users] calc problem

2007-02-20 Thread aryany dewi
Dear Sir/Madam, I'm using OpenOffice 2.04. I try to find organization chart like Excel's, but it seems that Calc doesn't have it. How can I make it ? And also if I want to put connection between 2 or more symbol (circle, rectagle etc) how can i find short cut like Excel ? Regard's Dewi

Re: [users] calc problem

2006-05-21 Thread Henrik Sundberg
2006/5/20, LBT [EMAIL PROTECTED]: I am using version 2.0 of Open Office. I am supposed to be able to save a Calc spreadsheet as an .xls file. This just does not happen. Instead, I get error messages, and if anything at all is saved, it is undecipherable. Lee Templeton You need to provide more

Re: [users] calc problem

2006-05-21 Thread CPHennessy
On Sat May 20 2006 21:57, + LBT wrote: [ MODERATED ] *** I am using version 2.0 of Open Office. I am supposed to be able to save a Calc spreadsheet as an .xls file. This just does not happen. Instead, I get error messages, and if anything at all is saved, it is

[users] calc problem

2006-05-01 Thread Martin Kliment
hello, I am using openoffice calc version 2.0.2 on fedora core 5 Sum function doesnt work correctly accross multiple files. When I want to add cell A1 on file1 with cell A1 on file2 it works. But when I copy the formula by dragging it to the column B, it changes itself correctly to add B1 on

Re: [users] Calc problem

2005-12-28 Thread CPHennessy
On Sat December 24 2005 23:06, + Eric Duhachek wrote: [ MODERATED ] *** Windows XP, OpenOffice 2.0. Calc spreadsheet program. I set up a spreadsheet with a function for calculating the number of days based on 2 dates. Worked fine until I saved and reopened the

Re: [users] Calc problem

2005-12-26 Thread David Chapman
Eric, What formula are you using? Dave On 12/24/05, Eric Duhachek [EMAIL PROTECTED] wrote: Windows XP, OpenOffice 2.0. Calc spreadsheet program. I set up a spreadsheet with a function for calculating the number of days based on 2 dates. Worked fine until I saved and reopened the

[users] Calc problem

2005-12-25 Thread Eric Duhachek
Windows XP, OpenOffice 2.0. Calc spreadsheet program. I set up a spreadsheet with a function for calculating the number of days based on 2 dates. Worked fine until I saved and reopened the spreadsheet. Now it displays ##MACRO in my formula field. If I retype any part of the formula, say