Re: Format while exporting text files

2022-04-20 Thread Andreas J. Guelzow
Hmm, works for me. Which version of Gnumeric are you running? Do you have a minimal (i.e. 1 cell) example file that does not work for you? Andreas On 2022-04-20 12:53 p.m., Rex Couture via gnumeric-list wrote:     I'm trying to export text files, and it would be nice if I could preserve

Re: 'floor' xlsx roundtrip sometimes comes back as 'rounddown' - intentional?

2022-04-20 Thread Andreas J. Guelzow
Excel and so xlsx files do not understand '=floor(0.5)'. So when one exports to xlsx one cannot retain '=floor(0.5)'. To retain the functions as they are you either have to restrict yourself to excel functions os save in Gnumeric's own format. Andreas On 2022-04-20 11:12 a.m., newbie

Re: follow up II - newbie questions, sum over range, rounding of special problematic values

2021-05-23 Thread Andreas J. Guelzow
Hi, On 2021-05-22 7:26 p.m., Steven D'Aprano wrote: input 0.24997 You are playing at the edge of the maximum mantissa length. Did you ever try using that number in LibreOffice or Excel? Andreas ___ gnumeric-list mailing list

Re: Order of items in legend, stavked bar chart

2020-03-17 Thread Andreas J Guelzow
Hi, for the X-Axis, check "Invert Axis" Andreas On 2020-03-17 1:22 p.m., Anton Kratz via gnumeric-list wrote: I often do a figure like the attached example: a horizontal stacked bar chart with a legend. The problem is that the order of the legend is always the opposite of the order in which

Re: interpolation models

2019-02-08 Thread Andreas J Guelzow
HI, please provide a complete minimal example that you think should work but fails, including all data. Andreas On 2019-02-08 12:08 p.m., Mark Lytle wrote: Hello all, I now have interpolation working on Gnumeric and it is giving reasonable numbers, but it seems to only have linear

Re: Problem with Font height/Row Height

2018-03-12 Thread Andreas J Guelzow
Hi, while Gnumeric should load the correct row heights you can fix it after the fact by selecting the whole sheet and then choose format->rows->AutoFitHeight. Andreas On 18-03-12 02:25 PM, John R. Sowden wrote: I am in the process of switching from LO to Gnumeric because of the very slow

Re: Adjusting menus

2018-03-02 Thread Andreas J Guelzow
You can also move them to the right or left of the sheet area by right-clicking on them and selecting the orientation from the pop-up menu. Andreas On 18-03-02 02:20 PM, Rich Shepard wrote: On Fri, 2 Mar 2018, Jean Brefort wrote: You can't. But you can hide them using the View menu.

Re: Extensions to ODF

2018-01-06 Thread Andreas J. Guelzow
Hi, we also have https://git.gnome.org/browse/gnumeric/tree/doc/developer/odf-foreign.txt but that may not be 100% complete, but it also lists name-spaced attribute values. Andreas On 18-01-06 10:06 AM, Morten Welinder wrote: does there exists a public available list of Gnumeric

Re: gnumeric-list Digest, Vol 161, Issue 2

2017-11-18 Thread Andreas J. Guelzow
Gnumeric does have a "New form Template" which opens a copy of a template file. You can use that to preset things like default cell formats. Andreas On 17-11-18 01:04 PM, Morten Welinder wrote: set the number format for all cells in the book The default for that is always "General". When

Re: prevent import of control chars

2016-07-17 Thread Andreas J. Guelzow
HI, if it is a single one-time file you could open it in Gnumeric, use search and replace to remove the newlines and then export it... Andreas On 16-07-17 11:33 AM, Bee wrote: I inherited an Excel spreadsheet. The Excel file has many sheets. It has some 0x0a LineFeed control chars in

Re: Hardcopy Version of GNUmeric manual

2016-05-16 Thread Andreas J. Guelzow
Both a pdf and an html version of the Gnumeric manual can be build from the source. You can get a recent version of the pdf document from http://aguelzow.concordia.ab.ca/wp-content/blogs.dir/39/files/2016/05/gnumeric.pdf Andreas On 16-05-16 12:46 PM, W. D. Allen wrote: Is it possible to get a

Re: ssconvert problems with multi-sheet export

2016-03-27 Thread Andreas J. Guelzow
Hi Chris, that is a known bug that was fixed a while back. You appear to be using an ancient version of gnumeric and ssconvert. Current is 1.12.28 and (I believe) the bug was fixed in 1.12.27. Gnumeric 1.12.27 +Morten: + * Teach ssconvert to split sheets into separate .txt files [#694408] +

Re: Additional symbols in xlsx ex Gnumeric

2015-12-06 Thread Andreas J. Guelzow
I don't see those symbols on MS-Excel 2013 either. Are you sure you attached the correct sample file? Andreas On 15-12-06 12:56 PM, Morten Welinder wrote: Also no problems for me with Excel 2010. M. On Sun, Dec 6, 2015 at 10:09 AM, Morten Welinder wrote: I will have to

Re: How to save advanced-filter settings (fwd)

2015-04-14 Thread Andreas J Guelzow
On 15-04-14 08:38 AM, Bob wrote: OK, I see part of the problem is over the meaning of histogram. Everywhere except in spreadseets it means a graphical display. So I started by clicking on the graphical display icon. If I go your route I do not get a graphical display, I get a frequency table

Re: How to save advanced-filter settings (fwd)

2015-04-14 Thread Andreas J Guelzow
-Virus-Scanned: by amavisd-new at gnome.org X-ASG-Debug-ID: 1429028087-0538de0f6f5cbcf0001-FiEwLn X-Barracuda-Envelope-From: aguel...@pyrshep.ca X-Barracuda-Apparent-Source-IP: 64.34.111.205 Message-ID: 552d3d46.8020...@pyrshep.ca Date: Tue, 14 Apr 2015 10:16:06 -0600 From: Andreas J Guelzow

Re: How to save advanced-filter settings

2015-04-13 Thread Andreas J. Guelzow
Le dimanche 12 avril 2015 à 19:30 -0400, Bob a écrit : In gnumeric it should be easier;-) (I actually can't figure out how to do it in gnumeric but I think you have to chose a lot of things Minitab and R will chose automatically [while still allowing you to override anything] What I would like

Re: manual with all of the charting modules

2015-02-26 Thread Andreas J Guelzow
On 15-02-26 10:52 AM, Adrian Custer wrote: Hey, Hope you are having fun with Gnumeric. The manual is in a sorry state. We did massive work writing it many years ago but, since then, little has been done to maintain it. I don't think that that is a proper description what has happened. There

Re: How to copy formulas from a text or remove (') from ('=) in many cells WITHOUT using CSV files ?

2015-02-16 Thread Andreas J. Guelzow
This works for me. Do you have what would be a valid expression in A1? =1*1 is clearly valid but I am wondering about your choice of words an error message like this. Andreas On 15-02-16 09:19 PM, Yury Dubinsky wrote: This question was asked on 21 May 2011 .

Re: Feature suggestion: quickly sort columns from auto filter menu

2014-08-08 Thread Andreas J. Guelzow
This is enhancement request https://bugzilla.gnome.org/show_bug.cgi?id=497954 . Andreas On 14-08-07 02:43 AM, arist...@web.de wrote: Hi, I'm happily using Gnumeric Spreadsheet 1.10.17 in Ubuntu 12.04. One feature I am desperately missing (and that Excel 2010 offers) is to quickly sort a

Re: Editing auto-generated statistic cells

2014-02-14 Thread Andreas J Guelzow
On Fri, 2014-02-14 at 22:01 +1100, Pete Crite wrote: Hi, I'm attempting to do some repetitive statistics on some data. I'm not sure if it's important, but I'm using the menu item at Statistics One Sample Tests Claims About a Mean. I'm planning on testing about 30 sets of data, and

Re: Gnumeric for SEO work

2013-11-08 Thread Andreas J Guelzow
with Excel? Sincerely, Gour You can basically do anything that is listed in excel-sor-sep with Gnumeric with the important exception of Pivot Tables. Gnumeric at this time does not have a pivot table interface. Andreas -- Andreas J. Guelzow, PhD FTICA Professor of Mathematical Computing

Re: [1.12] countif(range, expression) unimplemented

2013-05-17 Thread Andreas J Guelzow
function implementation unavailable should mean that you do not have the plugin loaded that defines 'countif'. Please check Tools-Plugins whether the Math functions are loaded. Andreas On Fri, 2013-05-17 at 23:57 +0200, bat.gu...@don.blech.e4ward.com wrote: Good evening Tim, and good evening

Re: Graph, chart, plot

2013-02-19 Thread Andreas J Guelzow
The README.analysis file is intended specifically for the statistical analysis tools. Andreas Marek Černocký ma...@manet.cz wrote: Source tree already contains file po/README.analysis. It can be renamed to a more intuitive name for translators (e.g. mentioned TERMINOLOGY) and supplemented.

Re: Manual page of ssconvert

2012-04-30 Thread Andreas J Guelzow
On Mon, 2012-04-30 at 10:39 -0400, Dick Bingham wrote: Unable to execute man ssconvert, as suggested from http://projects.gnome.org/gnumerics/doc/s.. Converting Files. ssconvert is located in my C:\Program Files (x86) Gnumeric/1.10.16/bin/. Have been able to execute ssconvert

Re: superscript in a chart legend

2012-02-01 Thread Andreas J. Guelzow
On Wed, 2012-02-01 at 19:55 +0100, Jean Brefort wrote: Not yet, but I'll add this very shortly. Regards, Jean Le mercredi 01 février 2012 à 19:31 +0100, Frederic Parrenin a écrit : Dear Gnumericers, How is it possible to insert superscript in a chart legend? Thank you very much

Re: gnumeric on os x

2011-04-06 Thread Andreas J. Guelzow
On Wed, 2011-04-06 at 12:58 -0400, Geoffrey Brown wrote: I don't know if this is a macports issue. While I've managed to get gnumeric to work correctly under my account -- all that launchctl stuff was a pain -- I haven't been able to get my cgi scripts (running as _www) to successfully use

Re: gnumeric on os x

2011-04-06 Thread Andreas J. Guelzow
On Wed, 2011-04-06 at 13:39 -0400, Geoffrey Brown wrote: Not sure how that will help -- gnumeric is looking for a dbus socket. In my user account if I execute launchctl load -w /Library/LaunchAgents/org.freedesktop.dbus-session.plist then ssconvert works file. It is not really Gnumeric

Re: Where are plugin functionality descriptions?

2011-03-21 Thread Andreas J. Guelzow
On Mon, 2011-03-21 at 12:10 -0500, Larry Evans wrote: Now, I could resort to looking in the bottom section of the Plugin List tab, but that just shows Spreadsheets Is that the category of the plugin? IOW, to find the functions in this plugin, I'd select the function icon, f(x), at the

Re: New pygnumeric update

2011-03-16 Thread Andreas J. Guelzow
On Wed, 2011-03-16 at 17:15 -0500, Cloudform C wrote: http://cloudform511.posterous.com/pygnumeric-updates-performance-useability-and I've made it more useable and added a ton of features. Check them out. You may want to fix your plugin.xml file. It currently advertises itself as:

Re: Bug in selection intervals??

2011-02-14 Thread Andreas J. Guelzow
The linear regression issue is bug # 551234. The histogram issue is relatively easy to fix. Andreas On Mon, 2011-02-14 at 13:35 -0500, Daniel P. Dougherty wrote: It used to be in prior versions of Gnumeric that you could select the entire column by clicking on the column header when doing a

Re: Histogram Bins tab options problem

2011-02-08 Thread Andreas J. Guelzow
On Tue, 2011-02-08 at 13:32 -0500, Daniel P. Dougherty wrote: Under the bins tab on the histogram dialog there is a possible error in the labels. The issue is how to capture the finite minimum and maximum data values in a bin?? I think it is more correct that the 8 rules should each be

Re: Histogram Bins tab options problem

2011-02-08 Thread Andreas J. Guelzow
On Tue, 2011-02-08 at 13:32 -0500, Daniel P. Dougherty wrote: Under the bins tab on the histogram dialog there is a possible error in the labels. The issue is how to capture the finite minimum and maximum data values in a bin?? I think it is more correct that the 8 rules should each be

Re: Histogram Bins tab options problem

2011-02-08 Thread Andreas J. Guelzow
On Tue, 2011-02-08 at 14:51 -0500, Daniel P. Dougherty wrote: The other issue is that the bin labels created by the Histogram process appear as english words note that they only appear as english words. They are numbers. Histogram 0.22251744455154 above

test required

2009-12-29 Thread Andreas J. Guelzow
of those versions of gtk, could you let us know whether you crash gnumeric when previewing a page containing a sheet widget. Thanks Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http

Re: test required

2009-12-29 Thread Andreas J. Guelzow
On Tue, 2009-12-29 at 17:48 +0800, bill lam wrote: mar, 29 Dec 2009, Andreas J. Guelzow skribis: Current git prints bitmap versions of sheet widgets (radio buttons, check buttons, scroll bars, ...) This uses some untested gtk features. It appears to work fine with gtk 2.18.5. We need

Re: Strike-through not working when save-as HTML 4.0

2009-12-13 Thread Andreas J. Guelzow
] Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Print view

2009-11-18 Thread Andreas J. Guelzow
creates an .emf file. That is then opened with whatever application is configured within Windows to open that kind of file. There is a known bug that the created .emf file is empty. I suspect that you are encountering that bug! Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca

Re: auto_completion not preserved

2009-11-18 Thread Andreas J. Guelzow
in on or off. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: unstable openoffice metadata

2009-11-17 Thread Andreas J. Guelzow
info shouldn't really matter. The metadata is gnumeric's metadata (you can edit it in file-properties) so I wouldn't consider it foreign metadata. Ww just happen the use the same format as for our metadata as ODF. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca

Re: missing recent files

2009-11-02 Thread Andreas J. Guelzow
On Mon, 2009-11-02 at 13:46 +0800, bill lam wrote: On Sun, 01 Nov 2009, Andreas J. Guelzow wrote: On Mon, 2009-11-02 at 12:55 +0800, bill lam wrote: I can find no recent files inside file menu. There is only a full history but that is sorted by file name and not that I want. I compile

Re: missing recent files

2009-11-02 Thread Andreas J. Guelzow
On Mon, 2009-11-02 at 16:55 +0800, bill lam wrote: On Mon, 02 Nov 2009, Jean Bréfort wrote: Le lundi 02 novembre 2009 à 13:46 +0800, bill lam a écrit : On Sun, 01 Nov 2009, Andreas J. Guelzow wrote: On Mon, 2009-11-02 at 12:55 +0800, bill lam wrote: I can find no recent files inside

