Page 1 of 1
Re: Compare Two Periods Report
Posted: Sun Dec 04, 2022 1:15 pm
by Renato
Renato wrote: ↑Sat Dec 03, 2022 8:16 pm
I prefere generate a report directly into MMEX.
No such evaluation is provided, but you can submit a request at
https://github.com/moneymanagerex/money ... +is%3Aopen.
Due to the many number of requests and little programming capacity it will take some time.
Information to PIvot, you can read:
https://support.microsoft.com/en-us/off ... 9134456576
Note: Unfortunately, the CTRL+c function does not work in the "All transactions" report, otherwise it would be possible to transfer the selected transactions to Excel in a simple way. See:
https://github.com/moneymanagerex/money ... ssues/5394
Re: Compare Two Periods Report
Posted: Sun Dec 04, 2022 3:43 pm
by MartinArmstrong
@Renato, as a workaround you can do this:
1. Go to the All Transactions view.
2. File | Export | HTML Files and save the file (
xxx.html)
3. Open
xxx.html in Excel, or just drag it into an open worksheet. You now have the transaction data, as you would have if you did copy/paste.
Re: Compare Two Periods Report
Posted: Sun Dec 04, 2022 4:09 pm
by Renato
Hi @MartinArmstrong
thanks for the tip, but the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
Re: Compare Two Periods Report
Posted: Sun Dec 04, 2022 6:32 pm
by MartinArmstrong
Renato wrote: ↑Sun Dec 04, 2022 4:09 pm
the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
I don't have that problem because my thousands separator in Windows
and in MMEX is a comma.
excel_cjoDozss90.png
If you want to use a space thousands separator in Excel (while keeping your Windows thousands separator in other applications), then in Excel:
- Click File > Options
- Click Advanced
- Under Editing Options, clear the check box Use system separators
- Click in the Thousands separator box
- Enter a space
- Click OK
ZWk11YhV3I.png
Re: Compare Two Periods Report
Posted: Sun Dec 04, 2022 7:24 pm
by Renato
Hi @MartinArmstrong
Thank you very much, I did not know, has worked perfectly.
Re: Compare Two Periods Report
Posted: Wed Sep 27, 2023 4:06 pm
by Noelok
MartinArmstrong wrote: ↑Sun Dec 04, 2022 6:32 pm
Renato wrote: ↑Sun Dec 04, 2022 4:09 pm
the amounts > 999.99 are displayed with a thousand delimitation "2 000 000.00" and Excel cannot calculate with that.
I don't have that problem because my thousands separator in Windows
and in MMEX is a comma.
Hi - How did you get MMEX to use comma as thousands separator? That would help me a lot!