質問する

lovecraft22's profile - activity

2019-01-19 21:08:34 +0200 バッジを受け取った  人気の質問 (source)
2019-01-01 21:13:01 +0200 コメント付き質問 Calc, password protected file is much slower than non protected file

https://bugs.documentfoundation.org/show_bug.cgi?id=122377

2018-12-30 09:04:39 +0200 コメント付き質問 Calc, password protected file is much slower than non protected file

I wil, thanks

2018-12-29 23:21:08 +0200 バッジを受け取った  有名な質問 (source)
2018-12-29 23:19:49 +0200 質問をする Calc, password protected file is much slower than non protected file

Calc, password protected file is much slower than non protected file Dear all, I have a password protected calc file whi

2018-02-07 21:06:59 +0200 バッジを受け取った  有名な質問 (source)
2017-11-21 03:02:21 +0200 バッジを受け取った  卓越した質問 (source)
2017-09-02 14:32:31 +0200 バッジを受け取った  有名な質問 (source)
2017-07-05 08:04:42 +0200 コメント付き回答 CALC: default date format

Thanks! Setting the locale to English UK solved my issue.

2017-07-05 08:01:08 +0200 バッジを受け取った  熱心な人
2017-07-05 02:04:42 +0200 バッジを受け取った  卓越した質問 (source)
2017-07-05 00:32:18 +0200 バッジを受け取った  人気の質問 (source)
2017-07-04 22:57:23 +0200 質問をする CALC: default date format

CALC: default date format Dear all, my computer (Mac) language is English but I would like LO to show dates in Italian F

2017-06-03 22:24:13 +0200 バッジを受け取った  人気の質問 (source)
2017-06-03 16:13:30 +0200 質問に回答する Calc sheet takes forever to open and save

Hi, I have been able to identify the issue. Among others, in my file I have lots of sumifs such as: =IF($M$1>=J2;(IF(

2017-06-02 23:08:47 +0200 質問をする Calc sheet takes forever to open and save

Calc sheet takes forever to open and save Dear all, I have a Calc sheet which takes a lot to open and especially to save

2017-04-26 21:00:56 +0200 バッジを受け取った  体系学者
2017-03-05 23:02:58 +0200 バッジを受け取った  卓越した質問 (source)
2017-02-06 14:53:57 +0200 バッジを受け取った  人気の質問 (source)
2017-02-05 15:05:29 +0200 バッジを受け取った  卓越した質問 (source)
2017-02-05 12:52:00 +0200 質問をする How to find out what is slowing down calc

Dear all, I have a big calc document and for some reason, in time, it got really slow. Is there any sort of "activity monitor" which would let me understand what is causing this?

Thanks!

2017-02-04 20:47:16 +0200 コメント付き回答 Calc - How to get cell coordinates as Sheet.A1

True, but in my case that will be just fine as I'm referencing this from a different sheet.

2017-02-04 20:12:51 +0200 コメント付き回答 Calc - How to get cell coordinates as Sheet.A1

Got it! =CELL("ADDRESS";Sheet2.A1) does exactly what I need! Thanks for your insight!

2017-02-04 19:53:05 +0200 コメント付き回答 Calc - How to get cell coordinates as Sheet.A1

Thanks! Works fine however it only works correctly if the cell where you fill the formula in is in the same sheet as cell A1, otherwise I get sheet2.sheet3.A1. Is there any way to fix it? (I'm not quite sure I understand how it works exactly)

2017-02-04 19:22:34 +0200 バッジを受け取った  人気の質問 (source)
2017-02-04 18:59:18 +0200 コメント付き回答 Calc - How to get cell coordinates as Sheet.A1

I don't want it to return the content of Sheet.A1 but I need it to return "Sheet.A1" instead. I need this to list different values and the cell where those values occur in 2 columns, such as

Sheet.A1 =Sheet.A1

Sheet.A2 =Sheet.A2

...

...

2017-02-04 18:58:49 +0200 質問に回答する Calc - How to get cell coordinates as Sheet.A1

I don't want it to return the content of Sheet.A1 but I need it to return "Sheet.A1" instead. I need this to list different values and the cell where those values occur in 2 columns, such as

Sheet.A1 =Sheet.A1

Sheet.A2 =Sheet.A2

...

...

2017-02-04 16:59:53 +0200 質問をする Calc - How to get cell coordinates as Sheet.A1

Dear all, I need a way to get a selected cell coordinates in this form: =function(Sheet.A1) should provide Sheet.A1

Is there any way to achieve this? From what I can understand =address would not return what I need.

Thanks

2016-02-27 16:12:29 +0200 バッジを受け取った  有名な質問 (source)
2016-01-05 22:13:32 +0200 バッジを受け取った  卓越した質問 (source)
2016-01-04 11:27:30 +0200 コメント付き回答 Conditional formatting based on week day

Perfect, thanks!

2016-01-01 07:51:35 +0200 バッジを受け取った  人気の質問 (source)
2015-12-28 11:53:17 +0200 質問をする Conditional formatting based on week day

Dear all, is there any way to apply a conditional formatting based on the week day filled in the cell? I have cells with the following format: Sun 31/12/2015 I would like Sundays to have a different background color.

Working with CALC on a Mac

Thanks!

2012-08-25 10:04:44 +0200 質問に回答する Decimal separator in Calc (mac OsX 10.7)

You need to set Italian (Swiss) as you language in Libre Office.