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 2008On 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."
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.
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.
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.
90607
You haven't commented on this issue. Did you find it difficult to understand or reproduce?
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.
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.ods2 Insert -> Picture -> From File This will insert a .pbm image into pbm_test.ods3 CTRL+S or press Save button to save pbm_test.odsResult: 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.
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.
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. :)
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."
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).
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.
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)
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
PGP.sig
Description: This is a digitally signed message part
