BUG: »ç¿ëÀÚ°¡ Excel ¸ñ·Ï Çà CommandButton Click À̺¥Æ®¿¡¼­ »èÁ¦ÇÒ ¼ö ¾ø½À´Ï´Ù.

±â¼ú ÀÚ·á: 823988 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

Çö»ó

Office Excel 2003¿ë °ü¸® ÄÚµå È®ÀåÀ» ÀÛ¼ºÇÑ. ¼Ö·ç¼Ç¿¡ MSForms ¸í·É ´ÜÃß ÄÁÆ®·ÑÀÇ Click À̺¥Æ®¸¦ »ç¿ëÇÏ¿© ÇàÀÇ ¿öÅ©½ÃÆ®¿¡ ÀÖ´Â ¸ñ·Ï °³Ã¼¿¡¼­ Á¦°ÅÇÕ´Ï´Ù. ¸ñ·Ï ÇàÀ» Á¦°ÅÇÏ·Á¸é ÀÌ ´ÜÃ߸¦ Ŭ¸¯Çϸé Çà Á¦°Å ¹× ·±Å¸ÀÓ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù.

ÇöÀç »óÅÂ

MicrosoftÀº Office Excel 2003 ¹ö±×°¡ ÀÖÀ½À» È®ÀÎÇß½À´Ï´Ù.

ÇØ°á ¹æ¹ý

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ¸ñ·Ï¿¡¼­ ÇàÀ» »èÁ¦ÇÒ ¶§ CommandButton Æ÷Ä¿½º°¡ ¾ø´ÂÁö È®ÀÎÇϽʽÿÀ. ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.
  • CommandButtonTakeFocusOnClick ¼Ó¼ºÀ» false ·Î ¼³Á¤ÇϽʽÿÀ.

    - ¶Ç´Â -
  • ÇöÀç ¿öÅ©½ÃÆ® ¼±Åà ¸í·É ´ÜÃß ¹ÛÀ¸·Î Æ÷Ä¿½º¸¦ µÑ ÀûÁ¤.

ÇØ°á °úÁ¤

ÀÌ ¹®Á¦¸¦ ÇØ°áÇÏ·Á¸é ´ÙÀ½ ¹æ¹ý Áß Çϳª¸¦ »ç¿ëÇϽʽÿÀ.
  • ¸í·É ´ÜÃß ÄÁÆ®·Ñ¿¡ ´ëÇÑ TakeFocusOnClick ¼Ó¼ºÀ» false ·Î ¼³Á¤ÇÒ:
    protected void ThisWorkbook_Open()
    {
    	//Get a reference to the first worksheet.
    	ws = (Excel.Worksheet)(ThisWorkbook.Worksheets[1]);
    
    	//Set up the Click event handler for CommandButton1.
    	cb = (MSForms.CommandButton)(this.FindControl("CommandButton1"));
    	cb.Click+= new MSForms.CommandButtonEvents_ClickEventHandler(cbClick);
    
    	cb.TakeFocusOnClick = false;
    }
    


    - ¶Ç´Â -
  • ÇöÀç ¿öÅ©½ÃÆ®ÀÇ ¼±Åà ¿¡¼­ CommandButton Æ÷Ä¿½º¸¦ Á¦°ÅÇÏ·Á¸é Select ¸Þ¼­µå¸¦ È£ÃâÇÏ¿©:
    private void cbClick()
    { 
    	ThisApplication.Selection.GetType().InvokeMember("Select",
    		System.Reflection.BindingFlags.Public | 
    		System.Reflection.BindingFlags.InvokeMethod | 
    		System.Reflection.BindingFlags.Instance,
    		null,
    		ThisApplication.Selection,
    		null);
    	
    	ws.ListObjects[1].ListRows[1].Delete();
    }
    

Ãß°¡ Á¤º¸

