[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-15 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Tue Jun 15 08:32:08 + 2010 --- I want to thank the OOo team for fixing this very long-standing nuisance.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Mon Jun 14 09:13:59 + 2010 --- @jtienhaara: can you attach an example that this change breaks?

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Mon Jun 14 14:01:15 + 2010 --- Created an attachment (id=69985) Example: notes in fields, +/- treated text

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Mon Jun 14 14:02:21 + 2010 --- Created an attachment (id=69986) Screenshot: OOo 3.0 /

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Mon Jun 14 14:03:03 + 2010 --- Created an attachment (id=69987) Screenshot: OOo 3.2 (Windoze) /

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Mon Jun 14 14:08:34 + 2010 --- @philhibbs: Thanks for taking the time to look at this further. I've

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Mon Jun 14 14:48:01 + 2010 --- jtienhaara: This is a bigger issue than someone deciding his medical

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Mon Jun 14 15:09:51 + 2010 --- It is nice to see that others are putting their minds to this issue. Excel

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Mon Jun 14 15:24:26 + 2010 --- All this talk of Excel irritates me to no end. A minor revision of

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread kohei
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User kohei changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Mon Jun 14 15:50:33 + 2010 --- @jtienhaara: The opener of Issue 109721 was told to refer to Issue 109165,

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-14 Thread mloiseleur
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User mloiseleur changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-13 Thread jtienhaara
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from jtienha...@openoffice.org Sun Jun 13 14:28:02 + 2010 --- I have never used Excel, but my OpenOffice 3.0 spreadsheets now show

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-13 Thread efa
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from e...@openoffice.org Sun Jun 13 15:32:37 + 2010 --- finally OOo work well with numbers inside a string. Good job.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2010-06-13 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from corno...@openoffice.org Sun Jun 13 20:28:55 + 2010 --- @jtienhaara: you can better use version 3.2.0 or 3.2.1 That should work in

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-12-02 Thread nn
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from n...@openoffice.org Wed Dec 2 10:31:13 + 2009 --- *** Issue 107375 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-11-16 Thread fst
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from f...@openoffice.org Mon Nov 16 15:56:40 + 2009 --- *** Issue 106944 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-28 Thread fst
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from f...@openoffice.org Mon Sep 28 14:47:59 + 2009 --- *** Issue 105427 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-10 Thread oc
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User oc changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-05 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-04 Thread tomvigl
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from tomv...@openoffice.org Fri Sep 4 15:35:00 + 2009 --- Are leading and trailing spaces stripped? 17 + 4 = 21 Can cells with spaces

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-04 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Fri Sep 4 20:46:42 + 2009 --- Also, Excel will interpret all kinds of numeric data, such as 100.000,00 or

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-03 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-03 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from e...@openoffice.org Thu Sep 3 21:03:01 + 2009 --- Missed the formula cell case, revision 275776 sc/source/core/tool/interpr4.cxx

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-03 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from e...@openoffice.org Thu Sep 3 21:06:07 + 2009 --- Created an attachment (id=64535) testcase now with formula cell results as well

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-02 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-09-02 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from e...@openoffice.org Wed Sep 2 14:40:46 + 2009 --- Created an attachment (id=64497) testcase for the fix

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-08-29 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-08-29 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User er changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-08-01 Thread regina
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from reg...@openoffice.org Sat Aug 1 16:21:34 + 2009 --- *** Issue 85242 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-07-09 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Thu Jul 9 14:36:12 + 2009 --- Issue 103318 created to propose handling of alternative semantics in

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-04 Thread tomvigl
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from tomv...@openoffice.org Thu Jun 4 12:24:28 + 2009 --- If you want a change: VOTE FOR THIS ISSUE

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-04 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Thu Jun 4 13:15:03 + 2009 --- @cornouws: ... did the frustrated part of the community give on the CT2N

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 07:12:46 + 2009 --- Andrew, apparently, you never worked in a large company. Unless a CxO is a

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Wed Jun 3 09:09:25 + 2009 --- Well, I happen to think that training is an important activity in any

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread karlis
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kar...@openoffice.org Wed Jun 3 10:32:34 + 2009 --- I have never come across the problem defined here. I do have. One of our

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 11:27:21 + 2009 --- Karlis, I think in this bug report we have seven years worth of evidence that

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Wed Jun 3 11:45:55 + 2009 --- I'm interested to hear any objections to working around this issue by

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 12:09:44 + 2009 --- I think I may actually have stumbled upon WHY this problem occurs in so many

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from corno...@openoffice.org Wed Jun 3 13:31:58 + 2009 --- Since this issue is messed up by disfunctional comments anyway, I might ad

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Wed Jun 3 13:40:32 + 2009 --- I think I now understand the problem better. If, in the real world, you are

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread clemare
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from clem...@openoffice.org Wed Jun 3 16:19:17 + 2009 --- I totally agree with karlis. Whoever said that OOO is superior because bla bla

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 19:47:32 + 2009 --- Andrew, If, in the real world, you are trying to use OpenOffice as an

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 19:50:34 + 2009 --- One more thought. It is *entirely* possible that Microsoft has done this

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread er
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from e...@openoffice.org Wed Jun 3 20:04:27 + 2009 --- Friends of the Italian Opera, would you PLEASE STOP discussing off-topic in this

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 20:08:42 + 2009 --- ER - given that this issue has its SEVENTH anniversary coming up on Monday

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from corno...@openoffice.org Wed Jun 3 20:16:29 + 2009 --- @ kkeane: then how much tips, carrots, sticks, suggestions, ... did the

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Wed Jun 3 21:00:19 + 2009 --- Good point. To be honest, I hadn't even heard about CT2N until you mentioned it

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from corno...@openoffice.org Wed Jun 3 21:10:33 + 2009 --- @ kkeane: Thanks for your reply. I think first time it was mentioned here was

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-03 Thread thing
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User thing changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-02 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Tue Jun 2 15:00:26 + 2009 --- @fdservices: how do users input numbers into a spreadsheet, format them as

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-02 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Tue Jun 2 15:52:29 + 2009 --- Best give your users some training then :-) Andrew

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-06-02 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Tue Jun 2 16:12:20 + 2009 --- On a recent engagement with a local authority in the UK to move from

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-24 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Sun May 24 14:02:35 + 2009 --- Hi alcohenma, I have never, and would never, enforce a I think this is

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread mux2005
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from mux2...@openoffice.org Fri May 22 10:05:03 + 2009 --- How about implementing the following things: 1. If the user enters a formula

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Fri May 22 11:40:40 + 2009 --- Interesting idea, but it won't fix =SUM(A1:A10)

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Fri May 22 11:42:58 + 2009 --- actually... I'm not sure if Excel will SUM() text values, Google Docs

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Fri May 22 13:31:15 + 2009 --- The above won't work for you, since you can enter a fomula before entering

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Fri May 22 16:41:15 + 2009 --- The marketplace is littered with better products that failed because they

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Fri May 22 20:15:12 + 2009 --- Wow, that is some tirade! Lotus was developed before Excel, and was the

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread alcohenma
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from alcohe...@openoffice.org Fri May 22 20:26:21 + 2009 --- As the originator of this bug, I've been watching this argument for a few

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-22 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from kke...@openoffice.org Fri May 22 21:18:33 + 2009 --- Andrew, here is an easy experiment that may settle this once and for all. It's

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-21 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Thu May 21 09:47:03 + 2009 --- There's a post on an MSDN blog explaining how this issue is responsible for

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-05-21 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Thu May 21 12:34:59 + 2009 --- Thinking a little more about that MSDN blog entry, there could be a way out.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-04-23 Thread fst
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from f...@openoffice.org Thu Apr 23 13:06:16 + 2009 --- *** Issue 101306 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-27 Thread khirano
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User khirano changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-07 Thread jbfaure
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User jbfaure changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-03 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Tue Mar 3 13:04:16 + 2009 --- ondrej_suchy says: Arithmetic operations of number and text should yeild

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-03 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from philhi...@openoffice.org Tue Mar 3 13:25:49 + 2009 --- Any cell that contains a formula such as =MID(A1;2;999) to trim off the

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-03 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from fdservi...@openoffice.org Tue Mar 3 16:21:34 + 2009 --- philhibbs says: Any cell that contains a formula such as =MID(A1;2;999) to

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2009-03-02 Thread ondrej_suchy
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from ondrej_su...@openoffice.org Tue Mar 3 06:57:47 + 2009 --- I just run into this issue in a spreadsheet which was giving bad results.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-12-30 Thread dridgway
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from dridg...@openoffice.org Tue Dec 30 15:58:12 + 2008 --- *** Issue 93204 has been marked as a duplicate of this issue. ***

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-25 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Tue Nov 25 09:14:32 + 2008 --- @discoleo: saying excel computes WRONG result is like saying I am RIGHT about this

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-25 Thread thb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User thb changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-25 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Tue Nov 25 13:57:50 + 2008 --- I think that it is just another example of Excel muddle headed formula evaluation.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-25 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Tue Nov 25 14:15:13 + 2008 --- @fdservices: Excel is inconsistent in its treatment of text and numbers. I would

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-25 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Tue Nov 25 14:35:42 + 2008 --- If OO doesn't do the same thing, it is a bug in OO's Excel import filter - can't

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-24 Thread mux2005
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 11:02:23 + 2008 --- My opinion on the question whether Excel's bugs/misfeatures should be emulated by

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-24 Thread clemare
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 19:49:38 + 2008 --- Thanks cornouws, this extension is very helpful. We need more votes to get a

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-24 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 20:46:21 + 2008 --- For all needing 100% Excel compatability: make sure you have all the same version

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-24 Thread discoleo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 21:58:16 + 2008 --- discoleo-cornouws For all needing 100% Excel compatability: make sure you have all

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-24 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 22:48:39 + 2008 --- I think mux2005, discoleo et al. are really missing the basic point here. Excel is

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-23 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sun Nov 23 09:30:41 + 2008 --- 1) Excel runs very well under Wine on Linux. 2) Windows rules the desktop simply

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 13:28:34 + 2008 --- No, that extension isn't sufficient. When one of my business partners sends me an

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 14:33:35 + 2008 --- Created an attachment (id=58219) Example of Excel calculation bug

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 14:35:23 + 2008 --- I tend to agree, this is really an excel bug and the question has to be Do we

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 14:42:29 + 2008 --- @ kkeane, Sat Nov 22 2008: OK, you want a program that does exactly the same as

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sat Nov 22 18:07:45 + 2008 --- Yes, that would be my conclusion. In summary: If you need Excel, use Excel As

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-22 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Sun Nov 23 04:11:41 + 2008 --- @ cornouws: OK, you want a program that does exactly the same as Excel, without

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-21 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 08:24:56 + 2008 --- I am afraid it is not quite as simple as that. One of the most common problems with

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-21 Thread clemare
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 13:36:15 + 2008 --- Consider a company doing $1 + '1,000,000' = $1 and going bankrupt afterwards.

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-21 Thread cornouws
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Fri Nov 21 13:51:44 + 2008 --- My company is considering seriously to buy MS Office licences because of this

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-20 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 13:15:24 + 2008 --- Clemare: You were probably using the Novell build of OO2.4 which did throw an

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-20 Thread kkeane
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 13:25:08 + 2008 --- It seems to me that there is a consensus developing here that it is more important

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-20 Thread fdservices
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 16:41:20 + 2008 --- Actually I would agree with that. Why not just create a superb spreadsheet?

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-20 Thread discoleo
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Thu Nov 20 18:27:20 + 2008 --- It seems to me that there is a consensus developing here that it is more

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-19 Thread philhibbs
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Wed Nov 19 10:02:52 + 2008 --- clemare: In early versions (OOCalc 2.4) the formula throws an error, This issue

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-19 Thread rail
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 User rail changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a number is a string (text)

2008-11-18 Thread clemare
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658 --- Additional comments from [EMAIL PROTECTED] Wed Nov 19 01:56:24 + 2008 --- First of all: I do not use Excel. Second: This is clearly a bug, this is why... If

  1   2   >