[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: 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] 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: 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] 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: 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] 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: 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: 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: 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: 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] 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] 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

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] 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

[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: 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] 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: 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] 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: 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] 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: 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: 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: 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: 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-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: 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] =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: 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] 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: 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: 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: 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: 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: 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-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-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-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] =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: 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] 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] 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: 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] 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: 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: 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] 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: 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] 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] 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: 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] 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] 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: [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] Re: Bug on change foreground color on Calc (LibO 3.5.4.2 on Mac)

2012-06-03 Thread Tinkerer
I am using LibO 3.5.4.2 on a Mac 10.7.4 and there does not appear to be any problems with colour in Calc, fonts or background. Can you give us an example? Tink. -- View this message in context:

[libreoffice-users] Re: Documents do strange things

2012-05-27 Thread Tinkerer
No JL All Mac Applications have their 'Preferences' where you set up all the customization. It is outside the normal operating menus as it is very rarely used once you have established everything. It is also to a very large extent a System thing. It also means one less item in the menus. Most Mac

[libreoffice-users] Re: Documents do strange things

2012-05-26 Thread Tinkerer
Wanda you can set the default fonts for LO documents using TOOLSOPTIONSLibreOffice WriterBasic Fonts (Western). You can select any installed Western font as the default font. Jay Lozier wrote On 05/25/2012 05:55 PM, Wanda Moore wrote: I use the right click menu or edit in the toolbar. I've

[libreoffice-users] Re: Documents do strange things

2012-05-26 Thread Tinkerer
Something went wrong there. I should have said: There is no Tools Options for LO in the Mac system. To make the correction you need: Libre Office Preferences Writer etc. Tink. -- View this message in context:

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
I have a Mac. System 10.7.4 Libre O, 3.5.4.2 The ^ is Shift 6 and it works perfectly. Enter 3^2 does not work. The correct syntax is =3^2. Tink. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986029.html Sent from the Users mailing list

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
Doesn't =3^2 just give the equation rather than the answer? Weird! It sounds like Mac is good fun to get used to. Regards from Tom :) No Tom =3^2 gives the result, 9. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986041.html Sent from

[libreoffice-users] Re: Is ^ different in Mac??

2012-05-25 Thread Tinkerer
Yes, but what is the difference? Macro basic or Calc formula. Either way, you still need to use the correct syntax. Tink. -- View this message in context: http://nabble.documentfoundation.org/Is-different-in-Mac-tp3985712p3986075.html Sent from the Users mailing list archive at Nabble.com. --

[libreoffice-users] 3.5.3 Mac Templates.

2012-05-14 Thread Tinkerer
I updated from 3.4.6 and though the template path has changed, I had no problems. Assisting a Mac newcomer I installed Lo 3.5.3 for the first time and it does not find a User created template. Either it has saved it in the wrong place or it is looking for it in the wrong place. BTW. I am using Mac

[libreoffice-users] Re: Mac OS X 10.7.3 - Java

2012-03-22 Thread Tinkerer
I have Mac 10.7.3 and Java is installed by Apple version 1.6.0_29 I have always felt it wise to stick to the Apple version concurrent with each system. Using Libre 3.5.2.1, I have no trouble running macros. Tink. -- View this message in context:

[libreoffice-users] Re: Mac OS X 10.7.3 - Java

2012-03-22 Thread Tinkerer
Because you mentioned Memory test, and that is a Java macro, I tried that and it worked. I also used CT2N, Convert Text to Numbers, and that works. Tink. -- View this message in context: http://nabble.documentfoundation.org/Mac-OS-X-10-7-3-Java-tp3847670p3850236.html Sent from the Users mailing

[libreoffice-users] Re: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

2012-03-17 Thread Tinkerer
Hi Cor The way it is now is ideal for what I do, but needs vary. Your question implies that I might need something extra, I cannot think what though. So. If it ain't broke, don't fix it. Best, Tink. -- View this message in context:

[libreoffice-users] Re: handling of quotes before text in Calc 3.4 and 3.5 changed compared to 3.3

2012-03-16 Thread Tinkerer
Cor Showing the apostrophe in front of a number is a great help. If I total a column it immediately tells me which numbers are included in the total and, more important, which numbers are not. Real text does not need the apostrophe. Tink. -- View this message in context:

[libreoffice-users] Grammar checking.

2012-03-12 Thread Tinkerer
I have After the Deadline and Language Tool in my Libre 3.5.1 Extensions. This worked in LO 3.4.5, but not in 3.5.1 My Operating System in Mac 10.7.3 Does this work for anyone else? BTW. My Java is Apple 1.6_029 Al my other extensions appear to be functioning OK. -- View this message in context:

[libreoffice-users] Re: Macintosh Custom Keyboard Shortcuts

2012-03-02 Thread Tinkerer
I only use the system short cuts, which appear in the menus. If you create additional keyboard cuts, then these must be Saved. Having saved them, they must consequentially be Loaded if you wish to use them. If the keys you have assigned conflict with system keys, the system key will be replaced.

[libreoffice-users] Re: LO Calc (3.4.5 and 3.5.0): Displaying sum() Results

2012-02-22 Thread Tinkerer
Make sure there is no space before the = in the formula. Tink. -- View this message in context: http://nabble.documentfoundation.org/LO-Calc-3-4-5-and-3-5-0-Displaying-sum-Results-tp3767030p3767323.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

[libreoffice-users] LO 3.5 Impress - No image.

2012-02-17 Thread Tinkerer
The Mac PPC version of LO 3.5 does not show images in Impress Slide Show. Adding images to a slide produces the error Graphics Filter Not Found. The Mac Intel version does not have this problem, neither does the PPC version if you use LO 3.4.5 Can someone confirm this? Tink. -- View this message

[libreoffice-users] Re: Problem with vertical scroll bar in LibreOffice Writer 3.5 for Mac OS X

2012-02-17 Thread Tinkerer
I am using an Intel Mac and LO 3.5 I was not aware of the fault, but I have since tried loading a 12MB document and yes, there is a problem with the vertical scroll bar. I am not sure that this is a LO fault though. Tink. -- View this message in context:

[libreoffice-users] Re: Write2epub

2012-02-12 Thread Tinkerer
e-letter Writer can be converted to an epub document using the extension Write2epub My experience is it does make a bit of a mess to it though if your document is rather complex. For the benefit of others. I updated my Libre Office to the latest build of 3.5 and now everything appears to be OK

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

2012-02-12 Thread Tinkerer
Cor I updated to the latest build of LO 3.5 and tried using a different name. It worked. I also tried the same with Write2epub and it worked, but the formatting was horrendous. The plot thickens. Tink. -- View this message in context:

[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

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

2012-02-10 Thread Tinkerer
Many thanks. I found it OK, but the result was the same Write error, Unable to write to file. Tink. -- View this message in context: http://nabble.documentfoundation.org/Export-as-PDF-in-LO-3-5-tp3727436p3733551.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

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

2012-02-10 Thread Tinkerer
I am using a Mac, System 10.7.2 I suppose I could try a Log File to see what happened. Tink -- View this message in context: http://nabble.documentfoundation.org/Export-as-PDF-in-LO-3-5-tp3727436p3733690.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

  1   2   >