Amiga OS, Workbench and Kickstart, Utilities, Optimizations, Hacks and all things file/usage related
User avatar
TenLeftFingers
 
Posts: 76
Joined: Wed Mar 02, 2016 7:19 am

Sharing classic spreadsheets on modern computers

by TenLeftFingers Wed May 31, 2017 12:36 pm

I wasn't expecting this to work, but I did an experiment today to see if I could do spreadsheet work on classic Amiga and send the results to a colleague to allow them to continue editing it. Having the great Dropbox client on Amiga (AmigaCloudHandlers, thanks to Norbert Kett!) made it even easier.

I created a spreadsheet identical to one I was working on this week - but on Amiga using Final Calc.
screenshot.png


Saving as the "1-2-3" format (and only this one), I was able to open it normally on Libre Office.
spreadsheet-LO.png


Some shortcomings
    As you can see, the colour formatting was lost. Also, you cant change the background colour of a cell on Final Calc which will mean adding additional columns for certain flags.

    Going the other way doesn't work; I can't get Final Calc to recognise any of LibreOffice's export formats by default.

    I haven't tried with proper maths functions to see how they make it across, but I'd be astonished if basics like summation, multiplication etc didn't work.

But if it means I can work on my Amiga for an hour a day instead of my usual computer (or in addition too), then I'm very happy with the results so far. <3
User avatar
Shot97
 
Posts: 410
Joined: Thu Mar 10, 2016 8:01 pm
Location: Detroit, MI, USA

Re: Sharing classic spreadsheets on modern computers

by Shot97 Wed May 31, 2017 1:08 pm

Oh, wow. Pretty impressive spreadsheet program on the Amiga. Never heard of it until now, gave it a little gander in a search though. Says it was released in 1995, so I'm guessing it's a strictly 2.0-3.1 affair. I saw mention of it having evolved from TurboCalc, which did have many 1.3 releases. Wondering if that program contains 1-2-3 save functions. I wonder if getting your hands on the last 1-2-3 version might help with going back to the Amiga. It was last updated in 2002, so I imagine it would be possible to work on something using your preferred newer spreadsheet program and then saving it in a format that would be recognized by the 2002 1-2-3, then you could use that program save in an older format the Amiga might recognize. Added steps of course, but it might be worth a try.

Very nice read and enjoyed the added pics.
User avatar
intric8
Site Admin
 
Posts: 721
Joined: Fri Jan 01, 2016 11:49 am
Location: Seattle, WA

Re: Sharing classic spreadsheets on modern computers

by intric8 Wed May 31, 2017 1:26 pm

@TenLeftFingers - very cool stuff.

And, let's be honest. Your Fast RAM is totally bonkers! :)
User avatar
TenLeftFingers
 
Posts: 76
Joined: Wed Mar 02, 2016 7:19 am

Re: Sharing classic spreadsheets on modern computers

by TenLeftFingers Wed May 31, 2017 2:17 pm

Shot97 wrote:I wonder if getting your hands on the last 1-2-3 version might help with going back to the Amiga. It was last updated in 2002, so I imagine it would be possible to work on something using your preferred newer spreadsheet program and then saving it in a format that would be recognized by the 2002 1-2-3, then you could use that program save in an older format the Amiga might recognize. Added steps of course, but it might be worth a try.

Very nice read and enjoyed the added pics.


Thanks Shot97, I'm glad you enjoyed it. That's an interesting idea and thank you for the helpful information. I'm looking for it now, although as I search I wonder if I have the patience for a third app. I can just about tolerate using two apps. Having said that, there was (is?) a great app to automate GUI application interactions on linux called Xpresser[1] that could do it unattended. We used it to open documents in one format, save as a different format, open an email, fill in the contact details and attach the new document format. Pretty cool.

1: https://www.youtube.com/watch?v=b-xxBBP ... &index=658
User avatar
TenLeftFingers
 
Posts: 76
Joined: Wed Mar 02, 2016 7:19 am

Re: Sharing classic spreadsheets on modern computers

by TenLeftFingers Wed May 31, 2017 2:21 pm

intric8 wrote:@TenLeftFingers - very cool stuff.

And, let's be honest. Your Fast RAM is totally bonkers! :)

Hehe, yeah that's an accelerator giving me the same 020 but also 28MHz and 64MB RAM. It makes a noticeable difference :)
User avatar
motrucker
 
Posts: 6
Joined: Thu Feb 02, 2017 6:03 pm
Location: Maryland, USA

Re: Sharing classic spreadsheets on modern computers

by motrucker Tue Sep 12, 2017 3:08 pm

I didn't realize Final Calc was upgraded that late. My copy works fine, but it doesn't accept dates passed 2K. All my Softwood stuff was registered, so I should have received all the upgrades. There are times when that date issue can be a real problem though.
I use TurboCalc 3.5, and it works fine with most newer pc programs.
Return to Software

Who is online

Users browsing this forum: No registered users and 1 guest