[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value

2010-09-08 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114418 --- Additional comments from to...@openoffice.org Thu Sep 9 01:55:38 + 2010 --- urlordofelves: The formula in D1, INDEX(ADDRESS(COLUMN();ROW())), is

[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result

2010-07-12 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113105 --- Additional comments from to...@openoffice.org Tue Jul 13 01:53:08 + 2010 --- I get the same results in Gnumeric that OpenOffice does. On Vista (Gnumeric

[sc-issues] [Issue 110570] Rounding/addition error

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

[sc-issues] [Issue 110173] Data - Sort option not av ailable

2010-03-17 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110173 --- Additional comments from to...@openoffice.org Thu Mar 18 00:41:14 + 2010 --- rcoe: When I open the file in Excel 03, it show the file is in shared mode.

[sc-issues] [Issue 110173] Data - Sort option not av ailable

2010-03-17 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110173 --- Additional comments from to...@openoffice.org Thu Mar 18 01:00:27 + 2010 --- rcoe: I finally broke the share mode of your file in Excel 03 by saving it as

[sc-issues] [Issue 110173] Data - Sort option not av ailable

2010-03-16 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110173 --- Additional comments from to...@openoffice.org Wed Mar 17 01:17:50 + 2010 --- rcoe: If your xls file is read-only then Sort is not available. When you

[sc-issues] [Issue 109799] 2 days difference in date s

2010-03-05 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109799 --- Additional comments from to...@openoffice.org Fri Mar 5 23:03:27 + 2010 --- Using OOO300m19 (Build:9420)(3.1.1) US-en on Vista Home Premium. I am seeing

[sc-issues] [Issue 109691] possible bug in MEDIAN() function of OOo Calc

2010-02-28 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109691 --- Additional comments from to...@openoffice.org Mon Mar 1 02:07:55 + 2010 --- krewetki: Calc is giving the correct result. Excel 03 is the same. The

[sc-issues] [Issue 108030] calc Sum function varies in amount.

2010-01-02 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=108030 --- Additional comments from to...@openoffice.org Sat Jan 2 17:37:05 + 2010 --- servant2him: Calc is summing correctly. If you expand your currency entries,

[sc-issues] [Issue 107201] loading large html file i n scalc hangs

2009-12-01 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107201 --- Additional comments from to...@openoffice.org Wed Dec 2 01:26:57 + 2009 --- b_ambrosius: I could not get the file to open in Calc. OOO310m19(build:9420)

[sc-issues] [Issue 107185] Net chart does not displa y all data ranges

2009-11-24 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107185 --- Additional comments from to...@openoffice.org Tue Nov 24 20:53:01 + 2009 --- mtxd: If you select chart type, un-check Stack Series, then it will show all

[sc-issues] [Issue 106358] Round-Off Error According to Cell Formatting

2009-10-27 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106358 --- Additional comments from to...@openoffice.org Wed Oct 28 00:15:03 + 2009 --- mathuhenry: Go to Tools | Options | OpenOffice.org Calc | Calculate |

[sc-issues] [Issue 105648] OpenOffice.org 3.1 and 3. 11, Calc, Err 525

2009-10-06 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105648 --- Additional comments from to...@openoffice.org Tue Oct 6 14:05:12 + 2009 --- I can confirm the issue in OOO311m19, but I get err 523. It opens ok in

[sc-issues] [Issue 105588] Formulas inside an area a re not reassigned when you sort that area by a column

2009-10-04 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105588 --- Additional comments from to...@openoffice.org Sun Oct 4 13:33:29 + 2009 --- Sorts ok using using OOO311 en_US on Vista SP2. Attaching bugdoc showing

[sc-issues] [Issue 105588] Formulas inside an area a re not reassigned when you sort that area by a column

2009-10-04 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105588 --- Additional comments from to...@openoffice.org Sun Oct 4 13:34:29 + 2009 --- Created an attachment (id=65122) bugdoc showing correct sort

[sc-issues] [Issue 104069] Over 71 minutes to open a spreadsheet

2009-08-06 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104069 --- Additional comments from to...@openoffice.org Fri Aug 7 00:05:36 + 2009 --- Some observations: 1) When opened in OO03.1, it opens as a writer/web

[sc-issues] [Issue 25368] mis-calculation in autofil l for numbers with one or two decimal places

2009-07-27 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=25368 --- Additional comments from to...@openoffice.org Tue Jul 28 00:58:51 + 2009 --- Kohei: Thank you for clarifying it as dupe. I did no know if my example was

[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.

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

[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.

2009-07-24 Thread tomwb
|editing Assigned to|spreadsheet Reported by|tomwb --- Additional comments from to...@openoffice.org Fri Jul 24 19:44:17 + 2009 --- I will attach a bugdoc to illustrate the following problem. This only applies to using autofill by the drag handle. Menu

[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.

2009-07-24 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103784 --- Additional comments from to...@openoffice.org Fri Jul 24 19:45:38 + 2009 --- Created an attachment (id=63727) Bugdoc showing autofill issue

[sc-issues] [Issue 103638] Loading a rather simple . ods file takes 10 minutes

2009-07-19 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103638 --- Additional comments from to...@openoffice.org Mon Jul 20 01:05:44 + 2009 --- h_koekoek: You have 41 links to some external .GIF files. When I broke the

[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format

2009-07-04 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 --- Additional comments from to...@openoffice.org Sat Jul 4 22:09:44 + 2009 --- I just created a Excel workbook that shows the same handling of the date,

[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format

2009-07-04 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 --- Additional comments from to...@openoffice.org Sat Jul 4 22:10:52 + 2009 --- Created an attachment (id=63364) Excel 2003 sheet with Date Example

[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format

2009-07-03 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103295 --- Additional comments from to...@openoffice.org Fri Jul 3 19:36:53 + 2009 --- I can confirm the effect, but it may not be a defect. It is caused on my

[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black

2009-06-24 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102726 --- Additional comments from to...@openoffice.org Wed Jun 24 22:48:50 + 2009 --- wmpub: Accessibility settings can cause this type of behavior. Do you have

[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t

2009-06-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103007 --- Additional comments from to...@openoffice.org Tue Jun 23 01:44:12 + 2009 --- Created an attachment (id=63152) OP's example data

[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t

2009-06-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103007 --- Additional comments from to...@openoffice.org Tue Jun 23 01:47:22 + 2009 --- Created an attachment (id=63153) Text document with pasted chart (Star Object

[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t

2009-06-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103007 --- Additional comments from to...@openoffice.org Tue Jun 23 01:48:57 + 2009 --- Created an attachment (id=63154) Example showing altered pasted chart after

[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t

2009-06-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103007 --- Additional comments from to...@openoffice.org Tue Jun 23 01:52:49 + 2009 --- Confirmed that pasted chart into odt document is altered after entering edit

[sc-issues] [Issue 102820] Chart elements cannot be specified post-creation

2009-06-15 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102820 --- Additional comments from to...@openoffice.org Tue Jun 16 01:36:03 + 2009 --- headbomb: After entering chart editing mode, use Insert | Title to add a

[sc-issues] [Issue 102822] Chart elements do not han dle subscripts/italics/etc.

2009-06-15 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102822 --- Additional comments from to...@openoffice.org Tue Jun 16 01:54:25 + 2009 --- headbomb: Although you can not add them directly to the title objects without

[sc-issues] [Issue 102821] Charts as their own sheet

2009-06-15 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102821 --- Additional comments from to...@openoffice.org Tue Jun 16 02:14:27 + 2009 --- headbomb: One can put a chart in a separate sheet. Just copy the created

[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black

2009-06-13 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102726 --- Additional comments from to...@openoffice.org Sat Jun 13 14:37:26 + 2009 --- You can think of Value Highlighting as a troubleshooting mode for locating

[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black

2009-06-12 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102726 --- Additional comments from to...@openoffice.org Fri Jun 12 20:57:44 + 2009 --- wmpub When Value Highlighting is enabled you get this behavior. Ctrl F8,

[sc-issues] [Issue 101782] Can't open calc spreadshe et - OOo hangs

2009-05-18 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from to...@openoffice.org Mon May 18 10:15:44 + 2009 --- If I open the first example in OO 2.4.1, all four sheets are there. It does

[sc-issues] [Issue 101782] Can't open calc spreadshe et - OOo hangs

2009-05-18 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101782 --- Additional comments from to...@openoffice.org Mon May 18 10:44:30 + 2009 --- As a further test, using OO 2.4.1, I saved the first example as an excel

[sc-issues] [Issue 101791] Sorting can modify formul a

2009-05-11 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101791 --- Additional comments from to...@openoffice.org Tue May 12 01:05:57 + 2009 --- I can confirm the defect in the sort. OOO310m11 on Vista OOO2.4.1 on Vista

[sc-issues] [Issue 101791] Sorting can modify formul a

2009-05-11 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101791 --- Additional comments from to...@openoffice.org Tue May 12 01:17:17 + 2009 --- Actually I believe this is a dupe of Issue 101690, or at least related to it.

[sc-issues] [Issue 101712] Countif can't count text wildcards

2009-05-09 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101712 --- Additional comments from to...@openoffice.org Sat May 9 21:13:31 + 2009 --- This link shows how wildcards work with countif. Calc can use Regular

[sc-issues] [Issue 87934] red color for negative fig ures

2009-05-06 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87934 --- Additional comments from to...@openoffice.org Wed May 6 23:06:09 + 2009 --- Sounds like 'Value Highlighting' is enabled. In the 'View' menu check to see

[sc-issues] [Issue 100523] (request) quick sum of ce lls

2009-03-24 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100523 --- Additional comments from to...@openoffice.org Wed Mar 25 02:14:38 + 2009 --- kaitlyn: Feature already exists in the status bar at the bottom of the calc

[sc-issues] [Issue 100455] Performing math on a cell that contains a formula fails.

2009-03-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=100455 --- Additional comments from to...@openoffice.org Sun Mar 22 13:54:44 + 2009 --- jmodzel: Your formulas in the first row return the correct value, because

[sc-issues] [Issue 99478] Selecting rows/columns imp ossible after using function wizard

2009-02-21 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=99478 --- Additional comments from to...@openoffice.org Sat Feb 21 17:43:27 + 2009 --- This error occurs back in Dev300m40 build 9381. If you save the document, row

[sc-issues] [Issue 98505] Columns considered second class

2009-01-27 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98505 --- Additional comments from to...@openoffice.org Tue Jan 27 11:01:31 + 2009 --- anwyl42: You need to use array functions to accomplish your examples.

[sc-issues] [Issue 98505] Columns considered second class

2009-01-27 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98505 --- Additional comments from to...@openoffice.org Tue Jan 27 11:02:53 + 2009 --- Created an attachment (id=59696) Example showing array functions

[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc

2009-01-19 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 11:07:05 + 2009 --- Created an attachment (id=59474) Screen Shot of Calc Import Dialog

[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc

2009-01-19 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 11:14:17 + 2009 --- fijam: I have attached a screen shot of the import dialog showing that the

[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc

2009-01-18 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Sun Jan 18 15:02:37 + 2009 --- fijam: The file you provided does not contain any dates. It imports properly

[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc

2009-01-18 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=33723 --- Additional comments from to...@openoffice.org Mon Jan 19 02:37:30 + 2009 --- fijam: After I found a locale in my language settings that would replicate the

[sc-issues] [Issue 97915] Loads xls file incorrectly with wrong formatting

2009-01-10 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97915 --- Additional comments from to...@openoffice.org Sat Jan 10 14:49:34 + 2009 --- Opens correctly with OOOm300m9 on Vista and Progex Linux. It does not open

[sc-issues] [Issue 97778] Add ability to paste newli nes.

2009-01-05 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97778 --- Additional comments from to...@openoffice.org Tue Jan 6 01:28:16 + 2009 --- Additional comment: I found that I did not have to enter any character into a

[sc-issues] [Issue 97778] Add ability to paste newli nes.

2009-01-05 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97778 --- Additional comments from to...@openoffice.org Tue Jan 6 02:15:34 + 2009 --- Gary: I opened some Excel documents from work in Calc and I could paste

[sc-issues] [Issue 97748] R1C1 Formula Syntax Defect ective

2009-01-04 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97748 --- Additional comments from to...@openoffice.org Mon Jan 5 00:24:49 + 2009 --- regina: The Ubuntu version Of OO 3.0.0 has the option in question. version:

[sc-issues] [Issue 97701] Workaround for 65K line li mit for csv

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

[sc-issues] [Issue 97396] OO3/Linux crashes on impor ting this doc

2008-12-18 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97396 --- Additional comments from to...@openoffice.org Fri Dec 19 00:53:34 + 2008 --- Opens with images with a Ubuntu 8.10 with GNOME 2.24.1 desktop version of

[sc-issues] [Issue 96989] crashing when opening exce l document

2008-12-07 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96989 --- Additional comments from [EMAIL PROTECTED] Sun Dec 7 17:17:21 + 2008 --- Opens ok in OOO300m9 (Build:9358) on the following computer: Progex 9.20 VMachine

[sc-issues] [Issue 96712] Calc ShortCut CTRL+Space n ot work

2008-11-29 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96712 --- Additional comments from [EMAIL PROTECTED] Sat Nov 29 21:39:27 + 2008 --- Fernando: You can always assign 'Ctrl Space' to select an entire row (it is

[sc-issues] [Issue 96557] SUMIF with a string with j olly character criteria doesn't work

2008-11-28 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96557 --- Additional comments from [EMAIL PROTECTED] Fri Nov 28 14:36:30 + 2008 --- Created an attachment (id=58364) Excel 2003 sheet showing syntax difference from

[sc-issues] [Issue 96557] SUMIF with a string with j olly character criteria doesn't work

2008-11-28 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96557 --- Additional comments from [EMAIL PROTECTED] Fri Nov 28 14:45:00 + 2008 --- Attached an Excel 2003 win xp sp2 workbook that shows the syntax differences

[sc-issues] [Issue 95744] Macro recording problems w ith arrow-keys in formula

2008-11-06 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95744 --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 01:42:05 + 2008 --- The recorded macro loses the reference to the formula target cell, placing the

[sc-issues] [Issue 95744] Macro recording problems w ith arrow-keys in formula

2008-11-06 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95744 --- Additional comments from [EMAIL PROTECTED] Fri Nov 7 02:02:58 + 2008 --- Followup: It occurred to me, just after my previous post, to try this out in

[sc-issues] [Issue 95510] Only prints one sheet in a large file

2008-10-27 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95510 --- Additional comments from [EMAIL PROTECTED] Mon Oct 27 22:14:44 + 2008 --- Michael: You only have a print range defined for the one sheet, Wed the 6th. You

[sc-issues] [Issue 95455] excell file with macro doe sn't work in open office

2008-10-26 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95455 --- Additional comments from [EMAIL PROTECTED] Sun Oct 26 13:10:44 + 2008 --- Loading into OOo 3.0 does not find any macro code. TomW

[sc-issues] [Issue 94476] oo-calc - formatting cell from decimal number to format dd:hh:mm:ss re port wrong day

2008-10-22 Thread tomwb
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94476 --- Additional comments from [EMAIL PROTECTED] Wed Oct 22 10:46:04 + 2008 --- I may be mistaken, but I think the OP is trying to format a number that represents