Re: Handling of quote characters in ssconvert

2009-11-01 Thread Andreas J. Guelzow
data need to be quoted? never, auto (puts quotes where needed), or always. Defaults to never. quoting-on-whitespace Controls whether initial or terminal whitespace forces quoting. Defaults to TRUE. Andreas -- Andreas J. Guelzow aguel

Re: force updating using ssconvert

2009-10-27 Thread Andreas J. Guelzow
of it (THe size changed by a few bytes and the modification date changed.) What happens in your case? Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo

Re: getting around null cell values?

2009-10-02 Thread Andreas J. Guelzow
On Fri, 2009-10-02 at 02:52 -0400, David Heinrich wrote: also, is there any way to get LINEST to display a, b, and c coefficients in cells one-beneath the other. I want my a, b, c coefficients displayed in say B9, B10, and B11...not in B9, C9, D9. I have other y-data in the B, C, and D

Re: 2 Qs: size of tables worksheets? graphed output to html?

2009-10-02 Thread Andreas J. Guelzow
On Fri, 2009-10-02 at 23:50 -0400, ken wrote: Leonard, Thanks for the great tips. But what's R? http://www.r-project.org/ Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http

Re: How to add vertical line or point to a XY chart with 2 series?

2009-09-28 Thread Andreas J. Guelzow
/pct_remix_per_day.gnumeric The first column represents dates and the two other columns represent values on each date. As you can see from the properties of the chart, I added a Point to one of the series but it does not show up. Any ideas would be greatly appreciated. Thanks. -- Andreas J

Re: control of overflow of cell content into adjacent cell(s)

2009-09-18 Thread Andreas J. Guelzow
way to determine if a cell is truly 'empty'? The only thing that can really overflow in to the next cell is straight text. Even text that is created by a formula cannot overflow. Andreas -- Andreas J. Guelzow, PhD, FTICA Mathematical Computing Sciences Concordia University College of Alberta

Re: Gnumeric fails to launch after install on TinyMeLinux 2008.1 Droplet

2009-08-07 Thread Andreas J. Guelzow
? Andreas Any help with this error would be appreciated Thanks in advance -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: How to get rid of #VALUE!

2009-08-02 Thread Andreas J. Guelzow
,credits and balances columns. One of those cells is likely to contain something unusual. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Fwd: Gnumeric and OpenOffice.org

2009-07-09 Thread Andreas J. Guelzow
have no incompatibility problem with Excel. Gnumeric's CEIL should match ODF's CEILING function. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric

Re: Gnumeric and OpenOffice.org

2009-06-29 Thread Andreas J. Guelzow
. But of course those graphs would be restricted to ODF capabilities (and OOWriters capabilities). This issue is therefore more one of OOWriters capabilities than Gnumeric's. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list

Re: Graph themes (guppi vs. default vs. custom)

2009-06-24 Thread Andreas J. Guelzow
change the data source. You can also add new series ysing the add (+) button. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: html export - bold, italic not set

2009-05-07 Thread Andreas J. Guelzow
file a bug report at bugzilla.gnome.org. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: how to git gnumeric

2009-04-27 Thread Andreas J. Guelzow
://svn.gnome.org/svn/gnumeric/trunk gnumeric git git://git.gnome.org/gnumeric fetch If you have an ssh account with Gnome: git ssh://usern...@git.gnome.org/git/gnumeric fetch svn up git pull --rebase your mileage may vary(, since this is just from memory). Andreas -- Andreas J. Guelzow, PhD, FTICA

Re: simple q: how to put a fct into the 2nd col ?

2009-04-19 Thread Andreas J. Guelzow
corner of the cell (it changes to a cross) and drag down to B100. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: GODataScalar, GODataVector and GODataMatrix removal

2009-04-18 Thread Andreas J. Guelzow
On Sat, 2009-04-18 at 18:25 +0200, Emmanuel Pacaud wrote: Hi, Here's the patches that removes GODataScalar, GODataVector and GODataMatrix and moves their functionality into GOData. It could be possible to go further and also merge the GODataFooVal, GODataFooStr and GnmGOFooData classes

Re: gnumeric-list Digest, Vol 59, Issue 21

2009-03-27 Thread Andreas J. Guelzow
On Fri, 2009-03-27 at 08:54 -0600, Jim Martin wrote: gnumeric-list-requ...@gnome.org wrote: Date: Thu, 26 Mar 2009 11:12:55 -0600 From: Andreas J. Guelzow aguel...@math.concordia.ab.ca Subject: Re: gnumeric-list Digest, Vol 59, Issue 21 According to the Gnumeric solver dialog

Re: gnumeric-list Digest, Vol 59, Issue 21

