Ask Your Question

OfficeLibre2's profile - activity

2020-05-18 10:36:30 +0100 received badge  Famous Question (source)
2020-03-26 02:18:21 +0100 received badge  Popular Question (source)
2019-10-10 20:33:56 +0100 received badge  Famous Question (source)
2019-10-10 20:33:56 +0100 received badge  Notable Question (source)
2019-04-03 16:01:11 +0100 received badge  Popular Question (source)
2019-04-03 14:42:26 +0100 marked best answer how to fill empty cells with zeros?

I'd like to fill all empty cells in my table with 0. I tried "find and change" ("znajdź i zamień" in Polish, Ctrl+H) function, where "find" field was empty and "change" contained 0. However, after running, empty cells were filled with 0, but it was aligned to the left side of each cell (instead of numbers which are aligned to the right). When I clicked on some of these cells, instead of 0 they contained '0 and it was impossible to correct it with "find and change". How can I do it correctly?

2019-04-03 14:42:26 +0100 received badge  Scholar (source)
2019-04-03 11:20:41 +0100 asked a question how to fill empty cells with zeros?

how to fill empty cells with zeros? I'd like to fill all empty cells in my table with 0. I tried "find and change" ("zna

2019-04-03 09:20:02 +0100 received badge  Notable Question (source)
2019-04-02 18:01:06 +0100 edited answer How to delete rows with 1st column value repeating and move their values in other columns?

Thank you very much, it works. But I would suggest enable selecting more than one of available fields to drag&drop a

2019-04-02 18:00:07 +0100 answered a question How to delete rows with 1st column value repeating and move their values in other columns?

Thank you very much, it works. But I would suggest enable selecting more than one of available fields to drag&drop a

2019-04-02 12:40:05 +0100 received badge  Popular Question (source)
2019-04-01 14:42:15 +0100 edited question How to delete rows with 1st column value repeating and move their values in other columns?

How to delete rows with 1st column value repeating and move their values in other columns? Hello, I have a table with so

2019-04-01 14:42:08 +0100 received badge  Editor (source)
2019-04-01 14:42:08 +0100 edited question How to delete rows with 1st column value repeating and move their values in other columns?

How to delete rows with 1st column value repeating? Hello, I have a table with some numbers, where: -1st column is fille

2019-04-01 14:41:09 +0100 edited question How to delete rows with 1st column value repeating and move their values in other columns?

How to delete rows with 1st column value repeating? Hello, I have a table with some numbers, where: -1st column is fille

2019-04-01 14:40:35 +0100 asked a question How to delete rows with 1st column value repeating and move their values in other columns?

How to delete rows with 1st column value repeating? Hello, I have a table with some numbers, where: -1st column is fille