com!online 2001 December/COMCD1201.iso/openoffice/f_0020/tools.xba

Extensible Markup Language | 2001-08-24 | 6.5 KB | 216 lines

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE script:module PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "module.dtd">
<script:module xmlns:script="http://openoffice.org/2000/script" script:name="tools" script:language="StarBasic">REM  *****  BASIC  *****
Option Explicit

Function SetProgressValue(iValue as Integer)
    If iValue = 0 Then
        oProgressbar.End
    End If
    ProgressValue = iValue
    oProgressbar.Value = iValue
End Function


Function GetPreferredWidth(oModel as Object, bGetMaxWidth as Boolean, Optional LocText)
Dim aPeerSize as new com.sun.star.awt.Size
Dim nWidth as Integer
Dim oControl as Object
' Todo: Wie geht das mit ImageControls
' kann nur fest verdrahtet werden
    If Not IsMissing(LocText) Then
        aPeerSize = GetPeerSize(oModel, oControl, LocText)
    Else
        aPeerSize = GetPeerSize(oModel, oControl)
    End If
    nWidth = aPeerSize.Width
    GetPreferredWidth = nWidth * XPixelFactor    ' PixelTo100thmm(nWidth)
End Function


Function GetPreferredHeight(oModel as Object, Optional LocText)
Dim aPeerSize as new com.sun.star.awt.Size
Dim nHeight as Integer
Dim oControl as Object
' Todo: Wie geht das mit ImageControls
    If Not IsMissing(LocText) Then
        aPeerSize = GetPeerSize(oModel, oControl, LocText)
    Else
        aPeerSize = GetPeerSize(oModel, oControl)
    End If
    nHeight = aPeerSize.Height
    GetPreferredHeight = nHeight * YPixelFactor     ' PixelTo100thmm(nHeight)
End Function



Function GetPeerSize(oModel as Object, oControl as Object, Optional LocText)
Dim oPeer as Object
Dim aPeerSize as new com.sun.star.awt.Size
    oControl = oController.GetControl(oModel)
    oPeer = oControl.GetPeer()
' Todo: Wie geht es bei Image Controls?
    If oControl.Model.PropertySetInfo.HasPropertybyName("EffectiveMax") Then
        If oControl.Model.EffectiveMax = 0 Then
            oControl.Model.EffectiveValue = 999.9999
        Else
            oControl.Model.EffectiveValue = oControl.Model.EffectiveMax
        End If
        aPeerSize = oPeer.PreferredSize()

    ElseIf Not IsMissing(LocText) Then
        oControl.Text = LocText
        aPeerSize = oPeer.PreferredSize()
    ElseIf CurFieldType = com.sun.star.sdbc.DataType.BIT Then
        oPeer.PreferredSize
        aPeerSize = oPeer.PreferredSize
    Else
        oControl.Text = "2222222222"
        aPeerSize = oPeer.PreferredSize()
        oControl.Text = ""
    End If
    GetPeerSize = aPeerSize
End Function


Function TwipToCM(BYVAL nValue as long) as String
    TwipToCM = trim(str(nValue / 567)) + "cm"
End function


Function TwipTo100telMM(BYVAL nValue as long) as long
     TwipTo100telMM = nValue / 0.567
End function


Function TwipToPixel(BYVAL nValue as long) as long ' nur ungefaehre Berechnung
    TwipToPixel = nValue / 15
End function


Function PixelTo100thMMX(oControl as Object) as long
    oPeer = oControl.GetPeer()
    PixelTo100mmX = Clng(Peer.GetInfo.PixelPerMeterX/100000)

'     PixelTo100thMM = nValue * 28        ' nur ungefähre Berechnung
End function


Function PixelTo100thMMY(oControl as Object) as long
    oPeer = oControl.GetPeer()
    PixelTo100mmX = Clng(Peer.GetInfo.PixelPerMeterY/100000)

'     PixelTo100thMM = nValue * 28        ' nur ungefähre Berechnung
End function


Function GetPoint(xPos, YPos) as New com.sun.star.awt.Point
Dim aPoint as New com.sun.star.awt.Point
    aPoint.X = xPos
    aPoint.Y = yPos
    GetPoint() = aPoint
