Re: [libreoffice-users] Re: Calc method to change whole column cell content

[James E. Lang]

And there *are* text editors (even on Windows) that use regular expressions and 
thus can perform the transformation relatively painlessly.

All the best!

-- 
Jim

-Original Message-
From: Tom Davies 
To: users@global.libreoffice.org
Sent: Wed, 13 Apr 2016 8:36
Subject: Re: [libreoffice-users] Re: Calc method to change whole column cell 
content

Hi :)
CSV format can be easily edited in normal text-editors before opening in
Calc.  Sometimes its easier to use a simpler tool to do a part of the job
rather than use a complicated route in a heavier tool such as Calc.
Regards from
Tom :)


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

[Andreas Säger]

Am 13.04.2016 um 12:32 schrieb Tom Davies:
> Hi :)
> CSV format can be easily edited in normal text-editors before opening in
> Calc.  Sometimes its easier to use a simpler tool to do a part of the job
> rather than use a complicated route in a heavier tool such as Calc.
> Regards from
> Tom :)

Really? And how do you convert (£1,234.98) into -1234.98 in columns 3,
17 and 23 across thousands of rows using a text editor? Are YOU able to
do this actually?
Don't you think that checking "English(UK)" and "Interprete Special
Numbers" is by far easier?


-- 
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] Columns width pasting [Calc]

[Tom Davies]

Hi :)
WooHooo!!  Congrats on figuring it out and fixing it yourself!

Sorry no-one was able to help you on this one, or even acknowledge your
posts.

Also, thanks for letting us know how you solved it too :)  Hopefully others
with the same problem stand some chance of finding this in the archives in
the future.  So, top-marks!
Thanks, congrats and regards from
Tom :)
On 11 Apr 2016 21:35, "gordom"  wrote:

> I figured it out. The problem was caused by the filter being enabled. I
> filtered out some data before attempting to copy them. When the filter is
> turned off everything seems to work OK: I can copy and paste columns format
> (i.e. its width).
> Regards,
> gordom
>
>
> W dniu 2016-04-11 o 20:59, Bruce Hohl pisze:
>
>> Seems to work with LO 5.1.0.3 on Windows 7  I can select a column then
>> Ctrl+C; go to another sheet within the "workbook"; select a column then
>> paste special formats  and the column is re-sized to the same width as
>> the source.  Maybe someone has your exact versions and can check.
>>
>> On Mon, Apr 11, 2016 at 10:50 AM, gordom  wrote:
>>
>> I should mention that I use LO 5.1.1.3 on Win XP machine.
>>> Regards,
>>> gordom
>>>
>>> W dniu 2016-04-11 o 16:47, gordom pisze:
>>>
>>> Hello Everyone.
>>>
 Just recently I upgraded LO ver. 4 to 5 and have a problem with Calc
 from that moment on. I can’t paste a columns width from one sheet to
 another. Paste Special > Formats does not give a desired outcome now.
 Any help will be appreciated.
 Regards,

 gordom



>>> --
>>> 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: Calc method to change whole column cell content

[Tom Davies]

Hi :)
CSV format can be easily edited in normal text-editors before opening in
Calc.  Sometimes its easier to use a simpler tool to do a part of the job
rather than use a complicated route in a heavier tool such as Calc.
Regards from
Tom :)
On 8 Apr 2016 16:43, "Andreas Säger"  wrote:

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

-- 
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] Character style support in impress

[Cor Nouws]

Hi Alex,

Alex Lindsay wrote on 12-04-16 01:15:

> Is adding support for character styles in impress a very difficult
> problem? 

As you already know (so for other readers) there is an issue for this:
https://bugs.documentfoundation.org/show_bug.cgi?id=40871


-- 
Cor Nouws
GPD key ID: 0xB13480A6 - 591A 30A7 36A0 CE3C 3D28  A038 E49D 7365 B134 80A6
- vrijwilliger http://nl.libreoffice.org
- volunteer http://www.libreoffice.org
- The Document Foundation Membership Committee Member

-- 
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] Changing view from Handsout to Normal triggers master slide

[Tom Davies]

Hi :)
+1
I think doing a bug-report would be great.

Please don't expect the devs to fix it soon though!  It's usually best to
find a work-around, or avoid needing it, for the short-mid term.  Devs tend
to focus on issues they or their actual employers are most interested in.

Regards from
Tom :)
On 11 Apr 2016 20:16, "anne-ology"  wrote:

>I would guess you've uncovered a bug  ;-)
>
>
>
> From: Kruno 
> Date: Mon, Apr 11, 2016 at 2:11 PM
> Subject: [libreoffice-users] Changing view from Handsout to Normal triggers
> master slide
> To: users@global.libreoffice.org
>
>
> Hi,
>
> I'm viewing a presentation now in LO 5.1.2 and if in the main section I
> choose Handout view (first is Normal, then Outline, then Notes, Handout and
> Slide Sorter) and then I choose back Normal -- LO is serving me a Master
> slide setup.
>
> It's not doing it if I choose e.g. Outline and then go back to Normal. It's
> only doing this from Normal → Handout → Normal [→ Master slide].
>
> Should that be reported or what?
>
> Kruno
>
> --
> 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

[Tom Davies]

Hi :)
Nicely done! :)))

It's always good to hear someone has fixed their problem and it's great
when the right person gets credit.
Congrats, thanks and regards from
Tom :)
On 12 Apr 2016 15:56, "Henry Sikkema"  wrote:

> Thank you, Regina, for your solution of changing the OpenCl/OpenGL settings
> to make my file function correctly.
>
> Sorry for not giving credit where it was due.
>
> *Henry*
> ---
> O LORD our Lord how glorious is Your Name in all the Earth ~ Ps 8:1
> ---
> Mr. Henry Sikkema, BEd, MSc.
> Rehoboth Christian Schoolphone: 905-627-5977
> 198 Inksetter Rd email:  hsikk...@rehoboth.on.ca
> PO Box 70website: science.rehoboth.on.ca
> Copetown, ON
> L0R 1J0
>
> On 8 April 2016 at 05: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
>

-- 
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] Character style support in impress

[Tom Davies]

Hi :)
There is another app/module/component called "Math" that is designed for
writing formulae.  I've only used it for writing maths formulae a couple of
times but it should be flexible enough to do all sorts.  From what i
remember it was quite a steep learning-curve and results in images which
can then be used anywhere.  If that is true it might be easier to use some
other image-editing program, such as inkscape, gimp or Draw or something
more familiar to you.

Anyway the guides/manuals for "Math", Draw as well as Writer, Impress and
the other LibreOffice modules are here;
https:// 
wiki.documentfoundation.org

/Documentation/Publications


There are video tutorials at;
http://spoken-tutorial.org/
for LibreOffice and many other FOSS projects.
Regards from
Tom :)

On 12 Apr 2016 13:02, "nasrin khaksar"  wrote:

> hello.
> i use libreoffice 4.3.5.
> but i tested more than twenty versions of this great program.
> from my experience, if you install version 5.0 and later, there are
> more features for impress and its more customizable in impress in
> compare to the previous versions.
> if i am correct, you can select these settings that you want in the
> format menu.
> and you can change the values according to your desire.
> thanks so much for your question and god bless you.
>
> On 4/12/16, Alex Lindsay  wrote:
> > I'm an engineering post-doc and I use chemical symbols all the time; I
> often
> > need to indicate chemical charge states with super-scripts. The current
> > super-script setting accessed by ctrl-shift-p is not desirable to me; I
> > would much prefer a value for "raise/lower by" of 67% compared to the
> > default value of 33% (I don't understand why this is the default, but
> that's
> > a separate issue). In writer I could address this by creating a new
> > character style and assigning it to a customized keyboard shortcut.
> However,
> > I cannot do this in impress. This dramatically slows down by presentation
> > preparation. Automating this process would be extremely helpful to me.
> >
> > Is adding support for character styles in impress a very difficult
> problem?
> > If it's something simple that developers won't get to because it's not a
> > high priority, then I would be happy to explore a code fix myself.
> >
> >
> > --
> > 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
> >
>
>
> --
> Those who follow the Messenger-Prophet, the Ummi, whom they find
> written down with them in the Taurat and the Injeel [who] enjoins them
> good and forbids them evil, and makes lawful to them the good things
> and makes unlawful to them impure things, and removes from them their
> burden and the shackles which were upon them; so [as for] those who
> believe in him and honor him and help him, and follow the light which
> has been sent down with him, these it is that are the successful.
> holy quran, chapter 7, verse 157.
> best website for studying islamic book in different languages
> al-islam.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
>

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