Dilwyn Jones wrote, On 22/02/10 19:08:
Thankyou Geoff - that is great - could you add a link to your website
please as a reminder.
It is a shame not to see you adding your valued input to this list
--
Rich Mellor
RWAP Services
Oops, forgot that link in my first email. It is:
http://members.multimania.co.uk/geoffwicks/advice.htm
Choose option 1 from the menu for the Spreadsheet transfer.
You are then invited to download a zipped plain text file of an
article by Geoff.
I have read Geoff's document and it makes no mention of QL Abacus ( and
Xchange) issues with exporting.
I need to export by column, as then Excel (importing by row and no way
of changing that) will preserve the spreadsheet layout.
However the QL 'archive/abacus' export only outputs data if the first
column cell is non blank.
This looks like a bug to me. Is it cured in any versions of Xchange -
mine is 3.90J?
All is OK if I put a blank row and fill it with any data.
If I then import from row 2 in Excel, then all looks fine.
Is there a way around this?
I have hundreds of files to export so this is a real pain.
Incidentally there is no need at all to modify the files to give an
extension. Simply leave the _exp there, and load files in Excel as type
*.* .
Tony
--
QBBS (QL fido BBS 2:257/67) +44(0)1442-828255
t...@firshman.co.uk http://firshman.co.uk
Voice: +44(0)1442-828254 Fax: +44(0)1442-828255 Skype: tonyfirshman
TF Services, 29 Longfield Road, TRING, Herts, HP23 4DG
_______________________________________________
QL-Users Mailing List
http://www.q-v-d.demon.co.uk/smsqe.htm