I've been given some data in a .ods file - energy consumption of a multi-site business. When I open it as a text file (Mac TextEdit) I can see there is data for 3 sites each with 2 utilities. However when I open it with OpenOffice only data for one site and one utility is visible. How do I access the rest?
OO is only showing there being a single sheet.
[Solved] Only part of data file loaded
[Solved] Only part of data file loaded
- Attachments
-
- Screenshot 2020-09-05 at 15.51.23.png (34.28 KiB) Viewed 824 times
-
- Screenshot 2020-09-05 at 15.48.36.png (20.98 KiB) Viewed 824 times
Last edited by MrProgrammer on Sat Sep 05, 2020 5:37 pm, edited 3 times in total.
Reason: Tagged with ✓
Reason: Tagged with ✓
OpenOffice 4.1.7 on MacOS 10.15.6
Re: Only part of data file loaded
It seems that some rows are filtered. Try selecting the entire visible region and then selecting the menu Data -> Fitler -> Remove Filter. Alternatively, select all of column A and choose the menu item Format -> Row -> Show.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: [Solved] Only part of data file loaded
Great, thanks, the second suggestion fixed it. Why would this have been needed?
OpenOffice 4.1.7 on MacOS 10.15.6
Re: [Solved] Only part of data file loaded
The previous user of the file may have used that filter.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: [Solved] Only part of data file loaded
Since the data came as an ods file, I have to assume the previous user hid those rows for some reason. I have never heard of a file getting filtered by merely opening it.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.