Sorunuzu Sorun

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

2020-08-07 19:59:22 +0100 en iyi cevap olarak işaretlenmiş Format for entering durations in years and months

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.

2020-08-07 19:57:39 +0100 rozet alındı  Ünlü Soru (kaynak)
2020-07-02 15:59:38 +0100 rozet alındı  Ünlü Soru (kaynak)
2020-06-13 14:56:52 +0100 rozet alındı  Güzel Cevap (kaynak)
2019-11-21 15:42:11 +0100 rozet alındı  Ünlü Soru (kaynak)
2019-09-17 15:43:15 +0100 cevaba yorum yazıldı Manual update of date field

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

2018-12-27 16:36:08 +0100 rozet alındı  Ölü diriltici (kaynak)
2018-12-25 11:15:50 +0100 rozet alındı  Önemli Soru (kaynak)
2018-08-14 23:45:25 +0100 cevaba yorum yazıldı Pass cell position into LOCalc function

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

2018-08-14 09:10:50 +0100 rozet alındı  Popüler Soru (kaynak)
2018-08-13 19:39:25 +0100 cevaba yorum yazıldı Create cumulative sum/ running total in column

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

2018-08-13 19:36:43 +0100 rozet alındı  Taraftar (kaynak)
2018-08-13 19:18:25 +0100 bir soru sordu Pass cell position into LOCalc function

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

2018-06-25 10:22:55 +0100 rozet alındı  Ölü diriltici (kaynak)
2018-06-25 10:22:55 +0100 rozet alındı  Öğretmen (kaynak)
2018-04-04 17:46:41 +0100 cevaba yorum yazıldı How do I insert an option button (selection circle) for a yes / no answer?

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

2018-04-04 17:45:37 +0100 cevaba yorum yazıldı Behaviour of radio/option buttons in PDF forms

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

2018-04-04 17:45:37 +0100 rozet alındı  Yorumcu
2017-12-04 10:54:26 +0100 bir soru cevapladı Read only content cannot be changed, no modifications will be accepted

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

2017-12-04 10:53:21 +0100 bir soru cevapladı "Write-protected content cannot be changed" - but I'd like to...

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

2017-11-25 13:59:06 +0100 soruya yorum yazıldı How to copy and paste only data from the spread sheet ?

For a similar question, see question 59306.

2017-11-25 13:58:58 +0100 soruya yorum yazıldı How to copy and paste only data from the spread sheet ?

For a similar question, see question 59306

2017-11-25 13:58:36 +0100 soruya yorum yazıldı How to copy and paste only data from the spread sheet ?

For a similar question, see question #59306.

2017-11-25 13:57:34 +0100 bir soru cevapladı Where is "Paste Special > Value" in LibreOffice?

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

2017-11-25 13:50:51 +0100 soruya yorum yazıldı How to copy and paste only data from the spread sheet ?

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

2017-10-05 19:27:43 +0100 soruya yorum yazıldı Format for entering durations in years and months

> 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

2017-10-05 19:25:12 +0100 bir soru cevapladı Format for entering durations in years and months

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

2017-10-05 19:19:38 +0100 cevaba yorum yazıldı Format for entering durations in years and months

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

2017-10-05 19:06:56 +0100 rozet alındı  Önemli Soru (kaynak)
2017-10-04 16:09:41 +0100 rozet alındı  Popüler Soru (kaynak)
2017-10-03 19:56:09 +0100 bir soru sordu Format for entering durations in years and months

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

2017-08-17 21:28:40 +0100 en iyi cevap olarak işaretlenmiş How can I set the default styles when opening a csv file?

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?

2017-08-17 21:28:40 +0100 rozet alındı  Alim (kaynak)
2017-08-17 12:55:02 +0100 cevaba yorum yazıldı In Writer, how to add text under/after a table?

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

2017-07-06 19:38:52 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:37:20 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:37:15 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:36:59 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:36:53 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:36:43 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:35:20 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 19:34:22 +0100 soruya yorum yazıldı Template file not lauched when importing from csv file

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

2017-07-06 19:33:45 +0100 soruya yorum yazıldı Default Template and CSV Files

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

2017-07-06 09:02:16 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 08:56:26 +0100 cevaba yorum yazıldı How can I set the default styles when opening a csv file?

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

2017-07-06 02:37:36 +0100 rozet alındı  Önemli Soru (kaynak)
2017-07-05 11:11:50 +0100 rozet alındı  Popüler Soru (kaynak)
2017-07-05 09:12:55 +0100 bir soru sordu How can I set the default styles when opening a csv file?

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