Bug 160353 - List images in order of document appearance in Calc Navigator
Summary: List images in order of document appearance in Calc Navigator
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.0 alpha0+
Hardware: All All
: lowest enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Navigator
  Show dependency treegraph
 
Reported: 2024-03-25 12:28 UTC by Telesto
Modified: 2024-05-09 06:01 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2024-03-25 12:28:48 UTC
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
Comment 2 Heiko Tietze 2024-04-24 08:24:08 UTC
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.
Comment 3 Telesto 2024-04-24 09:20:08 UTC
(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.
Comment 4 Heiko Tietze 2024-05-09 06:01:54 UTC
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.