Re: [libreoffice-users] Re: Libreoffice 5.1.1.3 on Windows 7
Open Computing Language (OpenCL) is a framework for writing programs that execute across heterogeneous platforms consisting of central processing units (CPUs), graphics processing units (GPUs), digital signal processors (DSPs), field-programmable gate arrays (FPGAs) and other processors or hardware accelerators. If OpenCL is active on both, suggest that you are using two differing GPU and/or CPU drivers. One working correctly and the other not. On 4/8/2016 12:29 PM, Henry Sikkema wrote: Thank you Tim! You were correct that it is the OpenCL that made the document fail. So the next questions is... What does Open CL do that is causing the document to fail? But my document works now, so THANK YOU! Henry On 8 April 2016 at 06:39, Tim Lloyd wrote: Have we established this is a problem specific to LO? Are there any other problems on the PC? Apologies if this has been touched on before but I am wondering whether is disk is faulty. Cheers On 08/04/16 19:44, Regina Henschel wrote: Hi Henry, have the failing files something in common? For example a special kind of chart? My candidates for failure are OpenGL (e.g. 3D rendering) and OpenCL (something for calculating, I don't know details). But for testing you should disable that. Make sure your LO is running well with someother file. In Tools > Options Load/Save you will find the item "Load user-specific settings with the document". Disable it. In Tools > Options > LibreOffice > View you can disable OpenGL. In Tools > Options > OpenCL you can disable OpenCL. Restart LO to activate the changes. Now try again to load a problematic file. Kind regards Regina Henry Sikkema schrieb: Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode allows the file to load! So how do I find the offending files or configuration? Henry On 7 April 2016 at 21:19, Andreas Säger wrote: Am 08.04.2016 um 03:02 schrieb Henry Sikkema: I tried a complete re-uninstall and deleted the profile folder and reinstalled and a new profile folder was created when I started LO Calc again. The file still crashes LO Calc on my machine but not on the other machine. Aside from a complete re-install of Windows 7, I do not know what else to attempt. *Henry* Start Windows in protected mode, start LibreOffice and see if protected mode makes any difference. -- 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 -- 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 -- 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: Libreoffice 5.1.1.3 on Windows 7
Thank you Tim! You were correct that it is the OpenCL that made the document fail. So the next questions is... What does Open CL do that is causing the document to fail? But my document works now, so THANK YOU! Henry On 8 April 2016 at 06:39, Tim Lloyd wrote: > Have we established this is a problem specific to LO? Are there any other > problems on the PC? > > Apologies if this has been touched on before but I am wondering whether is > disk is faulty. > > Cheers > > On 08/04/16 19:44, Regina Henschel wrote: > >> Hi Henry, >> >> have the failing files something in common? For example a special kind of >> chart? >> >> My candidates for failure are OpenGL (e.g. 3D rendering) and OpenCL >> (something for calculating, I don't know details). But for testing you >> should disable that. >> >> Make sure your LO is running well with someother file. In Tools > Options >> > Load/Save you will find the item "Load user-specific settings with the >> document". Disable it. >> >> In Tools > Options > LibreOffice > View you can disable OpenGL. >> >> In Tools > Options > OpenCL you can disable OpenCL. >> >> Restart LO to activate the changes. >> >> Now try again to load a problematic file. >> >> Kind regards >> Regina >> >> >> >> Henry Sikkema schrieb: >> >>> Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode >>> allows the file to load! So how do I find the offending files or >>> configuration? >>> >>> Henry >>> >>> On 7 April 2016 at 21:19, Andreas Säger wrote: >>> >>> Am 08.04.2016 um 03:02 schrieb Henry Sikkema: > I tried a complete re-uninstall and deleted the profile folder and > reinstalled and a new profile folder was created when I started LO Calc > again. The file still crashes LO Calc on my machine but not on the > other > machine. > > Aside from a complete re-install of Windows 7, I do not know what else > to > attempt. > > *Henry* > Start Windows in protected mode, start LibreOffice and see if protected mode makes any difference. -- 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 >>> >> >> > > -- > 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 > -- 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: Calc method to change whole column cell content
Am 08.04.2016 um 13:49 schrieb Bruce Hohl: > Method 1 - Using Value() > Use value() function to convert a text string into a number or date. > Copy the result; paste special as number or date. > --- > Method 2 - Search & Replace > Select (highlight) a cell range then: > Using Search & Replace (Ctrl+H): > Search for = .* > Replace = & > Under Other Options: > Y = Current selection only > Y = Regular expressions > Click Replace All > Method 3 - Text to Columns Select a column of cells Call Data>Text to Columns... Choose tab as delimiter and hit [OK] All 3 methods require that your locale setting matches with the data to be converted. ($1,2345.98) requires English(USA) because of the $, the comma as thousands separator and the decimal point. (£1,2345.98) requires English(UK) because of the £, the comma as thousands separator and the decimal point. (€1.2345,98) requires German or French because of the € the point as thousands separator and the decimal comma. menu:Tools>Options>LanguageSettings>Locale (second option) determines the cultual context of all text-to-number conversions. Better you do not import numeric text in the first place. Wrong dates (2/3/1999 vs 3/2/1999) and wrong numbers (1.234 vs 1,234) can be very difficult to convert. Simply check the right locale in the import dialog together with the "detect special numbers" option. -- 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: Calc method to change whole column cell content
Method 1 - Using Value() Use value() function to convert a text string into a number or date. Copy the result; paste special as number or date. --- Method 2 - Search & Replace Select (highlight) a cell range then: Using Search & Replace (Ctrl+H): Search for = .* Replace = & Under Other Options: Y = Current selection only Y = Regular expressions Click Replace All For the csv file Open Calc then open the CSV file from Calc. You can set you file associations on Windows, Linux, etc. so CSV files are always opened by Calc. On Thu, Apr 7, 2016 at 8:48 PM, Andreas Säger wrote: > Am 08.04.2016 um 01:35 schrieb MR ZenWiz: > > I recently began to use the spreadsheet downloads from one of my > > credit unions as it is so far superior to the home-grown method I have > > been using it's not even funny. > > > > (I know, way late... Cries of "luddite" in the background, etc.) > > > > However, in the .csv file they send, the dollar transactions are all > > given as text entries with ($xxx.xx) for negative entries and $xxx.xx > > for positive entries. I don't see a way inside calc either to simply > > convert that to a currency amount or to strip out the leading > > apostrophe/quote mark that inhibits proper evaluation of the field. > > Language = English(USA) > [X] Detect Special Numbers > > > > -- > 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 > -- 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: Libreoffice 5.1.1.3 on Windows 7
Hi, Have you tried a *System Restore* -- choosing a *Restore Point* date prior to the occurrence of the *LibreOffice* problem? This procedure would likely cause *subsequently-installed programs to malfunction* and they would have to be reinstalled. But the *Windows'* *System Restore* has an *"Undo"* feature should it *not help*. Take care. *- John* [image: Inline image 1] John Greenstreet 988 Deep Run Hollow Delray, West Virginia 26714 (540) 686-1039 home *On Facebook*: http://facebook.com/jagreenstreet *On Skype*: john.greenstreet5 * You Tube** videos*: http://www.youtube.com/user/jgreenst1409 *Other Pages Managed on Facebook*: Tommy Gumina, celebrity accordionist - https://www.facebook.com/tommygumina Brooklyn-Curtis Bay MD History - https://www.facebook.com/baybrook Emmett Toomey's Personal Page - https://www.facebook.com/eftoomey John Greenstreet's Personal Page - https://www.facebook.com/jag.personal North River Ruritan - https://www.facebook.com/nrruritan --- Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. John Greenstreet --- -- 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: Libreoffice 5.1.1.3 on Windows 7
Have we established this is a problem specific to LO? Are there any other problems on the PC? Apologies if this has been touched on before but I am wondering whether is disk is faulty. Cheers On 08/04/16 19:44, Regina Henschel wrote: Hi Henry, have the failing files something in common? For example a special kind of chart? My candidates for failure are OpenGL (e.g. 3D rendering) and OpenCL (something for calculating, I don't know details). But for testing you should disable that. Make sure your LO is running well with someother file. In Tools > Options > Load/Save you will find the item "Load user-specific settings with the document". Disable it. In Tools > Options > LibreOffice > View you can disable OpenGL. In Tools > Options > OpenCL you can disable OpenCL. Restart LO to activate the changes. Now try again to load a problematic file. Kind regards Regina Henry Sikkema schrieb: Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode allows the file to load! So how do I find the offending files or configuration? Henry On 7 April 2016 at 21:19, Andreas Säger wrote: Am 08.04.2016 um 03:02 schrieb Henry Sikkema: I tried a complete re-uninstall and deleted the profile folder and reinstalled and a new profile folder was created when I started LO Calc again. The file still crashes LO Calc on my machine but not on the other machine. Aside from a complete re-install of Windows 7, I do not know what else to attempt. *Henry* Start Windows in protected mode, start LibreOffice and see if protected mode makes any difference. -- 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 -- 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: Libreoffice 5.1.1.3 on Windows 7
Hi Henry, have the failing files something in common? For example a special kind of chart? My candidates for failure are OpenGL (e.g. 3D rendering) and OpenCL (something for calculating, I don't know details). But for testing you should disable that. Make sure your LO is running well with someother file. In Tools > Options > Load/Save you will find the item "Load user-specific settings with the document". Disable it. In Tools > Options > LibreOffice > View you can disable OpenGL. In Tools > Options > OpenCL you can disable OpenCL. Restart LO to activate the changes. Now try again to load a problematic file. Kind regards Regina Henry Sikkema schrieb: Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode allows the file to load! So how do I find the offending files or configuration? Henry On 7 April 2016 at 21:19, Andreas Säger wrote: Am 08.04.2016 um 03:02 schrieb Henry Sikkema: I tried a complete re-uninstall and deleted the profile folder and reinstalled and a new profile folder was created when I started LO Calc again. The file still crashes LO Calc on my machine but not on the other machine. Aside from a complete re-install of Windows 7, I do not know what else to attempt. *Henry* Start Windows in protected mode, start LibreOffice and see if protected mode makes any difference. -- 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 -- 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: Libreoffice 5.1.1.3 on Windows 7
Am 08.04.2016 um 04:04 schrieb Henry Sikkema: > Thank you Andreas, for the suggestion. Running Windows 7 in SafeMode > allows the file to load! So how do I find the offending files or > configuration? > > Henry > I don't know. My knowledge about Windows is very limited. -- 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: about libreoffice and tables:
nasrin khaksar wrote: > hi. > i am not shure, because i did not change any format and i dont know > how to do it. > but, only tested docx file and the docx crashed for me in version and > did not crashed in version 5! > without table it was great and opened in all libreoffice versions > which i tested. > Which means you should switch to version 5. LO 5 is much better, especially in the area of compatibility with MS office documents. -- Piet van Oostrum WWW: http://pietvanoostrum.com/ PGP key: [8DAE142BE17999C4] -- 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