Re: IEEE 754 compliance
The 754 standard is being updated and the result is being voted on now, I think. It's called 754r and can be found on the web. 16-bit and 128-bit floating point formats are what led me to it. Dave Feustel On Tue, May 13, 2008 at 08:50:45AM -0400, Prof J C Nash wrote: >There are some resources for testing by Nelson Beebe at >http://www.math.utah.edu/~beebe/software/ieee/timops.html From what I >understand, the main issues are handling of edge effects (underflow, >overflow, divide by 0, etc.) where compilers may do some things >different from the standard's prescription. There is, of course, an >interaction here with hardware that may not provide ways to get at the >bits (literally). > >In my efforts to set up some Gnumeric test worksheets, I've tried to >contact Beebe without success. He may have retired (I believe he is >older than I, and I'm on the brink of retirement from teaching, but not >from Gnumeric!) > >If there is interest, and in particular an example where IEEE754 may be >important, I'll be happy to dig a bit. I was a corresponding (ie vote by >mail) member of the IEEE 754 committee back in late 70s. Given the >arcane detail, it will take a bit of review for me to get fully up to speed. > > >JN > >___ >gnumeric-list mailing list >gnumeric-list@gnome.org >http://mail.gnome.org/mailman/listinfo/gnumeric-list ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
'Production Ready'? Not Exactly
As a brand new user of Gnumeric 1.2.12, I have to take exception to the 'Production Ready' characterization of Gnumeric. While it is good on the screen, the print/preview functions are basically broken because of the disconnect between print preview and what actually gets printed. I have to conclude that no one at gnome actually prints much with this spreadsheet program. Don't get me wrong, this program is off to a good start, but until the whole printing process has been polished more, it's not production ready. Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: 'Production Ready'? Not Exactly
On Monday 06 June 2005 08:22 pm, Morten Welinder wrote: > > I have to conclude that no one at gnome > > actually prints much with this spreadsheet program. > > It's hard to figure out exactly what is broken for you. If it is something > specific, you might want to file a detailed bug report at > http://bugzilla.gnome.org/ The main problem is it seems to be impossible to tell whether the spreadsheet is too wide for the paper until it is printed. There are other problems. I create a pdf file, view the file with xpdf, then print the file with lpr -P aps1 . More direct methods don't currently work for me. Overwriting output.pdf crashes gnumeric 100% of the time. > You should, btw., probably try using a recent version unless you > have very good reasons for staying behind. I'm running on OpenBSD. While I can keep current on some programs by recompiling them, gnumeric seems to use everything but the kitchen sink and I have a slow computer, so I use the OpenBSD gnumeric package in 3.6 right now. I will upgrade to 3.7 and its gnumeric package in a month or two when my finances improve. Two other nits are that gnumeric defaults to A4 and there does not seem to be a configuration process where I can set printer defaults (US letter size, print to pdf file) that are convenient for me. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: print problems with gnumeric (if win32)
On Monday 06 June 2005 09:09 pm, coralline algae wrote: > I couldnt tell from the note if the platform is windows but since I have > never had problems with printing on linux, I will take a stab and "assume" > it is windows. Sorry about that. My platform is OpenBSD. I walked away from Windows 3+ years ago. > I had some problems with another open source program abiword > printing garbage although print preview looked ok. > Other programs had no printing problems, so filed bug report. > In the interim new version came out and I tried it on another computer > and printing worked. Hmmm, reinstall print drivers on system > in question and problem solved. > > What can I say its windows, when in doubt reinstall something. > ___ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list > ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: 'Production Ready'? Not Exactly
On Tuesday 07 June 2005 08:22 am, Andreas J. Guelzow wrote: > On Tue, 2005-07-06 at 08:20 +0200, Lutz Müller wrote: > > On Tue, 2005-06-07 at 00:40 -0500, Dave Feustel wrote: > > > Two other nits are that gnumeric defaults to A4 and there does not > > > seem to be a configuration process where I can set printer defaults > > > (US letter size, print to pdf file) that are convenient for me. > > > > The configuration files for the printers are > > in /usr/share/libgnomeprint/.../*.xml. Look for the string > > > > Default="A4" > > > > Now that you've suggested it, I'll look into how to offer the user to make > > the default paper size persistent using the user interface. > > In theory you can save the page setup for a gnumeric sheet as default > for all future sheets. When I attempted to update templates, the file was not saved. I have had a lot of trouble with saving files in gnumeric. I need to get a newer version. How big a build is gnumeric? I have built Qt several times and tried but not yet succeeded in building even Arts for KDE. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: 'Production Ready'? Not Exactly
On Tuesday 07 June 2005 08:45 am, Morten Welinder wrote: > but bugzilla is really the way to go. I'll give it a shot. My disk setup does not currently have a large enough /usr partition to work on system stuff, but I have compiled a number of userland programs to run on OpenBSD. I started work on QT and KDE in order to get more recent versions of those software packages than are usually available as OpenBSD packages. I will now try to build the latest gnumeric since that program is suddenly quite important to me. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: 'Production Ready'? Not Exactly
On Wednesday 08 June 2005 01:46 pm, Jody Goldberg wrote: > On Tue, Jun 07, 2005 at 09:32:01AM -0500, Dave Feustel wrote: > > On Tuesday 07 June 2005 08:45 am, Morten Welinder wrote: > > > but bugzilla is really the way to go. > > > > I'll give it a shot. My disk setup does not currently have a large > > enough /usr partition to work on system stuff, but I have compiled > > a number of userland programs to run on OpenBSD. I started work on > > QT and KDE in order to get more recent versions of those software > > packages than are usually available as OpenBSD packages. I will > > now try to build the latest gnumeric since that program is suddenly > > quite important to me. > > Gnumeric is based on gtk and gnome. Your main needs will be the gtk > library stack and a couple of the gnumeric requirements like > - libgnomeprint* > - libgsf > > While we're not averse to someone writing a qt/kde front end no one > has offered one. I didn't mean to suggest a qt/kde front end for gnumeric. I only mentioned qt/kde software to bracket my experience level (such as it is) with open source. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
highlighting two columns with one click
Is there anything I could have done that would cause gnumeric to highlight two adjacent columns when I click on one of the column headers? (eg. clicking on col C highlights both B & C. Ditto for any other column pair as well. This suddenly happens on sheet 1 but not on sheets 2 or 3 of the spreadsheet. Thanks, Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
multiple windows in gnumeric?
Gnumeric is growing on me :-) Is there a way to have two separate gnumeric windows of the same or different spreadsheets simultaneously in unix-based systems? Related - Is it possible for one spreadsheet to access data in cells in a different spreadsheet (file)? Thanks, Dave ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: multiple windows in gnumeric?
On Thursday 09 June 2005 12:45 pm, Andreas J. Guelzow wrote: > > Related - Is it possible for one spreadsheet to access data > > in cells in a different spreadsheet (file)? > > yes, but both spreadsheets must be open in the same gnumeric process. > (This does not work quite as well imho.) I read the manual about this and got the impression that copy and paste works, but I want to either link to the data or use cells in the external spreadsheet in formulas in the active spreadsheet. Is that possible? Thanks, Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: multiple windows in gnumeric?
On Thursday 09 June 2005 12:58 pm, Andreas J. Guelzow wrote: > please let us know which dialogs cause you grief. There are only very > few truely modal dialogs in Gnumeric. Most only block the associated > spreadsheet window. By far the most buggy dialog is the 'save-as' in print to pdf file. There are *many* problems with this dialog. Not the least of which is 100% crashing of gnumeric any time a pdf file is overwritten. The print dialog would be much less error-prone if every option in that dialog could have a default value taken from a .conf file in either the user's home directory or from the directory holding the file to be printed (or both). ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: multiple windows in gnumeric?
On Thursday 09 June 2005 12:53 pm, David Stanaway wrote: > On Thu, 2005-06-09 at 12:33 -0500, Dave Feustel wrote: > > Gnumeric is growing on me :-) > > > > Is there a way to have two separate gnumeric windows > > of the same or different spreadsheets simultaneously > > in unix-based systems? > > You can certainly have different spreadsheets open at the same time. > (There are some issues with Modality of dialogs which might cause some > irritation thought). > > Are you thinking of having something like the functionality in emacs > where you can be accessing the same buffer in two different frames (Even > on 2 different X displays)? No. I want to work with two different spreadsheets at the same time. I now understand how to do this. > This would be pretty neat. Currently you > need to use split view to freeze one section while you are scrolling > around other parts of the sheet. I am not sure how much I would use > multiple windows for one sheet, but I am sure it would be very useful to > some people. EG: Manipulating a multi sheet workbook on a dual head > display. You could have one sheet selected on one display head, and be > referring to it while entering a formula on a different sheet in the > same workbook on a different window on the other display head. > > Is this worth an enhancement request bug on bugzilla? Not to me right now since I am not trying to do that. (I have a 21" monitor so I have lots of screen space) Maybe later. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 02:06 pm, Stephan Wehner wrote: > You're looking for lpq ? Tried that along with lpc and lprm. Nothing stopped the printer printing garbage until I deleted the files from /var/spool/lpd/aps1 I thought there was a command to manipulate the files in the print queue, but none of the commands above worked that way for me. I printed an older pdf file no problem, so the current print problem seems to be in bk2.pdf which was generated by the 'print to pdf file' command in gnumeric. To reiterate, the entire gnumeric print dialog is buggy, buggy, buggy. The rest of gnumeric is working well for me. Unfortunately, I use a lot of hardcopy records every day on my delivery route so the print problems are a serious impediment. > Also lprm might be useful for you for the next little while :) > > Stephan > > On 6/9/05, Dave Feustel <[EMAIL PROTECTED]> wrote: > > I generated a pdf file of a dead simple 1 page spreadsheet > > (no formulas) using the gnumeric print command. > > I examined the file using xpdf and the file looked ok. > > When I attempted to print the file using the command > > lpr -P aps1 , > > I am getting page after page, each with 1 printed line of garbage. > > I don't know where the problem lies, but this makes > > my printer unusable. I used to have this problem when I > > printed kde files before I installed aps1, but not since then > > until now. > > > > What command shows the names of files in the print queue? > > (I've looked but just can't find it) > > Dave Feustel > > > > > ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Do Customized Headers/Footers work?
I set data in the File/Page Setup/Headers-Footers/customise dialogs, but that data does not appear in the print preview or print to pdf file output. What else do I need to do to make the customized headers/footers work? Thanks, Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 02:55 pm, Morten Welinder wrote: > > To reiterate, the entire gnumeric print dialog is buggy, > > buggy, buggy. The rest of gnumeric is working well for me. > > That is what you say. And say again. And again. It is not useful! > I really wish you would back it up with a coherent statement as to > what is wrong. I believe, on the basis of the various print problems I see, that qa testing on the print dialogs is either not done at all or else done minimally. Prove me wrong by pointing me to a url where the print test procedures are that are used to test the gnumeric print functions so I can convince myself that the feature testing is comprehensive. Try doing a print to pdf file twice in a row without changing the output file name and see if gnumeric crashes when you do so. IT does 100% of the time on my system. Having said that, I concur that filing bugzilla reports is the best way to get the bugs fixed. My problem is that I don't have time to file (much less learn how to file) bug reports while I am trying to work around print problems as I attempt to meet real-time report deadlines. I would prefer to upgrade to the most recent gnumeric and see if the print problems go away. The question is how to do that without changing operating systems since one of the disadvantages of using OpenBSD is that the packages are almost always out-of-date. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Do Customized Headers/Footers work?
On Thursday 09 June 2005 02:58 pm, Morten Welinder wrote: > It works fine for me. It probably works fine for everyone but you. I am beginning to have concerns about how gnumeric code may have been modified by OpenBSD developers for installation on Openbsd. > Please use bugzilla. Attach a generated file so we can have a look. OK. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 02:40 pm, Tino Meinen wrote: > I suggest for you to try one of the live linux distributions containing > a recent gnumeric (kanotix has gnumeric 1.5.x) and see if you still have > printing problems on such a system. Excellent idea! Any specific recommendations? ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 02:45 pm, Andreas J. Guelzow wrote: > It would also be interesting if you ould post some screen shots of those > "buggy" dialogs, so that we can tell which ones you are in fact running. I would do this if I knew how. The various dialogs each are different. Some have an 'apply' button which is very useful. Others do not. There does not much uniformity in the dialog boxes used in the print subsystem. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Do Customized Headers/Footers work?
On Thursday 09 June 2005 03:00 pm, Andreas J. Guelzow wrote: > Did you allocate space for them? No. Didn't occur to me that I had to, but now that you mention it, I think you may have identified the problem. > You do that on the left of the same tab > as the specification of the customized headers. > > I have the feeling that something in your configuration is horribly > messed up. It wouldn't be the first time, but I haven't modified anything. I installed the OpenBSD package as downloaded. > Andreas This is why I would love to try using an OpenBSD version of gnumeric that was created by the gnumeric developers. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Do Customized Headers/Footers work?
On Thursday 09 June 2005 03:00 pm, Andreas J. Guelzow wrote: > Did you allocate space for them? You do that on the left of the same tab > as the specification of the customized headers. BINGO! Thanks! Dave ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 04:19 pm, Andreas J. Guelzow wrote: > On Thu, 2005-09-06 at 16:05 -0500, Dave Feustel wrote: > > On Thursday 09 June 2005 02:55 pm, Morten Welinder wrote: > > > > To reiterate, the entire gnumeric print dialog is buggy, > > > > buggy, buggy. The rest of gnumeric is working well for me. > > > > > > That is what you say. And say again. And again. It is not useful! > > > I really wish you would back it up with a coherent statement as to > > > what is wrong. > > > > I believe, on the basis of the various print problems I see, that qa testing > > on the print dialogs is either not done at all or else done minimally. > > Prove > > me wrong by pointing me to a url where the print test procedures are that > > are used to test the gnumeric print functions so I can convince myself > > that the feature testing is comprehensive. Try doing a print to pdf file > > twice in a row without changing the output file name and see if gnumeric > > crashes when you do so. IT does 100% of the time on my system. > > This is nearly insulting. I apologise. No offense was intended or even thought of. This is a 100% repeatable problem on my system. If it doesn't happen to you on your system, then it begins to look like an OpenBSD-related problem. >> The very first thing we probably tried as a > result of your messages is try to print to pdf using the same name (and > differnet names). I have not been able to crash it once. > > Since I am also supporting approximately 300 users of gnumeric for whom > printing is an essential part of gnumeric's use (since they typically > need to print their work to submit it) I also know that I ma not just > `lucky'. > > > > Having said that, I concur that filing bugzilla reports is the best way to > > get the bugs fixed. I now have a Bugzilla account. I'm looking at the opening screen. All I have to do now is learn how to use it :-) > > My problem is that I don't have time to file (much less > > learn how to file) bug reports while I am trying to work around print > > problems > > as I attempt to meet real-time report deadlines. I would prefer to upgrade > > to the most recent gnumeric and see if the print problems go away. > > The question is how to do that without changing operating systems since > > one of the disadvantages of using OpenBSD is that the packages are almost > > always out-of-date. > > Either you file bug reports or you live with the bugs. More likely > though the bugs you are seeing are either openBSD specific or specific > to your set-up. > > Andreas Andreas, I appreciate your work. Please don't take anything I write as an attack, either of you or gnumeric. I don't do that - ever. I do get worked up when I get frustrated. I have been trying to tone it down because even my cats leave when I get upset. Dave ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Thursday 09 June 2005 05:11 pm, Richard Bumby wrote: > Programs like Adobe reader and xpdf that view the files allow the file > to be printed from the viewer. The reason that I print with lpr is that I have a very hard time reading the text in the print dialogs in gnumeric and in xpdf (my eyesight has gotten worse in the last two years). It's much easier to specify -Paps1 with lpr on a command line than to figure out where the aps1 goes in the print dialogs. I also had trouble with specifying the correct pathname. again, mostly because of difficulty reading the text in the print dialogs. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Does OpenBSD Have a Spreadsheet That Prints Properly?
I write this as a person very committed to OpenBSD as a secure desktop. I can say from experience that, running with KDE, neither Kspread nor Gnumeric on OpenBSD 3.6 are useable (by me, at least) for hard copy of even simple spreadsheets. I am beginning to think *very* seriously about using a Windows computer *just* to run MS Excel so I can get reliably and straightforwardly the hard copy I need. Neither gnumeric nor kspread running on OpenBSD 3.6 qualify on the basis of my brief experience with those two programs. I will continue to use OpenBSD for accessing the internet, but my business related computing/printing tasks may well have to be done on Windows. Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Does OpenBSD Have a Spreadsheet That Prints Properly?
On Tuesday 14 June 2005 05:07 pm, Adrian Custer wrote: > Hello again, > > If you can't get gnumeric working on OpenBSD, gnumeric works on OpenBSD, The version that comes with 3.6 just has a lot of bugs in the print-to-pdf routines. > why don't you install one of the linuxes? I will only run OpenBSD for security reasons. I am going to paper and pencil for my daily records since gnumeric does not print well on OpenBSD. > There are a number of friendly distributions (Debian, > Red Hat, Ubuntu, Mandriva ...) which have effective output onto pdf or > onto paper. You could even use a bootable CD version of linux and you > would not have to install anything onto your hard disk. Maybe when I can run virtual pcs using AMD''s Pacifica. > > Please refrain from further posting on this list about alternatives on > OpenBSD. I will not be posting any more re any OpenBSD applications. > That distribution has a number of resources which are better > suited to your question. *This* list is specifically about gnumeric so > asking about alternatives is inherently off topic. Understood. > Personally, I will not answer any more of your questions on this > subject. Understood. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Does OpenBSD Have a Spreadsheet That Prints Properly?
On Tuesday 14 June 2005 07:40 pm, Andreas J. Guelzow wrote: > On Tue, 2005-14-06 at 18:19 -0500, Dave Feustel wrote: > > On Tuesday 14 June 2005 05:07 pm, Adrian Custer wrote: > > > Hello again, > > > > > > If you can't get gnumeric working on OpenBSD, > > > > gnumeric works on OpenBSD, The version that comes with 3.6 > > just has a lot of bugs in the print-to-pdf routines. > > There are no print-to-pdf routines in Gnumeric. There is in gnumeric a dialog box which allows selection of a generic postscript printer or the printing of a pdf file. I choose to print to a pdf file which I can inspect with xpdf before I try to print it. > (they are part of > libgnomeprint and you never bothered telling us which version of that > you are running or showing us a single incorrect pdf file.) My problem with gnumeric is that it always crashes when attempting to print a pdf file when there already exists a file with name selected as output. > > > > > why don't you install one of the linuxes? For security reasons, I will only run OpenBSD. Get used to it. > > I will only run OpenBSD for security reasons. > > In your earlier message you suggested that you will be using MS > Windows. I have decided to use paper and pencil to create my hardcopy "spreadsheets". ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Does OpenBSD Have a Spreadsheet That Prints Properly?
On Tuesday 14 June 2005 10:39 pm, Jody Goldberg wrote: > On Tue, Jun 14, 2005 at 06:19:49PM -0500, Dave Feustel wrote: > > On Tuesday 14 June 2005 05:07 pm, Adrian Custer wrote: > > > Hello again, > > > > > > If you can't get gnumeric working on OpenBSD, > > > > gnumeric works on OpenBSD, The version that comes with 3.6 > > just has a lot of bugs in the print-to-pdf routines. > > I can't imagine that the problem would be all that difficult to > diagnose and fix if you could get us some usable debug information. > It sounds like something in libgnomeprint or libgnomeprintui is > crashing with your setup. That is unfortunate. Get us a backtrace > and we can figure out where. The problem is unlikely to be gnumeric > specific. Can your print from evolution ? gedit ? abiword ? They > all use the same print backend. > > > I am going to paper and pencil for my daily records since > > gnumeric does not print well on OpenBSD. > > We are a volunteer organization. This sort of retoric This is not rhetoric, this is what I am going to do, partly because of limited funds and partly because of my need to figure some things out immediately. I am now also thinking of using my HP 49 calculator, or a newer version that runs faster and has more memory. > does little to encourage people to help with a problem that is very possibly > specific to your installation. I am sure the problem is at least specific to OpenBSD and maybe to my computer only. > You have yet to provide us with the two most basic elements of a bug > report. > - what version of gnumeric and associated libraries are >installed ? > - a backtrace of a crash. I don't have time to debug (Really!) It's easier for me to just go to pencil and paper, as many of my fellow contractors are doing. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Another gnumeric printing problem
On Friday 17 June 2005 05:26 pm, Richard Bumby wrote: > Re: Another gnumeric printing problem Thanks for the info. I have solved my gnumeric printing problem by simply not doing any printing in gnumeric. Gnumeric works well in screen mode. I will try printing again when I upgrade to OpenBSD 3.7 and a newer version of gnumeric. Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Multi-line Headers
How do I set up multi-line headers in headers and footers? Thanks, Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Date arithmetic
How is date arithmetic done in Gnumeric? I want to put a date in a cell and have 6 incremental dates generated in successive cells in the row. So I need a function that adds 1 to the date in the cell immediately to the left. I didn't see any obvious way to do this looking at the gnumeric date/time functions. Is there a straightforward way to do this? Thanks, Dave Feustel ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 03:48 pm, Morten Welinder wrote: > In A1, enter 2005-06-21 > In A2, enter =A1+1 > > Dates are just numbers formatted to look like dates. > > Morten This works on sheet 1 and fails on sheet 2 in cells with formatting identical to sheet 1. On sheet 2 I get I get ###. On sheet 1 the value runs over the next cell which is blank. I can get the value to display properly in sheet 2 by reducing the font size to 4, but it's hard to read :-) ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Multi-line Headers
On Wednesday 22 June 2005 03:56 pm, Morten Welinder wrote: > There seems to be no reasonable way to doing that, but at least there is an > unreasonable way: > > Enter the text in a cell, using Alt-Enter to seperate lines. Select > the whole text in > the edit line, and select Copy. The paste it into the page setup dialog. > > Morten Thanks! ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 04:29 pm, Uri David Akavia wrote: > Dave Feustel wrote: > > How is date arithmetic done in Gnumeric? > > I want to put a date in a cell and have 6 > > incremental dates generated in successive > > cells in the row. So I need a function that > > adds 1 to the date in the cell immediately to > > the left. I didn't see any obvious way to do this > > looking at the gnumeric date/time functions. > > Is there a straightforward way to do this? > > > > Thanks, > > Dave Feustel > > ___ > > gnumeric-list mailing list > > gnumeric-list@gnome.org > > http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > > > Did you try writing two of the cells, and then expanding them to the row? I tried that. It didn't work. But I copied the row from sheet 1 that displayed dates properly and pasted that to sheet 2, and that worked. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: > This has been around and documented since at least version 1.0.8. > Consult the manual for details on entering data in many cells > simultaneously or autofilling. I have found so far my experience with Excel stands me in good stead wrt copying formulas and filling. But the part about dragging the lower right corner of a cell is new to me. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: > This has been around and documented since at least version 1.0.8. > Consult the manual for details on entering data in many cells > simultaneously or autofilling. On my system clicking on help and then contents generates an error message on the console. I have to go to the gnumeric home page with my browser to access the manual. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 07:01 pm, Jody Goldberg wrote: > On Wed, Jun 22, 2005 at 05:41:27PM -0500, Dave Feustel wrote: > > On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: > > > This has been around and documented since at least version 1.0.8. > > > Consult the manual for details on entering data in many cells > > > simultaneously or autofilling. > > > > I have found so far my experience with Excel stands me in good > > stead wrt copying formulas and filling. But the part about dragging > > the lower right corner of a cell is new to me. > > Gnumeric tries to provide XL compatibility as an option. The drag > handle on the cursor for autofill is an XL feature. What does XL stand for? Something to do with Microsoft? (I stopped using Microsoft software about 3 years ago, so I am really out of touch with its current (new) software features). ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 07:02 pm, Jody Goldberg wrote: > On Wed, Jun 22, 2005 at 05:43:16PM -0500, Dave Feustel wrote: > > On Wednesday 22 June 2005 03:57 pm, Richard Bumby wrote: > > > This has been around and documented since at least version 1.0.8. > > > Consult the manual for details on entering data in many cells > > > simultaneously or autofilling. > > > > On my system clicking on help and then contents generates an > > error message on the console. I have to go to the gnumeric home > > page with my browser to access the manual. > > Sounds like another bug in the BSD package. I have worked my way through my printing problems and am now looking forward to upgrading to OpenBSD 3.7 which will have a newer version of Gnumeric. I am beginning to use Gnumeric a lot although my calculations are *really* simple. I would like to help make Gnumeric run well on OpenBSD. My time is limited because of the number of hours I put in on my job, but I will do what I can. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 08:41 pm, Jody Goldberg wrote: > On Wed, Jun 22, 2005 at 08:30:21PM -0500, Dave Feustel wrote: > > > > > > Sounds like another bug in the BSD package. > > > > I have worked my way through my printing problems > What was the solution ? Adding Headers and Footers, then getting them to print with the headers and footers, printing to pdf file puts each sheet on a separate page, which I was previously accomplishing by printing each sheet to a separate file. Now I just print the entire spreadsheet to a single pdf file and then print the pdf file using lpr. I spent a lot of time trying to get the spreadsheet to fit one page each time I modified it. Somewhere I clicked a 'fit to page' option, so I don't spend time tweaking the column widths any more Gnumeric is no longer crashing on me, but I save my changes frequently just in case. The feature that I could use the most at this point is the ability to do calculations using data from either an external spreadsheet or from a database. I am working with a downlevel version of Gnumeric, so I am waiting until I get the new version before I get too active about filing bug reports or making suggestions about new features. Ideally I would like to be able to recompile Gnumeric from source. With that capability I could start tweaking the code :-). > > and am now looking forward to upgrading to OpenBSD 3.7 which will > > have a newer version of Gnumeric. I am beginning to use Gnumeric a > > lot although my calculations are *really* simple. I would like to > > help make Gnumeric run well on OpenBSD. My time is limited because > > of the number of hours I put in on my job, but I will do what I > > can. > > It would be very helpful if you could make detailed bugzilla reports > of any problems you find. The key to getting things fixed is for us > to replicate the problem. The best bugs are the ones that are very > clear on exactly what version is being used, and provide detailed > steps on how to reproduce the problem. Most problems are actually > pretty simple once we locate them, the hard part is finding them. I like to think that I am very good at testing. One of the problems with reporting bugs in Gnumeric is that the version I'm using has so many bugs, possibly because in OpenBSD the user application file structure is not like other systems. (Most, if not all application files go into /usr/local/ rather than into /usr). I will document bugs with bug reports more often when I am working with a more current version of Gnumeric. I see a lot of error messages in the console log - a feature I like since it shows that gnumeric is aware of things going wrong. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Date arithmetic
On Wednesday 22 June 2005 10:00 pm, Jody Goldberg wrote: > On Wed, Jun 22, 2005 at 09:01:48PM -0500, Dave Feustel wrote: > > On Wednesday 22 June 2005 08:41 pm, Jody Goldberg wrote: > > > On Wed, Jun 22, 2005 at 08:30:21PM -0500, Dave Feustel wrote: > > > > > > > > > > Sounds like another bug in the BSD package. > > > > > > > > I have worked my way through my printing problems > > > What was the solution ? > > > > Adding Headers and Footers, then getting them to print > > with the headers and footers, printing to pdf file puts each > > sheet on a separate page, which I was previously accomplishing > > by printing each sheet to a separate file. Now I just print the entire > > spreadsheet to a single pdf file and then print the pdf file using > > lpr. > > > > Gnumeric is no longer crashing on me, but I save my changes frequently > > just in case. > > This sounds like voodoo. > Something was crashing repeatably it would be nice to know what. It's not voodoo. I stopped trying to do the things that I had figured out crashed gnumeric. Yesterday gnumeric went catatonic after I deleted a pdf file that gnumeric had apparently not let go of. I aborted and then restarted gnumeric with no ill effects. > > Ideally I would like to be able to recompile Gnumeric from source. > > With that capability I could start tweaking the code :-). > Building gnumeric is fairly trivial at this point _if_ you have the > dependencies installed. For a system that has not been used for > development there can be a rather significant number of build tools > and development libraries required. > > > I like to think that I am very good at testing. One of the problems with > > reporting bugs in Gnumeric is that the version I'm using has so many > > bugs, possibly because in OpenBSD the user application file structure > > is not like other systems. (Most, if not all application files go into > > /usr/local/ rather than into /usr). > Unlikely, gnumeric is completely parallel installable (or at least > it was, libspreadsheet needs versionsing for 1.5.3 to restore this). > I haven't run a copy out of /usr in months. > > > I will document bugs with bug reports > > more often when I am working with a more current version of Gnumeric. > > I see a lot of error messages in the console log - a feature I like since it > > shows that gnumeric is aware of things going wrong. > > Sounds good. Detailed problem reports are helpful. > ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
1 or 50 spreadsheets per file
I have 50 vending machines for which I want to rlog cash income. Would I be better off with 1 file per machine or with all 50 spreadsheets in a single file? Or does it make no difference with gnumeric in terms of file loading/saving speed? Thanks ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: 1 or 50 spreadsheets per file
On Thursday 23 June 2005 01:37 pm, Fernando Gómez wrote: > > It depends on the size of every spreadsheet. The spreadsheets will be quite small - no more than a log of amounts collected and dates the amounts were collected + a few simple calculations. > If they are individually too big, > you should have one file per machine because otherwise the system will take a > big amount of time to save little changes that you might only make to a single > spreadsheet. But if not, it would be faster, easier and more practical to just > have one file with the 50 spreadsheets. > > FG > > > I think it would be faster and more practical to have a machine per > spreadsheet > instead of > > On Thu, 23 Jun 2005 11:35:11 -0500 Dave Feustel <[EMAIL PROTECTED]> wrote: > > > I have 50 vending machines for which I want to rlog cash income. > > Would I be better off with 1 file per machine or with all 50 > > spreadsheets > > in a single file? Or does it make no difference with gnumeric in terms > > of > > file loading/saving speed? > > > > Thanks > > ___ > > gnumeric-list mailing list > > gnumeric-list@gnome.org > > http://mail.gnome.org/mailman/listinfo/gnumeric-list > > > ___ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list > ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
inconsistant panel icon behaviour
The default panel icon displays a generic message instead of 'gnumeric' when moused-over (all the other icons display similar generic program identifiers as well). When, via icon prooperties I change the mouse-over message to 'gnumeric', the icon is changed from the gnumeric icon to a generic icon. I have to reset the panel icon via the properties page. This seems a little inconsistant. Plus, when I tried an experiment of changing the command in a properties display, when I clicked 'ok', the icon, the properties of which I had just changed, DISAPPEARED from the panel and remained disappeared until I did *something*, (possibly ran kdeinit) that made it visible again. -- Tired of having to defend against Malware? (You know: trojans, viruses, SPYWARE, ADWARE, KEYLOGGERS, rootkits, worms and popups) Then Switch to OpenBSD with a KDE desktop!!! ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: inconsistant panel icon behaviour
On Thursday 25 August 2005 12:52, Morten Welinder wrote: > I don't think gnumeric is involved in the panel's operation at all. > In other words, you will need to talk to whoever made the panel. > > Morten > You are correct, of course. I have another panel issue to bring up when I discover the correct mailing list. -- Tired of having to defend against Malware? (You know: trojans, viruses, SPYWARE, ADWARE, KEYLOGGERS, rootkits, worms and popups) Then Switch to OpenBSD with a KDE desktop!!! ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Why would you go and do a thing like this ?
On Friday 26 August 2005 08:59, Jody Goldberg wrote: > On Fri, Aug 26, 2005 at 01:04:08AM -0500, Rob Ristroph wrote: > > > > Why don't you make gnumeric at least run without the > > libraries, and only load them with dl() when you actually need > > to play a sound and visit a web site, and make the software be > > politely and functionally silent if it doesn't find them ? > > Sounds like you want the gtk version of gnumeric without the gnome > extras. That would drop most of the libraries you're wondering > about. I don't see a gtk version listed at gnumeric.org. From where can the gtk version be downloaded? Thanks, Dave Feustel -- Tired of having to defend against Malware? (You know: trojans, viruses, SPYWARE, ADWARE, KEYLOGGERS, rootkits, worms and popups) Then Switch to OpenBSD with a KDE desktop!!! ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Why would you go and do a thing like this ?
On Friday 26 August 2005 09:53, Jody Goldberg wrote: > On Fri, Aug 26, 2005 at 09:07:30AM -0500, Dave Feustel wrote: > > On Friday 26 August 2005 08:59, Jody Goldberg wrote: > > > On Fri, Aug 26, 2005 at 01:04:08AM -0500, Rob Ristroph wrote: > > > > > > > > Why don't you make gnumeric at least run without the > > > > libraries, and only load them with dl() when you actually need > > > > to play a sound and visit a web site, and make the software be > > > > politely and functionally silent if it doesn't find them ? > > > > > > Sounds like you want the gtk version of gnumeric without the gnome > > > extras. That would drop most of the libraries you're wondering > > > about. > > > > I don't see a gtk version listed at gnumeric.org. > > From where can the gtk version be downloaded? > > It's part of the main tarball. Just run configure as > --without-gnome > You'll lose a gconf, and gnome-vfs support. > Thanks. I'm currently running the official OpenBSD port of gnumeric and I confess, that when I saw how many packages were installed along with gnumeric, I wanted to cancel the pkg_add immediately. But now gnumeric runs well so I no longer care about all the extras. Disk space is cheap. -- Tired of having to defend against Malware? (You know: trojans, viruses, SPYWARE, ADWARE, KEYLOGGERS, rootkits, worms and popups) Then Switch to OpenBSD with a KDE desktop!!! ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: Increasing number of rows in Gnumeric
On Tuesday 31 October 2006 09:34, Kenneth B. Davis wrote: > Hello List, > I need to increase the number of rows in Gnumeric to a huge number > (256*256*256*256). I have seen the proceedure in the FAQ section and found > the correct file in the source code. However I am NOT a programmer and > would not know a C compiler if it bit me. Can someone help with this? > Thank-you in advance. Ken Let's see if I've got this right, you want 4,294,967,296 rows, right? What sort of computer do you plan to run this on? Dave -- "How are nations ruled and led into war? Politicians lie to journalists and then believe those lies when they see them in print." —Austrian journalist Karl Wiegand, explaining the causes of the First World War. ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Format Painter
Hi, I have looked back in the archives and noticed that the equivalent of Excel's Format Painter has often been mooted - Has Gnumeric now got this option (I can't see it) Regards Dave ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: proven! bright screens make us sick; please implement black-background viewing option as in excel and calc
Quoting marc dunord : i implore you guys/gals again! please implement a black-background viewing option as those offered by excel and calc... see link below: bright screens make us sick ! :( http://www.guardian.co.uk/science/2013/may/22/peering-bright-screens-dark-harm-health it would be enough to just reverse colors (like a photo negative) and keep the printing as if one worked with a bright-background screen. as offered by pdf viewers in linux and windows... best marc __ this might work for you: http://stereopsis.com/flux/ Dave _ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list -- The problem with being cynical is you can't keep up! -- anon. philosopher ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
gnumeric website error
on the page at gnumeric.org is a broken link: http://www.csdassn.org/software_reports/gnumeric.pdf with link text "researchers" Dave -- Reporter to Mahatma Ghandi after his tour of east London "What do you think of western civilization, Mr. Ghandi?" Ghandi - "I think it would be an excellent idea!" ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
gnumeric 1.12.28 questions
I have a spreadsheet with about 20 columns and 8700 rows. The first two rows are headers and I'd like to format them to not scroll while I'm scanning the lower rows. I don't know how to do this so any advice is welcome. Also, I tried to search gnumeric help and got an error message saying, "The URI ‘ghelp:gnumeric’ does not point to a valid page." Any help fixing this would be welcome too. TIA Dave -- Reporter to Mahatma Ghandi after his tour of east London "What do you think of western civilization, Mr. Ghandi?" Ghandi - "I think it would be an excellent idea!" ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: gnumeric 1.12.28 questions
On Sat, 6 Aug 2016 13:48:08 -0700 Dave Stevens wrote: > I have a spreadsheet with about 20 columns and 8700 rows. The first > two rows are headers and I'd like to format them to not scroll while > I'm scanning the lower rows. I don't know how to do this so any > advice is welcome. > > Also, I tried to search gnumeric help and got an error message saying, > "The URI ‘ghelp:gnumeric’ does not point to a valid page." Any help > fixing this would be welcome too. > > TIA > > Dave > > yes, both freeze methods work, thanks. Any ideas about the missing help? Mint 18 if it matters. Dave -- Reporter to Mahatma Ghandi after his tour of east London "What do you think of western civilization, Mr. Ghandi?" Ghandi - "I think it would be an excellent idea!" ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
gnumeric spreadsheet newbie questions
I have some spreadsheets with about 30K rows each. In column A is a time and date like this - 2017-11-01 00:01:16 UTC. The time increments monotonically for a month then that's all the rows. I'd like to sum the readings for each hour, The number of rows per hour varies a bit with uneven intervals. So in a general sense: set sum to 0 While hour is unchanged do: add readings in column B end; display hourly total in column C and iterate over all rows until a blank row is found (EOF) If there's some function to do this or some part of this I'd appreciate a reference, or [perhaps hand-holding off-line.] The F1 help in my copy of gnumeric 1.12.28 gives an error message. Dave -- In modern fantasy (literary or governmental), killing people is the usual solution to the so-called war between good and evil. My books are not conceived in terms of such a war, and offer no simple answers to simplistic questions. - Ursula Le Guin ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list
Re: How to prevent Gnumeric from overwriting the same file by different gnumeric instances
Is there a reason that the patch attached to that bug wasn't applied? Dave. On 23/03/18 09:10, Morten Welinder wrote: There currently isn't although there was some discussion about it a long while ago, see https://bugzilla.gnome.org/show_bug.cgi?id=334024 I guess at least we ought to check if the file system time stamp has changed since we loaded the file. That would catch the vast majority of the problems. M. On Thu, Mar 22, 2018 at 5:13 PM, Yury Dubinsky wrote: Hello, When we click on a spreadsheet file, Gnumeric every time opens the file in a new program instance without any checking if this file was already open. Thus, it is extremely easy to accidentally overwrite the file content. The most of advanced text editors warn users in case when open files are changed on the disk. Office suites, such as LibreOffice, MS Office lock open files. Is there anything similar in Gnumeric? Thanks, Yury ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list ___ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list