Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?

[Andrew Pitonyak]

I remember writing code to go through cells... I don't remember if it was in 
AndrewMacro.odt or OOME.odt...

Can't look it up now...

Much depends on things like sizes and what you want to compare

Coming off a long shift, need to sleep, if you can't find it, let me know.

⁣Sent from BlueMail ​

On Jan 23, 2018, 6:45 AM, at 6:45 AM, stgmdn  wrote:
>Hello,
>
>I have to create a macro that read through a defined cell range, and
>for
>each cell, will assign it to a variable (to compare it to another
>cell),
>then it goes on the next cell.
>
>In my researches, I found that we can do this with a For Each Cell in
>VBA
>for Excel, but i can't seem to find the code that would do the same
>thing in
>LibreOffice Basic.
>
>Hope I've been clear enough, and thanks for your help.
>
>
>
>--
>Sent from: http://nabble.documentfoundation.org/Users-f1639498.html
>
>--
>To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
>Problems?
>https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
>Posting guidelines + more:
>https://wiki.documentfoundation.org/Netiquette
>List archive: https://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? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] base table window navigation tool

[leleu]

Je la 23/01/2018 19:48, Robert Großkopf skribis :

Hi Robert,


At least under Ubuntu Gnome this tool is awfully small, unreadable. How to
enlarge it ? I tried using gnome_color chooser (suggested by the French
forum), to no avail.

Could you please explain where to find "base table navigation tool"?
Doens't know what you mean. I have read "base table" and thought it has
to be something for the database of LO. But when I read gnome-color
chooser I couldn't guess, what is "small and unreadable".

Regards

Robert
Many thanks. Indeed it's related to the window used by the base module 
to display tables. The left part of the low border of the window shows 
icons  to go to First, Previous, Next, Last..

These, small, icons are the poblem

À demain !

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] base table window navigation tool

[Robert Großkopf]

Hi Robert,

> At least under Ubuntu Gnome this tool is awfully small, unreadable. How to
> enlarge it ? I tried using gnome_color chooser (suggested by the French
> forum), to no avail.

Could you please explain where to find "base table navigation tool"?
Doens't know what you mean. I have read "base table" and thought it has
to be something for the database of LO. But when I read gnome-color
chooser I couldn't guess, what is "small and unreadable".

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] base table window navigation tool

[robert leleu]

At least under Ubuntu Gnome this tool is awfully small, unreadable. How to
enlarge it ? I tried using gnome_color chooser (suggested by the French
forum), to no avail.

does anybody know ?


Bonsoir




--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?

[Jean-Francois Nifenecker]

Hi Tom,

Le 23/01/2018 à 09:35, stgmdn a écrit :


I have to create a macro that read through a defined cell range, and for
each cell, will assign it to a variable (to compare it to another cell),
then it goes on the next cell.

In my researches, I found that we can do this with a For Each Cell in VBA
for Excel, but i can't seem to find the code that would do the same thing in
LibreOffice Basic.



Yes, you're clear :)

I can see two ways to achieve your goal :
1. Browsing the cell range
2. Browsing the cell range data

1. Browsing a cell range

You have to create an enumerator which will give you the means to browse 
the range. The enumerator cannot be directly created from the range: 
you'll need a "range of ranges" (see below) in which you insert the 
range to browse object.


8< --
Dim MyRanges As Object  'a range of ranges
Dim MyEnum   As Object  'the enumerator
Dim TheCell  As Object  'each of the individual cells

MyRanges = 
ThisComponent.createInstance("com.sun.star.sheet.SheetCellRanges")

MyRanges.insertByName("some arbitrary name", MyRangeToBrowse)
MyEnum = MyRanges.Cells.CreateEnumeration
Do While MyEnum.hasMoreElements
TheCell = MyEnum.NextElement
'do smthg with the cell object
Loop
-- >8

Note that empty cells in the range will NOT be made avalaible (they are 
skipped by the enumerator).



2. Browsing cell range data

Once you've got the range to browse object, just refer to its .DataArray 
property and play with it. You'll have to use an external array as a buffer.


8< --
Dim MyArray As Variant  'buffer array

MyArray = MyRangeToBrowse.DataArray 'MyArray is set according to the 
range dimensions


'do smthg with the array items
'and finish with:
MyRangeToBrowse.DataArray = MyArray
-- >8

Note that the .DataArray property (thus MyArray as well) is a nested 
array : items are referred to as MyArray(i)(j), NOT as MyArray(i, j)



HTH,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Non-ASCII/UTF-8 double quote characters in text format?

[Leam Hall]

Hey, could use some help. I'm writing stuff in LibreOffice Writer 
(5.4.2.2) and it will sometimes put non-ASCII or UTF-8 " in the text. 
This causes an issue if I'm trying to use a regular expression to match 
the quotes as they are a non-standard character.


How can I force Libre Office to only use ASCII or UTF-8? How can I 
convert what is in whatever format to ASCII or UTF-8?


Thanks!

Leam

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Macros : For Each Cell in LibreOffice Basic ?

[stgmdn]

Hello, 

I have to create a macro that read through a defined cell range, and for
each cell, will assign it to a variable (to compare it to another cell),
then it goes on the next cell.

In my researches, I found that we can do this with a For Each Cell in VBA
for Excel, but i can't seem to find the code that would do the same thing in
LibreOffice Basic.

Hope I've been clear enough, and thanks for your help.



--
Sent from: http://nabble.documentfoundation.org/Users-f1639498.html

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Do not follow external links

[Olivier]

Stephan Bergmann  writes:

> On 23.01.2018 09:27, Olivier wrote:
>> Stephan Bergmann  writes:
>>> On 23.01.2018 04:36, Olivier wrote:
 Is there a way I can tell LibreOffice to not try to load external links?
 It could be a global configuration or a parameter at command line (but I
 could not see it).
>>>
>>> 
>> 
>> I have tried, but it does not seam to work, at least when loading an
>> HTML document: LibreOffice still tries to make an outgoing connection.
>> 
>> To be more specific, it tries to follow the link in the following (I
>> slitly modified the syntax, hping it can come through):
>> 
>> [td align="right">[a href="javascript:GoTofff();">[INPUT onclick="return
>> GoTofff()" border="0"
>> src="http://BAD_PLACE/site/sites/default/files/submit_icon.gif;
>> type="image" Value="submit">[/a>[/td>
>
> I can't reproduce any http access when loading such a html document into 
> LO and exporting it to pdf.  If you have a working example that doesn't 
> honour the "stealth mode" setting, best file an issue at 
>  with the details (and let me know 
> the issue ID, please).

Thank you Stephan. The bug ID is:

https://bugs.documentfoundation.org/show_bug.cgi?id=115166

Olivier
-- 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Do not follow external links

[Stephan Bergmann]

On 23.01.2018 09:27, Olivier wrote:

Stephan Bergmann  writes:

On 23.01.2018 04:36, Olivier wrote:

Is there a way I can tell LibreOffice to not try to load external links?
It could be a global configuration or a parameter at command line (but I
could not see it).





I have tried, but it does not seam to work, at least when loading an
HTML document: LibreOffice still tries to make an outgoing connection.

To be more specific, it tries to follow the link in the following (I
slitly modified the syntax, hping it can come through):

[td align="right">[a href="javascript:GoTofff();">[INPUT onclick="return
GoTofff()" border="0"
src="http://BAD_PLACE/site/sites/default/files/submit_icon.gif;
type="image" Value="submit">[/a>[/td>


I can't reproduce any http access when loading such a html document into 
LO and exporting it to pdf.  If you have a working example that doesn't 
honour the "stealth mode" setting, best file an issue at 
 with the details (and let me know 
the issue ID, please).


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Do not follow external links

[Olivier]

Stephan Bergmann  writes:

> On 23.01.2018 04:36, Olivier wrote:
>> Is there a way I can tell LibreOffice to not try to load external links?
>> It could be a global configuration or a parameter at command line (but I
>> could not see it).
>
> 

I have tried, but it does not seam to work, at least when loading an
HTML document: LibreOffice still tries to make an outgoing connection.

To be more specific, it tries to follow the link in the following (I
slitly modified the syntax, hping it can come through):

[td align="right">[a href="javascript:GoTofff();">[INPUT onclick="return
GoTofff()" border="0"
src="http://BAD_PLACE/site/sites/default/files/submit_icon.gif;
type="image" Value="submit">[/a>[/td>

Best regards,

Olivier

-- 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted