To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57095
User arg changed the following:
What|Old value |New value
Status|CLOSED|REOPENED
Resolution|DUPLICATE |
--- Additional comments from [EMAIL PROTECTED] Tue Nov 1 20:29:21 -0800
2005 ---
heard of that search and replace trick. Of course, there are many other
possibilities to get that text numbers with ' to real numbers again, for
example you can cut, change cell format to number and paste special as
unformatted text again...
I downloaded OOO and was using it. This is a real world scenario, wherein I was
entering my financial details and hit this WONTFIX of ooo.
This occured in 1st hour of my usage of OOO.
There would be many such cases of various people.
Please try to understand that these are genuine problems of real world people -
who are least interested in the documentation or the technical details.
Consider a huge data size. Your cut paste solution wont work in a real world
senario.
Also, I have seen people use excel with minimum size of 5 to 10 MB. OOO guys
cannot consider people to do a cut/paste or anyother workaround.
We need to take MS Office headone to succeed.
What is the bahaviour in latest staroffice?
This weekend I will check the working on the spreadsheet provided by kubuntu.
You can also try it and let us all know how does this particular case work.
I have heard that various comapnies have made MS Office an OS in itself and have
created a strong ecosystem around it. People are selling financial charts and
formulae, legal stuff all based on MS Office.
I hope that you understand what I am trying to explain.
Now you format the referenced cell as number and the text changes to that. As a
result the vlookup does not solve correctly and you get in trouble.
A simple regexp will help you solve whether to keep - or to be precise -
consider the cell contents as text or as numbers.
Forget the vlookup. Consider this simple case in excel (this simple case would
be applicable to OOO as well --
In excel 2000 enter 123 in cell A1 and abc in cell A2.
Both of them are general.
Now change the A1 to text and A2 to number and check the cell contents.
Using ' in front of numbers was an old paradigm.
Each cell's datastructure will have a member variable called format. If format =
text, using text rules, if format = number and regexpression shows that its a
number, use the cell as number - else use it as a text - or any other format
that its forced into.
-
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]
