Description: It would be good to be able to link a Calc sheet to Base. So the hard calculating work is done by Calc, while Base would be used for entering data and showing results and reports. Actual Results: - Expected Results: - Reproducible: Always User Profile Reset: No Additional Info: -
Hmm, think this is already supported. See the Base User Guide 6.4, chpt 7 for registering Database, and abt pg. 301 for Calc. https://nextcloud.documentfoundation.org/s/Rt67sEsWtg4TQJR
OP replied via PM Javier Lapaz <carlram9871@gmail.com> Wed 2020-12-02 7:37 PM After reading it, I think it is not supported. You can take data from Base with the Data Source tool and use it in Calc, but in order for the result fields to show back on Base you would have to import it again into Base. There is no real two way link. I can see the Data Source option in Base, but it is not active, it’s always gray.
You could link content of a database to a calc-sheet. It will be refresh every time you reopen the Calc-document. But you can't use the way back from Calc to Base with calculated values. You could only copy the results of your calculation. At this moment all calculation has to be done in the database. Please give an example which will show advantage of the way back from Calc to Base instead of calculating directly in Base. Calculating directly won't destroy the connection between the original values and the calculated result. If you change an original value the result would also be changed in Base. This is a valid enhancement request. So I will set it to NEW.
Here is the example, I’m working on a logbook and I want to calculate the sunrise and sunset times during flights. That takes around 90 cells in a Calc worksheet, some of them with long formulas and references to previewsly calculated results. To do that in Base is not possible, and if it is, is not practical at all.
You say "You could link content of a database to a calc-sheet. It will be refresh every time you reopen the Calc-document", but when I try that, Base doesn't let me add new records. This is from the manual: "Calc or Excel spreadsheets can also be used as the table source for databases. If, however, a Calc spreadsheet is used, no editing of the table data is possible. If the Calc document is still open, it will be write-protected."
(In reply to carlram9871 from comment #5) > You say "You could link content of a database to a calc-sheet. It will be > refresh every time you reopen the Calc-document", but when I try that, Base > doesn't let me add new records. Then you don't link content form the database to Calc. You have set Calc as data source for Base. Have a look at the Base Guide for this.
Robert Großkopf, is this a valid bug/enhancement? You set this as New before another discussion....
(In reply to BogdanB from comment #7) > Robert Großkopf, is this a valid bug/enhancement? > > You set this as New before another discussion.... There are many problems in this request: It will need connecting to 2 databases at the same time (Calc and internal database) for getting the calculated result of Calc with the data supported from base. No Problem to get the data from Base to Calc. Will be updated when Calc has been opened. But it isn't possible to get the result from Calc back to internal database of Base - only if working by macro, but then you won't need Calc at all. I don't know which calculations should be made in Calc, but the calculations you could do with a database depends on the database you use. So most calculations will work directly in Base.