To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=48335
User alanchristiansen changed the following:
What |Old value |New value
================================================================================
Status|CLOSED |UNCONFIRMED
--------------------------------------------------------------------------------
Resolution|INVALID |
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Thu Apr 28 07:37:21 -0700
2005 -------
I believe that this report is valid and addresses one problem.
The problem is
drops leading ' inside "" when reading csv
The included file demostrates this property. The <data>...</data> in the body
of
the text demostrates this property.
In attempting to produce definitive examples by black box testing I found
several other characteristics of the software, that I really do believe are the
same problem, where 'problem' is defined as 1 fault in the code needing remedy.
Assuming std model view controller terminology.
There will be two modules inside the code, one responsible for parsing CSV
and one for the 'model' of the spreadsheet. The interface from the control (GUI)
to the model uses one method to specify that a cell is text. It probably does
this implicitly by just passing the string and if the string starts with ' it
means it is a text cell even if the contents look numeric.
I believe you will find that the CSV reading code incorrectly uses that
interface and hence fails to correctly comunicate its intentions to the
model.
I presented several alternative potential methods to fix this,
the first made the CSV conform to the interface made for the GUI
the second and I think I indicated the preferred (in my view) method
which modifies the model interface to allow code to specify to the model
explicitly if this cells contents are text.
---------------------------------------------------------------------
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]
