[users] Re: [CALC] How to add a variable formula?

2010-04-15 Thread Andreas Saeger
Brian Barker wrote: At 20:27 13/04/2010 +0200, Michelle Konzack wrote: Now I have only to solve the sum(over) art which can only make the SUM of a range of ROWS (eg C5 to C999) which does not work if I insert new ROWS because the C999 is not updated to C1000. In fact, the formula will be

[users] Re: Hyperlinks

2010-04-12 Thread Andreas Saeger
Floyd Noel wrote: Can a column in a Base table be described as a hyperlink so that if I enter the location of an image on my computer in a cell in that column, clicking on that cell would bring up the image? FP Attach a picture control to a form and bind it to a text column. The text

[users] Re: Reports using parameter queries

2010-04-09 Thread Andreas Saeger
Floyd Noel wrote: How do I get a report to give current results after I've modified the parameters of it's query input? It is giving me results from the previous parameters in effect in the query. FP Yes, you can also use the old style reports dynamically. Bug and workaround:

[users] Re: [CALC] How to add a variabe formule?

2010-04-08 Thread Andreas Saeger
Michelle Konzack wrote: Hello Michael, Am 2010-04-04 22:05:05, hacktest Du folgendes herunter: Just clarifying, you want something like this? B2 =(C2+D2)*F2 B3 =(C3+D3)*F3 B4 =(C4+D4)*F4 B5 =(C5+D5)*F5 B6 =(C6+D6)*F6 B7 =(C7+D7)*F7 B8 =(C8+D8)*F8 Yes... If so, it can be achieved by

[users] Re: [CALC] How to add a variabe formule?

2010-04-04 Thread Andreas Saeger
Michelle Konzack wrote: Hello *, happy Easter-Egg-Searching... Happy Easter! I have a problem with inserting a formule in CALC which must look like: =(C{LINE}+D{LINE})*F{LINE} =$C1+$D1+$F1 and copy down the formula [Tutorial] Absolute, relative and mixed references:

[users] Re: Date Interpretation - Calc

2010-04-02 Thread Andreas Saeger
Harold Fuchs wrote: Thanks, Andreas. That works. I didn't realise that Fri Apr 30 is US English and *not* British English. Looks perfectly OK to this Brit. Well, as a German I think that the computer program interpretes these expressions as US dates simply because the month portion is

[users] Re: Date Interpretation - Calc

2010-04-01 Thread Andreas Saeger
Harold Fuchs wrote: OOo 3.1.1 on Win XP Pro. I have a column of dates in a text (.txt) file and want to copy them into a column of a Calc sheet. I can't because Calc insists on changing the values. The first few lines of the .txt file look like this: Fri Apr 30 Fri Apr 30 Sat May 1 Sat May 1

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread Andreas Saeger
PJH wrote: I'm going to post my feeble attempts at getting a line chart done in the hopes that (a) I will eventually be successful and (b) someone else will benefit from my flounderings. I have a spreadsheet with the following columns and data ranges: A: date B: odometer reading -- now up

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread Andreas Saeger
PJH wrote: OK, I want an x/y scatter chart with dates as the X-axis and several Y-axes. How do I do that? Thanks. Open the chart (double-click) and change the chart type. - To unsubscribe, e-mail:

[users] Re: Help needed

2010-03-15 Thread Andreas Saeger
Tanstaafl wrote: Cool... I'm looking forward to the day KDE is ready to run on Windows (laughing as James spills his $beverage all over his keyboard)... ;) http://kde.org/developerplatform/ The entire KDE Development Platform is built upon the Qt toolkit from Qt Development Frameworks, a

[users] Re: OO 3.2: mail merge does not work with numeric and date fields

2010-03-04 Thread Andreas Saeger
JSz. wrote: In OpenOffice 3.2: While performing mail merge from a Calc database with numeric or date fields, the values are NOT inserted into the merged document -- the fields are blank. Text values are prperly inserted. Is this an effect of a bug, or something else. The java is up to date:

[users] Re: Recommended Best Batch .odt to .doc Converter

2010-03-04 Thread Andreas Saeger
James Greenidge wrote: Greetings; I've come across several batch odt to doc converter macros, all very old and only do sxw and are cranky to get started. I'd like your recommendations on any that actually work. Thanks! Jim .. http://www.artofsolving.com/opensource/jodconverter

[users] Re: calc: statistical functions, ANOVA etc????

2010-03-03 Thread Andreas Saeger
Harold Fuchs wrote: On 3 March 2010 14:39, Uwe Brauer o...@mat.ucm.es wrote: Hello As I have been told MS Excel contains a lot of functions for statistical analysis, even ANOVA. I looked up oocalc can can't find anything similar. Can somebody please point out whether there are some Add-ons?

[users] Re: Very strange sorting error/brian

2010-03-02 Thread Andreas Saeger
Brian Barker wrote: At 08:08 01/03/2010 -0800, Brewster Gillett wrote: Brian Barker wrote: Mind you, ZIP data should probably all be text, in fact. That's an intriguing notion. Since ZIPs only ever consist of numbers, why would it be preferable to store them as text? So as to avoid

[users] Re: Very strange sorting error/brian

2010-03-01 Thread Andreas Saeger
Brewster Gillett wrote: Thank you for a very useful tip, which I may never have discovered otherwise. Sure enough, the ones that aren't included in the sort are showing as text. And, fool that I am, I should have seen it - every single one of them has a leading single quote - an artifact whose

[users] Re: Very strange sorting error/andreas

2010-03-01 Thread Andreas Saeger
Brewster Gillett wrote: On Mon, 2010-03-01 at 12:34 +0100, Andreas Saeger wrote: When you paste zip-codes from a decent application (database?) the clipboard data are marked as text and Calc will treat them as text in this particular case. Ah, it's about csv files again. Nice to hear

[users] Re: Very strange sorting error

2010-02-28 Thread Andreas Saeger
Brewster Gillett wrote: I have a list of names and addresses I maintain using OpenOfficeCalc. It does just fine - I don't need any database features. And you don't need any spreadsheet feature. What you need least is the flexibility of a spreadsheet where you can tear apart any list

[users] Re: Very strange sorting error

2010-02-28 Thread Andreas Saeger
Brewster Gillett wrote: That being the case, it would be very useful if you could explain to us all what *is* going on. I was not aware that a column of cells with simple numeric values in them had to be a table in order for that column to be sorted in straight numerical order. What's going

[users] Re: style changes are NOT retained

2010-02-21 Thread Andreas Saeger
Hi Thomas, How to create a new default template: http://user.services.openoffice.org/en/forum/viewtopic.php?f=71t=1161 (a template that is used when you call menu:FileNewText [Ctrl+N]) - To unsubscribe, e-mail:

[users] Re: Countif between checking

2010-02-19 Thread Andreas Saeger
Bob Long wrote: Simpler: =COUNTIF(range;5)-COUNTIF(range;=10) And another one: =SUMPRODUCT(range5;range=10) - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail:

[users] Re: Find and replace empty cells

2010-02-19 Thread Andreas Saeger
Brian McKee wrote: On Thu, Feb 18, 2010 at 6:43 PM, Twayne twa...@twaynesdomain.com wrote: In news:cc77dabe1002181306g79aaa2a4w491e279f95eb5...@mail.gmail.com, Brian McKee brian.mc...@gmail.com typed: In (cough) other spreadsheet software I'm used to starting find and replace, hitting the

[users] Re: calc: Python

2010-02-12 Thread Andreas Saeger
jonathon wrote: Johnny Rosenberg wrote: Actually, just NEVER EVER use the macro recorder at all, The functionality of the macro recorder depends upon why you think it is there. If you thought it would help you create macros for use on two, or more documents, you'd be wrong. If, OTOH, you

[users] Re: calc: Python

2010-02-11 Thread Andreas Saeger
Karti wrote: Hi, Is it possbile to use the macro recorder to record the macros and generate the codes in Python? Also is there any way to integrate sikuli script with openoffice macros? Regards, Karti Yes, it is possible (kind of). http://extensions.services.openoffice.org/project/MRI

[users] Re: Counting different items in a range

