質問する

Murz's profile - activity

2016-12-14 05:54:22 +0200 バッジを受け取った  ネクロマンサー (source)
2016-10-23 18:59:48 +0200 バッジを受け取った  有名な質問 (source)
2016-02-28 06:36:19 +0200 バッジを受け取った  体系学者
2015-08-28 09:29:02 +0200 バッジを受け取った  人気の質問 (source)
2015-08-28 09:29:02 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-28 09:28:38 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-28 09:28:38 +0200 バッジを受け取った  人気の質問 (source)
2015-04-20 09:17:23 +0200 質問をする Per file option "Enable regular expressions in formulas" in LibreOffice Calc

Is there any way to create document-depended option "Enable regular expressions in formulas"? As I understand, enabling this option globally can broke (change results) some formulas, when opening other XLS or ODS documents. For example, formula =COUNTIF(A1:A100,'1.') is regexp-depended.

So I afraid to enable this option globally, because I can see wrong results in some documents. Can I write macros or other feature that will enable regular expressions in formulas only for current document, and stay this option disabled for all other documents?

2015-04-20 08:47:30 +0200 質問をする Libreoffice Calc - relative link to Sheet in formula

Is there any way to create relative link to other Sheet in formula? I need the formula, that point always to right of current Sheet, independently of it's name. Another needs is "current + 2", "current -1", etc.

So I want something like =A1+{'CurrentSheet'+1}.A1 and =A1+{'CurrentSheet'-2}.A1 but can't find how to do this. Is this feature exist in LibreOffice or OpenOffice?

2015-03-17 14:55:25 +0200 質問に回答する How can I change the order of conditions in conditional formatting in calc?

I got the same problem and fill the bug about this: https://bugs.documentfoundation.org/s... Please subscribe and vote for it.

2014-08-09 14:40:57 +0200 バッジを受け取った  教師 (source)
2014-08-01 09:07:37 +0200 質問に回答する Why are my list styles renamed as "WWNumN" when converting from ODT to DOCX?

Here is issue about this problem with more detailed info and examples: https://bugs.freedesktop.org/show_bug...