2009-03-26 Thread Andreas J. Guelzow
of algorithm is used by OpenOffice Calc and/or Excel? (I doubt that there is a general solver that will converge in seconds for an arbitrary problem.) Andreas -- Andreas J. Guelzow, PhD, FTICA Coordinator, Mathematical Computing Sciences Concordia University College of Alberta

Re: Gnumeric FREQUENCY function with text data ??

2009-03-21 Thread Andreas J. Guelzow
for nominal data including text data that will enter (some other) formulas for you to create the same type of frequency table. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca attachment: screen.png___ gnumeric-list mailing list gnumeric-list@gnome.org

Re: Range operators

2009-03-21 Thread Andreas J. Guelzow
. Of course this has nothing to do with whether the SUM function is Excel compatible or not. It is the comma operator (when used) that is the problem. In your formula you didn't use it though. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca

Re: Range operators

2009-03-21 Thread Andreas J. Guelzow
~ as the cell concatenation symbol. (I am not sure where the claim that Gnumeric uses + in its display comes from, perhaps an old version?) Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca

Re: Preserving Leading Zeros in Gnumeric?

2009-03-20 Thread Andreas J. Guelzow
with strings then anything can be preserved. Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Problems with Gnumeric 1.9.4 on x86_64 (Centos 5.2)

2009-03-01 Thread Andreas J. Guelzow
programs to see whether those libraries work for you? Note that gnumeric works just fine on 64 bit hardware. In fact most gnumeric developers seem to use 64 bit hardware. -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list gnumeric

Re: Wrong results with named cells in formula

2009-02-24 Thread Andreas J. Guelzow
are addressing. In current svn we are defaulting to absolute addressing and so unless you know what you are doing you are not likely to use relative addressing here! Andreas -- Andreas J. Guelzow aguel...@pyrshep.ca ___ gnumeric-list mailing list

Re: Database Functions

2009-02-10 Thread Andreas J Guelzow
not quite sure I understand what you are doing. You may have to be a bit more explicit, but the criteria should have the label above the value, so: H2:J2 contains Brown and 90 is not right it should be H2:H3 contains... Andreas -- Andreas J. Guelzow Concordia University College of Alberta

Re: greek letters

2009-01-15 Thread Andreas J. Guelzow
On Thu, 2009-01-15 at 13:52 +0100, mathieu trocme wrote: Hi there, and thanks for this nice tool. I'm currently struggling to display greek letters. The Ctrl+Shift thing (http://mail.gnome.org/archives/gnumeric-list/2002-October/msg00099.html) does not work with the GNUmeric Windows

Re: how to compute totals grouped by field?

2009-01-10 Thread Andreas J. Guelzow
On Sun, 2009-01-11 at 02:07 +1100, Hal Ashburner wrote: Adam Dingle wrote: In Gnumeric, suppose that I have a series of rows representing payments to vendors. Each row contains a date, a vendor name and a payment: 4/3 XyzCo 4.15 4/4 AbcCo 8.20 4/5 XyzCo 2.25

Re: non-parametric data analysis tools needed

2008-12-27 Thread Andreas J. Guelzow
-test), Kruskal-Willis H-test (analog of ANOVA), and Spearman test (analog of Pearson test). Does anybody know if gnumeric development team plans to include these tools in future releases of the program? There is a pretty good chance that we will add them. Andreas -- Andreas J. Guelzow aguel

Re: how to copy all format of one sheet to another

2008-12-11 Thread Andreas J. Guelzow
On Fri, 2008-12-12 at 10:56 +0700, Tawee Laoitichote wrote: when I have existing format of one sheet which I already set ; say 1-day data; then next day with the same format as previous day, I have to format again. Is there any shortcut for this operation. Thanks. Copy, paste special

Re: how to copy all format of one sheet to another

2008-12-11 Thread Andreas J. Guelzow
On Fri, 2008-12-12 at 10:56 +0700, Tawee Laoitichote wrote: when I have existing format of one sheet which I already set ; say 1-day data; then next day with the same format as previous day, I have to format again. Is there any shortcut for this operation. Thanks. Copy, paste special

