[users] excel 2002 and abaove

2011-05-02 Thread S Bhandari
Hello please confirm if open office supports MS office format excel 2002 and above ? regds Sushil Bhandari Tata Consultancy Services 4 & 5th floor, PTI Building, No 4, Sansad Marg, New Delhi - 110001,Delhi India Mailto: s.bhand...@tcs.com Website: http://www.tcs.com

Re: [users] Excel problem

2010-05-02 Thread Abdul Hai
:46 Subject: Re: [users] Excel problem On Sunday 02 May 2010 03:58, Abdul Hai wrote: > Thanks for the reply I have only been to the forum so I was not able to > reply earlier. > > How do I change the attribute? > Don't worry about it. From Calc just "File - Save As...&quo

Re: [users] Excel problem

2010-05-02 Thread Michael Adams
On Sunday 02 May 2010 03:58, Abdul Hai wrote: > Thanks for the reply I have only been to the forum so I was not able to > reply earlier. > > How do I change the attribute? > Don't worry about it. From Calc just "File - Save As..." a copy of the file to your documents folder. This new copy will be

[users] Excel problem

2010-05-01 Thread Abdul Hai
Thanks for the reply I have only been to the forum so I was not able to reply earlier. How do I change the attribute? Date: Sat, 01 May 2010 07:05:18 -0400 From: Daniel Lewis Content-Type: text/plain; charset=UTF-8; format=flowed Subject: [users] Excel problem Abdul Hai wrote: > I have b

Re: [users] Excel problem

2010-05-01 Thread Daniel Lewis
Abdul Hai wrote: I have been sent an Excel document but I could not find anyway of editing it. I have sent this message last night it does not appear to have got through. Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/ You did

[users] Excel problem

2010-05-01 Thread Abdul Hai
I have been sent an Excel document but I could not find anyway of editing it. I have sent this message last night it does not appear to have got through. Support solar power in the developing world. http://www.everyclick.com/solaraid http://www.solar-aid.org/

[users] Excel/OO compatibility with respect to cell comments or notes

2010-01-04 Thread adriennew
Hi all, I opened an Excel document that had cell comments, in Open Office Calc. When I closed the file in Calc I saved it as an Excel file. However when I reopened the file in Excel, the cell comments are visible onscreen but will not print. The

Re: [users] Excel 2004 for Mac and web pages

2009-09-09 Thread Robert Holtzman
On Wed, Sep 09, 2009 at 07:38:15AM -0400, Robert Peirce wrote: > In Excel for Windows, you can access a web page and specify the specific > information you are after. In Excel 2004 for Mac you cannot. > Consequently, if your spreadsheet accesses a particular line and it > moves because of web

[users] Excel 2004 for Mac and web pages

2009-09-09 Thread Robert Peirce
In Excel for Windows, you can access a web page and specify the specific information you are after. In Excel 2004 for Mac you cannot. Consequently, if your spreadsheet accesses a particular line and it moves because of web page changes, you lose the information and have to revise your spreads

Re: [users] Excel File Import into Calc

2009-03-19 Thread JOE Conner
Brian Barker wrote: At 18:20 19/03/2009 -0700, Suzanne L. Perry wrote: There is a setting at Tools | Options... | OpenOffice.org Calc | Calculate | Precision as shown. If this is ticked, the displayed values - rounded according to the cell formatting - are used in your comparison rather than

Re: [users] Excel File Import into Calc

2009-03-19 Thread Brian Barker
At 18:20 19/03/2009 -0700, Suzanne L. Perry wrote: Excel file import into OO Calc. To perform some checks of extended figures on the imported file, I created a new column and inserted a formula to achieve the same result. Since the spreadsheet is over 4500 lines long, I wanted to compare the

[users] Excel File Import into Calc

2009-03-19 Thread S Perry
  Excel file import into OO Calc.   To perform some checks of extended figures on the imported file, I created a new column and inserted a formula to achieve the same result. Since the spreadsheet is over 4500 lines long, I wanted to compare the results quickly.   Picture this, if you will: Ce

Re: [users] Excel

2008-05-03 Thread James Knott
Robert Dinda wrote: Java People: Can I use Java Open Office to read & manipulate Microsoft Excel Files? We're not Java people. Java is a product from Sun and when you update Java, they also offer OpenOffice. To answer your question, OpenOffice can work with Excel files, except those

[users] Excel

2008-05-03 Thread Robert Dinda
Java People: Can I use Java Open Office to read & manipulate Microsoft Excel Files? Bob Dinda _ Back to work after baby–how do you know when you’re ready? http://lifestyle.msn.com/familyandparenting/articleNW.aspx?cp-documentid=57

Re: [users] excel spreadsheet

2008-03-15 Thread James Knott
[EMAIL PROTECTED] wrote: I AM USING VERSION 2.0.2 OF OPENOFFICE. IDOWNLOADED A SPREADSHEET X.L.S HOW CAN I USE OPENOFFICE TO READ IT AND EXTRACT INFORMATION. Assuming it's not the new Office 2007 (.XLSX) format, it should open without problem. Just double click on the file and see what

Re: [users] excel spreadsheet

2008-03-15 Thread Johnny Rosenberg
2008/3/14, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > I AM USING VERSION 2.0.2 OF OPENOFFICE. IDOWNLOADED A SPREADSHEET X.L.SHOW > CAN I USE OPENOFFICE > TO READ IT AND EXTRACT INFORMATION. Please don't use capitals only, because it means that you are shouting, which some people don't like. A

Re: [users] excel spreadsheet

2008-03-15 Thread Harold Fuchs
On 14/03/2008, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I AM USING VERSION 2.0.2 OF OPENOFFICE. IDOWNLOADED A SPREADSHEET X.L.SHOW > CAN I USE OPENOFFICE > TO READ IT AND EXTRACT INFORMATION. Just open it in Calc. Assuming you are using Windows, either a) right click on the file, choo

[users] excel spreadsheet

2008-03-14 Thread [EMAIL PROTECTED]
I AM USING VERSION 2.0.2 OF OPENOFFICE. IDOWNLOADED A SPREADSHEET X.L.S HOW CAN I USE OPENOFFICE TO READ IT AND EXTRACT INFORMATION. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTE

[users] Excel

2008-01-24 Thread Colin L. Swan
Thank you for all the replies I received re my Excel query!!! Colin. cls

Re: [users] excel

2008-01-14 Thread James Knott
margaret bagnall wrote: > i woudl like to download excell please help > > You cannot download Excel from www.openoffice.org. Excel is a commercial application, which you must pay a significant amount for. You can download OpenOffice for free, from www.openoffice.org. OpenOffice is a full off

Re: [users] excel

2008-01-14 Thread rlshadow
You'll need to go to the Microsoft web site to download Excel. If you want to download OpenOffice, for free, go to OpenOffice.org. -Original Message- From: margaret bagnall <[EMAIL PROTECTED]> To: users@openoffice.org Sent: Mon, 14 Jan 2008 10:15 am Subject: [users] excel

[users] excel

2008-01-14 Thread margaret bagnall
i woudl like to download excell please help - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] Excel Can't Multiply - AppScout

2007-09-27 Thread James Knott
http://www.appscout.com/2007/09/excel_cant_multiply.php -- Use OpenOffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[users] excel conversion

2007-09-21 Thread noranross
I have a large(1.4MB) excel spreadsheet which is locked unfortunately. I would love to get into Open Office. it sort of loads but not completely. it seems that there are macros using basic which are not converted. Is this normal. if i sent the spreadsheet could someone convert it please. OOis

Re: [users] excel spreadsheet calculations jumbled up when opened with calc.

2007-09-15 Thread Sa1496
In a message dated 9/15/2007 2:20:24 A.M. Central Daylight Time, [EMAIL PROTECTED] writes: [EMAIL PROTECTED] PLEASE UNSUBSCRIBE > [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) ; THANKS ** See what's new at http://www.aol.com

Re: [users] excel spreadsheet calculations jumbled up when opened with calc.

2007-09-15 Thread Brian Barker
At 12:27 14/09/2007 -0800, Musomba Noname wrote: The spreadsheet is here http://www.ezziarts.com/mullah.xls When opened in excel, the 'balance owed' column data ascends nice and correctly, see screen cap here:- http://www.ezziarts.com/excel.jpg When opened in calc, the 'balance owed' column g

Re: [users] excel spreadsheet calculations jumbled up when opened with calc.

2007-09-15 Thread Robert
On Friday 14 September 2007, musomba wrote: > Greetings everybody. > > The spreadsheet is here > > http://www.ezziarts.com/mullah.xls > > When opened in excel, the 'balance owed' column data ascends nice and > correctly, see screen cap here:- > > http://www.ezziarts.com/excel.jpg > > When opened in

Re: [users] excel spreadsheet calculations jumbled up when opened with calc.

2007-09-15 Thread Adrian Try
Hi Musomba When opened in calc, the 'balance owed' column gets all jumbled up. see screen cap here:- I and every one else at work uses excel, My Boss has begun to use open office on his laptop and wants me to solve this problem. he does not believe its an open office problem. I agree with y

[users] excel spreadsheet calculations jumbled up when opened with calc.

2007-09-15 Thread musomba
Greetings everybody. The spreadsheet is here http://www.ezziarts.com/mullah.xls When opened in excel, the 'balance owed' column data ascends nice and correctly, see screen cap here:- http://www.ezziarts.com/excel.jpg When opened in calc, the 'balance owed' column gets all jumbled up. see scree

Re: [users] excel dialer capability

2007-09-04 Thread Andrew Fisk
MIke, Do you know what kind of phone system you friend is hooked up to? Thanks Andy Spitfire Computer Services 441 Beaver Street Suite 202 Sewickley, PA 15143 Phone (412) 749-0162 fax: (602) 476-8868 [EMAIL PROTECTED] www.spitcomp.com On Aug 31, 2007, at Friday, August 31, 200712:40 PM, mike

[users] excel dialer capability

2007-09-02 Thread mike campbell
MS Excel has the ability to dial a phone number from data. A freind of mine has this add-on and it's called Excel Dialer. Can anyone tell me if there is such a add-on for open office yet? Best Regards Mike I would gladly make a contributon to anyone who can do this for me.

Re: [users] Excel crashes after memo field was edited by Calc

2007-07-24 Thread Daniel Rentz
[EMAIL PROTECTED] schrieb: Hi all, has anyone had such a problem before? A *.xls file has message entries for a cell (shown with a red square in the top right hand corner). The user's ID is shown, with the note. This is created by Excel 2003. OOo Calc 2.2.0 opens the cell and edits the content

Re: [users] excel

2007-07-22 Thread CPHennessy
On Monday 02 July 2007, + L. Jeanne Jain wrote: > If someone sends me an excel file, can I open it with open office? Please > advise. Yes. Please reply to users@openoffice.org only -- CPH : openoffice.org contributor Maybe your question has been answered already?

[users] Excel crashes after memo field was edited by Calc

2007-07-20 Thread [EMAIL PROTECTED]
Hi all, has anyone had such a problem before? A *.xls file has message entries for a cell (shown with a red square in the top right hand corner). The user's ID is shown, with the note. This is created by Excel 2003. OOo Calc 2.2.0 opens the cell and edits the contents. The spreadsheet is saved i

[users] Re : [users] Excel/Calc function list

2007-07-11 Thread Boris Ratak
Thx, this is just what I needed ! Boris - Message d'origine De : Daniel Rentz <[EMAIL PROTECTED]> À : users@openoffice.org Envoyé le : Mardi, 10 Juillet 2007, 18h10mn 50s Objet : Re: [users] Excel/Calc function list Boris Ratak schrieb: > Hi, > > Does anyone know

Re: [users] Excel/Calc function list

2007-07-10 Thread Daniel Rentz
Boris Ratak schrieb: Hi, Does anyone knows a document showing the Excel functions and their equivalent (or lack of equivalent) in Calc ? http://sc.openoffice.org/testdocs/formula_import_biff8.xls is a spreadsheet document in MS-Excel format that contains all built-in and add-in functions sup

Re: [users] Excel/Calc function list

2007-07-10 Thread Harold Fuchs
On 10/07/07, Boris Ratak <[EMAIL PROTECTED]> wrote: Hi, Does anyone knows a document showing the Excel functions and their equivalent (or lack of equivalent) in Calc ? Thx Try http://documentation.openoffice.org/manuals/oooauthors2/0606MG-DifferencesInUseCalcExcel.pdf Exploring from the ro

[users] Excel/Calc function list

2007-07-10 Thread Boris Ratak
Hi, Does anyone knows a document showing the Excel functions and their equivalent (or lack of equivalent) in Calc ? Thx _ Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

Re: [users] excel

2007-07-02 Thread Colin Sharpe
Yes you can, I've done it many times. Colin. --- "L. Jeanne Jain" <[EMAIL PROTECTED]> wrote: > If someone sends me an excel file, can I open it > with open office? Please advise. > > Thank you. > > Jeanne >

Re: [users] excel

2007-07-02 Thread Georgiarivers1
what is this all about?

[users] excel

2007-07-02 Thread L. Jeanne Jain
If someone sends me an excel file, can I open it with open office? Please advise. Thank you. Jeanne

Re: [users] Excel files problem

2007-06-24 Thread Paul
Dear Sir, good day... I have that problem with excel files from microsoft office which are working like a flash (I guess they have a macro). Well my problem is that i can not run such files with Calc from openoffice it starts with stable window and is not enabled (not active) while if i tried

[users] Excel files problem

2007-06-24 Thread Amjad EL-Meddah
Dear Sir, good day... I have that problem with excel files from microsoft office which are working like a flash (I guess they have a macro). Well my problem is that i can not run such files with Calc from openoffice it starts with stable window and is not enabled (not active) while if i tried

Re: [users] excel spread sheet

2007-06-18 Thread Paul
I have an excel spread sheet from office 2002 that I can not get to convert to open office. Can you advise me. I have attached it to this email. Any help would be appreciated. Attachments don't get through to the list. An excel spreadsheet created by Office 2002 should be able to be opened

[users] excel spread sheet

2007-06-18 Thread malcolm
I have an excel spread sheet from office 2002 that I can not get to convert to open office. Can you advise me. I have attached it to this email. Any help would be appreciated.- To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

Re: [users] Excel files?

2007-03-25 Thread Christen Lewis
PROTECTED]> Sent: Saturday, March 24, 2007 6:37:45 PM Subject: Re: [users] Excel files? On Saturday March 24 2007 2:52 pm, Christen Lewis wrote: > I downloaded OO2.1 for Mac OSX (Tiger) and when I double click the > icon, the writer program opens. I can't seem to find any > spreadshee

Re: [users] Excel files?

2007-03-24 Thread Dan Lewis
On Saturday March 24 2007 2:52 pm, Christen Lewis wrote: > I downloaded OO2.1 for Mac OSX (Tiger) and when I double click the > icon, the writer program opens. I can't seem to find any > spreadsheet program--do they need to be downloaded individually, or > is the writer the only program available

Re: [users] Excel files?

2007-03-24 Thread TerryJ
TerryJ wrote: > > > > Christen Lewis wrote: >> >> I downloaded OO2.1 for Mac OSX (Tiger) and when I double click the icon, >> the writer program opens. I can't seem to find any spreadsheet >> program--do they need to be downloaded individually, or is the writer the >> only program available

Re: [users] Excel files?

2007-03-24 Thread TerryJ
Christen Lewis wrote: > > I downloaded OO2.1 for Mac OSX (Tiger) and when I double click the icon, > the writer program opens. I can't seem to find any spreadsheet > program--do they need to be downloaded individually, or is the writer the > only program available for mac? > > Thanks very muc

[users] Excel files?

2007-03-24 Thread Christen Lewis
I downloaded OO2.1 for Mac OSX (Tiger) and when I double click the icon, the writer program opens. I can't seem to find any spreadsheet program--do they need to be downloaded individually, or is the writer the only program available for mac? Thanks very much, christen lewis Visit my ebay sto

Re: [users] Excel macros

2007-03-24 Thread TerryJ
Jan Altman wrote: > > Will Excel macros work in the Open Office spreadsheet program? > > I am curious about *both* VBA macros, and those written with Excel 4's > original macro language. > > Thanks for your help! > Jan Altman > > > I understand that VBA will work in the Novell version.

Re: [users] Excel macros

2007-03-24 Thread Hylton Conacher (ZR1HPC)
Jan Altman wrote: > Will Excel macros work in the Open Office spreadsheet program? > > I am curious about *both* VBA macros, and those written with Excel 4's > original macro language. In short NO. Openoffice,org has its own macro language I believe. Regards Hylton Please reply to users@openoffi

[users] Excel macros

2007-03-23 Thread Jan Altman
Will Excel macros work in the Open Office spreadsheet program? I am curious about *both* VBA macros, and those written with Excel 4's original macro language. Thanks for your help! Jan Altman

[users] Excel Spreadsheets

2007-03-20 Thread Keith Barry
Guys Thanks for the help. Luckily I only need to enter data, I can then send the sheet back to the originators to press the button to use the macros in their Excel program. In theory, therefore, I should be able to enter the data, save as per the instructions about preserving the VBA macros an

Re: [users] Excel Spreadsheet Macros

2007-03-19 Thread TerryJ
Keith Barry wrote: > > I have to prepare our qtr'ly return on an Excel spreadsheet supplied to > me running macros. I know, from a previous post, that the language is > different for both programs but, if I enter the data in OO and then save > it as an Excel spreadsheet, will the recipients b

Re: [users] Excel Spreadsheet Macros

2007-03-19 Thread Anthony Chilco
Hi Keith, There is a global setting that will preserve excel macros when saving, after editing an imported spreadsheet. You'll find it under 'tools / options / load-save / VBA properties'. tc Keith Barry wrote: I have to prepare our qtr'ly return on an Excel spreadsheet supplied to me running

[users] Excel Spreadsheet Macros

2007-03-19 Thread Keith Barry
I have to prepare our qtr'ly return on an Excel spreadsheet supplied to me running macros. I know, from a previous post, that the language is different for both programs but, if I enter the data in OO and then save it as an Excel spreadsheet, will the recipients be able to activate the mscros f

Re: [users] excel macro's

2007-03-04 Thread CPHennessy
On Wednesday 28 February 2007, + Mark Hannessen wrote: > [ MODERATED ] *** > Hi list, > > I am trying to run a few excel documents under openoffice, > but every time I try to open the document complains about a "Scripting > Framework" error or something like that.. > > does any

Re: [users] Excel Dowload

2007-03-03 Thread Dan Lewis
On Saturday March 03 2007 11:38 am, Johnny Andersson wrote: > 2007/3/2, Jeanne Sheldon <[EMAIL PROTECTED]>: > > Good Morning: > > I just signed up for openoffice today and have XP, > > on a HP computer with an EXECL reader but no EXCEL program. How > > do I download just EXCEL. > > > > Some loaned

Re: [users] Excel Dowload

2007-03-03 Thread Johnny Andersson
2007/3/2, Jeanne Sheldon <[EMAIL PROTECTED]>: Good Morning: I just signed up for openoffice today and have XP, on a HP computer with an EXECL reader but no EXCEL program. How do I download just EXCEL. Some loaned me their WORD program so I have that. If that someone didn't remove Word on his

Re: [users] Excel Dowload

2007-03-03 Thread Marc Hug
What you can deownload is not Word or Excel or PowerPoint, but similar programs that are free. See at . You download the whole OpenOffice (you can't only select Writer or Calc or some other part). Then you install it. Marc H. Jeanne Sheldon a écrit : Good Mornin

[users] Excel Dowload

2007-03-03 Thread Jeanne Sheldon
Good Morning: I just signed up for openoffice today and have XP, on a HP computer with an EXECL reader but no EXCEL program. How do I download just EXCEL. Some loaned me their WORD program so I have that. Thanks in advance for your help. Jeanne. or Chynna27 my e-mail account that I signed up

Re: [users] excel macro's

2007-02-28 Thread TerryJ
Mark Hannessen wrote: > > Hi list, > > I am trying to run a few excel documents under openoffice, > but every time I try to open the document complains about a "Scripting > Framework" error or something like that.. > > does anyone know what might cause this problem? > > OOo does not read

[users] excel macro's

2007-02-28 Thread Mark Hannessen
Hi list, I am trying to run a few excel documents under openoffice, but every time I try to open the document complains about a "Scripting Framework" error or something like that.. does anyone know what might cause this problem? --

Re: [users] Excel formula

2007-02-13 Thread TerryJ
what is > the largest number of significant digits in your entries? > > Dan >> - Original Message - >> From: "Dan Lewis" <[EMAIL PROTECTED]> >> To: ; "Ferencz" <[EMAIL PROTECTED]> >> Sent: 12 February, 2007 16:11 >> Subjec

Re: [users] Excel formula

2007-02-13 Thread Joshua Simons
Sorry for my lack of accuracy.. :-) On Feb 13, 2007, at 1:49 PM, James Knott wrote: Joshua Simons wrote: Double precision floating point values have only about 15 digits worth of accuracy--using anything above that is representing a false degree of accuracy. That would be a false degree o

Re: [users] Excel formula

2007-02-13 Thread James Knott
Joshua Simons wrote: Double precision floating point values have only about 15 digits worth of accuracy--using anything above that is representing a false degree of accuracy. That would be a false degree of precision, not accuracy. Accuracy refers to how close to correct something is. Preci

Re: [users] Excel formula

2007-02-13 Thread Dan Lewis
your entries have more than 20 decimal places? Or perhaps more to the point, what is the largest number of significant digits in your entries? Dan > - Original Message - > From: "Dan Lewis" <[EMAIL PROTECTED]> > To: ; "Ferencz" <[EMAIL PROTECTED]> &

Re: [users] Excel formula

2007-02-13 Thread Joshua Simons
- Original Message - From: "Anthony Chilco" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: 12 February, 2007 17:24 Subject: Re: [users] Excel formula Hi Ferencz, I pasted your formula in a spreadsheet, added some values in the referenced cells and it works fine.

Re: [users] Excel formula

2007-02-13 Thread Anthony Chilco
encz wrote: Hi tc Thx but that is is wrong the formula works fine in Excel, no problem. Ferencz - Original Message - From: "Anthony Chilco" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: 12 February, 2007 17:24 Subject: Re: [users] Excel formula Hi Ferencz, I

Re: [users] Excel formula

2007-02-13 Thread Ferencz
Hi tc Thx but that is is wrong the formula works fine in Excel, no problem. Ferencz - Original Message - From: "Anthony Chilco" <[EMAIL PROTECTED]> To: ; <[EMAIL PROTECTED]> Sent: 12 February, 2007 17:24 Subject: Re: [users] Excel formula Hi Ferencz, I pa

Re: [users] Excel formula

2007-02-13 Thread Ferencz
Thx Copied your formula into spreadsheet get error 501 It seems I2 is higher than 20 does not calculate Ferencz - Original Message - From: "Dan Lewis" <[EMAIL PROTECTED]> To: ; "Ferencz" <[EMAIL PROTECTED]> Sent: 12 February, 2007 16:11 Subject: Re: [u

Re: [users] Excel formula

2007-02-12 Thread Anthony Chilco
erencz - Original Message - From: "Dan Lewis" <[EMAIL PROTECTED]> To: Cc: "Ferencz" <[EMAIL PROTECTED]> Sent: 10 February, 2007 23:02 Subject: Re: [users] Excel formula Comment in-line On Saturday February 10 2007 12:27 pm, Joe Conner wrote: Calc uses semicolon

Re: [users] Excel formula

2007-02-12 Thread Dan Lewis
t; Err:502) > > > > Ferencz > > > > > > - Original Message - > > From: "Dan Lewis" <[EMAIL PROTECTED]> > > To: > > Cc: "Ferencz" <[EMAIL PROTECTED]> > > Sent: 10 February, 2007 23:02 > > Subject: Re:

Re: [users] Excel formula

2007-02-12 Thread TerryJ
ot;Dan Lewis" <[EMAIL PROTECTED]> > To: > Cc: "Ferencz" <[EMAIL PROTECTED]> > Sent: 10 February, 2007 23:02 > Subject: Re: [users] Excel formula > >> Comment in-line >> >> On Saturday February 10 2007 12:27 pm, Joe Conner wrote: >>&g

Re: [users] Excel formula

2007-02-11 Thread Joe Conner
Ferencz wrote: Thx I have replaced the "," with ";" but still no result (get Err:502) Ferencz - Original Message - From: "Dan Lewis" <[EMAIL PROTECTED]> To: Cc: "Ferencz" <[EMAIL PROTECTED]> Sent: 10 February, 2007 23:02 Subj

Re: [users] Excel formula

2007-02-11 Thread Ferencz
Thx I have replaced the "," with ";" but still no result (get Err:502) Ferencz - Original Message - From: "Dan Lewis" <[EMAIL PROTECTED]> To: Cc: "Ferencz" <[EMAIL PROTECTED]> Sent: 10 February, 2007 23:02 Subject: Re: [users] Ex

Re: [users] Excel formula

2007-02-11 Thread Pradeep Srinivas
On Saturday 10 Feb 2007, Ferencz wrote (regarding [users] Excel formula): > Openoffice ver 2.1 > xp pro > > I have an excel formula =ROUND(SUM(H5*$I$3+H5),$I$2) which openoffice calc > can't intrepert can someone help > > Thx Hi Ferencz (not sure if that is the right wa

Re: [users] Excel formula

2007-02-10 Thread Dan Lewis
Comment in-line On Saturday February 10 2007 12:27 pm, Joe Conner wrote: > Calc uses semicolons, not commas to separate parameters. I do not > understand what the formula does for you, but I do know that the > ROUND format should be ROUND( NUMBER ; DECIMAL PLACES ) SUM format should be SUM(BE

Re: [users] Excel formula

2007-02-10 Thread Joe Conner
Calc uses semicolons, not commas to separate parameters. I do not understand what the formula does for you, but I do know that the ROUND format should be ROUND( NUMBER ; DECIMAL PLACES ) Ferencz wrote: Openoffice ver 2.1 xp pro I have an excel formula =ROUND(SUM(H5*$I$3+H5),$I$2) which op

[users] Excel formula

2007-02-10 Thread Ferencz
Openoffice ver 2.1 xp pro I have an excel formula =ROUND(SUM(H5*$I$3+H5),$I$2) which openoffice calc can't intrepert can someone help Thx

Re: [users] Excel Macro Error in Excel.ActiveWorkbook.Worksheets

2007-01-29 Thread CPHennessy
On Monday 08 January 2007 09:39, + Matteo Rancilio wrote: > [ MODERATED ] *** > Hi, > > I'm trying to run an excel macro in openoffice. The macro is very simple > but i get an error here > Set wk = Excel.ActiveWorkbook.Worksheets(1) > > Could someone be so kind to help me in th

Re: [users] Excel Macro Error in Excel.ActiveWorkbook.Worksheets

2007-01-08 Thread Arnold Huzen
You didn't say which version of OpenOffice you're using. In the current version there is no support for VBA (as far as I know). So the macro compiler doesn't understand what you mean by Excle.ActiveWorkbook.Worksheets(1). Arnold Huzen Matteo Rancilio schreef: Hi, I'm trying to run an exc

[users] Excel Macro Error in Excel.ActiveWorkbook.Worksheets

2007-01-08 Thread Matteo Rancilio
Hi, I'm trying to run an excel macro in openoffice. The macro is very simple but i get an error here > Set wk = Excel.ActiveWorkbook.Worksheets(1) Could someone be so kind to help me in this? Rem Attribute VBA_ModuleType=VBAModule Option VBASupport 1 Option Explicit Sub convertiData() ' ' Con

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Sandy
Hubert Fitch wrote: Thanks for the reply Sandy! Perhaps I am giving too much information, but I hope that it is interesting to everyone who reads it? I want to provide my CD book customer with a way to use spreadsheets if he/she does not have Execl(r), and want to include an install open of

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Ross Johnson
Hubert Fitch wrote: I read Sandy's explanation (after I had already replied to her first response). She said that Calc opens files with protection enabled by default (for all cells!). Cells aren't "Protected" by default - they are really just tagged as protectable by default (in the Format -

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Hubert Fitch
would be more difficult for open office Calc to look at the Excel file to see what cell ranges are protected, and what ranges are not protected? - Original Message - From: "Kirill S. Palagin" <[EMAIL PROTECTED]> To: Sent: Thursday, November 16, 2006 4:29 PM Subje

RE: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Kirill S. Palagin
OTECTED] > Sent: Thursday, November 16, 2006 4:28 PM > To: users@openoffice.org > Subject: Re: [users] Excel spreadsheets should not open with > cells protected > > Thanks for the reply Sandy! > > Perhaps I am giving too much information, but I hope that it > is interesti

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Hubert Fitch
ption. Thanks for any Help!!! Hubert Fitch - Original Message - From: "Sandy" <[EMAIL PROTECTED]> To: Sent: Thursday, November 16, 2006 1:03 AM Subject: Re: [users] Excel spreadsheets should not open with cells protected Hubert Fitch wrote: My Excel spreadsheets m

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Sandy
Hubert Fitch wrote: - Original Message - From: "Sandy" <[EMAIL PROTECTED]> To: Sent: Thursday, November 16, 2006 1:03 AM Subject: Re: [users] Excel spreadsheets should not open with cells protected Hubert Fitch wrote: My Excel spreadsheets must open like they we

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-16 Thread Hubert Fitch
- Original Message - From: "Sandy" <[EMAIL PROTECTED]> To: Sent: Thursday, November 16, 2006 1:03 AM Subject: Re: [users] Excel spreadsheets should not open with cells protected Hubert Fitch wrote: My Excel spreadsheets must open like they were created, with des

Re: [users] Excel Compatibility

2006-11-16 Thread Marc Hug
I think you should give more information. If you use MS Excel, MS should inform you. OpenOffice is similar to MS Office, but it is not the same. Marc H. John Le Brasseur a écrit : Hi All. This is my first post. I have opened a number of excel files which are linked. I have used the indirect f

Re: [users] Excel spreadsheets should not open with cells protected

2006-11-15 Thread Sandy
Hubert Fitch wrote: My Excel spreadsheets must open like they were created, with desired columns of input cells unprotected. How can I change the behaviour of open office which adds protection when spreadsheets are opened, so that my customers can immediately use their spreadsheets as they ha

[users] Excel spreadsheets should not open with cells protected

2006-11-15 Thread Hubert Fitch
My Excel spreadsheets must open like they were created, with desired columns of input cells unprotected. How can I change the behaviour of open office which adds protection when spreadsheets are opened, so that my customers can immediately use their spreadsheets as they have always been able to

Re: [users] Excel Compatibility

2006-11-15 Thread Anthony Chilco
Hi John, Yes. This is a problem that's documented in the help files. The problem is that with indirects, addresses are created with text strings and the translator will only update excel type references when they are part of a formula. There is a very slick way around the problem which you ca

[users] Excel Compatibility

2006-11-15 Thread John Le Brasseur
Hi All. This is my first post. I have opened a number of excel files which are linked. I have used the indirect function a lot in the files. There seems to be errors to do with the indirect formulae. Is this possible? I use the latest version of Excel. John --

Re: [users] Excel Macros

2006-09-25 Thread KAMI
Barrie Backhurst írta: On Mon, 2006-09-25 at 22:29 +1000, Adrian Try wrote: On Mon, 25 Sep 2006 20:43:54 +1000, Ken Payne <[EMAIL PROTECTED]> wrote: Has anybody written any automatic translators for MS Excel macros? Yes. 1. Sun have created some macro convertors. They are incl

Re: [users] Excel Macros

2006-09-25 Thread Barrie Backhurst
On Mon, 2006-09-25 at 22:29 +1000, Adrian Try wrote: > On Mon, 25 Sep 2006 20:43:54 +1000, Ken Payne <[EMAIL PROTECTED]> wrote: > > > Has anybody written any automatic translators for MS Excel macros? > > Yes. > > 1. Sun have created some macro convertors. They are included in > StarOffice, no

Re: [users] Excel Macros

2006-09-25 Thread SandyU
Not as far as I know. Several months ago, someone wrote in the forum about a project to work on translations and I think I have seen a reference there to a possible translator as well. Ken Payne wrote: Has anybody written any automatic translators for MS Excel macros? -- If you're seeki

Re: [users] Excel Macros

2006-09-25 Thread Adrian Try
On Mon, 25 Sep 2006 20:43:54 +1000, Ken Payne <[EMAIL PROTECTED]> wrote: Has anybody written any automatic translators for MS Excel macros? Yes. 1. Sun have created some macro convertors. They are included in StarOffice, not OpenOffice.org. StarOffice is a commercial version of OpenOffice

  1   2   >