¡ÖWeb½ÐÈÇ¥µ¥¤¥È¡×¥Ù¡¼¥¿¸ø³«

Q&A½¸[¡©]

Åö¥µ¥¤¥È¤Ç¤Î¤´¼ÁÌä¤Î¼õÉդϽªÎ»¤·¤Þ¤·¤¿

¤¹¤Ù¤Æ¤Î¥³¥ó¥Æ¥ó¥Ä¤òÆÉ¤ß¹þ¤ßÀìÍѤȤ·¤¿¤¿¤á¡¢²óÅúÍ󤫤é¤âÅê¹Æ¤Ç¤­¤Þ¤»¤ó

Apache OpenOffice/LibreOffice¤Î¤´¼ÁÌä¤Ï¤½¤ì¤¾¤ì¤Î¥Õ¥©¡¼¥é¥à¤Ø¤´Åê¹Æ¤¯¤À¤µ¤¤

¼ÁÌ䥳¡¼¥Ê¡¼

¥µ¥¤¥ÈÆâ¸¡º÷

ʬÎà¥á¥Ë¥å¡¼

´ØÏ¢¥µ¥¤¥È


ËÜÆü¡§2
ºòÆü¡§0
Áí¿ô¡§2455
¸½ºß¡§3


setDataArray¤Ç¥»¥ë¤Ë½ñ¤­¹þ¤ó¤Àʸ»ú¤¬¸«¤¨¤Ê¤¤¡ª

¥Ú¡¼¥¸OpenOffice.org FAQ¤ÎÅÐÏ¿¥Ú¡¼¥¸
Åê¹Æ¼Ômr_happy
ʬÎà
edit/refer
Í¥Àè½ç°Ì
edit/refer
¾õÂÖ
edit/refer
¥«¥Æ¥´¥ê¡¼
edit/refer
Åê¹ÆÆü2011-05-01 14:35:32 (Æü)
OSWin7
°Í¸¤¹¤ë¥Ú¡¼¥¸fqa 6/238
¥Ð¡¼¥¸¥ç¥ó
edit/refer

¥á¥Ã¥»¡¼¥¸

²óÅú¥Ú¡¼¥¸¤Ç¤Ï¹ÔËö¤Ë¡Ö~¡×¤òÉղ乤ëɬÍפϤ¢¤ê¤Þ¤»¤ó

¤³¤ó¤Ë¤Á¤Ï¡¢¤ªÀ¤Ïäˤʤê¤Þ¤¹¡£ ÉôʬŪ¤Ç¤¹¤¬¡¢²¼µ­¤Î¤è¤¦¤Ë¤·¤Æ¥»¥ë¤Ë°ì³ç¤·¤Æ½ñ¤­¹þ¤ß¤ò¤¹¤ëºî¶È¤ò¸¦µæÃæ¤Ç¤¹¡£

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 Sub

Win7 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¤Çº£¡¢³Îǧ¤·¤Þ¤·¤¿¡£
¥í¥Ã¥¯¤µ¤ì¤Æ¤¤¤ë¤È¡Ö¸«¤¨¤Ê¤¤¡×¤¬ºÆ¸½¤µ¤ì¤Þ¤·¤¿¡£
¤â¤Á¤í¤ó¥¢¥ó¥í¥Ã¥¯¤Ê¤é¡Ö¸«¤¨¤ë¡×¾õÂ֤Ǥ¹¡£
³§¤µ¤ó¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£¤³¤ì¤Ç´°Î»¤Ç¤¹¡£

¤ªÌ¾Á°:
Âê̾: