Re: [libreoffice-users] Parametrising sheets
Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 15:06 Uhr +1300: Do Y and Z stay the same and just x varies (as input). For this one graph, yes. I'd probably also want to make other graphs with Y and Z varying. How many input values of x would you want process and display in one chart. Between 5 and 15. But more would be better, to be honest, and hence the desire to parametrise, rather than to hack this up with macros, or using copy-paste. -- @martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net "the pure and simple truth is rarely pure and never simple." -- oscar wilde spamtraps: madduck.bo...@madduck.net -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Parametrising sheets
Hi Martin. Do Y and Z stay the same and just x varies (as input). How many input values of x would you want process and display in one chart. Steve On 18/02/2020 14:55, martin f krafft wrote: > Regarding the following, written by "Steve Edmonds" on 2020-02-18 at > 14:17 Uhr +1300: >> I don't know about turning a sheet into a formula, but you could >> create a macro to generate your output series. > > That sounds ugly, but yes, that could work. But I was really trying to > avoid that, and still hope I can! > > Thanks for your response! > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Parametrising sheets
Regarding the following, written by "Steve Edmonds" on 2020-02-18 at 14:17 Uhr +1300: I don't know about turning a sheet into a formula, but you could create a macro to generate your output series. That sounds ugly, but yes, that could work. But I was really trying to avoid that, and still hope I can! Thanks for your response! -- @martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net "i love deadlines. i like the whooshing sound they make as they fly by." -- douglas adams spamtraps: madduck.bo...@madduck.net -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] Parametrising sheets
Hi Martin. It may be possible to obtain an acceptable chart using the Bar-3D -Deep type and suitably preparing your data. I don't know about turning a sheet into a formula, but you could create a macro to generate your output series. Steve On 18/02/2020 13:13, martin f krafft wrote: > Hello folks, > > I have an elaborate sheet that essentially takes 3 different values > as input, and outputs two data series, which I can use to produce a > bar chart like so: > > ``` > | > | _ > || | _ > |_ | | _| | > | _| | | || | | > | | | | | |_ | | | > | | | | | | | | | | > - > ``` > > Obviously, there'll be a single formula that produces each data > point, but it'll be very complex, as the sheet currently derives the > data in multiple steps. > > What I need to do now is to graph multiple of those graphs in one. > That is, I want a 3D bar graph with the first series equivalent to > what the sheet would produce with "input" parameters (X1, Y, Z), the > second series corresponding to "input" parameters (X2, Y, Z), and so > on. > > Is this possible? Without duplicating the sheets, of course? > Essentially turn a sheet into a function/formula that I can "call"? > > Thanks for any hints, > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Parametrising sheets
Hello folks, I have an elaborate sheet that essentially takes 3 different values as input, and outputs two data series, which I can use to produce a bar chart like so: ``` | | _ || | _ |_ | | _| | | _| | | || | | | | | | | |_ | | | | | | | | | | | | | - ``` Obviously, there'll be a single formula that produces each data point, but it'll be very complex, as the sheet currently derives the data in multiple steps. What I need to do now is to graph multiple of those graphs in one. That is, I want a 3D bar graph with the first series equivalent to what the sheet would produce with "input" parameters (X1, Y, Z), the second series corresponding to "input" parameters (X2, Y, Z), and so on. Is this possible? Without duplicating the sheets, of course? Essentially turn a sheet into a function/formula that I can "call"? Thanks for any hints, -- @martinkrafft | https://riot.im/app/#/room/#madduck:madduck.net "a cigarette is the perfect type of pleasure. it is exquisite, and it leaves one unsatisfied." -- oscar wilde spamtraps: madduck.bo...@madduck.net -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] Search results box in Calc
Using LO 6.0.7.3 in up-to-date UbuntuStudio 1804 LTS In any spreadsheet, when I use Ctrl-F and type in a search string, the Search Results dialog box displays results in 3 columns : Sheet, Cell, Content. This display has two annoying characteristics that I have not been able to change : 1. the whole box is too small so the the entire Contents column cannot be read. Certainly, there is a slider at the bottom and the whole box size can be dragged larger. But since there is no real-estate width limitations on the screen, it would be good to have the box appear wider by default. 2. the Cell column is too narrow by default to display more than 5 characters and I have to drag it larger every time. For example it displays $C$15 instead of $C$150. It would be good if the default display settings could be modified to provide a larger width to the Cell column and a larger overall dialogue box size. Can anybody explain where I might be able to modify some settings to achieve this result? Philip -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
