Ask Your Question

Is there a way to have preset fixed width when importing .txt files in Calc?

asked 2016-09-06 21:03:38 +0200

Epartsman gravatar image



I receive several reports in .txt format. I use fixed width to import the reports into Calc. Different reports have different widths. Is there a way to save the width settings as a template so that I can import a report without having to go through and reset the column breaks each time? I know that Calc must 'remember' the width settings between each time it is run because it defaults to the last width I used. Maybe there's a way for me to save a configuration file for each report type?

Thanks in advance for your time,

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-09-09 06:06:00 +0200

mark_t gravatar image

I don't think there is a built in method, but I thought it would be interesting to try and create a macro for this. It was a bit more effort than I originally expected but has been a good learning exercise. Attached document includes a copy of macros and the dialog required and some basic setup and usage instruction if you'd like to give it a try.

Let me know if you have any problems getting this running.

I'd be interested to try and develop this further if you have any suggestions that would make it more usefull.


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-09-06 21:03:38 +0200

Seen: 360 times

Last updated: Sep 09 '16