Ask Your Question

Mike Kaganski's profile - activity

2019-08-23 17:29:17 +0200 answered a question Average Visible Cells Only

SUBTOTALS is for that. See its 1xx function indexes that ignore hidden values (101 is for AVERAGE).

2019-08-23 16:01:18 +0200 commented answer why isn't there a file rename option?

Also it would be great to add a server configuration tools to LibreOffice, to allow Windows ActiveDirectory configuratio

2019-08-23 15:04:48 +0200 edited answer How to change the default behavior when setting cell background?

You can't. It's not "the default in None", it just shows you which is the current fill mode. It can't tell you "this cel

2019-08-23 15:02:44 +0200 answered a question How to change the default behavior when setting cell background?

You can't. It's not "the default in None", it just shows you which is the current fill mode. It can't tell you "this cel

2019-08-23 14:37:36 +0200 commented answer Could not load pdf content

... and...? As I said, it is unrelated information which application and how is used in your infra; what is important is

2019-08-23 13:59:03 +0200 commented answer Could not load pdf content

... so in your configuration, LibreOffice actually tries to open some PDF (not DWG, which was a red herring after all)?

2019-08-23 13:58:19 +0200 commented answer Could not load pdf content

... so in your configuration, LibreOffice actually tries to open some PDF (not DWG, which was a red herring after all)?

2019-08-23 13:40:45 +0200 commented answer LibreCalc Nested if question

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D For "default" case (like "what to do in all other ca

2019-08-23 12:51:54 +0200 commented answer How to fill cells with numbers in between the numbers.

That's just what I have filed tdf#127113 for - for you.

2019-08-23 12:49:39 +0200 commented answer Could not load pdf content

Working what? Opening DWGs in LibreOffice?

2019-08-23 12:48:30 +0200 commented question How to fill cells with numbers in between the numbers.

FYI: tdf#127113 was filed.

2019-08-23 12:30:31 +0200 edited answer How to fill cells with numbers in between the numbers.

If you put 5 into A1, and 12 into A5, you may put this to A2: =A1+($A$5-$A$1)/(ROW($A$5)-ROW($A$1)) ... and drag-copy

2019-08-23 12:29:14 +0200 answered a question How to fill cells with numbers in between the numbers.

If you put 5 into A1, and 12 into A5, you may put this to A2: =A1+($A$5-$A$1)/(ROW($A$5)-ROW($A$1)) ... and drag-copy

2019-08-23 12:11:36 +0200 commented question How to fill cells with numbers in between the numbers.

So, it seems that your question is an enhancement request to allow only fill two boxes (currently you may fill just Star

2019-08-23 12:11:09 +0200 commented question How to fill cells with numbers in between the numbers.

So, it seems that your question is an enhancement request to allow only fill two boxes (currently you may fill just Star

2019-08-23 11:42:17 +0200 commented question How to fill cells with numbers in between the numbers.

... and your settings in the dialog were ... ? And your end result was exactly ... (which)? E.g., when I select the 5 c

2019-08-23 11:41:29 +0200 commented question How to fill cells with numbers in between the numbers.

... and your settings in the dialog were ... ? And your end result was exactly ... (which)? E.g., when I select the 5 c

2019-08-23 11:37:06 +0200 commented question How to fill cells with numbers in between the numbers.

... and your settings in the dialog were ... ? And your end result was exactly ... (which)?

2019-08-23 11:00:34 +0200 commented answer Numerated list in table columns

See this video for the solution plot (the styles need further modifications to be identical, but the idea should be clea

2019-08-23 10:49:34 +0200 answered a question Numerated list in table columns

Cells in tables flow in Writer in rows, then across rows (i.e., horizontally first, then vertically). So after cell A1,

2019-08-23 10:32:33 +0200 commented question Is there a command line for removal of LibreLogo component in Windows?

By the way: CVE-2019-9849 has nothing to do with LibreLogo, so its removal will not mitigate that CVE.

2019-08-23 10:31:49 +0200 commented question Is there a command line for removal of LibreLogo component in Windows?

By the way: CVE-2019-9849 has nothing to do with LibreLogo, so its removal will not mitigate that CVE.

2019-08-23 10:00:39 +0200 edited answer Is there a command line for removal of LibreLogo component in Windows?

Use installer's REMOVE property: msiexec /i <path\to\LibreOffice_ver_Win_arch.msi or GUID> REMOVE=gm_o_Pyuno_Libr

2019-08-23 09:43:15 +0200 answered a question Could not load pdf content

DWG (AutoCAD drawing binary format) is not among the file types that LibreOffice can open. It only has a DXF (interchang

2019-08-23 07:35:27 +0200 commented question CommonopenLOtocreatenewpassword

I hope that the comment by @Opaque answers your question; anyway, please clarify the question (editing it) and mention w

2019-08-23 07:33:09 +0200 commented answer LibreCalc Nested if question

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D For "default" case, just use 1 or TRUE() as the cond

2019-08-23 07:33:01 +0200 commented answer LibreCalc Nested if question

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D For "default" case, just use 1 or TRUE() as the cond

2019-08-23 07:32:43 +0200 commented answer LibreCalc Nested if question

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D For "default" case, just use 1 as the conditions for

2019-08-23 07:31:12 +0200 commented answer LibreCalc Nested if question

:-) which leaves values from 1200 to 12000 inclusive undecided ;-D

2019-08-23 07:27:11 +0200 edited answer Is there a command line for removal of LibreLogo component in Windows?

Use installer's REMOVE property: msiexec /i <path\to\LibreOffice_ver_Win_arch.msi or GUID> REMOVE=gm_o_Pyuno_Libr

2019-08-23 07:17:52 +0200 answered a question Is there a command line for removal of LibreLogo component in Windows?

Use installer's REMOVE property: msiexec /i <path\to\LibreOffice_ver_Win_arch.msi or GUID> REMOVE=gm_o_Pyuno_Libr

2019-08-22 07:29:10 +0200 commented answer determine min and max dates (date/month) froma series of dates

A variant to use with MIN calculation: use another leap year, which gives a date with negative numerical value, like 160

2019-08-22 07:28:16 +0200 commented answer determine min and max dates (date/month) froma series of dates

A variant to use with MIN calculation: use another leap year, which gives a date with negative numerical value, like 160

2019-08-22 06:56:33 +0200 answered a question license LibreOffice Vanilla

LibreOffice Vanilla is an AppStore offer from Collabora Productivity; it has a cost. But you are free to download and i

2019-08-21 16:36:20 +0200 answered a question Why does CHAR text function not (always?) work?

What might be wrong? Char code 4 designates End-of-Transmission Character; it is a non-printing character - so what

2019-08-21 10:42:21 +0200 commented question Why are some special characters not displayed when writing in LibreOffice? tdf#127072

tdf#127072

2019-08-21 10:42:01 +0200 edited question Why are some special characters not displayed when writing in LibreOffice? tdf#127072

Why are some special characters not displayed when writing in LibreOffice? #tdf127072 I use Windows 10 and I use Guaran

2019-08-21 09:09:04 +0200 edited answer Set conditional formatting to ignore case type in referenced cells?

Use this formula for a range starting from B1: UPPER(A1)="YES"

2019-08-21 08:43:41 +0200 answered a question Human error in conditional formatting formula...

You need to make several corrections. You need to prepare your sample carefully. E.g., pay attention to the ranges you

2019-08-21 07:32:37 +0200 answered a question Set conditional formatting to ignore case type in referenced cells?

Use this formula for a range starting from A1: UPPER(A1)="YES"

2019-08-20 19:55:45 +0200 received badge  Nice Answer (source)
2019-08-20 13:48:19 +0200 commented question 6.3 on Windows 10 fails after installation

This only need to be filed as a bug if you can describe how to reproduce the profile corruption from clean profile. Unf

2019-08-20 10:38:21 +0200 commented question 6.3 on Windows 10 fails after installation

Try resetting user profile.

2019-08-20 10:37:19 +0200 commented question How do I prevent some of the HTML from being generated when I export a ODT to HTML using the writer2xhtml extension?

I think you only can do some post-processing (manual or with some script), or change the source code to prepare a custom

2019-08-20 09:51:26 +0200 answered a question Why is the latest Calc guide for version 4.1?

It's because it needs someone to do that. And it seems that more people have energy for updating Writer books than Calc

2019-08-20 09:47:56 +0200 commented answer How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

Just in case someone would still think it's a "great idea": the proposed thing is totally wrong. =WEEKDAY(A1) would call

2019-08-20 09:28:20 +0200 commented answer How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

Just in case someone would still think it's a "great idea": the proposed thing is totally wrong. A formula =WEEKDAY(A1)

2019-08-20 09:26:22 +0200 commented answer How do I derive a text day (Monday, Tuesday,...) from a date field (7/21/2016)

Just in case someone would still think it's a "great idea": the proposed thing is totally wrong. A formula =WEEKDAY(A1)

2019-08-20 08:50:54 +0200 commented answer Writer - Custom background size (image as page background) - unwanted images are not deleted

I'd even say it's a bug, not a feature...

2019-08-19 20:09:14 +0200 commented answer Table column width changes after saving + closing

Note Until now I found now way to configure this from within LibreOffice. See File▸Properties▸Font tab. Hopefully