Created attachment 159531 [details] problem file 1
Created attachment 159532 [details] error file
Dobry den, objevil jsem zahadnou chybu pri otevirani CSV souboru aplikaci Calc. Soubor prikladam, jedna se jasne o chybu, prosim o opravu: Tvorim si tabulku pro prenos dat mezi eshopem a ucetnictvim a jeden z produktu v teto tabulce nepochopitelne haze chybu. Prikladam soubor mujfeed.csv se vsemi produkty. Delicim znakem zde je zpetne lomitko \. Pri importu vse probehne spravne az do radku 528 (produkt s nazvem Lollipop Chainsaw), ktery zpusobuje to, ze od nej dal je delici znak ignorovan a import tak spadne, nebot pretece kapacita bunky, do ktere se Calc nepochopitelne rozhodne nacpat zbytek souboru. Zkousel jsem nahradit i jinym delicim znakem - striska (^) a efekt byl stejny. V tom radku je proste neco, co Calc zblbne. Kdyz jsem tentyz radek naimportoval do excelu (import CSV dat), vse probehlo OK. Je to skoda, s Calcem se mi ve veci CSV pracuje nejlepe. Pro lepsi prehlednost prikladam i soubor test3.csv, kde je vyjmuty jen ten samostatny problemovy radek. Je sance nejake opravy? Dekuji S pozdravem Miroslav Hrncir
Hi, I tried to import CSV file to CALC. The separator char was set to \. Line 528 of attached "problem file 1" (mujfeed.csv) causes Calc to start ignoring any following separators and Calc tries to fit the rest of the file into one cell instead of parsing it by \. I tried this even with different separator (like ^) and the error is the same. I attached error file (test3.csv) too, where the problematic line is exported. It makes the same error. There must be something wrong in that line, which cause Calc to start ignoring all separators from this line. I tried to import it to Excel (import CSV data) and it works fine, which means, that there must be an error in the Calc. I just do not want to use EXCEL, I love Calc! :-) Please could you take a look on it and fix it? Thank you very much. Regards Miroslav Hrncir
Oh I am sorry, I forgot the """ for text during import. My fault. After removing it everything works perfectly. So sorry! This ticket could be closed. Thanks and apologizes ... M.Hrncir