Re: Column Graphs

2008-11-24 Thread Andreas J. Guelzow
according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list

Re: Another try to get a response

2008-11-18 Thread Andreas J. Guelzow
On Tue, 2008-11-18 at 09:34 -0800, George Dell wrote: Hello Adrian, Thank you for engaging me on this issue. While I am a deep believer in “freedom” as you mention it – I also need to be able to have people (who understand none of the technospeak and specialized words), able to get to

Re: Another try to get a response

2008-11-18 Thread Andreas J. Guelzow
On Tue, 2008-11-18 at 20:30 +0100, Lutz Müller wrote: On Mon, 2008-11-17 at 21:53 -0800, George Dell wrote: In going to the web page Getting Gnumeric the new, excited, but unknowledgeable potential user is confronted with an immediate technospeak problem. You are probably expecting

Re: Another try to get a response

2008-11-18 Thread Andreas J. Guelzow
On Wed, 2008-11-19 at 07:43 +1100, John Machin wrote: On 19/11/2008 06:39, Andreas J. Guelzow wrote: On Tue, 2008-11-18 at 20:30 +0100, Lutz Müller wrote: On Mon, 2008-11-17 at 21:53 -0800, George Dell wrote: In going to the web page Getting Gnumeric the new, excited, but unknowledgeable

Re: Help with Gnumeric

2008-10-04 Thread Andreas J. Guelzow
consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds

Re: Histogram chart - What do the y-axis numbers mean?

2008-09-12 Thread Andreas J. Guelzow
On Fri, 2008-09-12 at 15:28 -0400, Marlon Nelson wrote: Thank you, Jean Another question: The data table was produced using the Histogram tool. The 1% bin counts 1011 data points between -1% and 1%. In the chart of the histogram, the area representing those points falls between 1% and 3%

Re: chart either does not work or is not intuitive

2008-09-05 Thread Andreas J. Guelzow
On Fri, 2008-09-05 at 16:06 -0700, Ralph Shumaker wrote: Andreas J. Guelzow wrote: Now that we know what yo udon't like could you tell us what you would like? I suspect the main problem may be the fcat that you have the one outlying data point: 090705. This will mess up any automatic

Re: Lognormal distribution

2008-08-22 Thread Andreas J. Guelzow
but not m. SO I don't see a bug anywhere. Andreas -- Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean

Re: Lognormal distribution

2008-08-22 Thread Andreas J. Guelzow
but not m. SO I don't see a bug anywhere. Andreas -- Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean

Re: Cell and Font Sizes

2008-08-18 Thread Andreas J. Guelzow
in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds signature.asc Description: This is a digitally signed message part

Re: Managed to recover

2008-05-27 Thread Andreas J. Guelzow
. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: build issues

2008-05-26 Thread Andreas J. Guelzow
? Or is it time to check my hardware? -- Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Prof. Dr. Andreas J. Guelzow Dept

Re: filtering and copying in gnumeric (Andrea Taroni)

2008-05-06 Thread Andreas J. Guelzow
On Tue, 2008-05-06 at 18:06 -0500, David Stanaway wrote: Yeah - it is a must have, but an intrusive implementation would be needed. First step would be an acknowledgment from the developers that this is a feature worth implementing. Any patch that attempts to make it work is going to

Re: Are You Using Gnumeric for Work?

2008-04-01 Thread Andreas J. Guelzow
. Rousseau Prof. Dr. Andreas J. Guelzow Dept. of Mathematical Computing Sciences Concordia University College of Alberta ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Couple of questions...

2008-03-31 Thread Andreas J. Guelzow
On Mon, 2008-03-31 at 11:35 -0400, Daniel P. Dougherty wrote: I am interested in doing a power of the test calculation for a Binomial experiment. How can I calculate critical values of the Binomial using Gnumeric? There does not seem to be a function for this but surely this is a heavily

Re: Complex Calculations

