Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Lotus 1-2-3 vs Excel

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-08-2009
Member
 
Join Date: Aug 2009
Posts: 6
Lotus 1-2-3 vs Excel
  

I have heard a lot of thing about Lotus 123 & Excel Spread Sheet conflict some say this is best some say that is better... Can anyone tell me the differences between the both.... I am really confused about it...! Please Help...!

Reply With Quote
  #2  
Old 31-08-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: Lotus 1-2-3 vs Excel

Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). It was the IBM PC's first "killer application"; its huge popularity in the mid-1980s contributed significantly to the success of the IBM PC in the corporate environment.
Reply With Quote
  #3  
Old 31-08-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: Lotus 1-2-3 vs Excel

About converting worksheets between Excel and Lotus 1-2-3

Converting files
Saving in Microsoft Excel file format : Excel stores the file format of any file you open. When you save a file, Excel uses the same format the file was in when you opened it. For example, if you open a Lotus 1-2-3 file with a .wk3 extension, Excel saves the file as a Lotus 1-2-3 file with a .wk3 extension. If you make changes to the file in Excel, you should save the file in an Excel file format to be sure all of your changes are saved. To do this, be sure to use the Save As command and select Microsoft Excel Workbook in the Save as type box.

Changing the file name extension : When you save a workbook as a different type by changing the file format in the Save as type box, you do not have to change the file name, because Excel saves a copy of the workbook with a different file name extension. For example, a Lotus 1-2-3 Release 4.0 file has a file name extension of .wk4; Excel Workbook format uses the .xls file name extension.

Typing a new extension in the File name box, or renaming the file with a new extension in the folder window, is not sufficient to change the file type. You must also change the Save as type box to the file type you want.

Applying formatting from associated Lotus 1-2-3 files : When you open a Lotus 1-2-3 worksheet or workbook in Excel, Excel applies the formatting in the associated .fmt, .fm3, or .all file. Make sure the associated file is stored in the same folder as the .wk? file. If you save a Lotus 1-2-3 file in Excel format, Excel saves the spreadsheet data and formatting in a single workbook file.

Converting formulas
Using Lotus 1-2-3 rules to calculate formulas : When you open a Lotus 1-2-3 worksheet in Microsoft Excel, the Transition formula evaluation check box is automatically selected for that sheet to ensure that Excel calculates the formulas according to the Lotus 1-2-3 rules.

If you save a Lotus 1-2-3 worksheet as an Excel worksheet, the Transition formula evaluation check box remains selected and Excel will calculate the formulas according to the Lotus 1-2-3 rules until you clear it.

How cells are used in formulas : Once you have converted a Lotus 1-2-3 file to an Excel workbook, you can examine the relationships of the cells and formulas within the worksheet by using the worksheet audit commands.

Some formulas may not convert : If a formula can't be converted to an Excel formula, the worksheet shows the last value calculated for the formula in Lotus 1-2-3.

Converting macros
Microsoft Excel 2000 and later versions do not run Lotus 1-2-3 macros. You can rewrite any macros that you need in Visual Basic for Applications. For information about writing Excel macro code.
Reply With Quote
  #4  
Old 31-08-2009
Member
 
Join Date: Apr 2008
Posts: 2,139
Re: Lotus 1-2-3 vs Excel

Lotus was a really best spread sheet as compare to excel at a time. But today it is behind due to lack of development in the application. In most field still Excel is not so efficient as Lotus like a bast chart that gives a 3D data view. Until Excel was released, Lotus gives more features in both quality and efficiency. It is not just a spreadsheet program but more efficient and reliable. Lotus ruled the market for number of years. Now Excel is the most common and used spreadsheet. Excel is not more popular for GUI support.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Lotus 1-2-3 vs Excel"
Thread Thread Starter Forum Replies Last Post
What are the features of IBM Lotus Symphony Robert59 Windows Software 4 08-03-2010 09:59 AM
Need information on IBM Lotus Symphony Cruzz Windows Software 5 13-01-2010 01:07 AM
LG Lotus extented battery Chhaya Portable Devices 2 07-07-2009 10:34 PM
Export Lotus Notes evansmith Technology & Internet 5 01-04-2009 03:23 PM
Lotus SmartSuite Chris Weir Vista Help 21 06-12-2008 09:37 AM


All times are GMT +5.5. The time now is 03:31 PM.