質問する

lolax's profile - activity

2018-02-09 14:44:42 +0200 バッジを受け取った  有名な質問 (source)
2017-09-24 22:50:48 +0200 バッジを受け取った  有名な質問 (source)
2017-09-22 11:48:06 +0200 バッジを受け取った  有名な質問 (source)
2017-06-27 20:03:07 +0200 バッジを受け取った  有名な質問 (source)
2017-04-06 01:13:19 +0200 バッジを受け取った  卓越した質問 (source)
2016-11-12 18:15:17 +0200 バッジを受け取った  体系学者
2016-10-15 15:34:47 +0200 バッジを受け取った  有名な質問 (source)
2016-03-10 06:28:38 +0200 バッジを受け取った  有名な質問 (source)
2016-02-29 21:22:24 +0200 バッジを受け取った  卓越した質問 (source)
2016-02-29 11:06:24 +0200 バッジを受け取った  有名な質問 (source)
2016-02-26 01:12:42 +0200 バッジを受け取った  人気の質問 (source)
2016-02-25 12:12:27 +0200 質問をする Is there any way I can protect the libreoffice files like MS office files with Rights Management Services

Libreoffice 5.0.5.2 Windows 7 64bits Is there any way I can protect the libreoffice files like MS office files with Rights Management Services ? Thanks.

2015-12-21 18:59:31 +0200 バッジを受け取った  卓越した質問 (source)
2015-12-21 18:59:31 +0200 バッジを受け取った  人気の質問 (source)
2015-10-24 12:05:53 +0200 バッジを受け取った  有名な質問 (source)
2015-10-06 19:43:53 +0200 バッジを受け取った  有名な質問 (source)
2015-08-27 15:30:05 +0200 質問に回答する Non-printing characters

Please check here.

2015-08-26 15:48:00 +0200 バッジを受け取った  教師 (source)
2015-08-25 19:42:20 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 19:41:00 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 19:27:03 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-25 03:21:26 +0200 質問に回答する How do I conditionally calculate a sum of values based on a date range?

Libreoffice 4.3.7 and Windows 7.

Please try the following formulas.

=SUM(IF(MONTH(A1:A9)={5,1,3},B1:B9,0))

=SUM(IF((MONTH(A1:A9)=5)+(MONTH(A1:A9)=1)+(MONTH(A1:A9)=3),B1:B9,0))

And please make sure to press CTRL+SHIFT+ENTER after typing the formula.

2015-08-24 16:28:06 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-22 05:32:29 +0200 質問に回答する How to make a list with values from A1, A13, A25, this is, from every "+12" cell?

how about the formula =INDIRECT("A"&(ROW(A1)-1)*12+1)

2015-08-21 11:16:56 +0200 バッジを受け取った  有名な質問 (source)
2015-08-21 08:05:47 +0200 質問をする Bullet symbol disappears automatically in Impress

Libreoffice 4.3.7

A ppt file was created by MS powerpoint and a certain slide has the bullet list. When I open it from LO impress and try to paste a word into one of the bulleted list, then the bullet symbol disappears automatically.

[Edit: added LO4 tag ]

2015-08-20 14:30:40 +0200 コメント付き質問 E-mail address gray in LO Calc
2015-08-20 02:33:21 +0200 質問に回答する How to add watermark

Please check here.

2015-08-15 16:33:42 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-15 00:46:29 +0200 バッジを受け取った  人気の質問 (source)
2015-08-14 06:53:44 +0200 質問をする How can I select non-adjacent columns in table ?

Libreoffice 4.3.7 I have a 5X6 table , and I would like to know how to select column A and column C in Writer and Impress. Thanks.

2015-08-12 16:29:50 +0200 コメント付き回答 I have gray marks between the letters - how get rid of?

Please try to paste special with unformatted text.

2015-08-07 12:50:32 +0200 コメント付き質問 How to select entire column while using vlookup function in calc

Thanks for your suggestion.

2015-08-07 12:38:22 +0200 質問に回答する Page numbers in footer have a grey background. How to remove?

Please click View , then click Field Shadings.

2015-08-06 14:19:26 +0200 バッジを受け取った  卓越した質問 (source)
2015-08-05 15:29:16 +0200 コメント付き質問 How to select entire column while using vlookup function in calc

I use LO 4.3.7 and I change the settings into Excel A1 for the Formula Syntax from Tools > Options > Libreoffice Calc > Formula and it's okay to use like VLOOKUP(D1,G:I,3,0)

2015-08-05 15:01:02 +0200 質問に回答する Is there a function in Calc to get the cell comments content?

Please check the URL and Lupp has provided a Link and there is a function CELL_NOTE should meet your requirement.

2015-08-05 05:30:24 +0200 バッジを受け取った  人気の質問 (source)
2015-08-05 02:42:41 +0200 コメント付き回答 Vlookup got Err:502

I still get Err:502. If the value gets from regular value, then everything is okay, but if the value is from other vlookup, then it fails.

2015-08-04 17:48:25 +0200 質問をする Vlookup got Err:502

LibreOffice 4.3.7 I have three xls files, the first file vlookup the second file, and the second file vlookup the third file, it's working from MS Excel, but it fails from Libreoffice Calc.

C:\fakepath\first.xls C:\fakepath\second.xls C:\fakepath\third.xls

2015-07-30 03:46:19 +0200 バッジを受け取った  卓越した質問 (source)
2015-07-27 18:40:15 +0200 バッジを受け取った  卓越した質問 (source)
2015-07-26 02:35:18 +0200 コメント付き回答 Why, in French, does the combo of functions SI(EXACT(cell1,text);cell2;cell3) returns a boolean instead of cell2 or cell3?

Hi Alex, I checked the website https://help.libreoffice.org/Calc/Log... and found SI function is the IF function in English.

2015-07-23 02:03:08 +0200 コメント付き回答 I would like to import text file which has more than one space between values

BTW, MS Excel will tick the option "Treat Consecutive delimiters as one" automatically when selecting space as delimiter.

2015-07-23 02:00:27 +0200 バッジを受け取った  人気の質問 (source)
2015-07-22 15:34:13 +0200 コメント付き回答 I would like to import text file which has more than one space between values

It's working. Thanks.

2015-07-22 15:12:20 +0200 質問をする I would like to import text file which has more than one space between values

LibreOffice 4.3.7

I used space as delimiter to separates values for the text file, but it generates a lot of blank cells, since Calc doesn't have the option "Treat Consecutive delimiters as one", therefore I need to use the "Fixed Width" to fulfill this requirement. Is there any way to solve this issue ? Thanks.

2015-07-21 03:40:45 +0200 質問に回答する Calc. Whe I hit CTRL to open the cells are all very small. Ver. 4.3.7.2

I had the same issue, then I drag the zoom slider to 100% and the problem was gone, even I open a new calc file.

2015-07-19 12:23:03 +0200 コメント付き回答 The content is html and the file's extenion name is xls

already added a statement in the program, therefore the xls file include the <meta http-equiv="content-type" content="application/ms-excel; charset=utf-8">, then got the correct characters. Thanks.

2015-07-19 03:01:30 +0200 コメント付き回答 Does line chart provide the drop line function ?

Thanks, seems chart has something cannot meet users' requirements.