[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tinkerer
Tom The LO Options for a Mac are in LO Preferences. The Options differ too as there is no option to switch Quickstarter on or off under the Memory option. It may exist elsewhere, but I have never seen it. BTW. I am running Mac 10.8.2 on an iMac and I have never experienced that problem. I am

[libreoffice-users] Re: LibreOffice suddenly hanging on my MacBook Pro

2013-02-27 Thread Tinkerer
Robert To ensure a compete removal of an Application I use Clean My Mac http://macpaw.com/cleanmymac or you could try Amnesia http://www.koingosw.com/products/amnesia.php Both these search and remove associated files when you do an uninstall. Tink. -- View this message in context:

[libreoffice-users] Re: Currency conversion/display in calc

2013-03-09 Thread Tinkerer
What is your default Language set to? Before Pasting, Go to FormatCells and alter the Language to US English. After Pasting, alter it back to UK English, or whatever currency is the Default. Tink. -- View this message in context:

[libreoffice-users] =IF Function

2013-03-13 Thread Tinkerer
Using Mac 10.8.2 and Libre 4.0.1, I find that the the IF function does not place a blank space as the second option. Have I done something insanely stupid, or is this a bug? Where I should get blank cells I am getting: #DIV/O! ASTest.ods

[libreoffice-users] Re: =IF Function - SOLVED

2013-03-13 Thread Tinkerer
I could not get your prompts to work, but they gave me ideas. The final formula was: =IFERROR(C30*100/B30,) This also covered other errors where only one number was present, so no calculation was possible. Many thanks, Tink. -- View this message in context:

[libreoffice-users] Re: =IF Function

2013-03-13 Thread Tinkerer
Thank you Brian I'd forgotten that there is a material difference between Empty cells and Blank cells, even though I noticed that the result sometimes varied. Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4043493p4043610.html Sent from the Users

[libreoffice-users] Re: Intro to LibreOffice Presentations

2013-03-13 Thread Tinkerer
Aaron On a Mac 10.8.2 using Libre 4.0.1 everything works OK I would fault the PPT's. The Black fonts on a Dark background were impossible to read and not all projectors would cope adequately. I went through the slides altering the font colour where I had difficulty reading. The finished result

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Tinkerer
For the benefit of others, there is no bug. You need to include a position on the sheet, say: Target 2014,A1 This will take you to cell A1 on Sheet 2014. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4043877.html Sent

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Tinkerer
Steve Replace the comma with a stop. Alas it still does not work correctly. It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink to Sheet 2014 as well. I have not the time to sort that out at present. Perhaps someone more intuitive can help. Tink. -- View this message

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-15 Thread Tinkerer
Steve No luck with either Hyperlink from the INSERT menu, or Hyperlink from the Functions. The Help pages are anything but on this subject. Can you send me a copy of your file so that I can try it. Many thanks, Tink. -- View this message in context:

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Tinkerer
Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation could be improved though. Thank you for your example, it works. I tried adding another Hyperlink to your Sheet 2012 and it moved the Link to Sheet 2011,

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Tinkerer
Hi Steve Doh! The solution is unbelievably simple. It does not much matter what technique you use as long as you have 2011.A1, or equivalent, in a Hyperlink. To make it work you have to SAVE the file before you use the Hyperlink. Any attempt to test it first will mess up your Sheets. Would you

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-17 Thread Tinkerer
Steve I have tried this on Mac 10.8.2 and Mac 10.8.3 For LibreO, I have tried 4.0.1 and 4.0.2.1 with no variation in the results. There must be something in the way I have it set up in the Preferences. Now I know how to cope with it, it isn't much of a problem as it only happens when you set up a

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tinkerer
Tanstaafl If I enter 2014.A1 as the Hyperlink target, a click on it takes me to sheet 2014 cell A1 If I enter 2012.C12 the link takes me to Sheet 2012 Cell C12 So where is the Bug? Go to the bug and read the comments. Tink. -- View this message in context:

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tinkerer
I understand perfectly what you are saying. I just do not understand why you cannot enter the cell location as well as the sheet number. When I do it, it just works. I know the Hyperlink has not asked for the cell reference, but you could give it anyway. There are far too many bugs waiting to be

[libreoffice-users] Re: calc problem

2013-03-25 Thread Tinkerer
It opens OK in the Mac, LO 4.0.1.2 version. 114 Rows by 13 columns. -- View this message in context: http://nabble.documentfoundation.org/calc-problem-tp4046080p4046119.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: pasting numbers into Calc (summary)

2013-04-13 Thread Tinkerer
The extension by Cor Nouws, CT2N, Convert Text 2 Numbers is ideal and quick. Paste, then click on the icon in the toolbar and it is done. Wherever there is a number prefixed by ' the ' will be removed. Nothing else will be changed and your sheet looks exactly the same. Here is the link

[libreoffice-users] Re: template paths

2013-05-03 Thread Tinkerer
For OS X Paths ApplicationsLibre Office, then Right click to: Show Contents ContentsShareTemplates BTW. OS X Options are in Libre Office Preferences, you will find Templates under Paths. Tink -- View this message in context:

[libreoffice-users] Re: Untitled 1

2013-05-14 Thread Tinkerer
Many thanks to Brian Barker. Somehow I had managed to delete the default document from the Templates folder, so when starting Writer it loaded the next available template which happened to be a Letter head. Every time I started a new document I first had to delete the address heading. No need to

[libreoffice-users] Re: LO 4.0.3.3: 'Insert: Horizontal rule' is missing

2013-06-15 Thread Tinkerer
When I want to draw horizontal line I use: Automatic lines in Writer 1. If you start a new line in a Writer text document by typing three or more hyphen characters and press the Enter key, the characters are removed and the previous paragraph gets a line as a bottom border. To create a single

[libreoffice-users] =IF Function

2013-06-18 Thread Tinkerer
How can I show the result of an IF function as Text instead of Value? eg. IF test, 'Passed,'Failed Tink. -- View this message in context: http://nabble.documentfoundation.org/IF-Function-tp4062008.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: =IF Function

2013-06-18 Thread Tinkerer
DOH! Thanks all. I gave you a wonderful chance to point out the bleeding obvious. I tried putting the quote marks around the text and got an error result. That was late last night so I must have done something wrong. Tink. -- View this message in context:

[libreoffice-users] Re: spelling correction

2013-07-12 Thread Tinkerer
Walther In LO 4.04.2 there is no alteration of Bold type. Your other error involving the added m is still there though. Tink. -- View this message in context: http://nabble.documentfoundation.org/spelling-correction-tp4065024p4065146.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Visible currency rounding

2013-07-14 Thread Tinkerer
I do not understand your formula, but you can set the result to a number of decimal places and I assume that is what you have done. Calc displays the number of places you set, but this is not the exact result, eg it may display two decimal places, but in fact is carrying forward three decimal

[libreoffice-users] Re: HTML Source

2013-07-14 Thread Tinkerer
In the Mac version LO 4.04.2 the Data Source is in the View Menu and you can obtain it by pressing F4. Tink -- View this message in context: http://nabble.documentfoundation.org/HTML-Source-tp4065331p4065360.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe

[libreoffice-users] Re: Visible currency rounding

2013-07-14 Thread Tinkerer
Marino Format Cells Numbers nil decimal places. To get a correct roundup go to Tools Options Calc Calculate, make sure that Precision as shown checked. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065363.html Sent from the

[libreoffice-users] Re: Visible currency rounding

2013-07-15 Thread Tinkerer
Tom Let me put it another way. Take the following sales: 50 items @ 1.37 VAT @20% = 68.50 VAT = 13.70 If the same items are sold separately, the VAT would be different. 1 item @ 1.37 VAT @ 20% = 0.274 for the VAT This would be rounded to 27p and 50 x 0.27 = 13.50 Rounding has caused a difference

[libreoffice-users] Re: Visible currency rounding

2013-07-15 Thread Tinkerer
Tom The post said he wanted to round everything including the tax on his invoice template. As I said earlier. He needs to go into Tools Options Calc Calculate and check the Precision as shown box. This will make all his calculations precise as displayed. ie if he sets to two decimal places then

[libreoffice-users] Re: Visible currency rounding

2013-07-16 Thread Tinkerer
Tom In my early days of using spreadsheets, to be absolutely certain we would Round the decimal by multiplying the result by 100, then INT and then divide by 100. Tink. -- View this message in context: http://nabble.documentfoundation.org/Visible-currency-rounding-tp4065342p4065731.html Sent

[libreoffice-users] Re: Uninstall ?

2013-07-27 Thread Tinkerer
No. Version 4.1 will overwrite an older version and your personal data will remain intact, together with Templates, Extensions etc. Tink. -- View this message in context: http://nabble.documentfoundation.org/Uninstall-tp4067654p4067660.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Claris Works 3 6

2013-07-30 Thread Tinkerer
Hi Niklas Ever hopeful I downloaded LO 4.1 It did not work. Neither did 4.1.04 Laurent Alonso contacted me and we have investigated what might be the cause. I tried the stand alone converter, mwawOSX, that also failed to convert. I have experienced a lot of difficulty with Apples security which

[libreoffice-users] Re: [4.0/Win] Edit form?

2013-08-07 Thread Tinkerer
Using a Mac 10.8.4 and LibreOffice 4.1.0.4 it works perfectly for me. Tink. -- View this message in context: http://nabble.documentfoundation.org/4-0-Win-Edit-form-tp4069229p4069240.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?

2012-07-09 Thread Tinkerer
It worked for me, = 1.26 In the multiply C1 by C2 cell you must have hit the function icon and not the equals icon. This would Sum the two in the absence of any chosen function. Tink. -- View this message in context:

[libreoffice-users] Libre Office on an iPad.

2012-07-21 Thread Tinkerer
This offers you Libre Office, but without hosting. You load it into the Cloud and with almost anything else, so it says. Has anyone any experience of this? https://www.rollapp.com/libreoffice Tink. -- View this message in context:

[libreoffice-users] Re: convert to pdf - failing

2012-07-30 Thread Tinkerer
You do not need a PDF Converter. In Libre Office Goto File Export as PDF - Job done. Tink. -- View this message in context: http://nabble.documentfoundation.org/convert-to-pdf-failing-tp3998412p3998516.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: scalc 3.6 date format problem

2012-08-17 Thread Tinkerer
I am using Libre Office 3.6.0.4 on an iMac 10.8 if I enter the date as 17/08/12 it is displayed as 17/08/2012. No doubt whatsoever that the date is being accepted using ddmmyy Tink -- View this message in context:

[libreoffice-users] Wrning Message

2012-08-25 Thread Tinkerer
http://nabble.documentfoundation.org/file/n4003584/Untitled.tiff Untitled.tiff I keep getting this message when loading a blank Libre Office Spreadsheet. I am using a Mac 10.8 and Libre Office 3.6 Tink. -- View this message in context:

[libreoffice-users] Re: Warning Message

2012-08-25 Thread Tinkerer
Sorry. I uploaded a screen shot and it has not worked. Tink. -- View this message in context: http://nabble.documentfoundation.org/Wrning-Message-tp4003584p4003585.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to:

[libreoffice-users] Re: Warning Message

2012-08-25 Thread Tinkerer
Trying to find my User folder, I find that the whole of the Mac User Library is missing. A search for the folder, or any folder known to be within that folder, draws a blank. Looking back in Time Machine I can see I have been without it since August 23rd, two days. I tried to Restore it, but

[libreoffice-users] Re: Warning Message

2012-08-27 Thread Tinkerer
Larry I have my Library now, for which Many Thanks. About the script error. The script referred to is nowhere in the 3 folder and deleting the Library/App.Support/Libre file has not solved it. In every other respect the Beta works. I will just wait for the next update. That usually cures these

[libreoffice-users] Re: Warning Message

2012-08-27 Thread Tinkerer
Larry I have downloaded Lbre 3.6.1.2 and it has the same fault. I have found the missing script. Not in Library/Application Support. It is here: LibreOffice.App/Contents/Share/basic/ScriptBindingLibrary/Script xlb Either it is in the wrong place or the App is not pointing to it. Would you

[libreoffice-users] Re: Warning Message

2012-08-28 Thread Tinkerer
Larry I have tried renaming the the User profile without success. I have just tried renaming it again and the file is identical to the previous file. I looked in Standard and it is empty. Thanks for telling me what does what and where to look. Tink. -- View this message in context:

[libreoffice-users] 3.6.1.2 Error message

2012-08-29 Thread Tinkerer
I reported this in error in LO 3.6 The fault persists in LO 3.6.1.2 with Mac 10.8 http://nabble.documentfoundation.org/file/n4004329/Untitled.tiff Untitled.tiff As you can see from the above file, the Folder, Standard in the User/Library/Application Support/LibreOffice/3/basic/Standard, is

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread Tinkerer
Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006356.html Sent from the Users mailing list archive at Nabble.com. -- For

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-10 Thread Tinkerer
James CT2N is a Libre extension, not a file extension http://extensions.libreoffice.org/extension-center?getCategories=getCompatibility=anysort_on=positive_ratingspath=%2FLibreOffice-Extensions-and-Templates%2Fextension-centerportal_type=PSCProjectSearchableText=CT2N Load this into the Libre

[libreoffice-users] Re: how to delete an entire heading

2012-10-14 Thread Tinkerer
Put the cursor in the Header then right click, from the menu, choose, Remove Header. You then have a choice, Delete header, Delete Header and Text. Tink. -- View this message in context: http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013288.html Sent from the

[libreoffice-users] Re: how to delete an entire heading

2012-10-15 Thread Tinkerer
Alternatively. try putting the cursor inside the blue drop down which describes the Header style. I have a Mac system 10.8.2 Tink. -- View this message in context: http://nabble.documentfoundation.org/how-to-delete-an-entire-heading-tp4013210p4013605.html Sent from the Users mailing list

[libreoffice-users] Checking Grammar

2012-10-30 Thread Tinkerer
I have installed After the Deadline and Lightproof, but neither seems to work. Do they need activation? Tink. -- View this message in context: http://nabble.documentfoundation.org/Checking-Grammar-tp4015999.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: Checking Grammar

2013-09-20 Thread Tinkerer
Thank you Kumara. I am OK now. Surprisingly, my request was made in October 2012. Tink. -- View this message in context: http://nabble.documentfoundation.org/Checking-Grammar-tp4015999p4074895.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Installing Extensions.

2013-10-04 Thread Tinkerer
Using a Mac System10.8.5 and LibreOffice 4.1.2. I find I am unable to install extension updates. Here is an example error message: Error while installing extension writer2epub.oxt. The error message is: Cannot detect media-type:

[libreoffice-users] Re: Installing extensions

2013-10-14 Thread Tinkerer
On a Mac you will find the Extensions folder by Right clicking on LibreOffice.app: Go To Show Package Contents Contents Share Extensions. Tink. -- View this message in context: http://nabble.documentfoundation.org/Installing-extensions-tp4078029p4078032.html Sent from the Users mailing list

[libreoffice-users] Insert/Overwrite in Status Bar

2013-11-02 Thread Tinkerer
In LO 4.1.3.2, Mac X version, the Insert/Overwrite Mode is missing from the Status Bar. Clicking next to the Language icon will bring up Overwrite, but it does not work. Tink. -- View this message in context: http://nabble.documentfoundation.org/Insert-Overwrite-in-Status-Bar-tp4081011.html

[libreoffice-users] Re: Insert/Overwrite in Status Bar

2013-11-03 Thread Tinkerer
I do not look at either. I am one of those poor unfortunates who still have to look at the keyboard. Tink. -- View this message in context: http://nabble.documentfoundation.org/Insert-Overwrite-in-Status-Bar-tp4081011p4081116.html Sent from the Users mailing list archive at Nabble.com. --

[libreoffice-users] Re: CALC convert text to numbers

2013-11-12 Thread Tinkerer
Brian If you are using a Mac 10.9 then you can move a Tool Bar icon simply by clicking on the gap to the right of the icon. When the object frame appears, drag the fame to where you want the icon, let go and the icon will move. I use CT2N when I copy and paste from a web site and it works, with

[libreoffice-users] Re: CALC convert text to numbers

2013-11-14 Thread Tinkerer
These solutions are far too complex especially if you have very large sheets. Why not use the extension CT2N? It is simple, very straightforward and you can decide ,whole sheet, or just parts. The ' is just removed. I understand it is to be included as standard, in which case there will be no need

Re: Formats failed marketing, was: Fwd: Cost of MS Office relative to LO, was: Fwd: [libreoffice-users] Re: moving to new version of MS Office

2013-12-01 Thread Tinkerer
LibreOffice as a BRAND is growing stronger every day. It is easily recognized once it has been introduced. When the name was chosen it must have been uppermost in the TDF mindset that they were creating a brand.. Promoting the Brand is surely what matters to all who want to see LibreOffice

[libreoffice-users] Table of Contents - Crash

2013-12-30 Thread Tinkerer
I am using an iMac 10.9.1. and LO 4.1.2. and whenever I enter Insert Indexes and Tables Indexes and Tables, LO crashes and I have to recover. I tried re-Boot, re-Download LO to no avail. Downloaded LO 4.2.1 and it works. Can someone confirm a bug in LO4.1.2 Tink -- View this message in

[libreoffice-users] Default Template

2014-01-12 Thread Tinkerer
I inadvertently created a Default Template. It arrived very time I opened Writer, so in Manage Templates I deleted it. Now when I open Writer I get the following Message: Users/jt/Library/Application Support/LibreOffice/4/user/template/LettersJT.ott does not exist. It is still calling for the

[libreoffice-users] Import into a Template

2014-01-12 Thread Tinkerer
I have downloaded a c,s.v file from my Bank and created a Template for the Bank listing. I can load the Bank file into a new Spreadsheet and I then have to reformat it. Why can I not Import it into the Template, or is there another way? Tink. -- View this message in context:

[libreoffice-users] Re: SOLVED Default Template

2014-01-12 Thread Tinkerer
I do not know whether this was correct, but I made Writer Untitled 1 my Default Template. Tink. -- View this message in context: http://nabble.documentfoundation.org/Default-Template-tp4091871p4091886.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: Import into a Template

2014-01-12 Thread Tinkerer
James That is exactly what I am trying to do. I open the CSV Template then I go to Insert Sheet from File OK and it creates another sheet either before or after the sheet from the Template. I finish up with a two sheet file, one sheet Formatted and the other sheet with the Bank info. What I want

[libreoffice-users] Re: Import into a Template

2014-01-13 Thread Tinkerer
James You have not read my request correctly. I know how to use Templates and I know you can add to the text, I also know that you cannot import another file into the Document, you can only Paste something in. This applies whether you are using a New Document, or one created from a Template.

[libreoffice-users] Re: Default Template

2014-01-13 Thread Tinkerer
Many thanks Brian. I wasn't until widened the Template Manager Window that I realised all these other options Existed. Tink. -- View this message in context: http://nabble.documentfoundation.org/SOLVED-Default-Template-tp4091871p4091972.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Editing Custom Styles in Calc

2014-01-15 Thread Tinkerer
Highlight the area, then Format Clear Direct Formatting. Tink. -- View this message in context: http://nabble.documentfoundation.org/Editing-Custom-Styles-in-Calc-tp4092310p4092325.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to:

[libreoffice-users] Re: Help needed with LibreOffice Calc 4.1.3.2

2014-01-21 Thread Tinkerer
To adjust the line thickness of the grid: Format Cell Borders Line Width From there you can alter the color, the spacing and the Line Arrangement. Tink. -- View this message in context: http://nabble.documentfoundation.org/Help-needed-with-LibreOffice-Calc-4-1-3-2-tp4093178p4093356.html

[libreoffice-users] Re: low traffic lately?

2014-01-26 Thread Tinkerer
I looked at ASKLO, but the requirement to sign up for Twitter I found off putting. Why cannot I just join ASK? Tink. -- View this message in context: http://nabble.documentfoundation.org/low-traffic-lately-tp4093796p4093989.html Sent from the Users mailing list archive at Nabble.com. -- To

[libreoffice-users] Re: Writer printing problem

2014-02-04 Thread Tinkerer
I am using a Mac and LO 4.2.0.4 LO stays on the page printed, but and I think this is what you also find, the Print menu reverts to page one. If so, I don't think this is an LO problem as the print routine does this whatever application you are in. Tink. -- View this message in context:

[libreoffice-users] Re: Large fonts

2014-02-22 Thread Tinkerer
I am using LO 4.2.1 on a Mac, system 10.9.1, using Default Style When I put the cursor back on the page after entering the font size 400, the font size reverts to 12. I have tried Clear Direct Formatting, but it still reverts to 12. I have also tried different fonts. I have tried typing in the

[libreoffice-users] Re: Large fonts

2014-02-22 Thread Tinkerer
*Doh* All I had to do was hit ENTER. Tink. -- View this message in context: http://nabble.documentfoundation.org/Large-fonts-tp4098417p4098547.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] No sound from Impress.

2014-03-10 Thread Tinkerer
I have several Impress and PPS files which use WAV sound. This format is no longer supported in Libre 4.2.1.1 Is this intentional, or is some other factor involved? I am using an iMac System 10.9.1 Tink. -- View this message in context:

[libreoffice-users] Re: No sound from Impress.

2014-03-13 Thread Tinkerer
I now have LO 4.2.2 and everything works OK for.wav sound. There is still a problem with video .m4v as it will either lock up, causing a Forced Reset, or it opens in Writer as gobbledegook. Tink. -- View this message in context:

[libreoffice-users] Page margins

2014-04-02 Thread Tinkerer
In Libre 4.2.2.1 Mac version. I have a five sheet Calc document and when I set the page margins to print one sheet, the margins for the other sheets are also altered. Should I list this as a bug? Tink. -- View this message in context:

[libreoffice-users] Re: Page margins

2014-04-02 Thread Tinkerer
Cor I need to make frequent changes to the Page Format on the three Sheets that I print from. I cannot predetermine every change, so a change in the margins is the simplest way out, or it would be if it remains with that sheet only. BTW. Re. CT2N. Using Libre version 3, I was not able to add

[libreoffice-users] Re: Page margins

2014-04-03 Thread Tinkerer
Many thanks Tim, I'll try that later. Tink. -- View this message in context: http://nabble.documentfoundation.org/Page-margins-tp4103796p4103997.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] Re: SOLVED: cannot convert text to number in spreadsheet from csv file

2014-04-20 Thread Tinkerer
I import English web data. I installed the Extension CT2N, Convert Text To Numbers, and this puts an icon in the Tool Bar. A click on CT2N and it is done. I had a problem with currency prefixes as they did not convert, but Cor Nous sorted that for me. Tink. -- View this message in context:

[libreoffice-users] Re: Delete Key Does Not Work in OS X

2011-07-07 Thread Tinkerer
I have Libre 3.4.1 on a Mac 10.6.8 and both Back Space and Delete keys work as normal. I have only used them in Writer and Calc though. Tink. -- View this message in context: http://nabble.documentfoundation.org/Delete-Key-Does-Not-Work-in-OS-X-tp3134155p3147662.html Sent from the Users mailing

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-15 Thread Tinkerer
I have an iMac, System 10.6.8 and Libre 3.4.1 In Calc I have no problems with red negatives, two decimal places and comma separated thousands when saved as odf However, when saved as xls, the red negatives are all black, but the thousand separator and the two decimals are OK. In xml, fods,

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread Tinkerer
I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context:

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread Tinkerer
Tom How do you do it? I try to make it a triple negative by using red, brackets and a minus sign. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176846.html Sent from the Users mailing list archive at

[libreoffice-users] Re: change to move/copy

2011-07-26 Thread Tinkerer
Now I am confused. On my iMac 10.6.8, Libre 3.4.1 I cannot find the EditSheet so that means I cannot find Move/Copy either. Tink. -- View this message in context: http://nabble.documentfoundation.org/change-to-move-copy-tp3198226p3200141.html Sent from the Users mailing list archive at

[libreoffice-users] How do I delete unwanted Extensions?

2011-08-21 Thread Tinkerer
I have somehow acquired a lot of extensions that I will never use, i.e.. Languages Unfortunately they are all locked. How can I remove the lock, or delete them any other way? Tink. -- View this message in context:

[libreoffice-users] Re: How do I delete unwanted Extensions?

2011-08-21 Thread Tinkerer
I am the root user on a Mac 10.6.8, Libre 3.4.2 I can alter all the Preferences, I can add Extensions but I cannot unlock these Extensions. The list is far too long and I want to shorten it. Tink -- View this message in context:

[libreoffice-users] Re: How do I delete unwanted Extensions?

2011-08-21 Thread Tinkerer
No luck there. I want to remove others as well, such as Java script provider and Python script provider. There is about twelve in all, all firmly locked. Tink. -- View this message in context: http://nabble.documentfoundation.org/How-do-I-delete-unwanted-Extensions-tp3272690p3272952.html

[libreoffice-users] Re: How do I delete unwanted Extensions?

2011-08-22 Thread Tinkerer
Larry That worked a treat. I must have a closer look at Show Package Contents, there are a lot of funnies lurking in there. Many thanks, Tink. -- View this message in context: http://nabble.documentfoundation.org/How-do-I-delete-unwanted-Extensions-tp3272690p3275147.html Sent from the Users

[libreoffice-users] Re: How do I delete unwanted Extensions?

2011-08-22 Thread Tinkerer
I believe the Mac uses the system dictionaries, the system languages and the system spell checker. You don't need two versions, so why do you need a choice? Extensions and Templates are different as they are unique to LibreO. Whoever produces the Mac version doesn't think a choice is needed,

[libreoffice-users] Libre Help file in Windows 7

2011-08-29 Thread Tinkerer
A friend has installed Libre 3.4.2 on his Windows 7 computer. He then installed the Libre Help file and Windows put it in Documents. It does not work. Where should it be? BTW. I am a Mac user. Tink. -- View this message in context:

[libreoffice-users] Re: Should LibreOffice even support Microsoft secret formats?

2011-09-11 Thread Tinkerer
The answer is obvious. Save in odf and get used to using odf. When there is a requirement to use an MS suffix,use Save As to do a copy in doc or docx, but keep your copy in odf. Tink. -- View this message in context:

[libreoffice-users] Re: Should LibreOffice even support Microsoft secret formats?

2011-09-11 Thread Tinkerer
Spencer The early version of MSO for the Mac left a lot to be desired, so I tried OOo. That was about six years ago. I very quickly graduated onto NeoOffice, a great improvement, then when the Doc F was founded I moved to LO. I am treasurer of a society and whilst I am knowledgeable of the

[libreoffice-users] Re: annoying restore window

2011-09-11 Thread Tinkerer
Guy Go to Preferences Paths Backups. I am not sure of this, but I think, that if you remove the backup files Libre will create a new Untitled1 file. Tink. -- View this message in context: http://nabble.documentfoundation.org/annoying-restore-window-tp3327252p3327299.html Sent from the Users

[libreoffice-users] Re: Should LibreOffice even support Microsoft secret formats?

2011-09-11 Thread Tinkerer
Spencer That is odd. According to the Format/Page the column widths have not been altered. On the page, they have. Re. Your comments as to the future of LO and all FOSS. Count me in. Tink. -- View this message in context:

[libreoffice-users] Re: sum function in libreoffice calc doesn't seem to work

2011-11-04 Thread Tinkerer
Get the Extension CT2N, which is convert text2 Numbers. You only jump through one loop then. Tink. -- View this message in context: http://nabble.documentfoundation.org/sum-function-in-libreoffice-calc-doesn-t-seem-to-work-tp1839208p3481046.html Sent from the Users mailing list archive at

[libreoffice-users] Re: Unwanted horizontal white hairline rules in PDF in Mac Preview

2011-12-02 Thread Tinkerer
I have just viewed this in Adobe Acrobat and it is OK I imported it into Libre 3.4.4 on my iMac using Lion and found that the whole page is covered with a grid. The lines are vertical as well as horizontal. Tink -- View this message in context:

[libreoffice-users] Re: Libre Office in IOS5?

2011-12-25 Thread Tinkerer
Krackedpress The iPad2 has 32GB of storage plus whatever you want to pay for in iCloud. I was not thinking of using USB sticks as you cannot connect them directly to an iPad. Transfers would be made through Sync or iCloud. The only problem I see is obtaining a version that will run on the IOS5

[libreoffice-users] Re: Happy New Year all!

2012-01-01 Thread Tinkerer
GĂ©rard Fargeot Brilliant! You made a good start to my New Year. A Happy New Year to you and all on here. Tink. -- View this message in context: http://nabble.documentfoundation.org/Happy-New-Year-all-tp3623969p3624791.html Sent from the Users mailing list archive at Nabble.com. -- For

[libreoffice-users] Re: Problem printing an .xls file

2012-01-27 Thread Tinkerer
It prints fine on my iMac using LO 3.5rc, with a Canon 4700 printer. All the lines are present and there is a 17mm margin on both sides. Tink. -- View this message in context: http://nabble.documentfoundation.org/Problem-printing-an-xls-file-tp3693933p3694406.html Sent from the Users mailing

[libreoffice-users] Export as PDF in LO 3.5

2012-02-08 Thread Tinkerer
Using Mac 10.7.2, Libre Office 3.5 I wish to write the Libre Office Guides as PDF files for insertion in IOS5, iPad. I try to Export to PDF but all I get is a Write error. Write2epub is no longer available and I have heard it cannot cope with formulas and graphics. I have tried converting other

[libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-10 Thread Tinkerer
I have tried converting a single page .odt to Pdf and obtained the same result. Write error Re; converting the Libre User Guide I don't see that size mattered when you are talking about 9MB and I have 4 GB of Ram. Tink. -- View this message in context:

[libreoffice-users] Write2epub

2012-02-10 Thread Tinkerer
I have found Write2epub. All the extensions are on a disc downloaded from Kracked Press. I thought I would try it for converting Libre User Guides to epub format for the iPad. I may not have set it up correctly, but just using the extension as supplied, I failed. The staus bar along the bottom

[libreoffice-users] Re: Export as PDF in LO 3.5

2012-02-10 Thread Tinkerer
I also just tried exporting a small but complex odt (note that I unchecked Create PDF Form) and simple 24 page doc, and both worked perfectly. Where do you find the Create PDF Form? I can only see Export as PDF. I have write permissions to the folder I put the original in, so it should take a

[libreoffice-users] Re: Write2epub

2012-02-10 Thread Tinkerer
KP This is my first effort at using Write2epub. Does it just output the one file for you? Tink. -- View this message in context: http://nabble.documentfoundation.org/Write2epub-tp3732714p3733526.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

  1   2   >