Ask Your Question

hjek's profile - activity

2019-04-19 20:45:29 +0200 received badge  Nice Answer (source)
2018-10-03 19:58:42 +0200 answered a question 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 +0200 commented answer Portable Draw

Perhaps use LibreOffice Portable then?

2018-08-22 16:19:02 +0200 commented answer Portable Draw

Perhaps use LibreOffice portable then?

2018-07-25 23:26:06 +0200 edited answer 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 +0200 edited answer 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 +0200 answered a question 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 +0200 edited answer 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 +0200 edited answer 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 +0200 edited answer 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 +0200 answered a question 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 +0200 received badge  Nice Answer (source)
2018-07-13 18:29:55 +0200 edited answer =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 +0200 answered a question =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 +0200 commented answer 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 +0200 commented answer 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 +0200 commented answer 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 +0200 edited answer 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 +0200 answered a question 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 +0200 answered a question 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 +0200 commented answer 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 +0200 commented answer 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 +0200 answered a question 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 +0200 commented question 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 +0200 commented answer 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 +0200 commented answer 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 +0200 answered a question 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 +0200 received badge  Nice Answer (source)
2018-06-22 21:42:05 +0200 commented answer 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 +0200 commented question 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 +0200 answered a question 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 +0200 edited answer 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 +0200 edited answer 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 +0200 answered a question 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 +0200 answered a question 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 +0200 answered a question 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 +0200 answered a question 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 +0200 commented question Table in a form does not show previous records

Are you using Calc?

2018-06-13 12:29:54 +0200 answered a question 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 +0200 commented answer 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 +0200 commented answer 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 +0200 commented answer 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 +0200 commented answer 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 +0200 answered a question 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 +0200 answered a question 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 +0200 answered a question 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 +0200 answered a question esc button does not work

Try Ctrl + Q

2018-06-09 18:39:08 +0200 commented question Sorting in Libre Calc by Cell Color

Why is this question so common?

2018-06-09 00:57:16 +0200 commented answer i have golf scores 1 to 17, some doubled and want to display them in another column as positions

Makes sense. I didn't get the question. Thought it was just about sorting a column of numbers.

2018-06-08 23:42:20 +0200 received badge  Popular Question (source)