Re: [libreoffice-users] Calc Function

2014-01-11 Thread Stephan Zietsman
Sorry, I accidentally sent my message to James instead of the mailing list. Let me recap what we discussed off-list. James E Lang wrote: Correction: I meant SUMIF() rather than SUM(). Corrected formula: =IF(___(A$3:A7,A7,Q$3:Q7)=___(A$3:A7,A7,R$3:R7),SUMIF(A$3:

Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?

2012-01-11 Thread Stephan Zietsman
Gilles wrote: I want to move cell A1 to A2 with the mouse: This is easy enough. You just select the cell, and then click-and-drag it - you don't need to press any keys on the keyboard. The trick is to actually *select* the cell. Try this: To move A1:A2 to B3:B4, simply select A1:A2 and

Re: [libreoffice-users] Re: [3.4.4/Windows] How to move cell with mouse?

2012-01-11 Thread Stephan Zietsman
Gilles wrote: Thanks, but it doesn't work. When I select A1, unclick (ie. remove my finger from the left button on the mouse) then move the mouse to A2, it simply selects A1 and A2, it doesn't move A1 to A2. I also tried keeping the left button clicked while I moved to A2, but it also selects

Re: [libreoffice-users] Add a Text file to Calc?

2012-01-11 Thread Stephan Zietsman
Jay Lozier wrote: On 01/11/2012 05:37 PM, . wrote: How do you add a text file to a Calc sheet? One method you could try is to create a *.txt file in Writer. Then import the file into Calc using InsertSheet from File. [snip] Something else you could also try is using Paste Special. In

Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?

2012-01-11 Thread Stephan Zietsman
Alan Boba wrote: 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. Click and hold to drag highlighted cell to new destination I think this method is better than the one I described. Thanks for pointing it out.

Re: [libreoffice-users] Calc bug involving drop-down boxes in grouped areas

2012-01-11 Thread Stephan Zietsman
Jim Trigg wrote: Any suggestions?  Is there a bug tracking system into which I should submit this? Tom Davies wrote: This link might help http://wiki.documentfoundation.org/BugReport Tom provided the link to information on reporting bugs in LibreOffice. If you want to get to the bug

Re: [libreoffice-users] [3.4.4/Windows] How to move cell with mouse?

2012-01-11 Thread Stephan Zietsman
Alan Boba wrote: 1. Move cell pointer to desired cell 2. Press Ctrl 3. Click on desired cell (note: Click, not Click and hold) 4. Release Ctrl 5. Click and hold to drag highlighted cell to new destination For the sake of completeness, let me add that you could also use the Shift key instead

Re: [libreoffice-users] In Calc- keyboard shortcut to change font size?

2012-01-09 Thread Stephan Zietsman
. pe...@aleksandrsolzhenitsyn.net wrote: Is there a keyboard shortcut to increase or decrease a font size? I just had a quick look and it appears that there is no short-cut for this. Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Modify a dot file with writer

2012-01-09 Thread Stephan Zietsman
Maxime de Roucy wrote: I have a client that want to modify a .dot file (Microsoft Word model file) with Writer. He don't want to convert it but to modify it : open, modify and save as .dot file. As far as I know, there is no difference between a .dot and a .doc file (except the extension). I

Re: [libreoffice-users] Re: [SOLVED] Identifying the correct row in Spreadsheet formulas

2011-12-14 Thread Stephan Zietsman
Ian Whitfield wrote: 1) How do I work out what ROW NUMBER a given unique value is on? 2) How do I use this ROW NUMBER to make-up a valid CELL ADDRESS? 3) How do I get the VALUE in that CELL ADDRESS? [...] 2) For the CELL ADDRESS I have a cell that identifies each COLUMN that these values

Re: [libreoffice-users] Hiding paragraphs not working

2011-12-05 Thread Stephan Zietsman
Phil Reynolds wrote: I was using OpenOffice rather than LibreOffice last year, and constructed an address label file that could omit a blank field from a label, or omit it if it was equal to a certain value, and in fact it did one of each, quite successfully. However, when I came to use this

Re: [libreoffice-users] Converting MS Office templates to Libre Office

2011-12-05 Thread Stephan Zietsman
Jay Lozier wrote: How many templates are you doing? I do not know of a batch method for converting a large number. I believe the command line could be used for this purpose. Something like: soffice -headless -convert-to ott MyTemplateFile.dotx It should not be too much trouble to modify this

Re: [libreoffice-users] The tone of thiese Lists (from a newbie)

2011-11-28 Thread Stephan Zietsman
Bob Houston wrote: If I understand the procedure correctly I just post the question to (libreoffice-users)? That's correct. Just post to libreoffice-users (users@global.libreoffice.org), as you are doing right now. Regards Stephan -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Comments removed when savin .docx

2011-11-28 Thread Stephan Zietsman
Advrk Aplmrkt wrote: However, I notice that any comments I add to a .docx document via LibreOffice Writer do not show up when opened in Micro$oft Word 2007, 2010, or 2011! Is this a known bug, or am I not doing it correctly? I believe this is a known bug

Re: [libreoffice-users] can I make Libre default to save as .rtf

2011-11-22 Thread Stephan Zietsman
doug wrote: AFAIK, Microsoft can read rtf.  Two people whom I recently sent odf to said they couldn't read it.  I'm told by people familiar with MS Word that not all .doc files are compatible, there having been a change somewhere along about 1998 or so. (I don't use anything Microsoft when I

Re: [libreoffice-users] writer: business cards w/ tables - duplicate cells

2011-11-21 Thread Stephan Zietsman
Matthew Monaco wrote: As a secondary issue, the 5 cell rows are 2 inches high. The document is US Letter (11 inches long). And the top and bottom margins are set to .5 inches each. Therefore, everything should fit exactly. However, there is a blank second page which I cannot get rid of. Any

Re: [libreoffice-users] can I make Libre default to save as .rtf

2011-11-21 Thread Stephan Zietsman
doug wrote: I'd like to make LO Writer default to saving everything in .rtf format.  The .odf is not readable by people with Microsoft software, which is most of the world.  If so, how?  (Running version 3.4.4) To change the default format when saving: Tools - Options... - Load/Save -

Re: [libreoffice-users] Re: Styles not saving

2011-11-20 Thread Stephan Zietsman
warutledge wrote: @Jack/Stephan -- I don't want to save the style to the csv, I'm aware that is not possible. I simply want to apply a style for editorial purposes while I am viewing the file. However, the issue is, I have to create the style in each individual document in order to apply it.

Re: [libreoffice-users] Spam, spam, spam

2011-11-16 Thread Stephan Zietsman
drew wrote: On Wed, 2011-11-16 at 19:51 +, Mike Moratz-Coppins wrote: Since I subscribed to this list, the amount of spam e-mails going to this account went from zero (in the years that I've had this address) to nine over a 3-day period.  There were even a couple of 419 jobs in there... I

Re: [libreoffice-users] Bug: Setting $DATA causes LibreOffice to crash

2011-11-14 Thread Stephan Zietsman
Keith Thompson wrote: Quick summary: Setting the environment variable $DATA causes LibreOffice to crash. [...] I also wonder whether some other seemingly innocuous environment variables might cause similar problems. Thanks for the info. I can only imagine what you had to go through to track

Re: [libreoffice-users] Libreoffice ~ JSON viewer / plugin

2011-11-14 Thread Stephan Zietsman
bankadmin wrote: Is there any Libreoffice ~ JSON viewer / plugin ? I don't know what JSON is so I looked it up on wikipedia. As far I can tell, it's just regular text (human readable code). I think you should be able to open it just like a text file. Is my assumption wrong? Regards Stephan

Re: Fw: Re: [libreoffice-users] [PDF Import] LibreOffice extension for importing PDF documents -- pdfimport

2011-11-14 Thread Stephan Zietsman
Pedro wrote: In the case of Musescore, the font is internal to the program and is embedded in the PDF (which explains why the PDF looks good).  If you look at the document properties you will notice that MScore120 and MScore20 were embedded. If you could get these exact fonts your PDFimport

Re: [libreoffice-users] Libre Office quitting

2011-11-14 Thread Stephan Zietsman
Séamas Ó Brógáin wrote: I always use “paste special” (in fact I have a keyboard shortcut for “paste unformatted text”)... Just a quick question, slightly off topic: how did you assign a keyboard short-cut to paste unformatted text? Regards Stephan -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Libre Office quitting

2011-11-14 Thread Stephan Zietsman
Séamas Ó Brógáin wrote: Tools Customise Keyboard . . . In the bottom-left panel, Functions Category, choose Edit; in the right-hand panel, Function, go down to Paste Unformatted Text; then in the top panel scroll to Ctl+Shift+V (or whatever you want), select it, and then press the button

Re: [libreoffice-users] Re: LibreOffice Math can't handle asterisk as superscript

2011-11-10 Thread Stephan Zietsman
Pedro wrote: Apparently this is a known limitation with a solution :) http://www.oooforum.org/forum/viewtopic.phtml?t=6925 For the benefit of those who might be following the thread, the solution that was suggested is to include the asterisk in quotes. So instead of writing: A ^ * you should

Re: [libreoffice-users] Re: How to make a request for a change?

2011-11-07 Thread Stephan Zietsman
NoOp wrote: It's always a good idea if you filed a bug report to post a url to the report. That way other users on this list can review comment if they have similar issues/requests. So, what is the link to the bug report that you filed? Just did a search, looks like it's this one:

Re: [libreoffice-users] name-define-edit causes crash in LO Calc v3.4.3

2011-11-06 Thread Stephan Zietsman
Gérard FARGEOT wrote: Searching with name ctash, bug with many duplicates are found. No need to post another bug. Plus, this bug is solved in future 3.4.4 Looks like it's this bug: https://bugs.freedesktop.org/show_bug.cgi?id=40571 Regards Stephan -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] The guts of ODF files

2011-11-03 Thread Stephan Zietsman
Dennis E. Hamilton wrote: The Zip-related message may be a warning, not a fatality. It also may be related to up-/down-level compatibility among the PKWare Zip specifications. When I use WinZip 9.0 SR-1, there are no problems reported.  I haven't checked the files against the PKWare APPNOTE

Re: [libreoffice-users] How to make a request for a change?

2011-11-03 Thread Stephan Zietsman
Cor Nouws wrote: For the component field, you may choose LibreOffice. And for the severity field, you may choose enhancement. Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-11-02 Thread Stephan Zietsman
David S. Crampton wrote: I don't think the bugs described in those 2 articles are the same behavior issue. Those descriptions and the discussion of is it a bug or is it emulating Excel are too dense for my brain at least this evening. [...] In short, I think I'm reporting something different.

Re: [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-11-01 Thread Stephan Zietsman
David S. Crampton wrote: The keystokes: In L154: Ctrl+C Down Arrow: moves to L155 Ctrl+V: paste Esc: terminate the dotted border focus on L154 F2: make the small edit Enter: terminate the edit Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled cell in the row.

Re: [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow

2011-11-01 Thread Stephan Zietsman
David S. Crampton wrote: The keystokes: In L154: Ctrl+C Down Arrow: moves to L155 Ctrl+V: paste Esc: terminate the dotted border focus on L154 F2: make the small edit Enter: terminate the edit Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled cell in the row.

Re: [libreoffice-users] Math does not export properly

2011-10-31 Thread Stephan Zietsman
Jacques Malaprade wrote: Please someone help. I am trying to export a long formula to PDF from lo math and it only exports the text in the input window (%sigma etc.). I need to export the proper formulas. I  have rebooted, tried to convert and import from different formats but no luck. Could

Re: [libreoffice-users] Combining Two Columns In-Place

2011-10-31 Thread Stephan Zietsman
Rich Shepard wrote:  In an Excel spreadsheet saved in .ods format are column pairs representing data that can be combined into a single column because rows have a value in one column or the other, but never both.  In Xess I was able to put the cursor in a cell (e.g., N2) and enter the

Re: [libreoffice-users] Calc: Converting Formula to Value

2011-10-31 Thread Stephan Zietsman
Rich Shepard wrote:  I have a column where the cells display the sum of two other columns. I want to change the contents from formula to value but cannot find the relevant information in the help pages. Please point me to instructions on how to do this. Select the relevant cell and click in

Re: [libreoffice-users] Problem LO Calc not copying formulae LMDE X64

2011-10-31 Thread Stephan Zietsman
Steve Fisher wrote: Enter X in B1, then enter following formula in A1 then copy formula to A2 =if(b1=X,AAA,BBB), it copies the value AAA and not the formula =if(b2=X,AAA,BBB). If I copy the formula from A1 to A2, the formula works as I would expect; the formula in A2 is =IF(B2=X,AAA,BBB). How

Re: [libreoffice-users] Problem LO Calc not copying formulae LMDE X64

2011-10-31 Thread Stephan Zietsman
Tom Davies wrote: LMDE is Linux Mint Sorry, I didn't pay much attention to the subject heading, only concentrated on the content. My bad. Regards Stephan -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Re: LO Conflicts with OOo

2011-10-31 Thread Stephan Zietsman
Harold Fuchs wrote: The conflict I reported was between a non-portable OOo installed to the C: drive on the machine and a portable LO installed on a USB key. I don't think they'd be using the same folder for user settings. As far as I know, the portable version uses the profile on the USB key

Re: [libreoffice-users] cannot open rtf files

2011-10-28 Thread Stephan Zietsman
Uwe Koch Kronberg wrote: I can not open the accompanied file [...] The mailing list removes all attachments. You can upload the file to the internet and then share the link on the list. You can use a site like www.2shared.com Regards Stephan -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] LO Conflicts with OOo

2011-10-27 Thread Stephan Zietsman
Harold Fuchs wrote: I installed the new portable LO (http://portableapps.com/apps/office/libreoffice_portable) on a USB stick. When I try to run it, it complains that there is another copy running. It seems that this is because OpenOffice's (non-portable) Quickstarter is running on the

Re: [libreoffice-users] what is the relationship between latex and libreoffice?

2011-10-27 Thread Stephan Zietsman
soumalya ray wrote: few days back,there was a mail about an extension (probably math) for libreoffice to integrate latex with it. what is latex [...] could anybody give me some idea about it?how to use it with libreoffice? Just to be clear, Latex is a completely different program from

Re: [libreoffice-users] Font attributes will not save in Calc

2011-10-25 Thread Stephan Zietsman
Dean Chia wrote: And if I can compound to this problem - same thing applies to say page formatting in Writer - I reconstruct margins and header/footer stuff, and it doesn't appear when I open a new document... Margin changes, as well as header/footer stuff will not appear in a new document

Re: [libreoffice-users] Sel-defined formulas insertng in Calc

2011-10-24 Thread Stephan Zietsman
plmvantoo...@hetnet.nl wrote: I get in Calc using the formula VOL(aA1;B1;C1) only the message #NAAM? This will mean that the name of the function is not recognized by Calc. What is wrong in what I have done, following the instructions in the report   Calc/user-defined Functions? Not sure if

Re: [libreoffice-users] A small annoying problem with the formula editor

2011-10-17 Thread Stephan Zietsman
John Bijnens wrote: I've a small annoying problem with the formula editor in libreoffice. I had the same problem with go oo. Just a quick question to get some clarification: which component of LibreOffice are you talking about (Calc or Math)? Regards Stephan -- For unsubscribe instructions

Re: [libreoffice-users] to bug or not to bug that is the question

2011-10-14 Thread Stephan Zietsman
gael.lori...@laposte.net wrote: I couldn't find a changelog of LO3.4.3 on libreoffice.org (results returned by seeks using the site:libreoffice.org keyword are irrelevant) A little off topic, but when searching for LibreOffice documentation, you might want to include inurl:libreoffice instead

Re: [libreoffice-users] Re: to bug or not to bug that is the question

2011-10-14 Thread Stephan Zietsman
gael.lori...@laposte.net wrote: You are right, Ctrl+ArrowKey is enough, my mistake. [...] Ctrl+ArrowKey works this way for me too, except when I am editing a formula and want to add a cell's reference, in which case it brings the cursor directly to the first/last coloumn/line of the

Re: [libreoffice-users] Calc: cut/paste removes and renames protected field references - is this a bug?

2011-10-13 Thread Stephan Zietsman
Brian Jamison wrote: Steps to reproduce: On Sheet1 put data in fields A1, A2 On Sheet2 reference A1 and A2 in cells (e.g. =$Sheet1.$A$1, =$Sheet1.$A$2) Protect Sheet2 Cut the data in cell A1 Paste the data into A2 Cut the data in cell A2 Paste the data into A1 Both field references in

Re: [libreoffice-users] converting ppt documents to pptx in headless mode

2011-10-10 Thread Stephan Zietsman
aneesh.vemuri wrote: I searched for documentation of converting ppt documents to pptx format in headless mode and I only saw examples of converting to pdf. Can someone please help me with the parameters to be passed for this. I have ppt files coming in and I want to save them as pptx files. I

Re: [libreoffice-users] Re: Problem installing on Windows 7, with workaround

2011-10-06 Thread Stephan Zietsman
Op Ed wrote: Anyway, I downloaded LibO_3.4.3_Win_x86_install_multi.exe and ran it. Had to get mommy to come to my desk and authenticate as admin, but otherwise the installation proceeded with no errors or obvious hiccups. I've also had trouble with administrative privileges on a Windows 7 PC.

Re: [libreoffice-users] need help how to save file into text file or CSV file

2011-10-06 Thread Stephan Zietsman
toto wrote: I want to save file from Calc into CSV file or text file using macro, but before that I want to change the content and use semicolon as delimiter. Anyone can help or have some reference on it? Not sure if I understand you correctly, but you can save a file as CSV with File Save

Re: [libreoffice-users] Problem installing on Windows 7, with workaround

2011-10-06 Thread Stephan Zietsman
Op Ed wrote: They do, however, have USB ports locked down for anything that's not human interface (i.e., mouse, keyboard, drawing tablet), so no portable apps - no external drives or memory... Just to clarify: the portable version does not require a flash disk. It can be installed onto the

Re: [libreoffice-users] Symbols: alpha

2011-10-04 Thread Stephan Zietsman
Sigrid Carrera wrote: You can insert a Math object in any other component like Writer, Calc, Impress... I don't know of a way to type %alpha and get then the greek letter within plain Writer. Just to add to what you've mentioned: To insert a Math object into Writer you can do the following:

Re: [libreoffice-users] Outline Numbering

2011-09-09 Thread Stephan Zietsman
William Honeywell wrote: Is there a plug in or later version in which Outlining behaves? I am using Libreoffice 3.3.2. Suggestions, advice, or help would be appreciated. Is there a user's group or a website? There is indeed a newer version of LibreOffice available. You can have a look at the

Re: [libreoffice-users] New Calc Document Appearance

2011-09-02 Thread Stephan Zietsman
Rich Shepard wrote:  Yes, the scale factor was set at 35% rather than at 100%. I used XessSE for more than a dozen years and moved my data to OO.o in the switch from 32-bit to 64-bit. Never saw a scale factor before. Strange. Hope it stays at 100% now. Rather than a scale factor, it's more of

Re: [libreoffice-users] HELP WITH CODE excel

2011-08-18 Thread Stephan Zietsman
Joseph Da Silva wrote: I was wondering if someone could help me with this code it works in excel but not with libra office. What exactly do you mean by the code working? Do you mean that in LibreOffice you get some kind of error? Or do you not get the result that you were expecting? If you

Re: [libreoffice-users] Re: Ability to change currency as neededacross a spreadsheet in Calc?

2011-07-15 Thread Stephan Zietsman
floridabrits wrote: thanks Twayne - I'm actually not interested in 'coverting' from USD to pick your currency so exchange rates don't matter at all...  all I really need to do is be able to say hey, here's a spreadsheet that's in USD... if you click on this button you can change the currency

Re: [libreoffice-users] Problems with Find in 3.4.0

2011-07-11 Thread Stephan Zietsman
MR ZenWiz wrote: Find and Replace (which used to be the same window as Find, shortcut ctlF) is not ctlaltF, and ctlF does nothing except activate the toolbar for finding text, which doesn't actually do a find at all. You can change the keyboard short-cut. The following instructions are for

Re: [libreoffice-users] Problems with Find in 3.4.0

2011-07-11 Thread Stephan Zietsman
Stephan Zietsman wrote: You can change the keyboard short-cut.  The following instructions are for Windows, they may differ slightly for Ubuntu. Click Tools Customise... Select the Keyboard tab. In the Shortcut keys pane, scroll down to Ctrl + F and select it. In the Category pane select

Re: [libreoffice-users] xls file causing crash

2011-07-07 Thread Stephan Zietsman
Cor Nouws wrote: Stephan wrote: I was hoping that I could narrow down the possibilities to file a proper bug report, but I can make no sense of this. Well, pls do. Since a developer with a debug-environment can prolly find out what the problem is. I've created a bug report

Re: [libreoffice-users] RE: Inserting Info - Move in a 'Z' formation...

2011-07-07 Thread Stephan Zietsman
Stephan Zietsman wrote: [...] please do a mock-up of what you need and what you want it to look like. [...] I'll email you directly so that you can get my email address.  I will try to keep the list posted if I think something's relevant. Behind the scenes Llweyn sent me the mock-up

Re: [libreoffice-users] xls file causing crash

2011-07-05 Thread Stephan Zietsman
Steve Edmonds wrote: How have you defined the data series in your original file, as a data range A1:A5 or as a named range. I defined it as a data range, however it is non-contiguous. As far as I remember, it should be sheet1.A1:A3, sheet1.A5 (without quotes). Regards Stephan -- Unsubscribe

Re: [libreoffice-users] xls file causing crash

2011-07-05 Thread Stephan Zietsman
Steve Edmonds wrote: If I take your file, edit the chart data series (which appears blank in LO3.4.1) and add sheet1.A1:A3, sheet1.A5 I get the correct chart. My assumption is that there is a bug in the import filter for the .xls file and the chart is importing blank data series. A bug

Re: [libreoffice-users] xls file causing crash

2011-07-05 Thread Stephan Zietsman
Sigrid Carrera wrote: I can open it with: LibreOffice 3.3.2 OOO330m19 (Build:202) Ver: 3.3.2.2-14.mga1 whereas LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.2.2 crashes repeatedly. Dave Griffiths wrote: I just tried and found no problem opening the file. I run openSUSE

Re: [libreoffice-users] Re: prevent line breaks between parentheses and formula object

2011-07-04 Thread Stephan Zietsman
Zak McKracken wrote: Am 01.07.2011, 15:17 Uhr, schrieb Brian Barker b.m.bar...@btinternet.com: An obvious workaround may be to include any such parentheses in the formula itself. Not quite, I'm afraid. Because in the parentheses, I have some regular text behind the formula, and a non-closed

Re: [libreoffice-users] Match cell against any of range of regexes?

2011-07-01 Thread Stephan Zietsman
Ryan Jendoubi wrote: This is set up pretty much how I'd like it to work (without the looong list of input on the first sheet). I wasted half my day Googling this and trying various things, and the IRC channel has declared it impossible without a macro. If you've thought of a winning formula

Re: [libreoffice-users] Match cell against any of range of regexes?

2011-07-01 Thread Stephan Zietsman
Ryan Jendoubi wrote: LO macros would definitely be a good skill to learn eventually, even if it's not at the top of my todo list at the moment. I haven't yet searched for any tutorials or the like, but I'd be interested to hear if you have any personal favourites which you think would suit

Re: [libreoffice-users] Re: Inserting Info - Move in a 'Z' formation...

2011-06-30 Thread Stephan Zietsman
Llweyn wrote: That would prefect, you'll just have to walk me through it. I'm familiar with what macro is, however I have never had the occasion to use such parameters. I'm a quick study though. :-) Let me know what is the next step and thank you! Ok, if a macro would work, I'll just need

Re: [libreoffice-users] Match cell against any of range of regexes?

2011-06-30 Thread Stephan Zietsman
Ryan Jendoubi wrote: Is the operation in the subject line possible? More info (maybe I'm asking the wrong question): I have a (long) list of URLs, and want to categorise them. The categories themselves could be pretty broad: news sites, search engines, music sites, etc. Similar URLs

Re: [libreoffice-users] Re: Command line (convert) parameter(s)

2011-06-29 Thread Stephan Zietsman
leif wrote: *Hi, For some reason I coulnd't make the *.doc to work. Instead I managed to create a batch file: Hi leif, apparently, the * (star) character won't work properly in Windows, according to http://muthusuba.blogspot.com/2011/03/so-called-hidden-features-of.html: quote [PS: wildcards

Re: [libreoffice-users] Re: LibreOffice won't start

2011-06-29 Thread Stephan Zietsman
ian_mcquay wrote: So it was something in the user profile that caused the problems. There is a .tmp file in the old *3\user* directory. I moved it to the new directory but id did not affect the starting. If you feel like it, you could copy some of the files/folders in the old profile to the

Re: [libreoffice-users] Inserting Info - Move in a 'Z' formation...

2011-06-29 Thread Stephan Zietsman
Llweyn wrote: Need to know if this program has the capability to allow a user to have a full worksheet, insert another cell and have the previous information moves cells in a 'Z' formation. [...] Is this feature already available and if so where can I locate it - how do I utilize it? Off the

Re: [libreoffice-users][windows] Calc: Text numbers

2011-06-29 Thread Stephan Zietsman
John B wrote: this where, say,  you enter text into a cell in column E  say at E16  the text would be something   8,000 btus (or 2.34kw) Machines now if you type in the same column above or below it, say at E7 the number 8, the whole of  8,000 btus (or 2.34kw) Machines appears. That is

Re: [libreoffice-users] Re: Command line (convert) parameter(s)

2011-06-28 Thread Stephan Zietsman
Nuno J. Silva wrote: According to the code, only UNIX systems get the help text written to the console. Everything else gets a dialog box. ,[desktop/source/app/cmdlinehelp.cxx, line 154] | #ifdef UNX |         // on unix use console for output |         fprintf(stdout, %s%s, | [...] |

Re: [libreoffice-users] Re: Command line (convert) parameter(s)

2011-06-27 Thread Stephan Zietsman
NoOp wrote: Not sure about Windows, but here is the output of the '--help' command in linux. I suspect that the same commands are also available in Windows. snip Thanks NoOp, that's what I was looking for. The message window I described only lists the options up to -infilter=filter along

Re: [libreoffice-users] Re: Linux synonem and language tool

2011-06-23 Thread Stephan Zietsman
lee wrote: Stephan Zietsman writes: I believe it should be Modify - Restore Default Command Cool, that works, thanks :) Perhaps this option needs to be renamed to Restore Default Icon? I believe that Restore Default Command restores both the icon as well as the command name (they can

Re: [libreoffice-users] LibreOffice won't start

2011-06-23 Thread Stephan Zietsman
Sigrid Carrera wrote: If you see the recovery assistant again, instead of saying yes, recover my files just click on cancel and LibO should start anew with a new document or at least with the startcenter open. If I try and start Calc again nothing visible happens. It duplicates the

Re: [libreoffice-users] LibreOffice won't start

2011-06-23 Thread Stephan Zietsman
Stephan Zietsman wrote: You could also try to bypass the recovery process.  In a command interface (Start - Run - cmd), try the following: soffice -norestore Sorry, in Win7 it's not Start - Run - cmd, but rather just Start - cmd (click Start and then you just type cmd and press ENTER) Regards

Re: [libreoffice-users] Command line (convert) parameter(s)

2011-06-22 Thread Stephan Zietsman
Nuno J. Silva wrote: I found out about that parameter while reading the development mailing list: Yes, I also found out about it from reading a mailing list or something. I also found it mentioned here: http://lists.freedesktop.org/archives/libreoffice/2011-April/009994.html I was hoping that

Re: [libreoffice-users] how to move text string into formula, from another cell

2011-06-21 Thread Stephan Zietsman
Tom Cloyd wrote: * changing the original formulat to =IF($E10=x,K4,0) or =IF($E10=x,K4,0) - where K4 is the cell with the calculated text string. Either of these result in an error 510. I notice the part K4 I think you may have confused your syntax here. In Calc formulas, the ampersand ()

Re: [libreoffice-users] Enabling Macros - misleading labelling

2011-06-21 Thread Stephan Zietsman
Roxy Robinson wrote: And just why would Macros be considered experimental features Macros have been around forever. Macros are not considered an experimental feature. They work even if Enable experimental (unstable) features is unticked. However, *recording* macros is not a fully

Re: [libreoffice-users] default type and setting for pasting

2011-06-21 Thread Stephan Zietsman
Stephan Zietsman wrote: So in lee's case, he would probably prefer something else.  And it looks like he found a solution that works for him. Sorry, lee. I assumed your gender (by saying he and him), which is generally considered bad etiquette. I apologise. lee wrote: Hm. Perhaps I can

Re: [libreoffice-users] default type and setting for pasting

2011-06-21 Thread Stephan Zietsman
Stephan Zietsman wrote: How did you create an icon like that?  At first I thought it should be fairly easy, but when I tried, I couldn't find a way. Never mind, I found it. Right-click on any toolbar - Customise toolbar... - Toolbar tab - Add... - (Category) Edit - (Commands) Paste Unformatted

Re: [libreoffice-users] default type and setting for pasting

2011-06-20 Thread Stephan Zietsman
Roxy Robinson wrote:  From what I know you have to use Paste Special for what you want to do. Paste Special has several options that you must choose from, so you cannot set it to do only one Just to elaborate: you can perform a Paste Special by pressing CTRL+SHIFT+V (instead of the regular

Re: [libreoffice-users] Double clicking .ODT file opens it in WordPad!

2011-06-20 Thread Stephan Zietsman
Bazsl wrote: I uninstalled Open Office and installed LibreOffice. Now if I click on a .ODT file it opens in WordPad instead of Writer. How can I easily fix this for all LibreOffice apps on Win7 Pro 64 bit? Thanks. There's another way to do it, which looks pretty straightforward:

Re: [libreoffice-users] Re: Side by side install of LibO and OOo

2011-06-20 Thread Stephan Zietsman
aqualung wrote: Registering means of course, entries in the registry which, when a file such as .odt or .ods is clicked, opens whatever program has been registered to open it. Depending on where in the REgstry these program-choosings lie, and which it comes to first, and with both LO and OOo

Re: [libreoffice-users] Re: Side by side install of LibO and OOo

2011-06-20 Thread Stephan Zietsman
aqualung wrote: Thank you, a reasonable suggestion (but see the bug referenced upthread, about conflict between LibO Portable and OOo.) The bug refers to *running* LibO Portable and OOo at the same time. They can peacefully co-exist, as long as you don't try to have an instance of both running

Re: [libreoffice-users] Re: How can I reset all settings?

2011-06-20 Thread Stephan Zietsman
Hi all, just to mention it explicitly: you don't need to uninstall and re-install if you've renamed the user profile directory. It is already mentioned in the tutorial (http://user.services.openoffice.org/en/forum/viewtopic.php?p=58401#p58401), and most of the posts here did imply that. I just

[libreoffice-users] Disable macro in an open document

2011-06-20 Thread Stephan Zietsman
Does anyone know of a way to disable a macro in a document that has already been opened? Just to clarify, I don't mean when opening a document. After I've opened a document and allowed macros to run, is there a way to disable them later on, without having to close and re-open the file? A quick

Re: [libreoffice-users] Disable macro in an open document

2011-06-20 Thread Stephan Zietsman
Frieder wrote: As far as I know there is no possibility without having to close and re-open the file Thanks, that answers my question. But you can stop a running macro. Thank you for the advice. I do know how to stop a running macro, but thanks for giving the suggestion any way (might

Re: [libreoffice-users] Re: CT2N Extension.

2011-06-17 Thread Stephan Zietsman
Tinkerer wrote: I was trying to convert 'one and two If you can upload a test file with typical inputs, then someone (maybe even me?) could have a look at writing a function (Calc function or Macro) that addresses your need(s). Regards Stephan -- Unsubscribe instructions: E-mail to

Re: [libreoffice-users] Re: CT2N Extension.

2011-06-15 Thread Stephan Zietsman
Tinkerer wrote: BTW. I should be able to Convert text to Numbers using the Value() function, in which case, I would not need CT2N. I have tried using Value several ways and all I get is either #Value, or Error 502. Hi Tinkerer, could you perhaps upload a test file of where this function is

Re: [libreoffice-users] copy down, copy and paste in calc.

2011-06-14 Thread Stephan Zietsman
Steve Edmonds wrote: Is it a bug or an enhancement? I notice that MS Excel also does not paste the data into all the selected cells (when using the method described in 2. above). Excel pops up a warning message about data on the clipboard not being the same size as the selected range. The two

Re: [libreoffice-users] How can I make long words stay on their starting line?

2011-06-13 Thread Stephan Zietsman
never punctual wrote: Please correct me if I'm wrong, but I think I understand how manual hyphenation works now! From how you explain it, it looks like you understand, yes. By the way I tried out Ctrl + Enter, and all it did was move my cursor down to the next page. I think the key

Re: [libreoffice-users] Spelling Check doesn't work

2011-06-13 Thread Stephan Zietsman
planas wrote: You should check under TOOLSOPTIONSLANGUAGE SETTINGSWRITING AIDS Make sure a dictionary is selected in the Available Language Modules group Then make sure the Check Spelling as You Type is selected in the Options group. Also check that the AutoSpellCheck button is active. It

Re: [libreoffice-users] removing hyperlinks

2011-06-13 Thread Stephan Zietsman
Joep L. Blom wrote: I have a small problem in a master document. I have written (in various stages of completion) 8 chapters of a book and use a master document to keep it  orderly. ...SNIP... I cannot delete these texts from the master document as they are read-only. Just a quick question:

Re: [libreoffice-users] helping Users and LibreOffice - proposal

2011-06-13 Thread Stephan Zietsman
upscope wrote: Can you install both at same time? I would like to test 3.4.0 to see if any of the calc problems I have with 3.3.2 are fixed. I have a possible work-around. You can use the portable version called LibreOfficePortable. It is available from

Re: [libreoffice-users] Merge cell problem LO3.3.2.2

2011-06-13 Thread Stephan Zietsman
Roxy Robinson wrote: I have a 15 page spreadsheet of classmate addresses, phone numbers, email, etc. I manipulate this information in several different ways to give my classmates different kinds of directories. Anyway, their names are in the first 3 columns. This particular spreadsheet is

Re: [libreoffice-users] How can I make long words stay on their starting line?

2011-06-10 Thread Stephan Zietsman
never punctual wrote: So basically, I consider my problem completely resolved now, thanks to all the replies. I only have one final question about what Stephan wrote. I went to the wiki page and I understood every part of your summary except the last part on manually hyphenating single words.

Re: [libreoffice-users] Problem Copy Image From Website

2011-06-09 Thread Stephan Zietsman
Cor Nouws wrote: All work fine for me. LibreOffice 3.3.3rc1, 3.4.0 Can you have a look in Tools Options Writer View, section Show, Images and objects .. ? The following check-boxes are ticked (ON): Tools Options LibreOffice Writer View (Display) Graphics objects Tools Options

Re: [libreoffice-users] text frame

2011-06-09 Thread Stephan Zietsman
Cor Nouws wrote: ?? How would you create a link 'between' one frame? I think there's a misunderstanding. I believe e-letter meant to say ... you can link two frames only (and not more than two)... Just use it as follows, I woudl suggest: frame1 = frame2 = frame3 = framen ... This seems to

  1   2   >