Importing a CSV file from my bank for tax purposes. The currency fields came in as text strings. The only choices to reformat the fields were as dates, general not as a numeric or currency as a result I was unable to perform calculations against these fields without nually strip the string identify from each field! (I see were some one entered a fix request to define numerics as strings. This makes absolutely no sense. (I am lucky I have a MAC. I had to use Apple's Numbers spreadsheet application. Please rethink this.
Importing a CSV file from my bank for tax purposes. The currency fields came in as text strings. The only choices to reformat the fields were as dates, general not as a numeric or currency as a result I was unable to perform calculations against these fields without first manually striping the string identify from each field! I see were some one entered a fix request to define numerics as strings. This makes absolutely no sense. I am lucky I have a MAC. I had to use Apple's Numbers spreadsheet application. Please rethink this.
Is this really a database-bug? Please describe exactly what you are doing. If you import *.csv-files in Calc there appears a wizard, which will show the content of the first fields. Could be you have only to switch in the "Other Options" > "Detect special numbers". Also a *.csv-file with the buggy behaviour (and some dummy-data) could help to see the problem.
I am imported a CSV file from my credit union into a LIBRE Office spreadsheet to work with the data for tax purposed which requires me to Sort and Sum various transactions for tax reporting. The currency fields of the CSV file are treated like text strings with a "'$" leading very number.For example:'$500.00 as a text string of characters instead of being able to define it as a numeric or currency field 500.00 which has an arithmetic value and can be calculated. I'm not sure its a database issue.
This is indeed the wrong component. Base is the database GUI of LibreOffice. Calc is the GUI for spreadsheets. Please post only one row of the original format of the *.csv-file. '$500.00 isn't a part of this, right?
Can not confirm. To bring in currency from strings, you need to check the "Detect special numbers" box in the Other Options field. The text string will then not receive the tic making it a left aligned text string, and will align right as a number. You can then adjust the formatting to you liking.