Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to report a BUG?
A few days ago, Dr Phil M posted what appears to be a BUG in the Excel 2007
conditional formatting process. I was hoping an MVP who knew how to report a BUG would see the thread, but that has not happened yet. So I repeat it here, in the hopes that this can be fixed. Apparently, there is an issue with executing a number format conditionally when the cell being tested has a reference to another worksheet. (The color formatting of interior works OK; it seems to be only the number formatting that gets screwed up). I was able to reproduce this on my Excel 2007. The original thread is at: http://groups.google.com/group/micro...310b5f20?hl=en Here is the portion showing how to reproduce the problem: You must Sign in before you can post messages. To post a message you must first join this group. Please update your nickname on the subscription settings page before posting. You do not have the permission required to post. Dr. Phil M View profile More options Nov 19, 10:49 pm Newsgroups: microsoft.public.excel.worksheet.functions From: Dr. Phil M Date: Wed, 19 Nov 2008 19:49:00 -0800 Subject: conditional format error Excel 2007 Ron thanks! I'm using Ecel 2007. The SS is a little complex but I made up a simple one which shows the error. As below Sheet 1 data entry in A1 and B1 Sheet 2 A1 =Sheet1!A1 A2=Sheet1!A2 A3=SUM(A1:A2) Format sheet 2 A3 as a number with 1decimal place Conditional format sheet 2 A3 with say 6 decimal places with condition formula =$A$1=0 So if you enter 0 in sheet 1 A1 then see 6 decimal places in sheet 2 A3. if you then enter 1 in sheet 1 A1, Excel does not reset sheet 2 A3 to 1 decimal place until you delete a blank cell on sheet 2. Wierd? Thanks Phil --ron |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to report a BUG?
Hi,
I tested you bug and was able to duplicate it, I have passed it along to the MVP feedback site, but be advised, these things sometime take a long time to get looked at or resolved. If this helps, please click the Yes button Cheers, Shane Devenshire "Ron Rosenfeld" wrote: A few days ago, Dr Phil M posted what appears to be a BUG in the Excel 2007 conditional formatting process. I was hoping an MVP who knew how to report a BUG would see the thread, but that has not happened yet. So I repeat it here, in the hopes that this can be fixed. Apparently, there is an issue with executing a number format conditionally when the cell being tested has a reference to another worksheet. (The color formatting of interior works OK; it seems to be only the number formatting that gets screwed up). I was able to reproduce this on my Excel 2007. The original thread is at: http://groups.google.com/group/micro...310b5f20?hl=en Here is the portion showing how to reproduce the problem: You must Sign in before you can post messages. To post a message you must first join this group. Please update your nickname on the subscription settings page before posting. You do not have the permission required to post. Dr. Phil M View profile More options Nov 19, 10:49 pm Newsgroups: microsoft.public.excel.worksheet.functions From: Dr. Phil M Date: Wed, 19 Nov 2008 19:49:00 -0800 Subject: conditional format error Excel 2007 Ron thanks! I'm using Ecel 2007. The SS is a little complex but I made up a simple one which shows the error. As below Sheet 1 data entry in A1 and B1 Sheet 2 A1 =Sheet1!A1 A2=Sheet1!A2 A3=SUM(A1:A2) Format sheet 2 A3 as a number with 1decimal place Conditional format sheet 2 A3 with say 6 decimal places with condition formula =$A$1=0 So if you enter 0 in sheet 1 A1 then see 6 decimal places in sheet 2 A3. if you then enter 1 in sheet 1 A1, Excel does not reset sheet 2 A3 to 1 decimal place until you delete a blank cell on sheet 2. Wierd? Thanks Phil --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to report a BUG?
Ron,
I have posted it on a MVP site, I don't have 2007 on the PC I am working on right now so I just quoted your message without testing. -- Regards, Peo Sjoblom "Ron Rosenfeld" wrote in message ... A few days ago, Dr Phil M posted what appears to be a BUG in the Excel 2007 conditional formatting process. I was hoping an MVP who knew how to report a BUG would see the thread, but that has not happened yet. So I repeat it here, in the hopes that this can be fixed. Apparently, there is an issue with executing a number format conditionally when the cell being tested has a reference to another worksheet. (The color formatting of interior works OK; it seems to be only the number formatting that gets screwed up). I was able to reproduce this on my Excel 2007. The original thread is at: http://groups.google.com/group/micro...310b5f20?hl=en Here is the portion showing how to reproduce the problem: You must Sign in before you can post messages. To post a message you must first join this group. Please update your nickname on the subscription settings page before posting. You do not have the permission required to post. Dr. Phil M View profile More options Nov 19, 10:49 pm Newsgroups: microsoft.public.excel.worksheet.functions From: Dr. Phil M Date: Wed, 19 Nov 2008 19:49:00 -0800 Subject: conditional format error Excel 2007 Ron thanks! I'm using Ecel 2007. The SS is a little complex but I made up a simple one which shows the error. As below Sheet 1 data entry in A1 and B1 Sheet 2 A1 =Sheet1!A1 A2=Sheet1!A2 A3=SUM(A1:A2) Format sheet 2 A3 as a number with 1decimal place Conditional format sheet 2 A3 with say 6 decimal places with condition formula =$A$1=0 So if you enter 0 in sheet 1 A1 then see 6 decimal places in sheet 2 A3. if you then enter 1 in sheet 1 A1, Excel does not reset sheet 2 A3 to 1 decimal place until you delete a blank cell on sheet 2. Wierd? Thanks Phil --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to report a BUG?
On Fri, 21 Nov 2008 12:30:02 -0800, Shane Devenshire
wrote: Hi, I tested you bug and was able to duplicate it, I have passed it along to the MVP feedback site, but be advised, these things sometime take a long time to get looked at or resolved. If this helps, please click the Yes button Cheers, Shane Devenshire Shane and Peo, Thanks for passing that along. Shane -- I am using a newsreader and don't have a "Yes" button to click. I suspect that is confined to the web interface. But I would if I could. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Print Report W/Sub Report | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
Header in Report Manager Report | Excel Discussion (Misc queries) | |||
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response | Excel Discussion (Misc queries) |