https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Mike Kaganski changed:
What|Removed |Added
See Also||https://bugs.documentfounda
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.
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 constr
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 5.4.
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. a
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Mike Kaganski changed:
What|Removed |Added
See Also||https://bugs.documentfounda
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
V Stuart Foote changed:
What|Removed |Added
CC||russdewo...@gmail.com
--- Commen
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Heiko Tietze changed:
What|Removed |Added
CC||220...@mail.ru
--- Comment #60 fro
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Branko changed:
What|Removed |Added
CC||branislav.gera...@gmail.com
V
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 Files\
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 us
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Xisco FaulĂ changed:
What|Removed |Added
Priority|high|medium
--- Comment #56 from Xisco F
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 l
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 accidentall
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
Libreo
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 beca
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, Nir
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 f
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 describ
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 unsubscribin
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.
Tha
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
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,
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 has
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 mai
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 redirec
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Gareth changed:
What|Removed |Added
See Also||https://bugs.documentfounda
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:
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. I
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 fi
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Heiko Tietze changed:
What|Removed |Added
Priority|medium |high
--- Comment #38 from Heiko Ti
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 C
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 v
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 t
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 and if it fails then
> you have
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 when unchecked, would suppress
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Mike Kaganski changed:
What|Removed |Added
CC||info_...@mail.ru
--- Comment #32
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Heiko Tietze changed:
What|Removed |Added
Keywords|needsUXEval |needsDevEval
CC|li
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 user
> given a preference sh
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 probably needs to be
> raised fo
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 chosen, then a separate task
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 I
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 suggestions is: Close a
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 industry that no longer requir
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" option IMHO just adds c
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
V Stuart Foote changed:
What|Removed |Added
CC||er...@redhat.com,
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Keywords||needsUXEval
CC|
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: "that won't work".
--
Y
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 chosen--that's what options are fo
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Status|REOPENED|NEW
Summary|FILEOPEN: Add
51 matches
Mail list logo