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

--- Comment #12 from Jesse McNichol <[email protected]> ---
(In reply to Aldric Degorre from comment #11)
> I am also having this bug (KDE Neon 20.04, which is also Ubuntu based).
> 

Hi Aldric - I recently switched to KDE Neon 20.04 and can confirm that the
behaviour you're describing with activities occurs for me too. A simple
workaround is to open a LibreOffice calc empty window in the current activity
prior to opening my tsv. This way your dialog at least stays on the right
activity but it does add an annoying additional step.

But I did find a way to bypass this awful behaviour through a bit of googling
and looking at the related windows thread
(https://bugs.documentfoundation.org/show_bug.cgi?id=32935). In that one, user
John Griessen posted a potential workaround to bypass this csv/tsv dialog box
from even opening but it doesn't work for KDE Neon. But then I came across this
stackoverflow thread:

https://stackoverflow.com/questions/64073090/using-libreoffices-scalc-to-convert-tab-delimited-text-to-excel-from-the-comm

In it, the poster provides a piece of code that works to bypass the dialog box:

libreoffice --calc --infilter="Text - txt - csv (StarCalc):9,39,76,2,1/9"

In Dolphin, you can just right-click on a class of files (in my case TSV),
click "Properties" > "File Type Options" > Under "Application Preference Order"
Libreoffice calc should be at the top, so click it then "Edit" > go to
"Application" tab, then just paste the above text before the "%U" (replacing
whatever's there, e.g. "libreoffice --calc". Now it works for me to open tsv
files directly from the file browser - they stay in the proper activity because
the dialog box is never spawned.

Doesn't actually fix the bug but it does make LibreOffice usable with TSV files
and multiple activities. Hopefully it helps someone.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to