This is dependent on how you output to file. If you use Excel's
built-in methods then expect these kinds of issues. Using VBA standard
file I/O methods is a much more efficient way to write worksheet data
to a file, or file data to a worksheet.

While Libre Calc doesn't have some of Excel's irritating nuances, it
does have a few of its own. It's still, though, the best 'free'
spreadsheet program available. (WPS might qualify as a good runnerup
for 2nd place)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion