Bug 104453 - How to save - and recall - non-contiguous selections ?
Summary: How to save - and recall - non-contiguous selections ?
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-06 23:02 UTC by Gérald Maruccia
Modified: 2016-12-07 16:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
calc with macro to save and select non contiguous selections, made by Zeguedon (25.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-06 23:02 UTC, Gérald Maruccia
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gérald Maruccia 2016-12-06 23:02:40 UTC
Created attachment 129360 [details]
calc with macro to save and select non contiguous selections, made by Zeguedon

Hi,

I know it's possible to define one range of cells as a database and select it again later.

Now I'd need to « memorize » more complex selections like these ones :
https://forum.openoffice.org/fr/forum/download/file.php?id=121446&mode=view
https://forum.openoffice.org/fr/forum/download/file.php?id=121471&mode=view
in order to call them back later on same or another sheet.

I did not find an easy way to do that.

Zeguedon proposed a macro, here https://forum.openoffice.org/fr/forum/viewtopic.php?f=8&t=52971 and https://bz.apache.org/ooo/show_bug.cgi?id=25769 describes the same need, I think, as suggested by Dude at the end of the thread.

I'm surprised there is no « memorize selections » feature.
Comment 1 Xisco Faulí 2016-12-07 15:45:25 UTC
Hello Gerald,



Questions about how to use LibreOffice must be asked in https://ask.libreoffice.org/en/questions/.
Bugzilla is used to track bugs.
Closing this as RESOLVED NOTABUG.
Comment 2 Gérald Maruccia 2016-12-07 16:25:59 UTC
Ok, maybe not a bug but isn't it a missing feature ?

Is not being able to memorize non-contiguous selections as range for database not a bug ?

But thanks for your answer !