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

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. @jiten

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

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)

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)

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, no

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

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)

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 OpenOffi

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

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)

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 spreads

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

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 attach

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

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) / notes_in_nu

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

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 / notes_in_number_field

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

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)

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)

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 you

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

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)

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 "#VALUE

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

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)

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)

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)

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)

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)

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 $75.

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

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 spa

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

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)

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)

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)

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)

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)

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)

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)

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)

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 differen

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

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 ext

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

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)

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)

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)

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)

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 frustr

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

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 witho

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

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 i

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

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 intenti

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

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 Exce

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

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)

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)

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 som

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

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 Exc

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

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 impleme

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

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 th

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

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 supp

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

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 compan

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

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 major

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

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 Microsof

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

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)

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 te

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

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 bet

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

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 c

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

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 day

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

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 spr

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

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 didn

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

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 t

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

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 doesn't

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

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)

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 t

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

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)

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 M

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

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)

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)

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)

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)

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 leadi

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

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 e

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

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)

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)

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 d

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

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 cla

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

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)

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)

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 thi

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

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 i

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

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 al

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

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 of

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

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 change

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

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 OO

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

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 bec

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

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 doi

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

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 for

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

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 Exce

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

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 reprod

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

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)

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 Ex

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

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 error

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

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. Tha

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

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)

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 importa

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

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? Inciden

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

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 t

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

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 error

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

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)

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 h

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

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

  1   2   >