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: 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
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 |

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.