Re: [libreoffice-users] Shall we waste twelve more years promoting Free office suites instead of...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 09/11/2013 19:33, Kracked_P_P---webmaster wrote: > Open File Formats > I still have State "agency" people send out MSO 2010 or 2013 Word > .docx files to other agency people who still have MSO 2007 and did > not have the budget to buy 2010 or 2013. They still cannot > understand that there is a limited backwards compatibility to the > .docx formatted files between the newer to the older MSO packages. > If, they were using a package that saved these documents in ODF [or > even .doc for Word] then they would not have these troubles. > Interestingly, during the installation of MS Office 2010 and 2013/365, you are now asked whether you want tthe default document type to be ODF or MS Office format... So either the use of ODF is becoming much more common, or it's the usual Embrace, Extend and Extinguish ploy from MS (Me, Cynical?) -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.22 (MingW32) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJSf1HPAAoJEBd10Bedj4uX5Y8IAJnWLBY3HKAmMDXSte8AMDTc ACLrtXIWAMakxAk2ikpzXLBAByYfV6hRr1RDH4orhkp6HqzRNSY2FPr/s85HlEs9 j3GajHHV/h8slev9LoQ0x/68DHAwtkHERAhLeHje5/qqfrWAPzjPrjnpXim16H3e +dzfOT6+0e7w5fNEqM1TtFvr1HghZYrCEUeWbPC8EcFo+4qBCwVSaLuE5Jhjf0hv 40jWpkTh6NW2jx0aXlsiUBBP66dX5cLETKdX4PozBaR7QXw6mlQ/K5bmFKihmuPJ w/ePBGiq6sa5uHjr9dVanaKh5sEE1xvxAsmhhDYTL94wyG/54AlIzD6UqZdrekY= =rBAk -END PGP SIGNATURE- -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] paste special problem
on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a "paste special" window appear with only: source: unknown source selection: unformatted text and the buttons OK CANCEL HELP the classical paste special dialog box with the classical choices like "text", "numbers", "formulas", "transpose" doesn't appear. how can I get the paste special works??? thanks, :-) ciao :-) pier -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Subject: DRM books
On 11/09/2013 10:49 PM, Daniel wrote: > Is there an extension in LO in order to read DRM ebooks? > > Thanks > > Daniel > LibreOffice really isn't the tool for this. Although you can convert to epub with some plugins, they really aren't very comprehensive and not worth the time, tbh. If you're looking to backup your DRM'd books, then I suggest Calibre with the DeDRM plugin. Calibre is an ebook reader and library manager that will convert books to a variety of formats. It'll also allow you to use LO and Word files as part of your library collection or convert them to e-book format. look here: http://apprenticealf.wordpress.com/2012/09/10/calibre-plugins-the-simplest-option-for-removing-most-ebook-drm/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Calc fields lose formatting
I'm having a consistent problem with some fieldd in a very large Calc spreadsheet. I'm on a Mac and running LO Version 3.6.6.2 (Build ID: f969faf) One of my columns is a wide field with a lot of text. I have my default font set to Geneva and the size to 10. For some reason in some of the cells parts of the text have been set to font size 12. I can go in and by hand select just that portion of the cell, change the font size back to 10 and it looks like it works. Save the file, close LO and re-open. Eventually the font size will change back to 12. It doesn't happen at once and it can take several open and closes before the problem shows up, hence I haven't been able to create a small version that shows the problem. Related is that if I select all the cells (via click in the upper left hand corner of the spreadsheet and then try to set the font and size none of the contents of the cells will change to the new font or size options. Can anyone offer any suggestions on how to: 1 - fix the edit of individual cells so that once a font change is made it sticks, permanently 2 - tell me how to globally change the entire document to be a specific font and or size and have that actually work. Thanks Eugenie (Oogie) McGuire Desert Weyr http://www.desertweyr.com/ Paonia, CO USA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Subject: DRM books
Daniel wrote: > Is there an extension in LO in order to read DRM ebooks? Why would you want to read ebooks in an office suite, when there are already many apps for that task? BTW, other than library books, I try to avoid DRM. I don't have a single DRM book that I own a copy of. The books I buy, I get from O'Reilly, which are DRM free. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Subject: DRM books
Yeah, kinda OT, but Calibre is the best program for this. you can even e-mail your books to your Kindle. On 11/10/2013 7:20 AM, zuke wrote: On 11/09/2013 10:49 PM, Daniel wrote: Is there an extension in LO in order to read DRM ebooks? Thanks Daniel LibreOffice really isn't the tool for this. Although you can convert to epub with some plugins, they really aren't very comprehensive and not worth the time, tbh. If you're looking to backup your DRM'd books, then I suggest Calibre with the DeDRM plugin. Calibre is an ebook reader and library manager that will convert books to a variety of formats. It'll also allow you to use LO and Word files as part of your library collection or convert them to e-book format. look here: http://apprenticealf.wordpress.com/2012/09/10/calibre-plugins-the-simplest-option-for-removing-most-ebook-drm/ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] paste special problem
On 2013-11-10 6:53 AM, yahoo-pier_andreit wrote: on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a "paste special" window appear with only: source: unknown source selection: unformatted text and the buttons OK CANCEL HELP the classical paste special dialog box with the classical choices like "text", "numbers", "formulas", "transpose" doesn't appear. how can I get the paste special works??? I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)... It is extremely annoying, and sometimes even prevents me from getting something done. Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] paste special problem
on my opensuse 12.3 and libreoffice Version 4.0:build-305 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a "paste special" window appear with only: source: unknown source selection: unformatted text and the buttons OK CANCEL HELP the classical paste special dialog box with the classical choices like "text", "numbers", "formulas" doesn't appear. how can I get the paste special works??? thanks, :-) ciao :-) pier -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] paste special problem
On 11/10/2013 06:00 PM, Tanstaafl wrote: On 2013-11-10 6:53 AM, yahoo-pier_andreit wrote: on my opensuse 12.3 and libreoffice Version 4.0:build-305 and also with Version: 4.1.1.2 paste special doesn't works any more. if I select a group of cells with formulas, move in another position and I perform paste special, a "paste special" window appear with only: source: unknown source selection: unformatted text and the buttons OK CANCEL HELP the classical paste special dialog box with the classical choices like "text", "numbers", "formulas", "transpose" doesn't appear. how can I get the paste special works??? I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)... It is extremely annoying, and sometimes even prevents me from getting something done. Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it... now for me is extremely reproducible, it never works:-) :-) :-) :-) now "paste special" and alsoo "simple paste" doesn't works, they paste only values, not formula or other I don't know how to come back to a working situation. may be it could be some config file to delete, but I cannot find it, in my /home I found a ./libreoffice folder, I renamed it but nothing change:-) :-) :-) -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Engaging users: initial results of the survey
Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis: http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/ Thank you for your participation! -- Charles-H. Schulz Co-founder, The Document Foundation, Kurfürstendamm 188, 10707 Berlin Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts Legal details: http://www.documentfoundation.org/imprint Mobile Number: +33 (0)6 98 65 54 24. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] paste special problem
On 2013-11-10 1:26 PM, yahoo-pier_andreit wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)... It is extremely annoying, and sometimes even prevents me from getting something done. Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it... now for me is extremely reproducible, it never works:-) :-) :-) :-) now "paste special" and alsoo "simple paste" doesn't works, they paste only values, not formula or other I don't know how to come back to a working situation. may be it could be some config file to delete, but I cannot find it, in my /home I found a ./libreoffice folder, I renamed it but nothing change:-) :-) :-) The very first thing I tried was deleting the .config and letting LO create a new one... no joy... -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Subject: DRM books
+1 there are several threads about this in the archive as well On 11/10/13, 5:20 AM, zuke wrote: > On 11/09/2013 10:49 PM, Daniel wrote: >> Is there an extension in LO in order to read DRM ebooks? >> >> Thanks >> >> Daniel >> > LibreOffice really isn't the tool for this. Although you can convert to > epub with some plugins, they really aren't very comprehensive and not > worth the time, tbh. > > If you're looking to backup your DRM'd books, then I suggest Calibre > with the DeDRM plugin. Calibre is an ebook reader and library manager > that will convert books to a variety of formats. It'll also allow you > to use LO and Word files as part of your library collection or convert > them to e-book format. > > look here: > http://apprenticealf.wordpress.com/2012/09/10/calibre-plugins-the-simplest-option-for-removing-most-ebook-drm/ > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] CALC convert text to numbers
I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and help at Libre Office are less than useful. https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that this conversion happens automatically but it sure doesn't I found reference to a value function, but no information on how to apply it to this data. I tried just changing the format of the cells to be number but that didn't do anything at all. I've also attempted various styles of paste special but still it doesn't work. There has got to be a way to quickly say this text is all really numbers and get it working! Please help Eugenie (Oogie) McGuire Desert Weyr http://www.desertweyr.com/ Paonia, CO USA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates That extension should do the trick - we're trying to incorporate it into the core code but so far you need the extension. All the best, Joel On 11/10/2013 01:57 PM, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and help at Libre Office are less than useful. https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that this conversion happens automatically but it sure doesn't I found reference to a value function, but no information on how to apply it to this data. I tried just changing the format of the cells to be number but that didn't do anything at all. I've also attempted various styles of paste special but still it doesn't work. There has got to be a way to quickly say this text is all really numbers and get it working! Please help Eugenie (Oogie) McGuire Desert Weyr http://www.desertweyr.com/ Paonia, CO USA -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Engaging users: initial results of the survey
On 11/10/2013 1:46 PM, Charles-H. Schulz wrote: Hello, As there were some exchanges about the survey here and as I advertised it on this mailing list as well, I thought you might be interested by my initial analysis: http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/ Thank you for your participation! I'm glad you think it was such a great success. I personally feel you would have a much larger response had the questionnaire been better formulated. So many of the questions' multiple choice answers had no choice which reflected my situation/experience. After a while I decided not to continue with it and discarded it because it was obvious that it would not have reflected my situation/experience (which I presume was the goal). I suppose it is possible that for some questions there are only a few possible answers, but for most, the choice of "other" should be made available, or possibly even a blank line to fill in. -- Dale Erwin Jr. 28 de Julio 657, Depto. 03 Magdalena del Mar, Lima 17 PERU http://leather.casaerwin.org -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Engaging users: initial results of the survey
"Charles-H. Schulz": The only way users can contribute is when they are paying. If a developer is paid for non-user-related applications, it will have the ubiquitous opensource mentality: "I'm a GOD and you insolent worm will crawl on all fours at my feet because it pleases me to do so". Obviously the commercial products which have incident support with developers and actually implement what users ask of them basing on what is asked and not on what is trivial to implement, will live LO in the gutter. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
> I have a spreadsheet that is the output of a SQLite Database on Android. It
> contains numbers that have been formatted as text. When I copy the columns
> into my LibreOffice Spreadsheet I want to make sure that they are interpreted
> as numbers.
>
> However they come in as text and the manuals and help at Libre Office are
> less than useful.
>
> https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that
> this conversion happens automatically but it sure doesn't
>
> I found reference to a value function, but no information on how to apply it
> to this data.
>
> I tried just changing the format of the cells to be number but that didn't
> do anything at all.
>
> I've also attempted various styles of paste special but still it doesn't
> work.
>
> There has got to be a way to quickly say this text is all really numbers and
> get it working!
>
> Please help
>
If the numbers (formatted as text) are already saved in your
spreadsheet, I would normally suggest a simple procedure involving
"paste special" and multiply (by "1"). This has worked for me in
several other spreadsheet tools.
But Calc will (currently?) fail, because Calc adds a single quotation
mark at the beginning of the cell. So what seems to be just "1"
(without the double quotation marks), in Calc actually is "'1"
(without the double quotation marks, but including the single initial
single quotation mark). If you currently don't see the initial single
quotation mark, you could see it (in the formula bar) by copying one
of these cells and pasting it in a new one (among other options).
This single quotation mark will even remain after changing the format
from 'text' to 'numbers', so this is what makes the solution less
than simple.
You could select the relevant cells, change their format and then
'find and replace' on that same selection. But, since this is a
special (hidden) character, I'm not sure how to make it happen ('find
and replace' might not find the specific character).
As a simple user, I see this "hidden" addition of the initial single
quotation mark as a _BUG_, and as one of those basic "features" that
work poorly in LibreOffice Calc than in several other spreadsheet
tools. I don't know if this behavior can be "corrected" or improved.
Now, if your data is not yet imported into Calc, you can change the
type of data from "standard" or "text" to "numbers" during the
'import' procedure. This task is simple enough if the numbers are
already located under the same "column" in the csv / text file that
you use as source to import the data into Calc.
All the above comments are relevant only if you don't need to do the
conversion in a repeatedly, scripted / batch / automatic way.
Regards,
Ady.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On Mon, 2013-11-11 at 02:56 +0200, Ady wrote:
> > I have a spreadsheet that is the output of a SQLite Database on Android. It
> > contains numbers that have been formatted as text. When I copy the columns
> > into my LibreOffice Spreadsheet I want to make sure that they are
> > interpreted as numbers.
> >
> > However they come in as text and the manuals and help at Libre Office are
> > less than useful.
> >
> > https://help.libreoffice.org/Calc/Converting_Text_to_Numbers implies that
> > this conversion happens automatically but it sure doesn't
> >
> > I found reference to a value function, but no information on how to apply
> > it to this data.
> >
> > I tried just changing the format of the cells to be number but that didn't
> > do anything at all.
> >
> > I've also attempted various styles of paste special but still it doesn't
> > work.
> >
> > There has got to be a way to quickly say this text is all really numbers
> > and get it working!
> >
> > Please help
> >
>
> If the numbers (formatted as text) are already saved in your
> spreadsheet, I would normally suggest a simple procedure involving
> "paste special" and multiply (by "1"). This has worked for me in
> several other spreadsheet tools.
>
> But Calc will (currently?) fail, because Calc adds a single quotation
> mark at the beginning of the cell. So what seems to be just "1"
> (without the double quotation marks), in Calc actually is "'1"
> (without the double quotation marks, but including the single initial
> single quotation mark). If you currently don't see the initial single
> quotation mark, you could see it (in the formula bar) by copying one
> of these cells and pasting it in a new one (among other options).
>
> This single quotation mark will even remain after changing the format
> from 'text' to 'numbers', so this is what makes the solution less
> than simple.
>
> You could select the relevant cells, change their format and then
> 'find and replace' on that same selection. But, since this is a
> special (hidden) character, I'm not sure how to make it happen ('find
> and replace' might not find the specific character).
>
> As a simple user, I see this "hidden" addition of the initial single
> quotation mark as a _BUG_, and as one of those basic "features" that
> work poorly in LibreOffice Calc than in several other spreadsheet
> tools. I don't know if this behavior can be "corrected" or improved.
>
> Now, if your data is not yet imported into Calc, you can change the
> type of data from "standard" or "text" to "numbers" during the
> 'import' procedure. This task is simple enough if the numbers are
> already located under the same "column" in the csv / text file that
> you use as source to import the data into Calc.
>
> All the above comments are relevant only if you don't need to do the
> conversion in a repeatedly, scripted / batch / automatic way.
>
> Regards,
> Ady.
>
Hi,
If you are importing a txt or csv file into Calc you can use INSERT >>
SHEET FROM FILE. The first part of the wizard will you can click OK. The
second dialog has a section "Other Options". In this section check
"Detect Special Numbers". There is a preview screen which shows what the
data will look like. If the column has the same data type (numbers,
text, datetime) Calc will convert the raw text into a more appropriate
data type. Also, once checkbox is selected, Calc will remember the
setting for subsequent imports.
This may be easier than cut/paste special.
--
Jay Lozier
jsloz...@gmail.com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 14:57 10/11/2013 -0700, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and help at Libre Office are less than useful. I found reference to a value function, but no information on how to apply it to this data. I tried just changing the format of the cells to be number but that didn't do anything at all. I've also attempted various styles of paste special but still it doesn't work. There has got to be a way to quickly say this text is all really numbers and get it working! There are various ways to do this, and you may want to experiment in order to discover what suits your work flow. The VALUE() function? Yes, you can use that: o In a spare column, row, or range (as appropriate), or even on another sheet, enter =VALUE(Xn) - where Xn is the start of the range. o Fill the formula down the column, along the row, or through the range. You now have a copy of your data - but as numbers, not text. o If desired, copy the numeric values and paste them back over the originals, but using Edit | Paste Special... (or right-click | Paste Special... or Ctrl+Shift+V) instead of ordinary Paste. o In the Paste Special dialogue, remove the tick from "Paste all" if necessary and ensure that Numbers and Formats are ticked but Formulas is not ticked. o You can now delete the temporary values or delete their rows or columns if you wish. No, changing the format of the cells will not help: a cell's format affects the way its value is displayed and the way inserted values are handled, but not the actual contents of the cell. Another easy way is via a comma-separated-value file. Save the sheet with your rogue text values using File | Save As... and selecting "Text CSV (.csv)" for "Save as type:". Now open the resulting (temporary, scratch) CSV file in LibreOffice and you will have numeric values that you can copy where you need them. Yes - as has already been suggested - you could alternatively import the CSV file as an additional sheet in your existing spreadsheet document. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On Mon, 11 Nov 2013 02:56:51 +0200 Ady wrote: > As a simple user, I see this "hidden" addition of the initial single > quotation mark as a _BUG_, and as one of those basic "features" that > work poorly in LibreOffice Calc than in several other spreadsheet > tools. I don't know if this behavior can be "corrected" or improved. As far as I understand it, the "hidden" initial quotation mark is what marks the contents of the cell as text. This is the same in MS Excel, IIRC. So basically, this isn't a bug, but intended behaviour, to give you a way to specify that a number should be interpreted as text and not as a number. For example, if you enter "0283", the leading zero will always be stripped, because it is interpreted as a number and the leading zero is superfluous, but if you enter "'0283", then this means you have entered a text string and the leading zero is kept. The format of the cell doesn't change this behavior, it only changes the *display* of the contents, not the interpretation of the contents. At least, as I understand it. Paul -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
> If you are importing a txt or csv file into Calc you can use INSERT >> > SHEET FROM FILE. The first part of the wizard will you can click OK. The > second dialog has a section "Other Options". In this section check > "Detect Special Numbers". There is a preview screen which shows what the > data will look like. If the column has the same data type (numbers, > text, datetime) Calc will convert the raw text into a more appropriate > data type. Also, once checkbox is selected, Calc will remember the > setting for subsequent imports. > > This may be easier than cut/paste special. > -- Yes, as I said, if there is still a need to 'import', that's simple enough. But if the data is already in a spreadsheet, there is a well-known "paste special" simple procedure. It works in other (more than one) spreadsheet tools and usually is fast enough. The more important matter is that LO Calc is making this simple conversion more complicated than necessary. I wonder if this should be reported as a bug / enhancement, so the behavior is changed / improved. Any comment from Calc developers would be really appreciated. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 14:57 10/11/2013 -0700, Oogie McGuire wrote: I have a spreadsheet that is the output of a SQLite Database on Android. It contains numbers that have been formatted as text. When I copy the columns into my LibreOffice Spreadsheet I want to make sure that they are interpreted as numbers. However they come in as text and the manuals and help at Libre Office are less than useful. I found reference to a value function, but no information on how to apply it to this data. I tried just changing the format of the cells to be number but that didn't do anything at all. I've also attempted various styles of paste special but still it doesn't work. There has got to be a way to quickly say this text is all really numbers and get it working! Oh, here's another way: o Ensure that the cells with your rogue values are actually formatted as numbers. (No, that won't solve your problem, but bear with me.) o Select the cells. o Search for .* and replace with & - but click More Options and tick "Current selection only" and "Regular expressions". The text values are reinserted in their cells, but are also reinterpreted - as numbers. I trust this (also) helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 02:56 11/11/2013 +0200, Ady Noname wrote:
If the numbers (formatted as text) are already saved in your
spreadsheet, I would normally suggest a simple procedure involving
"paste special" and multiply (by "1"). This has worked for me in
several other spreadsheet tools. But Calc will (currently?) fail,
because Calc adds a single quotation mark at the beginning of the
cell. So what seems to be just "1" (without the double quotation
marks), in Calc actually is "'1" (without the double quotation
marks, but including the single initial single quotation mark).
No, the reason this fails is because you are trying to multiply text
by a number. If this worked, the original problem would not exist:
the user would be able to involve his text values in mathematical
formulae directly. And it's wrong to think of that leading single
quotation mark as actually being in the cell. Preceding a numeric
value by a quotation mark is how you indicate in typing that you want
the value to remain as text and that you do not want the value
interpreted as a number. It's also the way that values shown in the
Input Line that might appear to be numbers are indicated actually to
be text. But there is no quote in the cell.
You could select the relevant cells, change their format and then
'find and replace' on that same selection. But, since this is a
special (hidden) character, I'm not sure how to make it happen
('find and replace' might not find the specific character).
Indeed: it won't find it because it's not there!
As a simple user, I see this "hidden" addition of the initial single
quotation mark as a _BUG_, and as one of those basic "features" that
work poorly in LibreOffice Calc than in several other spreadsheet
tools. I don't know if this behavior can be "corrected" or improved.
Aaargh! The quotation mark is not added to the cell, but is used to
indicate that you have preserved the value as text, not had it
interpreted as a number. That's most definitely a feature, not a
bug! There are genuine uses for this: if you live in Newark, New
Jersey, USA, your ZIP code may be the five-character text string
07102. But the postal system will not like your misrepresenting this
as 7102 - the number seven thousand, one hundred and two.
Brian Barker
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
> > As a simple user, I see this "hidden" addition of the initial single > > quotation mark as a _BUG_, and as one of those basic "features" that > > work poorly in LibreOffice Calc than in several other spreadsheet > > tools. I don't know if this behavior can be "corrected" or improved. > > As far as I understand it, the "hidden" initial quotation mark is what > marks the contents of the cell as text. This is the same in MS Excel, > IIRC. So basically, this isn't a bug, but intended behaviour, to give > you a way to specify that a number should be interpreted as text and > not as a number. > > For example, if you enter "0283", the leading zero will always be > stripped, because it is interpreted as a number and the leading zero is > superfluous, but if you enter "'0283", then this means you have entered > a text string and the leading zero is kept. The format of the cell > doesn't change this behavior, it only changes the *display* of the > contents, not the interpretation of the contents. At least, as I > understand it. > > Paul > Well, yes, but no :). In Excel and other spreadsheet tools, you could: 1_ In an auxiliary non-formatted cell, insert the number 1. 2_ Copy that auxiliary cell. 3_ Select the cells with numbers that are currently formatted as 'text' that you want to convert. 4_ Paste special (all), multiply. 5_ Delete the auxiliary cell. If the desired format is not just a 'general' number, then you can format the auxiliary cell before copying it. This simple procedure cannot be used in Calc, just because this "hidden" single quotation mark. This procedure is successful in other spreadsheet tools that use the single quotation mark too. So, why not in Calc? BTW, the quotation mark is not necessary for all cells containing numbers formatted as text, but that's off-topic here. My point is still relevant: the aforementioned procedure should be plausible in Calc, just as it is in other spreadsheet tools. There are workarounds, like using the 'VALUE' function in an auxiliary column and then copy+paste back; yet I still wonder about this hidden (annoying) single quotation mark. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On Mon, 2013-11-11 at 03:40 +0200, Paul wrote: > On Mon, 11 Nov 2013 02:56:51 +0200 > Ady wrote: > > > As a simple user, I see this "hidden" addition of the initial single > > quotation mark as a _BUG_, and as one of those basic "features" that > > work poorly in LibreOffice Calc than in several other spreadsheet > > tools. I don't know if this behavior can be "corrected" or improved. > > As far as I understand it, the "hidden" initial quotation mark is what > marks the contents of the cell as text. This is the same in MS Excel, > IIRC. So basically, this isn't a bug, but intended behaviour, to give > you a way to specify that a number should be interpreted as text and > not as a number. > > For example, if you enter "0283", the leading zero will always be > stripped, because it is interpreted as a number and the leading zero is > superfluous, but if you enter "'0283", then this means you have entered > a text string and the leading zero is kept. The format of the cell > doesn't change this behavior, it only changes the *display* of the > contents, not the interpretation of the contents. At least, as I > understand it. > > Paul > US zip codes (postal codes) may have a leading zero. Why not set a cell to the formula "=right(len(CELL)-1) which returns the all the characters except for the first. -- Jay Lozier jsloz...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 21:17 10/11/2013 -0500, Jay Lozier wrote: Why not set a cell to the formula =right(len(CELL)-1) which returns the all the characters except for the first. That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote mark because it's *not there*! The simpler formula =RIGHT(Xn;LEN(Xn)) would work, but that's just a complicated way of saying =VALUE(Xn). Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On 11/10/2013 06:32 PM, Brian Barker wrote: At 21:17 10/11/2013 -0500, Jay Lozier wrote: Why not set a cell to the formula =right(len(CELL)-1) which returns the all the characters except for the first. That's =RIGHT(Xn;LEN(Xn)-1) - but that won't strip the single quote mark because it's *not there*! The simpler formula =RIGHT(Xn;LEN(Xn)) would work, but that's just a complicated way of saying =VALUE(Xn). Brian Barker Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a nice gui All the best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
> Why not set a cell to the formula "=right(len(CELL)-1) which returns the > all the characters except for the first. > -- No, that won't work. You probably meant: =RIGHT(A1,LEN(A1)-1) where "A1" is the 'text' cell. But that one will fail too, because the initial single quotation mark is not really part of the content of the cell. (Note: it might work in some particular situation, but it is not a generic method.) The 'VALUE' method is a valid workaround, but it might be a "heavy" method, depending on the amount of data. I would prefer the "'paste special'+multiply by 1" method to work. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 18:43 10/11/2013 -0800, Joel Madero wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a nice gui Oh, that's easy: 1. List subscribers will have read earlier suggestions and are intelligent enough to ignore later ones if they prefer. 2. Different methods are appropriate in different circumstances - and subscribers other than the original questioner may find them helpful to their different needs. 3. It's important that questionable statements made on a public list read by many (and indeed archived) are challenged. (Anyone is welcome to trash this message if desired!) Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On 11/10/2013 07:05 PM, Brian Barker wrote: At 18:43 10/11/2013 -0800, Joel Madero wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a nice gui Oh, that's easy: 1. List subscribers will have read earlier suggestions and are intelligent enough to ignore later ones if they prefer. 2. Different methods are appropriate in different circumstances - and subscribers other than the original questioner may find them helpful to their different needs. 3. It's important that questionable statements made on a public list read by many (and indeed archived) are challenged. (Anyone is welcome to trash this message if desired!) Brian Barker :-D Fair enough. I was actually just curious if there is a benefit to the formulas over the text to number as I always use it but would change if there was a benefit to some other method :-D Thanks for explaining! All the best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
> Why is everyone straying away from the fact that there is a simple > extension developed by Cor (one of our brilliant devs) which > accomplishes all of this? Just curious if there's a benefit to doing > these formula techniques instead of just pushing a button on a nice gui I could ask you the same type of question regarding "paste special + multiply by 1" method. A user might not know of the extension, or about any extension for that matter. A user might not use extensions, ever. Why would anyone need to search, install and use an extension, when other spreadsheet tools can apply a well-known "multiply by 1" method? In other words, if very simple spreadsheet tools (not just Excel) can use a very simple and well-known method, perhaps instead of thinking of how to incorporate the CT2N extension into the core in Calc, the same time could be invested to make Calc work "as expected" with "paste special"? To be clear, I'm not complaining, just posting my thoughts. Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
On 11/10/2013 07:10 PM, Ady wrote: Why is everyone straying away from the fact that there is a simple extension developed by Cor (one of our brilliant devs) which accomplishes all of this? Just curious if there's a benefit to doing these formula techniques instead of just pushing a button on a nice gui I could ask you the same type of question regarding "paste special + multiply by 1" method. A user might not know of the extension, or about any extension for that matter. A user might not use extensions, ever. Why would anyone need to search, install and use an extension, when other spreadsheet tools can apply a well-known "multiply by 1" method? In other words, if very simple spreadsheet tools (not just Excel) can use a very simple and well-known method, perhaps instead of thinking of how to incorporate the CT2N extension into the core in Calc, the same time could be invested to make Calc work "as expected" with "paste special"? To be clear, I'm not complaining, just posting my thoughts. Regards, Ady. Thoughts are always appreciated in our community :-D Best, Joel -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: paste special problem
El 2013-11-10 01:59 p.m., Tanstaafl escribió: On 2013-11-10 1:26 PM, yahoo-pier_andreit wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)... It is extremely annoying, and sometimes even prevents me from getting something done. Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it... now for me is extremely reproducible, it never works:-) :-) :-) :-) now "paste special" and alsoo "simple paste" doesn't works, they paste only values, not formula or other I don't know how to come back to a working situation. may be it could be some config file to delete, but I cannot find it, in my /home I found a ./libreoffice folder, I renamed it but nothing change:-) :-) :-) The very first thing I tried was deleting the .config and letting LO create a new one... no joy... In Windows, I have had a different but probably connected problem. I copy from an application to paste in LO Calc, but the menu is greyed. That is, like when I have not copy anithing yet, but in reality the copy was done. What works me is close and reload LO. Then, I can copy and paste again. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Engaging users: initial results of the survey
> Hello, > > As there were some exchanges about the survey here and as I advertised > it on this mailing list as well, I thought you might be interested by > my initial analysis: > http://standardsandfreedom.net/index.php/2013/11/10/users-the-final-frontier/ > > Thank you for your participation! > > -- If I may... There are many ways for users to communicate: LibreOffice forum, Ask LibreOffice, several LibreOffice mailing lists, Nabble, wiki, Bugzilla, and several irc channels. The problem is, IMHO, they are sometimes "too many" and "too complicated". Let me explain with a simple example. In the release notes for LO 4.1.3, it said that the release was bit by bit the same as "RC3". Well, that was incorrect, as it is the same as 4.1.3.2, a.k.a. RC2 (there was no 4.1.3.3). What a casual reader needs to do if he happens to catch the "typo"? Can he easily report the one-character mistake? Does anyone think that this typo deserves opening a new bug report in Bugzilla? For each contact method mentioned above (each ML, Nabble, wiki, Bugzilla, forum,...), a user needs to go through an additional sign up, sometimes requiring multiple steps. In our example (RC3 typo), do you think a casual reader would go through a sign up process just to report one wrong character? Just as an example, I am subscribed to the users ML, and I found annoying to go through additional sign-ups for Nabble. I can understand that there might be relevant reasons for this; but it is still annoying :). On the other hand, if a user is interested in Writer only, having to receive emails regarding Draw (or anything else than Writer) is one reason not to subscribe to the users ML. So perhaps separated per-program lists should be available, instead of one unified "users" ML? (I am not necessarily recommending it; just mentioning such potential situation.) Then we have several irc channels, but none of those channels targeted to users are really active, ever (e.g. #libreoffice and/or #libreoffice-qa). So what's the point of publishing the "existence" of those irc channels if they are not really open with someone from the LibreOffice Team being present in the channel? I'm not saying answers should be "on real time". For irc to be relevant for users, someone at least should maintain the channel open and saving logs, checking it once a day or so. This is one contact method that could be easily used to report the typo mentioned in our example. One day is one typo, another day is another typo. Then there is some minor low-priority bug in the installer (e.g adding a link to the desktop even when the user unchecked the corresponding box during the installation process). Then the wiki might need some little correction or update... For each minor issue, a user could just think "not worth going through all the sign up troubles for each different service". As a consequence, none of those little corrections are reported / performed. What's the point of "Ask LibreOffice" if each question is seen, say, 3 times in a one week period? Most questions are unanswered. Similarly with LibreOffice forum. A user might not bother to sign up to such a method that is hardly ever used by relevant users; and if it goes through it anyway and no answer is provided (as it is the case with most "Ask LibreOffice" topics), it would probably generate a rejection response towards LibreOffice. If a user signs up and opens a bug report, that's because it is significant for him. Is this procedure relevant if the bug report is left unanswered for 2 years? Is this user going to keep reporting additional bugs? Evidently, solving bugs requires man power, so finding a simpler method to report "you have a st*pid typo" might help reduce wasted time, for both developers and users. So, making the contact methods more relevant, easier (unified?) sign up procedures and actually maintaining "active" and relevant the different contact channels would contribute to receive more feedback and eventually reduce wasted time. I am writing not to complain, but to voice my personal view of some of the ways to improve user's involvement in LibreOffice. I admit I am not sure if any of these changes would be the most effective use of man-power, so I'm not going to call these "recommendations". These might be potential considerations for potential improvements. Whether they are _effective_ use of man-power, I don't really know. Thank you and Best Regards, Ady. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: paste special problem
On 2013-11-11 17:09, Denis Navas Vega wrote: El 2013-11-10 01:59 p.m., Tanstaafl escribió: On 2013-11-10 1:26 PM, yahoo-pier_andreit wrote: On 11/10/2013 06:00 PM, Tanstaafl wrote: I have been having serious problems with 'Paste Special' working, then not working, then working again, on many different spreadsheets (most if not all created a long time ago, some as old as Openoffice 1.x)... It is extremely annoying, and sometimes even prevents me from getting something done. Been meaning to post a bug, but the problem is, I have not found a reliable way to reproduce it... now for me is extremely reproducible, it never works:-) :-) :-) :-) now "paste special" and alsoo "simple paste" doesn't works, they paste only values, not formula or other I don't know how to come back to a working situation. may be it could be some config file to delete, but I cannot find it, in my /home I found a ./libreoffice folder, I renamed it but nothing change:-) :-) :-) The very first thing I tried was deleting the .config and letting LO create a new one... no joy... In Windows, I have had a different but probably connected problem. I copy from an application to paste in LO Calc, but the menu is greyed. That is, like when I have not copy anithing yet, but in reality the copy was done. What works me is close and reload LO. Then, I can copy and paste again Hi. I found on linux the clip board settings can affect pasting. I don't have it completely figured. I had it at one time that ctl-V would paste the formula the first time and then the text value the next paste. Now it pastes formula each time. Steve -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
Le 10/11/2013 22:57, Oogie McGuire a écrit :
> I have a spreadsheet that is the output of a SQLite Database on
> Android. It contains numbers that have been formatted as text. When I
> copy the columns into my LibreOffice Spreadsheet I want to make sure
> that they are interpreted as numbers.
This will do quite easily:
Call the menu Data / Numbers as text (freely translated from my FR
install) then just click OK in the window that opens without changing
anything. This should do the trick.
Another way I often use when the import is made on a regular basis, is
to create what I call an "exploitation sheet".
You create a new spreadsheet and insert data there from the spreadsheet
you got from the import. The formulas will then look like
='file:///home/jf/Documents/Imports/MyImport.ods'#$'Sheet1'.A2
Then copy down and right and you're set.
What is interesting is that you may add some data handling when linking
the cells: you may have
=CNUM('file:///home/jf/Documents/Imports/MyImport.ods'#$'Sheet1'.A2)
which would automagically convert the text data into numerical data
without having to bother each and every time a new import comes.
You may also ignore any superfluous column, and so on.
For the ease of use, make sure to have both spreadsheets in the same
directory.
Note that:
-- this works only if the imported data is consistent (same columns at
the same place) and the data file must be uniformly named.
-- the imported data must be in a real file on disk.
HTH,
--
Jean-Francois Nifenecker, Bordeaux
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
ooops! forgot to specify the first step: 1. select the column to set as numbers first. Le 11/11/2013 07:03, Jean-Francois Nifenecker a écrit : > 2. do that: > Call the menu Data / Numbers as text (freely translated from my FR > install) then just click OK in the window that opens without changing > anything. This should do the trick. -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote: Call the menu Data / Numbers as text (freely translated from my FR install) ... In English, that's Data | Text to Columns... . Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] CALC convert text to numbers
Le 11/11/2013 07:44, Brian Barker a écrit : > At 07:03 11/11/2013 +0100, Jean-Francois Nifenecker wrote: >> Call the menu Data / Numbers as text (freely translated from my FR >> install) ... > > In English, that's Data | Text to Columns... . > thanks! -- Jean-Francois Nifenecker, Bordeaux -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
