LibreOffice Macros: Manipulation of Ranges - Validations by zenkly

View this thread on: hive.blog | peakd.com | ecency.com

utopian-io · @zenkly · Apr 26 '18 (edited)

$144.12

LibreOffice Macros: Manipulation of Ranges - Validations

![workstation-405768_1920.jpg](https://cdn.utopian.io/posts/3ed16cef6cf92def4f750671adc7a35ba91fworkstation-405768_1920.jpg)


<div class="text-justify">

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

* The use of different types of validation through *.ValidationType*.

* The use of different types of alerts through *.ValidationAlertStyle*.

* The application of the different types of conditional operators of *.ConditionOperator*.

* Manipulation of validation properties using *.TableValidation* service.

All derived from the *com.sun.star.sheet object*.

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

* 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
Either choose between the following options:

- Intermediate

#### Description
Previously, in a previous tutorial of this series I had shown how to apply validations using the UNO Service through the Dispatcher. Actually, that procedure only called the dialog box and the user had to fill in the parameters of the validation.

In the present tutorial we will explore the use of validations in a deeper way. We will assign each of the parameters directly in the range object. Within this learning session we will make use of the following services, properties and enumerations.

![Screenshot from 2018-04-25 12-12-15.png](https://cdn.utopian.io/posts/708ed2faf77ecdbcba70e5959c89cd049e91Screenshot_from_2018-04-25_12-12-15.png)
<center>[Source](https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ValidationType.html)</center>
![Screenshot from 2018-04-25 12-13-14.png](https://cdn.utopian.io/posts/749fa642b799150ad13c3a930c2a36f3c0b3Screenshot_from_2018-04-25_12-13-14.png)
<center>[Source](https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ValidationAlertStyle.html)</center>
![Screenshot from 2018-04-25 12-14-03.png](https://cdn.utopian.io/posts/172bfa3effb2dbde6e7b4b36ff459ab60695Screenshot_from_2018-04-25_12-14-03.png)
<center>[Source](https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ConditionOperator.html)</center>
![Screenshot from 2018-04-25 12-15-14.png](https://cdn.utopian.io/posts/1ffcfb510aa7d4f29c129f3e399c226cf6caScreenshot_from_2018-04-25_12-15-14.png)
<center>[Source](https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/TableValidation.html)</center>

Model examples will be provided so that you can apply this knowledge to your needs.

**The code generated for this tutorial can be consulted in the following link: [CODE](https://gist.github.com/Zenkly/781692d18570d434c18ffbf0119b1e1f)**

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

#### 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)

</div>

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@zenkly/libreoffice-macros-manipulation-of-ranges-validations">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>

👍 utopian-io, jaff8, mosqueteros, lourdeshd6, supreme-verdict, buckydurddle, clayjohn, mauriciovite, aderemi01, loshcat, alphacore, thinkingmind, skatitauriazul, tex73110, monster-reborn, thegrandestine, reciclajeymas, omegacore, skybreaker, sophiegeek, javisem, paradoxofchoice, soledadjc, polbot, love-me, retrocausality, butterfly-effect, chaostheory, aljoursantillan, mysticalword, betacore, mirrorforce, adelaida, hernanmrtnz, the-reaper, broadcaster, audiosiren, javicuesta, ubg, lilith, olivier10101, bharathi22, mirkosche, chain-reaction, greciav, ylv19, kittenpics, fermionico

properties (23)

author

zenkly

permlink

libreoffice-macros-manipulation-of-ranges-validations

category

utopian-io

json_metadata

"{"community":"utopian","app":"utopian/1.0.0","format":"markdown","repository":{"id":14021280,"name":"core","full_name":"LibreOffice/core","html_url":"https://github.com/LibreOffice/core","fork":false,"owner":{"login":"LibreOffice"}},"pullRequests":[],"platform":"github","type":"video-tutorials","tags":["utopian-io","openoffice","calc","macros","tutorial"],"users":["zenkly"],"links":["https://cdn.utopian.io/posts/3ed16cef6cf92def4f750671adc7a35ba91fworkstation-405768_1920.jpg","https://cdn.utopian.io/posts/708ed2faf77ecdbcba70e5959c89cd049e91Screenshot_from_2018-04-25_12-12-15.png","https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ValidationType.html","https://cdn.utopian.io/posts/749fa642b799150ad13c3a930c2a36f3c0b3Screenshot_from_2018-04-25_12-13-14.png","https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ValidationAlertStyle.html","https://cdn.utopian.io/posts/172bfa3effb2dbde6e7b4b36ff459ab60695Screenshot_from_2018-04-25_12-14-03.png","https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/ConditionOperator.html","https://cdn.utopian.io/posts/1ffcfb510aa7d4f29c129f3e399c226cf6caScreenshot_from_2018-04-25_12-15-14.png","https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/TableValidation.html","https://gist.github.com/Zenkly/781692d18570d434c18ffbf0119b1e1f","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"],"image":["https://cdn.utopian.io/posts/3ed16cef6cf92def4f750671adc7a35ba91fworkstation-405768_1920.jpg","https://cdn.utopian.io/posts/708ed2faf77ecdbcba70e5959c89cd049e91Screenshot_from_2018-04-25_12-12-15.png","https://cdn.utopian.io/posts/749fa642b799150ad13c3a930c2a36f3c0b3Screenshot_from_2018-04-25_12-13-14.png","https://cdn.utopian.io/posts/172bfa3effb2dbde6e7b4b36ff459ab60695Screenshot_from_2018-04-25_12-14-03.png","https://cdn.utopian.io/posts/1ffcfb510aa7d4f29c129f3e399c226cf6caScreenshot_from_2018-04-25_12-15-14.png"],"moderator":{"account":"rosatravels","time":"2018-04-26T04:37:48.534Z","pending":false,"reviewed":true,"flagged":false},"questions":null,"score":null,"total_influence":null,"staff_pick":null,"config":{"questions":[{"question":"How many substantial concepts does this tutorial address?","question_id":"vtuts-1","answers":[{"answer":"4-5 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-1","value":10},{"answer":"2-3 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-2","value":7},{"answer":"1 substantial concept covered in the tutorial.","answer_id":"vtuts-1-a-3","value":2},{"answer":"More than 5 substantial concepts covered in the tutorial.","answer_id":"vtuts-1-a-4","value":0}]},{"question":"How informative is the content included alongside the video?","question_id":"vtuts-2","answers":[{"answer":"Exceptionally good text and, when applicable, images for concepts covered.","answer_id":"vtuts-2-a-1","value":20},{"answer":"Thorough text and, if applicable, images for concepts covered.","answer_id":"vtuts-2-a-2","value":18},{"answer":"Minimal text and images.","answer_id":"vtuts-2-a-3","value":10},{"answer":"No or very little text and images.","answer_id":"vtuts-2-a-4","value":0}]},{"question":"Is the video clearly prepared and structured?","question_id":"vtuts-3","answers":[{"answer":"Both the presenter and the video are exceptionally organized, structured and presented","answer_id":"vtuts-3-a-1","value":20},{"answer":"Presenter is prepared and video concepts are structured.","answer_id":"vtuts-3-a-2","value":16},{"answer":"Presenter has moments when he/she seems unprepared and/or the content seems to be unstructured.","answer_id":"vtuts-3-a-3","value":8},{"answer":"Presenter seems unprepared and/or video is unstructured.","answer_id":"vtuts-3-a-4","value":0}]},{"question":"Does the contributor provide supplementary resources, such as code and sample files in the contribution post or a GitHub repository?","question_id":"vtuts-4","answers":[{"answer":"Contributor provided exceptional supplementary resources.","answer_id":"vtuts-4-a-1","value":5},{"answer":"Contributor provided good supplementary resources.","answer_id":"vtuts-4-a-2","value":4},{"answer":"Contributor provided minimal supplementary resources.","answer_id":"vtuts-4-a-3","value":1.5},{"answer":"No supplementary resources were provided.","answer_id":"vtuts-4-a-4","value":0}]},{"question":"How would you describe the sound quality of the video?","question_id":"vtuts-5","answers":[{"answer":"Sound quality is excellent and sounds professionally produced.","answer_id":"vtuts-5-a-1","value":10},{"answer":"The sound is clear and understandable with complimenting background music / sounds.","answer_id":"vtuts-5-a-2","value":8},{"answer":"Low quality of sound and/or mildly distracting background noise.","answer_id":"vtuts-5-a-3","value":3},{"answer":"Distracting background noise and/or very low quality recording.","answer_id":"vtuts-5-a-4","value":0}]},{"question":"Does the presenter speak clearly and is easy to understand?","question_id":"vtuts-6","answers":[{"answer":"Yes, presenter’s speech is highly engaging and professional.","answer_id":"vtuts-6-a-1","value":10},{"answer":"Yes, the voice-over is easy to understand.","answer_id":"vtuts-6-a-2","value":8},{"answer":"Only some of the voice-over was comprehensible.","answer_id":"vtuts-6-a-3","value":4},{"answer":"The voice-over was impossible to understand / not included at all.","answer_id":"vtuts-6-a-4","value":0}]},{"question":"Are the title of the tutorial and the concepts being covered present on the video in text overlay form?","question_id":"vtuts-7","answers":[{"answer":"Title and concepts covered are present in the video at all times in a non-disruptive way.","answer_id":"vtuts-7-a-1","value":5},{"answer":"Title and concepts covered appear temporarily when they are addressed.","answer_id":"vtuts-7-a-2","value":4.5},{"answer":"Only the title is presented and the concepts shown are not addressed in overlay text.","answer_id":"vtuts-7-a-3","value":2},{"answer":"Neither title nor concepts covered are presented in the video text overlay.","answer_id":"vtuts-7-a-4","value":0}]},{"question":"How would you describe the formatting, language and overall presentation of the post?","question_id":"c-1","answers":[{"answer":"The quality of the post is fantastic.","answer_id":"c-1-a-1","value":10},{"answer":"The post is of very good quality.","answer_id":"c-1-a-2","value":7},{"answer":"The post is poorly written and/or formatted, but readable.","answer_id":"c-1-a-3","value":3},{"answer":"The post is really hard to read and the content is barely understandable.","answer_id":"c-1-a-4","value":0}]},{"question":"How would you rate the overall value of this contribution on the open source community and ecosystem?","question_id":"c-2","answers":[{"answer":"This contribution brings great and impactful value, and can be used for applications outside the specific project.","answer_id":"c-2-a-1","value":20},{"answer":"This contribution adds significant value to the open source community and ecosystem, or is of critical importance to the specific project.","answer_id":"c-2-a-2","value":18},{"answer":"This contribution adds some value to the open source community and ecosystem or is only valuable to the specific project.","answer_id":"c-2-a-3","value":11},{"answer":"This contribution adds no value to the open source community and ecosystem or the specific project.","answer_id":"c-2-a-4","value":0}]}]}}"

created

2018-04-25 17:33:03

last_update

2018-04-26 04:37:51

depth

children

last_payout

2018-05-02 17:33:03

cashout_time

1969-12-31 23:59:59

total_payout_value

103.972 HBD

curator_payout_value

40.146 HBD

pending_payout_value

0.000 HBD

promoted

0.000 HBD

body_length

4,880

author_reputation

18,269,562,015,999

root_title

"LibreOffice Macros: Manipulation of Ranges - Validations"

beneficiaries

0.

`account`	utopian.pay
`weight`	1,500

max_accepted_payout

1,000,000.000 HBD

percent_hbd

10,000

post_id

52,105,758

net_rshares

25,424,352,628,371

author_curate_reward

vote details (48)

voter	rshares	pct
ubg	305,334,630	1%
mauriciovite	4,082,208,388	20%
alphacore	2,786,830,235	5%
lourdeshd6	20,286,424,698	100%
chaostheory	861,712,202	100%
butterfly-effect	882,057,785	100%
thegrandestine	1,686,807,410	100%
mirrorforce	645,275,728	100%
lilith	234,725,963	100%
mysticalword	737,340,326	100%
skatitauriazul	1,987,002,997	100%
paradoxofchoice	1,243,261,272	100%
betacore	732,765,877	100%
love-me	1,129,098,284	100%
omegacore	1,580,049,845	100%
ylv19	70,802,384	5.99%
kittenpics	60,633,839	25%
buckydurddle	9,661,189,240	26%
loshcat	2,896,919,665	100%
utopian-io	25,214,926,284,730	17.2%
jaff8	80,274,798,265	100%
javisem	1,301,778,869	100%
reciclajeymas	1,637,400,753	100%
tex73110	1,955,367,951	100%
thinkingmind	2,770,570,606	100%
audiosiren	374,808,914	100%
the-reaper	501,499,701	100%
adelaida	611,267,185	100%
aljoursantillan	792,129,651	100%
soledadjc	1,238,054,671	100%
skybreaker	1,533,089,052	100%
polbot	1,209,978,365	100%
mirkosche	116,268,147	26%
sophiegeek	1,388,712,156	100%
aderemi01	3,323,224,539	100%
hernanmrtnz	584,002,171	100%
supreme-verdict	20,252,347,347	100%
retrocausality	916,562,500	100%
fermionico	56,928,934	5.99%
greciav	91,682,550	14.97%
mosqueteros	26,270,965,193	29.95%
monster-reborn	1,734,539,524	100%
bharathi22	116,674,390	20%
chain-reaction	95,478,093	100%
olivier10101	167,322,701	100%
javicuesta	332,734,046	13%
clayjohn	7,440,626,686	100%
broadcaster	467,089,913	100%

@javisem · Apr 25 '18

Hermano un saludo! @jayoxaju y yo ya estamos de vuelta.

properties (22)

`author`	javisem
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180425t203722922z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["jayoxaju"],"app":"steemit/0.1"}
`created`	2018-04-25 20:36:51
`last_update`	2018-04-25 20:36:51
`depth`	1
`children`	2
`last_payout`	2018-05-02 20:36:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	55
`author_reputation`	8,246,678,978,265
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,130,305
`net_rshares`	0

@zenkly · Apr 27 '18

¡Que bueno Javi! Ya se les echaba de menos.

properties (22)

`author`	zenkly
`permlink`	re-javisem-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180427t135317340z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-27 13:53:18
`last_update`	2018-04-27 13:53:18
`depth`	2
`children`	1
`last_payout`	2018-05-04 13:53:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	43
`author_reputation`	18,269,562,015,999
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,459,645
`net_rshares`	0

@javisem · Apr 28 '18

gracias hermano querido, eres muy honesto con tu estima! :)

properties (22)

`author`	javisem
`permlink`	re-zenkly-re-javisem-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180428t100014494z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-28 10:00:21
`last_update`	2018-04-28 10:00:21
`depth`	3
`children`	0
`last_payout`	2018-05-05 10:00:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	59
`author_reputation`	8,246,678,978,265
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,615,016
`net_rshares`	0

@phillips93 · Apr 25 '18

Buen trabajo amigo saludos y exitos

properties (22)

`author`	phillips93
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180425t200238972z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-25 20:02:48
`last_update`	2018-04-25 20:02:48
`depth`	1
`children`	1
`last_payout`	2018-05-02 20:02:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	35
`author_reputation`	190,210,226,774
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,126,106
`net_rshares`	0

@zenkly · Apr 25 '18

¡Gracias!

properties (22)

`author`	zenkly
`permlink`	re-phillips93-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180425t202851520z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-25 20:28:51
`last_update`	2018-04-25 20:28:51
`depth`	2
`children`	0
`last_payout`	2018-05-02 20:28:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	9
`author_reputation`	18,269,562,015,999
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,129,351
`net_rshares`	0

@reciclajeymas · Apr 25 '18

Por aquí pasando a saludar y deseando sigas teniendo muchos éxitos en lo que emprendas, cuenta con mi apoyo. Saludos.

properties (22)

`author`	reciclajeymas
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180425t212435465z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-25 20:55:42
`last_update`	2018-04-25 20:55:42
`depth`	1
`children`	1
`last_payout`	2018-05-02 20:55:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	117
`author_reputation`	1,569,890,519,455
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,132,825
`net_rshares`	0

@zenkly · Apr 27 '18

Muchas gracias :D

properties (22)

`author`	zenkly
`permlink`	re-reciclajeymas-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180427t135352363z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-27 13:53:51
`last_update`	2018-04-27 13:53:51
`depth`	2
`children`	0
`last_payout`	2018-05-04 13:53:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	17
`author_reputation`	18,269,562,015,999
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,459,728
`net_rshares`	0

@rosatravels · Apr 26 '18

$0.74

Thank you for your contribution. It has been reviewed and scored.

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

**[[utopian-moderator]](https://utopian.io/moderators)**

👍 rosatravels

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
rosatravels	0 B		180,912,745,237	100%

@zenkly · Apr 26 '18

Thanks!

properties (22)

`author`	zenkly
`permlink`	re-rosatravels-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180426t060148022z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"community":"busy","app":"busy/2.4.0"}
`created`	2018-04-26 06:01:51
`last_update`	2018-04-26 06:01:51
`depth`	2
`children`	0
`last_payout`	2018-05-03 06:01:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	7
`author_reputation`	18,269,562,015,999
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,199,273
`net_rshares`	0

@utopian-io · Apr 27 '18

### Hey @zenkly! Thank you for the great work you've done!
We're already looking forward to your next contribution!
#### Fully Decentralized Rewards
We hope you will take the time to share your expertise and knowledge by rating contributions made by others on Utopian.io to help us reward the best contributions together.
#### Utopian Witness!
<a href="https://v2.steemconnect.com/sign/account-witness-vote?witness=utopian-io&approve=1">Vote for Utopian Witness!</a> We are made of developers, system administrators, entrepreneurs, artists, content creators, thinkers. We embrace every nationality, mindset and belief.

**Want to chat? Join us on Discord https://discord.me/utopian-io**

properties (22)

`author`	utopian-io
`permlink`	re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180427t210512928z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
`created`	2018-04-27 21:05:15
`last_update`	2018-04-27 21:05:15
`depth`	1
`children`	1
`last_payout`	2018-05-04 21:05:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	686
`author_reputation`	152,955,367,999,756
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,522,844
`net_rshares`	0

@zenkly · Apr 28 '18

$0.05

Thanks!

👍 zenkly

`author`	zenkly
`permlink`	re-utopian-io-re-zenkly-libreoffice-macros-manipulation-of-ranges-validations-20180428t065542133z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"app":"steemit/0.1"}
`created`	2018-04-28 06:55:42
`last_update`	2018-04-28 06:55:42
`depth`	2
`children`	0
`last_payout`	2018-05-05 06:55:42
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.054 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	7
`author_reputation`	18,269,562,015,999
`root_title`	"LibreOffice Macros: Manipulation of Ranges - Validations"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	52,591,694
`net_rshares`	8,856,959,523
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
zenkly	0 B		8,856,959,523	100%