End Function


Function GetSize(iWidth, iHeight) As New com.sun.star.awt.Size
Dim aSize As New com.sun.star.awt.Size
    aSize.Width = iWidth
    aSize.Height = iHeight
    GetSize() = aSize
End Function


Sub    ImportStyles()
Dim CurIndex as Integer
Dim sImportPath as String
Dim bWithBackGraphic as Boolean
    ToggleLayoutPage(False)
    oDocument.LockControllers
    CurIndex = GetCurIndex(oDialogModel.lstStyles, Styles(), NumberofStyles,8)
    sImportPath = Styles(8,CurIndex)
    bWithBackGraphic = LoadNewStyles(oDocument, oDialogModel, CurIndex, sImportPath, Styles(), TexturePath)
    ControlCaptionsToStandardLayout()
    ToggleOptionButtons(oDialogModel, bWithBackGraphic)
    ConfigurePageStyle()
    oDocument.UnlockControllers
    ToggleLayoutPage(True)
End Sub


Function SetNumerics(ByVal oLocObject as Object) as Object
    ' Todo: FS fragen, ob dies alles richtig ist
    ' Todo: Es sollte in der Hilfe darauf hingewiesen werden, dass der untere Wertbereich negativ ist.
    Select Case CurFieldType
        Case com.sun.star.sdbc.DataType.BIGINT
            oLocObOject.EffectiveMax = 2147483647 * 2147483647
            oLocbject.EffectiveMin = -(-2147483648 * -2147483648)
        Case com.sun.star.sdbc.DataType.INTEGER
            oLocObject.EffectiveMax = 2147483647
            oLocObject.EffectiveMin = -2147483648
        Case  com.sun.star.sdbc.DataType.SMALLINT
            oLocObject.EffectiveMax = 32767
            oLocObject.EffectiveMin = -32768
        Case com.sun.star.sdbc.DataType.TINYINT
            oLocObject.EffectiveMax = 127
            oLocObject.EffectiveMin = -128
        Case com.sun.star.sdbc.DataType.FLOAT, com.sun.star.sdbc.DataType.REAL, com.sun.star.sdbc.DataType.DOUBLE, com.sun.star.sdbc.DataType.DECIMAL, com.sun.star.sdbc.DataType.NUMERIC
        ' Todo: Hier sollte der Numberformatter angeworfen werden um die Nachkommastellen
        ' festzulegen, da ein EffectiveMax/EffectiveMin hier keinen Sinn macht
'            oLocObject.DecimalAccuracy = FieldDecimalAccuracy%(n%) ' Nachkommastellen
    End Select
End Function


' Destroy all Shapes in Nirwana
Sub RemoveShapes()
Dim n as Integer
Dim oControl as Object
Dim oShape as Object
    For n = oDrawPage.Count-1 To 0 Step -1
        oShape = oDrawPage(n)
        If oShape.Position.Y > -2000 Then
            oDrawPage.Remove(oShape)
        End If
    Next n
End Sub

' Note as Shapes cannot be removed from the DrawPage without destroying
' the object we have to park them somewhere in Nirwana
Sub ShapesToNirwana()
Dim n as Integer
Dim oControl as Object
    For n = 0 To oDrawPage.Count-1
        oDrawPage(n).Position = GetPoint(-20, -10000)
    Next n
End Sub


Function CalcUniqueContentName(BYVAL oContainer as Object, sBaseName as String) as String
Dim nPostfix as Integer
Dim sReturn as String
    nPostfix = 2
    sReturn = sBaseName

    while (oContainer.hasByName(sReturn))
        sReturn = sBaseName & nPostfix
        nPostfix = nPostfix + 1
    Wend
    CalcUniqueContentName = sReturn
End Function




Function CountItemsInArray(BigArray(), SearchItem)
Dim i as Integer
Dim MaxIndex as Integer
Dim ResCount as Integer
    ResCount = 0
    MaxIndex = Ubound(BigArray())
    For i = 0 To MaxIndex
        If SearchItem = BigArray(i) Then
            ResCount = ResCount + 1
        End If
    Next i
    CountItemsInArray() = ResCount
End Function                    </script:module>