pgovotsos wrote:The last version of Lotus 1-2-3 for DOS runs really well on current Windows versions. 2.4 is the last English version. To get it to work the best, you need to edit the properties (of the icon not in 1-2-3) to give it at least 1MB of EXPANDED memory, NOT extended memory.
So modify the icon on the Amiga so it will work with the PC version?
No, I mean the shortcut icon on Windows. You can set the properties for the DOS program the shortcut points to to use there. Memory is the thing that you most want to pay attention to. For 1-2-3 for DOS, to use larger spreadsheets you need to add EXPANDED memory. Think of it as sort of similar to the RAM disk on the Amiga. You can't access it directly like on the Amiga but programs can. Extended memory is more used to load system components into high memory to free up some of the 640 KB conventional memory so you can run larger programs.
Basically, conventional memory is where programs run, extended memory is where system components can be shoved to and run from, expanded memory is where programs can store data.
Very good. What I really want/need is a way for partners/clients to be able to read these. I suppose a quick conversion will do that if I'm willing to forego some of the features.
Looking at the YouTube videos, I think I'll go with Quattro Pro. I'll try saving a file to Dropbox and opening it in FinalCalc. Fingers crossed. It'll take me some time to get around to this but I'll post back when I'm done. Thanks again!
Pretty much every PC spreadsheet program can open 1-2-3 files but, as you discovered, not all can save in a format that Amiga spreadsheets can import. Lotus 1-2-3 can (obviously), all versions of Quattro Pro (DOS or Windows) can, MS Excel for DOS can but I'm not sure if all the Windows versions can - version 5 for Windows can I know.
When you are selecting the format to save the file from PC spreadsheets, you have to select 1-2-3 for DOS. 1-2-3 for Windows files won't import to Amiga spreadsheet programs.