Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Hallo everyone.


We are using a spreadsheet with a pivot table to generate price lists. The price lists show prices for some sets of products. Each time somebody wants to see actual price, must do 2 things:
- choose a name of the set from a drop down list and
- put a current rate in a certain cell to update the prices.

Then the spreadsheet:
1. checks what kind and how many items belong to the certain set
2. checks foreign description of each item and puts its proper translation
3. checks prices, multiply them by the given rate and number of items and sum up everything
4. runs macros to format data and present it nicely in the pivot

Everything works fine until I have to make data modifications (i.g. if some products are not produced any more, or the prices are changed etc.). At this point updating a spreadsheet becomes a complicated and time consuming task. I think it would be easier for me to maintain these data in LO Base instead of using spreadsheet. I believe everything could be accomplished with some tables, one or few queries and front-end form that will be based on these queries. This form will be used to retrieve and present data only (not for modifying data in database).

Question before I'll start designing a database (I'm a novice in Base):

Is it possible to make a field in this front-end form where users can put a rate to calculate prices in the table or query "on the fly" (like in the spreadsheet, where a certain cell is referred to a range of cells in another worksheet)? I'll appreciate any help.

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.