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
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
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.
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
---
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Branko changed:
What|Removed |Added
CC||branislav.gera...@gmail.com
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
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Xisco FaulĂ changed:
What|Removed |Added
Priority|high|medium
--- Comment #56 from Xisco
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
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
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
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
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,
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
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
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
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.
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
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
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
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.
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Heiko Tietze changed:
What|Removed |Added
Priority|medium |high
--- Comment #38 from Heiko
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
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
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
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
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Mike Kaganski changed:
What|Removed |Added
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Heiko Tietze changed:
What|Removed |Added
Keywords|needsUXEval
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
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
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
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
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
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
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"
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
V Stuart Foote changed:
What|Removed |Added
CC|
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Keywords||needsUXEval
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:
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
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Status|REOPENED|NEW
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Status|RESOLVED|REOPENED
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
QA Administrators changed:
What|Removed |Added
Status|NEEDINFO
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
--- Comment #17 from QA Administrators ---
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Hardware|Other |All
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
AAAfarmclub changed:
What|Removed |Added
OS|All |Android
---
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
--- Comment #15 from Cor Nouws ---
(In reply to Pablo Frias from comment #14)
> I m facing the same issue, have tons of CVS files generate by a internal
Hi Pablo,
I very well understand your point and understand it's
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
--- Comment #14 from Pablo Frias ---
I m facing the same issue, have tons of CVS files generate by a internal
website we use at the company. The final user manually open the CVS reports but
it s annoying getting the
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
Cor Nouws changed:
What|Removed |Added
Status|REOPENED|NEEDINFO
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
--- Comment #12 from dirkmccalla...@hotmail.com ---
I would also like for this issue to be addressed. My job involves opening
dozens of CSV files every day (sometimes hundreds, depending on the current
project I'm working on), and as all
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
tre...@gmail.com changed:
What|Removed |Added
Status|RESOLVED|REOPENED
https://bugs.documentfoundation.org/show_bug.cgi?id=74580
tre...@gmail.com changed:
What|Removed |Added
Version|4.2.0.4 release |4.4.0.3 release
--
You are
https://bugs.freedesktop.org/show_bug.cgi?id=74580
Cor Nouws c...@nouenoff.nl changed:
What|Removed |Added
See Also||https://bugs.freedesktop.or
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #8 from Gareth gareth.adam...@gmail.com ---
This should not be marked resolved. The program behaviour ignores a significant
use case.
The use case ignored is where an office has a program which generates many csv
files per day, which
https://bugs.freedesktop.org/show_bug.cgi?id=74580
Gareth gareth.adam...@gmail.com changed:
What|Removed |Added
See Also|
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #9 from Gareth gareth.adam...@gmail.com ---
Found the other bug has already been reported many times. Added a link.
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #10 from Gareth gareth.adam...@gmail.com ---
Same applies to HTML imports.
Should another bug be raised for that?
--
You are receiving this mail because:
You are the assignee for the bug.
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #3 from Jeff Sadowski jeff.sadow...@gmail.com ---
Why can't we save the settings for a file type?
I'd like csv's to always be one way without the dialog all the time.
It would be nice if we could save the settings with the dialog for
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #4 from Cor Nouws c...@nouenoff.nl ---
(In reply to Jeff Sadowski from comment #3)
Why can't we save the settings for a file type?
Because not every csv that people import, has the same format.
I'd like csv's to always be one way
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #5 from Jeff Sadowski jeff.sadow...@gmail.com ---
(In reply to Cor Nouws from comment #4)
(In reply to Jeff Sadowski from comment #3)
Why can't we save the settings for a file type?
Because not every csv that people import, has
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #6 from Cor Nouws c...@nouenoff.nl ---
(In reply to Jeff Sadowski from comment #5)
I understand that is why I ask for an option in the settings. To select
whether or not we get the dialog.
Sorry, but it was not clear to me that
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #7 from Jeff Sadowski jeff.sadow...@gmail.com ---
(In reply to Cor Nouws from comment #6)
(In reply to Jeff Sadowski from comment #5)
I understand that is why I ask for an option in the settings. To select
whether or not we get
https://bugs.freedesktop.org/show_bug.cgi?id=74580
Cor Nouws c...@nouenoff.nl changed:
What|Removed |Added
Status|UNCONFIRMED |RESOLVED
https://bugs.freedesktop.org/show_bug.cgi?id=74580
--- Comment #2 from Knocks bigazzkno...@gmail.com ---
It remembers the last choice. so Enter (OK) is enough.
I'm not sure what you mean by enough. It requires you to do that for every
CSV file that you ever open. For people who opens lots of
74 matches
Mail list logo