Fai la tua domanda

Pedro Olazabal's profile - attività

2018-01-09 14:08:25 +0200 received badge  Domande famose (source)
2017-12-18 10:30:52 +0200 received badge  Domande famose (source)
2016-11-23 23:41:11 +0200 received badge  Domanda notevole (source)
2016-09-07 10:07:01 +0200 received badge  Entusiasta
2016-08-25 13:30:21 +0200 ha commentato una risposta Two Loops Together in Libreoffice Basic and Paste Function

yuhuuuuuuuuuuuuu!!!!!!!

2016-08-25 13:29:55 +0200 received badge  Studioso (source)
2016-08-25 13:27:17 +0200 ha commentato una risposta Two Loops Together in Libreoffice Basic and Paste Function

Yeah! Thanks a lot!!!!!!! That's what I needed :) :) :) :) :)

2016-08-24 12:40:14 +0200 received badge  Domanda gettonata (source)
2016-08-24 11:54:14 +0200 ha risposto a una domanda Two Loops Together in Libreoffice Basic and Paste Function

Since I don't see where I can edit my original question, I add a screen shot here with what I mean with the columns

image description

Another example

image description

2016-08-24 11:25:22 +0200 ha commentato una risposta Two Loops Together in Libreoffice Basic and Paste Function

Hi

Thanks a lot for the programm :) :) :) I'm trying to understand this but I'm not so good. I'll respond you in a few hours :):):)

2016-08-24 11:08:08 +0200 ha commentato una domanda Two Loops Together in Libreoffice Basic and Paste Function

Hi

thanks a lot for answering! :)

I wanted to edit the question with a screen shot with what I mean. But I don't see how I can edit it :( I mean with blank that for example A3 is an empty cell in the initial column.

2016-08-24 11:05:28 +0200 ha commentato una risposta Two Loops Together in Libreoffice Basic and Paste Function

Thanks a lot for answering

I will study the handbook you send me :)

2016-08-23 11:19:31 +0200 ha posto una domanda Two Loops Together in Libreoffice Basic and Paste Function

Hi, I have a task that I don’t know how to solve I have two columns. In the first column I will have data like the following

Peter George John Lewis [Blank] John George [Blank] George Lewis

The second column is in the beginning empty. I want that the second column will be filled with the same data as the first column but without repeating names and without blanks. The result of the second column would be

Peter George John Lewis

I would make a programm like the following one (see image) but I don’t know some functions I need 1.How to check if a cell is empty → in calc the function isblank()

2.How to paste a cell in a new cellposition

On the other hand, I’m a beginner in programming so I would appreciate if you see some mistakes to correct

ps: is there any handbook for beginners in programming in libreoffice basic?

image description

2016-08-19 12:00:12 +0200 ha commentato una risposta Msgbox with text unreadable

Thanks for the links. I will ask there because I don't understand anything :)

2016-08-18 16:59:19 +0200 received badge  Domanda notevole (source)
2016-08-18 14:01:41 +0200 received badge  Revisore (source)
2016-08-16 17:35:33 +0200 received badge  Studente (source)
2016-08-16 17:19:56 +0200 ha risposto a una domanda Msgbox with text unreadable

Hi,

I have just seen your second answer (I don't know why I cannot see here your answer and my answer...)

I have reseted the user profile and I see that there is a new folder called "user" in the path I commented (home/pedro/.config/libreoffice/4).

But I cannot still see the messages of validity. I can see the title of the box but not the content of the pop-up.

if you have any other ideas...

[EDIT] I add picture. I also forgot to mention that I have LibreOffice 5.1.4

image description

image description

image description

Thanks Pedro

2016-08-16 16:59:17 +0200 ha risposto a una domanda Can I format page numbers higher in my footer?

Hi, I'm not sure if I understand your question but if I have understood you, you only have to do as follows:

  1. Click on "Format"
  2. Click on "Page"
  3. Click on Tab "Page"
  4. Change the margins. You see the margins in the left corner. For your case, increase the margin "Bottom" until you are happy :)

I hope it works :)

Pedro

2016-08-16 13:10:51 +0200 received badge  Domanda gettonata (source)
2016-08-16 12:21:27 +0200 ha risposto a una domanda Msgbox with text unreadable

Hi,

thanks a lot for the answer. I checked if OpenGL was clicked, but it wasn't.

So I tried to reset my user profile as you suggest. I read the link and it is stated that I should rename the user profile folder. When I looked for the location of this folder I found "home/pedro/.config/libreoffice/4/user"

But if I click in "home" and then in "pedro", after that I don't find any folder called ".config"

I'm not an expert in computers at all, sorry!

Thanks again

2016-08-16 12:19:07 +0200 ha risposto a una domanda Msgbox with text unreadable

Hi,

thanks a lot for the answer. I checked if OpenGL was clicked, but it wasn't.

So I tried to reset my user profile as you suggest. I read the link and it is stated that I should rename the user profile folder. When I looked for the location of this folder I found "home/pedro/.config/libreoffice/4/user"

But if I click in "home" and then in "pedro", after that I don't find any folder called ".config"

I'm not an expert in computers at all, sorry!

Thanks again

2016-08-11 14:42:43 +0200 ha posto una domanda Msgbox with text unreadable

Hi

I have just updated to Ubuntu 16.04 LTS and Libreoffice was also updated to 5.1.4.2

I had a calc sheet with some message boxes that now don't work properly. The pop-up appears but the text in the boxes is unreadable.

This happens in the boxes that appear when there is an error by entering something in a cell where there is catalog to use (validity function).

Does anyone knows why this happens and if there is a solution?

I wanted to upload an image but I'm not able to (>3 points to upload files)

Thanks

Pedro