Created attachment 67151 [details] Screenshot of CSV properties and the finally reopened CSV document Problem description: We have a spreadsheet with 3 columns (e.g. sku, name,description). All the fields are text. Description is given as HTML code. When using ODS format - we haven't problem at all, but I have to use CSV format. The values in CSV are taken in brackets. If the size of HTML code is bigger then 4 kb it doesn't save in CSV at all. Steps to reproduce: 1. create any table and place in two cells HTML code. The first must be lower 4 kB (for ex.: 33580 bytes). The second - greater then 4 kb (36000 for example). Save in ODS format. It's OK. 2. Select all the cells (Ctrl+A). Mouse rightclick - Format - Text. Save as: name of file. Type - CSV. Check Edit filter settings. Settings: Character set - UTF-8, field delimiter - , text deliniter - " check "qoute all text cells" and SAVE. Close the document. 3. Open the document and you'll see that you have your data in first cell and the emty second cell. Current behavior: Save not all data in CSV format. Expected behavior: MUST save ALL data in CSV format, even it's bigger than 4 kb Platform (if different from the browser): Browser: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.19 (KHTML, like Gecko) Chrome/18.0.1025.162 Safari/535.19
Created attachment 67152 [details] The document in ODS format
Created attachment 67153 [details] After exporting in CSV
Confirmed in 3.6.1.
Nice to meet you. I see this bug for two years, whenethere no one no what it is Magento, and no one knos what it is import product htere. It is a problem in indeeed. I make a table with this fields and I see, that some fields are disappear. So much I can display that some fields, which are bigger than 4 kB are not properly indicates(or inproducesed or inproducted? sorry my English is not good). For inclues - are welcome on email.... :) P.S. Was using O_o and then Libre Office (Ubuntu neeeds) for business works, so this bug is terrible for me...
+1 this is causing major problems for me too
This seems to be fixed? (at least on master?)
Created attachment 79211 [details] LibreOffice 4.0.3.3 Output Can you review if the bug is still around in 4.0.3.3. Thank You, Matthias
Can you review if the bug is still around? Thank you, Matthias
It seems fixed, I can confirm same result as Matthias on LO 4.0.3.3 (Win7 Home Premium 32bit) Anyway loading the attached ODS file sample taking very long time (very high cpu usage). Is it normal? Because that file size only 36 KB
@slow response: This is not expected behaviour, but dealed in another bug(52106). (LibreOffice more or less can not handle situations where the file has a fonttype or language it does not recognize ... something along the lines.-> https://bugs.freedesktop.org/show_bug.cgi?id=52106)
Per comments, marking as WFM - seems to be fixed