2010-02-03 Thread Andreas Saeger
Andy Chaplin wrote: If there a simple way to count the number of different values in a range? If I have a column with a thousand rows and I have different values in the rows (some of which are repeated)... Bacon Eggs Toast Marmalade Toast Toast Bacon The answer I want here is 4. (the total

[users] Re: Do different versions of OO.o do number formats differently???

2010-02-02 Thread Andreas Saeger
Joe(theWordy)Philbrook wrote: I ask because I have a writer document with a table in it I use to provide my doctor with a record of my daily blood glucose test data. I use my own personal time of day notation. It does NOT conform to any formally defined time format. And as far as I'm concerned,

[users] Re: Do different versions of OO.o do number formats differently???

2010-02-02 Thread Andreas Saeger
Joe(theWordy)Philbrook wrote: Whatever you hate or not. A text-only word processor would be an embarrasing defective piece of software. You never sum up numbers in tables? Never write invoices or something? - To

[users] Re: Calc conditional question

2010-01-30 Thread Andreas Saeger
Allen wrote: Hi gang, Is there any way to make a formula conditional depending on whether the cells in the row referred to are visible or hidden. What I need to do is create a summary of the sub-sections of a standard so executives can see the overall but then also have the detailed view

[users] Re: Calc conditional question

2010-01-30 Thread Andreas Saeger
Nothing is easy to do in a spreadsheet. This prejudice is built upon deception because a spreadsheet lets you enter anything anywhere instantly. Have you tried SUBTOTAL with filters? What is wrong with it? The infamous D-functions (DSUM, DGET, D...) can display subtotals based on filter

[users] Re: Forms for Calc

2010-01-27 Thread Andreas Saeger
jonathon wrote: Andreas Saeger wrote: But form controls are obsolete if you know how to tweak cells. How do you tweak a cell to prevent bad data from being input, without using form controls? jonathon Play with menu:DataValidity

[users] Re: Mail Merge won't create multiple letters

2010-01-27 Thread Andreas Saeger
NoOp wrote: On 01/26/2010 12:27 PM, NoOp wrote: I can view the datasource w/o issue, the data fields seem to be fine as I can click between the two addresses in the MM wizard and see the datafields change in the letter. But when attempting to print or save the 'merged' document, only one

[users] Re: Forms for Calc

2010-01-26 Thread Andreas Saeger
Wade Smart wrote: Well, this was really for about 1500 users is locations all over the world for this one company. The spread sheet is how they update certain things but, Ill have to check out the other way. :D One way or the other way, it is impossible to help with this tiny amount of

[users] Re: Forms for Calc

2010-01-26 Thread Andreas Saeger
Wade Smart wrote: The information is not collected. This form is for individuals - not a company. Thanks Wade And what was the question? Create a spreadsheet with unlocked cells on a protected sheet. Add some validation if it makes sense. Save as xls. Every Excel book since 1995 describes

[users] Re: Forms for Calc

2010-01-26 Thread Andreas Saeger
Wade Smart wrote: No. Not at all. My original question was: I have a project in front of me using calc. They want a form for input. Is anyone using input forms built for OO Calc but also used on Excel? Are they cross compatible? Nothing at all was said about getting the data back. Im

[users] Re: Anaphraseus is messing up with OOo

2010-01-25 Thread Andreas Saeger
Alex Zachopoulos wrote: Okay, folks, I _am_ a little misleading in the Subject line, but not much: I've got NeoOffice, which (I hope you'll agree) is for all intents and purposes in this thread the same as OOo. Running on MacOS X Leopard 10.5.7. I installed Anaphraseus, didn't like it, and

[users] Re: Forms for Calc

2010-01-25 Thread Andreas Saeger
Wade Smart wrote: I have a project in front of me using calc. They want a form for input. Is anyone using input forms built for OO Calc but also used on Excel? Are they cross compatible? Wade Base input forms are far better than the almost useless Excel forms. - Store a flat list as dBase

[users] Re: Forms for Calc

2010-01-25 Thread Andreas Saeger
Wade Smart wrote: Wow. I think between what you and Andreas said, I might just create a db and use php on a web page and forget the spread sheet. Thanks. Wade This is a very good idea and I'm sure the extra effort pays off after a few days of data collection by a small group of users.

[users] Re: Mail Merge won't create multiple letters

2010-01-25 Thread Andreas Saeger
D wrote: On 1/24/2010 5:10 PM, jomali wrote: I suspect that you expect to see all of the letters to be sent on your screen. However, have you tried printing your mail merge document? The merge, AFAIK, only happens upon printing. Only on print? That's seems rather strange to me.

[users] Re: Importing csv data into an existing database

2010-01-22 Thread Andreas Saeger
Pierre wrote: I'm back again, more confused than before. Drew Jensen wrote: When you launch the Import wizard, per the help file information, you I'm seeing an IMPORT TEXT dialog that lets me set column delimiters, character sets etc. 1) Ensure that the target table name is the name of

[users] Re: use named range in listbox

2010-01-19 Thread Andreas Saeger
Karti wrote: Please help me out with this. Karti kartikeya_...@hotmail.com wrote in message news:hif7nh$kp...@ger.gmane.org... Hi, It is possible to use named range in the source cell range while creating the listbox/combo box? If it is not possible is it possible to use a formula in the

[users] Re: .odt on fly

2010-01-14 Thread Andreas Saeger
H.S.Rai wrote: Is there some module / library by which one can generate .odt or .ods file from a webpage using php and fetching data from MySQL instead of producing html page. This is what the Base component does. Connect to your existing MySQL database and dump data from the beamer window

[users] Re: Mailing Lists Forums [Was: checksum]

2010-01-10 Thread Andreas Saeger
Dave Barton wrote: For the curious, who would like to know more, or the detractors, who wish to criticise, please read my 2008 post first and feel free to contact me off-list to avoid another long drawn out meta-thread. Dave OK, that's it. I stop answering questions here. Too much noise,

[users] Re: Base: Dropdown suggestions for existing data on condition?

2010-01-07 Thread Andreas Saeger
Dotan Cohen wrote: I do not understand what the form does. It appears to me that when I select a,b from one side, it tries to select b,a from the other. it doesn't exactly work, but as it doesn't fit what we need here I'll leave it at that. I do appreciate your attempt at helping, though. It

[users] Re: Base: Dropdown suggestions for existing data on condition?

2010-01-07 Thread Andreas Saeger
Dotan Cohen wrote: Last question, if I may? Where in the docs would I have found this? I really am trying to get up to speed with Base but there is so much info that I am drowning. The F1 help is close to useless. http://documentation.openoffice.org/servlets/ProjectDocumentList?folderID=778

[users] Re: Base: Dropdown suggestions for existing data on condition?

2010-01-07 Thread Andreas Saeger
I should have mentioned the most important toolbar to design a form manually and tune wizard-generated ones: http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=11228p=52666#p52666 Toolbar Form Navigation provides the full user interface for a form in operating mode:

[users] Re: Writer: Table changing 2009: to 2009:00:00. How to prevent?

2010-01-06 Thread Andreas Saeger
Dotan Cohen wrote: Writer insists on changing the text 2009: to 2009:00:00 in tables. I cannot find the formatting options such as Calc has to prevent this. I have gone through all the Autocomplete options and found nothing relevant. What must I do? Thanks Just like in Calc, number formt @

[users] Re: checksum

2010-01-05 Thread Andreas Saeger
NoOp wrote: Josef won't hear you unless you cc him... Delivered-To: mailing list users@openoffice.org Delivered-To: moderator for users@openoffice.org I don't understand. Why do you hear me and he doesn't? Does this mean I have to read the headers of all mails I want to answer?

[users] Re: checksum

2010-01-05 Thread Andreas Saeger
Barbara Duprey wrote: No, a lot of us have set up filters to look for the Delivered-To: moderator text in message headers and flag those messages as coming from unsubscribed users. Thunderbird, for example, makes this quite easy. I'm subscribed neither. I know that it's my turn to get

[users] Re: checksum

2010-01-05 Thread Andreas Saeger
the list in another way. Those of us who've been on the list a while treat her posts as exceptions, and don't copy her on responses. Andreas Saeger wrote: Barbara Duprey wrote: Barbara, Thank you very much for the explanation. It was not my intention to start another meta-thread. There are too

[users] Re: Calc: remove ' character before number

2010-01-04 Thread Andreas Saeger
jonathon wrote: OOo 1.x included a dBase 3 compatible database engine. Whenever the issue of does OOo include a database? came up, the answer was invariably no. Wrong. You could connect, define queries, use form controls and reports.

[users] Re: checksum

2010-01-04 Thread Andreas Saeger
josef muck wrote: Dear Sir Dear Madam, I am currently writing a thesis on INTEGRITY AND AUTHENTICITY OF DATA FROM THE DOWNLOAD OF THE WEB at the University in Graz, Austria. Do you provide at your download site a possibility to check the integrity? For example: hashes, MD5, SHA-XXX, etc. If

