Advertisement
dajare

LibreOffice Macro - straight quotes to curly

Oct 20th, 2012
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. sub StraightQuotes2CurlyQuotes
  2. rem ----------------------------------------------------------------------
  3. rem define variables
  4. dim document   as object
  5. dim dispatcher as object
  6. rem ----------------------------------------------------------------------
  7. rem get access to the document
  8. document   = ThisComponent.CurrentController.Frame
  9. dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
  10.  
  11. rem ----------------------------------------------------------------------
  12. dim args1(18) as new com.sun.star.beans.PropertyValue
  13. args1(0).Name = "SearchItem.StyleFamily"
  14. args1(0).Value = 2
  15. args1(1).Name = "SearchItem.CellType"
  16. args1(1).Value = 0
  17. args1(2).Name = "SearchItem.RowDirection"
  18. args1(2).Value = true
  19. args1(3).Name = "SearchItem.AllTables"
  20. args1(3).Value = false
  21. args1(4).Name = "SearchItem.Backward"
  22. args1(4).Value = false
  23. args1(5).Name = "SearchItem.Pattern"
  24. args1(5).Value = false
  25. args1(6).Name = "SearchItem.Content"
  26. args1(6).Value = false
  27. args1(7).Name = "SearchItem.AsianOptions"
  28. args1(7).Value = false
  29. args1(8).Name = "SearchItem.AlgorithmType"
  30. args1(8).Value = 1
  31. args1(9).Name = "SearchItem.SearchFlags"
  32. args1(9).Value = 65536
  33. args1(10).Name = "SearchItem.SearchString"
  34. args1(10).Value = CHR$(34)+"(\<|[\[\(])"
  35. args1(11).Name = "SearchItem.ReplaceString"
  36. args1(11).Value = "“$1"
  37. args1(12).Name = "SearchItem.Locale"
  38. args1(12).Value = 255
  39. args1(13).Name = "SearchItem.ChangedChars"
  40. args1(13).Value = 2
  41. args1(14).Name = "SearchItem.DeletedChars"
  42. args1(14).Value = 2
  43. args1(15).Name = "SearchItem.InsertedChars"
  44. args1(15).Value = 2
  45. args1(16).Name = "SearchItem.TransliterateFlags"
  46. args1(16).Value = 1280
  47. args1(17).Name = "SearchItem.Command"
  48. args1(17).Value = 3
  49. args1(18).Name = "Quiet"
  50. args1(18).Value = true
  51.  
  52. dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args1())
  53.  
  54. rem ----------------------------------------------------------------------
  55. dim args2(18) as new com.sun.star.beans.PropertyValue
  56. args2(0).Name = "SearchItem.StyleFamily"
  57. args2(0).Value = 2
  58. args2(1).Name = "SearchItem.CellType"
  59. args2(1).Value = 0
  60. args2(2).Name = "SearchItem.RowDirection"
  61. args2(2).Value = true
  62. args2(3).Name = "SearchItem.AllTables"
  63. args2(3).Value = false
  64. args2(4).Name = "SearchItem.Backward"
  65. args2(4).Value = false
  66. args2(5).Name = "SearchItem.Pattern"
  67. args2(5).Value = false
  68. args2(6).Name = "SearchItem.Content"
  69. args2(6).Value = false
  70. args2(7).Name = "SearchItem.AsianOptions"
  71. args2(7).Value = false
  72. args2(8).Name = "SearchItem.AlgorithmType"
  73. args2(8).Value = 1
  74. args2(9).Name = "SearchItem.SearchFlags"
  75. args2(9).Value = 65536
  76. args2(10).Name = "SearchItem.SearchString"
  77. args2(10).Value = "(\>|[,.;!?\]\)])"+CHR$(34)
  78. args2(11).Name = "SearchItem.ReplaceString"
  79. args2(11).Value = "$1”"
  80. args2(12).Name = "SearchItem.Locale"
  81. args2(12).Value = 255
  82. args2(13).Name = "SearchItem.ChangedChars"
  83. args2(13).Value = 2
  84. args2(14).Name = "SearchItem.DeletedChars"
  85. args2(14).Value = 2
  86. args2(15).Name = "SearchItem.InsertedChars"
  87. args2(15).Value = 2
  88. args2(16).Name = "SearchItem.TransliterateFlags"
  89. args2(16).Value = 1280
  90. args2(17).Name = "SearchItem.Command"
  91. args2(17).Value = 3
  92. args2(18).Name = "Quiet"
  93. args2(18).Value = true
  94.  
  95. dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args2())
  96.  
  97. rem ----------------------------------------------------------------------
  98. dim args3(18) as new com.sun.star.beans.PropertyValue
  99. args3(0).Name = "SearchItem.StyleFamily"
  100. args3(0).Value = 2
  101. args3(1).Name = "SearchItem.CellType"
  102. args3(1).Value = 0
  103. args3(2).Name = "SearchItem.RowDirection"
  104. args3(2).Value = true
  105. args3(3).Name = "SearchItem.AllTables"
  106. args3(3).Value = false
  107. args3(4).Name = "SearchItem.Backward"
  108. args3(4).Value = false
  109. args3(5).Name = "SearchItem.Pattern"
  110. args3(5).Value = false
  111. args3(6).Name = "SearchItem.Content"
  112. args3(6).Value = false
  113. args3(7).Name = "SearchItem.AsianOptions"
  114. args3(7).Value = false
  115. args3(8).Name = "SearchItem.AlgorithmType"
  116. args3(8).Value = 1
  117. args3(9).Name = "SearchItem.SearchFlags"
  118. args3(9).Value = 65536
  119. args3(10).Name = "SearchItem.SearchString"
  120. args3(10).Value = " '"
  121. args3(11).Name = "SearchItem.ReplaceString"
  122. args3(11).Value = " ‘"
  123. args3(12).Name = "SearchItem.Locale"
  124. args3(12).Value = 255
  125. args3(13).Name = "SearchItem.ChangedChars"
  126. args3(13).Value = 2
  127. args3(14).Name = "SearchItem.DeletedChars"
  128. args3(14).Value = 2
  129. args3(15).Name = "SearchItem.InsertedChars"
  130. args3(15).Value = 2
  131. args3(16).Name = "SearchItem.TransliterateFlags"
  132. args3(16).Value = 1280
  133. args3(17).Name = "SearchItem.Command"
  134. args3(17).Value = 3
  135. args3(18).Name = "Quiet"
  136. args3(18).Value = true
  137.  
  138. dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args3())
  139.  
  140. rem ----------------------------------------------------------------------
  141. dim args4(18) as new com.sun.star.beans.PropertyValue
  142. args4(0).Name = "SearchItem.StyleFamily"
  143. args4(0).Value = 2
  144. args4(1).Name = "SearchItem.CellType"
  145. args4(1).Value = 0
  146. args4(2).Name = "SearchItem.RowDirection"
  147. args4(2).Value = true
  148. args4(3).Name = "SearchItem.AllTables"
  149. args4(3).Value = false
  150. args4(4).Name = "SearchItem.Backward"
  151. args4(4).Value = false
  152. args4(5).Name = "SearchItem.Pattern"
  153. args4(5).Value = false
  154. args4(6).Name = "SearchItem.Content"
  155. args4(6).Value = false
  156. args4(7).Name = "SearchItem.AsianOptions"
  157. args4(7).Value = false
  158. args4(8).Name = "SearchItem.AlgorithmType"
  159. args4(8).Value = 1
  160. args4(9).Name = "SearchItem.SearchFlags"
  161. args4(9).Value = 65536
  162. args4(10).Name = "SearchItem.SearchString"
  163. args4(10).Value = "'"
  164. args4(11).Name = "SearchItem.ReplaceString"
  165. args4(11).Value = "’"
  166. args4(12).Name = "SearchItem.Locale"
  167. args4(12).Value = 255
  168. args4(13).Name = "SearchItem.ChangedChars"
  169. args4(13).Value = 2
  170. args4(14).Name = "SearchItem.DeletedChars"
  171. args4(14).Value = 2
  172. args4(15).Name = "SearchItem.InsertedChars"
  173. args4(15).Value = 2
  174. args4(16).Name = "SearchItem.TransliterateFlags"
  175. args4(16).Value = 1280
  176. args4(17).Name = "SearchItem.Command"
  177. args4(17).Value = 3
  178. args4(18).Name = "Quiet"
  179. args4(18).Value = true
  180.  
  181. dispatcher.executeDispatch(document, ".uno:ExecuteSearch", "", 0, args4())
  182.  
  183.  
  184. end sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement