Ask Your Question

Derived base Calc spreadsheets, does not work "Create query in the editor ..." [closed]

asked 2015-09-23 04:36:42 +0100

updated 2020-08-25 18:30:48 +0100

Alex Kemp gravatar image

(pt-br) Tenho um arquivo Calc com duas planilhas, criei um Base tendo como base esta planilhas, gerou corretamente as tabelas com os nomes das planilhas. Porém quando tento montar uma consulta que necessita relacionamento destas duas tabelas, em "Criar consulta no editor..." na janela aberta, "Adicionar tabelas" mostra as duas tabelas, mas ao selecionar uma e Adicionar a janela fecha, e não consigo incluir a outra tabela.

Isto é padrão, quando Base é derivado de planilhas do Calc, ou tem algo errado ????

(en-google) I have a Calc file with two worksheets, I created a basis based on this spreadsheet correctly generated tables with the names of the worksheets. But when I try to mount a query that requires relationship of these two tables, on "Create query in the editor ..." in the open window, "Add Tables" shows the two tables, but when selecting an e Add the window closes, and can not include the other table.

This is standard when Base is derived from the Calc spreadsheet, or have something wrong ????

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-25 18:31:38.666159

1 Answer

Sort by » oldest newest most voted

answered 2015-09-24 23:18:04 +0100

m.a.riosv gravatar image

Hi Gilberto no error, it's no possible to do relations in Base with spreadsheets.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-09-23 04:36:42 +0100

Seen: 101 times

Last updated: Sep 24 '15