Pergunte aqui

Perfil de Aigars - atividade

2019-05-24 15:05:00 +0200 Medalha recebida  Pergunta famosa (fonte)
2018-12-06 22:12:18 +0200 Medalha recebida  Pergunta popular (fonte)
2018-12-06 11:13:48 +0200 Resposta comentada How to differentiate date format?

Thank you!

2018-12-06 11:13:38 +0200 Marcada como a melhor resposta How to differentiate date format?

I need to format a cell so that when I enter a date in format 6/12 it would show "december 6, 2018", but if I enter 0 it would show "____.____._______"

The first one is simple - just use a date format, but how to get it to show the other outcome when the date is "0"?

2018-12-06 11:01:32 +0200 Perguntou How to differentiate date format?

How to differentiate date format? I need to format a cell so that when I enter a date in format 6/12 it would show "dece

2018-09-27 13:24:32 +0200 Pergunta comentada libre office won't print

I can't print a specific file on two different computers (with the same printer). Both have windows 10. One PC had a cle

2017-04-16 11:45:14 +0200 Resposta comentada All my documents are Libre Office

Read this Also, this is not a LO question.

2017-04-16 11:44:13 +0200 Resposta comentada All my documents are Libre Office

"Restore previous versions" is something like a backup tool, you use it when something has been done to the file and you

2017-04-16 11:42:25 +0200 Resposta comentada All my documents are Libre Office

"Restore previous versions" is something like a backup tool, you use it when something has been done to the file and you

2017-04-16 11:40:20 +0200 Resposta comentada All my documents are Libre Office

"Restore previous versions" is something like a backup tool, you use it when something has been done to the file and you

2017-02-02 14:21:19 +0200 Medalha recebida  Pergunta notável (fonte)
2017-02-02 08:31:46 +0200 Respondeu uma pergunta Why LO won't show cell content

As Stanton suggested, the problem was the font. It might be damaged in the third PC and when I change it, the text appears.

Even font preview shows the text already: image description

2017-02-02 08:29:04 +0200 Pergunta comentada Why LO won't show cell content

You are correct, it was the font. I don't know what's wrong with it on the third PC, but when I change it, the text appears. Thanks for the idea.

2017-02-02 01:59:14 +0200 Medalha recebida  Pergunta popular (fonte)
2017-02-01 15:44:09 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-02-01 15:44:09 +0200 Medalha recebida  Pergunta notável (fonte)
2017-02-01 15:42:20 +0200 Medalha recebida  Pergunta famosa (fonte)
2017-02-01 15:39:06 +0200 Perguntou Why LO won't show cell content

Hi! I have made an .ods spreadsheet containing table with numbers and texts. The table is formatted with background colors. On both my computers everything is fine, but the third PC won't display cell content. When I select the cells, open the right-click menu and select "Clear Direct Formatting", cell content appears. It's not font color, I checked that.

Here's how it should look: image description

And here's how it looks: image description

Thus far only one PC out of three is having this issue. What could be the problem?

2017-01-15 14:15:40 +0200 Medalha recebida  Pergunta popular (fonte)
2017-01-15 14:15:40 +0200 Medalha recebida  Pergunta notável (fonte)
2017-01-12 09:23:57 +0200 Respondeu uma pergunta How to get a date from text?

Thanks, I found the answer myself. It was really easy actually. LOL DATE(F16;1;1), where F16 is the year number the user inputs and first number one is the month and the second number one is the day. And the result is 01.01.2016.

2017-01-12 09:15:53 +0200 Perguntou How to get a date from text?

Hi! I have spreadsheet that has one cell where the user has to input a year number, like "2016" and it's used for titles (text) on other sheets. Now I need to get a date from this year number. I.e. if the user inputs "2016" I need to get a date 01.01.2016, if the user inputs "2017", I need to get 01.01.2017. Its necessary for further calculations. Any ideas?

2016-10-10 18:01:37 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-09-28 12:55:02 +0200 Resposta comentada Missing program icons

Performed a clean install (uninstalled and cleaned the registry) and installed LO 5.1.5.2, the issue is gone now.

2016-09-28 12:53:09 +0200 Medalha recebida  Pergunta famosa (fonte)
2016-09-15 08:30:34 +0200 Resposta comentada How to get a list of all unique values from two columns?

@Lupp Can your solution be adapted to a fixed range?

2016-09-15 08:29:45 +0200 Resposta comentada How to get a list of all unique values from two columns?

Worked fine for me, with no bugs, but I was looking for a more or less automated solution.

2016-09-14 18:39:05 +0200 Resposta comentada How to get a list of all unique values from two columns?

@Lupp Yes he does! :)

2016-09-14 17:04:57 +0200 Medalha recebida  Pergunta notável (fonte)
2016-09-14 13:08:15 +0200 Resposta comentada How to get a list of all unique values from two columns?

Ok, so I tested your spreadsheet with a small portion of my data, it seems to work very well. Although I don't yet know why and how :D (I have to run) Though, my spreadsheet is not meant to be infinite. Data fields have a fixed size, but I'm starting to wonder if it could in fact be turned into a continuous table...

The very foundation of my spreadsheet is to enter those values in these two columns with a random pattern. They are supposed to repeat.

2016-09-14 12:44:45 +0200 Resposta comentada How to get a list of all unique values from two columns?

Wow, thanks for going the extra mile and providing an example. I will look into it, might be what I needed.

As for the "B" option, it's no good, there are about 3k entries and it needs to be automated.

2016-09-14 12:36:46 +0200 Medalha recebida  Pergunta popular (fonte)
2016-09-14 11:32:17 +0200 Resposta comentada How to get a list of all unique values from two columns?

It's starting to sound promising, but I lack the knowledge in this area.

2016-09-14 10:27:42 +0200 Resposta comentada How to get a list of all unique values from two columns?

This looks like SQL, but I'm working with a spreadsheet in calc.

2016-09-14 09:31:02 +0200 Perguntou How to get a list of all unique values from two columns?

Hi! I have two columns containing values like "aaa", "aab", "aac", etc. They repeat n times in a random pattern and new values may emerge after few intervals. I need to create a list in a new column that would show all the unique values from both columns.

It would look something like this: image description

If I had just one column I could use Pivot table with the necessary Row Field, but since I have two columns, this does not work. Any suggestions?

2016-08-17 23:50:58 +0200 Medalha recebida  Pergunta popular (fonte)
2016-08-16 22:56:44 +0200 Marcada como a melhor resposta Outline level not working in Paragraph style.

I'm trying to create a paragraph style that would add outline numbering, but I can't set the outline level. No matter what I put there, the numbers are 1, 2, 3..., while they should've been 1.1, 1.2, 1.3...

Is there something I'm missing?

2016-08-16 22:56:29 +0200 Resposta comentada Outline level not working in Paragraph style.

Thank you! This worked just the way I needed. Though I'm a little confused why are there two kinds of numbering.