2008-02-25 Thread Andreas J. Guelzow
On Tue, 2008-02-26 at 06:10 +1100, John Machin wrote: Ralph Shumaker wrote: John Machin wrote: Secondly, you don't need sum(En-Fn) ... just En-Fn is enough. En-Fn will give you the difference. sum(En-Fn) is different. Where x is a scalar, how can sum(x) differ from x? Give

Re: gnumeric XML doesn't show result of formula

2008-02-10 Thread Andreas J. Guelzow
people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: gnumeric XML doesn't show result of formula

2008-02-09 Thread Andreas J. Guelzow
On Mon, 2008-02-04 at 20:37 -0500, Allin Cottrell wrote: On Mon, 4 Feb 2008, Andreas J. Guelzow wrote: I think [putting formula results into the XML] this is reasonable. A case in point that I know of is the econometrics program, gretl. gretl can read a variety of formats

Re: gnumeric XML doesn't show result of formula

2008-02-03 Thread Andreas J. Guelzow
On Sun, 2008-02-03 at 07:22 +1100, John Machin wrote: Andreas J. Guelzow wrote: On Sat, 2008-02-02 at 12:55 +1100, John Machin wrote: Hello, Here's the results of a little experiment (start up the UI, type =sqrt(2) into cell A1, save as ...) for a few varieties of XML

Re: Regression Result in Gnumeric

2008-01-10 Thread Andreas J. Guelzow
On Thu, 2008-01-10 at 14:45 +0100, Markus Häge wrote: Hello, I explore since a few months the open-source-world and like to know what are the results of the regression in statistics of gnumeric. A Heap of number, some I know, but mostly it's a riddle. Even my statistic-Professor doesn't

Re: Request for goffice relicensing

2007-11-29 Thread Andreas J. Guelzow
. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

gnumeric's glade files

2007-11-07 Thread Andreas J. Guelzow
-- Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Customize Chart needs love before release

2007-10-28 Thread Andreas J. Guelzow
On Sun, 2007-28-10 at 22:39 +0100, Emmanuel Pacaud wrote: Le dimanche 28 octobre 2007 à 22:28 +0100, Emmanuel Pacaud a écrit : Le dimanche 28 octobre 2007 à 23:03 +0100, Adrian Custer a écrit : So you seem to be aware that with a mouse drag, I can drag the chart to Y=199.3%. To a naive

Re: Gnumeric dies on two-means, unequal variances.

2007-10-17 Thread Andreas J. Guelzow
450676 fixed a while ago. Andreas -- Andreas J. Guelzow, Professor Dept. of Mathematical Computing Sciences Concordia University College of Alberta ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric

Re: Recent files - possible bug

2007-09-26 Thread Andreas J. Guelzow
. Is this the planned behavior? (Why?) If not, is this fixed in 1.7 or should I open a bug? You can open it from the full history Andreas -- Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http

Re: gnumeric: very unstable (unusable) for 64 bits

2007-08-10 Thread Andreas J. Guelzow
/gnumeric-list -- Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds

Re: UTF-8 problem (XLS)

2007-08-06 Thread Andreas J. Guelzow
/gnumeric-list -- Liberty consists less in acting according to one's own pleasure, than in not being subject to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds

Re: Re. Set Print Area in Gnumeric 1.6.3?

2007-08-05 Thread Andreas J. Guelzow
. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list

Re: Gnumeric 1.7.11 for Windows?

2007-08-02 Thread Andreas J. Guelzow
for me.) But to fix it you have to crash it first. I wouldn't even know where to find an MS Windows machine to check for such a crash. Andreas -- Andreas J. Guelzow, Professor Dept. of Mathematical Computing Sciences Concordia University College of Alberta

Re: gnumeric2LaTeX?

2007-07-12 Thread Andreas J. Guelzow
to the will and pleasure of other people. It consists also in our not subjecting the wills of other people to our own. Rousseau Andreas J. Guelzow Pyrenean Shepherds ___ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman

  1   2   >