Hi Clytie ^_^ Thank you for your detailed explaination and encouragement.
On 2008-07-09, at 21:23:55, Clytie Siddall wrote: >> >Hello again Mei Ying :) > >On 07/07/2008, at 11:47 AM, limeiying wrote: >>> >> Thanks for reminding me. (='.'=) ^_^ > >I like your smilies, too. :) >> >> Issue numbers are as follows. >> 90806 >> >> Opened: Tue Jun 17 14:12:00 +0000 2008 >> On windows XP, I want to assign scalc.exe as the default application >> to open xslx files, as I just did for .docx & .pptx files, with >> swriter.exe & simpress.exe. When I right click a xlsx file, 'open >> with' and browse to my program files to 'scalc.exe' and confirm, the >> scals doesn't add to the application list, as if windows didn't >> recognize it as en executable. All others OO apps (sbase, sdraw, >> simpress, smath & swriter) can be added to the apps list, but not >> scalc. >> ------- Additional comments from amy2008 Mon Jun 30 09:05:31 +0000 >> 2008 ------- >> >> I can't reproduce this bug in dev300_m20 and dev300_m21. > >This is a good comment: brief and to the point. You also need to add >your operating system: the original user has specified Windows XP, but >we can't assume you're using that. Using Windows XP as an example: > >"WinXP: can't reproduce this bug in dev300_m20 or dev300_m21." > >or > >"I can't reproduce this bug in dev300_m20 or dev300_m21 on Windows XP." > >or even: > >"WinXP, DEV300_m20, DEV300_m21: can't reproduce this bug." > fixed. >> >> 90771 > >> cannot auto update when saving shared worksheet by multiple user >> using calc 3.0beta simultaneously. unlike ms excel when shared >> worksheet it has auto update when saving worksheet by multiple user. >> ------- Additional comments from amy2008 Mon Jun 30 08:49:32 +0000 >> 2008 ------- >> >> to usher8701: Would you like depictting it step by step to reproduce >> this bug? > >That was a good response to this issue: the user has not described the >problem clearly, and hasn't supplied the system and build details. > >"usher8701: please describe, step-by-step, how we can reproduce this >bug. When reporting an issue, please always include your operating >system and version, and the OpenOffice.org build/version you are using." > >> ------- Additional comments from amy2008 Wed Jul 9 07:35:01 +0000 >> 2008 ------- >> >> Maybe, this issue should be marked as a duplicate of issue 8811. > >It's a good thing that you compared this issue with similar issues. >It's a bit difficult to tell, because the user has been so unclear >about his or her problem, but if his/her problem is not being able to >_auto-update_ while using a shared worksheet, I think that is a >separate problem from issue 8811. Issue 8811 was about _creating_ the >shared worksheet feature, and that has been achieved in OpenOffice.org >3.0. Auto-update may well be an extension of this feature. You could >say: > >"This issue appears to be related to issue 8811. Spreadsheet devs, is >auto-updating shared worksheets a current feature? If so, then this >can be a separate issue. If not, then it should be a feature request." > >Much of our task in confirming issues is guiding users to report >issues correctly. They often forget to tell us about their system or >OpenOffice.org version, they often don't describe things clearly, and >they may not understand that the Issue Tracker has separate settings >for a "bug" and a "feature request" or "enhancement". You can also >refer them to the documentation. >> "usher8701: please describe, step-by-step, how we can reproduce this bug. When reporting an issue, please always include your operating system and version, and the OpenOffice.org build/version you are using." >> 90740 > >> The Box is a 32-bit Win XP, SP2 installation. The OO code at issue >> is OOo-Dev_DEV300_m17_Win32Intel_install_en-US. If you copy an >> entire worksheet in Excel and attempt to paste it to Calc, the paste >> never terminates. Cutting and pasting a few cells between Excel & >> Calc works fine (but really slowly). In addition, it's very >> difficult to kill the Calc job once it stops responding. I could >> only kill it once a process manager screen decided to come up. Based >> on the fact that processor usage was pegged at 100% and the fact >> that the process manager windows took about 4-5 minutes to actually >> appear, I'd say that there is some sort of very tight loop that the >> program is stuck in. Oddly, I was able to use other applications >> during this period where the process manager would not appear. >> ------- Additional comments from amy2008 Thu Jul 3 02:25:12 +0000 >> 2008 ------- >> >> I can't reproduce it in DEV300_m21_en WinXP. > >Excellent. It certainly helps that the user reported the problem >clearly. However, there is something he didn't tell us: the size of >the original Excel worksheet. Slow processing, hangs and/or crashes >can be related to the size of the job, so we should ask about this. >You could add: > >"jdn2916, please check in the latest build. If the problem persists, >how large was the original Excel worksheet? Is the problem related to >size at all?" > >You could also say how large the Excel worksheet was, which you used >to test the issue. >> I added: "jdn2916, WinXP, BEB300_m2. Reroducing process: 1. Copy an entire worksheet in Excel 2. Make sure you didn't do Ctrl+A in Calc, then paste it to Calc In this way, I can't reproduce this issue in BEB300_m2 on WinXP. But doing Ctrl+A in Calc before pasting it to Calc, OOo doesn't response. If so, this issue is likely to be the issue 59453. " You added: "Although this issue is a duplicate of issue 59453, the information here adds to that issue, so I will transfer it. jdn2916, please follow issue 59453 and add your experience to it. *** This issue has been marked as a duplicate of 59453 *** " In this way, I should just pay attention to issue 59453. Also, I add myself to the CC list of issue 59453. >> 90658 > >> A list of -1 #N/A A 0 1 generates the following filter criteria in >> auto-filter and standard filter -1 A 1 Zero is missing and the empty >> entry hides all rows. >> ------- Additional comments from villeroy Thu Jun 12 12:00:05 +0000 >> 2008 ------- >> >> Created an attachment (id=54428) A list of values and filter criteria >> ------- Additional comments from amy2008 Wed Jul 9 08:20:50 +0000 >> 2008 ------- >> >> Maybe this issue should be marked as a duplication of issue 89816. > >Well done, finding the similar issue. Both issues, in fact, are >related to issue 90920: Calc's handling of null values is non- >standard, so if affects a number of situations. Possibly we need a >single issue to combine this information. > er added: "No, this issue is not related to issue 90920 nor issue 89816. This issue here is about a formula's error result confusing the list of available values in AutoFilter. Issue 90920 is about considering empty cells when searching for an empty string respectively the empty paragraph regular expression. Issue 89816 is about the automatic selection of the data area if none was selected." I'll confirm this issue again. >> 90607 > >You haven't commented on this issue. Did you find it difficult to >understand or reproduce? >> I added: "In BEB300_m2, on WinXP. I think I really understand your explaination. But I can't reproduce this by the following steps. 1. Open the file rel128.wk1 2. In sheet1, found #REF errors from A7 to A9, but A6 showed very well. 3. Insert a new sheet named sheet2 into rel128.wk1 4. In sheet2,from A1 to A5, input 1 2 3 4 5 in each cell From DX1 to EA1, input 1 2 3 4 in each cell then, cell A6 refers to DX1,cell A7 refers to DY1, cell A8 refers to DZ1,cell A9 refers to EA1. Result: #REF errors doesn't happen. So, I wonder if you can reproduce it in BEB300_m2 on WinXP with a new lotus *.wk1 file or not. " >> 90605 > >This turns out to be one of (at least) 7 duplicates of issue 35579. >It's probably not surprising that you didn't detect that, since issues >are often reported from different points of view. However, the problem >should be fixed in OpenOffice.org 3.x. Watch out for more duplicates >of this issue, since the absence of these basic filter conditions is >likely to annoy more users. >> Sorry Clytie, I will watch out for duplicates of ervery issue. I have added myself to the CC list of issue 35579. >> 90597 > >> when you add pbm, (portable bitmap image) to somewhere in sheet and >> press save button --> whole oo crashes. >> ------- Additional comments from amy2008 Thu Jul 3 05:38:20 +0000 >> 2008 ------- >> >> In DEV300_m21_en WinXP. There are some steps to reproduce this issue. >> 1 Create a new calc document named as pbm_test.ods >> 2 Insert -> Picture -> From File This will insert a .pbm image into >> pbm_test.ods >> 3 CTRL+S or press Save button to save pbm_test.ods >> Result: OOo works well, no crash happened. note: If my steps are >> different with yours, please comment. > >Good work. :) > >You could also ask the user which build s/he was using, and to check >this problem in the latest build. If the user is using WinXP, we can >mark this issue as Fixed, since it works in a later build. if not, the >info that it works on WinXP will help the developers. > >Also note that if you want to follow the progress of an issue, you >only need to add your OpenOffice.org username to the CC box. > Fixed. >> 90579 > >> I got error 504 using the SUMIF function. I used as criteria both a >> link to a cell, both a reference between "". The same file opened >> with MS Excel, works perfectly. I submit the file. Thanks. Sergio >> ------- Additional comments from starchill Tue Jun 10 18:39:13 +0000 >> 2008 ------- >> >> Created an attachment (id=54381) error 504 using the SUMIF function >> ------- Additional comments from amy2008 Thu Jul 3 06:26:43 +0000 >> 2008 ------- >> >> In DEV300_m21_en WinXP, I opened the attachment. The SUMIF function >> works very well too. > >"In DEV300_m21_en WinXP, the attachment opens and the SUMIF function >works correctly." > >That's good, but you probably also need to say if it worked using each >criterion: (1) link (2) quoted reference. >> WinXP, can't reproduce it in BEB300_m2. >> 90540 > >> 1. Create sample file1.odp by other application,which contains a >> Spreadsheet OLE in Presentation 3. Open the sample file1.odp using >> OpenOffice3.0beta 4. double click the Spreadsheet OLE and enter into >> Spreadsheet edit state 5. return to OLE display state from >> Spreadsheet edit state 6. the Spreadsheet OLE can not display >> correctly, only displays one cell 7. modify the XML file in the zip >> package /Object1/Settings.xml, add "ooo" namespace declaration and >> usage in the Settings.xml, repackage the .odp file as sample >> file2.odp 8. reopen the sample file2.odp using OpenOffice3.0beta 9. >> double-click the OLE object and return to OLD display state, all is >> OK. Defect: OpenOffice3.0beta interprets Spreadsheet OLE in >> Presentation dependent on the specific "ooo" namespace. >> ------- Additional comments from jiamingfei Tue Jun 10 04:31:41 >> +0000 2008 ------- >> >> Created an attachment (id=54350) sample file without "ooo" namespace >> ------- Additional comments from jiamingfei Tue Jun 10 04:32:52 >> +0000 2008 ------- >> >> Created an attachment (id=54351) sample file with "ooo" namespace >> ------- Additional comments from cl Tue Jun 10 10:55:31 +0000 2008 >> ------- >> >> this is a spreadsheet issue, changing owner >> ------- Additional comments from amy2008 Thu Jul 3 07:04:14 +0000 >> 2008 ------- >> >> Sure, This issue can be reproduced in DEV300_m21_en WinXP. > >"This issue can be reproduced in DEV300_m21_en WinXP." > >You don't need the "Sure". If you want to be more emphatic: > >"This issue can certainly be reproduced in DEV300_m21_en WinXP." > >"Sure" used in that way is a conversational style, not appropriate for >writing. > >Note how much easier it is to test an issue when the user has >described it clearly, with steps to reproduce it. :) >> I added: "Scenario: WinXP, BEB300_m2 Reproducing process: 1. Create reproducation1.odp file containing a Spreadsheet OLE in Presentation with RedOffice application 2. Open reproducation1.odp with BEB300_m2 3. Double click the Spreadsheet OLE and enter Spreadsheet edit state 4. Click and retrun to OLE display state from Spreadsheet edit state. Result: The Spreadsheet OLE can display very well So, Can't reproduce this issue in BEB300_m2 on WinXP. " >> 90476 > >> I have long found that when I need to print something from the >> computer screen, the easiest way to do it was to hit PrintScreen, >> then paste it into an Excel spreadsheet, then crop and resize it >> till I have what I want. I just tried the same thing using OOo Calc >> 3.0Beta, and discovered that it is much more difficult. Calc brings >> up a window with measurements you can change, and its own snapshot >> of the graphic that shows where you are moving the borders to. It >> works, but it is hard to get it just right. You cannot see it well, >> and must often invoke the tool, change the measurements, and quit >> the tool several times to get it just where you want it. PLEASE add >> a mouse tool that can be used directly on the image in the >> spreadsheet. The cropping icon could still bring up the window, and >> then a button in that window could close the window and replace it >> with the mouse tool. Thanks, Tim (WinXP Home SP2, AMD Duron 950 >> processor) PS: Why does hitting the apostrophe while I_m typing >> (like just then! I put a line where I tried to put the apostrophe.) >> bring up a QuickFind tool instead. That_s very frustrating! >> ------- Additional comments from amy2008 Thu Jul 3 07:25:22 +0000 >> 2008 ------- >> >> This issue exists. Mouse tools for editing images in Calc is >> necessary. > >This issue was reported as a Defect, but it's actually a request for >an enhancement. The apostrophe-input problem belongs to the user and >his or her input system. I doubt if it has anything to do with >OpenOffice.org. > >"Confirming this issue in DEV300_m21, WinXP. Mouse-editing tools for >editing images in Calc are useful and probably expected by users, >especially those switching from MS Office. I'm changing this issue to >Enhancement since it is not a Defect (a current function not working). > >timdeaton : Is your apostrophe input problem related to OpenOffice.org >at all?" >> ^_^ >> 90442 > >> - please open the attached spreadsheet - copy the content of cell A1 >> into clipboard - paste as plain text or HTML into writer: Spaces >> instead of line breaks are inserted. (Other formats (including RTF) >> are ok.) >> ------- Additional comments from norbert2 Fri Jun 6 13:31:42 +0000 >> 2008 ------- >> >> Created an attachment (id=54298) test.ods >> ------- Additional comments from amy2008 Thu Jul 3 08:32:34 +0000 >> 2008 ------- >> >> This issue can be reproduced in DEV300_m21_en WinXP. Paste as DDE >> link,there are two results with the same operation. (a) paste only a >> frame in the odt document (b) like pasting as plain text or HTML, >> line breaks replaced by spaces. > >Good work. > >"When you paste as a DDE link, there are two results for the same >operation: (a) only a frame is pasted into the .odt document, and (b) >when pasting as plain text or HTML, line breaks are replaced by spaces." >> Your descripation is so perfect. Learn more and make progress every day, I just do it. >> 90412 > >> I can reproduce it in DEV300_m21_en WinXP. > >Good. I've confirmed the issue. It's also related to issue 90191: it >seems that language settings are not persisting in some situations. >The issues should probably be combined into one issue, or a meta- >issue, to investigate the cause. >> >> 90308 > >> Trying to open corrupted xls file causes Calc to consumes 1,7 GB of >> memory on my machine. It is reproducible with the attached file. >> ------- Additional comments from lpiccilli Tue Jun 3 15:16:18 +0000 >> 2008 ------- >> >> Created an attachment (id=54211) Corrupted xls file >> ------- Additional comments from amy2008 Fri Jul 4 07:49:41 +0000 >> 2008 ------- >> >> I can reproduce it in DEV300_m21_en WinXP. > >It's useful to have that confirmed, but I would question if >OpenOffice.org should have to be able to open a corrupted file. >However, it should probably display an error dialogue, not hog the >system resources. >> ^_^ >> 90279 > >Although you have confirmed the issue in DEV300_m21, another user has >not detected it in a 3.0b build. I think we need to test in 3.0b2rc1 >(BEB300_m2). I added: "Installed 3.0b2rc1 (BEB300_m2) on WinXP. Now if you created a Spreadsheet document and saved it as test1.ods/test1.xls, closed test1.ods/test1.xls, then you could found that it showed up in the your recent documents list of the start menu. So, can't reproduce it in BEB300_m2 on WinXP." >> >> 90230 > >Confirmed. >> >> 90182 > >Confirmed. >> >> 90168 > >> When a new sheet is inserted as the last sheet in a spreadsheet >> containing other worksheets, and the user chooses to view the sheet >> in File>Page Preview, the previous sheet is displayed instead. The >> user must save, close then re-open the file, before the last >> inserted sheet can be viewed in Page Preview >> ------- Additional comments from amy2008 Fri Jul 4 09:15:09 +0000 >> 2008 ------- >> >> It isn't reproducible on DEV300_m21_en WinXP. > >Again, the user hasn't told us which system or OOo version s/he is >using, so we need to ask. We also need to ask him/her to test this >problem in the latest build. Many problems are fixed in later builds, >but users don't bother to check, or they don't bother to come back and >tell us. So we remind them. ;) >> >> 90167 > >This seems to be related to 90168, in that the Preview is not updating >to show current elements. Confirmed. >> >> 90163 > >Confirmed. I don't know if the inconsistency between click-selecting >and double-click selecting is important, but pasting first shouldn't >disable cursor movement. >> >> 90137 > >OK. We need the user to check the latest build. >> >> These bug had been confirmed and made comments on the issue. > >You did a good job. Just remember that you can request more >information from the user, and you can ask them to check if their >problem exists in the latest build. Thank you very much. I remember it. >> >>> >>> The longest journey begins with a single step. :) >> Surprisingly, smart Clytie, you are at home on Chinese culture. >> This is a famous phrase called "千里之行，始于足下". ^_^ > >孔夫子 ;) > >(Confucius) A small mistake, Lao tzu not confucius. Honestly, I thought that was confucius too. >>> >>> >> Make sure I have the latest OpenOffice.org build. > >Good: that's BEB300_m2 now, so you should update. > >>>> Good good study, day day up! >>> >>> "Day by day we learn and improve." >> >> This is another Chinese wisdom. It is said that this statement can be >> accepted in English speaking nations. I have no idea. ^_^ > >You can try sayings and see how people react. :) > ^_^ >from Clytie > >Vietnamese Free Software Translation Team >http://vnoss.net/dokuwiki/doku.php?id=projects:l10n ------------------------------------------------------------- Best regards! *********************************** Li meiying Beijing Redflag Chinese 2000 Software CO.,LTD Email:[EMAIL PROTECTED] Tel：51570010-6140 Fax：51570333 Code：100176 ************************************ 2008-07-11 12:59:39
