Home of site
Macroの杜( Python編 )
[ Python for LibreOffice( Apache OpenOffice ) ]
【 General No.2 】
**********************【 Index 】**********************
Data( Python はＣ言語と違い、あらかじめ変数やそのData型を宣言する必要はありません。)
[ Number ]
GDN-)[General]足し算
GDN-)[General]引き算
GDN-)[General]掛け算
GDN-)[General]割り算(1)[整数/整数](ver2.7)
GDN-)[General]割り算(2)[実数/実数]
GDN-)[General]整数の余り[ % ]
GDN-)[General]整数の割り算(ver2.7)
GDN-)[General]整数の割り算(ver3.3)
GDN-)[General]整数の割り算と余り[ divmod(,) ]
GDN-)[General]浮動小数点の余り[ import math / math.fmod ]
GDN-)[General]精度の良い計算( Decimal型 )[from decimal import * / Decimal ]
GDN-)[General]実数(浮動小数点)[ float() ]
GDN-)[General]整数型[ int() ]
GDN-)[General]指数[ math.exp / math.expm1() ]
GDN-)[General]対数[ math.log(,) / .log() / .log10() / .log1p() / .log2() ]
GDN-)[General]平方根[ math.sqrt ]
GDN-)[General]複素数[ .real / ]
GDN-)[General]絶対値(1)[ abs() ]
GDN-)[General]絶対値(2)[ math.fabs() ]
GDN-)[General]乱数[ import random / random / .seed() / .random / .randrange / .randint / .randform / .choice / .sample / .shuffle ]
GDN-)[General]四捨五入[ round ]
GDN-)[General]Decimal型の四捨五入[ Decimal().quantize() ]
GDN-)[General]小数点第1位の切り捨て / 整数表示[ math.trunc ]
GDN-)[General]小数点第1位の切り捨て / 浮動小数点表示(2.7系),整数表示(3.3系)[ math.floor() ]
GDN-)[General]小数点第1位の切り上げ / 浮動小数点表示(2.7系),整数表示(3.3系)[ math.ceil() ]
GDN-)[General]Max / Min[ max / min ]
GDN-)[General]10進数(int型) ⇒ 16進数[ hex() ]
GDN-)[General]10進数(float型) ⇒ 16進数 ⇒ 10進数(float型)[ float.hex() / float.fromhex() ]
GDN-)[General]8進数[ oct() ]
GDN-)[General]べき数[ pow / math.pow(x, y) ]
GDN-)[General]浮動小数点を小数点部と整数部に分ける(+値のみ)[ math.modf() ]
GDN-)[General]円周率 π[ math.pi ]
GDN-)[General]自然対数基数 e [ math.e ]
GDN-)[General]精度の違う表記を統一[ from decimal import * / .normalize() ]
GDN-)[General]比較演算[ 2.7系 ][ cmp ]
GDN-)[General]複数の比較演算[ ]
GDN-)[General]合計取得[ sum() / math.fsum() ]
GDN-)[General]int型に変換可能かcheck[ .isdigt() ]
GDN-)[General]数値型( int / float / +,-付 )に変更可能かcheck[ ]
GDN-)[General]未完成[ .isdecimal() ]
GDN-)[General]未完成[ .isnumeric() ]
GDN-)[General]x に y の符号を付ける[ math.copysign(x, y) ]
GDN-)[General]階乗[ math.factorial() ]
GDN-)[General]仮数と指数のPair(x,y)[ math.frexp() ]
GDN-)[General]x * (2**y)[ math.ldexp(x, y) ]
GDN-)[General]無限大かどうかCheck[ math.isinf() ]
GDN-)[General]NaN( Not a number )Check[ math.isnan() ]
GDN-)[General]無限大 or NaNかどうかCheck[ math.isfinite() ]
GDN-)[General]角度変換[ math.radians() / math.degrees() ]
GDN-)[General]三角関数[ math.sin() / math.cos() / math.tan() / math.asin() / math.acos() / math.atan() / math.atan2(,) / math.hypot(,) ]
GDN-)[General]双曲線関数[ math.sinh() / math.cosh() / math.tanh() / math.asinh() / math.acosh() / math.atanh() ]
GDN-)[General]誤差関数/相補誤差関数[ math.erf() / math.erfc() ]
GDN-)[General]Gamma関数[ ]
GDN-)[General][ ]
[ String ]
******************************[ Macro Code ]******************************
【 General No.2 】
Data
GDa-)[General]変数の型をCheck・判別
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oTuple = ('tuple1','tuple2')
oList = ['list1','list2']
oDict = {'1':'dict1','2':'dist2'}
oString = 'Tape'
oCheckType = []
oCheckType.append(oTuple)
oCheckType.append(oList)
oCheckType.append(oDict)
oCheckType.append(oString)
oDisp = u'[ 変数の型 ]\n\t'
for i in oCheckType:
if isinstance(i,tuple):
for j in i:
oDisp = oDisp + str(j) + u' ⇒ tuple \n\t'
elif isinstance(i,list):
for j in i:
oDisp = oDisp + str(j) + u' ⇒ list \n\t'
elif isinstance(i,dict):
for j in i:
oDisp = oDisp + str(j) + u' ⇒ dict \n\t'
else:
oDisp = oDisp + str(i) + u' ⇒ String \n\t'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'変数の型をCheck・判別')
GDa-)[General]文字列のCheck・判別[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oStr = 'Hello world!!'
oUCd = unicode('こんにちは!!','utf-8')
oIsInce1 = isinstance(oStr,basestring)
oIsInce2 = isinstance(oStr,(str,unicode))
oIsInce3 = isinstance(oUCd,basestring)
oDisp = unicode('[ String / unicode型のCheck ]\n\n','utf-8')\
+ 'isinstance(' + str(oStr) + ',basestring) = ' + str(oIsInce1) + '\n'\
+ 'isinstance(' + str(oStr) + ',(str,unicode)) = ' + str(oIsInce2) + '\n'\
+ 'isinstance(' + oUCd + ',basestring) = ' + str(oIsInce3)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDa-)[General]文字列のCheck・判別[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oStr = u'Hello world!!'
oUCd = u'こんにちは!!'
oIsInce1 = isinstance(oStr,str)
# oIsInce2 = isinstance(oStr,(str,unicode)) # 3.3 : impossible
oIsInce3 = isinstance(oUCd,str)
oDisp = u'[ String型のCheck[ 3.3系 ] ]\n\n' + u'isinstance(' + oStr + u',str) = ' + str(oIsInce1) + '\n'\
+ u'isinstance(' + oUCd + u',str) = ' + str(oIsInce3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字列のCheck・判別')
GDa-)[General]File ObjectのCheck・判別[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oTextFile = 'c:\\temp\\oTextMacro.txt'
# Readonly
with open(oTextFile,'rb') as oFileObj:
oType = isinstance(oFileObj,file)
oFileObj.closed
oDisp = unicode('[ File Object Check ]\n','utf-8')\
+ 'isinstance(oFileObj,file) = ' + str(oType)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDa-)[General]File ObjectのCheck・判別[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
from io import IOBase
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oTextFile = u'c:\\temp\\oTextMacro.txt'
# Readonly
with open(oTextFile,'rb') as oFileObj:
oType = isinstance(oFileObj,IOBase)
oFileObj.closed
oDisp = u'[ File Object Check ]\n\t' + u'isinstance(oFileObj,IOBase)\n\t = ' + str(oType)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'File ObjectのCheck・判別')
GDa-)[General]float型に関する情報
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oFloat = sys.float_info
oDisp = u'[ float型に関する情報 ]\n\n' + str(oFloat)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'float型に関する情報')
#
# max : floatが表わせる最大の値
# max_exp : floatがradix**(e-1)を表現可能な最大整数e
# max_10_exp : floatが10**eを表現可能な最大整数e
# min : floatが表現可能な最少の正の値
# min_exp : radix**(e-1)が正規化floatであるような最少の整数e
# min_10_exp : 10**eが正規化floatであるような最少の整数e
# dig : digits
# mant_dig : mantissa digits
# epsilon : 1とその次の表現可能なfloat値の差
# radix : radix of exponent
# rounds : addition rounds
GDa-)[General]int型の最大値の定数[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oSys = sys.maxint
oDisp = unicode('[ int型の最大値の定数 ]\n => ','utf-8') + str(oSys)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDa-)[General]int型の最大値の定数[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oSys = sys.maxsize
oDisp = u'[ int型の最大値の定数 ]\n ⇒ ' + str(oSys) + u' ( 3.3系 )'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'int型の最大値の定数')
GDa-)[General]Dataの圧縮/解凍[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import zlib,binascii
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
"""shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
#
def oTest():
try:
oOrgText = 'This is the original data.'
oComp = zlib.compress(oOrgText)
oCompHex = binascii.hexlify(oComp)
oDeComp = zlib.decompress(oComp)
oDisp = u'[ Dataの圧縮/解凍 ]\n'\
+ '( Original Data )\n' + str(oOrgText) + '\n\n'\
+ '( Compress )\n' + str(oCompHex) + '\n\n'\
+ '( Decompress )\n' + str(oDeComp)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDa-)[General]Dataの圧縮/解凍[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import zlib,binascii
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oOrgText = b'This is the original data.' # 3.3 : Byte型 / String型は不可
oComp = zlib.compress(oOrgText)
oCompHex = binascii.hexlify(oComp)
oDeComp = zlib.decompress(oComp)
oDisp = u'[ Dataの圧縮/解凍(3.3系) ]\n' + u'( Original Data )\n' + str(oOrgText) + '\n\t ↓ \t\n'\
+ '( Compress )\n' + str(oCompHex) + '\n\t ↓ \t\n' + '( Decompress )\n' + str(oDeComp)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Dataの圧縮/解凍')
GDa-)[General]
[ Number ]
GMN-)[General]足し算
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
# 整数の除算は floor (実数の解を越えない最大の整数) を返す:
try:
num1 = 7
num2 = 3
num = num1 + num2
oDisp = num
omsgbox(oDisp)
except:
pass
GMN-)[General]引き算
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
#
def oTest():
# 整数の除算は floor (実数の解を越えない最大の整数) を返す:
try:
num1 = 7
num2 = 3
num = num1 - num2
oDisp = num
omsgbox(oDisp)
except:
pass
GMN-)[General]掛け算
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
# 整数の除算は floor (実数の解を越えない最大の整数) を返す:
try:
num1 = 7
num2 = 3
num = (num1+2) * (num2+1)
oDisp = num
omsgbox(oDisp)
except:
pass
GMN-)[General]割り算(1)[整数/整数](ver2.7)
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
#
def oTest():
# 整数の除算は floor (実数の解を越えない最大の整数) を返す(ver2.7) / ver3.3では 整数/整数の除算でも小数部を含めて返す:
try:
num1 = 7
num2 = 3
num = (num1+2) / (num2+1)
oDisp = num
omsgbox(oDisp)
except:
pass
GMN-)[General]割り算(2)[実数/実数]
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
num1 = 7.5
num2 = 3.1
num = (num1+2) / (num2+1)
oDisp = num
omsgbox(oDisp)
except:
pass
GMN-)[General]整数の余り
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
num1 = 7
num2 = 3
num = (num1+2) % (num2+1)
oDisp = num
omsgbox(oDisp)
except:
pass
#
# [ Note ]
# 整数の除算は floor (実数の解を越えない最大の整数) を返すので、厳密解で無い場合ある。
# 従い 10.3 % 1.2 ≠ math.fmod(10.3,1.2) である。
GMN-)[General]整数の割り算(ver2.7)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oInt1 = 1 # 整数型
oInt2 = 3
oReal1 = 1.0 # 実数型
oReal2 = 3.0
oDiv1 = oInt1 / oInt2
oDiv2 = float(oInt1/oInt2)
oDiv3 = float(oInt1) / float(oInt2)
oDiv4 = oReal1 / oReal2
oDiv5 = oReal1 / oInt2
oDisp = unicode('[ 整数( int / long )型の除算 ]','utf-8') + '\n\
' + str(oInt1) + ' / ' + str(oInt2) + ' = ' + str(oDiv1) + '\n\
' + 'float(' + str(oInt1) + ' / ' + str(oInt2) + ') = ' + str(oDiv2) + '\n\
' + 'float(' + str(oInt1) + ')/float(' + str(oInt2) + ') = ' + str(oDiv3) + '\n\
' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oDiv4) + '\n\
' + str(oReal1) + ' / ' + str(oInt2) + ' = ' + str(oDiv5)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
#
# [ Note ]
# ver2.7でも from __future__ import division とするver3.3と同様に「整数同士の割り算でも割りきれない場合は実数にする」というmodeになるらしい。
GMN-)[General]整数の割り算(ver3.3)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
#
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
"""shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def Test():
try:
# Ver3.3 の 整数/整数は、小数までReturnされる
oInt1 = 1 # 整数型
oInt2 = 3
oReal1 = 1.0 # 実数型
oReal2 = 3.0
oDiv1 = oInt1 / oInt2 # int(oInt1) / int(oInt2)でも結果は同じ
oDiv2 = float(oInt1/oInt2)
oDiv3 = float(oInt1) / float(oInt2)
oDiv4 = oReal1 / oReal2
oDiv5 = oReal1 / oInt2
oDisp = u'[ 整数( int / long )型の除算(ver3.3) ]\n'\
+ str(oInt1) + ' / ' + str(oInt2) + ' = ' + str(oDiv1) + '\n'\
+ 'float(' + str(oInt1) + ' / ' + str(oInt2) + ') = ' + str(oDiv2) + '\n'\
+ 'float(' + str(oInt1) + ')/float(' + str(oInt2) + ') = ' + str(oDiv3) + '\n'\
+ str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oDiv4) + '\n'\
+ str(oReal1) + ' / ' + str(oInt2) + ' = ' + str(oDiv5)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1)
GMN-)[General]整数の割り算と余り
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt1 = 5 # 整数型
oInt2 = 3
oReal1 = 5.0 # 実数型
oReal2 = 3.0
oDiv1 = divmod(oInt1,oInt2) # ReturnはTuple
oDiv2 = divmod(oReal1,oReal2)
oDiv3 = divmod(oReal1,oInt2)
oDisp = u'[ 除算の商と余り ]\n\t divmod(' + str(oInt1) + ',' + str(oInt2) + ') = ' + str(oDiv1) + '\n\t'\
+ ' divmod(' + str(oReal1) + ',' + str(oReal2) + ') = ' + str(oDiv2) + '\n\t'\
+ ' divmod(' + str(oReal1) + ',' + str(oInt2) + ') = ' + str(oDiv3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'商と余り')
GMN-)[General]浮動小数点の余り
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = -10.0
oReal2 = 3.5
oReal3 = 10.0
oReal4 = -3.5
oDiv1 = math.fmod(oReal1,oReal2)
oDiv2 = oReal1 % oReal2
oDiv3 = math.fmod(oReal3,oReal4)
oDiv4 = oReal3 % oReal4
oDisp = u'[ 浮動小数点の余り ]\n\t math.fmod( ' + str(oReal1) + ', ' + str(oReal2) + ') = ' + str(oDiv1) + '\n\t '\
+ str(oReal1) + ' % ' + str(oReal2) + ' = ' + str(oDiv2) + '\n\t '\
+ 'math.fmod( ' + str(oReal3) + ', ' + str(oReal4) + ') = ' + str(oDiv3) + '\n\t '\
+ str(oReal3) + ' % ' + str(oReal4) + ' = ' + str(oDiv4)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'余り')
#
# [ 浮動小数点の割り算の注意 ]
# 「x % y」のReturnの正負符号(+-)は必ず分母(ｙ)の符号と同じになる。
# 浮動小数点を含む「x % y」では厳密解が得られない時がある。
# 余りの計算には 浮動小数点 => math.fmod(x,y) / 整数 => x % yを利用する方が良い。
GMN-)[General]精度の良い計算
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
from decimal import *
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt1 = 8765
oInt2 = 4321
oPI = math.pi
oDcml1 = Decimal(oInt1) / Decimal(oInt2)
oDcml2 = Decimal(str(oPI)) ** Decimal('12.345') # float型は文字列型に変換する
oDisp = u'[ 精度の良い計算 ]\n\t'\
+ ' Decimal(' + str(oInt1) + ') / Decimal(' + str(oInt2) + ')\n\t = ' + str(oDcml1) + '\n\n\t'\
+ ' oPI = ' + str(oPI) + '\n\t Decimal(str(oPI)) ** Decimal(\'12.345\')\n\t = ' + str(oDcml2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'decimal')
#
# Decimal(x)の引数xは整数か文字列である事が必須。
# float型をdecimal型に変換するには一度、文字列にする必要がある。
GMN-)[General]実数(浮動小数点)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
num1 = 7.5
num2 = 3.1
num = (num1+2) / (num2+1)
oDisp = '(' + str(num1) + '+2)/(' + str(num2) + '+1)\n = ' + str(float(num))
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'float')
#
# [ 浮動小数点型(float)についての注意 ]
# 通常、Pythonの浮動小数点型は53bit以上の精度を持たないので、結果的に
# 「 abs(x) >= 2 ** 52 」であるような浮動小数点「x」は小数点を持たなくなる。
# Platformにおける「C double型」と同じ
GMN-)[General]整数型
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
num1 = 7.5
num2 = 3.1
num = (num1+2) / (num2+1)
oDisp = '(' + str(num1) + '+2)/(' + str(num2) + '+1)\n = ' + str(int(num))
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'int')
GMN-)[General]指数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum = 2.5
oExp = math.exp(oNum)
oExp_1 = math.exp(oNum)-1
oExpm1 = math.expm1(oNum) # 厳密な math.exp(oNum)-1 をReturn
oDisp = u'[ 指数 ]\n\t exp(' + str(oNum) + ') = ' + str(oExp) + '\n\t exp(' + str(oNum) + ') - 1 = '\
+ str(oExp_1) + '\n\t ' + 'expm1(' + str(oNum) + ') = ' + str(oExpm1)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'exp/expm1')
GMN-)[General]対数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum = 2.5
oX = 16 # Logの基数⇒ int 型
oLogX = math.log(oNum,oX)
oLogE = math.log(oNum)
oLogE2 = math.log1p(oNum) # ver3.2で追加
oLog10 = math.log10(oNum)
oLog2 = math.log2(oNum) # ver3.3で追加
oDisp = u'[ 対数 ]\n\t 基数16の対数\n => Log16(' + str(oNum) + ') = ' + str(oLogX) + '\n\n\t'\
+ u' 自然対数\n => LogE(' + str(oNum) + ') = ' + str(oLogE) + '\n\n\t'\
+ u' 1+x の自然対数\n => LogE(' + str(oNum) + '+1) = ' + str(oLogE2) + '\n\n\t'\
+ u' 基数10の対数\n => Log10(' + str(oNum) + ') = ' + str(oLog10) + '\n\n\t'\
+ u' 基数2の対数\n => Log2(' + str(oNum) + ') = ' + str(oLog2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'対数')
GMN-)[General]平方根
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum = 2.5
oSqrt1 = math.sqrt(oNum)
oSqrt2 = oNum ** (1.0/2.0) # ()内は実数の事。整数だと「0」になってしまう。
oSqrt3 = pow(oNum,1.0/2.0)
oDisp = u'[ 平方根 ]' + '\n\t math.sqrt(' + str(oNum) + ') = ' + str(oSqrt1) + '\n\t '\
+ str(oNum) + ' ** (1.0/2.0) = ' + str(oSqrt2) + '\n\t ' + 'pow(' + str(oNum) + ',1.0/2.0) = ' + str(oSqrt3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'平方根')
GMN-)[General]複素数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
num1 = 7.5+3j
numR = num1.real
numJ = num1.imag
oDisp = str(num1) + '\n\t 実数部 = ' + str(numR) + '\n\t 虚数部 = ' + str(numJ)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'複素数')
GMN-)[General]絶対値(1)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum1 = abs(12.34)
oNum2 = abs(-12.34)
oNum3 = abs(0.0)
oDisp = u'[ Absolute ]' + '\n\t' + str('abs(12.34) = ') + str(oNum1) + '\n\t'\
+ str('abs(-12.34) = ') + str(oNum2) + '\n\t' + str('abs(0.0) = ') + str(oNum3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'絶対値')
GMN-)[General]絶対値(2)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum1 = math.fabs(12.34)
oNum2 = math.fabs(-12.34)
oNum3 = math.fabs(0.0)
oDisp = u'[ math.fabs ]' + '\n\t' + str('math.fabs(12.34) = ') + str(oNum1) + '\n\t'\
+ str('math.fabs(-12.34) = ') + str(oNum2) + '\n\t' + str('math.fabs(0.0) = ') + str(oNum3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'絶対値')
GMN-)[General]乱数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import random
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
random.seed() # Randomの初期化
oData0 = random.random() #0.0～1.0までのfloat値
oData1 = random.randrange(1,96,5) #任意の値間且つ任意間隔の値(整数)
oData2 = random.uniform(1,100) #任意の値間のfloat値
oData3 = random.randint(1,100) #任意の値間のint値
#任意の文字列から一つの要素を取得
oStr = '123abcdK5?-+'
oData4 = random.choice(oStr)
#リストの順番をShuffule
oList = [1,'two','three',4,'five','six']
oData51 = random.choice(oList)
oData52 = random.sample(oList,2)
oListBase = str(oList)
random.shuffle(oList)
oListShfle = str(oList)
#
oDisp = u'[ 乱数で取得(毎回値が変わる) ]\n\t 0) 0.0～1.0までのfloat値 ⇒ ' + str(oData0) + '\n\n\t'\
+ u' 1) 任意の値間且つ任意間隔のint値 ⇒ ' + str(oData1) + '\n\n\t'\
+ u' 2) 任意の値間のfloat値 ⇒ ' + str(oData2) + '\n\n\t'\
+ u' 3) 任意の値間のint値 ⇒ ' + str(oData3) + '\n\n\t'\
+ u' 4) 任意の文字列から一つの要素を取得\n\t' + oStr + u' ⇒ ' + str(oData4) + '\n\n\t'\
+ u' 5) Listを用いた乱数\n\t -- 元のList --\n\t\t' + oListBase + '\n\n\t\t'\
+ u' 5-1) リストの順番をShuffule\n\t\t\t ⇒ ' + str(oListShfle) + '\n\n\t\t'\
+ u' 5-2) リスト中からRandam選択\n\t\t\t ⇒ ' + str(oData51) + '\n\n\t\t'\
+ u' 5-3) リスト中から任意の個数をRandom選択\n\t\t\t ⇒ ' + str(oData52)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'乱数')
GMN-)[General]四捨五入
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum = 12345.6789
oRd0 = round(oNum)
oRd1 = round(oNum,2)
oRd2 = round(oNum,-1)
oDisp = u'[ 四捨五入 ]\n\t' + u'元数 ⇒ ' + str(oNum) + '\n\t' + u'引数無し ⇒ ' + str(oRd0) + '\n\t'\
+ u'小数第3位を四社五入 ⇒ ' + str(oRd1) + '\n\t' + u'1桁目を四捨五入 ⇒ ' + str(oRd2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Round')
GMN-)[General]Decimal型の四捨五入
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
from decimal import *
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oPI = math.pi
oRnd = Decimal(str(oPI)).quantize(Decimal(10)**-3) # .quantize('0.01')は不可
oDisp = u'[ Decimal型の四捨五入 ]\n\t' + u'oPI = ' + str(oPI) + '\n\n\t'\
+ 'Decimal(str(oPI)).quantaize(Decimal(10)**-3)\n\t = ' + str(oRnd)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Round')
#
# Decimal型はfloat型より精度が良い
GMN-)[General]小数点第1位の切り捨て / 整数表示
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 100.0
oReal2 = 3.0
oTrunc = math.trunc(oReal1/oReal2)
oDisp = u'[ 整数に切り捨て ]\n\t' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oTrunc)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Rounddown')
GMN-)[General]小数点第1位の切り捨て / 浮動小数点表示(2.7系),整数表示(3.3系)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 100.0
oReal2 = 3.0
oFloor = math.floor(oReal1/oReal2)
oDisp = u'[ 切り捨て / 整数表示(3.3系) ]\n\t' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oFloor)
# 2.7系では浮動小数点表示
#oDisp = unicode('[ 切り捨て / 浮動小数点 ]','utf-8') + '\n\
# ' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oFloor)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Rounddown')
GMN-)[General]小数点第1位の切り上げ / 浮動小数点表示(2.7系),整数表示(3.3系)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 100.0
oReal2 = 3.0
oFloor = math.ceil(oReal1/oReal2)
oDisp = u'[ 切り上げ/整数表示(3.3系) ]\n\t' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oFloor)
# 2.7系では浮動小数点表示
#oDisp = unicode('[ 切り上げ / 浮動小数点 ]','utf-8') + '\n\
# ' + str(oReal1) + ' / ' + str(oReal2) + ' = ' + str(oFloor)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Roundup')
GMN-)[General]Max / Min
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oList = [0,1,2,3,-2,-1]
oMax = max(oList)
oMin = min(oList)
oDisp = u'[ max / min ]\n\t 元List ⇒ ' + str(oList) + '\n\t Max ⇒ ' + str(oMax) + '\n\t Min ⇒ ' + str(oMin)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'最大値/最少値')
GMN-)[General]10進数(int型) ⇒ 16進数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt1 = 15
oInt2 = 255
oInt3 = 2028
oHex1 = hex(oInt1)
oHex2 = hex(oInt2)
oHex3 = hex(oInt3)
oDisp = u'[ 16進数に変換 ]\n\t' + str(oInt1) + ' ⇒ ' + str(oHex1) + '\n\t'\
+ str(oInt2) + ' ⇒ ' + str(oHex2) + '\n\t' + str(oInt3) + ' ⇒ ' + str(oHex3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'16進数')
GMN-)[General]10進数(float型) ⇒ 16進数 ⇒ 10進数(float型)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oNum = 15.5
oHexF = float.hex(oNum)
oFromHex = float.fromhex(oHexF)
oDisp = u'[ 10進数(float型) ⇒ 16進数 ⇒ 10進数(float型) ]\n\n' + str(oNum) + ' ⇒ ' + str(oHexF) + ' ⇒ ' + str(oFromHex)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'16進数')
#
# 16進数文字列表現は以下の様になります。
# [符号]['0x'整数]['.'小数部]['p'指数部]
# 符号はOptionで,+-のいずれか。
# 整数部と小数部は16進数の文字列で、整数部/小数部の何れかが必須(当たり前の事ですが･･･)
# 指数部はOptionで符号がつけられる10進数です。
GMN-)[General]8進数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt1 = 15
oInt2 = 255
oInt3 = 2028
oOct1 = oct(oInt1)
oOct2 = oct(oInt2)
oOct3 = oct(oInt3)
oDisp = u'[ 8進数に変換 ]\n\t' + str(oInt1) + ' ⇒ ' + str(oOct1) + '\n\t' + str(oInt2) + ' ⇒ ' + str(oOct2)\
+ '\n\t' + str(oInt3) + ' ⇒ ' + str(oOct3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'8進数')
GMN-)[General]べき数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt1 = 10
oInt2 = 2
oInt3 = 12
oReal1 = -10.0
oReal2 = -2.0
oPow11 = pow(oInt1,oInt2)
oPow12 = oInt1 ** oInt2
oPow21 = pow(oReal1,oReal2)
oPow22 = oReal1 ** oReal2
oPow31 = pow(oInt1,oInt2,oInt3)
oPow32 = (oInt1 ** oInt2) % oInt3
oMPow1 = math.pow(oReal1, oReal2)
oDisp = u'[ べき乗 ]\n\t 1) pow(' + str(oInt1) + ',' + str(oInt2) + ') = ' + str(oPow11) + '\n\t'\
+ ' 2) ' + str(oInt1) + ' ** ' + str(oInt2) + ' = ' + str(oPow12) + '\n\t'\
+ ' 3) pow(' + str(oReal1) + ',' + str(oReal2) + ') = ' + str(oPow21) + '\n\t'\
+ ' 4) ' + str(oReal1) + ' ** ' + str(oReal2) + ' = ' + str(oPow22) + '\n\t'\
+ ' 5) pow(' + str(oInt1) + ',' + str(oInt2) + ',' + str(oInt3) + ') = ' + str(oPow31) + '\n\t'\
+ ' 6) ( ' + str(oInt1) + ' ** ' + str(oInt2) + ' ) % ' + str(oInt3) + ' = ' + str(oPow32) + '\n\n\t'\
+ ' 7) math.pow(' + str(oReal1) + ',' + str(oReal2) + ' = ' + str(oMPow1)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'べき乗')
#
# [ Note ]
# 第3引数ある場合はoInt1～3は整数型。また第2引数(oInt2)の「+/-」は必ず「+」/ pow(oInt1,oInt2,oInt3) = (pow(oInt1,oInt2))%oInt3 だが、高速処理が可能。
# Builtinの ** 演算子と違って、 math.pow() は両方の引数を float 型に変換します。 正確な整数の冪乗を計算するには ** もしくはBuiltinの pow() 関数を使うべき。
GMN-)[General]浮動小数点を小数点部と整数部に分ける
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 1234.5678
oReal2 = -1234.567
oModF1 = math.modf(oReal1)
oModF2 = math.modf(oReal2) # 小数点部も「-」符号が付く
oDisp = u'[ 浮動小数点を整数部と小数点部に分ける ]\n 1) math.modf(' + str(oReal1) + ')\n\t = ' + str(oModF1)\
+ '\n 2) math.modf(' + str(oReal2) + ')\n\t = ' + str(oModF2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'math.modf')
GMN-)[General]円周率 π
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oPI = math.pi
oDisp = u'[ 円周率 ]\n\t math.pi = ' + str(oPI)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'π')
GMN-)[General]自然対数基数 e
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oE = math.e
oDisp = u'[ 自然対数基数 e ]\n\t math.e = ' + str(oE)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'e')
GMN-)[General]精度の違う表記を統一
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
from decimal import *
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum1 = 2000
oNum2 = 2000.00000000
oNum3 = '2E3'
oNum4 = '.02E+5'
oDcml1 = Decimal(oNum1)
oDcml2 = Decimal(str(oNum2))
oDcml3 = Decimal(oNum3)
oDcml4 = Decimal(oNum4)
oList = [oDcml1,oDcml2,oDcml3,oDcml4]
oDisp = u'[ 精度の違う表記を統一 ]\n [ 元の値 ]\n\t ⇒ '\
+ str(oNum1) + ' : ' + str(oNum2) + ' : ' + str(oNum3) + ' : ' + str(oNum4) + ' :' + '\n [ 統一表記 ]\n\t ⇒ '
for n in oList:
oDisp = oDisp + str(n.normalize()) + ' : '
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'統一表記')
GMN-)[General]比較演算[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def otest():
try:
oNum1 = 10.0
oNum2 = 5.0
oCmp1 = cmp(oNum1,oNum2) # 比較演算は型が同じ事。実数型と整数型で比較するとError
oCmp2 = cmp(oNum1,oNum1)
oCmp3 = cmp(oNum2,oNum1)
oDisp = unicode('[ cmp関数 / 比較演算 ]','utf-8') + '\n\
' + 'cmp(' + str(oNum1) + ',' + str(oNum2) + ') = ' + str(oCmp1) + '\n\
' + 'cmp(' + str(oNum1) + ',' + str(oNum1) + ') = ' + str(oCmp2) + '\n\
' + 'cmp(' + str(oNum2) + ',' + str(oNum1) + ') = ' + str(oCmp3)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GMN-)[General]複数の比較演算
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oNum1 = 10.0
oNum2 = 3.0
oNum3 = 5.0
oDisp = u'[ 複数の比較演算 ]\n'
if oNum1 < oNum2 <= oNum3:
oDisp = oDisp + str(oNum1) + ' < ' + str(oNum2) + ' <= ' + str(oNum3)
elif oNum1 < oNum3 <= oNum2:
oDisp = oDisp + str(oNum1) + ' < ' + str(oNum3) + ' <= ' + str(oNum2)
elif oNum2 < oNum3 <= oNum1:
oDisp = oDisp + str(oNum2) + ' < ' + str(oNum3) + ' <= ' + str(oNum1)
elif oNum2 < oNum1 <= oNum3:
oDisp = oDisp + str(oNum2) + ' < ' + str(oNum1) + ' <= ' + str(oNum3)
elif oNum3 < oNum1 <= oNum2:
oDisp = oDisp + str(oNum3) + ' < ' + str(oNum1) + ' <= ' + str(oNum2)
elif oNum3 < oNum2 <= oNum1:
oDisp = oDisp + str(oNum3) + ' < ' + str(oNum2) + ' <= ' + str(oNum1)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'比較演算')
GMN-)[General]合計取得
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oIter = iter(range(1,11))
oList = range(1,11)
oStart = 7
oSum1 = sum(oIter)
oSum2 = sum(oIter,oStart) # = 0 + oStart
oSum3 = sum(oList,oStart) # = sum(oIter) + oStart
oFSum1 = math.fsum(oIter)
oFSum2 = math.fsum(oList)
oDisp = u'[ sum / math.fsum ]\n sum(iter(range(1,11))) = ' + str(oSum1) + '\n sum(iter(range(1,11)),7) = '\
+ str(oSum2) + '\n sum(range(1,11),7) = ' + str(oSum3) + '\n math.fsum(iter(range(1,11))) = ' + str(oFSum1)\
+ '\n math.fsum(range(1,11)) = ' + str(oFSum2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'合計')
#
# [ Note ]
# 1) Referenceにはsum(iterable[,start])とあるが[,start]はsum(iterable) + startである。
# 2) math.fsum は sumより厳密な和を返す。(和の桁落ちを防ぐ)
GMN-)[General]int型に変換可能かcheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr1 = '123'
oStr2 = '123a'
oStr3 = '123.45'
oStr4 = '+123'
oStr5 = '-123'
oIsNum1 = oStr1.isdigit()
oIsNum2 = oStr2.isdigit()
oIsNum3 = oStr3.isdigit()
oIsNum4 = oStr4.isdigit()
oIsNum5 = oStr5.isdigit()
oDisp = u'[ int型に変換可能かcheck ]\n\t'\
+ '1) ' + str(oStr1) + ' : oStr1.isgit() = ' + str(oIsNum1) + '\n\t'\
+ '2) ' + str(oStr2) + ' : oStr2.isgit() = ' + str(oIsNum2) + '\n\t'\
+ '3) ' + str(oStr3) + ' : oStr3.isgit() = ' + str(oIsNum3) + '\n\t'\
+ '4) ' + str(oStr4) + ' : oStr4.isgit() = ' + str(oIsNum4) + '\n\t'\
+ '5) ' + str(oStr5) + ' : oStr5.isgit() = ' + str(oIsNum5)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Int型への変換')
#
# [ Note ]
# 1) int()では整数以外の文字列を与えるとErrorになる。
# 2) isdisit()は小数点や+/-が含まれていてもFalseがreturnになる。
GMN-)[General]数値型( int / float / +,-付 )に変更可能かcheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oNumeric(num_str):
"""文字列を数値への変更"""
try:
if num_str == 0:
return 0
else:
oVal = float(num_str)
if oVal == int(oVal):
return int(oVal)
except ValueError:
return None
def oTest():
try:
oStr1 = '123'
oStr2 = '123a'
oStr3 = '123.45'
oStr4 = '+123'
oStr5 = '-123'
oIsNum1 = oNumeric(oStr1)
oIsNum2 = oNumeric(oStr2)
oIsNum3 = oNumeric(oStr3)
oIsNum4 = oNumeric(oStr4)
oIsNum5 = oNumeric(oStr5)
oDisp = u'[ 数値型に変換可能かcheck ]\n'\
+ "1) oNumeric('" + str(oStr1) + "') = " + str(oIsNum1) + '\n'\
+ "2) oNumeric('" + str(oStr2) + "') = " + str(oIsNum2) + '\n'\
+ "3) oNumeric('" + str(oStr3) + "') = " + str(oIsNum3) + '\n'\
+ "4) oNumeric('" + str(oStr4) + "') = " + str(oIsNum4) + '\n'\
+ "5) oNumeric('" + str(oStr5) + "') = " + str(oIsNum5)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'数値型への変換')
#
# exceptを利用して変換する。数値以外の値含まれているとfloat()でValueErrorが生じる事を利用している。
GMN-)[General]x に y の符号を付ける
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 50.0
oReal2 = -1.0
oRtn = math.copysign(oReal1,oReal2) # Returnは Integer
oDisp = u'[ copysign ]\n\t' + 'math.copysign(' + str(oReal1) + ',' + str(oReal2) + ')\n\t = ' + str(oRtn)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'x に y の符号を付ける')
#
# [ Note ]
# On a platform that supports signed zeros, copysign(1.0, -0.0) returns -1.0.
GMN-)[General]階乗
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oInt = 5 # Integerで無ければError。 0 も不可。
oRtn1 = math.factorial(oInt)
oRtn2 = 1
for i in [1,2,3,4,5]:
oRtn2 = oRtn2 * i
oDisp = u'[ 階乗 ]\n\t' + 'math.factorial(' + str(oInt) + ') = ' + str(oRtn1) + '\n\t' + u'1*2*3*4*5 = ' + str(oRtn2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'factorial')
GMN-)[General]仮数と指数のPair(x,y)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oFlt = 5.0 # Float型
oRtn1 = math.frexp(oFlt)
oDisp = u'[ 仮数と指数のPair ]\n\t' + 'math.frexp(' + str(oFlt) + ')\n\t = (x, y) = ' + str(oRtn1) + '\n\n\t ' + str(oFlt) + ' = x**2y'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'math.frexp')
GMN-)[General]x * (2**y)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oReal1 = 10.0
oInt1 = 2
oRtn1 = math.ldexp(oReal1,oInt1) # ver3.2で追加
oRtn11 = oReal1 * (2**oInt1)
oRtn2 = math.ldexp(oInt1,oInt1)
oRtn22 = oInt1 * (2**oInt1)
oDisp = u'[ x * (2**y) ]\n\t math.ldexp(' + str(oReal1) + ', ' + str(oInt1) + ') = ' + str(oRtn1) + ' : '\
+ str(oReal1) + ' * (2**' + str(oInt1) + ') = ' + str(oRtn11) + '\n\t '\
+ 'math.isfinite(' + str(oInt1) + ', ' + str(oInt1) + ') = ' + str(oRtn2) + ' : ' + str(oInt1) + ' * (2**' + str(oInt1) + ') = ' + str(oRtn22)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'x * (2**y)')
#
# [ Note ]
# math.ldexp(x, y) / y は Integer型
GMN-)[General]無限大かどうかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oFlt1 = 5.0
oFlt2 = -1.0
oRtn1 = math.isinf(float('Infinity')) # 無限大は float('inf') でもOK / 'Infinity'のみは不可 : ver3.2で追加
oRtn2 = math.isinf(oFlt1/oFlt2)
oDisp = u'[ 無限大 ]\n\t math.isinf(float(\'Infinity\')) = ' + str(oRtn1) + '\n\t '\
+ 'math.isinf(' + str(oFlt1) + ' / ' + str(oFlt2) + ') = ' + str(oRtn2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Infinity')
GMN-)[General]NaN( Not a number )Check
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oRtn1 = math.isnan(float('Infinity')) # ver3.2で追加
oRtn2 = math.isnan(5)
oRtn3 = math.isnan(float('nan'))
oDisp = u'[ Not a Number ]\n\t math.isnan(float(\'Infinity\')) = ' + str(oRtn1) + '\n\t ' + 'math.isnan(5) = ' + str(oRtn2) + '\n\t '\
+ 'math.isnan(float(\'nan\')) = ' + str(oRtn3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'NaN')
GMN-)[General]無限大 or NaNかどうかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oRtn1 = math.isfinite(float('Infinity')) # ver3.2で追加
oRtn2 = math.isfinite(math.pi)
oRtn3 = math.isfinite(float('nan'))
oDisp = u'[ 無限大 and NaN 以外]\n\t math.isfinite(float(\'Infinity\')) = ' + str(oRtn1) + '\n\t ' + 'math.isfinite(math.pi) = ' + str(oRtn2) + '\n\t '\
+ 'math.isfinite(float(\'nan\')) = ' + str(oRtn3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'無限大 or NaN')
#
# [ Note ]
# math.isfinite('LibreOffice') はError
GMN-)[General]角度変換
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oDec1 = 60 # 30 degree
oRad = math.radians(oDec1)
oDec2 = math.degrees(oRad)
oDisp = u'[ Degree ⇔ Radian ]\n\t' + str(oDec1) + u'°\n ⇒ ' + str(oRad) + u' [rad]\n ⇒ ' + str(oDec2) + u'°'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'角度変換')
GMN-)[General]三角関数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oDec1 = 30 # 30 degree
oRad = math.radians(oDec1)
oSin = math.sin(oRad)
oCos = math.cos(oRad)
oTan = math.tan(oRad)
oASin = math.degrees(math.asin(oSin))
oACos = math.degrees(math.acos(oCos))
oATan = math.degrees(math.atan(oTan))
oATan2 = math.atan2(-1, -1)
oHypot = math.hypot(-1, -1)
oDisp = u'[ 三角関数 ]\n\t 1) Sin(' + str(oDec1) + ') = ' + str(oSin) + '\n\t'\
+ ' 2) Cos(' + str(oDec1) + ') = ' + str(oCos) + '\n\t' + ' 3) Tan(' + str(oDec1) + ') = ' + str(oTan) + '\n\t'\
+ ' 4) ASin(' + str(oSin) + ') = ' + str(oASin) + u'°\n\t' + ' 5) ACos(' + str(oCos) + ') = ' + str(oACos) + u'°\n\t'\
+ ' 6) ATan(' + str(oTan) + ') = ' + str(oATan) + u'°\n\t' + ' 7) oATan2(-1,-1) = ' + str(oATan2) + '\n\t'\
+ u' 8) 原点から点(-1, -1) のベクトルの長さ = ' + str(oHypot)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Trigonometric function')
GMN-)[General]双曲線関数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oX = 10.0
oE = math.e
oSinH = math.sinh(oX)
oCosH = math.cosh(oX)
oTanH = math.tanh(oX)
oASinH = math.asinh(oSinH)
oACosH = math.acosh(oCosH)
oATanH = math.atanh(oTanH)
oSinH2 = (oE**oX - oE**(-1*oX))/2
oCosH2 = (oE**oX + oE**(-1*oX))/2
oDisp = u'[ 双曲線関数 ]\n\t 1) sinh(' + str(oX) + ') = ' + str(oSinH) + '\n\t'\
+ ' 2) cosh(' + str(oX) + ') = ' + str(oCosH) + '\n\t' + ' 3) tanh(' + str(oX) + ') = ' + str(oTanH) + '\n\t'\
+ ' 4) Asinh(' + str(oSinH) + ') = ' + str(oASinH) + u'°\n\t' + ' 5) Acosh(' + str(oCosH) + ') = ' + str(oACosH) + u'°\n\t'\
+ ' 6) ATan(' + str(oTanH) + ') = ' + str(oATanH) + u'°\n\t' + ' 7) (e**' + str(oX) + ' - e**' + str(oX) + ')/2 = ' + str(oSinH2) + '\n\t'\
+ u' 8) (e**' + str(oX) + ' + e**' + str(oX) + ')/2 = ' + str(oCosH2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Hyperbolic function')
GMN-)[General]誤差関数/相補誤差関数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oX = 10.0
oErf = math.erf(oX) # .erf / .erfc 共にver3.2で追加
oErfC1 = math.erfc(oX)
oErfC2 = 1.0 - math.erf(oX)
oDisp = u'[ 誤差関数/相補誤差関数 ]\n\t 1) 誤差関数\n\t math.erf(' + str(oX) + ') = ' + str(oErf) + '\n\n'\
+ u' 2) 相補誤差関数\n\t math.erfc(' + str(oX) + ') = ' + str(oErfC1) + '\n\t 1.0 - math.erf(' + str(oX) + ') = ' + str(oErfC2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Error function')
#
# [ Note ]
# 正規分布( Normal distribution )は以下で定義できる。
# def phi(x):
# 'Cumulative distribution function for the standard normal distribution'
# return (1.0 + erf(x / sqrt(2.0))) / 2.0
GMN-)[General]Gamma関数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import math
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oX = 10.0
oGma = math.gamma(oX) # 共にver3.2で追加
oLGma = math.lgamma(oX)
oDisp = u'[ Gamma関数 ]\n\t 1) Gamma関数\n\t math.gamma(' + str(oX) + ') = ' + str(oGma) + '\n\n\t'\
+ u' 2) x のGamma関数の絶対値の自然対数\n\t math.lgamma(' + str(oX) + ') = ' + str(oLGma)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Gamma function')
[ String ]
GDS-)[General]Source CodeのEncodeingを定義
Source CodeのEncodeingを定義するには、Source Codeの一行目か二行目に。
# coding: エンコーディング名
or
# coding=エンコーディング名
[ 例 ]
# -*- encoding: utf-8 -*-
# -*- encoding: cp932 -*-
GDS-)[General]記号（')1
#文字列はシングルまたはダブルのクォートで囲みます。
#使用例としては通常はシングルクォートを用い、シングルクォートが含まれる文字列を書く際にはダブルクォートを使う。
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
str = 'don\'t'
oDisp = str
omsgbox(oDisp)
str = "doesn't"
oDisp = str
omsgbox(oDisp)
except:
pass
GDS-)[General]改行
#文字列はシングルまたはダブルのクォートで囲みます
#使用例としては通常はシングルクォートを用い、シングルクォートが含まれる文字列を書く際にはダブルクォートを使う。
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
str = "Today is Sunday.\n\
It is fine."
oDisp = str
omsgbox(oDisp)
except:
pass
GDS-)[General]Tab( タブ )
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr = 'abc\tdefg'
oDisp = u'[ Tab(タブ) ]\n \'abc\\tdefg\' は\n' + oStr + u'\n と表示されます。'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Tab')
GDS-)[General]連結、反復
#文字列はシングルまたはダブルのクォートで囲みます
#使用例としては通常はシングルクォートを用い、シングルクォートが含まれる文字列を書く際にはダブルクォートを使う。
#
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
word = 'Help' + ' me! '
oDisp = '<' + word*5 + '>'
omsgbox(oDisp)
except:
pass
GDS-)[General]スライス表記
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
word = 'Help' + ' me! '
oDisp = word[1] # 2番目の文字
omsgbox(oDisp)
oDisp = word[2:4] # 3番目から4番目の文字
omsgbox(oDisp)
except:
pass
GDS-)[General]文字長さ
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
word = 'Help' + ' me! '
oDisp = len(word)
omsgbox(oDisp)
except:
pass
GDS-)[General]文字列に変換1
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
word = 'Number => '
oNumber = 1234
oDisp = word + str(oNumber)
omsgbox(oDisp)
except:
pass
GDS-)[General]文字列に変換2[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def otest():
try:
oNum = 0.1
#
oDisp = unicode('[ repr関数とstr関数の違い ]\n\n','utf-8')
oDisp = oDisp + 'str(' + str(oNum) + ') = ' + str(oNum) + '\n'
oDisp = oDisp + 'repr(' + str(oNum) + ') = ' + repr(oNum)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
#
# repr()はInterpriterで読める表現にする。表現出来ない場合はSyntaxErrorが搬出する。
# 特別なObject(文字列等)で無ければstr()と同じになる。
GDS-)[General]文字列に変換2[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def otest():
try:
oNum = 0.1
oDisp = u'[ repr関数とstr関数の違い ]\n\n str(' + str(oNum) + ') = ' + str(oNum) + '\n repr(' + str(oNum) + ') = ' + repr(oNum)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'repr関数')
# [ Python3.3 Documentより ]
# オブジェクトの印字可能な表現を含む文字列を返します。この関数は多くの型について、 eval() に渡されたときと同じ値を持つようなオブジェクトを表す文字列を生成しようとします。そうでない場合は、山括弧に囲まれたオブジェクトの型の名前と追加の情報 (大抵の場合はオブジェクトの名前とアドレスを含みます) を返します。クラスは、 __repr__() メソッドを定義することで、この関数によりそのクラスのインスタンスが返すものを制御することができます。
GDS-)[General]長いDataを省略して表示[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import repr
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
"""shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
#
def oTest():
try:
oRepr1 = repr.repr(set('supercalifraglisticexpilalidoccious'))
oRepr2 = repr.repr([1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0])
oDisp = u'[ repr表示 ]\n' + str(oRepr1) + '\n' + str(oRepr2)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]長いDataを省略して表示[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
import reprlib
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oRepr1 = reprlib.repr(set('supercalifraglisticexpilalidoccious'))
oRepr2 = reprlib.repr([1,2,3,4,5,6,7,8,9,0,1,2,3,4,5,6,7,8,9,0])
oDisp = u'[ 省略表示 ]\n' + str(oRepr1) + '\n' + str(oRepr2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'reprlib module')
GDS-)[General]文字列の検索1
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr = u'こんにちは(Hello)!!本日は晴天なり(Today is file.)'
fword_1 = u'は'
oInStr_1 = oStr.find(fword_1)
oInStr_2 = oStr.find(fword_1,oInStr_1+1)
oInStr_3 = oStr.find(fword_1,oInStr_2+1)
oDisp = u'[ 検索対象の文字列 ]\n' + oStr + '\n\n'\
+ '1) ' + u'検索文字 ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_1) + u' 番目\n'\
+ '2) ' + u'検索文字(2回目) ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_2) + u' 番目\n'\
+ '3) ' + u'検索文字(3回目) ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_3) + u' 番目'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'検索文字の位置')
#
# find(sub[, start[, end]])
# 文字列中の領域 [start, end] に 文字(sub) が含まれる場合、 その最小のIndex(文字位置)を返します。
# 文字が見つからなかった場合 -1 を返します。
GDS-)[General]文字列の検索2
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oInStr(dStart,dStr,dSch):
"""index関数"""
try:
oIdx = dStr.index(dSch,dStart)
return oIdx
except ValueError:
return 0
def oTest():
try:
oStr = u'こんにちは(Hello)!!本日は晴天なり(Today is file.)'
fword_1 = u'は'
oInStr_1 = oInStr(1,oStr,fword_1)
oInStr_2 = oInStr(oInStr_1+1,oStr,fword_1)
oInStr_3 = oInStr(oInStr_2+1,oStr,fword_1)
oDisp = u'[ 検索対象の文字列 / index ]\n' + oStr + '\n\n'\
+ '1) ' + u'検索文字 ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_1) + u' 番目\n'\
+ '2) ' + u'検索文字(2回目) ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_2) + u' 番目\n'\
+ '3) ' + u'検索文字(3回目) ： ' + fword_1 + u' ⇒ 左から ' + str(oInStr_3) + u' 番目'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'検索文字の位置')
#
# index(sub[, start[, end]])
# find() と同様ですが、sub が見つからなかった場合 ValueError を送出します。
GDS-)[General]文字列の先頭/末尾文字を調べる
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oChkWord = 'Summer has come!!'
# 大文字と小文字は区別される。
oCW = 'su'
oResult = oChkWord.startswith(oCW)
oPreDisp = oChkWord + u' の先頭文字は\n' + oCW + u' ⇒ '
# true: 1 / false: 0
if oResult == 1:
oDisp= oPreDisp + u' です'
else:
oDisp= oPreDisp + u' ではありません'
oEw = 'come!!'
oResult = oChkWord.endswith(oEw)
oSufDisp = oDisp + u'\n\n末尾文字は\n' + oEw + u' ⇒ '
# true: 1 / false: 0
if oResult == 1:
oDisp= oSufDisp + u' です'
else:
oDisp= oSufDisp + u' ではありません'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'先頭/末尾 文字Check')
GDS-)[General]文字列中に任意の文字が含まれているか
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oChkWord = u'夏が来た!!'
# 大文字と小文字は区別される。
oCW = u'来'
oResult = oCW in oChkWord
oPreDisp = oChkWord + u' に\n\t' + oCW
# true: 1 / false: 0
if oResult == 1:
oDisp= oPreDisp + u' は含まれる'
else:
oDisp= oPreDisp + u' は含まれない'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字Check')
GDS-)[General]文字列中の任意の文字数
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr = u'こんにちは(Hello)!!本日は晴天なり(Today is file.)'
fword_1 = u'は'
oCnt = oStr.count(fword_1,3,21) # ３文字目～21文字の間に 'は' の数
oDisp = u'[ 検索対象の文字数 ]\n' + oStr + '\n\n\t' + u'の3～21文字間に 「 ' + fword_1 + ' 」の数は、' + str(oCnt) + ' 回'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'検索文字の数')
GDS-)[General]大文字か小文字かCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = 'LIBREOFFICE'
oWord2 = 'libreoffice'
oWord3 = 'LibreOffice'
oUpper1 = str(oWord1.islower())
oUpper2 = str(oWord1.isupper())
oLower1 = str(oWord2.islower())
oLower2 = str(oWord2.isupper())
oCmpxL1 = str(oWord3.islower())
oCmpxU2 = str(oWord3.isupper())
oDisp = '[ ' + oWord1 + u' ] \n\t Upper Character ⇒ ' + oUpper1 + u'\n\t Upper Character ⇒ ' + oUpper2\
+ '\n\n[ ' + oWord2 + u' ]\n\t Lower Character ⇒ ' + oLower1 + u'\n\t Lower Character ⇒ ' + oLower2\
+ '\n\n[ ' + oWord3 + u' ]\n\t Lower Character ⇒ ' + oCmpxL1 + u'\n\t Upper Character ⇒ ' + oCmpxU2
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'大文字/小文字Check')
GDS-)[General]大文字化、小文字化
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = 'LibreOffice'
oLower = oWord1.lower()
oUpper = oWord1.upper()
oSwap = oWord1.swapcase()
oCasefold = oWord1.casefold() # ver.3.3 で追加
oDisp = oWord1 + u'\n\t ⇒ ' + oLower + ' ( .lower() )\n\n' + oWord1 + u'\n\t ⇒ ' + oUpper + '( .upper() )\n\n'\
+ oWord1 + u'\n\t ⇒ ' + oSwap + u'( .swapcase() )\n\n' + oWord1 + u'\n\t ⇒ ' + oCasefold + u'( .casefold() )'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'大文字化/小文字化')
GDS-)[General]先頭文字のみ大文字(1文字)
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'libreoffice'
oCap = oWord1.capitalize()
oDisp = '[ ' + oWord1 + ' ] \n\
=> ' + oCap
omsgbox(oDisp)
except:
pass
GDS-)[General]先頭文字のみ大文字(複数文字)[Title文字化]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = 'liBreOffice apache openOFFiCe'
oCap = oWord1.title()
oChkTitle1 = oWord1.istitle()
oChkTitle2 = oCap.istitle()
oDisp = u'[ Title文字化 ]\n' + oWord1 + u'\n ⇒ title文字 : ' + str(oChkTitle1) + u'\n\t ↓ \n'\
+ oCap + u'\n ⇒ title文字 : ' + str(oChkTitle2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Title文字')
GDS-)[General]文字列を1文字毎にする(英数字)
#!
# Coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oword = 'Summer has come / 2011' # forで使う場合、変数名の大文字はNG
oDisp = ''
for iw in oword:
oDisp = oDisp + iw + ' , '
omsgbox(oDisp)
except:
pass
GDS-)[General]文字列を1文字毎にする(日本語)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
ouniword = u'夏が来た / 2011'
oDisp = ''
for iw in ouniword: # forで使う場合、大文字はNG
oDisp = oDisp + iw + ' , '
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'1文字毎に分割')
GDS-)[General]文字列の分割
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oBfrWord = '＜ ＜ Summer has Come!! ＞ ＞\n夏が 来た!!'
oLftSplit = str(oBfrWord.split(' ',9)) # From left 9+1分割
oRgtSplit = str(oBfrWord.rsplit(' ',3)) # From right 3+1分割
oDisp= oBfrWord + u'\n ⇒ .split()\n' + oLftSplit + u'\n ⇒ .rsplit()\n' + oRgtSplit
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字列の分割')
#
# [ 注意 ]
# split([sep [,maxsplit]])
# sep を単語の境界として文字列を単語に分割し、分割された単語 からなるListを返します。
# (したがって返されるリストはmaxsplit+1 の要素を持ちます） maxsplit が与えられていない場合、
# 無制限に分割が行なわれます （全ての可能な分割が行なわれる）。
GDS-)[General]文字列を改行部分で分割
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr1 = u'Hello!!\nToday is fine.'
oStr2 = 'こんにちは!!\n本日は晴天なり'
oSplitLines1 = oStr1.splitlines()
oSplitLines2 = oStr2.splitlines()
oDisp = u'[ 半角英数字のみ ]\n' + oStr1 + '\n ⇒ ' + str(oSplitLines1) + '\n\n[ 全角文字 ]\n' + oStr2 + '\n ⇒ ' + str(oSplitLines2)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'改行部分で分割')
GDS-)[General]任意の文字で分割(Return : tuple型)
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord = u'Summer has come / 夏が来た'
oPatrt1 = oWord.partition(' ') # From left
oPatrt2 = oWord.rpartition(' ') # From right
oPatrt11 = oWord.partition(',') # Separate文字が無い場合は全文が、1つ目のtuple値
oPatrt22 = oWord.rpartition(',') # Separate文字が無い場合は全文が、3つ目のtuple値
oDisp = u'[ 文字列の分割 ]\n oWord : ' + oWord + u'\n\n oWord.partition(\' \') ⇒ ' + str(oPatrt1)\
+ u'\n\n oWord.rpartition(\' \') ⇒ ' + str(oPatrt2) + u'\n\n oWord.partition(\',\') ⇒ ' + str(oPatrt11)\
+ u'\n\n oWord.rpartition(\',\') ⇒ ' + str(oPatrt22)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字列の分割')
GDS-)[General]文字の前後の半角Spaceを取り除く[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'word1:'
oBfrWord = ' Summer has Come '
oWord2 = '!!'
oBefore = oWord1 + unicode(oBfrWord,'utf-8') + oWord2
oAftWord = oBfrWord.strip() # 全角Spaceは実行は出来るが処理が止まる。
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の前後の半角Spaceを取り除く[ 3.3系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord = u' \t\n Summer has come !! \n\t\t\t\t夏が来た/平成23年 \n\t '
oAftWord = oWord.strip()
oDisp = oWord + '\n\t ↓\n' + oAftWord
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字列の前後のSpace削除')
GDS-)[General]文字の先頭/末尾のSpaceを取り除く
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'word1:'
oBfrWord = u' Summer has Come '
oWord2 = u'!!'
oBefore = oWord1 + oBfrWord + oWord2
oLStrip = oBfrWord.lstrip()
oRStrip = oBfrWord.rstrip()
oLAfter = oWord1 + oLStrip + oWord2
oRAfter = oWord1 + oRStrip + oWord2
oDisp= u'[ 元の文字 ]\n' +oBefore + u'\n\n[ 先頭Space削除 ]\n' + oLAfter + u'\n\n[ 末尾Space削除 ]\n' + oRAfter
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Spaceの削除')
GDS-)[General]文字の置換
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'word1: '
oBfrWord = u'Summer has Come'
oWord2 = u'!!'
oBefore = oWord1 + oBfrWord + oWord2
oAftWord = oBfrWord.replace('Summer','Winter')
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n ⇒ \n' + oAfter
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字の置換')
GDS-)[General]複数文字の置換
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'word: '
oBfrWord1 = u'Summer has Come\n\t 夏が来た!!'
oBefore1 = oWord1 + oBfrWord1
oAftWord1 = oBfrWord1.translate(str.maketrans('Summer夏','Winter冬'))
oAfter1 = oWord1 + oAftWord1
oDisp= oBefore1 + u'\n ⇒ \n' + oAfter1
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'文字の置換')
GDS-)[General]文字の左に半角空白を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
oAftWord = oBfrWord.rjust(10)
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の右に半角空白を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
oAftWord = oBfrWord.ljust(20)
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の左右に半角空白を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
oAftWord = oBfrWord.center(25)
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の左に半角英数字/記号を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
# 追加する文字は半角英数字/記号の1文字のみ'0-a'等は不可
oAftWord = oBfrWord.rjust(20,'-')
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の右に半角英数字/記号を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
# 追加する文字は半角英数字/記号の1文字のみ'0-a'等は不可
oAftWord = oBfrWord.ljust(20,'0')
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]文字の左右に半角英数字/記号を追加する
#!
#coding: utf-8
# python Marco
import uno
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oWord1 = 'Word :'
oWord2 = '!!'
oBfrWord = 'Python'
oBefore = oWord1 + oBfrWord + oWord2
# 'Python Macro'等の様に複数Wordに対しては不可 / 元の文字数より少ない数を指定しても不可
# 追加する文字は半角英数字/記号の1文字のみ'0-a'等は不可
oAftWord = oBfrWord.center(20,'z')
oAfter = oWord1 + oAftWord + oWord2
oDisp= oBefore + '\n\
=> \n\
' + oAfter
omsgbox(oDisp)
except:
pass
GDS-)[General]Binary文字列
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oNum1 = 33
oNum2 = 65
oNum3 = 97
oBiny1 = bin(oNum1) # 整数型の事
oBiny2 = bin(oNum2)
oBiny3 = bin(oNum3)
oDisp = unicode('[ Binary文字列 ]','utf-8') + '\n\
' + str(oNum1) + ' => ' + unicode(oBiny1,'utf-8') + '\n\
' + str(oNum2) + ' => ' + unicode(oBiny2,'utf-8') + '\n\
' + str(oNum3) + ' => ' + unicode(oBiny3,'utf-8')
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]Unicode番号を文字列へ変換
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oNum1 = 33
oNum2 = 65
oNum3 = 97
oChar1 = chr(oNum1) # 整数型の事
oChar2 = chr(oNum2)
oChar3 = chr(oNum3)
oDisp = u'[ unicode番号 ⇒ 文字列 ]\n\t' + str(oNum1) + ' ⇒ ' + oChar1 + '\n\t' + str(oNum2) + ' ⇒ ' + oChar2\
+ '\n\t' + str(oNum3) + ' ⇒ ' + oChar3
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Unicode番号⇒文字列')
GDS-)[General]unicode番号を文字列へ変換[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oNum1 = 33
oNum2 = 65
oNum3 = 97
oChr1 = unichr(oNum1)
oChr2 = unichr(oNum2)
oChr3 = unichr(oNum3)
oDisp = unicode('[ unicode文字列 =＞ unicode code ]','utf-8') + '\n\
' + str(oNum1) + unicode(' =＞ ','utf-8') + str(oChr1) + '\n\
' + str(oNum2) + unicode(' =＞ ','utf-8') + str(oChr2) + '\n\
' + str(oNum3) + unicode(' =＞ ','utf-8') + str(oChr3)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]文字をUnicode番号へ変換
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'Summer has come / 2011'
oWord2 = u'夏が来た / 平成23年'
oDisp = u'[ Unicode Code Pointを表す整数へ変換 ]\n' + oWord1 + '\n ⇒ '
for iw in oWord1:
oDisp = oDisp + iw + ' = ' + str(ord(iw)) + '\t'
oDisp = oDisp + '\n\n' + oWord2 + '\n ⇒ '
for iw in oWord2:
oDisp = oDisp + iw + ' = ' + str(ord(iw)) + '\t'
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Unicode Code Point')
GDS-)[General]文字列をASCII Codeへ変換[ 2.7系 ]
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def oTest():
try:
oChar1 = '!'
oChar2 = 'A'
oChar3 = 'a'
oAsc1 = ord(oChar1)
oAsc2 = ord(oChar2)
oAsc3 = ord(oChar3)
oDisp = unicode('[ 文字列 => ASCII Code ]','utf-8') + '\n\
' + str(oChar1) + ' => ' + str(oAsc1) + '\n\
' + str(oChar2) + ' => ' + str(oAsc2) + '\n\
' + str(oChar3) + ' => ' + str(oAsc3)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]文字列の比較演算
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def otest():
try:
oStr1 = 'OpenOffice.org'
oStr2 = 'LibreOffice'
oCmp1 = cmp(oStr1,oStr2) # 比較演算は型が同じ事。実数型と整数型で比較するとError
oCmp2 = cmp(oStr1,oStr1)
oCmp3 = cmp(oStr2,oStr1)
oDisp = unicode('[ cmp関数 / 文字列の比較演算 ]','utf-8') + '\n\
' + 'cmp(\'' + oStr1 + '\',\'' + oStr2 + '\') = ' + str(oCmp1) + '\n\
' + 'cmp(\'' + oStr1 + '\',\'' + oStr1 + '\') = ' + str(oCmp2) + '\n\
' + 'cmp(\'' + oStr2 + '\',\'' + oStr1 + '\') = ' + str(oCmp3)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]複数の文字列の比較演算
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(message):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), 'messbox', 1, 'Title', message)
return msgbox.execute()
def otest():
try:
oStr1 = 'OpenOffice.org'
oStr2 = 'LibreOffice'
oStr3 = 'OOo / LO'
oDisp = unicode('[ 複数の文字列の比較演算 ]','utf-8') + '\n'
if oStr1 < oStr2 <= oStr3:
oDisp = oDisp + '\'' + oStr1 + '\'' + ' < ' + '\'' + oStr2 + '\'' + ' <= ' + '\'' + oStr3 + '\''
elif oStr1 < oStr3 <= oStr2:
oDisp = oDisp + '\'' + oStr1 + '\'' + ' < ' + '\'' + oStr3 + '\'' + ' <= ' + '\'' + oStr2 + '\''
elif oStr2 < oStr3 <= oStr1:
oDisp = oDisp + '\'' + oStr2 + '\'' + ' < ' + '\'' + oStr3 + '\'' + ' <= ' + '\'' + oStr1 + '\''
elif oStr2 < oStr1 <= oStr3:
oDisp = oDisp + '\'' + oStr2 + '\'' + ' < ' + '\'' + oStr1 + '\'' + ' <= ' + '\'' + oStr3 + '\''
elif oStr3 < oStr1 <= oStr2:
oDisp = oDisp + '\'' + oStr3 + '\'' + ' < ' + '\'' + oStr1 + '\'' + ' <= ' + '\'' + oStr2 + '\''
elif oStr3 < oStr2 <= oStr1:
oDisp = oDisp + '\'' + oStr3 + '\'' + ' < ' + '\'' + oStr2 + '\'' + ' <= ' + '\'' + oStr1 + '\''
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp)
GDS-)[General]文字列表記の計算
#!
#coding: utf-8
# python Marco
import sys
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
#
def oTest():
try:
oStr = '(1+2) * 4 /2 + 1'
oEval = eval(oStr)
oDisp = 'eval("' + str(oStr) + '") = ' + str(oEval)
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDS-)[General]join methodでList / 文字列を結合する1
#!
#coding: utf-8
# python Marco
import sys
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oList = ['1','temp','python','macro']
oStr = 'acbdefg'
oDelimiter = '/'
oJoinStr1 = oDelimiter.join(oList)
oJoinStr2 = oDelimiter.join(oStr)
oDisp = '1) ' + oJoinStr1 + '\n' + '2) ' + oJoinStr2
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
#
# [ 注意 ]
# 1) Pythonのjoin() methodはListでは無く、文字列のmethodとして用意されている。
GDS-)[General]join methodでList / 文字列を結合する2
#!
#coding: utf-8
# python Marco
import sys
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oDelimiter = '/'
oJoinStr1 = oDelimiter.join(str(x * x) for x in range(10))
oDisp = oJoinStr1
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDS-)[General]文字列からの文字抽出( Left / Mid / Right )
#!
#coding: utf-8
# python Marco
import sys
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oStr = u'こんにちは(Hello)!!本日は晴天なり(Today is file.)'
oLenStr = int(len(oStr))
oRStart = int(oLenStr - 3)
oLeft = oStr[0:3] # [Start:End] / Start: 0～、End: 1～
oMid = oStr[3:10]
oRight = oStr[oRStart:oLenStr]
oDisp = u'[ 文字列の一部を抽出 ]\n'\
+ '1) ' + u'Left抽出 ： ' + oLeft + '\n'\
+ '2) ' + u'Mid抽出 : ' + oMid + '\n'\
+ '3) ' + u'Right抽出 : ' + oRight
except:
oDisp = traceback.format_exc(sys.exc_info()[2])
finally:
omsgbox(oDisp,1)
GDS-)[General]Space＆記号が含まれていないか
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'平成２６年'
oWord2 = u'Ｈ２６年'
oWord3 = u'H26 ?'
oIsAlm1 = oWord1.isalnum()
oIsAlm2 = oWord2.isalnum()
oIsAlm3 = oWord3.isalnum()
oDisp= u'[ Ｓｐａｃｅ＆記号が含まれていないか? ]\n\t' + oWord1 + u' : ' + str(oIsAlm1) + '\n\t'\
+ oWord2 + u' : ' + str(oIsAlm2) + '\n\t' + oWord3 + u' : ' + str(oIsAlm3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Ｓｐａｃｅ＆記号')
GDS-)[General]Space＆記号＆数字が含まれていないかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'平成二十六年'
oWord2 = u'Ｈ２６'
oWord3 = u'冬季オリンピックYear!'
oIsAlp1 = oWord1.isalpha()
oIsAlp2 = oWord2.isalpha()
oIsAlp3 = oWord3.isalpha()
oDisp= u'[ Ｓｐａｃｅ＆記号＆数字が含まれていないか? ]\n\t' + oWord1 + u' : ' + str(oIsAlp1) + '\n\t'\
+ oWord2 + u' : ' + str(oIsAlp2) + '\n\t' + oWord3 + u' : ' + str(oIsAlp3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'Ｓｐａｃｅ＆記号＆数字')
GDS-)[General]識別子又はKeywordかどうかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'A'
oWord2 = u'&'
oWord3 = u'if'
oIsIfr1 = oWord1.isidentifier()
oIsIfr2 = oWord2.isidentifier()
oIsIfr3 = oWord3.isidentifier()
oDisp= u'[ 識別子又はKeywordかどうか? ]\n\t' + oWord1 + u' : ' + str(oIsIfr1) + '\n\t'\
+ oWord2 + u' : ' + str(oIsIfr2) + '\n\t' + oWord3 + u' : ' + str(oIsIfr3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'識別子又はKeyword')
#
# [ Note ]
# 識別子 (identifier) : A～Z, a～z, _, 先頭の文字を除く数字 0～9
# Keyword :
# False class finally is return
# None continue for lambda try
# True def from nonlocal while
# and del global not with
# as elif if or yield
# assert else import pass
# break except in raise
GDS-)[General]印字可能文字かどうかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = u'LibreOffice/日本語版'
oWord2 = u'∑'
oWord3 = u'\n'
oIsPrt1 = oWord1.isprintable()
oIsPrt2 = oWord2.isprintable()
oIsPrt3 = oWord3.isprintable()
oDisp= u'[ 印字可能文字かどうか? ]\n\t' + oWord1 + u' : ' + str(oIsPrt1) + '\n\t'\
+ oWord2 + u' : ' + str(oIsPrt2) + '\n\t' + oWord3 + u' : ' + str(oIsPrt3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'isprintable')
GDS-)[General]空白文字のみかどうかCheck
#!
#coding: utf-8
# python Marco
import uno
import sys
import traceback
from com.sun.star.awt import Rectangle
def omsgbox(oMessage='',oBtnType=1,oTitle='Title',oMsgType='messbox'):
# """shows message."""
desktop = XSCRIPTCONTEXT.getDesktop()
frame = desktop.getCurrentFrame()
window = frame.getContainerWindow()
toolkit = window.getToolkit()
msgbox = toolkit.createMessageBox(window, Rectangle(), oMsgType, oBtnType, oTitle, oMessage)
return msgbox.execute()
def oTest():
try:
oWord1 = ' '
oWord2 = u' \n\t '
oWord3 = u' \n Check'
oIsSpc1 = oWord1.isspace()
oIsSpc2 = oWord2.isspace()
oIsSpc3 = oWord3.isspace()
oDisp= u'[ 空白のみかどうか? ]\n\t' + oWord1 + u' : ' + str(oIsSpc1) + '\n\t'\
+ oWord2 + u' : ' + str(oIsSpc2) + '\n\t' + oWord3 + u' : ' + str(oIsSpc3)
except Exception as er:
oDisp = ''
oDisp = str(traceback.format_exc()) + '\n' + str(er)
finally:
omsgbox(oDisp,1,u'isspace')
GDS-)[General]
