Bug 88422 - Allow multiple ranges in solver "By changing cells" field.
Summary: Allow multiple ranges in solver "By changing cells" field.
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Solver
  Show dependency treegraph
 
Reported: 2015-01-14 21:43 UTC by austn3
Modified: 2022-06-01 18:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description austn3 2015-01-14 21:43:51 UTC
I see that there was a bug request closed for this but no explanation was given other than "that's the way it is". It is something that excel supports and it is a lot easier than copying all of the data into a massive rectangle.

Thanks

https://bugs.freedesktop.org/show_bug.cgi?id=87758
Comment 1 Robinson Tryon (qubit) 2015-01-15 03:55:45 UTC
(In reply to austn3 from comment #0)
> ...It is something that excel supports
> and it is a lot easier than copying all of the data into a massive rectangle.

It sounds plausible as an enhancement, so this will live in NEW until someone picks it up to work on it or decides to reclassify it
Status -> NEW
Comment 2 Rafael Lima 2022-06-01 18:30:52 UTC
As of LO 7.3 it is currently possible to add multiple ranges in "By changing cells" field. You simply have to type ";" to separate each range. For example:

$D$8:$D$37;$E$8:$E$37

Contains 2 ranges $D$8:$D$37 and $E$8:$E$37.

I have just tested and it works fine. So this is WFM.