summaryrefslogtreecommitdiff
path: root/wizards/source/euro/Writer.xba
diff options
context:
space:
mode:
authorMichael Stahl <mstahl@redhat.com>2012-01-28 20:52:45 +0100
committerMichael Stahl <mstahl@redhat.com>2012-01-28 20:52:45 +0100
commit2e626373db2412ac22e8c5c27a60d11cd29e875b (patch)
tree9e9f67205cd5b72f1031721273e1534a3a1e5b0f /wizards/source/euro/Writer.xba
parentf7ee7bbd5174b084f018c2ec94d8c70c98ee04da (diff)
replace obsolete "master" branch with README that points at new repoHEADmaster-deletedmaster
Diffstat (limited to 'wizards/source/euro/Writer.xba')
-rw-r--r--wizards/source/euro/Writer.xba72
1 files changed, 0 insertions, 72 deletions
diff --git a/wizards/source/euro/Writer.xba b/wizards/source/euro/Writer.xba
deleted file mode 100644
index 0d153b705..000000000
--- a/wizards/source/euro/Writer.xba
+++ /dev/null
@@ -1,72 +0,0 @@
-<?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="Writer" script:language="StarBasic">REM ***** BASIC *****
-
-
-Sub ConvertWriterTables()
-Dim CellString as String
-Dim oParagraphs as Object
-Dim oPara as Object
-Dim i as integer
-Dim sCellNames()
-Dim oCell as Object
- oParagraphs = oDocument.Text.CreateEnumeration
- While oParagraphs.HasMoreElements
- oPara = oParagraphs.NextElement
- If NOT oPara.supportsService(&quot;com.sun.star.text.Paragraph&quot;) Then
- &apos; Note: As cells might be splitted or merged
- &apos; you cannot refer to them via their indices
- sCellNames = oPara.CellNames
- For i = 0 To Ubound(sCellNames)
- If sCellNames(i) &lt;&gt; &quot;&quot; Then
- oCell = oPara.getCellByName(sCellNames(i))
- If CheckFormatType(oCell) Then
- SwitchNumberFormat(oCell, oFormats, sEuroSign)
- ModifyObjectValuewithCurrFactor(oCell)
- End If
- End If
- Next
- End If
- Wend
-End Sub
-
-
-Sub ModifyObjectValuewithCurrFactor(oDocObject as Object)
- oDocObjectValue = oDocObject.Value
- oDocObject.Value = oDocObjectValue/CurrFactor
-End Sub
-
-
-Sub ConvertTextFields()
-Dim oTextFields as Object
-Dim oTextField as Object
-Dim FieldValue
-Dim oDocObjectValue as double
-Dim InstanceNames(500) as String
-Dim CurInstanceName as String
-Dim MaxIndex as Integer
- MaxIndex = 0
- oTextfields = oDocument.getTextfields.CreateEnumeration
- While oTextFields.hasmoreElements
- oTextField = oTextFields.NextElement
- If oTextField.PropertySetInfo.HasPropertybyName(&quot;NumberFormat&quot;) Then
- If CheckFormatType(oTextField) Then
- If oTextField.PropertySetInfo.HasPropertybyName(&quot;Value&quot;) Then
- If Not oTextField.SupportsService(&quot;com.sun.star.text.TextField.GetExpression&quot;) Then
- oTextField.Content = CStr(Round(oTextField.Value/CurrFactor,2))
- End If
- ElseIf oTextField.TextFieldMaster.PropertySetInfo.HasPropertyByName(&quot;Value&quot;) Then
- CurInstanceName = oTextField.TextFieldMaster.InstanceName
- If Not FieldinArray(InstanceNames(), MaxIndex, CurInstanceName) Then
- oTextField.TextFieldMaster.Content = CStr(Round(oTextField.TextFieldMaster.Value/CurrFactor,2))
- InstanceNames(MaxIndex) = CurInstanceName
- MaxIndex = MaxIndex + 1
- End If
- End If
- SwitchNumberFormat(oTextField, oFormats, sEuroSign)
- End If
- End If
- Wend
- oDocument.GetTextFields.refresh()
-End Sub
-</script:module> \ No newline at end of file