Difference between revisions of "User talk:RedflagQA"
(→Q&A) |
|||
Line 2,911: | Line 2,911: | ||
= Q & A = | = Q & A = | ||
== Framework == | == Framework == | ||
+ | * '''Send document as E-mail by foxmail which is the default e-mail client''' | ||
+ | ''Amy2008'':<br> | ||
+ | How can I send document as E-mail by foxmail which is the default e-mail client? | ||
+ | File - send - Document as E-mail, | ||
+ | dialog 1 | ||
+ | no default e-mail client ...... Pls run Microsoft Office Outlook as default e-mail client | ||
+ | dialog2 | ||
+ | OOo can't find a working e-mail configuration ...... | ||
+ | |||
+ | Related links | ||
+ | http://www.oooforum.org/forum/viewtopic.phtml?t=46349 | ||
+ | http://www.openoffice.org/issues/show_bug.cgi?id=64151 | ||
+ | http://kb.mozillazine.org/Default_mail_client#Windows | ||
+ | http://en.wikipedia.org/wiki/Messaging_Application_Programming_Interface#Service_provider_interface | ||
* '''How to set an user-defined template as the default one?''' | * '''How to set an user-defined template as the default one?''' | ||
''Amy2008'':<br> | ''Amy2008'':<br> |
Revision as of 07:45, 25 June 2009
TCM testing
Localization 21
- L10N test of OpenOffice.org 2.3, run all the testcases in the TCM
Localization 27
- L10N test of OpenOffice.org 2.4, run all the testcases in the TCM
Localization 29
- L10N test of OpenOffice.org 3.0, run all the testcases in the TCM
- Duration: July 22nd To August 14th
- Testers: Li Meiying, ZhangHong, Hu Ruihai, Liu Xia, Meng Yuanyuan, Xing Yancheng, Zhu Lihua
- Result
OS | Pass | Fail | Skip | Total |
Linux | 5 | 0 | 0 | 5 |
Windows | 142 | 56 | 6 | 204 |
Total | 147 | 56 | 6 | 209 |
- 30 new bugs found
IssueID | Description |
92074 | Unlocalized date format in Share Document dialog |
92110 | [zh-CN]Un-translated help content: solver |
92111 | [zh-CN]Translate error in Solver dialog: operator |
92112 | [zh-CN]Typo error in Solver->Option dialog: Engine |
92113 | data range not match: Solver->Options->Epsilon level |
92114 | [zh_CN]Button label translate error in Solver Result dialog |
92115 | When select a cell, we get a cell range in Solver dialog. |
92128 | [zh-CN]discontinuous underline in chart titles(axis titles) |
92264 | logo image is a little bigger than that it should be. |
92265 | Un-translated items in Fields dialog. |
92268 | Text in messagebox goes garbage in File->Wizard |
92434 | Incorrect zoom display after leaving OLE mode and using slider |
92464 | Unlocalized contents in message box when save a read only document with the same name |
92466 | Translation error in Resolve Conflict dialog |
92514 | Date format error. |
92538 | Access key doesn't work in table wizard. |
92540 | refresh problem in View Design window |
92541 | Line height too small to display characters in View Design wizard |
92542 | SubForm fails to delete when uncheck the "Add Subform" checkbox in the Form Wizard |
92543 | Crashes when close report created by old report wizard |
92547 | Bullets and Numbering doesn't work in impress |
92652 | Cursor goes to wrong place in a "drop cap" paragraph |
92682 | Inconsistent translation in Column tab in Page dialog |
91942 | Double image in Header or Footer edit configuration |
91952 | SC: Date Format error |
92018 | Time format string changed into text |
92064 | Link to External Data: some links make OOo crashed |
92071 | can't match the right font for *.ppt |
92200 | Wrong interconversion between SBC case and DBC case in ZH |
92436 | OLE object Showed abnormally when reloading or reopening doc |
Translating all the testcases
- All the testcases in the TCM are translated into Chinese
- Corrected some testcases during translation
Localization 35
- L10N test of OpenOffice.org 3.1, run all the testcases in the TCM
- Result
OS | Pass | Fail | Skip | Total |
Linux | 141 | 39 | 8 | 188 |
Windows | 167 | 52 | 10 | 229 |
Solaris | 10 | 0 | 0 | 10 |
Total | 318 | 91 | 18 | 427 |
- 5 new bugs found
IssueID | Description |
99837 | Cell format: [DBNum?] don't work |
99841 | Title with Vertically stacked attribute behaves error when e |
99842 | wrong colour displayed for underlining text |
99944 | Clicking "Create Report in Design View..." failed to open th |
99947 | opening biblio.odb, the data on row 1 and column 1 is "BOR04 |
Issue handling
Verified issues Closed by RedFlag QA people
46681 | P3 | ODFF: Repeat values of single array vector if used in second |
51656 | P3 | Add resizeable margin on page preview |
56931 | P3 | Problem with notes and window-freeze |
57668 | P4 | deleting a table which is currently opened for data entry le |
77853 | P3 | Columns reversed when pasting RTL spreadsheet into Writer |
81037 | P3 | The function 'SOME' is not allowed in Query Designer, or wit |
81468 | P3 | Add shortcut to put focus on the list in Apply style combobo |
86856 | P3 | Show Formula Syntax in tip help! |
87843 | P4 | when using assistant to create FAX / letter, comma mistakes |
87844 | P2 | Crash while saving multiple mail-merge form letters |
88467 | P3 | Undo is not possible after changing margins in page preview |
90614 | P2 | Saving file o exporting it into PDF causes crash |
91146 | P2 | Negated large arrays slow application |
91483 | P2 | Writer crashes when inserting ole if text is hidden |
91547 | P3 | ODFF: enhance BETADIST to support probability density functi |
91780 | P3 | Error: no StreamName ??? |
91800 | P3 | Fonts are too small after saved a loaded xls file to ods |
92164 | P2 | Escape processing setting is ignored |
92514 | P3 | Date format error. |
92541 | P3 | Line height too small to display characters in View Design w |
92564 | P3 | Old MIME Type Icons in File->New->Templates and Documents |
92682 | P3 | Inconsistent translation in Column tab in Page dialog |
92853 | P3 | [zh-CN]menu item Inconsistent with help content |
93176 | P3 | preview mode not saved anymore with database document |
93450 | P2 | [API crash when calling XRow::getObject with a NULL typemap |
93473 | P2 | closing a form while the data source browser is focused sile |
94187 | P2 | WW8: Broken export of some bullets positions to MS-Word 97 |
94455 | P2 | database document corrupted after renaming a table |
94568 | P2 | opening a report design which has been copied, and after the |
95381 | P2 | Calc function ADDRESS not retro-compatible |
95865 | P2 | migrating macros in a form with non-ASCII name loses al macr |
96167 | P2 | PDF Export from page preview crashes when field names are di |
96191 | P3 | .dbf export fails on N,x,0 fields |
96835 | P3 | ODFF: make the last parameter of LOG function optional |
96837 | P3 | ODFF: make the last parameter of POISSON function optional |
96930 | P3 | the toolbar's sorting icons should be disabled in multi-sele |
97271 | P2 | [cws mav43] database is readonly after opening |
97680 | P2 | Crash loading valid spreadsheet file |
97892 | P3 | target URL of form control buttons interpreted incorrectly |
98000 | P2 | Crash when loading a Calc file that was saved from page prev |
98029 | P3 | Import of grouped objects from BIFF8 broken |
98115 | P2 | "Edit" is a different SQL from "Edit in SQL View" |
98174 | P2 | range names display "#NAME?" in formula bar |
98240 | P2 | .xls crash after GetBasic called on Shell |
98317 | P2 | using FunctionAccess service causes crash |
98318 | P2 | Office Crash after setting the reference to an existing file |
98402 | P2 | PDF Export: Dramatic Performance Regression |
98655 | P3 | Function Wizard doesn't show function description before a f |
98656 | P3 | Function Wizard: reference input possible if no function is |
98738 | P2 | Crash when selecting "Last Used" in Function Wizard |
98747 | P3 | Function Wizard: Function can no longer be selected with Spa |
98784 | P3 | List boxes scroll too late when travelling with cursor keys |
100116 | P2 | Properties of form controls not usable |
100135 | P3 | Moving formulas containing external references may result in |
100346 | P2 | Crash:copying filter's data from excel 2003. |
100349 | P2 | crash when close the font dialog in a richtext Control |
100416 | P3 | External area reference breaks if linked document is updated |
100541 | P3 | Edit control with scrollbars paints garbage |
83317 | P3 | Spreadsheet: long copy and cut |
84426 | P3 | Make filetype detection independent from file suffix |
84777 | P3 | OO enter in loop with copy and paste |
84874 | P3 | Data filters imported from Excel not properly editable |
84930 | P3 | calc crashed with output log. |
85004 | P3 | Formatting lost when using Search&Replace |
85187 | P3 | Wrong option gets disabled in paste special, shift cells |
85322 | P3 | Inserting cols mis-updates range arg of functions |
85498 | P3 | Copy/paste is irritatingly slow in calc & base |
86133 | P3 | No warning when exporting un-translatable function |
86863 | P3 | Vlookup not included added data |
86869 | P3 | Crash when ctrl-a ctrl-v pasting into a Spreadsheet |
87178 | P3 | link to external data does not work for cgi text data |
85362 | P3 | Calc: Default Formatting ruins dates |
86832 | P3 | Error with exponent in formula |
92855 | P3 | [zh-TW]Inconsistent translation of "Function" and "Virable" in Math |
93313 | P3 | [zh-TW]Translation error in chart |
99072 | P3 | Translation error in bullet and numbering |
100300 | P3 | Unreferenced external sheets saved lead to "Update links?" dialog and can't be removed. |
Issues confirmed by RedFlag QA people
83332 | P3 | xls import filter fails to handle the anchored-to-page prope |
84417 | P3 | Regression -Unable to edit chart title with IME |
85081 | P3 | checkbox's jumping |
85095 | P3 | Excel XML import filter loses times |
85110 | P3 | ImportDescriptor for unregistered sources |
85297 | P3 | Importing 65536 rows CSV incorrectly informs it exceeded the |
85342 | P3 | problem with text wrap in Calc cell |
85395 | P3 | date field error |
85646 | P3 | not correct result when macro write the single value to cell |
86040 | P3 | Incorrect Page Format between Windows and Linux |
86283 | P4 | DELTA/GESTEP functions with non-numeric args are inconsisten |
86422 | P3 | incorrect paste operation if array functions are used |
86447 | P3 | Validity down-arrow overwrites the next cell |
86512 | P3 | bitmap display distorted |
87053 | P3 | Form control buttons not working in opened Excel sheet |
87107 | P3 | Incorrect display of chart in MS Excel file |
87171 | P3 | Create Names doesn't work properly for 'rho' |
87265 | P3 | Graphics inside and anchored to cells do not behave in predi |
87321 | P3 | Solver: Does not recognize unbounded model |
87322 | P3 | Solver: "Solver engine" dropdown enabled, although it should |
87353 | P4 | RANK sometimes gives a rank to text |
87544 | P3 | OOo Linux build fails to display dragging borders while movi |
88022 | P3 | diferences between „passive“ and „active“ cells and between |
88071 | P3 | text data corrupted on reopen when saved as HTML: leading z |
88072 | P2 | Data validity "list" will be changed to "cell range" if inpu |
88187 | P3 | cell background colour doesn't follow when cell is moved cal |
88431 | P3 | Calc does not export sheet props properly into .xls file |
88456 | P4 | user defined number format does not survive closing and reop |
88487 | P3 | deleting cells very slow when sharing document |
New issues filed by RedFlag QA people
98054 | P2 | Closed | Fixed | Crash when open a html file |
92682 | P3 | Closed | Fixed | Inconsistent translation in Column tab in Page dialog |
92853 | P3 | Closed | Fixed | [zh-CN]menu item Inconsistent with help content |
84412 | P3 | Closed | Fixed | insert note->display note->copy/past->save->reopen->note dis |
84510 | P2 | Closed | Fixed | Crash when clicking "AutoWidth" in "forbidden" case on colum |
91486 | P2 | Closed | Fixed | OOo Crashes when set Table property |
85403 | P3 | Closed | Fixed | Numbering with circled-digit, 11-20 can't display in Chinese |
92541 | P3 | Closed | Fixed | Line height too small to display characters in View Design w |
92074 | P3 | Closed | Fixed | Unlocalized date format in Share Document dialog |
85456 | P3 | Closed | Fixed | Slot/control unknown :"WaitSlot" |
80891 | P3 | Closed | Fixed | character in the forbidden list sometimes appears at the hom |
83481 | P3 | Closed | Fixed | "Enclosing character" controls in "Asian layout" tab in cha |
92514 | P3 | Closed | Fixed | Date format error. |
83480 | P4 | Closed | Fixed | Can not change focus with arrow key in "Asia typography" tab |
80898 | P3 | 已验证 | Fixed | copy words from calc to writer, font size changed. |
84110 | P3 | Closed | Fixed | Fonts Replacement table issue. Tools->Options->OOo->Fonts |
97299 | P2 | Closed | Fixed | Writer crashed when setting cursor to Note and clicking 'Und |
97380 | P2 | Closed | Fixed | Writer crashes: Delete all Notes and Undo between Original d |
97577 | P2 | 已验证 | Fixed | Edit address list associating with CSV file has been deleted |
97471 | P2 | 已验证 | Fixed | Group two drawings, double-click one drawing meanwhile enter |
97295 | P2 | Closed | Fixed | Writer crashed when editing the 'Frame' inserted via Placeho |
97377 | P3 | 已验证 | Fixed | OK is inactive after draging 'Form Controls' to change its ' |
97346 | P2 | Closed | Fixed | Impress crashes when draging Check box to the top of 'Tab O |
97386 | P2 | Closed | Fixed | OOo crashed: Close 'Styles and Formatting' dialog and later |
92786 | P3 | Closed | Fixed | Show wrong hint dialog when cancelling Insert Further object |
92891 | P3 | Closed | Fixed | Insert *.xls which renamed from *.txt into Calc file, OOo cr |
97190 | P2 | Closed | Fixed | Impress crashes: Load blank template and double click this b |
97261 | P2 | Closed | Fixed | Delete content of one cell in table and cut the cell, OOo cr |
97296 | P2 | Closed | Fixed | Impress crashed: Click Custom Animation pan after canceling |
97338 | P2 | Closed | Fixed | Drawing and Impress crashes when rightclicking on thumbnail |
97413 | P2 | Closed | Fixed | Drawing&Impress crashes: Insert a table and update color of |
97552 | P2 | Closed | Fixed | Insert Object document with password as a link, input wrong |
83888 | P2 | Closed | Fixed | Second time click hyperlink button,the presentation crash. |
96644 | P2 | Closed | Fixed | (W) Program crash when formatting a paragraph, add hyperlink |
96822 | P2 | Closed | Fixed | Closing "business card" dialog when called from hyperlink di |
97388 | P3 | Closed | Fixed | Crash while set the "Max. base text size" to 0 in "Text Grid |
97347 | P2 | Closed | Fixed | Insert a table, edit it, undo and insert again, OOo crashes |
97478 | P2 | Closed | Fixed | Crash when "Increase Spacing" on demoted text |
97634 | P2 | Closed | Fixed | Impress Crash: when Find&Replace dialogbox show, switch view |
98386 | P2 | Closed | Fixed | modify the select region in ImageMap crash OOo |
97628 | P3 | Closed | Fixed | All of Custom Animation have no effect in Impress |
99947 | P3 | Closed | Fixed | opening biblio.odb, the data on row 1 and column 1 is "BOR04 |
96597 | P3 | New | Font size changed if paste or move characters in text line. | |
91504 | P2 | New | Sort and Undo text with picture cause OOo crash | |
80888 | P3 | New | Titles of some html files become to garbage. | |
87359 | P3 | New | Interoperability issue: Copy table from Ms-Word to writer vi | |
92652 | P3 | New | Cursor goes to wrong place in a "drop cap" paragraph | |
80892 | P3 | New | find/replace function can't work correctly | |
85323 | P3 | New | Click on text attributes button in Header & Footer dialog fa | |
86436 | P3 | New | copy cell to writer, extra line inserted | |
84441 | P3 | New | Undo in a protected sheet | |
84634 | P3 | New | When Drop caps characters greater than page, text will disap | |
85257 | P3 | New | indents not fit the habit of chinese people | |
85784 | P3 | New | Uncheck Dawing in Pinter Otions Dialog, drawings still print | |
87118 | P3 | New | Highlight have different base line and height in the same li | |
80895 | P5 | New | Chinese charactor will be garbage when saved as MS95 form. | |
93500 | P3 | New | The left and right margin of some paper size are not correct | |
84072 | P4 | New | Characters goes right side out of the display area of screen | |
84736 | P3 | New | DDE link and DIF paste cause Chinese character garbage | |
98220 | P3 | New | images without absolute address failed to get url and can't | |
92268 | P3 | New | Text in messagebox goes garbage in File->Wizard | |
80873 | P3 | New | header and footer configuration error | |
84109 | P3 | New | Fonts replace table doesn't work well in calc, Tools->Option | |
84444 | P3 | New | The direction of the text can be changed from tool bar in a | |
84483 | P3 | New | AutoFill issue about rotate text in a merged cell | |
92113 | P3 | New | data range not match: Solver->Options->Epsilon level | |
84633 | P3 | New | adjust font size with Reduce Font, abnormal When reached 2 | |
86716 | P3 | New | Table border preview shows double line incorrectly | |
87122 | P3 | New | "scale width" in character dialog does not offer "tri-state" | |
92434 | P3 | New | Incorrect zoom display after leaving OLE mode and using slid | |
93164 | P3 | New | refresh problem with OLE object out of paper range | |
84293 | P4 | New | Tools->Options->OOo writer->view->Ruler logical problem | |
92110 | P3 | New | [zh-CN]Un-translated help content: solver | |
80896 | P3 | New | DateTimePicker in AcceptChanges dialog does not work well | |
84405 | P3 | New | meta issue to track issues discovered by RedFlag2000 QA | |
85137 | P3 | New | [zh_CN] File->Wizards not localized | |
80886 | P3 | New | Insert hyperlink abnormal, chararcters replaced by URL | |
84300 | P3 | New | if we choose none for page number, the word "page" shouldn't | |
84632 | P3 | New | font effects will effect paragraph mark (paragraph break) | |
85251 | P3 | New | File name field in save dialog should be pre-fill by the fir | |
80889 | P3 | New | autocorrect in Chinese version does not work correctly. | |
84558 | P3 | New | character font changed during Chinese translation | |
84681 | P3 | New | Chinese character Numbering error for list numberings >100 | |
84981 | P3 | New | spellcheck do wrong in English version of writer with Chines | |
85404 | P3 | New | not localized options in listbox in Insert Index/Table dialo | |
85419 | P3 | New | Search text with specific attribute fail with font selected | |
85420 | P3 | New | quotation marks can't replace correct in Tools->AutoCorrect- | |
85421 | P3 | New | Some Full-width characters can't convert to half-width chara | |
86561 | P3 | New | Uncompatible when open a MS Doc file with grid enabled | |
87537 | P3 | New | missing data while Chinese-translation with a draw object se | |
92265 | P3 | New | Un-translated items in Fields dialog. | |
92464 | P3 | New | Unlocalized contents in message box when save a read only do | |
99184 | P3 | New | AutoFormat dialog shouldn't set "AutoFit width and height" v | |
80897 | P4 | New | [zh] Autotext is in japanese (TOP) | |
84686 | P3 | New | sort include merged cell, something wrong. | |
84733 | P3 | New | assign a font to a cell, when input text, the font is change | |
84739 | P3 | New | copy text on a picture, font size changed | |
85034 | P3 | New | can not go to the cell on the right in merged and wrapped ce | |
86338 | P3 | New | Set note to background, adjust column width, the note point | |
86339 | P3 | New | set note to background, copy cell, paste, note move to left | |
86951 | P3 | New | Copy hyperlink from MS-word to Calc, failed. | |
87540 | P3 | New | Open a excel document with macro, scripts are remarked. | |
89359 | P3 | New | character can't display when swith between tabs if we use Ms | |
92111 | P3 | New | [zh-CN]Translate error in Solver dialog: operator | |
92112 | P3 | New | [zh-CN]Typo error in Solver->Option dialog: Engine | |
92114 | P3 | New | [zh_CN]Button label translate error in Solver Result dialog: | |
92978 | P3 | New | font can't apply to characters if set font name before input | |
99837 | P3 | New | Cell format: [DBNum?] don't work | |
100971 | P3 | New | header/footer CJK font name inconsistent with global setting | |
80871 | P3 | New | DateTimePicker does not work well | |
84740 | P3 | New | copy table from writer to calc, reference point need modify | |
86340 | P3 | New | Tools->Options->OOo->View->Mouse->Middle mouse button UI err | |
94058 | P3 | New | Performance-Very slow to show contents | |
94268 | P3 | New | refresh problem in options dialog, extra checkbox showes | |
97055 | P3 | New | no warning when save file if there is hidden content | |
93504 | P4 | New | Vertical callout and text button can not be hidden in drawin | |
97300 | P2 | New | Drawing or Impress crashed when modifying links of inserted | |
97333 | P2 | New | OOo crashes when doing 'Undo' after deleting two user-define | |
97334 | P2 | New | Impress crashes when setting 'Custom Animation' for characte | |
97341 | P2 | New | Drawing&Impress crashes: select 'Input' in the Drawing bar | |
97477 | P2 | New | Find&Replace under Handout and do it again after switching t | |
97573 | P2 | New | Do sth. on the deleted theme, crashes OOo | |
101006 | P2 | New | Crash when applying layout for three pages, Undo three times | |
97188 | P3 | New | Opening a modal dialog still allows to operate toolboxes. | |
97419 | P3 | New | Modeless dialog opens when deleting a new layer's name and c | |
98305 | P3 | New | Slide show with Window type, no response when closing and sa | |
97384 | P2 | New | Deleting characters and insert a Writer file under Record Ch | |
97420 | P2 | New | Writer crashes after Undo-Redo-Undo with tracked changes not | |
97421 | P2 | New | Writer loops after deleting invisible recorded changes and U | |
97474 | P2 | New | Move table-formula, split cell and merge the whole table, Un | |
97481 | P2 | New | Undo on sorting in nesed tables crashes Writer | |
97551 | P2 | New | Insert Object into Index and edit Index, Undo-Redo crashes W | |
98382 | P2 | New | Modify a style which has been deleted, crashes OOo | |
97298 | P2 | New | Drawing or Impress crashed after merging cells and spliting | |
97301 | P2 | New | arithmetic progression problem make OOo crashed after Mergin | |
97652 | P2 | New | Insert table with more than 50 columns and rows hangs Drawin | |
96820 | P3 | New | impress table: Merge cells in Inserted talbe, save button is | |
97262 | P3 | New | Undo-Redo don't work well after splitting cells | |
97684 | P3 | New | To equal proportions' doesn't work when spliting cells hori | |
98016 | P3 | New | Split cells twice on the same row of table | |
97968 | P3 | New | Double-click Default can't display Slide Design dialog after | |
97379 | P2 | New | Crash after deactivating certain Calc OLE in Writer | |
97969 | P3 | New | overwriting own templates unsuccessfully | |
97186 | P2 | New | Insert a new Hyperlink document with long name, OOo crashes | |
101009 | P2 | New | Crash when turning off "Show changes" after "compare documen | |
97570 | P2 | New | Insert a file with Object document and Undo twice crashes Wr | |
97566 | P2 | New | Open Sina index page hangs OOo | |
98267 | P3 | New | Page numbers increase continuously when inserting a video fi | |
97565 | P2 | New | Insert Index and moveup Text on Navigator crashes Master doc | |
101214 | P2 | New | Preview userdefined Autotext with indexs and tables, crashes | |
101125 | P2 | New | ^$ freezes writer containing table (Find & replace) | |
101149 | P2 | New | ^. freezes writer (Find & replace) | |
92071 | P3 | New | can't match the right font for *.ppt | |
97189 | P3 | New | Format error discovered in the file content.xml at position | |
97175 | P2 | New | Calc crashed When pasting table from Writer not MS word | |
97336 | P2 | New | Calc crashes when rightclick-Default to set the character in | |
97389 | P2 | New | Calc hangs when double_clicking OLE text object containingti | |
97649 | P2 | New | Full Screen View switch on/off while switch typewriting and | |
91942 | P3 | New | Double image in Header or Footer edit configuration | |
92018 | P3 | New | Time format string changed into text | |
92436 | P3 | New | OLE object Showed abnormally when reloading or reopening doc | |
93125 | P3 | New | Validity: no error messages when invalid values are entered | |
93128 | P3 | New | Validity: wrong error messages if Text length item works | |
97655 | P3 | New | Dropdown list shows wrong data after setting validity Criter | |
97683 | P3 | New | Content of Note stay the status before updating the content | |
97731 | P3 | New | Slide page displays wrong after Undo Page Format | |
97732 | P3 | New | Can't enter edit mode after select all | |
97758 | P3 | New | Can't save autoformat settings for cell ranges in Calc | |
97759 | P3 | New | Organizer contains unreadable informations in cell styles an | |
97787 | P3 | New | Spacing from Expanded to Condensed when space value is a lar | |
97857 | P3 | New | Dropdown list shows number format after setting validity as | |
97885 | P3 | New | Font and Font size show disharmony in Calc After chinese tra | |
97971 | P3 | New | Vertical Scroll bar was fixed after doing AutoFilter or Stan | |
97976 | P3 | New | Drawing distorts after autofileter all | |
98014 | P3 | New | Validity is broken when pasting sort result with unchecking | |
98019 | P3 | New | Spacing to contents works in a mess when editting cells and | |
98105 | P3 | New | Paste cell on two sheets, sheet protection destroyed | |
98215 | P3 | New | Insert gallery into calc successfully after protecting sheet | |
98268 | P3 | New | replace text after protecting sheet, many hint dialog open | |
98269 | P3 | New | Group two or more notes, then show any note and move note to | |
98299 | P3 | New | Cursor locates on characters (not between characters) in ver | |
98336 | P3 | New | Date format changes when editing MM/DD/YYYY HH:MM:SS date fo | |
97381 | P2 | New | Insert a new Hyperlink document with illegal character, OOo | |
97415 | P2 | New | OOo hangs: Access a file which doesn't exist via CTRL+Click | |
98100 | P2 | New | Click Design mode on/off after opening Form controls' proper | |
97970 | P3 | New | Can't open hyperlink which target is a MS ppt slide page | |
98219 | P3 | New | Set macro for 'Push button', click the button after Design M | |
97259 | P2 | New | Draw&Impress crashed if copy and paste part of table in empt | |
101236 | P2 | New | chinese translation for doc containing "-----" crashes OOo | |
98760 | P3 | 未确认的 | macro cannot be removed in ImageMap | |
96777 | P2 | New | (I) Crash when creating new note master | |
97472 | P2 | New | hide all Custom Slide Show, OOo CRASH when showing | |
97659 | P3 | New | "New" button in standard toolbar failure after create an Imp | |
97682 | P3 | New | Impress: pointer in nevigator is nullification | |
97734 | P3 | New | Inserting slide by right-click layourts-style dose not apply | |
97737 | P3 | New | "Bullets and Numbering" in text field apply error when switc | |
97786 | P3 | New | Cannot insert OO file which has password | |
97967 | P3 | New | "Media playback" toolbar has blank item in "Visible Buttons" | |
98341 | P3 | New | Animated image's Area effect dosen't display in slide show | |
98384 | P3 | New | Undo failure after expand slide in outline view | |
99755 | P3 | New | custom animation assign error in paragraphs | |
99756 | P3 | New | Master file doesn't update properly when link file adds slid | |
97476 | P2 | New | Insert a charm base on table, delete a column of the table, | |
98948 | P3 | New | copy and paste a modified table, the change dosen't remain i | |
97260 | P3 | New | Deadlock when operating Simplified/Traditional Chinese trans | |
97654 | P2 | New | Writer: serious efficiency defect when open large pure-text | |
99842 | P3 | New | wrong colour displayed for underlining text | |
99838 | P3 | New | WW8: object cannot be activated in MSWord | |
99141 | P3 | New | Version save error when delete some internal version(s) befo | |
97385 | P2 | New | Loop when inserting an object into "hidden" text | |
97387 | P3 | New | crash when insert a nested table into a section with multi c | |
97650 | P3 | New | Writer block: paste a web page, then set page columns | |
99702 | P3 | New | button function error of "Numbering On/Off" and "Bullets On/ | |
99939 | P4 | New | Cannot close the Hyperlink dialog when a shape is selected | |
98334 | P3 | New | "Surface" setting in 3D-settings has no effection | |
97589 | P3 | 未确认的 | Serious efficience problem when fill the whole sheet, lead t | |
98221 | P3 | 未确认的 | program switch to engender unclosed prompt dialog-box in cal | |
99252 | P3 | 未确认的 | hyperlink lost after text replace in Calc | |
99399 | P3 | 未确认的 | Undo error in edit-mode with a cell has function | |
99839 | P3 | 未确认的 | set tabstop value over range, the value jump back to min val | |
99840 | P4 | 未确认的 | Optimal Height caculate error | |
99901 | P4 | 未确认的 | Chinese characters in Chart subtitle displays poorly in Calc | |
97651 | P3 | New | Calc block: Save the special .ods file as "Microsoft Excel 2 | |
98012 | P3 | New | function DAYSINMONTH and DATSINYEAR caculate error | |
97297 | P2 | New | Crash when save a new XML Filter which has the Unkonwn attri | |
97632 | P2 | New | Writer Crash: copy any DBC case punctuation from MS Word to | |
99841 | P3 | New | Title with Vertically stacked attribute behaves error when e | |
97962 | P3 | New | [Automation] (Writer)Problems encountered on a 19-inch wides | |
97961 | P3 | New | [Automation] (Framework)Problems encountered on a 19-inch wi | |
99944 | P3 | 未确认的 | Clicking "Create Report in Design View..." failed to open th | |
97963 | P3 | New | [Automation] (Dbacess)Problems encountered on a 19-inch wide | |
87312 | P3 | New | The master page picture is not show completely. | |
84531 | P3 | New | add custom animation to the movie,the custom animation is of | |
84687 | P3 | New | Cann't find and replace the word in hyperlink. | |
84526 | P3 | New | bullets and numbering lost after paste | |
83887 | P3 | New | Show slide ,the hyperlink button does not work. | |
84683 | P3 | New | visible buttons submenu have a blank option | |
101417 | P3 | New | WW8: MS doc containing chinese characters, hangs OOo. | |
101442 | P3 | New | Drag&Drop text works wrong between the different paragraphs. | |
101551 | P3 | New | [ZH] Black and White button incorrect translated in help content | |
101555 | P3 | New | Incorrect default CJK font when create document with context menu | |
102492(find by Redflag QA, Filed by wg) | P3 | New | Outline paragraphs hidden, text paragraphs not hidden |
Invalid/Dupplicated issues closed by RedFlag QA people
86832
|
Error with exponent in formula |
85362
|
Calc: Default Formatting ruins dates |
83317
|
Spreadsheet: long copy and cut |
84426
|
Make filetype detection independent from file suffix |
84777
|
OO enter in loop with copy and paste |
84874
|
Data filters imported from Excel not properly editable |
84930
|
calc crashed with output log. |
85004
|
Formatting lost when using Search&Replace |
85187
|
Wrong option gets disabled in paste special, shift cells |
85322
|
Inserting cols mis-updates range arg of functions |
85498
|
Copy/paste is irritatingly slow in calc & base |
86133
|
No warning when exporting un-translatable function |
86863
|
Vlookup not included added data |
86869
|
Crash when ctrl-a ctrl-v pasting into a Spreadsheet |
87178
|
link to external data does not work for cgi text data |
97589
|
Serious efficience problem when fill the whole sheet, lead to block |
Release approval
OpenOffice.org 2.4 zh-CN and zh-TW
OpenOffice.org 3.0 zh-CN and zh-TW
OpenOffice.org 3.1 zh-CN and zh-TW
Fixed issues(Filed by Redflag QA people) per milestone
OOo2.4
- 4 issues fixed, one of them is P2 issue.
84412 | P3 | All | insert note->display note->copy/past->save->reopen->note dis |
84510 | P2 | All | Crash when clicking "AutoWidth" in "forbidden" case on colum |
85403 | P3 | All | Numbering with circled-digit, 11-20 can't display in Chinese |
85456 | P3 | All | Slot/control unknown :"WaitSlot" |
OOo3.0
- 10 issues are fixed in this milestone. one of them is P2 issue.
83485 | P3 | All | Translate issue in Asian layout in option dialog |
85213 | P3 | All | regular expression help translation error |
85217 | P3 | All | [zh_CN] Translation error in Word Count dialog |
85219 | P3 | All | [Zh_CN] translation error in Standard Filter dialog |
87629 | P3 | All | translation error in formula help (STDEVA, STDEVPA) |
80891 | P3 | PC | character in the forbidden list sometimes appears at the hom |
83481 | P3 | All | "Enclosing character" controls in "Asian layout" tab in cha |
83480 | P4 | All | Can not change focus with arrow key in "Asia typography" tab |
84110 | P3 | All | Fonts Replacement table issue. Tools->Options->OOo->Fonts |
83888 | P2 | All | Second time click hyperlink button,the presentation crash. |
OOo3.1
- 27 issues are fixed in this milestone. 17 of them are P2 issues
- 20 of them are submitted after OOo300m9 (OOo3.0).
97299 | P2 | All | Writer crashed when setting cursor to Note and clicking 'Und |
97380 | P2 | All | Writer crashes: Delete all Notes and Undo between Original d |
97295 | P2 | All | Writer crashed when editing the 'Frame' inserted via Placeho |
97346 | P2 | All | Impress crashes when draging Check box to the top of 'Tab O |
97386 | P2 | All | OOo crashed: Close 'Styles and Formatting' dialog and later |
97190 | P2 | All | Impress crashes: Load blank template and double click this b |
97261 | P2 | PC | Delete content of one cell in table and cut the cell, OOo cr |
97296 | P2 | All | Impress crashed: Click Custom Animation pan after canceling |
97338 | P2 | All | Drawing and Impress crashes when rightclicking on thumbnail |
97413 | P2 | All | Drawing&Impress crashes: Insert a table and update color of |
97552 | P2 | All | Insert Object document with password as a link, input wrong |
92855 | P3 | All | [zh-TW]Inconsistent translation of "Function" and "Virable" |
93313 | P3 | All | [zh-TW]Translation error in chart |
99072 | P3 | All | Translation error in bullet and numbering |
99442 | P3 | All | unsuitable translation in search and replace dialog |
92682 | P3 | All | Inconsistent translation in Column tab in Page dialog |
92853 | P3 | All | [zh-CN]menu item Inconsistent with help content |
91486 | P2 | All | OOo Crashes when set Table property |
92541 | P3 | All | Line height too small to display characters in View Design w |
92514 | P3 | All | Date format error. |
96822 | P2 | PC | Closing "business card" dialog when called from hyperlink di |
97388 | P3 | Unknown | Crash while set the "Max. base text size" to 0 in "Text Grid |
97347 | P2 | Unknown | Insert a table, edit it, undo and insert again, OOo crashes |
97478 | P2 | Unknown | Crash when "Increase Spacing" on demoted text |
97634 | P2 | Unknown | Impress Crash: when Find&Replace dialogbox show, switch view |
98386 | P2 | PC | modify the select region in ImageMap crash OOo |
97628 | P3 | Unknown | All of Custom Animation have no effect in Impress |
Search Toolbar
Specs
http://wiki.services.openoffice.org/wiki/Specification_search_toolbar
TestCases specification
Waiting
Q&A
- Search Text Field
Amy2008:
For Search toolbar specs, I have a question. In the following label:2. Search Text Field http://wiki.services.openoffice.org/wiki/Specification_search_toolbar#1._.22Find.22_Label I find no hint about select one or more strings in the document, then launch the Search toobar, What will show in the Search Text Field - Blank space string, previous search strings or the strings selected in the document? It's not clearly.
Stefan Baltzer:
Thank you for pointing at this. A good point! Looking at the current F&R dialog: - A multi-selection brings "no string" on first dialog call. - A selected word gets into the search text field. - After that, (on the next dialog call), a multi-string selection brings "no string", so the last search string is shown.
So the "dynamic" behavior as well as the depency on current selection needs specification here.
Contents of selection: What if... - An object (or text within an object) is selected (Graphic, OLE object, Writer text frame, Draw text box)
What about A multi-selection Nothing selected "A lot of text" selected
Plus First-time or second time use. What if search bar is closed and reopened (flush memory or keep it).
Sorry, but digging into such details is QAing a spec. :-)
- A lot of text selected
Amy2008:
if the muti-strings are continuous, I think the search text field should be the muti-strings. what do you think?
Stefan Baltzer:
I checked the "A lot of text selected" thing in the old dialog. When the current selection of text goes beyond a paragraph break, it is regarded a multi-selection => no string passed on to text field => the old search string stays. Same when the text is too long. A paragraph in Writer is limited to 65535 characters. This is also the limit for a long string to be passed to the F&R dialog. If the selection is longer than 64k characters, nothing goes to the search text field.
Automation
Q & A
Framework
- Send document as E-mail by foxmail which is the default e-mail client
Amy2008:
How can I send document as E-mail by foxmail which is the default e-mail client?
File - send - Document as E-mail,
dialog 1
no default e-mail client ...... Pls run Microsoft Office Outlook as default e-mail client
dialog2
OOo can't find a working e-mail configuration ......
Related links http://www.oooforum.org/forum/viewtopic.phtml?t=46349 http://www.openoffice.org/issues/show_bug.cgi?id=64151 http://kb.mozillazine.org/Default_mail_client#Windows http://en.wikipedia.org/wiki/Messaging_Application_Programming_Interface#Service_provider_interface
- How to set an user-defined template as the default one?
Amy2008:
I don't know how to set a user-defined template as the default one. If someone know it clearly, please tell me as soon as quickly. Appreciating your kindness. I created a template in calc named test.ots, then saved test.ots as the default template to be used. My question: One, when I open a *.txt (tab-delimited) or *.csv file with Calc, which template would be used, the old template or test.ots (namely, user-defined template)? Another, when I open a new file (.ots) it uses the template I created or not?
Cor Nouws:
limeiying wrote (7-8-2008 9:25) > I don't know how to set a user-defined template as the default one. > If someone know it clearly, please tell me as soon as quickly. Appreciating your kindness. Choose File>Template>Organize In the left list, find and select your template Now click Commands>Set as default template. > I created a template in calc named test.ots, then saved test.ots as the default template to be used. > My question: > One, when I open a *.txt (tab-delimited) or *.csv file with Calc, which template would be used,the old template or test.ots (namely, user-defined template)? You may want to try that yourself? > Another, when I open a new file (.ots) it uses the template I created or not? Definitely your template.
Spreadsheet
- Open shared document, some buttons on Drawing bar are active, the other deactive
Amy2008:
When creating a new Calc document, save it in shared document mode, pls have a look at the Drawing bar, find: some buttons are deactive, like Fontwork Gallery and From file. But the other buttons on the bar are active. Q1, I have no idea: which button should be active? If CTRL + Click Rectangle, can insert a rectangle as backgroud in the middle of the sheet, save the shared document, reload the shared document. find: the inserted rectangle disappeared. I don't know it is a normal action or bug.
Oliver:
Waiting for the answer
- How to select drawing or "movie and sound" object inSpreadsheet
Amy2008:
Several days before, I have asked for help from Stefan about "movie and sound" or drawing object which can be set as background and selected via "Ctrl+click the object" in Writer. But now, I have another problem, How to select drawing or "movie and sound" object in Spreadsheet? I try to use "Ctrl + click the object", but it doesn't work. I have checked issue 89920, there is no hint about how to do it in Spreadsheet.
Cor Nouws:
I know this can be done by the navigator. I do not know, if it is good that there is no way to do it directly in the document ;-)
- DataPilot
Amy2008:
About DataPilot, I am puzzled. There are several questions which I want to ask for your help. TIA Firstly, Data - DataPilot - Start - External Source/Interface on Select source dialog is deinactive. so, what can I do to make External Source/Interface do on Select source dialog deinactive? Should I install third part drivers or sth. else? Marek Brezina had asked the similiar question and subject is "[users] OLAP and external data", and CPH had answered his question as follows: On Monday 08 March 2004 08:16, wrote: > Hello, > I tried to look for this in archives and didnt find (or very old > themes), so my question is. > How can I connect DataPilot to OLAP server (or cube)? > Is this feature already implemented? On Wednesday 04 February 2004 19:14, Niklas Nebel wrote: > G. Roderick Singleton wrote: > > It will be up to the user to determine whether or not he can apply this > > technology vi OOo. In other words, OOo is NOT a OLAP tool but may be > > able to be configured to support some of what is needed. > > The "External source/interface" option in the DataPilot source dialog > allows to access external implementations of the > com.sun.star.sheet.DataPilotSource service (described in the Developer's > Guide) which provides the results shown in a DataPilot table. This is > meant to allow connecting to OLAP servers, but I haven't yet seen any > real implementation of it. After that, I still don't understand how to do to make it active. Secondly,Data - DataPilot - Start - Data source registered in OpenOffice.org - OK to open "Select Source" dialog. Would you like telling me the difference between sql and sql[native]? Thirdly,Data - DataPilot - Start - Data source registered in OpenOffice.org - OKto open "Select Source" dialog - biblio as Data source - OK - select "Type" as Page/Column/Row fields - double_click the "Type" item to open Data Field dialog, then clickoptions button to open Data Field Options, have a look at this dialogso, what can I do to make Hierarchy do on Data Field Options dialog deinactive? What's the best is to give us an example, thank you.
Stefan Weigel:
This might be related:
http://de.openoffice.org/issues/show_bug.cgi?id=89952.
- AutoFilter in Spreadsheet
Amy2008:
About AutoFilter, in sheet1, if I do autofilter and select some type result, then do autofilter in sheet2, then find that autofilter in sheet1 disappears.
Oliver:
It is possible to add several autofilters, but each autofilter needs its own named datarange. The easiest way to create it is to select the range and then use the Data - Define Range dialog and give the range a name.The technical background is that if the range for the autofilter has no name it will get an internal one automatically. If you create a second autofilter the first one will be overwritten.
- Rename one protected sheet
Amy2008:
Can users rename a sheet which has been protected? In Help file, it says "To protect the cells from being changed / viewed / printed according to your settings in the Format - Cells dialog, choose Tools - Protect Document - Sheet." So, I think, the protected sheet can be renamed by users.
Kirill S. Palagin:
Alt-click sheet name.Also vote for http://qa.openoffice.org/issues/show_bug.cgi?id=27126
- Create Names doesn't work properly for 'rho'
Amy2008:
In OOo community, there is a bug http://qa.openoffice.org/issues show_bug.cgi?id=87171. I can reproduce it, but don't know it is a bug or some special operations to 'rho'. So, Would you like telling me what it is?
Joost Andrae,Oliver Craemer,Daniel Rentz:
if you define a named range (/insert/names/define) then you can calculate with it's content. Example:create two cells containing the value 1 define a named range called "barfoo" based on these two cells enter =sum(barfoo) somewhere within the document --Joost But the fact that there is a leading underscore in the names dialog after creating the name "rho" is strange. Daniel is investigating this. --Oliver Craemer While creating the named ranges using the Names->Create function, the names from the cells are checked against ambiguities, e.g. that they are not a valid cell address such as "A1" or "R1C1". The name "rho" is wrongly recognized as such a cell address. I have forwarded the issue to Eike for further investigation. --Daniel Rentz
- Events button inactive in Spreadsheet, but active in Writer
Amy2008:
Open the Hyperlink dialog -> Internet -> Further Settings -> find the Events button is inactive in Spreadsheet but active in Writer.
Answer:
Issue 101262
- What's the "soft formatted"?
Amy2008:
When checking issue 99904,http://qa.openoffice.org/issues/show_bug.cgi?id=99904 I occured the key word "soft formatted", then I don't know what the meaning is in this issue, so pls tell me the meanings of this key word, or tell me how I can do to make soft formatted, if you know it clearly.
Joost Andrae, Oliver Brinzing, Bernd Eilers:
The term soft-formatting is used when you work with styles in contrary to hard-formatting where you just select eg. the "bold"-icon from the toolbar for a piece text.
For example if in writer the users selects a portion of text with the mouse and than use the toolbar icon for making that text bold and than selects a font from the font listbox in the toolbar thats hard formatting.
On the other hand the user may use the "Styles and Formatting" Icon in the toolbar to define a Style named "MyFancyBoldStyle" and use that to format some paragraph. That´s soft-formatting. Soft-formatting is available in writer, calc, draw and impresss. The same concept to what I just said about paragraphs in writer does apply to graphical elements in draw or impress or on cells in calc. The following links might introduce you to the concept of soft-formatting: http://wiki.services.openoffice.org/wiki/Writer_Guide:_Introduction_to_Styles http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Writer_Guide/Working_with_Styles http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Draw_Guide/Using_styles http://www.brainstorminc.com/openoffice.org-tips/tip-using-openoffice.org-styles.html http://www.taming-openoffice-org.com/newsite/?page_id=78 http://openoffice.blogs.com/openoffice/2005/12/all_about_style.html
- Space replaces tab-delimited when pasting a single line of tab-delimited text from notepad
Amy2008:
What I did: First, Create a new notepad file, then enter some characters like "test1 test2 test3 test4" which is divided by tab-delimited. Then copy these characters into the clipboard. Second, Create a new Calc file, select a cell at will, double-click and enter the cell, then paste the content in the clipboard to the this cell. Click any another cell at will. Found, Spaces replaces tab-delimited when pasting a single line of tab-delimited text from notepad My question: Why do Spaces replace tab-delimited when pasting a single line of tab-delimited text from notepad?
Alex Fisher:
Because notepad replaces tabs with a pre-determined number (usually 5) of spaces. It (notepad) is a very simple text editor, and it's files are plain ASCII. It (notepad) does not store tabs as tabs. If you tried doing the same using commas or semi-colons as delimiters, it will probably work properly (Not really sure, as I don't use Windows). Possible simply using a single space between text should work OK as well (the space becomes the delimiter)
- About Chane case: half-width and full-width
Amy2008:
I am in a puzzle about Chane case. Would you like telling me the part that the half-width and full-width play in Clac? In addition, can you tell me the difference between half-width and DBC case, full-width and SBC case?
No Answer
- About manual line break (issue 13870)
Amy2008:
Hi Oliver and cloph, I am in a puzzle about manual line break mentioned in issue 13870 (http://qa.openoffice.org/issues /show_bug.cgi?id=13870). But I don't know why this issue has been set as "won't fix" One: when the Text is entered to a cell directly (not via the "formula bar") e.g. aaa(Ctrl+Enter)bbb(Ctrl+Enter)ccc; copy cell & paste to a new cell (Ctrl + c, Ctrl + v) -------correctly pastes. select the input cell again & copy input line from formula bar, paste into new cell -------incorrectly pastes, "aaa" into new cell, "bbb" into next cell and "ccc" into next cell. Another: Input some characters into the formula bar, Ctrl + Enter to make a manual line break for the cell, but it doesn't work. Namely, can't input manual line break into the formula. In my opinion, inputting some special charaters into the formula bar is necessary.
Answer:
2008/8/13 limeiying <limeiying@redoffice.com.cn>: > I am in a puzzle about manual line break mentioned in issue 13870 (http://qa.openoffice.org/issues /show_bug.cgi?id=13870). > But I don't know why this issue has been set as "won't fix" It has been marked as won't fix because there is no intention to change the current behaviour. > One: > when the Text is entered to a cell directly (not via the "formula bar") e.g. aaa(Ctrl+Enter)bbb(Ctrl+Enter)ccc; > copy cell & paste to a new cell (Ctrl + c, Ctrl + v) > -------correctly pastes. Yes, you paste the contents as is that way. > select the input cell again & copy input line from formula bar, paste into new cell > -------incorrectly pastes, "aaa" into new cell, "bbb" into next cell and "ccc" into next cell. This is consistent with the fact that you cannot enter manual linebreaks using the formula-bar, but only when editing the cell directly. > Another: > Input some characters into the formula bar, Ctrl + Enter to make a manual line break for the cell, but it doesn't work. Namely, > can't input manual line break into the formula. Yes. Exactly. You cannot enter it in the formula bar, only in the direct editing. > In my opinion, inputting some special charaters into the formula bar is necessary. Well, good that opinions can differ :-) There are other issues already to allow insertion of newlines with formulas or character codes. But I'm not in product planning anyway, I cannot tell other people to work on a fix or something. I think if you want to work on a patch yourself/in your team, it would be best to mail either the user-experience list and/or the spreadsheet list to get a more detailed answer on whether the fix will be accepted and if not, why not. Wontfix in general only means that the person the issue is assigned to will not do anything regarding that issue, but if there is a patch the fix will not be rejected (there are exceptions however, so better check with the corresponding sub-project before spending unnecessary work)
- What's the analysis plug-in?
Amy2008:
For confirming issue 92177 in QAtracker, ODDFPRICE, ODDFYIELD, ODDLPRICE and ODDLYIELD function can't work fine unless there exists analysis plug-in in our OS. So, I wonder what is the analysis plug-in and how I can get it.
No Answer:
- Data Range
Amy2008:
I have five questions about Data Range. These questions has puzzled me a few days. Q1: About Refresh Range (a) Data->Define Range (b) Sort the Range and copy the sort results to other cells (c) Alert one or more data in the Range (d) Find that Refresh Range is activated. (e) Data->Refresh Range, resort the sort results. Then, I want to ask a question: Besides this function, is there a role that Refresh Range can play in Sreadsheets. Q2: Insert or delete cells (Data ->Define Range-> Select an existing Range-> More^ options) (a) Data->Define Range, input an inexistent range name (b) Sort the Range and copy the sort results to other cells (c) Click more to unfold options card (d) Two different operations Make sure “Insert or delete cells” Unchecked , Click “ok” Put a check mark on “Insert or delete cells”, Click “ok” (e) Insert a row in the end of the Range and input some characters in these cells OR Delete any row in the Range (f) Data->Refresh Range, resort the sort results. Find: Whatever which operation carries out in (c) , there is the same result. So, please explain the function of checked and unchecked “Insert or delete cells” in detail if you have encountered this deal. Q3: Keep formatting (Data ->Define Range-> Select an existing Range-> More^ options) The same as Q2, please explain the function of checked and unchecked “Insert or delete cells” in detail if you have encountered this deal. Q4: Don't save imported data (Data ->Define Range-> Select an existing Range-> More^ options) The same as Q2, please explain the function of checked and unchecked “Insert or delete cells” in detail if you have encountered this deal. Q5: Source (Data ->Define Range-> Select an existing Range-> More^ options) “Displays information about the current database source and any existing operators.” This is the help. But I don't know the meaning of “ the current database source” and ”existing operators” clearly. Who can tell me? ^_^ For Question 2 3 4, if you can attach some files to show the detail for me, I really appreciate it.
Oliver Craemer
Q1:It refreshes all settings that can be stored at a database range: - Sorting settings - Filter settings (standard filter, auto filter, special filter) - Subtotal settings - External database settings ("Refresh Range" re-imports data from an external database). The easiest way to create a DB range linked to a database: Open "View -> Data Sources" (or press F4), in the treelist open Bibliography->Tables, drag&drop the table "biblio" into the sheet. Now you have a new DB range "Import1". Q2:This option is of interest if the DB range is linked to an external database. If checked, and someone adds or deletes records in the database, and then refreshes the Calc DB range, Calc will move cells *below* the DB range up or down. if someone adds or deletes columns in the database, Calc will move cells *right of* the DB range to the left or right. If not checked, the cells below/right of the DB range do not move and may be overwritten if the external database grows. Q3:Related to external databases only: If checked and the DB range is refreshed, the formatting of the header row will not change, and the formatting of the first data row will be copied to all other data rows. To try out: set some formatting to some cells in the first and second row of the DB range, then refresh it. Q4:Also only for external databases. If checked, the imported data is not saved with the Calc document, but just the link to the database. If not checked, the imported data is saved and will still be available, if the external database is not present (anymore). But the file size may grow especially if you link to a very big database. Q5:Source: Shows the link to the current external database. Operations: Shows which operations have been defined for this DB range and will be executed when you select "Data -> Refresh Range". For example sorting, filtering, or subtotals.
- limit to the size of paste content in Spreadsheet
Amy2008:
I encountered a problem when I copy some characters in sheet1 and paste it to sheet2. There are the steps as follows: Create a new calc document; In sheet1,Input some characters in some cells,Copy theses characters (CTRL+C); Switch to sheet2, Select entire sheet(CTRL+A), then paste the characters from sheet1(CTRL+V); Result: OOo crashed and Inner memory leaked out. Suggestion:The size of paste content in Spreadsheet should be limited
Clytie Siddall:
Issue 59453
Writer
- Autocaption in writer
Amy2008:
Tools - Options - OOo writer - AutoCaption - check OOo spreadsheet - position: above - OK In writer, Insert - Object - OLE Object - OOo spreadsheet - OK Find illustration X is inserted below the OOo spreadsheet object.
Waiting for your answer:
- Can't alter "movie and sound" object
Amy2008:
If insert a "movie and sound" object in Writer, or insert an drawing by F6 until cusor set on the drawing bar, then -> (Right) to Rectangle or ellipse and CRTL+ENTER in Writer ^1 try to move the object, and change the position of the object, Can't do that. ^2 click other area except the inserted object, try to select the inserted object, can't select it. ^1 and ^2, can be done successfully in Spreadsheet, Drawing and Impress.
Stefan Baltzer:
This is a known issue:http://qa.openoffice.org/issues/show_bug.cgi?id=89920 "Objects (Fontwork, Movie and Sound) only selectable via Ctrl-Click, because it's inserted "in background" by default". See details in issue description.
- writer边框不停闪动
kongnan:
http://user.services.openoffice.org/zh/forum/viewtopic.php?f=23&t=39 由 isabella0029 于 2009-04-19 00:18 使用writer时,无论是点击保存,还是间隔固定时间后的自动保存,上方的两排工具栏和页面的黑色细边框都会不停地闪动,而且无法停止。 目前使用的是3.0.0正式版,但是此问题在3.1上依然存在。 因为是15日重装的系统xp sp3,当时的3.1使用一切正常,从18日才忽然出现此问题,卸载后改装3.0.0,但是问题未能解决。
amy2008:
http://www.openoffice.org/issues/show_bug.cgi?id=39014
- Paste a table with DDE link
zhulihua:
currently I have no web site to upload a file. But this is a good suggestion. I'll apply one for it. So, I provide a detailed description: 1. Create a new writer document; 2. Insert a table in it; 3. Select the table; 4. Ctrl+C; 5. Click out of the table; 6. Click the right side of the Paste and choose "DDE Link"; I expect there is a table pasted at the caret position. But there is only a something like a frame there. And type in the table, nothing happened in the "frame".
Peter Junge:
I tried this with an OOo 2.3 on Ubuntu Linux. I can confirm your observation. No problem while I use English localization. If I switch to Chinese, the same office installation will reproduce the described behavior. The case seems to be quite clear, the writer tables have localized (Chinese is this case) names; press 'F5' to verify in the OOo navigator. When pasting the table as DDE link it is bound to fail, because DDE is only specified to be used with ASCII encodings. Great finding.
zhulihua:
So, is there any solution for this issue? If there is no way to achieve, maybe we should disable this item in paste list? And another question: If we didn't click out side of the table in the steps. we click in a table cell, then paste DDE link. Only the contents of the table are pasted and we modify the original text, the target text remain unchanged. Why this?
Peter Junge:
> So, is there any solution for this issue? If there is no way to achieve, maybe we should disable this item in paste list? http://www.openoffice.org/issues/show_bug.cgi?id=86557 > And another question: > If we didn't click out side of the table in the steps. we click in a table cell, then paste DDE link. Only the > contents of the table are pasted and we modify the original text, the target text remain unchanged. Does your observation apply for an English, a Chinese or both versions? I'm not sure if I understand it. Please provide a step by step instruction again.
zhulihua:
I tested in a English version since this function can't achieve in Chinese localized table name. 1. Create a new writer document; 2. Insert a table in it; 3. Select the table; 4. Ctrl+C; 5. Click in one of the cells in the table; 6. Click the right side of the Paste button and choose "DDE Link" Only the contents of the table are pasted and we modify the original text, the target text remain unchanged. I think, if it works as normal, it would be a nested table. if the level of the nesting is not limited, maybe something would happen. But, no table is nested. just texts of the table in it. And I found the texts remain unchanged if we modify the original text.
Peter Junge:
I guess linking a table to a cell of itself would end up in a loop of events, probably ending in an OOo crash. Inserting the DDE link would modify the source table. The modification would be forwarded to the nested link. The nested table will be modified, which would also be an modification of the source table. Consequently, creating a DDE link within the source doesn't make any sense at all.
Drawing
Chart
Impress
Base
- Open two *.odb files when double-click the form ( After issue93450 )
Amy2008:
When checking issue93450, I find an odd problem.
- open the attached database document in issue93450 (please allow macro execution, since the bug is triggered by macro code) - double-click the contained form to open it => Open two *.odb files when double-click the contained form.
Frank.Schoenheit:
Cannot reproduce on WinXP, in OOO310.m8. The only thing which happens here is that the Basic IDE opens
and jumps to a location in the Basic script which is errornous.
Automation
- A question about issue 70775
Amy2008:
http://www.openoffice.org/issues/show_bug.cgi?id=70775 From this issue, I've got some information, but it's not enough. :0) Do it like this: 1. Copy the perl files under the \script\analyze to the Eventlog directory 2. Locate to the Eventlog directory 3. Run this codeline (perl make_summary.pl *.res) in dos command line window, the result is ' Invalid argument: *.res, stopped at make_summary.pl line 88.' 4. Run this codeline (perl make_summary.pl e_fileopen.res e_help.res) in dos command line window, the result is ' Filename Errors Warnings Warnings_during_initialization ================ ====== ======== ==================== e_fileopen.res 0 0 0 e_help.res 0 0 0 ============================================================= Total 2 files 0 0 0 ' Please pay attention to step3 and step4, result in step4 is right, but one in step3 is not. Maybe '*.res' can't work for get the res-file list, but I don't know another way to solve this problem. So, everyone, would you like giving me a hint?
Marc Neumann:
I don't know the scripts at all. May be it's the best to ask tora directly how to use the scripts.
andre.schnabel:
Hmm ... seems, as this is a windows problem. I always use cygwin on windows.With cygwin you have the power of most open soucecommand line tools also on windows. You can get cygwin from here: http://www.cygwin.com/ during install make sure, you enable Perl ;) When using cygwin, be aware that you cannot use drive letters. Cygwin maps windows drive letters to a virtual path structure. E.g. C: becomes /cygdrice/c .
- Where can I get the batch file to do required testing on Linux?
Amy2008:
I remember I have seen the batch file to do required testing on Windows, but I have no idea, where can I get the batch file to do required testing on Linux?
Helge.Delfs:
The CWS where Issue i93675 is being fixed is not yet integrated in so you will not find those scripts in path testautomation You can get them via CVS checkout from qa/qatesttool See CWS-Browse for details: http://qa.openoffice.org/source/browse/qa/qatesttool/script/
- Different model(writer and Spreadsheet), different Spelling UNO Id
Amy2008:
In AutoTest, I found a warning info about Spelling check In testautomation\spreadsheet\required\c_updt2.bas call c_upd_toolsmenu like this: --------- Tools Menu Part I (c_upd_toolsmenu.inc) --------- tToolsSpellcheck Warning: Spellchecking not possible ----------------------------------------------------------- UNO of Spelling is ".uno:SpellDialog" in Spreadsheet, but in Writer it is ".uno:SpellingAndGrammarDialog". In e_all.sid, there is ".uno:SpellingAndGrammarDialog". So, I guess ".UNO:SpellDialog" in Spreadsheet may be wrong, but I'm not sure about it. Please give me more info. :-D
Oliver Craemer:
This is a known problem and is handled by issue 92650. This issue is fixed in the OOO300 codeline (OOO3.0) but due to a merge conflict the cws greenstate30 was not integrated in the current codeline (DEV300). We are working on this problem and it will be fixed soon.
- [Automation]About isDebugVersion or isProduct
zhulihua:
I notice that some operations are different depend on if the OOo is a DebugVersion or not. There is a variable named "isDebugVersion", and I found another variable "isProduct". What's the conception of DebugVersion and ProductVersion? whether the equation below is always correct or not? isDebugVersion = NOT isProduct And What's the difference between the testing of DebugVersion and NonDebugVersion? What's the difference between the testing of isProduct Version and Non-isProduct Version?(If nessessary)
Oliver Craemer:
a debug version has some extra code for development which point to problems during runtime. The main difference for testing such a debug version is that there are error- and warning messageboxes. These messageboxes can be handled by testtool but will change the timing of some tests. Therefor we differentiate between "Product" and "DebudVersion" in some cases. Normally we only test "Product" versions with the testtool.
- [Automation]Timing problem when run scripts
zhulihua:
I'm running required scripts against OOo_m9 these days. I've found some timing issues, if I add a sleep instrction at proper position, the result will be Ok, or there will be some errors or warnings in the result. I'll attach a resultfile, w_updt.res. In this file, tEditFields, tInsertNote, tFormatWrapArea and tFormatPositionAndSizeLegend often have this timing issue. Not every testcase metioned will occur the problem every time, but often. the same problem often come out in some other scripts, such as EuroConverter. I consulted Helge about this. He told me this never happened in Sun. And he took time to run some testcases, no error happened. I ran the testcases against both English version and Chinese version under both English locale and Chinese locale of OS. The problem happened in all conditions. Did you have this kind of problem when you ran testcases?
Maho NAKATA:
We have two results done by Matuaki-san for 2.4.1. http://www.openoffice.org/issues/show_bug.cgi?id=90589 http://www.openoffice.org/nonav/issues/showattachment.cgi/54387/errorlog-rc2woJRE-WinXP.zip http://www.openoffice.org/nonav/issues/showattachment.cgi/54391/errorlog-rc2wJRE-WinXP.zip
Sorry I don't have other stuffs here at RIKEN.
[BTW: my machine had been too busy to providing FreeBSD ports. Fortunately, recently I was funded by OOo and purchased a machine for that purpose. So I can test a bit more soon.] I'm using FreeBSD I fogot that and I can run http://qa.openoffice.org/qatesttool/src680m226/VCLTestTool_Linux_src680m226.tar.gz via Linux compatibility feature :)
No errors by Matuaki's output. Please refer his results. http://www.openoffice.org/issues/show_bug.cgi?id=90589 (2.4.1) http://www.openoffice.org/issues/show_bug.cgi?id=81804 (2.3.0) see for example: http://www.openoffice.org/nonav/issues/showattachment.cgi/48427/summary.txt http://www.openoffice.org/issues/show_bug.cgi?id=77823 (2.2.0) http://www.openoffice.org/nonav/issues/showattachment.cgi/45476/errorlog_WinXP_wJRE.zip (no errors)
zhulihua:
I tested on a native display. I have to say, I gave you a bad example last time. Further research shows that is not a timing issue. The issue of tInsertNote has turned out to be a defect of script. I'll explain to you. I attach another result file to you. This one is a timing issue which I sent to Joerg just now. [quote] I'll send you the f_wizards.res, in which tUpdtWizardEuroconverter have the problem. The problem will come up, until you add a sleep instruction before "Waehrungen.Select(1) 'Setting to first entry of listbox " [/quote] BTW, How to perform a remote testing? I'd like to know. :-) Error in tInsertNote: 1. Sorry I told you the wrong script name. It's ma_updt.bas, not w_updt.bas 2. The error occurs after you deleted the userprofile(or new installed). Reason: When you first run the testcase after delete the userprofile, at "instruction No.1", Navigator of MasterDoc came out. "NavigatorGlobalDoc" are Kontexted, and Liste is visible. So the navigator are switched to normal navigator. "Instruction No.3" are run, so this normal navigator get Kontexted. when the script goes to the "Instruction No.4", because there is NO Liste in this navigator, so error occured. When you run the testcase again, at "Instruction No.1", normal navigator will come up, because we switched to normal navigator last time. But this instruction Kontext MasterDoc navigator (NavigatorGlobalDoc), So Liste is not visible. So "Instruction No.3" will not run. And so, MasterDoc navigator is still Kontexted. So at "Instruction No.4", Liste is exist but not visible, so the "switch button" will not be clicked. But this time the result will be OK. So, in NavigatorGlobalDoc, there is Liste. And in NavigatorWriter, there is Auswahlliste. But we found, in NavigatorGlobalDoc, there is Auswahlliste too. That why there is no Error with Auswahlliste at "Instruction No.6", Although "Instruction No.5" is not run when we run the testcase again. -------------------------------------------------------------------------------------------- testcase tInsertNote dim sNoteText as String PrintLog "- Insert / Note" Call hNewDocument printlog " Insert / Note" InsertNoteWriter Kontext "DocumentWriter" sNoteText = "Testnote inserted by testtool !" Call wTypeKeys (sNoteText) Call wNavigatorAuswahl( 11, 1 ) //Error occurs in this sub, I paste it below Kontext "NavigatorWriter" if Auswahlliste.Gettext <> sNoteText then warnlog ("Note was not inserted correctly (Focus problem?") end if printlog " Check if note exists" printlog " Close active document" Call hCloseDocument endcase sub wNavigatorAuswahl(Gruppe as integer, Eintrag as integer,optional LeaveFocus as boolean) dim j as integer, WelcherEintrag as integer Dim MinEntrys as integer If IsMissing(LeaveFocus) = True then LeaveFocus = False Select Case Ucase(gApplication) ... Case "MASTERDOC" Kontext "NavigatorGlobalDoc" if NavigatorGlobalDoc.NotExists then EditNavigator wait 500 Kontext "NavigatorGlobalDoc" //Instruction No.1 if Liste.IsVisible then //Instruction No.2 Kontext "GlobaldokumentToolbox" Umschalten.Click Kontext "NavigatorWriter" //Instruction No.3 end if MinEntrys = 11 Case Else ' for all others!!!! Warnlog "Not supported application!" exit sub end select Sleep 2 Select Case Ucase(gApplication) ... Case "MASTERDOC" if Liste.IsVisible = True then //Instruction No.4 Umschalten.Click //Instruction No.5 end if if Auswahlliste.GetItemCount >MinEntrys then //Instruction No.6 For j= 1 to 12 Auswahlliste.Select j Auswahlliste.TypeKeys "-" next j end if Auswahlliste.Select Gruppe if Eintrag >0 then WelcherEintrag = Gruppe + Eintrag Auswahlliste.TypeKeys "+" Auswahlliste.Select WelcherEintrag Auswahlliste.TypeKeys "<Return>" end if end select ... end sub
Helge Delfs:
sorry for answering late....
> BTW, How to perform a remote testing? I'd like to know. :-) Remote testing can be done via VNC connected to a remote machine or Remote-Desktop-Connection (using windows) > Error in tInsertNote:
It is reproducable here with m9 as well. Should be checked in current version of testscripts on DEV300-Branch If it also occurs in current version of this branch best way would be to file an issue fredrik@openoffice.org to have it fixed. Of course if you like you could provide a fix too :-)
Fredrik has some additional issue to merge w_updt.bas, ma_updt.bas and ww_updt.bas to 1 test only because the differences in those tests can easily be found out and workarounded. See #i95541 for details on this.
- [Automation]Remote testing with testtool
zhulihua:
I found in the setting dialog of testtool, there is a Misc tab. It seems that we can remote testing via proper setting in the tab. But I can't find the descriptions from the testtool manual. I wonder how to set this tab and how it used? Is there anyone can help me?
Oliver Craemer:
you can't find a description for these settings because there is none ;-) . But maybe I can give you a little light on these settings: 'Host' does only work with "localhost" because other settings are not supported by our testscripts.
Other
- can't setup dev300_m23 or dev300_m24
Amy2008:
Set up OOo dev300_m23 or dev300_m24 on WinXP, there is an error, "Error 1304. Error writing to file cli_oootypes.dll. Verify that you have access to that directory." when copying new files.
Olaf Felka:
[Issue 91700], Installation fails if .NET2.0 is not installed.