To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80385
User er changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Aug 8 15:56:01 +0000
2007 -------
> Let us be clear on one thing. I am discussing the existing behaviour of Calc.
> What I want is not an enhancement or new way to handle CSV files, I merely
> want
> the handling to be consistent, and to reflect what I have in the file
> reasonably
> accurately.
Isn't that somewhat contradicting? You have broken data in your file and
want it reflected reasonably accurately? Yes, we can add some more magic
to try to guess broken data correctly. Yes, we will do eventually, this
is what issue 78926 is about, so this issue here in fact is a duplicate.
> > Else, how should this be handled:
> > ,"abc" d "ef",
> > IS the FIELD actually:
> > 1. 'abc" d "ef' AND the application forgot to double the QUOTES
> > (valid assumption)
This is how it should be treated, IMHO. Doing so would also lead to
,"a"b, "a",
resulting in _one_ field
'a"b, "a'
and not two, 'ab' and ' "a"' like it is currently the case. I could bet
sooner or later someone will show up and complain that we don't do it
like Excel ...
> > 2. 'abc d ef' - my view - CONSISTENT HANDLING
Consistent, but also loses information.
> > 3. 'abc d "ef"' - your view - the least consistent of these 4 methods
>
> This is not my view, it is actually what happens in Calc and Excel. If you
> don't
> believe me, please try it yourself.
Yes, that's how this case of broken data that doesn't follow the escaped
quotes rule currently may be treated.
*** This issue has been marked as a duplicate of 78926 ***
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
