[sc-issues] [Issue 114418] value returned by ADDRESS () not valid as INDEX() value
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 referencing itself. The 'Address' portion of this formula is returning 4,1 or cell "D1". This makes the 'reference' range for the 'Index' function, the cell that contains the 'Index' function. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 113105] Calc: mayer chart (statis tique) wrong result
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 1.9.1) and Ubuntu 9.04 (Gnumeric 1.8.4) TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110570] Rounding/addition error
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 Summary|Rounding/addition error |Rounding/addition error --- Additional comments from to...@openoffice.org Fri Apr 2 20:13:28 + 2010 --- dwharty: It appears to be just normal rounding of floating point numbers. Excel 03 gives the same results. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110173] Data - Sort option not av ailable
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 a xml file, then saving the xml fie as an xls. By doing this I was able to open either of these two files in OO3.1.1. Sorting was now available in OO3.1.1 and OO2.4.1. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110173] Data - Sort option not av ailable
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. It will open on OO2.4.1, but makes OO3.1.1 inoperable: The UI does not open completely. I do not have OO3.2.0 available here. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 110173] Data - Sort option not av ailable
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 copy the data to a new spreadsheet, it is no longer read-only and you can sort the data. If your file is not a read-only file then something else is wrong. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109799] 2 days difference in date s
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 different Date formats on the two cells in question on all four workbooks provided by the OP. The A3 cell is using a what my system is calling a custom DD/MM/YY format. The B3 cell has either the MM/DD/YY format or the General format. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 109691] possible bug in MEDIAN() function of OOo Calc
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 Median provides the middle value of a 'sorted' list. >From Wikipedia: "The median of a finite list of numbers can be found by arranging all the observations from lowest value to highest value and picking the middle one." TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 108030] calc Sum function varies in amount.
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, you will see that you have fractional cents that you are adding. e.g. $537.6195. If you go to Tools|Options|OpenOffice.org Calc|Calculate and check 'Precision As Shown', the sum will behave as you expect. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107201] loading large html file i n scalc hangs
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) on Vista Sp2. I started the process to open the file in calc about 5:30 am. When I arrived home at 8 pm, the file still had not opened.(14.5 hours!) I killed the process, which was showing memory usage of over 300 meg on a 4 gig machine. OO Web/Writer will open it, but it takes a minute or so. Also Firefox 3.5.5 needed a minute or better to open it. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 107185] Net chart does not displa y all data ranges
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 three series. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 106358] Round-Off Error According to Cell Formatting
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 | Precision as shown". Uncheck the box. It should display correctly now. TomW OOO310m19 on Vista Sp2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105648] OpenOffice.org 3.1 and 3. 11, Calc, Err 525
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 OOO241 as indicated by OP. The OP has iterations steps set to 1 with a change of 1. One must use Ctrl-shift F9 to re-calculate the cells for the error goes away after opening the workbook. If the step is changed to 2, there is no error on reopening the file. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105588] Formulas inside an area a re not reassigned when you sort that area by a column
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 105588] Formulas inside an area a re not reassigned when you sort that area by a column
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 correct sort. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 104069] Over 71 minutes to open a spreadsheet
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 document. I seem to remember an issue with these types of documents from excel taking a very long time to open. Issue 86650? 2)I opened it in Excel 2003. A "Save As" defaults to a web type document. I then overrode this default and saved it as a Excel xls workbook. 3) Opening the newly saved document in OO03.1 is nearly instant. So the fix in the 3.2 line must of corrected this issue TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 25368] mis-calculation in autofil l for numbers with one or two decimal places
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 anything like what you had experimented with. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.
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 Version|OOO310m9 |OOO310m11 --- Additional comments from to...@openoffice.org Sat Jul 25 12:55:52 + 2009 --- Changed OO version to 000310m11. Brain cramp!! TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103784] Autofill does not work co rrectly for certain numbers.
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103784 Issue #|103784 Summary|Autofill does not work correctly for certain numbers. Component|Spreadsheet Version|OOO310m9 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|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 | Edit | Fill | Series (Linear) works ok. I have found four numbers, that if used to start an autofill series, will not autofill as desired. Example: first cell = .3, second cell = .31, third cell = .32 If I select the three cells then try to autofill with the drag handle, the next value created is 1.3, not 0.34, then 1.31, followed by 1.32. The first digit is incrementing, not the last. The other decimal values that do not work as expected are 0.4, 0.6, 0.7. Another quirk to this is that for 0.3 and 0.6, if I enter them as .30 or .60, the sequence in the autofill is correct. This does not work with 0.4 or 0.7. You will notice in my above example that I did not put in a leading zero when describing the number sequence. This was to show that I did not type a leading zero when entering them into a cell. (Adding a leading zero to the left of the decimal point had no effect.) The bugdoc hopefully shows this more clearly. I did a search of the Issue Tracker for Autofill and found a few issues, but that did not seem the same as this. Issues 5550, 25368, 88119, 92292 were the closest. I found the same behavior on OO 3.0.1(Ubuntu version) on Linux and OO 2.4.1 on Vista SP2. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103638] Loading a rather simple . ods file takes >10 minutes
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 links, the file opens quickly. 1) What I found to be a a bigger problem, is that it takes a very long time for Calc to break the links (about the same order of time as the slow loading). 2) If my shaky DSL connection goes down, Calc still tries to open the file but can't. Once the connection was re-established, it then opened the file eventually (more than ten minutes elapsed). TomW OOO310m11 on Vista SP2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
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, whether copy/paste or typed in. Will attached Excel file. TomW 000310m11 on Vista SP2 and Excel 2003 on XP SP2. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103295] Date conversion Error whi le pasting dates in MM/DD/YYYY format
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 system by the English(US)language or locale setting. Anything greater than 12 in the month slot is not recognized as a date. Therefore that data with a month greater than 12 is pasted as text. If one changes the locale to English(UK) (DD/MM/YY), the pasted data is correctly recognized as a date. TomW OOO310m11 & OOO2.4.1 on Vista SP2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black
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 "Use automatic font color for screen display" enabled? If so, un-select it and then see if you can change font colors. This is setting that will affect all components in OO. TomW OOO310m11 Vista SP2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t
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 mode. Documents attached showing changes. TomW OOO310m11 Vista SP2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t
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 entering edit mode - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t
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 Descriptor(XML)) before edit - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 103007] Chart Data Table incorrec tly plotted in Standalone x-y scatter data plo t
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102821] Charts as their own sheet
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 chart then paste special in a new sheet as "Star Object Descriptor (XML)". This maintains a link with the data and is fully editable as a chart. Not quite a neat and clean as Excel, but it does work. TomW OOO310m11 on Vista SP2. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102822] Chart elements do not han dle subscripts/italics/etc.
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 using the somewhat limited 'Insert | Special Character' method, one can create in the formula editor much of what you want, in a cell on the sheet. Then copy the formula in the cell and paste it into the chart, placing it where the different titles would be located. However, once pasted into the chart you cannot edit the formula. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102820] Chart elements cannot be specified post-creation
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 chart title and axis labels. No need to start over on my system. TomW OOO310m11 on Vista sp2 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black
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 numbers as text, formula cell locations, etc. When you turn off Value Highlighting, you can format the cells to any color you want. When Value Highlighting, it disables any font colors while it is enabled. Turn it off and the cells will revert to the your colors of choice. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 102726] Number format show blue a nd green colors, not black
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, View | Value Highlighting or Tools|Calc|View|Value Highlighting will toggle this on or off. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101782] Can't open calc spreadshe et - OOo hangs
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 file. This process changed the long fourth sheet name to just sheet5 and the order of the sheets. The first sheet became the second sheet, but it still maintained the links to the newly named fourth sheet. OO 3.1 will now open this file with all four sheets. Windows Vista TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101782] Can't open calc spreadshe et - OOo hangs
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 not show any external links (Edit | Links... is grayed out). The first sheet links to the fourth sheet. When I open it in OO 3.1, calc it asks if you want to update links(to the missing fourth sheet which it thinks is a original file), and the fourth sheet is missing(Nothing to unhide). If you open up the Links dialog, it is trying to link to the external file (which is now the missing sheet). windows vista TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101791] Sorting can modify formul a
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. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101791] Sorting can modify formul a
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 and Excel03 on XP sort correctly. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 101712] Countif can't count text wildcards
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 Expressions", which are more robust than what Excel can do. http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_COUNTIF_function TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 87934] red color for negative fig ures
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 if this option is checked. I do not know if it is the same on a mac, but on Vista 'Ctrl F8' toggles this on or off. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 100523] (request) quick sum of ce lls
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 window (lower right). Whatever you highlight for a range will be summed in the status bar. If you right click the status bar near the sum value, you can change the function e.g. average, etc TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 100455] Performing math on a cell that contains a formula fails.
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 "Left" returns a string and "N" treats strings as 0. Using "Value" instead of "N" will give you the results you are looking for. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 99478] Selecting rows/columns imp ossible after using function wizard
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 and column selection is enabled again. If you have multiple documents open, each one needs to be saved to re-enable row/column selection. You can open a new document and it will not be affected while the others have the row/column disabled. This problem does not occur in OOO300m15 build 9379. Vista Sp1 TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 98505] Columns considered second class
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 98505] Columns considered second class
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.
{=B5:B15*C5:C15}, the braces are created when you use Ctrl Shift Enter to enter
the array function to give the output array.(Which is created automatically.)
If you need a sum of the product just use the "SumProduct" function. Also, you
can name your different data areas and use them in the array formula . Eg.
{=UnitsP*UnitV/TimeP}. Attached a sample sheet.
TomW
-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
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 selection of the "US English" is made after selecting a field column in the window. This enables the "Field Type" Dropdown box where you can make the Selection for "US English". I should have been more explicit in my previous post. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
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 issue shown in your jpg, I found that I could import the file correctly by changing the field type in the import dialog to "US English". As noted before, My US English system imported the file with out issue. Whether your systems language includes the "US English" in the Import Dialog is unknown to me. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 33723] Ability to turn off Number Recognition for incomplete dates in Calc
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 in OOO2.4.1 and OOO300m9 on Vista. Need better information: OS, OOO version, and file that does not import properly. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97915] Loads xls file incorrectly with wrong formatting
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 correctly on with OOO2.4.1 on Vista; It opens as a Web/Writer document. This is opening it from within OOO2.4.1 Calc . TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97778] Add ability to paste newli nes.
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 newlines into an empty cell. Worked on both a Vista system and Progex Linux VM. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97778] Add ability to paste newli nes.
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 cell in order to enter text with new lines. Just double click the empty cell (edit mode), then paste. Works on OOO300m9 on Vista and a Ubuntu version of Linux (Progex), DEV300m35 on Vista. TomW P.S. If you want to insert text with new lines into a cell with text, after double clicking the cell, place the cursor where you want to insert the text, then paste. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97748] R1C1 Formula Syntax Defect ective
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: 1:3.0.0-6ubuntu0Intrepid1 TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97701] Workaround for 65K line li mit for csv
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 Summary|Workaround for 65K line li|Workaround for 65K line li |mit for csv |mit for csv --- Additional comments from to...@openoffice.org Fri Jan 2 00:57:45 + 2009 --- Here is a link to some vba code for importing large files, 65k plus lines, into Office 2003. I am not familiar enough with Starbasic to know how to convert this code. Someone with this experience on the list might be able to make it functional for Calc. http://www.cpearson.com/excel/ImportBigFiles.aspx TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 97396] OO3/Linux crashes on impor ting this doc
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 OOO300m9. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[sc-issues] [Issue 96989] crashing when opening exce l document
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 Version= 8.20 - Based on Ubuntu 8.10 with GNOME 2.24.1 desktop Linux filesystem: ext3 Kernel= 2.6.27-8-generic and the same OOO version/build on Vista Home Premium. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 96712] Calc ShortCut CTRL+Space n ot work
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 unused currently), by going to Tools|Customize|Keyboard. Currently the shortcut for selecting an entire column is 'Ctrl Shift Space', which matches up with 'Shift Space' for selecting an entire row. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 96557] SUMIF with a string with j olly character criteria doesn't work
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 between Excel and Calc. Calc needs a period (stop) added to the formula along with regualar expressions enabled. It appears that Calc does not translate the Excel syntax to Calc syntax. This was using OOO300m9 (Build:9358) and Dev300m35 (Build:9367) Calc versions. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 96557] SUMIF with a string with j olly character criteria doesn't work
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 Calc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 95744] Macro recording problems w ith arrow-keys in formula
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 Excel 2003. I recorded the macro verbatum. Saved the file, opened it in OOo 3.0 then saved it as an ods file. The macro runs correctly. Go figure! TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 95744] Macro recording problems w ith arrow-keys in formula
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 result in the position of the last cell movement by use of the arrow key. I tried several different macros that started the use of the arrow keys in different positions. It always places the formula in the last position selected by an arrow key. TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 95510] Only prints one sheet in a large file
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 need to define a print range for all sheets. Format|Print Ranges|[Define],[Add],,[Edit]. Also, this is a question that should first be asked on the OO Users mailing list, or forums. If it can not be resolved there, then a bug report should be filed using this Issues list. Sincerely, TomW - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 95455] excell file with macro doe sn't work in open office
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 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sc-issues] [Issue 94476] oo-calc - formatting cell from decimal number to format "dd:hh:mm:ss" re port wrong day
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 a time interval. e.g. It 7.6 days to download OOo on my 1200 baud modem. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
