Ask Your Question

Gilward Kukel's profile - activity

2018-03-15 02:09:34 +0200 answered a question Calc: Using Paste Special > Options > Link, but the target cell doesn't change when source is updated

I can confirm this. It looks like a bug.

2018-03-13 19:24:21 +0200 answered a question Can't change (list) {decimal} separator

In "Tools - Options - Language Settings - Languages" set Locale setting to Greek. Then you will have to correct the form

2018-03-03 17:00:05 +0200 edited answer How do I highlight duplicate values?

Example: A1: a A2: 3 A3: 1 A4: 2 A5: 3 A6: 1 A7: 1 Go to A1. Menu Data > Pivot Table > Create... OK. Drag "a"

2018-03-03 16:18:35 +0200 commented answer How do I highlight duplicate values?

no :(

2018-03-02 13:59:02 +0200 answered a question How do I highlight duplicate values?

Example: A1: a A2: 3 A3: 1 A4: 2 A5: 3 A6: 1 A7: 1 Go to A1. Menu Data > Pivot Table > Create... OK. Drag "a"

2018-03-02 13:34:57 +0200 commented answer scalc: Ctrl D then immediately F2 gives empty field

Thank you. After 5 and a half years finally someone cared.

2018-03-02 02:16:06 +0200 received badge  Supporter (source)
2018-03-02 01:55:03 +0200 commented answer Can lists be generated automatically in Calc?

I changed the program in the attachment.

2018-03-02 01:51:26 +0200 commented answer Can lists be generated automatically in Calc?

I changed the program.

2018-03-02 01:09:16 +0200 edited answer Can lists be generated automatically in Calc?

Download the attachment: C:\fakepath\listgenerator.ods Change the file ending from ods to zip. Extract it. Download and

2018-03-01 23:27:19 +0200 answered a question Can lists be generated automatically in Calc?

Download the attachment: C:\fakepath\listgenerator.ods Change the file ending from ods to zip. Extract it. Download and

2018-03-01 19:55:08 +0200 received badge  Teacher (source)
2018-03-01 19:27:04 +0200 answered a question scalc: Ctrl D then immediately F2 gives empty field

It is a known bug. https://bugs.documentfoundation.org/show_bug.cgi?id=54197

2018-02-14 15:54:57 +0200 asked a question Define Database Range: Option "Insert or delete cells"

Define Database Range: Option "Insert or delete cells" Calc: Can you please give an example that shows what difference

2017-02-21 20:42:20 +0200 answered a question Replace One of 2 Words in Calc

How about that:

search: ^.*?(<UN>|<VI>)

replace: $1

2017-02-18 01:25:44 +0200 answered a question Objekt in andere Ebene verschieben

klicke auf das Objekt, lasse die Maustaste gedrückt, warte ein paar Sekunden, ziehe es auf die andere Ebene

2017-02-17 02:45:52 +0200 commented question Calc 5.3.0.3 cursor disappears after space

I have reported this bug: https://bugs.documentfoundation.org/s...

2017-02-16 05:08:09 +0200 answered a question Country redirect ... I don't like that!

Yes, I am redirected too.

Of course you can just bookmark https://ask.libreoffice.org/en

And in Firefox, you can set your preferred language for websites.

2017-02-16 03:13:00 +0200 answered a question Recovery failed after outage

Nothing in the backup folder of your LibreOffice user profile?

2017-02-15 23:16:24 +0200 received badge  Editor (source)
2017-02-15 23:01:39 +0200 answered a question Libreoffice Calc mode.sngl - err:538

I tried it. It seems that 100,000 is the maximum number of values that mode.sngl accepts. In the statusbar there is a description of the error value.

You can generate a pivot table of the values and their counts, sorted by the counts.

2017-02-15 00:44:05 +0200 answered a question Why does autocorrect not work for abbreviations?

Type i'm in a Writer document, copy it and paste it into the "Replace:" field in the autocorrect dialog. Click "New" and "OK". Type I'm in the Writer document, copy it, choose the i'm entry in the replace table of the autocorrect dialog, and paste into the "With:" field. Click "Replace" and "OK".

It did not work because single quotes are replaced.

2017-02-15 00:12:32 +0200 received badge  Enthusiast
2017-02-13 20:50:57 +0200 commented answer Sonderzeichen STRG+ALT LibreOffice Writer

Wegen Strg+Alt gibt es schon diesen Fehlerbericht: https://bugs.documentfoundation.org/s...

2017-02-12 16:52:23 +0200 commented answer Sonderzeichen STRG+ALT LibreOffice Writer

Verwendest du vielleicht auch AVG TuneUp? https://ask.libreoffice.org/de/questi...

2017-02-10 15:40:29 +0200 commented answer Sonderzeichen STRG+ALT LibreOffice Writer

Hast du in Windows ein deutsches Tastaturlayout eingestellt?

Funktioniert AltGr in anderen Programmen oder ist vielleicht diese Taste kaputt?

Probier es mit einem zurückgesetzten LibreOffice-Profil: https://wiki.documentfoundation.org/U...

Probier eine neuere LibreOffice-Version.

Strtg+Alt funktioniert auch bei mir nicht in Writer.

2017-02-10 00:56:21 +0200 commented question AltGr+Taste funktionieren nicht

Meinst du, dass AltGr bei dir in Writer nicht funktioniert, z.B. AltGr+Q = @ ? Das sollte funktionieren. Strg+Alt geht bei mir auch nicht in Writer, und ich weiß nicht, ob man das ändern kann. Ich glaube nicht.

2017-02-10 00:46:13 +0200 answered a question Sonderzeichen STRG+ALT LibreOffice Writer

Und mit AltGr geht's nicht? Z.B. AltGr+Q = @