[users] Re: Calc: remove ' character before number

2010-01-03 Thread Andreas Saeger
jonathon wrote: On Fri, Jan 1, 2010 at 15:30, Andreas Saeger wrote: I have never seen any reasonable argument why spreadsheets should be used like this (except for mere laziness). The typical user neither knows, nor cares what the difference between a database and a spreadsheet program

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2010-01-01 Thread Andreas Saeger
Dotan Cohen wrote: Sorry for the delay, I have been swamped. As already stated, OOo uses the Hebrew locale with UK style dates when started with a he_IL environment. What are UK style dates? -mm-dd? dd/mm/ Stop insisting on modified defaults. It is not possible. Why7 should I

[users] Re: Calc: remove ' character before number

2010-01-01 Thread Andreas Saeger
Dotan Cohen wrote: any of the issues belong to different projects, most of which I am not the only member of. Although I have no fear of databases, it seems that Excel has many database-like features The database-like features *assume* database-like structures without enforcing them by any

[users] Re: cannot open Base

2010-01-01 Thread Andreas Saeger
Dotan Cohen wrote: I am trying to test something in Base, which until recently worked fine on my system. However, now the Base option is grey in the OOo splashscreen, and opening an odb file with the quickstarter just returns me to the splash screen. What could be the problem? Kubuntu 9.10, OOo

[users] Re: cannot open Base

2010-01-01 Thread Andreas Saeger
Drew Jensen wrote: Howdy Andreas, I used to give that advice also - at present however it seems that using OpenJDK yields just as satisfactory a result. Happy New Year Drew Thank you for this important hint. I had never noticed the improvement by myself. Best transatlanic whishes for

[users] Re: Base: Dropdown suggestions for existing data on condition?

2009-12-30 Thread Andreas Saeger
Dotan Cohen wrote: In Base, how can text fields have a dropdown box showing existing data if a certain condition is met? At a lab I work at, we process requests from different local companies. The first field is for the area, and the second field is for the company name. I want only the

[users] Re: OO writer, spell check doesn't work

2009-12-27 Thread Andreas Saeger
Larry Gusaas wrote: On 2009/12/27 7:27 AM David B Teague wrote: If I recall correctly, the spell check in versions of OO.o Writer worked out of the box. It usually does. Do I recall correctly? Yes If so, why was that changed? It hasn't. No software works perfectly for everyone.

[users] Re: Sorting and grouping ?

2009-12-25 Thread Andreas Saeger
William Case wrote: A reminder in either case would be helpful -- am starting to get frustrated. menu:DataSubtotal... sorts within groups and inserts subtotals. I prefer the data pilot since it provides the same information without touching the original data.

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-23 Thread Andreas Saeger
NoOp wrote: Option Decimal separator key refers to the decimal key on the num-pad. You can (and should) force that key to send a comma or a dot to OpenOffice.org, according to the set locale. Without this option, the application receives the same character as any other application. Do you

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-23 Thread Andreas Saeger
My test reveals the same as it ever did since version 1. Ooo3.1.1, LANG=de_DE (comma decimals) Num pad's decimal key on is comma in some text editor Locale Default (German), option checked Input Result Comment 3.1401.03.14Number

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-22 Thread Andreas Saeger
NoOp wrote: I did find that if I set the Default style (in OOo Calc) to Swedish (Sweden) and then the Date format to -MM-DD, the numbers displayed in the cell and in the formula bar are 2009-12-13. So that may be worth experimenting with also. Hi, Allow me to abstract the discussion

[users] Re: calc datapilot

