I guess the slave column could be column G.
Can't you just copy the $15,25 'buy price' up
into cells C:2 to C:9? Then you can just
calc the slave in column G with a consistent
On 10/13/21 1:04 AM, firstname.lastname@example.org wrote:
I have to calculate prices (buy/sell) and have a question to make it
easier. A little bit maybe:)
The file >http://status.sisi-systems.ovh/article_sample.csv
The file contains the columns Article number, text of the supplier,
purchase price, sales price, the lengths and master (1) slave (0).
The factor is for calculating the purchase price. The master (1)
can be ordered, the slave (0) items not. These are blanks.
The question is can I calculate the slaves automatically by
calculation on the basis of the master?
With hand for example:
With multiple suppliers:
For several articles, this is a monthly job. Isn't there a way to do this
a little automated? Comparison with article number + master / slave? When
it will only work with one supplier it will be okay.
Maybe someone have an idea? It would be great.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- Re: [libreoffice-users] Buy/Sell Calculation · Mike Flannigan
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy