acknak wrote:Calc does not separate text files at sentence boundaries. In fact, I'm surprised that Excel does it.
I just tried with some text that had periods, commas, semi-colons, and carriage returns. I used Microsoft Office Excel 2007 to open the file after renaming it test.csv.
Excel, without prompting or asking what type of separator was required, only
looked at the commas to separate text into new cells on the same row
looked at carriage returns to start a new row
Further, it did not automatically
set column widths to accommodate varying lengths of text.
I did not fiddle with any settings, so I presume the defaults were active.
Calc 3.2.0 asked me to choose the separator and automatically adjusted column width (but since I use Calc for all my work, I've fiddled with quite a few settings).
Here's the text (just a standard paste):
During the drive to the McKillops’ Reginald was possessed with a great peace,
which was not wholly to be accounted for by the fact that he had inveigled his feet
into shoes a size too small for them. I misgave more than ever, and having once launched
Reginald on to the McKillops’ lawn, I established him near a seductive dish of
marrons glacés, and as far from the Archdeacon’s wife as possible;
as I drifted away to a diplomatic distance I heard with painful distinctness
the eldest Mawkby girl asking him if he had seen San Toy.
It must have been ten minutes later, not more, and I had been having quite an enjoyable chat with
my hostess, and had promised to lend her The Eternal City and my recipe for rabbit mayonnaise, and was just
about to offer a kind home for her third Persian kitten, when I perceived, out of the corner of my eye, that Reginald was not where I had left him,
and that the marrons glacés were untasted. At the same moment I became aware that old Colonel Mendoza was essaying to tell his classic story of how he introduced golf into India, and that Reginald was in dangerous proximity. There are occasions when Reginald is caviare to the Colonel.
“When I was at Poona in ’76”—
“My dear Colonel,” purred Reginald, “fancy admitting such a thing! Such a give-away for one’s age! I wouldn’t admit being on this planet in ’76.” (Reginald in his wildest lapses into veracity never admits to being more than twenty-two.)