Re: [libreoffice-users] Conditional hide rows in Calc?
Thanks, Simon, Brian - I'm an infrequent spreadsheet-user and just didn't think about filters. These approaches work fine! -- Wayne On Sun, Jul 17, 2011 at 6:04 PM, Brian Barker wrote: > At 17:35 17/07/2011 -0700, Wayne Stidolph wrote: > >> I have a variable numbers of data elements for each day, and I'd like to >> hide all but the last of each day (or export only the last-of-day values); >> is there an easy way? >> >> Example data: >> row | date | reading number | value | ... >> 1 | 7/1/2011 | 1 | 3 >> 2 | 7/2/2011 | 1 | 6 >> 3 | 7/2/2011 | 2 | 7 >> 4 | 7/2/2011 | 3 | 5 >> 5 | 7/4/2011 | 1 | 4 >> 6 | 7/5/2011 | 1 | 5 >> 7 | 7/5/2011 | 2 | 6 >> >> So I'd like to extract: >> 1 | 7/1/2011 | 1 | 3 >> >> >> 4 | 7/2/2011 | 3 | 5 >> 5 | 7/4/2011 | 1 | 4 >> >> 7 | 7/5/2011 | 2 | 6 >> >> Is there a way to use conditional formatting to hide a row, based on a >> test of the reading number of the current row compared to the reading number >> of the next row? >> > > Yes. Your dates are in column A, starting in row 1. In row 1 of a new > column, put the formula > =A1<>A2 > Now fill this down the new column. The last rows of each day - which you > want to keep - are now marked TRUE and the others FALSE. Select the new > column and go to Data | Filter > | Standard Filter... . Ensure that "Field > name" refers to your new column, and choose "=" for Condition and TRUE (or > 1) for Value. > > To export the required values, just copy the filtered region and paste it > somewhere else: only the visible cells will be copied. > > Note that you can hide the new column if preferred. > > I trust this helps. > > Brian Barker > > > > -- > Unsubscribe instructions: E-mail to > users+help@global.libreoffice.**org > In case of problems unsubscribing, write to postmaster@documentfoundation. > **org > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- Wayne -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Conditional hide rows in Calc?
I have a variable numbers of data elements for each day, and I'd like to hide all but the last of each day (or export only the last-of-day values); is there an easy way? Example data: row | date | reading number | value | ... 1 | 7/1/2011 | 1 | 3 2 | 7/2/2011 | 1 | 6 3 | 7/2/2011 | 2 | 7 4 | 7/2/2011 | 3 | 5 5 | 7/4/2011 | 1 | 4 6 | 7/5/2011 | 1 | 5 7 | 7/5/2011 | 2 | 6 So I'd like to extract: 1 | 7/1/2011 | 1 | 3 4 | 7/2/2011 | 3 | 5 5 | 7/4/2011 | 1 | 4 7 | 7/5/2011 | 2 | 6 Is there a way to use conditional formatting to hide a row, based on a test of the reading number of the current row compared to the reading number of the next row? -- Wayne -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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: General input/output error when saving to network drive
I see the same "General-on save/nothing on open" behavior with LO3.4 trying to directly read/write to a Synology NAS: * Fedora 14 64-bit, wired connection * Fedora 15 32-bit, wireless connection Double-clicking on the remote ODT file from Nautilous works - the doc opens in LO. And, changing the doc so opened and saving it from inside LO works fine - the doc on the NAS is updated (and verified by opening it from the other machine). On Fri, Jun 17, 2011 at 1:17 AM, Steve Edmonds wrote: > > > On 17/06/11 3:51 PM, protonpusher wrote: >> >> Another update. First off, in response to Jean-Francois, I checked, and >> there >> are no special characters in the share name or server name. >> >> I also have some more test results. Using two computers (Old Toshiba >> Satellite, and desktop) I ran the Live cd for both Ubuntu 10.10 (has OOo), >> and Ubuntu 11.04 (has LO). The results are not surprising. >> >> On both machines Ubuntu 11.04/LO, LO was unable to save to the network >> share, and unable to open files on the network share through LO using the >> save and open commands. Opening files does nothing, saving files produces >> the error listed above. >> >> On both machines Ubuntu 10.10/OOo worked just fine. I could open and save >> files just fine to the network with no problem. >> >> For what it is worth, to mount the network share I use Nautilus. I go to >> Network, find the network drive (MYBOOKLIVE), and open it. It has several >> shares, and I double click to open one, and the share then appears on the >> desktop. The share is also then available on the list of places I can open >> and save to from within LO (it just fails to actually open or save) >> >> At this point I am sort of stumped. It does seem like a bug though. >> >> -- >> View this message in context: >> http://nabble.documentfoundation.org/General-input-output-error-when-saving-to-network-drive-tp3061786p3074966.html >> Sent from the Users mailing list archive at Nabble.com. >> > Hi. Run the live CD of Ubuntu 10.10 and install LO. This will then tell you > if it is Ubuntu related or LO related. > steve > > -- > Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org > In case of problems unsubscribing, write to > postmas...@documentfoundation.org > 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 > > -- Wayne -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Impress leads to system log out
This happened to me yesterday; I switched to fullscreen in Draw (but Impress was also open, as I recall) and was logged out (back to the login prompt). I was using LO 3.4 on gnome 2, Fedora 14 x86_64, with the kmod-nvidia drivers on a Nvidia 8600 chip. It wasn't repeatable, though - I reopened the same stuff (after Recovery) and everything was fine. -- Wayne On Mon, Jun 13, 2011 at 10:14 AM, Karsten Breitig wrote: > I just found out, that my problem only occurs, when I go to fullscreen with > the presentation. However, it doesn't seem to be an x-server-crash. > Does that change something? > > Original-Nachricht >> Datum: Mon, 13 Jun 2011 16:58:18 +0200 >> Von: Marcello Romani >> An: users@global.libreoffice.org >> Betreff: Re: [libreoffice-users] Impress leads to system log out > >> Il 12/06/2011 23:19, Karsten Breitig ha scritto: >> > Hey guys, >> > >> > I've got some issues with LibreOffice 3.3.2 on Ubuntu 11.04 (Unity). >> > >> > I have a presentation file here (.odp, used to be .pptx). When I open >> it, the system logs off. This happens only with this presentation (and one >> else), others work fine. The problem can be repeated several times. >> > In some cases, it doesn't crash while opening a file, but when I try to >> insert an image. >> > >> > I've got enough memory and disk space. The presentation worked on >> another Ubuntu 11.04 with LibreOffice 3.3.2. >> > >> > Does anybody know how to help me? >> > >> > >> > Best regards, >> > Karsten >> >> Hi, I had a similar problem a few weeks ago. It was a pretty normal >> document that made OOo crash and log me out of the session. >> I couldn't reliably reproduce the bug. In fact it appeared only a couple >> of times and haven't seen it again since then. >> If I remember correctly, looking at the system logs it had something to >> do with graphic drivers and X crashing. >> I suppose subsequent system updates solved the driver problem. >> (My PC is a fairly old PIV 2.8Ghz with the infamous Intal 82865G >> integrated graphics controller). >> >> So my advice is: look at Xorg logs, dmesg and other system logs. Look at >> your graphics cards manufacturer and model (lspci) and search for bugs >> in launchpad. >> >> -- >> Marcello Romani >> >> -- >> Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org >> In case of problems unsubscribing, write to >> postmas...@documentfoundation.org >> 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 > > -- > Empfehlen Sie GMX DSL Ihren Freunden und Bekannten und wir > belohnen Sie mit bis zu 50,- Euro! https://freundschaftswerbung.gmx.de > > -- > Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org > In case of problems unsubscribing, write to postmas...@documentfoundation.org > 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 > -- Wayne -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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] Any way to "keep with previous" in Writer?
I want to "Keep with previous" rather than "keep with next" (for my beginning-of-list styles). I can see from searching that it's been discussed and bugs opened and such, for quite a while, but I don't think anything has come of it yet ... I wonder if anyone has worked out a way to do that, or is it just a manual thing to do - go through and apply Keep With Next, take it off where it no longer applies, etc. -- Wayne -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted