You are here

Calc Portable .txt update

7 posts / 0 new
Last post
kam2kam
Offline
Last seen: 16 years 4 months ago
Joined: 2007-11-17 08:27
Calc Portable .txt update

I work for a GIANT blue chip company and use excel very heavily but since the discovery of portable apps I have fallen in love with all apps but in particular with Calc, however, while I and many friends would love to stop using all other vendors programs in favour of calc app, we find that there is one small functionally missing to make it complete, and that is to have the option to SAVE AS .txt and then check mark options to choose selected range only.

For this particular task we currently use Lotus 123. We have to have it saved this way because SAP system only likes .txt uploads.

I know csv is similar to txt but when we change the extentions its not exectly same. Also there is no option to choose selected range only.

Please include the above you will make thousands of people very happy.
Many Thanks.

Simeon
Simeon's picture
Offline
Last seen: 9 years 5 months ago
DeveloperTranslator
Joined: 2006-09-25 15:15
we only pack the apps

without changing them so you'd have to aks the original developper about that.

"What about Love?" - "Overrated. Biochemically no different than eating large quantities of chocolate." - Al Pacino in The Devils Advocate

alanbcohen
Offline
Last seen: 4 years 7 months ago
Joined: 2006-01-04 10:47
Get the compny to switch to

Get the company to switch to PeopleSoft! (just kidding - a little ERP rivalry thing.)

Seriously, a work around to try:
Do a copy and paste special (Presumably numbers) from the spreadsheet into a new .txt file in a text editor. Then save the text file and use that for the SAP upload. You may need to play with the idea, but give it a try.

kam2kam
Offline
Last seen: 16 years 4 months ago
Joined: 2007-11-17 08:27
Calc Prtable .txt update

Alan,

Thanks for the tip, but unfortuneatly its not just the numbers that we have to be carefull about in txt file its also the column width etc which has to be exectly the same to the last pixel of SAP just refuses to accept the file, so for this reason copy/paste job does not work as we have all tried many different options just so that we can stop using 123 and Excel.

Any other ideas? Smile

Samul, I am unable to find the developer any ideas on the email so I can try my luck there.

Thanks to all, please can we all suggest this to the developer, thanks

Kam

ZachHudock
ZachHudock's picture
Offline
Last seen: 1 year 2 months ago
Developer
Joined: 2006-12-06 18:07
I'm assuming the app you are

I'm assuming the app you are referring to is OpenOffice.org Calc.

If so, try here http://www.openoffice.org/contact.html

The developer formerly known as ZGitRDun8705

grannyGeek
Offline
Last seen: 15 years 8 months ago
Joined: 2007-03-14 23:42
A shot in the dark --

Maybe try using TAB as the field delimiter instead of Comma when you save the csv text file out of Calc.

I haven't worked much with Calc yet, but so far there is no way to save only a selected range to csv. As a very kludgy work-around, you could copy the selected range to a new sheet, and then save that new sheet to Tab-delimited csv.

Of course, I don't know if Tab-delimiting would accomplish what you need either.

But maybe it's worth a shot, what the heck.

sag47
Offline
Last seen: 10 years 1 month ago
Joined: 2007-11-17 16:19
Can you please post a small

Can you please post a small sample of the CSV file and then tell me how you would like it to be formatted in .txt. I've worked alot with parsing CSV files so I can write a small program for you that will convert it to the format you need.

Then you won't need to worry about it at all. I provide source with all programming.

SAM

What's a signature?

Log in or register to post comments