Hello!
We use Nextcoud and Collabora
Is it possible to save text import separator options, namely fixed width?
At the moment, this parameter is saved only within one session of working with a file. After reopening the file, we need to adjust it again by clicking on the ruler
Nextcloud - 29.0.7
Collabora (docker image) - 24.04.13.3
Nextcloud Office - 8.4.12
Hii @kermindi
currently in Collabora Online when importing CSV or plain text files (e.g., .txt
, .csv
), **text import settings like “fixed width” or custom delimiters are not permanently saved with the document. These settings are session-based and reset when the file is closed and reopened, especially in integrations like Nextcloud Office.
unlike .ods
or .xlsx
files, CSV or TXT files do not store import metadata like delimiters or fixed widths.
Convert and Save as Spreadsheet
- Open the
.csv
or .txt
file using your desired import settings (e.g., fixed width).
- Once it’s opened correctly, choose File → Save As and save it as an
.ods
or .xlsx
file.
- Next time, open the
.ods
/.xlsx
file instead — it will retain all structure and formatting.
This is the recommended method if you’re working repeatedly with the same data source.
Ok, thanks
But if I want to add new lines (copy paste text) to the old .ods
/.xlsx
file, then the fixed width will disappear again/will only work in the current session
Or is this applicable to .ods
files as well?