Pergunte aqui

Perfil de T-buch - atividade

2020-08-24 18:14:20 +0200 Medalha recebida  Pergunta famosa (fonte)
2020-08-21 18:47:20 +0200 Respondeu uma pergunta CALC: Merge only columns not rows

Select the three cells of the first row, merge, copy, select other rows and paste You might mean: Select the

2020-08-21 15:15:27 +0200 Pergunta comentada CALC: Merge only columns not rows

https://i.imgur.com/5ob5lOq.jpg

2020-08-21 15:13:07 +0200 Medalha recebida  Pergunta notável (fonte)
2020-08-21 15:07:19 +0200 Pergunta editada CALC: Merge only columns not rows

CALC: Merce only columns not rows Can we do this too in Calc EDIT - New and better sample

2020-08-21 15:06:38 +0200 Pergunta comentada CALC: Merge only columns not rows

Good question but not mine - because I haven't entered any data yet in the cells But I tried it - and I can tell you - f

2020-08-21 12:22:34 +0200 Resposta comentada CALC: Merge only columns not rows

Now I have add a better sample-pic

2020-08-21 12:10:34 +0200 Medalha recebida  Pergunta popular (fonte)
2020-08-21 12:05:28 +0200 Resposta comentada CALC: Merge only columns not rows

;) Thanks to you confirming it

2020-08-21 11:48:53 +0200 Resposta comentada CALC: Merge only columns not rows

"First of all, this is not the Excel command, but one of the possibilities provided by the Ultimate Suite for Excel add-

2020-08-21 09:14:09 +0200 Perguntou CALC: Merge only columns not rows

CALC: Merce only columns not rows Can we do this too in Calc

2019-12-12 08:59:30 +0200 Medalha recebida  Estudante (fonte)
2019-12-12 08:59:28 +0200 Marcada como a melhor resposta Convert Text to table

Pease see the picture Anyone have an Idea of how to get from the sample text to this table:

image description

a way might be to use the "text to columns" function in Calc as a middle way - But perhaps there is a smarter way to do it?

2019-10-29 14:58:02 +0200 Medalha recebida  Pergunta famosa (fonte)
2019-10-28 19:36:21 +0200 Medalha recebida  Pergunta notável (fonte)
2019-10-27 10:01:54 +0200 Medalha recebida  Pergunta notável (fonte)
2019-10-27 07:05:55 +0200 Resposta comentada [SOLVED] Understanding how Calc stores time

Yes, I will never do that again - I swear;)

2019-10-27 07:00:36 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!! :-D .

2019-10-27 07:00:18 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!! .

2019-10-27 07:00:12 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!! .

2019-10-27 07:00:04 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!!

2019-10-27 06:59:56 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!!

2019-10-27 06:59:41 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!!

2019-10-27 06:59:29 +0200 Pergunta comentada Can I get notifications when someone commits a question??

Managing "email alerts" in your user profile isn't what you are looking for? YES!!

2019-10-27 06:55:58 +0200 Medalha recebida  Pergunta popular (fonte)
2019-10-27 06:55:29 +0200 Resposta comentada Inserted numbers (dates) from a text editor, the dates are sorted incorrectly

Well it's ok to add 1 to the "day-place-holder" and then It sounds like a less bulky way to do it - than the way which c

2019-10-27 06:26:11 +0200 Medalha recebida  Entusiasta
2019-10-26 19:46:36 +0200 Perguntou Can I get notifications when someone commits a question??

Can I get notifications when someone commits a question?? I have tried to found out but my research has not been success

2019-10-26 19:22:56 +0200 Resposta comentada Inserted numbers (dates) from a text editor, the dates are sorted incorrectly

So why would this 06 2019 input not produce a date in my case?

2019-10-26 19:14:42 +0200 Medalha recebida  Pergunta popular (fonte)
2019-10-26 12:41:32 +0200 Perguntou Inserted numbers (dates) from a text editor, the dates are sorted incorrectly

Inserted numbers (dates) from a text editor, the dates are sorted incorrectly I have imported a table column with the fo

2019-10-26 11:21:59 +0200 Resposta editada [SOLVED] Understanding how Calc stores time

Ok its simple - if you (as you said) can remember there is 86400 secs in a day - Or you could write =A2*24*60*60. Also r

2019-10-26 11:15:58 +0200 Pergunta comentada [SOLVED] Understanding how Calc stores time

I was inspired by this question-tread https://ask.libreoffice.org/en/question/214588/solved-draw-new-version-makes-file-

2019-10-26 11:06:01 +0200 Marcada como a melhor resposta [SOLVED] Understanding how Calc stores time

I have a cell: A1

A1 = is a number specified with time values (TT:MM:SS). Eg. 3 hours, 25 min. and 26 sec. written as 03:25:26

I imagine myself to have a function that converts A2 = 03: 25: 26 to seconds (12,326 secs) and again after doing some calculation which give me this result: 45,095 secs - This I want to convert back to 12:31:35

However, I do not know of such a function?

Maybe there is a whole other and smarter way to do it?

2019-10-26 11:05:59 +0200 Medalha recebida  Torcedor (fonte)
2019-10-26 11:04:45 +0200 Resposta editada [SOLVED] Understanding how Calc stores time

Ok its simple - if you (as you said) can remember there is 86400 secs in a day - Or you could write =A22460*60. Also rem

2019-10-26 11:02:17 +0200 Resposta comentada [SOLVED] Understanding how Calc stores time

Thanks for the reply Sorry, Now I have made some editing to clarify my point So this part of your (erAck) answer is n

2019-10-26 11:01:43 +0200 Resposta comentada [SOLVED] Understanding how Calc stores time

Thanks for the reply Sorry, Now I have made some editing to clarify my point So this part of your (erAck) is not actu

2019-10-26 11:00:49 +0200 Resposta comentada [SOLVED] Understanding how Calc stores time

Thanks for the reply Sorry, Now I have made some editing to clarify my point So this part of your (erAck) is not actu

2019-10-26 10:56:07 +0200 Pergunta editada [SOLVED] Understanding how Calc stores time

[SOLVED] Understanding how Calc stores time I have a cell: A1 A1 = is a number specified with time values (TT:MM:SS). E

2019-10-26 10:56:05 +0200 Medalha recebida  Pergunta notável (fonte)
2019-10-26 10:51:59 +0200 Pergunta editada [SOLVED] Understanding how Calc stores time

Function for calculating equation with time values I have two cells: A1 and A2 A1 = is just a given number (e.g. 8.2) A

2019-10-26 10:47:55 +0200 Resposta comentada [SOLVED] Understanding how Calc stores time

Thanks now I understand - just to add some more to your explanation- that is: The Number 86400 (which is 24(hour)60(min