[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #66 from grovel...@gmail.com --- See corrected macro at bug 156144. -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #65 from mrjjacobs --- I have a spreadsheet that I use to balance my accounts. It needs that I print a Trial Balance to CSV for every date presented in my spreadsheet (e.g. every day of March) and it LibreOffice BASIC to

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #64 from Mike Kaganski --- (In reply to GroveLn22 from comment #63) > I use a basic macro to open > approximately 40 csv files daily. This macro worked with version 6.0.7.3 of > libreoffice calc as well as earlier version

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #63 from grovel...@gmail.com --- I have the same problem as Knocks. I use a basic macro to open approximately 40 csv files daily. This macro worked with version 6.0.7.3 of libreoffice calc as well as earlier version 5.4.3.2.

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Mike Kaganski changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 V Stuart Foote changed: What|Removed |Added CC||russdewo...@gmail.com ---

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Cor Nouws changed: What|Removed |Added Version|7.0.1.2 release |unspecified --- Comment #61 from Cor

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Heiko Tietze changed: What|Removed |Added CC||220...@mail.ru --- Comment #60

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Branko changed: What|Removed |Added CC||branislav.gera...@gmail.com

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #58 from bla...@gmail.com --- If you want to just open a .csv file in Windows using LibreOffice, do this: Open a CMD prompt as admin and enter these 2 commands: assoc .csv=LibreOffice.Csv ftype LibreOffice.Csv="C:\Program

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #57 from efwb...@gmail.com --- (In reply to Xisco Faulí from comment #56) > Changing priority back to 'medium' since the number of duplicates is lower > than 5 Say what? From my perspective this bug reads "Calc is completely

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Xisco Faulí changed: What|Removed |Added Priority|high|medium --- Comment #56 from Xisco

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #55 from Gareth --- Many thanks. Couldn't find any useful documentation on the HTML filter options, so tried hacking a filter based on the CSV one, the info required by the HTML import dialog, and the limited info in the docs

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #54 from Eike Rathke --- (In reply to Gareth from comment #52) > --infilter="calc_HTML_WebQuery":"Neutral locale language : 0" I don't know where you got the "Neutral locale language : 0" part from. While that works

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #53 from DM --- ^That worked perfectly. Thank you very, very much! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #52 from Gareth --- And, just in case anyone else also uses them, here is a parameter that does the same job for HTML imports: --infilter="calc_HTML_WebQuery":"Neutral locale language : 0" -- You are receiving this mail

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #51 from Gareth --- To set up the workaround described in Comment 47 so that it works in Windows, you need to edit the file association. Windows makes this unreasonably difficult to do, but luckily there is a freeware tool,

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #50 from DM --- Is there a way to apply this fix on Windows? I would love to be able to open CSV files without having to go through that dialogue box every time. -- You are receiving this mail because: You are the assignee

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #49 from grnbrg --- Not a bad hack to solve this. For those who want to use this, and are interested, the options for the "--infilter" argument (which allows the separator and text quoting characters to be defined) are

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #48 from Knocks --- OP here. It's been nearly 6 years since I opened this ticket, and since no one seems to care about fixing an issue that so many people are complaining about, I am washing hands away from it and

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #47 from John --- +1 for addressing this. I too have to open lots of CSV files, and am trying to transition from Windows/Excel to Ubuntu/LO. I was happier running a Windows VM just to keep using Excel, due to this issue.

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #46 from xzwvt --- This is a major issue. Those saying it is not significant have never experienced it. Add 100 clicks per day to your ongoing click count and you will very shortly have a different opinion. It is a known issue

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #45 from sedlmeier --- For me this is also a misfeature/bug. I am creating usualy 4 to 10 csv at a time and they are opened simutaniously, so it is very tedious to click to all boxes. When i hit enter after generating a batch,

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #44 from grnbrg --- Adding another vote for this issue. I understand that CSV files *can* have significant variation in format. However, that variation is likely to be much lower for each individual user. A similar issue

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #43 from Gareth --- HTML opening issue seems to be fixed in 6.2. Many thanks again. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #42 from Gareth --- Thanks Mike, and apologies, Cor. I can confirm that it is fixed for CSV imports in 6.12. However, the ability to open HTML imports from Windows Explorer in Calc appears to have been removed: they get

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Gareth changed: What|Removed |Added See Also||https://bugs.documentfounda

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #41 from Mike Kaganski --- (In reply to Gareth from comment #39) > A second problem, with both CSV and HTML import dialogs, is that they have > the wrong parent window. In Windows 7-10, this leads to the following > behaviour:

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #40 from Cor Nouws --- (In reply to Gareth from comment #39) > A second problem, with both CSV and HTML import dialogs, is that they have > the wrong parent window. In Windows 7-10, this leads to the following Thanks Gareth.

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #39 from Gareth --- A second problem, with both CSV and HTML import dialogs, is that they have the wrong parent window. In Windows 7-10, this leads to the following behaviour: * If LibreOffice is closed, the dialog appears

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Heiko Tietze changed: What|Removed |Added Priority|medium |high --- Comment #38 from Heiko

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #37 from Kyle --- The public has been asking for this to be addressed to our needs for years at this point. I too must beg for this bug/enhancement to be fixed/improved. Like Dirk from 2015, I have to open/edit 25-100s of

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #36 from Heiko Tietze --- (In reply to James from comment #35) > I see this issue was raised 4 years ago, and I really can't understand why > there is so much resistance to aiding usability for the majority of users. You are

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #35 from James --- I know it has been a while but I would like to add my two cents worth to this also. We are providing computers as part of an industrial research rig package- the rigs are controlled using propriety software

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #34 from Neutrino --- (In reply to csongor from comment #27) > 1. heuristics, that try to make smart guesses how to understand files. It > mostly works but sometimes not. This is what Excel does

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #33 from Mike Kaganski --- We have a checkbox in Save As dialog named "Edit filter settings". A counterpart in File Open dialog would be natural and consistent. It could be checked by default, and

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Mike Kaganski changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #30 from Gareth --- In reply to Comment #29 (from V Stuart Foote) re. whether a parallel task is needed for the HTML import. > Importing sheet data from HTML is very much a corner case, in fact a

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #29 from V Stuart Foote --- (In reply to Gareth from comment #28) > The same issue exists with HTML. (As mentioned above at Comment #10.) If > csongor's solution is chosen, then a separate task

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #28 from Gareth --- In reply to cson...@halmai.hu (Comment #27) > currently only CSV would exist there The same issue exists with HTML. (As mentioned above at Comment #10.) If csongor's solution is

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #27 from cson...@halmai.hu --- (In reply to Knocks from comment #25) > And as others have mentioned above, Excel does this right. LibreOffice does > it wrong and is user-hostile. I have to contradict, sorry. :) Sometimes

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #26 from Cor Nouws --- Suggest discussing at UX-meeting. Just hitting "Enter" is enough. One might expect that the regular csv-openers will understand that soon enough. Also looking at Eike's advice, my

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #25 from Knocks --- And as others have mentioned above, Excel does this right. LibreOffice does it wrong and is user-hostile. I opened this ticket 4 years ago and have since moved to a different

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #24 from Eike Rathke --- As already mentioned in comment 1 the settings meanwhile are remembered and, except the column types, presented as pre-set for the next open. An extra "open bypassing the dialog"

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 V Stuart Foote changed: What|Removed |Added CC|

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Cor Nouws changed: What|Removed |Added Keywords||needsUXEval

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #22 from Shepelev Stanislav --- This is plain stupid. That's why free software is doomed. Every user says: "just do the same thing that successful MS Excel did long ago", and every free developer says:

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 --- Comment #21 from jeramy --- This does seem like an obvious and easy problem to resolve--as stated above, and elsewhere, simply create an option to open with whatever default character set the user has

[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file ( see comment #13)

https://bugs.documentfoundation.org/show_bug.cgi?id=74580 Cor Nouws changed: What|Removed |Added Status|REOPENED|NEW