Description: List images in order of document appearance in navigator Steps to Reproduce: Follow-up on bug 134960 (writer) 1. Open attachment 193254 [details] 2. Open the navigator. Expand images 3. Start clicking on imaged listed Actual Results: Jumping around the spreadsheet in erratic manner (likely insertion order) Expected Results: Well this more complex compared to Writer. With rows and columns I would assume them to be listed by row. So all images in a row. So all images in each row (distributed across columns). Followed by all images in the next row etc And maybe a filter where to navigator only list items with a certain selected area; not sure if this actually workable, though Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b38974391e8d4bf0d450abfaa86bbccbe1022995 CPU threads: 8; OS: macOS 14.3; UI render: Skia/Metal; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
I'd call this an enhancement. UX/Design, Jim, what do you think? Relevant fixed bugs (all Writer): Bug 146419 Bug 143569 Bug 134960 Bug 86395 Bug 52115 Bug 40427 Relevant patches from bug 134960 comment 27: https://gerrit.libreoffice.org/c/core/+/133101 https://gerrit.libreoffice.org/c/core/+/133342 https://gerrit.libreoffice.org/c/core/+/133350 https://gerrit.libreoffice.org/c/core/+/133359 https://gerrit.libreoffice.org/c/core/+/131448
Sorting has been requested in * Bug 90244 - SIDEBAR: Enhancing Navigator in Draw * Bug 104255 - Allow alphabetical sorting of Navigator content (headings, bookmarks, etc.) (and probably other too) What sort order is the best depends on the scenario. In case of Calc it is even more difficult as you may have some vertical/horizontal arrangement in mind. But users may organize the content differently, or have a non-Western view on data. Some other scenarios require perhaps to sort by the image name, users become greedy and want us to sort by image size, etc. To sum up, a) there is no unique order in Calc, and b) sorting needs to be optional.
(In reply to Heiko Tietze from comment #2) > To sum up, a) there is no unique order in Calc True > b) sorting needs to be optional. Well a list has a top down order order by definition. So images listed in the navigator are sorted anyhow. So it's not clear what you want to convey by optional. I don't necessary intend to insert some sort filter with various options. More the adjust the default logic to make it more predictable. In similar fashion as in Writer. Arranging images by insertion time a large spreadsheet with lots of images (>50) simply random. Same as image creation time. Or sorting by filename. You have filename if insert with Insert -> Image, in case of copy paste you get something like: image27. I don't expect people to be really conscious about image file names in general. Look the sample document. Row by row seems to more sensible. So first image A1, next image in B1, 2C..followed by row 2, column A; A2; B2; C2. This makes the arrangement at least predictable. This use-full results for non-complex spreadsheets with where one column being filled with images (like example), which I think being a rather common use-case. The current order in unproductive in any case, IMHO. --- What might work is an alternative view option listing the images visible in the view port. This is useful if images being distributed across plenty of columns on the same row; however not sure of need for it. Seems a bit excessive.
We discussed the topic in the design meeting. Sorting can be done in at least four different orders: row first, col first, alphabetically, and by insertion time. The use case is questionable, and rather inspired by the existence of this feature in Writer. But the biggest issue is the fact that the Navigator lists objects from all sheets. Let's keep the ticket for later consideration.