[sc-issues] [Issue 12666] autofilter works just on o ne sheet (only one auto-range per document)

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=12666 --- Additional comments from philhi...@openoffice.org Thu Nov 18 13:38:14 + 2010 --- Also, copying a sheet that has an AutoFilter creates a sheet that has the dr

[sc-issues] [Issue 115506] Named range breaks when d eleting a row

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115506 --- Additional comments from philhi...@openoffice.org Wed Nov 10 13:25:04 + 2010 --- Behaviour observed on Go-oo OpenOffice.org 3.2.1 OOO320m19 (Build:9505) oo

[sc-issues] [Issue 115506] Named range breaks when d eleting a row

Assigned to|spreadsheet Reported by|philhibbs --- Additional comments from philhi...@openoffice.org Wed Nov 10 13:17:03 + 2010 --- 1. Select an entire column 2. Define it as a Named Range - by default it misses out the last row, so change the definition to include row

[sc-issues] [Issue 13427] Column highlighting has ru naway scrolling

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=13427 --- Additional comments from philhi...@openoffice.org Tue Oct 26 11:39:02 + 2010 --- In answer to fst, no scrolling would be superior to half an hour of unstoppa

[sc-issues] [Issue 93973] Improve adjustment of smal l column width using mouse

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93973 --- Additional comments from philhi...@openoffice.org Thu Sep 30 15:09:58 + 2010 --- It appears that the smallest width that you can set a column to with the mou

[sc-issues] [Issue 114769] Movement after selection

Assigned to|spreadsheet Reported by|philhibbs --- Additional comments from philhi...@openoffice.org Mon Sep 27 08:55:34 + 2010 --- In 3.0, if I selected a block of cells with the cursor, Copied them, and then moved down, movement would be relative to the cell that was

[sc-issues] [Issue 109721] Calculations no longer tr eat non-numeric text as zero

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109721 --- Additional comments from philhi...@openoffice.org Mon Jun 14 16:39:15 + 2010 --- SUM(A1;A2) also fails, not just SUM(A1;-A2). It gives Err:508. It doesn't s

[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 --- 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 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 philhi...@openoffice.org Thu Jul 9 14:36:12 + 2009 --- Issue 103318 created to propose handling of alternative semantics in differen

[sc-issues] [Issue 101471] Import formulas in msoxl: namespace from ODS

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

[sc-issues] [Issue 103318] Support for alternative n amespace semantics

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103318 --- Additional comments from philhi...@openoffice.org Fri Jul 3 15:10:46 + 2009 --- See also Issue 101471 and Issue 5658 -

[sc-issues] [Issue 103318] Support for alternative n amespace semantics

Assigned to|spreadsheet Reported by|philhibbs --- Additional comments from philhi...@openoffice.org Fri Jul 3 15:09:43 + 2009 --- ODF spreadsheet formulae have, according to the standard, "a namespace prefix specifying the syntax and semantics used within the fo

[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 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 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 101471] Import formulas in msoxl: namespace from ODS

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101471 --- Additional comments from philhi...@openoffice.org Tue Jun 2 15:10:49 + 2009 --- Another thing to bear in mind is that my proposal of handling the msoxl nam

[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 101471] Import formulas in msoxl: namespace from ODS

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101471 --- Additional comments from philhi...@openoffice.org Tue Jun 2 12:09:57 + 2009 --- Minor correction to myself - it's not that it's a direct reference, since =

[sc-issues] [Issue 101471] Import formulas in msoxl: namespace from ODS

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101471 --- Additional comments from philhi...@openoffice.org Tue Jun 2 10:58:05 + 2009 --- The reason that the formulae are in a different namespace is that Excel use

[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 24374] Cell formatted as TEXT con verted to NUMBER format fails

To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=24374 --- Additional comments from philhi...@openoffice.org Thu May 21 12:43:51 + 2009 --- You have to use REGULAR EXPRESSIONS to fix this? WTF? I know what regular 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 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 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 [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] 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 --- Additional comments from [EMAIL PROTECTED] Sun Oct 5 11:28:13 + 2008 --- And that - the resistance that some have to accepting this as an "Excel compatibilit

[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 Jun 23 19:22:04 + 2008 --- Not sure if this is of any use to anyone: =IF(ISERR(VALUE(A1));"text";IF(VALUE(A1)=

[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 Mar 28 12:54:38 + 2008 --- @jrtapper: It has been an active issue for this long because it is a difficult issu

[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 Mar 5 16:02:43 + 2008 --- @er: Good point. I hope that everyone is following this debate, it cuts to the very

[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 Feb 21 16:31:45 + 2008 --- @er: At some point, OOo has to decide whether a series of characters is a number or

[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 Feb 21 09:13:00 + 2008 --- @er: Thank you for your thoughtful reply. The issues you raise are just the sort 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] Wed Feb 20 22:37:59 + 2008 --- @daxkelson: I don't understand why you are going so far in your request that it be 1

[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 Feb 20 18:21:42 + 2008 --- Two questions to the crowd: 1. Does anyone watching this issue think that it should

[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 Feb 20 18:12:58 + 2008 --- @daxkelson: Can we call a truce on this? I think we're mostly on the same side here,

[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 Feb 20 18:04:37 + 2008 --- Questions to those who oppose changing this behaviour (I would say "fixing this 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] Wed Feb 20 17:44:01 + 2008 --- @kohei: >On top of that, I had a separate patch just to handle =SUM(A1:A10) the way

[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 Feb 20 17:41:22 + 2008 --- @daxkelson: Malicious? You just lost your credibility. Expecting bug-for-bug compata

[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 Feb 20 16:24:33 + 2008 --- Although, it depends on your context of course - if you are working for a client who

[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 Feb 20 16:20:55 + 2008 --- @kohei: Absolutely. You can't introduce a bug into a spreadsheet application just be

[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 Feb 20 16:03:52 + 2008 --- >For case 2) where a built-in function takes a cell range as an argument and >that

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 2 07:15:57 -0800 2005 --- >I'll never get it why people think that treating this the Excel >way, 0 in SUM(B2:

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 2 05:47:49 -0800 2005 --- Real-world spreadsheets are the result of many changes by different users with diffe

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 2 02:30:04 -0800 2005 --- OK this is very confusing. I closed the document, re-opened it, and the ' is no long

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 2 02:27:35 -0800 2005 --- OK I see it now. Sorry. The formula bar has '1 in it. This is how I got here: 1. E

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 2 02:22:31 -0800 2005 --- I have created two new attachments, texttest1.ods and texttest2.ods - can someone te

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 philhibbs changed the following: What|Old value |New value

[sc-issues] [Issue 5658] Spreadsheet thinks a numbe r 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 philhibbs changed the following: What|Old value |New value