Ask Your Question

pbfoobar's profile - activity

2019-06-20 21:56:42 +0200 commented answer How do I change the default date/time format?

This is a bug, and should be fixed. Of course if I enter it as bug into bugzilla, it will be reclassified as a feature

2019-02-18 14:58:06 +0200 received badge  Famous Question (source)
2019-02-18 14:58:06 +0200 received badge  Notable Question (source)
2018-11-11 21:59:31 +0200 received badge  Student (source)
2018-03-14 19:27:30 +0200 received badge  Famous Question (source)
2018-01-31 13:34:41 +0200 received badge  Notable Question (source)
2018-01-09 06:59:12 +0200 received badge  Popular Question (source)
2018-01-08 02:30:52 +0200 asked a question How do I step through a function evaluation in calc?

How do I step through a function evaluation in calc? subject says it all.

2017-11-14 22:20:42 +0200 received badge  Popular Question (source)
2017-10-12 23:48:05 +0200 asked a question menu shortcut keys

menu shortcut keys Between v5.0.1.2 and 5.4.1.2, the sequence of alt-keystrokes to navigate the menus changed, which of

2016-12-10 23:15:26 +0200 answered a question File locked in LibreOffice (no ".~lock" file to delete)

I just had the same problem, and ended here. The way I solved it might help someone else.

I could clearly see that the lock file had been deleted. LO still gave me a lock message, saying the file was open by user "unknown."

If Windows does not know that you want say .doc files opened by LibreOffice, the default is something like wordpad, depending on which OS version you are running. Even though I closed that program, it kept running windowless with its own lock, enforced through the OS.

So, check for any programs which might have the file in question, or the lock file open. You can do this with either the free Sysinternals Process Explorer (supported by MS), or by the free Process Hacker. They search all your processes for a handle with the specified string.

2015-06-17 22:49:27 +0200 received badge  Editor (source)
2015-06-17 22:42:54 +0200 answered a question How do I merge two separate csv files?

None of these provide a simple way to do the requested function. Even very old ms excel provides this functionality.

As long as you are doing extra work, it's probably easiest to just do it with the shell.

For example, in windows you can say

copy *.csv allfiles.csv

or, in unix, you can use 'cat' similarly.

Then, import the combined file to calc.

Of course, that assumes that all the csv files have consistent formatting and columns.

2015-06-17 22:19:17 +0200 commented answer How can I merge a csv file into a Calc file?

This is not a very useful answer. It essentially says open the csv file in another instantiation of calc, or another sheet, and copy the contents to where you want them. Maybe there is no way to do this automatically?