quazgar isimli kullanıcının profili - etkinlik

Hi, I am looking for a way to enter time durations involving years and months. Ideally in the format YY-MM. But when I set the format to such a format and try to enter "6 months" as 00-06, it is interpreted as 2000-06 (displayed as 00-06 though), whereas adding this date to another date adds another 100 years, because LibreOffice's epoch seems to be 1900-01-01.

So, how can I manually enter durations and visually see if they were entered correctly?

Note: As a programmer I know that working with times is a PITA, always.

If I start of with a template-like document, which I want to edit and save as a new file, I might want to keep the date

Hmm, that's a real shortcoming, I think. I was hoping to do it in a way similar to e.g. the ROW() function which someho

So please edit the answer so that others don't make the same mistake :-)

Pass cell position into LOCalc function Hi, I want to use the distance (in columns) between two cells in a custom-writte

Make sure that the buttons all have the same "Name" value, this is what makes them mutually exclusive.

Thanks, this was the correct, but unintuitive answer. I tried to set "Group Name" to the same value first.

I solved my problem with protected forms by unsetting an option in the Options dialog: Tools > Options ... > Libr

I solved my problem with protected forms by unsetting an option in the Options dialog: Tools > Options ... > Libr

For a similar question, see question 59306.

For a similar question, see question 59306

For a similar question, see question #59306.

The options Paste only (right-click menu) and Paste special are greyed out when there is nothing in the clipboard. Note

How is this question invalid? I just came here for exactly the same reason as the OP.

> What do you expect to be the actual content of a cell That does not really matter that much to me, I don't care if

Combining the answers by @Gilberto Schiavinatto and @Jim K, formatting the delta B1 as Number 00-00 (just formatting sug

Thanks, that's already very useful, especially the link with the hint to edate. Unfortunately, LEFT(B1, 2) yields 6 for

Format for entering durations in years and months Hi, I am looking for a way to enter time durations involving years and

When opening a CSV file, LibreOffice Calc seems to use its internal defaults for styles, no matter if I set a default document template or not. That means it will use Letter sized pages, in portrait orientation, whereas I need A4, in landscape.

Is there a way to tell localc which page format to use for importing non-ods files?

Very good. I would like to add that this also helps for adding text under a section (e.g. to create columns in a part of

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) But that's the number, and the

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) [[tdf#86336]] [link text](tdf#

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) [[tdf#86336]] [link text](http

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) [[tdf#86336]]

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) [tdf#86336]

Hmm, that format does not seem to work: tdf#86336 (The bug is old, it has only 5 digits.) #86336

OK, let's see if that format still works: tdf#86336

Reported as a bug here: https://bugs.documentfoundation.org/show_bug.cgi?id=86336

Reported as a bug here: https://bugs.documentfoundation.org/show_bug.cgi?id=86336

Thanks for testing this behavior and the tip. I think I will use the "insert" way for cases when I know I will print the

Thanks for testing this behavior and the tip. I think I will use the "insert" way for cases when I know I will print the

How can I set the default styles when opening a csv file? When opening a CSV file, LibreOffice Calc seems to use its int