| Summary: | FILTER: can't import csv UTF-8 for non english languages with macros | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | sunweb |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED INVALID | ||
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 4.2.2.1 release | ||
| Hardware: | Other | ||
| OS: | All | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
file in UTF-8
ODS with macros |
||
Created attachment 96536 [details]
ODS with macros
!!!*** Carry this message to developers with them is simply impossible to be written off to foreigners. !!!*** Why is there no Ukrainian version of the site libra office ?? Although it has long been translated! Add it please. You have a very intricate system of reporting bugs (errors) Everything is very closed and difficult! Is it not possible to make a more friendly system? No support for the Ukrainian language ( https://translations.documentfoundation.org/uk/website/multiplanet-uk.po http://uk.libreoffice.org/ - no open(( (In reply to sunweb from comment #0) > aProps( 1 ).name = "FilterData" > aProps( 1 ).Value = "44,34,76,1,1" You should use "FilterOptions" instead of "FilterData". Resolving as INVALID. |
Created attachment 96535 [details] file in UTF-8 Problem description: can't import csv UTF-8 for non english languages using macros only if opened CSV by hand and choose UTF-8. Steps to reproduce: Use the following macros and files that i attached Sub ImportCSV oSheet = thisComponent.Sheets(0) Dim aProps(1) as new com.sun.star.beans.PropertyValue Url = "file:///dev/shm/import.csv" aProps( 0 ).name = "FilterName" aProps( 0 ).Value = "Text - txt - csv (StarCalc)" aProps( 1 ).name = "FilterData" aProps( 1 ).Value = "44,34,76,1,1" oExport = StarDesktop.loadComponentFromURL( Url, "_blank", 0, aProps() ) End Sub Current behavior: Opens CSV file as new ODS file but Ukrainian and Russian languages aren't decoded. Expected behavior: Opens CSV file as new ODS file and decodes everything correctly. Operating System: All Version: 4.2.2.1 release