Fai la tua domanda

andrewH's profile - attività

2018-10-05 02:11:46 +0200 received badge  Tassonomista
2017-06-04 21:20:03 +0200 received badge  Domande famose (source)
2016-12-11 01:05:00 +0200 received badge  Domanda notevole (source)
2016-10-21 10:24:54 +0200 received badge  Entusiasta
2016-10-20 20:49:46 +0200 received badge  Domanda gettonata (source)
2016-10-20 20:06:59 +0200 ha commentato una domanda Is there a better way of getting a web page into Writer than cut and paste?

@gabix Because if I save as "Webpage complete" i.e. including graphics, I get a folder with a bunch of things in it, not a single file. If Writer has a way of opening these webpage folder, I don't know what it is.Is there such a feature?

2016-10-20 09:16:39 +0200 ha posto una domanda Is there a better way of getting a web page into Writer than cut and paste?

Dear Folks-- I realize this makes me a neanderthal, but I do not absorb large blocks of text or complicated graphics well from the computer screen. I can deal with journalism, but when dealing with data or code I often resort to pasting pages into Writer and then printing them. the reason that I don't just print them directly is that most web pages are too lavish with white space to be sensible when reduced to print.

However, there are some problems that consistently arise when I do this. Graphics are often dramatically misplaced and hard or impossible to move. The underlying page structure, which is often a table of some kind, is sometimes tractable and sometimes intractable. Things like maps can usually be resized, but they often take up a whole page no matter how small you make them, and they usually appear to ignore, e.g. text wrapping.

Is there a better way of importing that produces a result that is easier to edit? Or is there a family of tricks to fix broken parts of web page imports that I could learn?

2014-10-20 23:26:58 +0200 received badge  Buona domanda (source)
2014-04-21 23:10:44 +0200 received badge  Domande famose (source)
2014-03-26 00:56:34 +0200 received badge  Domande famose (source)
2014-03-26 00:55:26 +0200 received badge  Studioso (source)
2014-03-26 00:54:10 +0200 received badge  Domande famose (source)
2014-03-22 23:34:19 +0200 received badge  Domanda notevole (source)
2014-03-22 13:11:05 +0200 received badge  Domanda gettonata (source)
2014-03-22 11:35:46 +0200 received badge  Domanda notevole (source)
2014-03-22 07:28:45 +0200 received badge  Domanda notevole (source)
2014-03-22 03:36:14 +0200 received badge  Domanda gettonata (source)
2014-03-22 01:57:20 +0200 ha commentato una domanda Formulas proced with drag handle does not display correct values.

I attached the file using the dialog box, and it rather oddly put the link at the very beginning of my post. See above.

2014-03-22 01:23:59 +0200 ha commentato una risposta Formulas proced with drag handle does not display correct values.

Given 2 columns with data newly typed, addition of columns by dragging a formula cell in the same problem sheet has the same result described above. Addition of cols in this way in a new worksheet in the same workbook also has the same result as above. Addition of cols in this way in a newly created spreadsheet works fine. In the newly created sheet in the original workbook, tracing either precedents or antecedents updates the values! & new formulas work! But existing ones formulas not updated.

2014-03-22 00:53:59 +0200 ha commentato una risposta Formulas proced with drag handle does not display correct values.

Unfortunately I do not remember if I right-justified the text after pasting, but there are no quotation marks in the cell, and the Numbers tab in the Format cells dialog box seems to claim that they are of format general. My Locale setting is Default - English (USA)

2014-03-22 00:37:52 +0200 received badge  Revisore (source)
2014-03-22 00:35:32 +0200 ha posto una domanda Does Base offer a straightforward way to impliment window functions?

Hi folks! I would like to use base to create and query some very large flat data files that I now have in .csv or tab-delimited format (mainly Census data and the like). One of the things that I would like to do with the data is to create a variety of summary statistics from various subsets of the data. I would like to do this in Base where possible to avoid problems with line limits (in Calc) or memory (in R).

I am almost completely new to databases except for using forms others have written to access pre-existing databases, but my understanding is that creation of the sort of summary statistics I am talking about can most easily be created via the use of window functions for those databases that support window functions. So, two related questions: 1. Does LibreOffice base support window functions? and if so: 2. Is there a good how-to guide or tutorial on using such functions via Base that you would recommend for someone new to Base, and indeed, almost new to databases?