Windows Mobile ±â¹Ý ½º¸¶Æ®Æù¿¡ GPRS ¿¬°áÀÌ ±¸¼ºµÇ¾î ÀÖ´ÂÁö È®ÀÎÇÕ´Ï´Ù

  1. Microsoft Visual Studio .NET 2003 ½ÃÀÛÇϽʽÿÀ.
  2. ÆÄÀÏ ¸Þ´º¿¡¼­ »õ·Î ¸¸µé±â¸¦ °¡¸®Å² ´ÙÀ½ ÇÁ·ÎÁ§Æ® ¸¦ Ŭ¸¯ÇϽʽÿÀ.
  3. ÇÁ·ÎÁ§Æ® Çü½Ä ¸ñ·Ï¿¡¼­ Microsoft Office ½Ã½ºÅÛ ÇÁ·ÎÁ§Æ® ¸¦ È®ÀåÇÑ ´ÙÀ½ Visual C# ÇÁ·ÎÁ§Æ® ¸¦ Ŭ¸¯ÇϽʽÿÀ. Excel ÅëÇÕ ¹®¼­ ¼­½Ä ÆÄÀÏ ¸ñ·Ï¿¡¼­ ¼±ÅÃÇϰí È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
  4. ¸¶Ä§OfficeÀÇ ÇÁ·ÎÁ§Æ® ¸¶¹ý»ç ¸¦ Ŭ¸¯ÇϽʽÿÀ.
  5. F5 ۸¦ ´­·¯ ÇÁ·ÎÁ§Æ®¸¦ ½ÇÇàÇÏ·Á¸é ¹× Excel¿¡¼­ ÅëÇÕ ¹®¼­¸¦ ¿±´Ï´Ù.
  6. ÅëÇÕ ¹®¼­¸¦ ´ÙÀ½°ú °°ÀÌ ¼öÁ¤ÇϽʽÿÀ.
    1. A1 ¼¿À» ¼±ÅÃÇϽʽÿÀ.
    2. µ¥ÀÌÅÍ ¸Þ´º¿¡¼­ ¸ñ·Ï À» °¡¸®Å² ´ÙÀ½ ¸ñ·Ï ¸¸µé±â¸¦ Ŭ¸¯ÇϽʽÿÀ. ¸ñ·Ï ¸¸µé±â ´ëÈ­ »óÀÚ°¡ ³ªÅ¸³³´Ï´Ù. È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
    3. A2, A3, A4 ¼¿¿¡ ÅØ½ºÆ®¸¦ Ãß°¡ÇÒ (A2:A4).
    4. º¸±â ¸Þ´º¿¡¼­ µµ±¸ ¸ðÀ½ À» °¡¸®Å² ´ÙÀ½ ÄÁÆ®·Ñ µµ±¸ »óÀÚ ¸¦ Ŭ¸¯ÇϽʽÿÀ.
    5. ¿öÅ©½ÃÆ®¿¡ ÀÖ´Â ¸í·É ´ÜÃß ÄÁÆ®·ÑÀ» ±×¸³´Ï´Ù. ±âº» À̸§ÀÎ CommandButton1 À».
    6. ÅëÇÕ ¹®¼­¸¦ ÀúÀåÇÑ ´ÙÀ½ ExcelÀ» Á¾·áÇϽʽÿÀ.
  7. Thisworkbook.cs ÄÚµå ¸ðµâ¿¡ ´ÙÀ½ Äڵ带 Ãß°¡ÇÕ´Ï´Ù: °³ÀÎ MSForms.CommandButton cb
    private MSForms.CommandButton cb;
    private Excel.Worksheet ws;
    
    protected void ThisWorkbook_Open()
    {
    	//Get a reference to the first worksheet.
    	ws = (Excel.Worksheet)(ThisWorkbook.Worksheets[1]);
    
    	//Set up the Click event handler for CommandButton1.
    	cb = (MSForms.CommandButton)(this.FindControl("CommandButton1"));
    	cb.Click+= new MSForms.CommandButtonEvents_ClickEventHandler(cbClick);
    }
    
    private void cbClick()
    {
    	try
    	{
    		//Delete the first row in the list object.
    		ws.ListObjects[1].ListRows[1].Delete();
    	}
    	catch (Exception ex)
    	{
    		System.Diagnostics.Debug.WriteLine(ex.Message);
    		MessageBox.Show(ex.Message);
    	}
    }
    
  8. F5 ۸¦ ´­·¯ ºôµåÇϰí ÇÁ·ÎÁ§Æ®¸¦ ½ÇÇàÇÕ´Ï´Ù.
  9. CommandButton1 À» Ŭ¸¯ÇϽʽÿÀ.

    °á°ú ¸ñ·Ï¿¡¼­ ÇàÀ» »èÁ¦ÇÒ ¶§ ¿¹¿Ü°¡ °Ë»öµÇ¾ú½À´Ï´Ù. ´ÙÀ½ ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³­´Ù
    HRESULT¿¡¼­ ¿¹¿Ü: 0x800A03EC

¼Ó¼º

±â¼ú ÀÚ·á: 823988 - ¸¶Áö¸· °ËÅä: 2007³â 1¿ù 15ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 2.3
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Office Excel 2003
  • Microsoft Visual Studio Tools for the Microsoft Office System version 2003
Ű¿öµå:?
kbmt kbbug kbautomation kbnofix KB823988 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â