Dne 28.12.2011 18:28, berntie napsal(a):
Jay Lozier wrote
What are you actually trying to do? It sounds like your trying do
something that a database may be better at doing.
I'm just trying to keep some kind of record of my daily expenses. While
there's some hassle involved, LibreOffice provide
Jay Lozier wrote
>
> What are you actually trying to do? It sounds like your trying do
> something that a database may be better at doing.
I'm just trying to keep some kind of record of my daily expenses. While
there's some hassle involved, LibreOffice provides all the features I need
for that p
ibreoffice-users] Re: Cell formatting with CSV files in Calc
To: users@global.libreoffice.org
Date: Sunday, 4 December, 2011, 1:06
Pedro wrote
>
>
> berntie wrote
>>
>> When I open my CSV file, select the date column and go to "Data ->
>> Validity" and t
On 12/03/2011 05:43 PM, berntie wrote:
Jay Lozier wrote
* File a bug/feature request? If yes, where can I do that?
File a feature request for a currency data type
Where can I do that?
You will need a free bugzilla account to use this (a link is provided)
https://www.libreoffice.org/get-help/b
Pedro wrote
>
>
> berntie wrote
>>
>> When I open my CSV file, select the date column and go to "Data ->
>> Validity" and tell Calc to disallow dates before, say, 01.01.2010, then I
>> can nonetheless enter, e.g., 01.01.2009.
>>
>
> Did you check the "Show error message" option in the Error A
berntie wrote
>
> When I open my CSV file, select the date column and go to "Data ->
> Validity" and tell Calc to disallow dates before, say, 01.01.2010, then I
> can nonetheless enter, e.g., 01.01.2009.
>
Did you check the "Show error message" option in the Error Alert tab?
When you type anyt
Pedro wrote
>
>
> berntie wrote
>>
>> Oh, and by the way, can you confirm that data validation does not work
>> with CSV files?
>>
>
> I'm glad I could help ;)
>
> What do you mean? Data validation is performed by Calc, it is not affected
> by the file format.
>
> Can you explain what you d
berntie wrote
>
> Oh, and by the way, can you confirm that data validation does not work
> with CSV files?
>
I'm glad I could help ;)
What do you mean? Data validation is performed by Calc, it is not affected
by the file format.
Can you explain what you did, what happened and what you expect
Pedro wrote
>
> What you need to do is
>
> 1) You CAN'T use the Save button
> 2) You must always Save As (although you can overwrite your csv file)
> 3) In the Save As dialog, always check the bottom box "Edit filter
> settings"
> 4) On the next dialog choose "Keep current format" (meaning save
berntie wrote
>
> First of, I've unintentionally replied to your address only. Sorry for
> that.
No problem ;)
berntie wrote
>
> I just want to export as CSV, I don't want to export the formats.
> Basically:
>
> I want to edit a CSV. And by "editing" I mean "adding and/or modifying
> lines".
Jay Lozier wrote
>
>> * File a bug/feature request? If yes, where can I do that?
> File a feature request for a currency data type
Where can I do that?
Jay Lozier wrote
>
>> * Work around the issue? What would that workaround be??
> Work around appears to be import as standard, then format the
Pedro wrote
>
> Can you explain why you want to export as CSV including formats? Maybe we
> can throw same alternative solutions...
>
First of, I've unintentionally replied to your address only. Sorry for that.
I just want to export as CSV, I don't want to export the formats. Basically:
I want
berntie wrote
>
> "Date";"Item";"Amount"
> Donnerstag, 01. Dezember 2011;"New laptop";-1.000,00 EUR
> Freitag, 02. Dezember 2011;"Glass of beer";-3,00 EUR
>
There is a basic problem in your procedure: you can not export formats in
the CSV file. So when you export the dates in the first column
13 matches
Mail list logo