Help and guidance very much appreciated. I am using LibreOffice 4.2.1.1 under Windows 7 64-bit with Service Pack 1.

Warmest regards, andrewH

2014-03-22 00:13:37 +0200 ha posto una domanda How similar or different are the Base implimentations under LibreOffice vs OpenOffice?

Dear folks -- I have recently switched from Microsoft Office to LibreOffice. I am pleased to say that so far that switch has been quite painless. For all the areas where I have made extensive use of the Microsoft Office components -- basically Word, Excel, and Powerpoint ( I have previously switched all my Outlook functions over to Google) the equivalent LibreOffice program has been comparably powerful and easier to use. Bravo!

However, I now find myself in need of a way to create and use a database. I have made almost no use of databases previously (except using other people's databases through interfaces that other people have written) and I have already established that I have a lot to learn. I need a database primarily because I am dealing with files (from the U.S. Census & Bureau of Labor Statistics) that are bigger than Calc will open. Ultimately I will be doing this analysis in some mix of Calc and R, but in both cases I would like to do as much preprocessing via database as possible to avoid line limits (in Calc) and memory limits (in R). I will not be doing anything particularly complicated -- mainly loading .csv OR tab-delimited flat files and then pulling out rows and columns, with perhaps some substitutions, mathematical or logical operations, and maybe calculating summary statistics on some subsets (e.g. on records by state or by racial category).

This brings me to my question: Is Base in OpenOffice pretty much the same as Base in OfficeLibre at the level of sophistication and complexity that I am talking about? Because I am finding a lot more beginner's guides, video tutorials, and and blogs and such that explain how to do particular basic tasks using OpenOffice than LibreOffice. I assume that this is just because they have been around longer, but I would like to know if I can trust these learning materials in most basic (no pun intended) cases for guidance on OfficeLibre Base. Can I? And if I can, are there good beginner's materials I can refer to that would help me in the cases where they are different?

Any help and guidance I can get would be much appreciated. I am using LibreOffice 4.2.1.1 under Windows 7 64-bit with Service Pack 1.

Warmest regards, andrewH

2014-03-09 19:57:35 +0200 received badge  Domanda gettonata (source)
2014-03-08 10:31:37 +0200 received badge  Studente (source)
2014-03-08 06:56:59 +0200 ha commentato una domanda Formulas proced with drag handle does not display correct values.

Nope, karma is still 1. This sort of discourages new posters from putting up information that may be necessary to allow others to answer their question, no?

2014-03-08 06:54:45 +0200 ha posto una domanda Formulas proced with drag handle does not display correct values.

Oakland Emp & Unemp.odsDear Folks-- I have a Calc worksheet with simple columns of numbers representing employment and unemployment numbers and rates. These numbers were copied as individual columns from Excel spreadsheets downloaded from the U.S. Bureau of Labor Statistics. They did not bring any formatting or formulas with them that I can identify by looking in the cells - just numbers. I am trying to take the difference of several pairs of these columns. I write out the difference in a cell in the usual way, e.g. "=M12-G12" (without the quotation marks) at the top of a column. I then grab the cell handle and pull it down to the bottom of the column. This fills the column with copies of the formula that differ in having the current row number in place of the original row number from the first entry in the column, as I expected. However, all of these formulas evaluate to the same number - the number in the original cell. This number is incorrect for all of the numbers but the original, and does not match the result of calculating the formula in the cell.

I have tried the following things which do not work: Saving the file, closing it, and reopening it; Cutting the column and pasting it back in the same place; Cutting the column and pasting it back in the same place as formulas only; Cutting one of the copied columns and pasting it back as numbers only; Dragging from the bottom instead of the top; Dragging to the right or left instead of vertically (again the formulas are correct but the number remains the value of the original cell); Cutting the entire spreadsheet and pasting it into a different sheet; Dragging the handle while holding down the Ctrl or Shift key; Entering the formula in a different column; Summing the numbers in two of these results columns sums the numbers displayed, not the correct results from the formula; Placing the cursor at the end of the formula in the cell and hitting return; Placing the cursor at the end of the formula in the formula bar window, or whatever it is called, and hitting return.

If I place the cursor in the formula bar, make some change in the formula, such as deleting the final "2" in the example I provided above, and then type the 2 back in ... (more)