When I import a CSV, it ends up in a sheet called 'Sheet1' - I'd love to have a different name eg. 'CSVData' or 'RawData' or somesuch by default, that would be more friendly. Of course we'd then need to translate that - and then we'd need to validate that the translation contained a real sheet name; so a bit of a pain - at least initially though switching to 'CSVData' would be quite fun. It seems likely that the CSV import filter is in: sc/source/filter/orcus/orcusfiltersimpl.cxx (ScOrcusFiltersImpl::importCSV) But it is possible that there is another CSV import filter somewhere; it'd be worth checking the data goes through that method in the debugger first.
Actually that code path (ScOrcusFiltersImpl::importCSV) is used only when the orcus mode is enabled, which, unless you are a coder and know exactly what to do to enable that mode, is disabled by default. The main part of the current CSV import code is in ScImportExport::ExtText2Doc() in sc/source/ui/docshell/impex.cxx. IIRC, we don't really explicitly insert the first sheet instance, and CSV only uses the first sheet. So, you may not find an explicit call to insert new sheet there. You can probably just set the new name to the first sheet at appropriate point during import.
Good idea. Why not adding an option in the CSV import dialog allowing the user to choose between: - using the name of the CSV file (not a good idea if you want to change the CSV file without changing the data processing made on the data in another sheet) - using sheet1 - using something like CSVdata - providing the sheet name he want. Set to enhancement. Best regards. JBF
Created attachment 93774 [details] Make default sheet name to CSVData on CSV import
More friendly would be to act like the real software and set the sheet name to CSV filename.
Created attachment 93800 [details] Make default sheet name to imported filename on CSV import
(In reply to comment #5) > Created attachment 93800 [details] > Make default sheet name to imported filename on CSV import Hi Roger, Your patch seems to have been cut off on the right hand side. Can you re-submit with your whole patch? Thanks.
Created attachment 93826 [details] Make default sheet name to imported filename on CSV import
(In reply to comment #6) > (In reply to comment #5) > > Created attachment 93800 [details] > > Make default sheet name to imported filename on CSV import > > Hi Roger, > > Your patch seems to have been cut off on the right hand side. Can you > re-submit with your whole patch? Thanks. I have re-submited
I saw your attempt to send license statement, but you put the whole statement in the subject line. I'd like you to re-submit your license statement, with the statement in the email body (not in the subject line), with the subject line of "<your name> License statement". Replace the "<your name>" part with your real name. Here is a good example of what a license statement should look like. http://lists.freedesktop.org/archives/libreoffice/2014-January/058712.html Thanks.
(In reply to comment #9) > I saw your attempt to send license statement, but you put the whole > statement in the subject line. > > I'd like you to re-submit your license statement, with the statement in the > email body (not in the subject line), with the subject line of "<your name> > License statement". Replace the "<your name>" part with your real name. > > Here is a good example of what a license statement should look like. > > http://lists.freedesktop.org/archives/libreoffice/2014-January/058712.html > > Thanks. i have re-submitted mail for license statement
(In reply to comment #9) > I saw your attempt to send license statement, but you put the whole > statement in the subject line. > > I'd like you to re-submit your license statement, with the statement in the > email body (not in the subject line), with the subject line of "<your name> > License statement". Replace the "<your name>" part with your real name. > > Here is a good example of what a license statement should look like. > > http://lists.freedesktop.org/archives/libreoffice/2014-January/058712.html > > Thanks. my email about license statement requires moderator's approval. Please look into it.
Aditya Kale committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=a4f09f8c2ef3ae82b86d1b4f0c6c90d1a61614fa fdo#73552 - Set name of CSV import sheet to something friendly The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This patch has broken my sheet and made it unuseable because now is not practicable to modify my links to the CSV data files without renaming them beforehand or modyfing every reference Therefore I would be glad if either this patch is removed or modified in a way which would allow a deactivation from within the program. Which Jean-Baptiste Faure already stated in his comment: - using the name of the CSV file (not a good idea if you want to change the CSV file without changing the data processing made on the data in another sheet)
I tend to agree that a well defined name; eg. 'RawData' would be rather better here, certainly for automation =)
Migrating Whiteboard tags to Keywords: (EasyHack DifficultyBeginner SkillCpp TopicCleanup ) [NinjaEdit]
JanI is default CC for Easy Hacks (Add Jan; remove LibreOffice Dev List from CC) [NinjaEdit]
A polite ping, still working on this issue?
Unassigning, due to lack of work. Remark if you want to continue working on the issue, please assign yourself again.
Changing status to ASSIGNED
Broken predictable external references are tracked with bug 86282