setDataArray¤Ç¥»¥ë¤Ë½ñ¤¹þ¤ó¤Àʸ»ú¤¬¸«¤¨¤Ê¤¤¡ª †
¥Ú¡¼¥¸ | OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸ |
---|---|
Åê¹Æ¼Ô | mr_happy |
ʬÎà | |
Í¥Àè½ç°Ì | |
¾õÂÖ | |
¥«¥Æ¥´¥ê¡¼ | |
Åê¹ÆÆü | 2011-05-01 14:35:32 (Æü) |
OS | Win7 |
°Í¸¤¹¤ë¥Ú¡¼¥¸ | fqa 6/238 |
¥Ð¡¼¥¸¥ç¥ó |
¥á¥Ã¥»¡¼¥¸ †
²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó |
¤³¤ó¤Ë¤Á¤Ï¡¢¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£ ÉôʬŪ¤Ç¤¹¤¬¡¢²¼µ¤Î¤è¤¦¤Ë¤·¤Æ¥»¥ë¤Ë°ì³ç¤·¤Æ½ñ¤¹þ¤ß¤ò¤¹¤ëºî¶È¤ò¸¦µæÃæ¤Ç¤¹¡£
Dim x1 As Integer, y1 As Integer, x2 As Integer, y2 As Integer Dim vnBf(4), mm(4)
For nSno=1 To 5 For nKtnNo=1 To 5 mm(nKtnNo-1)=cnKei(nKtnNo, nSno) Next vnBf(nSno-1) = Array(mm(0),mm(1),mm(2),mm(3),mm(4)) Next x1=57: y1=9 x2 = Ubound(vnBf(0)) + x1 y2 = Ubound(vnBf) + y1 oSht=ThisComponent.Sheets(1) oSht.getCellRangeByPosition(x1,y1,x2,y2).setDataArray(vnBf)
¤³¤ì¤Çưºî¤ÏÌÜŪƻÍý¹Ô¤ï¤ì¤ë¤Î¤Ç¤¹¤¬¡¢¥·¡¼¥È¤ò¸«¤ë¤È²¿¤â½ñ¤¹þ¤Þ¤ì¤Æ¤¤¤Þ¤»¤ó¡ª¡£ ¤¤¤ä¡¢½ñ¤¹þ¤Þ¤ì¤Æ¤¤¤ë¤è¤¦¤Ê¤Î¤Ç¤¹¤¬¡¢¸«¤¨¤Þ¤»¤ó¡£
¤³¤Î°ÕÌ£¤Ï¡¢¥Þ¥¦¥¹¤ò¥»¥ë¾å¤Ë»ý¤Ã¤Æ¤æ¤¯¤È¡¢ ¿ô¼°ÆþÎÏÍó¤Ë¤Ï½ñ¤¹þ¤Þ¤ì¤¿¿ô»ú¤¬É½¤ì¤Þ¤¹¡£ ¤·¤«¤·¡¢¥»¥ë¤Ë¤Ï̵¤¤¤Î¤Ç¤¹¡£
½ñ¤¹þ¤Þ¤ì¤¿¤È»×¤ï¤ì¤ëÉôʬ¤ò¥¹¥¯¥í¡¼¥ë¤·¡¢ °ìÅÙ±£¤·¤Æ¤«¤é ºÆ¤ÓÌ᤹¤È¸«¤¨¤ë¡á½ñ¤¹þ¤Þ¤ì¤Æ¤¤¤ë¤Î¤Ç¤¹¡£
¹¹¤Ë¡¢¥»¥ë¤Ë¸½¤ì¤¿¿ô»ú¤ò¾Ã¤½¤¦¤È¤·¤Æ¤â¡ÊDEL,¥¯¥ê¥¢¤Ê¤É¡Ë¾Ã¤¨¤Þ¤»¤ó¡ª ·ë¶É¡¢¹Ô¤òºï½ü¤·¤Æ¾Ã¤·¡¢¥Æ¥¹¥È¤ò³¤±¤Æ¤¤¤Þ¤¹¡£
¤Ê¤¼¤³¤ó¤Ê¤³¤È¤¬µ¯¤³¤ë¤Î¤Ç¤·¤ç¤¦¤«¡© ¤ªÊ¬¤«¤ê¤ÎÊý¤¬¤ª¤ê¤Þ¤·¤¿¤é¡¢¤´¶µ¼ø¤¯¤À¤µ¤¤¡£¤ª´ê¤¤¤·¤Þ¤¹¡£
²èÌ̹¹¿·¡© †
M.Kamataki (2011-05-02 20:32:14 (·î))
¥Þ¥¯¥í¤Î¼Â¹Ô®ÅÙ¤ò¾å¤²¤ë¤¿¤á¤Ë²èÌ̹¹¿·¤ò¥í¥Ã¥¯¤·¤Æ¤¤¤Þ¤»¤ó¤«¡© °Ê²¼¤Î¥Ú¡¼¥¸¤ò»²¹Í¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£
¥³¥ó¥È¥í¡¼¥é¤Î¥í¥Ã¥¯
http://hermione.s41.xrea.com/pukiwiki/pukiwiki.php?OOoBasic%2FGeneric%2FlockControllers
¥í¥Ã¥¯¤Ï¤µ¤ì¤Æ¤Ê¤¤¤è¤¦¤Ç¤¹¤¬ †
mr_happy (2011-05-03 08:29:35 (²Ð))
¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£~
°Ê²¼¤ÇÄ´¤Ù¤Æ¤ß¤Þ¤·¤¿¤¬¡¢·ë²Ì¤Ï¡ÖFALSE¡×¤È¤Ê¤ê¡¢¥í¥Ã¥¯¤Ï¤µ¤ì¤Æ¤Ê¤¤¤è¤¦¤Ç¤¹¡£Sub LockChk Dim oDoc oDoc = ThisComponent If oDoc.hasControllersLocked =TRUE then msgbox "TRUE" else: msgbox "FALSE" End If End Sub¼¡¤Î¤Ç¤â¤¤¤¤¤Î¤Ç¤·¤¿¤Í
Sub LockChk Dim oDoc oDoc = ThisComponent msgbox oDoc.hasControllersLocked End Sub
LockChk¤Ç¤Ï¤¤¤Ä¤âFALSE¤Ë¤Ê¤ë¡©¡ª †
mr_happy (2011-06-05 16:05:00 (Æü))
¤³¤ó¤Ë¤Á¤Ï¡£fqa 6/238 ¤ò¸«¤Æ¼«Ê¬¤Î¤ÏÊѤÀ¤Ê¤¡¡¢¤â¤¦°ìÅ٤Ȼפ¤¤Ê¤¬¤é
¼¡¤Î¤³¤È¤ò¤·¤Æ¤ß¤Þ¤·¤¿¡£²¼µ¤Î¥Þ¥¯¥í¤Ç~
¡lockBook ¢ª LockChk ¡¦¡¦¡¦MsgBox¤Ï¡¡TRUE¡¡¢ª FALSE ¤È¥á¥Ã¥»¡¼¥¸~
¢UnlockBook ¢ª LockChk ¡¦¡¦¡¦MsgBox¤Ï¡¡FALSE ¢ª FALSE ¤È¥á¥Ã¥»¡¼¥¸~
¤³¤Î·ë²Ì¡¢¥í¥Ã¥¯¤µ¤ì¤Æ¤¤¤Æ¤â¤¤¤Ê¤¯¤Æ¤âLockChk¤Ç¤ÏFALSE¤Ë¤Ê¤ë¤È¤¤¤¦¤³¤È¤Ç¤·¤¿¡£¤É¤³¤¬¤Þ¤º¤¤¤Î¤Ç¤·¤ç¤¦¤«¡£µ¹¤·¤¯¤´¶µ¼¨¤Î¤Û¤É¤ò¡£Sub LockChk Dim oDoc oDoc = ThisComponent msgbox oDoc.hasControllersLocked End Sub Sub lockBook Dim oDoc oDoc = ThisComponent oDoc.lockControllers() msgbox oDoc.hasControllersLocked End Sub Sub UnlockBook Dim oDoc oDoc = ThisComponent oDoc.unlockControllers() msgbox oDoc.hasControllersLocked End Sub
LibreOffice¤ÎÉÔ¶ñ¹ç¤Ã¤Ý¤¤¤Ç¤¹¤Í †
M.Kamataki (2011-06-05 16:59:29 (Æü))
mr_happy¤µ¤ó¤¬¤ª»È¤¤¤Î¤â¤Î¤Ï¡¢¡Ö3.3.2¡×¤È¤¤¤¦¤³¤È¤Ê¤Î¤Ç¡¢LibreOffice¤Ç¤¹¤è¤Í¡£³Î¤«¤ËLibreOffice¤Ç¤Ï¡¢Æ°ºî¤¬¤ª¤«¤·¤¤¤è¤¦¤Ç¤¹¡£LibreOffice¤ÎÉÔ¶ñ¹ç¡¦Í×˾¥Ç¡¼¥¿¥Ù¡¼¥¹¤Ç¤¢¤ëBugZilla¤Ë°Ê²¼¤ÎÅÐÏ¿¤¬¤¢¤ê¤Þ¤·¤¿¡£
calc: Basic scripts do not redraw table when macros are working
https://bugs.freedesktop.org/show_bug.cgi?id=34655
¤³¤ÎÉÔ¶ñ¹ç¤¬Ä¾¤ë¤Þ¤Ç¡¢lockControllers ¤Ï»È¤ï¤Ê¤¤¤Û¤¦¤¬Îɤ¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£°ìÊý¡¢addActionLock ¤Ïµ¡Ç½¤¹¤ë¤è¤¦¤Ç¤¹¡£
¤Ê¤ª¡¢OpenOffice.org 3.3.0¤Ç¤ÏÉÔ¶ñ¹ç¤Ï¤Ê¤¤¤è¤¦¤Ç¤¹¡£
ºÆ¸½¤·¤Þ¤»¤ó †
ike@¶å½£ (2011-06-06 08:56:29 (·î))
Sub Test lockBook 'true LockChk 'true UnlockBook 'false LockChk 'false End SubWin7 64bit LibreOffice3.3.2
¤³¤Á¤é¤Ç¤ÏºÆ¸½¤·¤Þ¤»¤ó¡£
3.4¤ò¥¤¥ó¥¹¥È¡¼¥ë¤Ç²ò¾Ã †
mr_happy (2011-06-06 16:02:51 (·î))
M.Kamataki ¤µ¤ó¡¢ike@¶å½£¤µ¤ó¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
3.4¤ò¥¤¥ó¥¹¥È¡¼¥ë¤Ç²ò¾Ã¤Ç¤¤Þ¤·¤¿¡£
¤¿¤À¡¢3.3¤ò¥¢¥ó¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¤È¤¡¢¤Á¤é¤ê¤È¸«¤¨¤¿¥Ð¡¼¥¸¥ç¥óÈÖ¹æ~
³Î¤«3.3.202¤À¤Ã¤¿¤è¤¦¤Êµ¤¤¬¤·¤Þ¤¹¡£~
ike@¶å½£¤µ¤ó¤Î¤Ï¡ÖWin7 64bit LibreOffice3.3.2¡×¤Î¸å¤ÎÈÖ¹æ¤â¤¢¤ë¤Î¤Ç¤·¤ç¤¦¤«¡©¡¡Î㤨¤Ð3.3.208¤È¤«¡©¡©¡©
°ì±þ´°Î»¤Ë¤·¤Æ¤ª¤¤Þ¤¹¡£
Àå¤餺¤Ç¤·¤¿ †
mr_happy (2011-06-06 16:09:09 (·î))
¡Ö3.4¤ò¥¤¥ó¥¹¥È¡¼¥ë¤Ç²ò¾Ã¤Ç¤¤Þ¤·¤¿¡×¤Ï¡¢¤â¤È¤â¤È¤ÎÌäÂê¡Ö¸«¤¨¤Ê¤¤¡×¤Î¤³¤È¤Ç¤Ï¤Ê¤¯¥í¥Ã¥¯¤ÎTRUE,FALSE¤Î»ö¤Ç¤¹¡£
¡Ö¸«¤¨¤Ê¤¤¡×·ï¤ÏÊÝα¤Ç¤Ê¤±¤ì¤Ð¤Ê¤é¤Ê¤«¤Ã¤¿¤Î¤Ç¤·¤¿¡£¤Ä¤Þ¤ê¤Þ¤À¥Æ¥¹¥È¤Ï¤·¤Æ¤¤¤Þ¤»¤ó¤Î¤Ç¡£~
¤Ê¤Î¤Ç¡¢´°Î»¤ÏÊÝα¤·¤Þ¤¹¡£
º£³Îǧ¡ª †
mr_happy (2011-06-06 17:21:08 (·î))
V£ò3.4.0¤Çº£¡¢³Îǧ¤·¤Þ¤·¤¿¡£
¥í¥Ã¥¯¤µ¤ì¤Æ¤¤¤ë¤È¡Ö¸«¤¨¤Ê¤¤¡×¤¬ºÆ¸½¤µ¤ì¤Þ¤·¤¿¡£
¤â¤Á¤í¤ó¥¢¥ó¥í¥Ã¥¯¤Ê¤é¡Ö¸«¤¨¤ë¡×¾õÂ֤Ǥ¹¡£
³§¤µ¤ó¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£¤³¤ì¤Ç´°Î»¤Ç¤¹¡£