Hi,
in LibreOffice 4.1.4.2 on Windows XP I have created a new Calc template with two new cell styles. I named them MyCellStyle1 and MyCellStyle2. Then I have set LibreOffice to open this new template when creating new Calc document. When I start LibreOffice and from menu Format | Styles and Formatting I can see this two new styles are included in new Calc document. So far as expected.
Now the problem:
- With text editor create some text document with two columns separated by semicolon. E.g.: data1; data2
and save the document as e.g. myfile.csv
- In LibreOffice Calc, File | Open.
- Select myfile.csv.
- In Text Import select Separator Options | Separated by | Semicolon and click on OK.
- Document is successfully imported.
But now problem appears. When looking into Format | Styles and Formatting | Cell Styles tab and there are no styles MyCellStyle1 and MyCellStyle2. It looks like when opening a csv file the default template does not get started. Is there any special setting to tell Calc to start default template also when importing a csv file and not just when creating new ODF file?
Thanks