We all know and love our browsers, Office Applications and other useful software. How would you like the opportunity to carry around your favourite applications anywhere you go? You can have the best software to support your projects wherever you go and not pay a cent. How awesome is that?! That is the power you wield when you use Portable Applications.
Portable Applications can be found under various categories (Please note that by accessing any of the following links you abide by my disclaimer):
Continue reading The Power of Portable Applications (Portable Apps)
How it started.
I was at home and needed to edit a MS Excel 2007 file. Having OpenOffice installed (And only 2003 Excel), I used the Calc module to edit the document and saved the changes made.
Still In the Dark..
After multiple changes and updates on the document, I overwrote the copy on my flash drive. All is well.
…Saw the Light…Oh Oh!
I was however, totally unaware (that on saving) that some of the structural settings native to MS Excel 2007 were modified to function in OpenOffice Calc. I only discovered this issue when on opening, the file complained about being corrupt and the file was to send that day. Oh! Oh!
Attempts at Work
I tried File – Open – Open and Repair
I tried extracting the data from the file
I tried relocating file to the computer
I tried changing computers
I even tried installing a recovery software (unsuccessfully due to no administrative rights!!)
I tried searching for ways to recover file without installing software (which prompted me to pen this piece)
Whilst at home I attempted to open the file once more with the suspicion of something being wrong with the system at work or flash drive file. No such luck.
With a prayer and fingers crossed, I opened the file in OpenOffice Calc and …BINGO!!
It was all there. Nice and Open. I re-saved this time as MS Excel 2003. (Please note that this article in no way is to discredit the great creation that is OpenOffice. I have never had any issues with switching from any of the other components in OpenOffice to their counterparts in MS Office Suite, except with Excel 2007. )
After additional changes I was able to successfully open the file in Excel 2007 (compatibility mode) and so send the file to the respective recipient.
Lessons to To Be Learnt
Always save in the lowest compatible build i.e save in 2003 rather in 2007.
Always have multiple options (although they may be in different locations) and
Unless you are an I.T Manager or Something you will not have administrative privileges
If you have learnt any lessons from this or your own experience feel free to share.