Re: CSV handling in KSpread, KWord
Jaroslaw Staniek <js <at> iidea.pl>
2005-12-02 19:07:02 GMT
Ariya Hidayat said the following, On 2005-12-02 17:31:
>>Similar problem:
>>-pasting CSV data from OO.org Calc into Kexi works well on any system, but
>>pasting it to KCalc only fills a single cell. Pasting it to KWord opens a
>>selection dialog allowing to paste plain text or image (no CSV has been
>>detected). This particular problem may be caused by no detecting whether the
>>plain text is in CSV format, right?
>
>
> Yes, it's likely the problem here.
> For KSpread, pasting CSV from clipboard should be performed not by
> normal paste, by inserting external data. This is suboptimal and
> less-intuitive for the users.
>
> I would say we can put the CSV-paste problem as JJ.
Good idea. I'd say: #1 interoperability problem for now. Another job could be
for KWord too.
The job is quite easy: it's enough to detect CSV format (I've recently noticed
these options are expected by spreadsheets and other apps when pasting to them:
- demiliter = tabs
- text quotes = none
On my side I am going to set these as defaults when copying data in Kexi.
Moreover, I guess am wondering whether we could reuse improved void
KexiCSVImportDialog::fillTable() method.
--
--
(Continue reading)