Our club uses the invoice export to excel feature to create a summary control sheet for all orders. A recent change in the way libreoffice calc treats the copying and pasting of formulae has suddenly made it a lot more complicated and time consuming each month - microsoft excel has handled it the same way for a while.
Is it possible to create a version of the export that places all the invoice data into a single sheet in excel though it could exclude the totals and additional items. This would generate a large sheet but would enable the use of pivot tables to generate various summaries.
Possible?