Ask Your Question

w2016's profile - activity

2019-04-05 14:32:57 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2019-04-05 14:32:15 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2019-04-05 14:31:30 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2019-04-05 14:30:11 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2019-04-05 14:29:15 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2019-04-05 13:05:55 +0200 commented answer Hi! Is there a function "Sort or filter by color" in Libreoffice Calc? If not, is there a hack to filter cell by color? Thanks

I basically do that when I create spreadsheets (having extra columns for sorting), but I regularly receive files from MS

2018-08-08 03:05:58 +0200 received badge  Enthusiast
2018-08-07 15:33:25 +0200 commented answer Lookup by column and row values

Useful answer, but please improve that by adding a zero to the each of the MATCH functions, otherwise the approximate lo

2018-08-07 15:33:25 +0200 received badge  Commentator
2018-06-29 14:10:02 +0200 commented answer Hide Whitespace

The bugreport now has the status: RESOLVED NOTABUG (BTW: my LO 6.0.4.2 works fine)

2018-06-29 14:09:27 +0200 commented answer Hide Whitespace

The bugreport now has the status: RESOLVED NOTABUG (my LO 6.0.4.2 works fine)

2018-06-29 14:08:28 +0200 commented answer Hide Whitespace

The bugreport now has the status: RESOLVED NOTABUG

2017-03-24 08:14:44 +0200 answered a question software adding unwanted code automatically

Could be a regression of bug 67572 Please file a bug report, otherwise chances are slim that it will be fixed soon on its own.

2016-04-29 11:12:10 +0200 commented question New user to LO. But LO calc keeps crashing with frustrating regularity. Can you help me please?

I always have several spreadsheet files open at the same time and now noticed that every time I had a crash I also had an "Untitled" file in the recovery list. I am now always immediately giving a new file a name and will see whether that improves it.

2016-04-25 15:36:56 +0200 commented question Why does libreoffice keep losing hours and hours of progress?

I am suffering from the same problem in scalc (latest LO 5.1.2.2, Windows 64 bit)

2016-04-25 15:33:44 +0200 commented answer Crash recovery doesn't work

LO 5.1.1.2 still didn't improve for me, just lost about 2 hours of small notes; not much in volume, but annoying when trying to remember what I changed/added ;-(

2016-04-01 14:01:31 +0200 commented answer Crash recovery doesn't work

"Always create a backup copy " good advice, but that doesn't really help with the non-working auto recovery (at least it never helped me so far); when LO today crashed before lunchtime I got the file from 8 o-clock in the morning, the backup was a version from yesterday late afternoon; I will have to increase the frequency of using Ctrl-S

2016-04-01 13:52:31 +0200 commented answer Crash recovery doesn't work

"the shorter the value the small a possible loss; I use 3 min" I tried 1 min. with LO 4, but when I opened a really large file the AutoRecovery save took so long that I could hardly work (3 year old hardware) and in the end crashed LO; now I am using 15 min.; I have one file open the whole day (task tracking) - losing the last 15 min is acceptable for me, as the data isn't that much, but today LO 5.1.1.3 crashed just before lunch, recovery failed and I lost half a day of notes

2016-04-01 08:18:16 +0200 commented answer Crash recovery doesn't work

"Automatically save document too" was removed in LO 5 (according to other posts it never worked) I didn't use it so far because I preferred to control myself when to save, but I would like to try that now, after having lost data 3 times in the past week

2016-03-24 03:21:51 +0200 commented answer How can i fix Problem about Vowels Thai Font

Today I noticed that the weird spacing with English/Thai still was there for all fonts except Arial Unicode MS; to expand my example from above, "กิดA" is shown normally, but "Aกิด" is shown as "Aกิ ด", the problem happens with all lifted vowels and the tone modifiers.

2016-03-24 02:38:54 +0200 commented answer Thai Language is invisible in Office

Please try Tools/Options/View and UNcheck "Use OpenGL for all rendering (on restart)"

(You have to restart LibreOffice)

2016-03-23 14:01:01 +0200 answered a question How can i fix Problem about Vowels Thai Font

Please update to the latest version (5.1.1.3)

Then try Tools/Options/View and UNcheck "Use OpenGL for all rendering (on restart)"

(You have to restart LibreOffice)

Option 1: using an older version (initially I went back to 4.4.5.2, because I still had the install file; you can get other old versions from https://downloadarchive.documentfound...)

Option 2: temporarily install MS Office, install LibreOffice 5.1.1.3, uninstall MS office (this worked for my co-worker today, but IMO is not a real solution)

Some details: I had the problem with scalc from version 5.1.1.3 64 bit (on Windows 8.1); the Thai consonants were shown (the initial 5.0 version on my co-worker's computer didn't display any Thai characters), but the spacing was uneven for most fonts if I had at least one English character in front of the Thai text in the same cell; (Arial Unicode MS had proper spacing all the time for the Thai consonants); but the wrong vowels were displayed with all fonts and they were at the wrong place too.

For testing I switched to Thai input and keyed in "dbf", which should look like this: "กิด" But the "b" instead of showing the Thai vowel for a short "i" displayed the long "i" and off to the right by several consonant widths. The last character (a consonant) was properly shown. It looked roughly like this: "กด ี"

I downloaded the "Noto Sans Thai" font as suggested in another thread, but it didn't help.

I also downloaded the free MS Excel viewer and installed it in the hopes it would have the same effect as the temporary MS Office install on the other computer, but it didn't. (Additionally installing the MS Word viewer and the MS PowerPoint viewer didn't help either.)

Please note: I tried the OpenGL settings AFTER I installed all those MS viewers. So I uninstalled all 3 viewers and LibreOffice then had the option checked again! Unchecking it and restarting LibreOffice once more helped - I did not restart the computer.

HTH