[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

Stephane MANKOWSKI  changed:

   What|Removed |Added

  Latest Commit||https://commits.kde.org/skr
   ||ooge/62409a23b6937e38fc3f4b
   ||f258ba131d05a760c1
 Status|CONFIRMED   |RESOLVED
 Resolution|--- |FIXED

--- Comment #10 from Stephane MANKOWSKI  ---
Git commit 62409a23b6937e38fc3f4bf258ba131d05a760c1 by Stephane Mankowski.
Committed on 17/01/2018 at 17:40.
Pushed by smankowski into branch 'master'.

Splitting Currency and Amount into separate columns

M  +1-0CHANGELOG
M  +17   -4skgbankgui/skgobjectmodel.cpp
M  +5-5skgbankmodeler/skgdocumentbank.cpp
M  +85   -21   skgbasegui/skgtreeview.cpp
M  +1-0skgbasegui/skgtreeview.h

https://commits.kde.org/skrooge/62409a23b6937e38fc3f4bf258ba131d05a760c1

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #9 from dterr...@yahoo.com ---
Sure, sure, absolutely. I'm happy with this. Thank you!

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

Stephane MANKOWSKI  changed:

   What|Removed |Added

 Attachment #109935|0   |1
is obsolete||

--- Comment #8 from Stephane MANKOWSKI  ---
Created attachment 109944
  --> https://bugs.kde.org/attachment.cgi?id=109944=edit
Copy / paste with only needed raw and unit and better management of boolean

Hi,

Here is a new version taking into account your remark about boolean attributes.
I don't know what to do with the "strange characters" because in fact this is
an unbreakable space between the amount and its unit. I prefer to keep it like
this event if windows doesn't manage it well.

Do you agree to close this incident like this?
Regards.

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #7 from dterr...@yahoo.com ---
That looks good! (although under Windows, I'm looking at it at work, Excel sees
some strange characters in the currency symbols; maybe it doesn't recognize
that it is UTF-8? Either way; it won't be a problem for me because I don't use
symbols but 3 letter codes)

There are a few columns (booleans) that get duplicated because N gets formatted
as "". The separate raw column might not be useful, so you could filter those
out.

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

Stephane MANKOWSKI  changed:

   What|Removed |Added

 Attachment #109895|0   |1
is obsolete||

--- Comment #6 from Stephane MANKOWSKI  ---
Created attachment 109935
  --> https://bugs.kde.org/attachment.cgi?id=109935=edit
Copy / paste with only needed raw and unit

Hi,
I did a correction with:
1-to keep only needed raw columns (when at least one raw value is different
than the displayed value) 
2- Better header title
3- New unit column for "operation"

Is this result the expected one?

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #5 from dterr...@yahoo.com ---
Yes, the raw columns would be useful for me, with a separate column for the
currency code.

Somehow there seem to be extra characters in the non-raw columns with currency
values that do not show up under linux LibreOffice, but that turn into strange
symbols (�贈) under windows.

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #4 from Stephane MANKOWSKI  ---
Created attachment 109895
  --> https://bugs.kde.org/attachment.cgi?id=109895=edit
Result of copy paste

Hi,

I did a small correction to copy/paste the displayed values AND the raw values.
As you can see, this could be interesting for dates and values.

Do you think this could help you?
Regards.

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

Stephane MANKOWSKI  changed:

   What|Removed |Added

 Status|UNCONFIRMED |CONFIRMED
 Ever confirmed|0   |1

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #3 from dterr...@yahoo.com ---
Hi Stephane,

I use three letter currency codes, rather than symbols, because that's how most
of my banks set it in their ofx files and otherwise I always end up with a
duplicate unit and need to fix it afterwards.

I have attached a test skrooge document with 6 accounts, 2 for each currency
GBP (my base currency), USD and EUR, each with a 3 letter code and with a
symbol. If I show all transactions with Category "Interest" and then copy paste
to LibreOffice (5.4.4) only the £ version gets converted to a number (it is my
system currency, which Libreoffice picks up); the others are strings with code
and number combined.
(copy pasting into this forum messes up formatting, but I have right aligned
the numbers manually below whereas the strings are left aligned).

Account Amount  Amount entered
USD2 £72.82 USD100.00
USD1 £72.82 $100.00
GBP2£100.00 GBP100.00
GBP1£100.00 £100.00
EUR2 £88.81 EUR100.00
EUR1 £88.81 €100.00

Even if I could get libreoffice to "ignore" the currency code, I still need it
to determine the exchange rate (unless I can fetch the correct one from
Skrooge; I asked a question on the forum because I don't know if this is
possible maybe using monthly reports).

This is very much wishlist; I may be the only one to benefit if you "fix" this
for me, so I won't be offended if you ignore it and I'll continue to use my
workaround. :-)

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[bugzilla_noreply]

https://bugs.kde.org/show_bug.cgi?id=388955

--- Comment #2 from dterr...@yahoo.com ---
Created attachment 109860
  --> https://bugs.kde.org/attachment.cgi?id=109860=edit
currency export test database

-- 
You are receiving this mail because:
You are watching all bug changes.

[skrooge] [Bug 388955] Splitting Currency and Amount into separate columns

[Stephane MANKOWSKI]

https://bugs.kde.org/show_bug.cgi?id=388955

Stephane MANKOWSKI  changed:

   What|Removed |Added

   Assignee|guillaume.deb...@gmail.com  |steph...@mankowski.fr

--- Comment #1 from Stephane MANKOWSKI  ---
Hi,

What is your detailed scenario?
I tried this one:
1- Open Skrooge
2- Open the operations page
3- Select some operations
4- Right click + "Copy"
5- Open LibreOffice 5.1.6.2
6- Paste

Result:
Amounts are well received by LibreOffice with units but are well parsed and
only the value is set in the cells (without the unit).

-- 
You are receiving this mail because:
You are watching all bug changes.