LibreOffice Macros: Manipulation of Ranges - Search and Replacement. by zenkly

utopian-io · @zenkly · Jun 16 '18 (edited)

$11.88

LibreOffice Macros: Manipulation of Ranges - Search and Replacement.

![search-1013911_1920.jpg](https://cdn.steemitimages.com/DQmejEvFBCQbLirTKgHoxccLMjxQXUy2i3BGP8Tu5UA7vE2/search-1013911_1920.jpg)

<center>[Source](https://pixabay.com/en/search-to-find-internet-1013911/)</center>


<div class="text-justify">

#### Repository
https://github.com/LibreOffice/core

#### What Will I Learn?
In this video you will learn:

* How to perform simple searches and replacements.
* How to perform searches and replacements case sensitive.
* How to perform searches and replacements using defining similarity attributes.
* How to perform searches and replacements with complete words.
* How to manipulate the group of cells obtained by a search.

#### Requirements
The tutorial tries to be self-contained but it is necessary:

* [LibreOffice](https://www.libreoffice.org/)
* Intermediate knowledge of LibreOffice Calc
* Basic knowledge of programming
* This video is part of a series therefore the knowledge of the previous videos of the series is used.

#### Difficulty

- Intermediate

#### Description
In this video we will learn to perform searches and replacements within spreadsheets.

To achieve this we will use the search and replace descriptors. For the first of them we will explore the following properties.

![](https://cdn.steemitimages.com/DQmeKGo3GvfRmLag4DkBhso2URy9Hb4EnAWreTGdThM9tr9/imagen.png)
<center>[Source](http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/SearchDescriptor.html)</center>

By modifying these properties we will be able to make various replacements with the help of the second descriptor, in which we can use the properties of the first descriptor.

![](https://cdn.steemitimages.com/DQmXVEVAt9Lt4fAtu1Xd9qs9yJkk12PhecHohp21drJz7yE/imagen.png)
<center>[Source](http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/XReplaceDescriptor.html)</center>

Finally we will show how to directly manipulate the cells that are obtained as a result of the searches, through the following methods.

![](https://cdn.steemitimages.com/DQmRk1aBLJJ4mBa1ukxWRYrKFheTzxYKZ5Md8SxzGHSh2Tr/imagen.png)
<center>[Source](http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/XSearchable.html)</center>

#### Video Tutorial
https://youtu.be/FPSO8pC6LiM

#### Curriculum
Although the current video is in English, some of the previous videos are in Spanish. You can find the other videos of the series in the following links:

- [Introducción a las macros en LibreOffice](https://utopian.io/utopian-io/@zenkly/introduccion-a-las-macros-en-libreoffice)
- [LibreOffice Macros. Variables](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-variables)
- [LibreOffice Macros. Variables Variant, constantes, variables de usuario y bloque With.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-variables-variant-constantes-variables-de-usuario-y-bloque-with-zenkly)     
- [LibreOffice Macros. Arreglos parte 1](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-parte-1)
- [LibreOffice Macros. Arreglos 2: Redimensionamientos.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-2-redimensionamientos)
- [LibreOffice Macros. Arreglos 3: Errores comunes](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-3-errores-comunes-copiado-por-valor-y-copiado-por-referencia)
- [LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-introducing-libreoffice-calc-objects-and-how-to-use-the-dispatcher-automatic-creation-of-tables-with)
- [LibreOffice Macros: Manipulation of spreadsheets](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-spreadsheets)
- [LibreOffice Macros: Manipulation of cells.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-cells)
- [LibreOffice Macros: Manipulation of cells 2.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-cells-2)
- [LibreOffice Macros: Manipulation of Annotations.](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-annotations)
- [LibreOffice Macros: Manipulation of Ranges - Validations](https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-ranges-validations)
- [LibreOffice Macros: Manipulation of Ranges - Conditional Formatting and Queries](https://steemit.com/utopian-io/@zenkly/libreoffice-macros-manipulation-of-ranges-conditional-formatting-and-queries-1)

#### Proof of Work Done
https://gist.github.com/Zenkly/805e7b19a66c14dcba5d7da104da1388

</div>

👍 utopian-io, jaff8, elteamgordo, tensor, mosqueteros, trupvote, mauriciovite, bursatilonline, qurator-tier-0, yuxi, reciclajeymas, strings, mvanyi, atheneav, sophiegeek, jayoxaju, leir, shadowmyst, sertes, wailibis, drinkschin, batchjocular, liquidmeat, ogergami, broadcaster, adelaida, walrusaromatic, maruse4ka, javisem, shirani, properfraction, dariuska2008, sheikhsayem, proyectocrecer, steemit-mexico, ethemkibar, mariart1, steemitboard, ornitorenk, polbot, marcopasha, karinquintero, greciav, oscarina, carloslgonzalez, teaholik, angiemargelews

properties (23)

`post_id`	53,186,225
`author`	zenkly
`permlink`	libreoffice-macros-manipulation-of-ranges-search-and-replacement
`category`	utopian-io
`json_metadata`	"{"image": ["https://cdn.steemitimages.com/DQmeKGo3GvfRmLag4DkBhso2URy9Hb4EnAWreTGdThM9tr9/imagen.png"], "format": "markdown", "app": "steemit/0.1", "tags": ["utopian-io", "video-tutorials", "openoffice", "calc", "macros"], "links": ["https://github.com/LibreOffice/core", "https://www.libreoffice.org/", "http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/SearchDescriptor.html", "http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/XReplaceDescriptor.html", "http://www.openoffice.org/api/docs/common/ref/com/sun/star/util/XSearchable.html", "https://youtu.be/FPSO8pC6LiM", "https://utopian.io/utopian-io/@zenkly/introduccion-a-las-macros-en-libreoffice", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-variables", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-variables-variant-constantes-variables-de-usuario-y-bloque-with-zenkly", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-parte-1", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-2-redimensionamientos", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-arreglos-3-errores-comunes-copiado-por-valor-y-copiado-por-referencia", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-introducing-libreoffice-calc-objects-and-how-to-use-the-dispatcher-automatic-creation-of-tables-with", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-spreadsheets", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-cells", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-cells-2", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-annotations", "https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-ranges-validations", "https://steemit.com/utopian-io/@zenkly/libreoffice-macros-manipulation-of-ranges-conditional-formatting-and-queries-1", "https://gist.github.com/Zenkly/805e7b19a66c14dcba5d7da104da1388"]}"
`created`	2018-06-16 05:42:03
`last_update`	2018-06-16 06:01:21
`depth`	0
`children`	18
`net_rshares`	4,772,546,623,786
`last_payout`	2018-06-23 05:42:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	9.078 SBD
`curator_payout_value`	2.806 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	4,586
`author_reputation`	12,686,251,981,032
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

vote details (47)

voter	rshares	pct
yuxi	2,675,458,893	10%
shadowmyst	647,084,665	100%
mauriciovite	13,840,486,821	12%
steemitboard	373,459,290	1%
elteamgordo	27,984,182,341	100%
tensor	25,917,038,793	100%
bursatilonline	5,984,392,776	100%
leir	688,156,579	20%
utopian-io	4,568,079,436,430	3%
jaff8	58,210,368,098	100%
shirani	597,934,589	100%
ethemkibar	459,207,535	100%
javisem	599,008,488	100%
jayoxaju	975,694,920	100%
reciclajeymas	2,120,069,254	100%
mvanyi	1,563,688,387	100%
teaholik	55,125,245	10%
atheneav	1,516,673,397	100%
oscarina	85,609,171	15.53%
strings	1,889,572,976	100%
adelaida	611,267,185	100%
angiemargelews	0	100%
steemit-mexico	500,520,126	100%
polbot	227,077,632	100%
sophiegeek	1,392,279,671	100%
ornitorenk	306,120,571	100%
properfraction	590,463,046	100%
carloslgonzalez	70,094,278	15.53%
greciav	94,559,734	15.53%
mosqueteros	23,593,813,709	31.07%
marcopasha	226,097,840	100%
ogergami	611,567,587	100%
qurator-tier-0	5,543,355,061	1%
mariart1	439,361,550	100%
trupvote	17,366,126,166	100%
sheikhsayem	563,798,936	100%
sertes	613,245,303	100%
broadcaster	611,350,222	100%
maruse4ka	609,941,427	100%
dariuska2008	584,006,289	100%
walrusaromatic	609,941,427	100%
proyectocrecer	532,710,819	100%
karinquintero	137,441,482	24.85%
drinkschin	612,188,822	100%
liquidmeat	612,151,469	100%
batchjocular	612,155,860	100%
wailibis	612,338,926	100%

@biblegateway · Jun 16 '18

God bless you. https://steemit.com/@biblegateway

properties (22)

`post_id`	53,186,257
`author`	biblegateway
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180616t054220564z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"], "links": ["https://steemit.com/@biblegateway"]}"
`created`	2018-06-16 05:42:27
`last_update`	2018-06-16 05:42:27
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-23 05:42:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	48
`author_reputation`	-1,829,035,868,014
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@steemitboard · Jun 16 '18

Congratulations @zenkly! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

[![](https://steemitimages.com/70x80/http://steemitboard.com/notifications/votes.png)](http://steemitboard.com/@zenkly) Award for the number of upvotes

<sub>_Click on the badge to view your Board of Honor._</sub>
<sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub>


To support your work, I also upvoted your post!


**Do not miss the [last post](https://steemit.com/steemitboard/@steemitboard/steemitboard-world-cup-contest-croatia-vs-nigeria) from @steemitboard!**

---
**Participate in the [SteemitBoard World Cup Contest](https://steemit.com/steemitboard/@steemitboard/steemitboard-world-cup-contest-collect-badges-and-win-free-sbd)!**
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: [@good-karma](https://v2.steemconnect.com/sign/account-witness-vote?witness=good-karma&approve=1) and [@lukestokes](https://v2.steemconnect.com/sign/account-witness-vote?witness=lukestokes.mhth&approve=1)

---

> Do you like [SteemitBoard's project](https://steemit.com/@steemitboard)? Then **[Vote for its witness](https://v2.steemconnect.com/sign/account-witness-vote?witness=steemitboard&approve=1)** and **get one more award**!

properties (22)

`post_id`	53,190,233
`author`	steemitboard
`permlink`	steemitboard-notify-zenkly-20180616t064453000z
`category`	utopian-io
`json_metadata`	"{"image": ["https://steemitboard.com/img/notify.png"]}"
`created`	2018-06-16 06:44:51
`last_update`	2018-06-16 06:44:51
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-23 06:44:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	1,324
`author_reputation`	38,705,954,145,809
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@phillips93 · Jun 16 '18

Greetings friend how good you are back with us

properties (22)

`post_id`	53,221,823
`author`	phillips93
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180616t141556628z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-16 14:16:03
`last_update`	2018-06-16 14:16:03
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-23 14:16:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	46
`author_reputation`	190,059,196,496
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@phillips93 · Jun 16 '18

Greetings friend how good you are back with us

properties (22)

`post_id`	53,223,125
`author`	phillips93
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180616t143208887z
`category`	utopian-io
`json_metadata`	"{"tags": ["utopian-io"], "app": "steemit/0.1"}"
`created`	2018-06-16 14:32:18
`last_update`	2018-06-16 14:32:18
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-23 14:32:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	46
`author_reputation`	190,059,196,496
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@reciclajeymas · Jun 16 '18

Me alegra mucho verte de vuelta  ◠‿◠  te he extrañado, sabes cuanto tengo que no visito un museo? un sitio lindo contigo? estoy feliz de tu regreso,  te envío un gran abrazo

properties (22)

`post_id`	53,234,387
`author`	reciclajeymas
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180616t163347900z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-16 16:33:48
`last_update`	2018-06-16 16:33:48
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2018-06-23 16:33:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	173
`author_reputation`	1,568,756,562,371
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@zenkly · Jun 17 '18

Muchas gracias por tus palabras, las aprecio mucho. Espero estar de nuevo activo. =D

properties (22)

`post_id`	53,344,340
`author`	zenkly
`permlink`	re-reciclajeymas-re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180617t172604197z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-17 17:26:03
`last_update`	2018-06-17 17:26:03
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-24 17:26:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	84
`author_reputation`	12,686,251,981,032
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@proyectocrecer · Jun 17 '18

Nos contenta mucho verlo activo y en continuo apoyo a la comunidad.

##

<center>![minilogo.png](https://cdn.steemitimages.com/DQmTkPYUjEd3azohzy7XxwMVveQ1D88PhmVjDFVZjVwQzhi/minilogo.png)</center>

properties (22)

`post_id`	53,349,620
`author`	proyectocrecer
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180617t182415098z
`category`	utopian-io
`json_metadata`	"{"image": ["https://cdn.steemitimages.com/DQmTkPYUjEd3azohzy7XxwMVveQ1D88PhmVjDFVZjVwQzhi/minilogo.png"], "app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-17 18:24:42
`last_update`	2018-06-17 18:24:42
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2018-06-24 18:24:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	197
`author_reputation`	4,084,238,652
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@zenkly · Jun 19 '18

Gracias =)

properties (22)

`post_id`	53,586,161
`author`	zenkly
`permlink`	re-proyectocrecer-re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180619t180139390z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-19 18:01:39
`last_update`	2018-06-19 18:01:39
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-26 18:01:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	10
`author_reputation`	12,686,251,981,032
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@bursatilonline · Jun 17 '18

Que bueno que estas nuevamente activo.... trayendo magnifico material. Nuestro humilde servidor Proyecto Crecer te da todo el apoyo del mundo esperando tenerte más seguido haciendo post en steemit.

properties (22)

`post_id`	53,349,875
`author`	bursatilonline
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180617t182704833z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-17 18:27:33
`last_update`	2018-06-17 18:27:33
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-24 18:27:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	197
`author_reputation`	3,467,368,504,525
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@dariuska2008 · Jun 17 '18

Me habían comentado lo bueno que son tus post, la verdad que se quedaron cortos con lo que me habían comentado, que bueno que vuelvas a estar activo en la plataforma... Un saludo de parte de Proyecto Crecer y de esta humilde servidora

properties (22)

`post_id`	53,353,643
`author`	dariuska2008
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180617t190838592z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-17 19:08:36
`last_update`	2018-06-17 19:08:36
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2018-06-24 19:08:36
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	234
`author_reputation`	1,116,291,911,150
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@zenkly · Jun 19 '18

Muchas gracias =). Saludos

properties (22)

`post_id`	53,586,208
`author`	zenkly
`permlink`	re-dariuska2008-re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180619t180207786z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-19 18:02:06
`last_update`	2018-06-19 18:02:06
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-26 18:02:06
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	26
`author_reputation`	12,686,251,981,032
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@mariart1 · Jun 17 '18

Hola, vi su nombre en el servidor de proyecto crecer y me encantaría apoyarlo

properties (22)

`post_id`	53,368,406
`author`	mariart1
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180617t221558221z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-17 22:16:00
`last_update`	2018-06-17 22:16:00
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2018-06-24 22:16:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	77
`author_reputation`	1,159,963,822,467
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@zenkly · Jun 19 '18

Muchas gracias

properties (22)

`post_id`	53,586,245
`author`	zenkly
`permlink`	re-mariart1-re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180619t180227121z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"]}"
`created`	2018-06-19 18:02:27
`last_update`	2018-06-19 18:02:27
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-26 18:02:27
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	14
`author_reputation`	12,686,251,981,032
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@rosatravels · Jun 18 '18 (edited)

$3.27

Hi @zenkly

Thank you for your contribution. Please note the following before you contribute the next video tutorial:

- Your tutorial is very basic.  You need to go into deeper concepts that are not found on the internet.

- Your screenshots in this tutorial are not even your own work. No proper explanation is given.

- Screenshots are only valuable if you provide your own tutorial teaching that is related to the video tutorial.  So please do not just post screenshots from other sites.  All tutorial material needs to be your own work.

- You need to work out an outline and structure of the concepts you want to teach.  Presently no work flow is shown in what you want to teach in this tutorial.


Your contribution has been evaluated according to [Utopian policies and guidelines](https://join.utopian.io/guidelines), as well as a predefined set of questions pertaining to the category.

To view those questions and the relevant answers related to your post, [click here](https://review.utopian.io/result/9/344433334).

---- 
Need help? Write a ticket on https://support.utopian.io/. 
Chat with us on [Discord](https://discord.gg/uTyJkNm). 
[[utopian-moderator]](https://join.utopian.io/)

👍 utopian-io, shirani

`post_id`	53,408,221
`author`	rosatravels
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180618t072327821z
`category`	utopian-io
`json_metadata`	"{"app": "steemit/0.1", "tags": ["utopian-io"], "users": ["zenkly"], "links": ["https://join.utopian.io/guidelines", "https://review.utopian.io/result/9/344433334", "https://support.utopian.io/", "https://discord.gg/uTyJkNm", "https://join.utopian.io/"]}"
`created`	2018-06-18 07:23:30
`last_update`	2018-06-18 07:49:00
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2018-06-25 07:23:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	2.454 SBD
`curator_payout_value`	0.816 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	1,196
`author_reputation`	446,683,592,150,961
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000
`author_curate_reward`	""

properties (23)vote details (2)

voter	weight	wgt%	rshares	pct	time
utopian-io	0 B		1,523,666,273,929	1%
shirani	0 B		610,137,336	100%

@utopian-io · Jun 18 '18

Hey @rosatravels
Here's a tip for your valuable feedback! @Utopian-io loves and incentivises informative comments.

**Contributing on Utopian**
Learn how to contribute on <a href="https://join.utopian.io">our website</a>.

**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**

<a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for Utopian Witness!</a>

properties (22)

`post_id`	53,426,273
`author`	utopian-io
`permlink`	20180618t110512576z
`category`	utopian-io
`json_metadata`	"{"tags": ["utopian.tip"], "app": "utopian-io"}"
`created`	2018-06-18 11:05:12
`last_update`	2018-06-18 11:05:12
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2018-06-25 11:05:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	411
`author_reputation`	152,913,012,544,965
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@utopian-io · Jun 18 '18

Hey @zenkly
**Thanks for contributing on Utopian**.
We’re already looking forward to your next contribution!

**Contributing on Utopian**
Learn how to contribute on <a href='https://join.utopian.io'>our website</a> or by watching <a href='https://www.youtube.com/watch?v=8S1AtrzYY1Q'>this tutorial</a> on Youtube.

**Want to chat? Join us on Discord https://discord.gg/h52nFrV.**

<a href='https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1'>Vote for Utopian Witness!</a>

properties (22)

`post_id`	53,408,358
`author`	utopian-io
`permlink`	re-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180618t072508z
`category`	utopian-io
`json_metadata`	"{"app": "beem/0.19.29"}"
`created`	2018-06-18 07:25:09
`last_update`	2018-06-18 07:25:09
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-25 07:25:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	503
`author_reputation`	152,913,012,544,965
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000

@javisem · Jun 20 '18

Hermano muy buen aporte me alegra saber que estas de regreso! :)

properties (22)

@jayoxaju · Jun 20 '18

Volvisteeeeeeeeee!!!! que felicidad :D

properties (22)

`post_id`	53,719,751
`author`	jayoxaju
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-search-and-replacement-20180620t195818624z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit\/0.1"}
`created`	2018-06-20 19:59:24
`last_update`	2018-06-20 19:59:24
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2018-06-27 19:59:24
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	38
`author_reputation`	1,498,150,886,337
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Search and Replacement."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 SBD
`percent_steem_dollars`	10,000