Mdthbs

How can I shoot a bow using Strength instead of Dexterity?

The more + the + comparative degree

What should I do with the stock I own if I anticipate there will be a recession?

What should I do if actually I found a serious flaw in someone's PhD thesis and an article derived from that PhD thesis?

How can I find an old paper when the usual methods fail?

Is the Microsoft recommendation to use C# properties applicable to game development?

What was the intention with the Commodore 128?

What is the farthest a camera can see?

Doesn't the speed of light limit imply the same electron can be annihilated twice?

Why do so many people play out of turn on the last lead?

Is there a fallacy about "appeal to 'big words'"?

Did Michelle Obama have a staff of 23; and Melania have a staff of 4?

Some pads on a PCB are marked in clusters and I can't understand which one is which

Will some rockets really collapse under their own weight?

Adding things to bunches of things vs multiplication

What should we do with manuals from the 80s?

Can a Battle Master fighter with Extra Attack use the Commander's Strike maneuver before he throws a net?

Is there a name for the technique in songs/poems, where the rhyming pattern primes the listener for a certain line, which never comes?

Number in overlapping range

How do I ask for 2-3 days per week remote work in a job interview?

Does an Irish VISA WARNING count as "refused entry at the border of any country other than the UK?"

What would cause a nuclear power plant to break down after 2000 years, but not sooner?

How do figure out how powerful I am, when my abilities far exceed my knowledge?

Are there really no countries that protect Freedom of Speech as the United States does?

How to avoid Text Import form when opening CSV in Calc?

How to count similar results in several columns in Libre Office Calc?How to calculate percentages in LibreOffice Calc?How to show only the last two digits of a number in LibreOffice Calc?How to plot one dimensional data with margin of error in LibreOffice Calc?Calc: How to convert a numeric column in-place?Calc adds ' (apostrophe) when importing time from CSVhow to import customers to dolibarrHow to do sum calculations in libreoffice calc, single column

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

1

I regularly need to open CSV files of a certain format in Libre Office Calc (on Linux Mint). The format is always a comma separator and the first column a date as D/M/Y.

Could anyone suggest a way to open these files without having to repetitively specify the format on the Text Import form, which normally appears when a CSV is opened.

I will happily consider command-line options, any script or macro or even an AutoKey script. The only restriction is that it should not interfere with the opening of CSVs that don’t fit this format.

Example data:

11 Jul 19, “Description 1”, 12.34

06/8/19, “Description 2”, 56.78

31/7/19, “Description 3”, 90.00

Edit - date formats

The mixed date formats are handled by Calc, when you set column A to be of type Date (on the Import Text dialogue). The solution should include this functionality.

libreoffice

share|improve this question

edited yesterday

Peter bill

asked yesterday

Peter billPeter bill

2833 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You have two formats of date in your data, you want to convert them to one format?
  
  – guillermo chamorro
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Create a script that opens your file with libreoffice calc and the format options you need and open those files with that script instead of calc directly
  
  – Philippos
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @guillermochamorro - please see edit..
  
  – Peter bill
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Philippos - that's the point of the question - how? My reading of the command-line options indicates no such facility.
  
  – Peter bill
  yesterday
  

  
  
  
  

add a comment | 

1

I regularly need to open CSV files of a certain format in Libre Office Calc (on Linux Mint). The format is always a comma separator and the first column a date as D/M/Y.

Could anyone suggest a way to open these files without having to repetitively specify the format on the Text Import form, which normally appears when a CSV is opened.

I will happily consider command-line options, any script or macro or even an AutoKey script. The only restriction is that it should not interfere with the opening of CSVs that don’t fit this format.

Example data:

11 Jul 19, “Description 1”, 12.34

06/8/19, “Description 2”, 56.78

31/7/19, “Description 3”, 90.00

Edit - date formats

The mixed date formats are handled by Calc, when you set column A to be of type Date (on the Import Text dialogue). The solution should include this functionality.

libreoffice

share|improve this question

edited yesterday

Peter bill

asked yesterday

Peter billPeter bill

2833 bronze badges

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You have two formats of date in your data, you want to convert them to one format?
  
  – guillermo chamorro
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Create a script that opens your file with libreoffice calc and the format options you need and open those files with that script instead of calc directly
  
  – Philippos
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @guillermochamorro - please see edit..
  
  – Peter bill
  yesterday
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Philippos - that's the point of the question - how? My reading of the command-line options indicates no such facility.
  
  – Peter bill
  yesterday
  

  
  
  
  

add a comment | 

I regularly need to open CSV files of a certain format in Libre Office Calc (on Linux Mint). The format is always a comma separator and the first column a date as D/M/Y.

Could anyone suggest a way to open these files without having to repetitively specify the format on the Text Import form, which normally appears when a CSV is opened.

I will happily consider command-line options, any script or macro or even an AutoKey script. The only restriction is that it should not interfere with the opening of CSVs that don’t fit this format.

Example data:

11 Jul 19, “Description 1”, 12.34

06/8/19, “Description 2”, 56.78

31/7/19, “Description 3”, 90.00

Edit - date formats

The mixed date formats are handled by Calc, when you set column A to be of type Date (on the Import Text dialogue). The solution should include this functionality.

libreoffice

share|improve this question

edited yesterday

Peter bill

asked yesterday

Peter billPeter bill

2833 bronze badges

11 Jul 19, “Description 1”, 12.34

06/8/19, “Description 2”, 56.78

31/7/19, “Description 3”, 90.00

share|improve this question

edited yesterday

Peter bill

asked yesterday

Peter billPeter bill

2833 bronze badges

share|improve this question

edited yesterday

Peter bill

asked yesterday

Peter billPeter bill

2833 bronze badges

asked yesterday

Peter billPeter bill

2833 bronze badges

asked yesterday

Peter billPeter bill

2833 bronze badges