質問する

hjek's profile - activity

2019-11-13 04:02:50 +0100 バッジを受け取った  卓越した質問 (source)
2019-10-07 18:17:48 +0100 バッジを受け取った  卓越した質問 (source)
2019-10-07 18:17:48 +0100 バッジを受け取った  有名な質問 (source)
2019-04-19 20:45:29 +0100 バッジを受け取った  素晴らしい回答 (source)
2018-10-03 19:58:42 +0100 質問に回答する opensolver.org port

The solve item should pass the data provided in the form to the COIN-OR solver and modify the spreadsheet to reflect

2018-08-22 16:19:16 +0100 コメント付き回答 Portable Draw

Perhaps use LibreOffice Portable then?

2018-08-22 16:19:02 +0100 コメント付き回答 Portable Draw

Perhaps use LibreOffice portable then?

2018-07-25 23:26:06 +0100 編集された回答 Oracle changing java license

In the InfoWorld article you link to, it appears that this additionally restricted license is only for version 8 of Java

2018-07-25 14:26:20 +0100 編集された回答 Can you see if a file that wasn’t supposed to be shared through libre office was shared ?

Someone borrowed my laptop [...] Can you see if a file that wasn’t supposed to be shared through libre office was sha

2018-07-25 14:21:03 +0100 質問に回答する Can you see if a file that wasn’t supposed to be shared through libre office was shared ?

Someone borrowed my laptop [...] Can you see if a file that wasn’t supposed to be shared through libre office was sha

2018-07-25 14:02:20 +0100 編集された回答 Oracle changing java license

In the InfoWorld article you link to, it appears that this additionally restricted license is only for version 8 of Java

2018-07-25 13:59:20 +0100 編集された回答 Oracle changing java license

In the InfoWorld article you link to, it appears that this additionally restricted license is only for version 8 of Java

2018-07-25 13:58:32 +0100 編集された回答 Oracle changing java license

In the InfoWorld article you link to, it appears that this additionally restricted license is only for version 8 of Java

2018-07-25 13:57:22 +0100 質問に回答する Oracle changing java license

In the InfoWorld article you link to, it appears that this additionally restricted license is only for version 8 of Java

2018-07-13 21:54:19 +0100 バッジを受け取った  素晴らしい回答 (source)
2018-07-13 18:29:55 +0100 編集された回答 =SUM(J23/(G23-H23)) for a whole column?

If you want to sum a whole column, e.g. column A, enter =SUM(A:A). If you want to divide the sum of column J by column G

2018-07-13 18:26:44 +0100 質問に回答する =SUM(J23/(G23-H23)) for a whole column?

If you want to sum column A, enter =SUM(A:A).

2018-07-10 20:55:08 +0100 コメント付き回答 How to compare two libreCalc files and generate comparative graph from that files?

What does this student progress data look like? And how is it split into different files? Is it one file per student? I

2018-07-10 12:38:51 +0100 コメント付き回答 Trying to create a coin toss

Apparently it was added in 5.2. Didn't know it was that new. Might be better to stick to @erAck's solution then, at leas

2018-07-10 12:38:42 +0100 コメント付き回答 Trying to create a coin toss

Apparently it was added in 5.2. Didn't know it was that new. Might be better to stick to @erAck's solution then, at leas

2018-07-08 13:57:30 +0100 編集された回答 What Python code opens a specific Calc file?

I want to export 50 Calc files to csv files . Doing this manually takes a long time. With Unoconv you can do that o

2018-07-08 13:52:01 +0100 質問に回答する What Python code opens a specific Calc file?

I want to export 50 Calc files to csv files . Doing this manually takes a long time. With Unoconv you can do that o

2018-07-06 22:11:18 +0100 質問に回答する How to search in multiple Calc files (sheets AND files)?

This can be done, but I don't think LibreOffice provides a built-in way of doing it. You can use a search program that

2018-07-06 21:50:12 +0100 コメント付き回答 Trying to create a coin toss

Oops, @ErAck, didn't see your answer before I posted mine. Not my intention to double-answer.

2018-07-06 21:49:37 +0100 コメント付き回答 Trying to create a coin toss

When you start entering the formula in the formula bar, e.g. type =IF(, there'll be a little pop up indicating the corre

2018-07-06 21:46:22 +0100 質問に回答する Trying to create a coin toss

=IF(AND(0=A2,0=B2),"1,3",=IF(AND(0=A2,1=B2),"2,4")) Formula B does not work returns Err:510 expected 1,3 or 2,4 or FA

2018-06-28 03:43:36 +0100 コメント付き質問 Text in cells truncated after 255 characters

I can't reproduce this issue. Does the same thing happen with any file or only that particular file? What format are you

2018-06-28 01:10:07 +0100 コメント付き回答 Is it possible to have more than one line of text in a spreadsheet cell?

On Mac, yes: Command + Enter.

2018-06-28 01:09:57 +0100 コメント付き回答 Is it possible to have more than one line of text in a spreadsheet cell?

On Mac, yes Command + Enter.

2018-06-27 23:16:00 +0100 質問に回答する Is it possible to have more than one line of text in a spreadsheet cell?

Yes, press Ctrl + Enter for line break within a cell.

2018-06-23 05:02:53 +0100 バッジを受け取った  素晴らしい回答 (source)
2018-06-22 21:42:05 +0100 コメント付き回答 LO Calc: relative path to external sheet?

Yes, adding another function call doesn't make it look less busy. Also, it appears that this question has been discusse

2018-06-22 21:29:29 +0100 コメント付き質問 Track changes not changing font

The font does not change color as I am expecting it to. Why are you expecting the font to change colour?

2018-06-22 20:58:00 +0100 質問に回答する How to aggregate rows using group by?

A simple but possibly insufficient solution is to use a formula. If we were to assume that you already had a list of uni

2018-06-22 20:24:23 +0100 編集された回答 How to create a user defined function

It's fairly simple to literally translate your requirements if B2 or C2 is empty the result is empty, but otherwise

2018-06-22 20:23:51 +0100 編集された回答 How to create a user defined function

It's fairly simple to literally translate your requirements if B2 or C2 is empty the result is empty, but otherwise

2018-06-22 20:22:45 +0100 質問に回答する How to create a user defined function

It's fairly simple to literally translate your requirements if B2 or C2 is empty the result is empty, but otherwise

2018-06-22 20:12:34 +0100 質問に回答する LO Calc: relative path to external sheet?

Yes, you can do that: =INDIRECT("'./material costs.ods'#$Webbing.$C$2:$C$6") I guess another use case for this would

2018-06-21 11:48:48 +0100 質問に回答する all of the menu choices are grayed out

Looks like all the icons are missing. No idea why. Perhaps as a workaround, try clicking Tools -> Options -> Libre

2018-06-13 12:51:32 +0100 質問に回答する Copy AND add background colour each time I hit ctrl+c

You can record macros in LibreOffice, too. First go to Tools -> Macros -> Record Macro, then record your actions (

2018-06-13 12:34:19 +0100 コメント付き質問 Table in a form does not show previous records

Are you using Calc?

2018-06-13 12:29:54 +0100 質問に回答する Why were files saved to a temporary folder?

If you don't notice what folder you save a particular document in, I guess it may seem like that document has "disappear

2018-06-12 23:24:36 +0100 コメント付き回答 L.O. is uninstalled from PC whenever SKYPE updates. Why?

Just to say that it's not off limits for MS to delete competing products during an update. Anyways, have you tried the

2018-06-12 23:23:09 +0100 コメント付き回答 L.O. is uninstalled from PC whenever SKYPE updates. Why?

Just to say that it's not off limits for MS to delete competing products during an update. Anyways, have you tried the

2018-06-12 23:22:49 +0100 コメント付き回答 L.O. is uninstalled from PC whenever SKYPE updates. Why?

Just to say that it's not off limits for MS to delete competing products during an update. Anyways, have you tried the

2018-06-12 23:17:11 +0100 コメント付き回答 L.O. is uninstalled from PC whenever SKYPE updates. Why?

Yes, obviously I'm just guessing as I don't have a machine with Windows on it. However, when Microsoft pushed the Windo

2018-06-11 23:27:11 +0100 質問に回答する uninstall libreoffice on linux installed from source

Remove the LibreOffice folder manually. (There is no make uninstall in the LibreOffice makefile) Many GNU/Linux distro

2018-06-11 23:16:02 +0100 質問に回答する how can i convert multiple csv to xls

For automated conversion with LibreOffice, check out unoconv. If you want to convert foo.csv and bar.csv to xls, then in

2018-06-11 23:04:27 +0100 質問に回答する L.O. is uninstalled from PC whenever SKYPE updates. Why?

Microsoft has a long history of hostility against free software and free document formats. Windows and Skype contain pro

2018-06-10 10:58:25 +0100 質問に回答する esc button does not work

Try Ctrl + Q