2009-12-22 Thread Andreas Saeger
Klark Ooi wrote: Hi, Am I able to use datapilot to build summary table rather than values/statistics? For eg, I have a long list of table with: Country Customer Name contact person contact info My sample wish list will be in this form: === SG

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-22 Thread Andreas Saeger
NoOp wrote: quote NoOp So, set up Tools|Options|Lang...|Languages|Locale Setting|Swedish (Sweden) and adjust the *Decimal*, Currency, Language, etc for your liking. /quote NoOp Emphasis added to adjust the *Decimal*. Does this not work for you? Works for me. Here, let me explain how to adjust

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-21 Thread Andreas Saeger
Dotan Cohen wrote: You might be used to OOo Calc changing your date formats for you on the fly, but I enter dates in the format that I would like to use them. That's exactly what Calc does *not* do. It applies the format *you* have set or some default which depends on it's own locale (Hebrew,

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-21 Thread Andreas Saeger
Dotan Cohen wrote: Anything preventing the user from: Format|Cells|Date|1999-12-31 ? Or am I confusing Date formating with Text formating? In the latter case, the user should enter '2009-12-13 and then press Tab. I need this to be the default, Gary. The users could just go to any cell and

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-21 Thread Andreas Saeger
As already stated, OOo uses the Hebrew locale with UK style dates when started with a he_IL environment. Stop insisting on modified defaults. It is not possible. All of my own spreadsheets use no dates other than ISO dates. I never see any US style since I use either one of explicitly set

[users] Re: Formatting code for days HH:MM

2009-12-19 Thread Andreas Saeger
Format codes display day numbers rather than count of days. Start date in A1, end date in B1 ... =TEXT(INT(B1-A1);00) Days, TEXT(B1-A1;HH:MM) ... returns a text value like 3 Days, 13:45 for display purposes. For further calculations you should refer to the original numbers A1 and B1.

[users] Re: Calc: remove ' character before number

2009-12-19 Thread Andreas Saeger
Dotan Cohen wrote: I have a spreadsheet with 1375 rows. One of the colums is a time column, with the format 'hh:mm:ss. Note the leading ' sign. In order to sum this column, I need to remove this character. However, the search and replace dialogue s not recognize this character. How can I remove

[users] Re: Converting Base to Access

2009-12-14 Thread Andreas Saeger
Terry Ehrhart wrote: Is there a way to convert a Base file back to Access. I have a program that only recognizes an Access data file. Terry Ehrhart Running Linux, I can not try out, but I'm pretty sure it works: Get a copy of some mdb, connect a Base document it, remove the tables, open

[users] Re: calculating fields with a macro in a database

2009-12-13 Thread Andreas Saeger
You can extend the HSQL database application by means of Java libraries and you can extend the office by means of macros. Both apps are strictly separated from each other although they are bundled in your office installation and despite the fact that database data and the office data are

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: Thanks, Andreas, but Hebrew support is far different than -mm-dd support! -mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar with. As far as I can see, ISO date -mm-dd is among the predefined date

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: 2009/12/13 Andreas Saeger saege...@onlinehome.de: Dotan Cohen wrote: Thanks, Andreas, but Hebrew support is far different than -mm-dd support! -mm-dd is not the default date format for Israel, rather, I think it is the British yy/mm/dd as you are familiar

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-13 Thread Andreas Saeger
Dotan Cohen wrote: Yes, but it is not the default locale in any but Hungarian and Latvian. I need it to be my default date format, so when an unformatted cell gets 2005-9-2 Calc doesn't mangle it into something else. This can not work with unformatted cells (you mean number format General).

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-12 Thread Andreas Saeger
Dotan Cohen wrote: No, my locale is not US English: $ locale LANG=he_IL.utf8 This is the only relevant setting which is read from the OS when a default locale has to be evaluated. I figured that I could get away with not posting that as I posted this: $ date +%x 2009-12-08 The program

[users] Re: Calc formula

2009-12-12 Thread Andreas Saeger
John Meyer wrote: On 12/9/2009 10:25 AM, Johnny Rosenberg wrote: 2009/12/8 John Meyerpueblonat...@opensuse.us: Have you tried =CELL(…)? Doesn't have an infotype returning the sheet name. My default template for Calc has 2 named references: 1. InsertNamesDefine...[Ctrl+F3]

[users] Re: Calc cell formatting: hours

2009-12-12 Thread Andreas Saeger
Dotan Cohen wrote: Input masks are made for database forms where you have fields and records rather than cells: http://user.services.openoffice.org/en/forum/viewtopic.php?t=22506p=102636#p102636 I knew that I was using the wrong term, but what I meant was: a way to tell the computer that an

[users] Re: Calc cell formatting: hours

2009-12-12 Thread Andreas Saeger
Brian Barker wrote: At 10:23 08/12/2009 +0200, Dotan Cohen wrote: I have a column formatted as HH:MM. When the user enters 14 I need it to be registered as 14:00 assuming a 24-hour clock. How can this be achieved? One obvious workaround is to have two columns: one in which the user enters

[users] Re: Daten Sortieren Bereich enthält Spaltenbe schriftungen dauerhaft anwählen

2009-12-12 Thread Andreas Saeger
Harald und Doris Kral wrote: Hallo, ich nutze Windows XP Home Edition, Open Office 3.1.1 Da ich viele Tabellen mit Spaltenbeschriftungen habe, wollte ich gern die Option: Daten/Sortieren/Bereich enthält Spaltenbeschriftungen/ dauerhaft anwählen, was aber leider nicht funktioniert. Bei jedem

[users] Re: calculating fields with a macro in a database

2009-12-12 Thread Andreas Saeger
menu:InsertQuery (SQL)... SELECT *, UPPER(Name) AS NAME FROM Your Table Selects all the fields from a table named Your Table plus a calculated field labeled NAME having the upper cased value of a text field named Name. Just replace the quoted object names with you actual ones. This type of

[users] Re: Loading truetype fonts into OO

2009-12-12 Thread Andreas Saeger
Frank Lee wrote: Thanks Dave, I found /fonts/ in the windows folder. In windows 7 a Load Fonts button magically appeared. Work related files seem to hold format in OO. Now I will try the same OO edited files at work in MS Word. Next Ill try excel. If it works my bussiness will go off MS O!!!

[users] Re: Formula keyword un-localized...

2009-12-12 Thread Andreas Saeger
Verner Kjærsgaard wrote: Hi gurus... - I'm using OOcalc in danish. It annoys me that all formula keywords have been (doh!!) translated into hard to understand danish... I.e., 'if' becomes 'hvis' and worse than that. Is there a way to have OOcalc use standard (english) keywords in calc?

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-12 Thread Andreas Saeger
Dotan Cohen wrote: Where is there an outline of which locales provide which formatting? I have gone through quite a bit of the docs as support.openoffice.org but I find nothing. Any number format dialog in this office suite shows all the built-in formattings with format codes for all the

[users] Re: Calc cell formatting: hours

2009-12-12 Thread Andreas Saeger
Dotan Cohen wrote: I knew that I was using the wrong term, but what I meant was: a way to tell the computer that an integer [0,23] should be read as belonging to the hour. If [0,23] means two integers 0 and 23 to be read as hours and minutes: A1: 0 B1: 23 other cell, formatted as time:

[users] Re: calculating fields with a macro in a database

2009-12-12 Thread Andreas Saeger
Jonathan Kaye wrote: Andreas Saeger wrote: menu:InsertQuery (SQL)... SELECT *, UPPER(Name) AS NAME FROM Your Table SELECT *, Charis(ENTRY Sorting) AS Beaut FROM Table1 SQL is not a programming language. It is more like a command line environment to manipulate most relational databases

[users] Re: File extensions

2009-12-12 Thread Andreas Saeger
Sean wrote: How do I make OOo recognize file extensions? I'm currently using OOo 3.2 build 9460 (soon to be 9466) and I'm having a little trouble with this. I've had to assign each filetype manually but I was hoping there was a better way. I thought someone said that it can be done in a release

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-11 Thread Andreas Saeger
Dotan Cohen wrote: Please, please, this is killing me. $ date +%x 2009-12-08 However, Calc insists on using the mm/dd/yy year format in new documents. The settings under Language are all Default. What must I do to have OOo respect the locale settings? I know that this issue has been addressed

[users] Re: Who do I have to strangle to get OOo to respect locale settings in Linux?

2009-12-11 Thread Andreas Saeger
Johnny Rosenberg wrote: 2009/12/11 Andreas Saeger saege...@onlinehome.de: Dotan Cohen wrote: Please, please, this is killing me. $ date +%x 2009-12-08 However, Calc insists on using the mm/dd/yy year format in new documents. The settings under Language are all Default. What must I do to have

[users] Re: Calc cell formatting: hours

2009-12-11 Thread Andreas Saeger
Input masks are made for database forms where you have fields and records rather than cells: http://user.services.openoffice.org/en/forum/viewtopic.php?t=22506p=102636#p102636 - To unsubscribe, e-mail:

[users] Re: Who has a larger organization (100 users) using Open Office?

2009-12-06 Thread Andreas Saeger
Dan Itkis wrote: I'm looking to chat with someone who's migrated their organization to Open Office to gain insight into what to expect. thanks! Dan Does IBM count? They use their own derivate of OOo and name it Lotus Symphony.

[users] Re: Save Cell range as csv

2009-12-04 Thread Andreas Saeger
Franz Waldmüller wrote: Andreas Saeger schrieb: Franz Waldmüller wrote: I am looking for an extension macro which enables me to save a certain (selected) cell range of a sheet to a csv file. If I am right I remember using a macro or extension before. I am work on a fresh ubuntu 9.10 install

[users] Re: Save Cell range as csv

2009-12-03 Thread Andreas Saeger
Franz Waldmüller wrote: I am looking for an extension macro which enables me to save a certain (selected) cell range of a sheet to a csv file. If I am right I remember using a macro or extension before. I am work on a fresh ubuntu 9.10 install and spend a lot of time with the usual search

[users] Re: Open Office Base 3.1.0 Issue

2009-12-01 Thread Andreas Saeger
André Costa wrote: Hello I recently work with your Open Office Base 3.1.0, and I have a doubt. Can I insert a picture in database? In the table design I select one column IMAGE[LONGVARBINARY]. In data view in this column apears OBJECT. I can't insert anything. What's mean? Then

[users] Re: sorting in Calc

2009-11-30 Thread Andreas Saeger
joe g wrote: Hi, trying to sort the first column in Calc but the first line is ignored and is not sorted. Inserted a blank row but was deleted and same thing happened as before. All the rest of column is sorted OK. Any ideas? Tks Calc's quick-sort can not recognize a column label if all

[users] Re: URGENTE:COMO DESINSTALAR O BROFFICE?

2009-11-30 Thread Andreas Saeger
Janaina Hallais wrote: Prezados, Fui orientada a baixar o BrOffice 3.1 para recuperar um documendo do Word (Office 2007), mas como não consegui, gostaria de desinstalar o programa, pois nao será mais útil. O BrOffice não aparece em Adicionar/Remover Programas. Grata, Janaína Hallais sudo

[users] Re: Base Form Question

2009-11-29 Thread Andreas Saeger
Eustace wrote: How can I specify the vertical distance between a label and a field? (Of course I can drag it, but I want to be accurate.) -emf Toolbar Form Design provides all the tools you want. The first part of that toolbar lets you manage the hierarchy of forms and controls, the

[users] Re: Ubuntu 9.04, OpenOffice V 3.0.1 and newest OpenOffice V 3.1.x

2009-11-29 Thread Andreas Saeger
Web Kracked wrote: My question still stands, could someone setup a repository for OOo's web site's [Sun's] version for the Deb versions of Linux? How much bandwidth would it need - GUESS? How hard would it be to do so for every update that comes out? I would love to be able to easily install

[users] Re: [moderated] Database dosen't open

2009-11-29 Thread Andreas Saeger
Joana Villas-Boas wrote: I just installed Open Office for the first time. I did a custom instalation because I just want to use the Database application. When I clic the openoffie Icon I can’t open the Dabase application! Nothing happends. I tried registering the product, reparing, unistalling,

[users] Re: Want date of last modification in Calc

2009-11-27 Thread Andreas Saeger
bill purvis wrote: I am working on a multi-sheet parts list spreadsheet and it would be really useful if I could automatically insert the date of the most change at the bottom of each sheet. I can see that I can enter the 'current' date, but I'd really like the date at which any of the sheets

[users] Re: Want date of last modification in Calc

2009-11-27 Thread Andreas Saeger
bill purvis wrote: On Friday 27 November 2009, Richard Detwiler wrote: bill purvis wrote: On Friday 27 November 2009, Andreas Saeger wrote: bill purvis wrote: I am working on a multi-sheet parts list spreadsheet and it would be really useful if I could automatically insert the date

[users] Re: http://qa.openoffice.org/issues/show_bug.cgi?id=94697

2009-11-25 Thread Andreas Saeger
JOE Conner wrote: What I want to be able to do is import a style and incorporate it within my own new document (F-11) dropdown list of styles. This could happen when I receive a document from another source when it has a style that I would like to use in my own documents.

  1   2   3   >