Re: [libreoffice-users] Custom Bitmap for Chart Wall?

2013-02-09 Thread Regina Henschel
Hi Jonathan, Jonathan Levi schrieb: I'd like to fill the wall of my chart with a custom bitmap of my own creation. But when I double-click my chart, then click menu Format Chart Wall... Area tab Bitmap popup item Blank pattern, I can't edit this pattern, even though LibreOffice Help entry

Re: [libreoffice-users] Custom Bitmap for Chart Wall?

2013-02-09 Thread Regina Henschel
Hi Jonathan, Jonathan Levi schrieb: Brian and Regina, Thank you both for your responses. Both methods worked (Regina's had the advantage of not needing a new document) but both also produced an unexpected (and undesired) blurring of the boundary between two colors: Any further suggestions

Re: [libreoffice-users] [Writer] Current page value?

2013-02-10 Thread Regina Henschel
Hi Jean-Francois, Jean-Francois Nifenecker schrieb: Hello Tom, Le 10/02/2013 16:35, Tom Davies a écrit : how do other people normally do this? It's possible to have 1st page different isn't it? Is there a way of having last page different too? Does everyone do this by having at least 3

Re: [libreoffice-users] Custom Bitmap for Chart Wall?

2013-02-10 Thread Regina Henschel
Hi Jonathan, Regina Henschel schrieb: Hi Jonathan, Jonathan Levi schrieb: Brian and Regina, Thank you both for your responses. Both methods worked (Regina's had the advantage of not needing a new document) but both also produced an unexpected (and undesired) blurring of the boundary between

Re: [libreoffice-users] Libre office version 3.4.4 Calc Using excel 2007 formula SUMIFS??

2013-02-27 Thread Regina Henschel
Hi Daniel, dangilf schrieb: Hi, I've got a calc spreadsheet, and I'm trying to sum data based on three different criteria (data to sum in column J, criteria in columns A, H K. I'm trying to work out the syntax for using the sumproduct function to be able to do this, but I keep getting results

Re: [libreoffice-users] Calc - Keyboard shortcut to go to the first cell of the current column

2013-02-28 Thread Regina Henschel
pierre masci schrieb: Hello, with Home i can move to the start of the current row. How can i do the same thing with a column? Even if i need to use several Shortcuts to achieve it, it wouldn't be a problem: i could always record the series of shortcut as a new Macro, and make a custom keyboard

Re: [libreoffice-users] definition of flat/relational database

2013-03-03 Thread Regina Henschel
Hi John, John R. Sowden schrieb: Why do the Libreoffice powers that be define dbase/xbase as a flat file database, not a relational database. The below definitions from the Base Intro documentation demonstrate what I am saying: Do you have a direct link? *Flat databases* A flat database

Re: [libreoffice-users] No margins by default in ver.4

2013-03-20 Thread Regina Henschel
Hi Jeff, Jeff Shrowder schrieb: Just upgraded from 3.5.2 to 4.0.1 and I'm still finding my way around. (This is only the first of my queries; the others will each get separate posts.) It seems that by default there are no longer any grey margins on either a new page or an existing document.

Re: [libreoffice-users] [Calc] How to work with long formulas?

2013-03-22 Thread Regina Henschel
Hi Miroslaw, Mirosław Zalewski schrieb: Hi Some time ago I had to write a function that will display filename of current Calc workbook. After some Googling and trial and error I came up with this monster: =RIGHT(MID(CELL(FILENAME;A1);2;

Re: [libreoffice-users] Text Outlining

2013-03-22 Thread Regina Henschel
Hi Dave, Dave Liesse schrieb: One of the writers in the Windows Secrets newsletter recently compared OO and LO to MS Office, and I have to agree with him when he implied the LO web site is somewhat disorganized and confusing. Thus, this posting that is probably an enhancement request, but I

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread Regina Henschel
Hi ???, miltus_31 schrieb: Hello, I want to number the pages in an document. I know it can be achieved by 1. inserting default footer 2. then inserting page number field. But in this case by default the page numbers come in english. Is there any way to give the page numbers in any language ?

Re: [libreoffice-users] Page numbers in language other than english

2013-03-25 Thread Regina Henschel
Hi miltus, miltus31 schrieb: On Mon, 2013-03-25 at 15:52 +0100, Regina Henschel wrote: Hi ???, You can say miltus. Use Format Page and there the tab Page. There is a drop-down list Format in section Layout settings. From that list use the item Native Numbering. I'm using LibreOffice

Re: [libreoffice-users] Summing a cell value by a backgroud color cell style

2013-03-26 Thread Regina Henschel
Hi Kruno, Krunoslav Šebetić schrieb: Hello, I need to make a Calc table. Table is structured verticly. Tables sums number values from collums in the last row of table. Every collum stands for itself, and has nothing do do with oder collums. But values are enterd in collum by different

Re: [libreoffice-users] Re: question with selective sums

2013-03-26 Thread Regina Henschel
Hi Dries, that can by a task for the pivot table. The column, which should be sum up, goes into the data field in the middle and the item by which it is grouped goes into the row fields. In the More section you can determine, where the resulting table is written. With a double click on the

Re: [libreoffice-users]

2013-03-27 Thread Regina Henschel
Hi David, david_lynch schrieb: The formatting in my previous message was mangled. I have reformatted using | for column separator and _ for null character. I can't seem to get Calc to recognise column labels in array formulas. In addition, it seems to behave differently depending on whether

Re: [libreoffice-users] booklet printing problem

2013-03-28 Thread Regina Henschel
Hi Jeff, Jeff Shrowder schrieb: Another problem I have with LO (ver. 4.0.1.2) is that when I try to print a booklet - let's say a 4 page A5 booklet - on A4 it prints pages 1 and 4 in landscape across the portrait-oriented A4 page rather than along it. Pages 2 and 3 are similarly affected. The

Re: [libreoffice-users] brochure printing

2013-04-01 Thread Regina Henschel
Hi Paul, Paul van Tooren schrieb: Dear Regina, I have read your comments on the request of Jeff Shrowder of 28-3-2013. Printing a brochure on a duplex-printer is even more simpler as you wrote. 1.Set the document on A4-format Then you need to enlarge all things by factor √2, because it

Re: [libreoffice-users] Impress Styles and Formats Are Inconsistent

2013-04-03 Thread Regina Henschel
Hi dlt101, dlt101 schrieb: 1. When editing an existing presentation, I notice that some of the text boxes use Presentation styles and others use Graphics styles. Why? That are different kind of objects. Presentation objects are bound to the master. So changing the master will change the

Re: [libreoffice-users] Re: Impress Styles and Formats Are Inconsistent

2013-04-03 Thread Regina Henschel
Hi David, dlt101 schrieb: Regina --- thanks for your extended reply. In regard to #1, the idea that Presentation objects are tied to the master and Graphics objects are everything else really helps. Frankly, I've never seen that in print before. As for #3, please see attached upload. ~David

Re: [libreoffice-users] API characters

2013-04-17 Thread Regina Henschel
Hi Alain, Alain Carrière schrieb: Hello to all! I am looking in LO characters menu to see if I can find the IPA (international phonetic alphabet) and can't find anything. Is there a way to download it somewhere? I use a french keyboard and would like to type those characters directly (for

Re: [libreoffice-users] Paragraph styles

2013-05-01 Thread Regina Henschel
Hi Dave, Dave Liesse schrieb: As an end user, I'd like to ask one follow-up question to your third point. This is an I don't understand type of question, by the way, not a challenge. Are you implying that if I want to, say, indent one paragraph with no other changes, I should create a new

Re: [libreoffice-users] Re: Check Box size in LO Base

2013-05-02 Thread Regina Henschel
Hi Alexander, Alexander Thurgood schrieb: Le 30/04/13 12:43, Ian Whitfield a écrit : Hi Ian, Is there a way of adjusting the size at all? I'll try and find out on the dev list where the code responsible for this might be (or might not be). AFAIK, the checkbox is not self-drawn, but it

Re: [libreoffice-users] Re: Integer degrees in Draw

2013-05-03 Thread Regina Henschel
Hi all, it is bug https://bugs.freedesktop.org/show_bug.cgi?id=60120 kind regards Regina Dan Lewis schrieb: On 05/03/2013 08:56 AM, Alexander Thurgood wrote: Le 03/05/13 13:14, Dan Lewis a écrit : It is a feature that has been introduced in 4.0. 3.6.6 permits you to set the degree

Re: [libreoffice-users] Re: Integer degrees in Draw

2013-05-03 Thread Regina Henschel
Hi, Dan Lewis schrieb: On 05/03/2013 08:56 AM, Alexander Thurgood wrote: Le 03/05/13 13:14, Dan Lewis a écrit : It is a feature that has been introduced in 4.0. 3.6.6 permits you to set the degree angle for a line to 100th of a degree (English system). 4.0.2 and 4.0.3 both limit the

Re: [libreoffice-users] Mail merge's record number field

2013-05-06 Thread Regina Henschel
Hi Leroy, LeroyTennison schrieb: Has anyone gotten this field to return anything? Yes, but not in LibreOffice. The last version which works for me is a OpenOffice.org2.4.3. It is already broken in OOo3.4.1. It should show a counting number of the records. Kind regards Regina -- To

Re: [libreoffice-users] Compatibility LO/MSO

2013-05-06 Thread Regina Henschel
Hi Milos, Milos Sramek schrieb: Hi, I observe that LibreOffice and MS Office display even simple documents, containing just a few paragraphs with numbered and bulleted lists, differently. These differences are from both sides: a document is created in LO, stored in odf and opened in MSO (2013)

Re: [libreoffice-users] Compatibility LO/MSO

2013-05-07 Thread Regina Henschel
Hi Milos, Milos Sramek schrieb: Hi, thank you all for your answers. In fact I take part in a larger scale testing of interoperability of formats, since open source software is currently considered by Slovak administration as and alternative to the standard MS stuff. Then you might be

Re: [libreoffice-users] Compatibility LO/MSO

2013-05-07 Thread Regina Henschel
Hi Milos, Milos Sramek schrieb: [..] ODF 1.1 and OOXML transitional were used, the used fonts were available on both computers. Line spacing does not seem to be a big issue, but one can see inconsistent line spacing nearly everywhere. So, from the point of view of interoperability it is

Re: [libreoffice-users] java macro

2013-05-09 Thread Regina Henschel
Hi Vieri, Vieri schrieb: Hi, I'm new to making Java macros. I compiled my Java class, created the parcel-descriptor.xml file and placed the .xml, .jar and .class files within the following folders I also created: C:\Users\USERNAME\AppData\Roaming\LibreOffice\4\user\Scripts\java\MACRO1

Re: [libreoffice-users] java macro

2013-05-09 Thread Regina Henschel
Hi Vieri, Vieri schrieb: I didn't need to use BeanShell. I edited the parcel descriptor xml file directly. I finally found out why I wasn't seeing the macro (or at least I think so). I needed to create my class within default package (I'm using NetBeans IDE). I'm able to launch my Java

Re: [libreoffice-users] Math custom function name

2013-05-12 Thread Regina Henschel
Hi, Alaak schrieb: Hi, I know there is a command, similar to Latex \operatorname{}, to include custom operators/functions in libreoffce math formulas. oper Or do you want to add a symbol to the catalog? Unfortunately writer changes this command if used to Sum, so all my custom functions

Re: [libreoffice-users] How to center a pasted drawing?

2013-05-12 Thread Regina Henschel
Hi William, William Drago schrieb: All, When I paste a drawing into writer there are no options for centering it left-right on the page. Surely there must be a better way to do this than dragging it around until it looks centered. Can anyone tell me how? Use the PositionSize dialog from its

Re: [libreoffice-users] Why such large svg files in LibreOffice (Linux)?

2013-05-22 Thread Regina Henschel
Hi, chimak111 schrieb: I installed LibreOffice Version 4.0.2.2 (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3) direct from http://www.libreoffice.org/download/ on Lubuntu 13.04. While I have no issues with it [I]per se[/I], I think it has installed some svg files in

Re: [libreoffice-users] Re: How to extract a color from a text?

2013-05-29 Thread Regina Henschel
Brian Barker schrieb: At 06:19 29/05/2013 -0400, Dan Lewis wrote: On 05/29/2013 12:36 AM, Axel Braun wrote: Yes, that works for colors that are known to the system, not for custom colors (like in imported documents) Try this: Open the Styles and Formatting window (use the F11 key to do

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Regina Henschel
Hi, Tanstaafl schrieb: Hi all, Ok, I'm at my wits end. We have a Canon Imagerunner iR-ADV C5030/5035 UFR II. It has 4 paper trays: 2 for Letter (different orientations), one for Legal, and one for Tabloid. Microsoft office works fine under the following circumstances, but Libreoffice is

Re: [libreoffice-users] Strange Page Setup/Printing Problem

2013-05-30 Thread Regina Henschel
Hi, I have searched AOO Bugzilla and found this one https://issues.apache.org/ooo/show_bug.cgi?id=112863 It seems to be indeed a problem with sign tabloid. Kind regards Regina Tanstaafl schrieb: On 2013-05-30 10:43 AM, Regina Henschel rb.hensc...@t-online.de wrote: If I change the paper

Re: [libreoffice-users] Floating frames

2013-06-10 Thread Regina Henschel
Hi Malcom, the floating frame is a remainder from StarOffice5.2. It is defined in ODF, but I do not know any OOo, AOO or LO version, where it works. The (old) help text says, that it is intended to display foreign webpages in HTML-documents, but in Writer/Web floating frames are disabled in

Re: [libreoffice-users] LO Calv - Vertical Split

2013-06-17 Thread Regina Henschel
Hi Ian, Ian Whitfield schrieb: Hi All I have LO 3.6.5.2 on PCLOS 2013 Is it possible to do the following in Calc?? I have two list of names (and other data) side-by-side in a Spreadsheet and I want to Split the Spreadsheet vertically to show the LH part on the left and the RH part on the

Re: [libreoffice-users] [LO Calc] Chart with continuous discontinuous series of data

2013-06-18 Thread Regina Henschel
Hi Gordom, gordom schrieb: Hi, I have another problem with my charts in Calc. I need to present a series of data using column and line chart. Here you have a simplified set of data. DateABC 2012/10/120,8-247,9 2012/10/130,6-248,9 2012/10/140-248,7

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-23 Thread Regina Henschel
Hi Paul, Paul schrieb: Bump? Or is this the wrong mailing list to ask such questions on? It is the right mailing list. But sometimes an email slipped through. I cannot reproduce the problem with LibreOffice 4.1. Please try it with the LO4.1 beta. If you see the problem there too, it

Re: [libreoffice-users] Error in Calc custom formats between closing and opening a file

2013-06-23 Thread Regina Henschel
Hi Paul, Paul schrieb: Hi Regina, Thanks for your response. If I install the 4.1 beta, will it install side by side with the existing stable, or replace it? If it replaces it, can I revert to stable easily? Do I just re-install with the stable download? It will not install side-by-side but

Re: [libreoffice-users] Need header outside right margin

2013-06-26 Thread Regina Henschel
Hi William, William Drago schrieb: All, I am working on a research paper. The required page layout puts last name, working title, and page number in the upper right hand corner of each page, outside the right hand margin. It is similar to what is shown here, but has to appear on every page,

Re: [libreoffice-users] missing features

2013-06-29 Thread Regina Henschel
Hi Patrick, Patrick Dreier schrieb: Hello! Can you adding a financial software in the Libreoffice. With king regards! financial software is very vague. There exists a lot of financial functions in Calc. Can you please describe in detail what you are looking for? Kind regards Regina

Re: [libreoffice-users] Default font and size

2013-07-02 Thread Regina Henschel
Hi John, John R. Sowden schrieb: On 07/02/2013 01:56 PM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from the first menu, I

Re: [libreoffice-users] Default font and size

2013-07-02 Thread Regina Henschel
Hi Brian, Brian Barker schrieb: At 13:13 02/07/2013 -0700, John R. Sowden wrote: I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from the first menu, I get a font called 'arial' (sounds

Re: [libreoffice-users] Book-writing with Writer

2013-07-12 Thread Regina Henschel
Hi Wolfgang, Wolfgang Keller schrieb: I don't believe I've heard of structure markup style concept and I'm not sure I understand what you mean. I used WordPerfect for years and could never quite get the hang of WP's styles, all the while I took to Word's and OO's (now LO's) styles quite easily.

Re: [libreoffice-users] HTML Source

2013-07-14 Thread Regina Henschel
Hi Andrew, Andrew schrieb: This link: https://help.libreoffice.org/Common/HTML_Source says: Displays the source text of the current HTML document. To view the HTML source of a new document, you must first save the new document as an HTML document. Choose View - HTML Source Open context menu

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Regina Henschel
Hi Jean, Jean Milot schrieb: Hello, I search to use some tables from Access so i want to copy all data in base ( i don't want to connect to the access db). How i can add data without create a primary key ? Why do you want to avoid using a primary key? Do you know the database tutorial? See

Re: [libreoffice-users] BASE : How add data without primary key

2013-07-15 Thread Regina Henschel
Hi Jean, Jean Milot schrieb: Hi, I want save my time. Setting the primary key on table import is 1 click. Avoiding it does not save time, but produces trouble. I don't want modify all the tables. ?? I thought you want to write data? I have a mdb file, so i need already to create all

Re: [libreoffice-users] Re: Some content in ODP slide appears only in slide show view of Impress, not in normal view or PDF output

2013-07-19 Thread Regina Henschel
Hi vi5u0, vi5u0 schrieb: Tom wrote Hi :) Sorry you haven't received many replies to this yet! You could upload the files to Nabble so that people can see them and see the problem. It's not as tough as it sounds! Just use the links in this email or navigate to the right thread through the

Re: [libreoffice-users] Draw printing of large plans

2013-07-24 Thread Regina Henschel
Hi, Kracked_P_P---webmaster schrieb: On 07/24/2013 08:47 AM, Regina Henschel wrote: Hi John, John R. Sowden schrieb: 4) Can I print multiple parts of the drawing onto 8.5 x 11.0 paper, then tape them together for a preliminary draft? (I know I can do the taping part, its the printing

Re: [libreoffice-users] Re: Customizing Number Format of each level in Writer-Tools-Outline Numbering

2013-07-25 Thread Regina Henschel
Hi Sina Sina Momken schrieb: Let me show you what exact Outline Numbering I want using the example below: Level Example(desired output) Associated Paragraph Style 1Chapter 3: Chapter 2 3.2- Heading 1 3 3.2.5- Heading 2 4

Re: [libreoffice-users] Re: Customizing Number Format of each level in Writer-Tools-Outline Numbering

2013-07-26 Thread Regina Henschel
Hi Sina, Sina Momken schrieb: On 07/25/2013 04:29 PM, Regina Henschel wrote: Hi Sina [..] You do the outline numbering with Chapter, Heading 1 , ... with normal outline numbering. You need to define a paragraph style Chapter and alter the assignment between paragraph style and level

Re: [libreoffice-users] Re: Customizing Number Format of each level in Writer-Tools-Outline Numbering

2013-07-28 Thread Regina Henschel
Hi Sina, Sina Momken schrieb: On 07/26/2013 04:29 PM, Regina Henschel wrote: [..] Here a way to get a caption without using the wizard: When you insert the picture, it is anchored to an empty paragraph as default. Open the paragraph properties of this paragraph and enable option Keep

Re: [libreoffice-users] writer - basic - texttable: how to get out of the table

2013-08-08 Thread Regina Henschel
Hi Alain, Alain Van Utterbeeck schrieb: Hello, I'm writing a macro and have a problem: in my macro I insert a table in my document: args4(0).Name = TableName args4(0).Value = Tabel1 args4(1).Name = Columns

Re: [libreoffice-users] Charts with lots of data in Calc

2013-08-08 Thread Regina Henschel
Hi Sebastián, Sebastián Dietrich schrieb: I'm making some x-y chart in Calc with a lot of data. In this moment, i have some with more than 25,000 data points. Your screen has likely not more than 2000 dots width. Are you sure you need 25000 data points? It seems like Calc cannot manage

[libreoffice-users] Installing 4.1 on OpenSuse

2013-08-09 Thread Regina Henschel
Hi all, I make my first steps in using Linux and have got a OpenSuse 12.3 on my old Notebook. Now I try to install LO4.1. I have download the archive, unpacked it and followed the instructions in its readme. I can get the single modules from the application launcher, but there remain two

Re: [libreoffice-users] Re: How to change direction of Outline Numbering to RTL in LO Writer?

2013-08-09 Thread Regina Henschel
Hi Sina, Sina Momken schrieb: Let me make long story, short: I want to know is there any method to make numbering of sub-chapter 1 of chapter 3 shown as ‮۳-۱-‬ instead of ‫۳.۱-‬ in file below???

Re: [libreoffice-users] Installing 4.1 on OpenSuse

2013-08-11 Thread Regina Henschel
Hi all, thank you all for your assistance. I've learned a lot about work-flow under Linux and find it rather different from what I'm used to do under Windows. I need Linux mainly for testing ODF interoperability problems. Such is possible now. If I get further problems, I know you will help

Re: [libreoffice-users] [3.5.3.2/Writer] Split screen in half horizontally?

2012-06-24 Thread Regina Henschel
Hi Gilles, Gilles schrieb: Hello I'm working on a long document in Writer, and need to split the screen in half so I can navigate in different parts of the document. Someone already asked this in February 2012, and it seems like this feature was not implemented yet:

Re: [libreoffice-users] [3.5.3.2/Writer] F3 to jump to next occurence?

2012-06-24 Thread Regina Henschel
Hi Gilles, Gilles schrieb: Hello I google for this, but didn't find if LO supports a keyboard shortcut for the Find feature to jump to the next occurence. Next occurrence of what? It doesn't seem to implement Windows' standard F3 key. There only very few keys and key-combinations, which

Re: [libreoffice-users] Re: Bar charts with user-defined x-axis

2012-06-25 Thread Regina Henschel
Hi prino, prino schrieb: Thank you, this works! It shows every third year as label (1980/1983/1986...) Is there a way to show only every n-th year? For this chart n=5 would be my choice. Set chart in edit mode. Format Axis x-Axis Dialog page Scale. Set Type to 'Date'. Then you get

Re: [libreoffice-users] compiler libreoffice error

2012-06-28 Thread Regina Henschel
Hi, apple schrieb: hi,everyone! Linux-pc the compiler libreoffice source, the following problems, how to solve? Thank you! This is the wrong list for your question. Please write to the developer list libreoff...@lists.freedesktop.org or use the #libreoffice-dev channel at

Re: [libreoffice-users] LOW: uncontrollable line spacing in PDF output???

2012-07-03 Thread Regina Henschel
Hi Rogier, Rogier F. van Vlissingen schrieb: Back in 2002 I produced a book, going straight to print off a Open Office PDF, and the results were thoroughly satisfactory. In fact, my book at that time was probably the first production book that was fully produced straight from OO, skipping DTP

Re: [libreoffice-users] Search and Replace question

2012-07-03 Thread Regina Henschel
Hi Mark, mickelsen schrieb: Is there a way to specify the beginning-of-line a part of the search-for string in a search and replace operation? I guess you can get what you want using regular expressions. Look in the help for a list of them. Kind regards Regina -- For unsubscribe

Re: [libreoffice-users] Callout 2 - modification of line start point

2012-07-03 Thread Regina Henschel
Hi Ian, Ian McCarthy schrieb: I have placed several callout2 objects around a picture to illustrate various points. I can adjust the remote end of the line and the mid point, using the little hand which appears and doing click and drag, I also wish to change where on the callout box the start

Re: [libreoffice-users] Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-05 Thread Regina Henschel
Hi, Pastel Painter schrieb: When I print my documents, they are printing about 1/8 of the original (letter) size, and are being rotated to landscape mode. When I check the document in print preview, the document looks like I expect it to - taking up the full page, etc. I have no idea as to why

Re: [libreoffice-users] a little math problem with Calc

2012-07-05 Thread Regina Henschel
Hi, alex sato schrieb: Hi, I have a problem with functions I made. Let's say I create the function: Function Test (n) dim r(3) r(0)=int(n) r(1)=n-r(0) r(2)=r(1)*100 r(3)=int(r(2)) Test = r End Function Then, in a empty spreadsheet take the following steps: -select A1:D1 -press [F2] -Insert

Re: [libreoffice-users] a little math problem with Calc

2012-07-06 Thread Regina Henschel
Hi Alex, alex sato schrieb: Regina, thanks for your answer. But can you tell me how to call Calc functions inside the macro? I searched in docs and in the Google and don't found any clue. It is done with the service FunctionAccess, see

Re: [libreoffice-users] Re: Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-06 Thread Regina Henschel
Hi, Pastel Painter schrieb: Thanks for responding to my question. I have been using LibreOffice for quite a while and have just recently encountered this problem. I was wondering if it was because of operating system updates. I am using Ubuntu Linux, Libre Office 3.5.3.2. The ruler is on in

Re: [libreoffice-users] Re: Libre Office printing documents 1/8 of original size and in landscape mode - Help

2012-07-06 Thread Regina Henschel
Hi, Pastel Painter schrieb: I also tested a document that I downloaded - a newsletter - created by someone else. It printed to the correct size. It appears that just my LibreOffice documents are affected. Do you follow the guide Setting up Printer and Fax Under UNIX Based Platforms from the

Re: [libreoffice-users] Outline woes

2012-07-09 Thread Regina Henschel
Hi, Rahn Land schrieb: Hi, I am trying to create a report document template with a basic outline using styles so that the headings and formatting are automatic: I. A. i. a) I am finding this incredibly difficult and confusing. The further I try to teach myself how it

Re: [libreoffice-users] Re: Outline woes

2012-07-09 Thread Regina Henschel
Hi, Rahn Land schrieb: I think I want to number headings by manipulating styles, but I am not sure. I don't understand the distinctions between the three. I want an outline system that uses styles, so that I can easily change or modify the format of multiple headings at once. I want it

Re: [libreoffice-users] Quickstarter is missing from LO3.5.5. on Debian

2012-07-12 Thread Regina Henschel
Hi, AG schrieb: Hi list As the subject line says really - there is no option to activate the quick starter for LO3.5.5 using Debian squeeze. I downloaded and installed the LO3.5.5 today (after removing the previous version, which also did not have a quick start option), and find again that

Re: [libreoffice-users] No help in LO

2012-07-13 Thread Regina Henschel
Hi Graham, Graham Luffrum schrieb: Hi I have installed LO 3.5.5 under Windows 7 together with the English UK help files in the order specified. However when I try to access help in LO instead of getting the built-in help I get directed to the website

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Regina Henschel
Hi Andrew, Andrew Douglas Pitonyak schrieb: I wrote a simple function Function mydate As Date mydate = CDate(100) End Function I then called this function from a Calc document =myDate() Finally, I directly accessed the cells with the dates from a macro similar to the following code:

Re: [libreoffice-users] Unexpected behavior while writing Calc Functions

2012-07-16 Thread Regina Henschel
Hi Tom, Tom Davies schrieb: Hi :) I am pretty sure that Date is an Sql data-type, just like double or text but perhaps it got tweaked-off somewhere in the embedded HsqlDb? This is not about HSQL but about Basic. Andrew is almost never wrong and Regina is never wrong so i'm at a loss about

Re: [libreoffice-users] Re: Function in OSX with Calc 3.5.5

2012-07-19 Thread Regina Henschel
digisan schrieb: Steve, I was using 3.4 and installed 3.5.5. Here is a portion of the screen shot. Does anyone know where to download 3.4, it looks like it is no longer available on the website. http://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png You

Re: [libreoffice-users] Chart Office compatibility issue

2012-07-20 Thread Regina Henschel
Hi, davews schrieb: I have received an xls spreadsheet created in Office which contains charts. But the charts appear blank - there are bars/columns on sheet 2 and graphs/lines on sheet 3. You can find the spreadsheet http://www.btinternet.com/~dsergeant/cadismay.xls here (because of the

Re: [libreoffice-users] Which template categories are built-in, how to name custom ones?

2012-07-22 Thread Regina Henschel
Hi Friedrich, Friedrich W. H. Kossebau schrieb: Hi, Am Dienstag, 10. Juli 2012, 09:04:54 schrieb Friedrich W. H. Kossebau: I need help with understanding how the naming of the template categories is done, especially for custom categories. I have basically 2 questions, listed at the end. I

Re: [libreoffice-users] Re: Chart Office compatibility issue

2012-07-22 Thread Regina Henschel
Hi, davews schrieb: Regina Henschel wrote Hi, davews schrieb: I have received an xls spreadsheet created in Office which contains charts. But the charts appear blank - there are bars/columns on sheet 2 and graphs/lines on sheet 3. You can find the spreadsheet http://www.btinternet.com

Re: [libreoffice-users] Re: Chart Office compatibility issue

2012-07-22 Thread Regina Henschel
Hi Andreas, Andreas Säger schrieb: Am 22.07.2012 18:10, Regina Henschel wrote: A first step might be to add a request to LO bugzilla. But I personally liked more, when named ranges would be possible. Kind regards Regina Named ranges are named formula expressions. Formula expressions

Re: [libreoffice-users] Where are my custom labels?

2012-07-24 Thread Regina Henschel
Hi Jerry, Libre User schrieb: I have recently upgraded to LibreOffice 3.6.4 and can't find my custom labels. Using the LO 3.2 family I have been creating labels for museum exhibits. From a museum supplied spreadsheet with the necessary fields, I used an LO Base query sheet and then used

Re: [libreoffice-users] Does this file crash with the latest 3.6 beta?

2012-07-26 Thread Regina Henschel
Hi Andreas, Andreas Säger schrieb: Hi, The simple spreadsheet document http://www.mediafire.com/view/?1s1wui59p3p2oxz crashes with LO-Dev Beta 1 (Build ID: 1f1cdd8). I know there is a more recent build of 3.6 but 3.5 will be my last version of LibreOffice. If someone confirms the crash with a

Re: [libreoffice-users] inserting (exactly) a line before a paragraph using styles

2012-08-02 Thread Regina Henschel
Hi Rob, rob wood schrieb: Hi, Firstly, thanks for all the replies about my blank page question. That is all working nicely, however, I am now stuck trying to get writer to insert a blank line before a paragraph. It is important it is *exactly* a line as otherwise the baseline of the text on

Re: [libreoffice-users] inserting (exactly) a line before a paragraph using styles

2012-08-02 Thread Regina Henschel
Hi Rob, rob wood schrieb: This isn't quite the same, I don't want the capital to go down into the other lines (a drop cap) I want it to have the same baseline as the rest of the text like this (if you're viewing this in html mode): The first letter is bigger than the rest... This is the

Re: [libreoffice-users] Tooltip background is half transparent

2012-08-14 Thread Regina Henschel
Hi, linuxissue schrieb: I have a problem about tooltip in LibreOffice - its background is half black and half transparent with white words on it: https://bugs.freedesktop.org/attachment.cgi?id=65488 Screenshot . It makes me difficult to see the description. I have already filed this bug on

Re: [libreoffice-users] calc - message in cell

2012-09-09 Thread Regina Henschel
Hi, IGraham schrieb: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help Go to

Re: [libreoffice-users] calc

2012-09-12 Thread Regina Henschel
Hi Magnus, a a schrieb: Hey, When i am creating a diagram i can change the numeric values of the y-axel, but when i try the same procedure for the x-axel, the template with options stay grey and imposible to change. How can i do to make this grey area black again so i can change the numeric

Re: [libreoffice-users] Draw object selection problem

2012-09-14 Thread Regina Henschel
Hi Girvin, Girvin R. Herr schrieb: Greetings, LO 3.5.3.2 on Linux. I am trying to edit a Jpeg picture in Draw by drawing objects on top of the picture. However, I am having a problem selecting my objects. Draw keeps selecting the larger underlaying picture instead of the object I want it to

Re: [libreoffice-users] Multiply values BEFORE summing

2012-09-27 Thread Regina Henschel
Hi Vytas, Vytas schrieb: Hi, I have about 2453 records for which I require to sum numerous columns ie. A * H, A* I , A*J The following equation will sum the values of each column [=SUM($H$2:$H$2453)]. Is there a way I can multiply the summation column by the corresponding column A

Re: [libreoffice-users] Re: Impress - Blink animation doesn't work

2012-09-28 Thread Regina Henschel
Hi Gordon, Gordon Burgess-Parker schrieb: On 26/09/12 15:57, Gordon Burgess-Parker wrote: LO 3.6.0.2 (Build ID: 360m1(Build:102)) None of the Repeat options work in the Blink animation. It blinks once and then stops. Any one got a fix? Anyone got any comments on this? Other effects do not

Re: [libreoffice-users] Re: Impress - Blink animation doesn't work

2012-09-28 Thread Regina Henschel
Hi, rost52 schrieb: Hi, I observe the same bug. Settings Entry: Appear on click Emphasis: Blink after previous 3 times Result All works but only 1 blink independed of the number of blinks set LO 3.5.6.2 XP SP3 Have not yet reported this bug It is said to be fixed with

Re: [libreoffice-users] Re: Impress - Blink animation doesn't work

2012-09-28 Thread Regina Henschel
Hi, rost52 schrieb: Hi, I observe the same bug. Settings Entry: Appear on click Emphasis: Blink after previous 3 times Result All works but only 1 blink independed of the number of blinks set LO 3.5.6.2 XP SP3 Have not yet reported this bug It is already there

Re: [libreoffice-users] Re: Impress - Blink animation doesn't work

2012-09-29 Thread Regina Henschel
Hi, Dr. R. O Stapf schrieb: On 2012-09-28 23:56, Regina Henschel wrote: [..] It is said to be fixed with https://bugs.freedesktop.org/show_bug.cgi?id=50833 but I have not tested it yet. Unfortunately it is still there. As the bug assitant does not work (at least not for me) I even can't

Re: [libreoffice-users] Opening a CSV file with Calc

2012-09-29 Thread Regina Henschel
Hi Jeff, Jeff Hahn schrieb: Thanks. Unfortunately the suggestions did not work. I am using Windows 7. The only way I have been able to open the file with LO is as a TXT file. When I try to open with Calc the text Import window comes up. Then you are using the wrong filter. Start Calc.

Re: [libreoffice-users] Color cursor (active cell) on calc

2012-10-11 Thread Regina Henschel
Hi Àngel, Àngel mompó schrieb: I am using Libreofice Calc version 3.6.2.2 I have a group of cells witha a black 1pt border so i find dificult to see at witch cell the cursor is. Is there any way to change the color and or other characteristics of the cursor? I don't know a way to change

Re: [libreoffice-users] --convert-to txt:Text *.odp

2012-10-19 Thread Regina Henschel
Hi Trever, Trever L. Adams schrieb: Hello Everyone, I am strugling with something. I need to dump the text out of presentation files (Impress, PowerPoint, anything that LibreOffice Impress can read). The problem, I can convert to pdf, but not text. Is there any reason why? After all, grabbing

Re: [libreoffice-users] LibreOffice Math: Export PDF- Control the output?

2012-10-23 Thread Regina Henschel
Hi Russ, russurquhart1 schrieb: Hi, I want to export an equation created in Math as a pdf file. When i use the Export PDF, i get the equations, but i also get the file name, the command i entered at the bottom of the page, and a border around the page. How can i NOT get those things to come

Re: [libreoffice-users] The Document Foundation announces LibreOffice 3.5.7

2012-10-29 Thread Regina Henschel
Hi, Guy Voets schrieb: 2012/10/18 Italo Vignoli italo.vign...@documentfoundation.org [..] It is nigh impossible to find a link to a place where the 3.5.7 can be downloaded. I also looked in the nl.libreoffice.org site... no dice! From the general download site

  1   2   3   4   5   6   7   >