[libreoffice-users] Re: Calc chart x-axis labels
Brian Barker wrote > At 17:23 02/12/2014 -0700, Jerry Vonly Bonly wrote: >>... I thought with "Source Format" selected it would use the source >>format as is. >> It does: if your original format, say, is DD/MM/YY, then that is how >> the axis values will appear. It keeps the format, not the values. > Well, that seems silly to me, to preserve only the format. At least give > an option to preserve the values makes more sense to me. > > >>I tried the "X-Y Scatter" chart type; it still didn't give me what I >>wanted, and I don't like the "graph" line. >> You can have X-Y Scatter without the line if you prefer. > That doesn't sound to useful. > > Thanks for your ideas Brian, very much appreciated. > > Jerry >> Brian Barker > -- > To unsubscribe e-mail to: > users+unsubscribe@.libreoffice > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- View this message in context: http://nabble.documentfoundation.org/Calc-chart-x-axis-labels-tp4131286p4131350.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Calc chart x-axis labels
At 17:23 02/12/2014 -0700, Jerry Vonly Bonly wrote: ... I thought with "Source Format" selected it would use the source format as is. It does: if your original format, say, is DD/MM/YY, then that is how the axis values will appear. It keeps the format, not the values. I tried the "X-Y Scatter" chart type; it still didn't give me what I wanted, and I don't like the "graph" line. You can have X-Y Scatter without the line if you prefer. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Calc chart x-axis labels
Brian Barker wrote > At 11:05 02/12/2014 -0700, Jerry Vonly Bonly wrote: >>I have a table containing data on my credit card. Left-most column >>is the monthly statement dates, (oldest to newest, top to bottom) >>which are not always the same. The next column to the right is the >>monthly balance. When I create a Column Type chart from these two >>columns of data, I have the balances as the Y data, and the dates as >>the X column labels. For the X column labels, Calc always sets the >>dates to the first day of the month, not the real (table) date. >> >>I have checked the "Format Axis..." settings, and on the Numbers >>tab, "Source Format" is checked. I think this means that it is >>supposed to set the x-axis labels to the format of the cells in the >>table. But, this is not happening. All of the x-axis labels are set >>to the first day of the month, i.e. 01/01/14, instead of 01/24/14 >>(the date in the table). >> >>I have tried all of the other chart types, none of them source the >>dates correctly. Is this a bug, or am I missing something? > > I think this is probably by design. When you plot a chart, you don't > normally put individual data values on the axes, but merely label the > axis with round, equally spaced values. Since your data is roughly > monthly, having x-values labelled once per month sounds sensible. > Note that the y-axis is not labelled with your actual balance amounts > but likewise with suitably round, equally spaced values. I never thought about it this way, makes sense though. > A column chart appears to set out the columns somewhat regularly, not > exactly according to the x-value for each column. Perhaps that is > because such charts are normally used for non-parametric statistics, > where this makes sense. And you shouldn't really want your equally > spaced columns to be labelled with unequally spaced vales. Correct, but I thought with "Source Format" selected it would use the source format as is. > So what can you do? One possibility is to use a chart of type "X-Y > (Scatter)", where the x-axis labels will still be equally spaced, but > the data points will be displaced into their appropriate place within > each month. But I suspect a better solution, if you really want a > column chart, is to label your columns with just the relevant month - > discarding the day information. You can do this either by changing > the format of your column of statement dates and keeping your "Source > format" option, or - probably more sensibly - to keep the original > dates showing in your table but to untick "Source format" in the > x-Axis dialogue and set a suitable date format there. How about > something like "MM/YY" (12/14) or "MMM YY" (Dec 14)? I tried the "X-Y Scatter" chart type; it still didn't give me what I wanted, and I don't like the "graph" line. > Alternatively, you can use Insert Data Labels to create labels on the > columns themselves. Use Format Data Labels... to adjust them; you can > choose "Show category" to place the date values instead of the > balance amounts on the columns. Format the dates as you wish (they > inherit the Number format from the x-Axis dialogue), possibly > rotating them to fit the columns. Once you have the data labels as > you want them - perhaps "D MMM " (2 Dec 2014) - you can choose to > delete the x-axis entirely, so you just have columns labelled with > the actual dates. Lots of good ideas Brian, thank you for your input. > I trust this helps. > > Brian Barker > > > -- > To unsubscribe e-mail to: > users+unsubscribe@.libreoffice > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted -- View this message in context: http://nabble.documentfoundation.org/Calc-chart-x-axis-labels-tp4131286p4131340.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc chart x-axis labels
At 11:05 02/12/2014 -0700, Jerry Vonly Bonly wrote: I have a table containing data on my credit card. Left-most column is the monthly statement dates, (oldest to newest, top to bottom) which are not always the same. The next column to the right is the monthly balance. When I create a Column Type chart from these two columns of data, I have the balances as the Y data, and the dates as the X column labels. For the X column labels, Calc always sets the dates to the first day of the month, not the real (table) date. I have checked the "Format Axis..." settings, and on the Numbers tab, "Source Format" is checked. I think this means that it is supposed to set the x-axis labels to the format of the cells in the table. But, this is not happening. All of the x-axis labels are set to the first day of the month, i.e. 01/01/14, instead of 01/24/14 (the date in the table). I have tried all of the other chart types, none of them source the dates correctly. Is this a bug, or am I missing something? I think this is probably by design. When you plot a chart, you don't normally put individual data values on the axes, but merely label the axis with round, equally spaced values. Since your data is roughly monthly, having x-values labelled once per month sounds sensible. Note that the y-axis is not labelled with your actual balance amounts but likewise with suitably round, equally spaced values. A column chart appears to set out the columns somewhat regularly, not exactly according to the x-value for each column. Perhaps that is because such charts are normally used for non-parametric statistics, where this makes sense. And you shouldn't really want your equally spaced columns to be labelled with unequally spaced vales. So what can you do? One possibility is to use a chart of type "X-Y (Scatter)", where the x-axis labels will still be equally spaced, but the data points will be displaced into their appropriate place within each month. But I suspect a better solution, if you really want a column chart, is to label your columns with just the relevant month - discarding the day information. You can do this either by changing the format of your column of statement dates and keeping your "Source format" option, or - probably more sensibly - to keep the original dates showing in your table but to untick "Source format" in the x-Axis dialogue and set a suitable date format there. How about something like "MM/YY" (12/14) or "MMM YY" (Dec 14)? Alternatively, you can use Insert Data Labels to create labels on the columns themselves. Use Format Data Labels... to adjust them; you can choose "Show category" to place the date values instead of the balance amounts on the columns. Format the dates as you wish (they inherit the Number format from the x-Axis dialogue), possibly rotating them to fit the columns. Once you have the data labels as you want them - perhaps "D MMM " (2 Dec 2014) - you can choose to delete the x-axis entirely, so you just have columns labelled with the actual dates. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] stopping windows raising
On 2014-12-02, Tom Davies wrote: > Hi :) > I think no-one here knows. There are other places to ask; > https://www.libreoffice.org/get-help/community-support/ Obviously I looked there before asking - I can't find a magic keyword to find anything in the documentation, and the ask libreoffice thing appears to require setting up an OpenID server first (or making yet another throwaway gmail account), which I can't be bothered to do. > I thought all the focus and "always on top" type stuff was all set-up in > the OS - and that would mean it'd behave the same across all different > apps, programs and suites. I know it's possible to set some individual That's an overstatement, and depends what you mean by OS. In the traditional Unix X setting, window placement and stacking of top-level windows is the job of the window manager, and client programs don't change their size or stacking order other than by explicit user request (e.g. opening a new dialog window). In this convention, window managers typically honour client raise requests, because the client is assumed to have a good reason for doing it. Whereas if focus changes, that's a window manager matter, and it's up to the wm to raise or not raise the focussed window according to the user's policy (not the OS's policy!). So presumably the LO home-grown GUI toolkit is violating this policy, and explicitly raising when it gets focus, because it was designed by people from a different background (Windows?). > apps on a per-app basis but with a limited range of possibilities. Your's > sounds unusual! Not at all. It's been the standard for 30 years or so. > So, hopefully you might get some more answers from this list but please go > ahead and repost elsewhere too. If you do get a good answer from elsewhere > please could you give us a link so we can check it out? I fear the answer is almost certainly patch the source and recompile! Which is too much work. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Sphinx - voice translation - Linux
On 12/2/2014 3:08 PM, charles meyer wrote: Hi Tom, I spoke with someone who uses Linux and they shared that Sphinx - voice translation is new so many may not have tried it yet. Sorry for jumping the gun, so to speak. It's speech recognition, not voice translation. If I throw you off the top of the building, I'm going to hear your voice. If I push you near the edge of the roof, I would hear your speech.. Sphinx has been around for at least 15 years in different forms. It has been, and probably always will be a system designed for IVR (interactive voice response, "speak or press one to get ignored by a customer service representative"). It is not and never will be a system for general-purpose speech recognition. The only useful speech recognition packages are NaturallySpeaking with a not very close runner-up of Windows speech recognition. Google speech recognition would be in the running if it wasn't bound to a very limited number of apps with no user accessible grammars. I'm currently experimenting with running Windows in a KVM virtual machine, running NaturallySpeaking there and find a way to see the output of NaturallySpeaking back to the Linux host OS. If I can get the audio stream clean enough, it looks like a promising technique for adding speech recognition to Linux Now all I need some help to figure out what I don't know about injecting keystrokes into linux and may be help with fixing up KVM so it passes audio cleanly under most conditions. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Sphinx - voice translation - Linux
Hi Tom, I spoke with someone who uses Linux and they shared that Sphinx - voice translation is new so many may not have tried it yet. Sorry for jumping the gun, so to speak. Thanks. Charles. On 12/2/14, Tom Davies wrote: > Hi :) > Got a nice reply from Charles Meyer which i think might do better on-list > so i'm sending it back here (please see below) > Regards from > Tom :) > > > On 2 December 2014 at 16:42, charles meyer wrote: > >> Hi Andrew and Tom, >> >> Thank you both for your posts. >> >> Many Linux distributions (e.g. Fedora, Ubuntu, Mint, etc.) offer >> Sphinx - the voice translation software. >> >> Have either of you used this voice translation software? >> >> Tom - thanks so much for sharing the Linux links. >> >> Thank you. >> >> Charles. >> >> On 2 December 2014 at 05:45, Andrew Douglas Pitonyak >> wrote: >> >> Can you be more specific? Numerous packages named Sphinx, could >> not begin to guess which. Perhaps I am simply not well informed. >> >> My best guess is this: >> >> https://pypi.python.org/pypi/sphinxcontrib-libreoffice >> >> Hi :) >> It's kinda ok to ask Linux questions in here but not all of us use it. >> So you might prefer a more general Linux forum instead. On the other >> hand quite a few of us do seem to use various different distros so it >> can often be worth asking. >> >> Both my links below worked. >> Regards from >> Tom :) >> >> >> >> On 2 December 2014 at 13:27, Tom Davies wrote: >> >> Hi :) >> A good general purpose Linux forum is >> http://www.linuxquestions.org >> or is it >> https://www.linuxquestions.org >> now? >> >> Regards from >> Tom :) >> > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc chart x-axis labels
I have a table containing data on my credit card. Left-most column is the monthly statement dates, (oldest to newest, top to bottom) which are not always the same. The next column to the right is the monthly balance. When I create a Column Type chart from these two columns of data, I have the balances as the Y data, and the dates as the X column labels. For the X column labels, Calc always sets the dates to the first day of the month, not the real (table) date. I have checked the "Format Axis..." settings, and on the Numbers tab, "Source Format" is checked. I think this means that it is supposed to set the x-axis labels to the format of the cells in the table. But, this is not happening. All of the x-axis labels are set to the first day of the month, i.e. 01/01/14, instead of 01/24/14 (the date in the table). I have tried all of the other chart types, none of them source the dates correctly. Is this a bug, or am I missing something? -- View this message in context: http://nabble.documentfoundation.org/Calc-chart-x-axis-labels-tp4131286.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Sphinx - voice translation - Linux
Hi :) Got a nice reply from Charles Meyer which i think might do better on-list so i'm sending it back here (please see below) Regards from Tom :) On 2 December 2014 at 16:42, charles meyer wrote: > Hi Andrew and Tom, > > Thank you both for your posts. > > Many Linux distributions (e.g. Fedora, Ubuntu, Mint, etc.) offer > Sphinx - the voice translation software. > > Have either of you used this voice translation software? > > Tom - thanks so much for sharing the Linux links. > > Thank you. > > Charles. > > On 2 December 2014 at 05:45, Andrew Douglas Pitonyak > wrote: > > Can you be more specific? Numerous packages named Sphinx, could > not begin to guess which. Perhaps I am simply not well informed. > > My best guess is this: > > https://pypi.python.org/pypi/sphinxcontrib-libreoffice > > Hi :) > It's kinda ok to ask Linux questions in here but not all of us use it. > So you might prefer a more general Linux forum instead. On the other > hand quite a few of us do seem to use various different distros so it > can often be worth asking. > > Both my links below worked. > Regards from > Tom :) > > > > On 2 December 2014 at 13:27, Tom Davies wrote: > > Hi :) > A good general purpose Linux forum is > http://www.linuxquestions.org > or is it > https://www.linuxquestions.org > now? > > Regards from > Tom :) > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] stopping windows raising
Hi :) I think no-one here knows. There are other places to ask; https://www.libreoffice.org/get-help/community-support/ Sometimes it is a case of just being lucky and asking the question at the right time to catch the right people. My response "bumps the thread" so that it appears at the top of people's inbox again. I't sometimes worth doing that if you've had no response after a day or few (but obviously don't over-use it!). I thought all the focus and "always on top" type stuff was all set-up in the OS - and that would mean it'd behave the same across all different apps, programs and suites. I know it's possible to set some individual apps on a per-app basis but with a limited range of possibilities. Your's sounds unusual! So, hopefully you might get some more answers from this list but please go ahead and repost elsewhere too. If you do get a good answer from elsewhere please could you give us a link so we can check it out? Regards from Tom :) On 28 November 2014 at 13:51, Julian Bradfield < jlibreus...@stevens-bradfield.com> wrote: > A very simple question, but one I can't find an answer to. > > When I use libreoffice, it insists on raising its window to the top of > my display whenever it gets focus. Since I use a "focus follows mouse" > model in my window manager - and anyway, just because a window has > focus doesn't mean I want it on top - this is fantastically annoying. > How do I stop it doing this? > (Version 4.0.4.2 on Scientific Linux 6.5, in case it matters.) > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux Users - Sphinx use
Hi :) It's kinda ok to ask Linux questions in here but not all of us use it. So you might prefer a more general Linux forum instead. On the other hand quite a few of us do seem to use various different distros so it can often be worth asking. Both my links below worked. Regards from Tom :) On 2 December 2014 at 13:27, Tom Davies wrote: > Hi :) > A good general purpose Linux forum is > http://www.linuxquestions.org > or is it > https://www.linuxquestions.org > now? > > Regards from > Tom :) > > > > > On 2 December 2014 at 05:45, Andrew Douglas Pitonyak > wrote: > >> Can you be more specific? Numerous packages named Sphinx, could not begin >> to guess which. Perhaps I am simply not well informed. >> >> My best guess is this: >> >> https://pypi.python.org/pypi/sphinxcontrib-libreoffice >> >> >> On 12/01/2014 11:19 PM, charles meyer wrote: >> >>> I hope it's OK to post about Linux here? >>> >>> If not, my apologies. >>> >>> I was curious if any Linux users have used the Sphinx application and >>> how well it's worked? >>> >>> Thanks so much. >>> >>> Charles. >>> >>> >> -- >> Andrew Pitonyak >> My Macro Document: http://www.pitonyak.org/AndrewMacro.odt >> Info: http://www.pitonyak.org/oo.php >> >> >> >> -- >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- >> unsubscribe/ >> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette >> List archive: http://listarchives.libreoffice.org/global/users/ >> All messages sent to this list will be publicly archived and cannot be >> deleted >> > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Linux Users - Sphinx use
Hi :) A good general purpose Linux forum is http://www.linuxquestions.org or is it https://www.linuxquestions.org now? Regards from Tom :) On 2 December 2014 at 05:45, Andrew Douglas Pitonyak wrote: > Can you be more specific? Numerous packages named Sphinx, could not begin > to guess which. Perhaps I am simply not well informed. > > My best guess is this: > > https://pypi.python.org/pypi/sphinxcontrib-libreoffice > > > On 12/01/2014 11:19 PM, charles meyer wrote: > >> I hope it's OK to post about Linux here? >> >> If not, my apologies. >> >> I was curious if any Linux users have used the Sphinx application and >> how well it's worked? >> >> Thanks so much. >> >> Charles. >> >> > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > Info: http://www.pitonyak.org/oo.php > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted