Экспорт CSV правильно открывает Office (сохраняет числа как ТЕКСТ)

Я использую OPEN-OFFICE для работы и сохранения CSV. Я также использую разделитель-запятую и ' " '. Однако при сохранении CSV не все числа инкапсулируются. Как я могу заставить Open-Office обрабатывать числа как текст и также инкапсулировать их. Пример:

"store","website","attribute_set","type","sku","name","price","categories","description","qty","sizet","is_in_stock","status","visibility","tax_class_id"
"admin","base","test","simple","T010013-012","Test12","12","test/test","Desc12",12,"S","1","Enabled","Catalog, Search","Taxable Goods"
"admin","base","test","simple","T010013-013","Test13","13","test/test","Desc13",13,"M","1","Enabled","Catalog, Search","Taxable Goods"
"admin","base","test","simple","T010013-014","Test14","14","test/test","Desc14",14,"L","1","Enabled","Catalog, Search","Taxable Goods"
"admin","base","test","simple","T010013-015","Test15","15","test/test","Desc15",15,"XL","1","Enabled","Catalog, Search","Taxable Goods"
"admin","base","test","simple","T010013-016","Test16","16","test/test","Desc16",16,"XXL","1","Enabled","Catalog, Search","Taxable Goods"
"admin","base","test","configurable","T010013","TestParent","5","test/test","DescParent","30","","1","Enabled","Catalog, Search","Taxable Goods"

Спасибо за помощь. PS: я использую скрипт MAGMI для Magento. Загрузка продуктов

10
задан dusan 8 October 2012 в 17:41
поделиться