"Fields" suggests a database, you mention a spreadsheet, and "frames" suggests a text document, so I don't think your whole problem is particularly well defined here. But inasmuch as your final problem seems to be getting material to spill over naturally between columns in a text document, then separate frames will - as you say - not work. But there are various schemes that will:
o Go to Format | Columns... and make your setting there. Notice that this is a facet of your page style, so you can also find this on the Columns tab of the page style dialogue. By changing page style, you can make the columns extend over only some pages of your document.
o You can even have the columns extend over fractional pages using sections. Go to Insert | Section... to create a section in your document. Set the number of columns in the Insert Section dialogue. Note the "Evenly distribute contents to all columns" option, which is a simple way to arrange that your columns extend exactly as far down the page as necessary.
o If you prefer to use frames (as you mention), it is possible to link frames so that material will flow naturally between them. Select the first frame, click the Link Frames button in the Frame toolbar, and click in the second frame. Repeat for further frames.
I trust this helps.
Brian Barker
![[TEST] Document Foundation Community](https://communitytest.documentfoundation.org/images/discourse-logo-sketch.png){kind=logo}