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
- 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.
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.
Finally we will show how to directly manipulate the cells that are obtained as a result of the searches, through the following methods.
Video Tutorial
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
- LibreOffice Macros. Variables
- LibreOffice Macros. Variables Variant, constantes, variables de usuario y bloque With.
- LibreOffice Macros. Arreglos parte 1
- LibreOffice Macros. Arreglos 2: Redimensionamientos.
- LibreOffice Macros. Arreglos 3: Errores comunes
- LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.
- LibreOffice Macros: Manipulation of spreadsheets
- LibreOffice Macros: Manipulation of cells.
- LibreOffice Macros: Manipulation of cells 2.
- LibreOffice Macros: Manipulation of Annotations.
- LibreOffice Macros: Manipulation of Ranges - Validations
- LibreOffice Macros: Manipulation of Ranges - Conditional Formatting and Queries
Proof of Work Done
https://gist.github.com/Zenkly/805e7b19a66c14dcba5d7da104da1388
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, 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.
Need help? Write a ticket on https://support.utopian.io/.
Chat with us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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 our website.
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Greetings friend how good you are back with us
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Greetings friend how good you are back with us
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Muchas gracias por tus palabras, las aprecio mucho. Espero estar de nuevo activo. =D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nos contenta mucho verlo activo y en continuo apoyo a la comunidad.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Gracias =)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @zenkly! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on the badge to view your Board of Honor.
If you no longer want to receive notifications, reply to this comment with the word
STOPTo support your work, I also upvoted your post!
Do not miss the last post from @steemitboard!
Participate in the SteemitBoard World Cup Contest!
Collect World Cup badges and win free SBD
Support the Gold Sponsors of the contest: @good-karma and @lukestokes
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Muchas gracias =). Saludos
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hola, vi su nombre en el servidor de proyecto crecer y me encantaría apoyarlo
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Muchas gracias
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @zenkly
Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!
Contributing on Utopian
Learn how to contribute on our website or by watching this tutorial on Youtube.
Want to chat? Join us on Discord https://discord.gg/h52nFrV.
Vote for Utopian Witness!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hermano muy buen aporte me alegra saber que estas de regreso! :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Volvisteeeeeeeeee!!!! que felicidad :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit