Please consider improving how scatter plots interpret input data in LibreOffice Calc, as the current behavior is quite problematic in practice. When working with datasets arranged as consecutive XY column pairs, for example:
x1 y1 x2 y2
Calc treats each column as an independent data series instead of recognizing (x1, y1) and (x2, y2) as two separate XY datasets. As a result, the generated chart is incorrect unless the user manually edits each data series and assigns X and Y ranges one by one.
This behavior is unintuitive, especially in scientific and experimental contexts where such a data layout is very common. It significantly slows down workflow and creates unnecessary friction for users who expect the software to interpret adjacent columns as paired data.
It would be highly beneficial if Calc could either automatically detect XY column pairs in such cases or provide an explicit option in the chart wizard, such as “Interpret adjacent columns as XY pairs.” This would improve usability without breaking existing functionality, as it could remain an opt-in feature.
Overall, this seems like a relatively small UX improvement that could make working with scatter plots much more efficient and aligned with user expectations.