Re: [libreoffice-users] Customizing styles and keeping them in templates in Writer?

[bunk3m]

OK. I think I did.  Please let me know if it didn't work properly.

I hate gmail for trying to modify anything typical in an email.  It's a
piece of shit web software. :-)

On Fri, 24 Nov 2023 at 15:08, bunk3m  wrote:

> Thank you Eric.
>
> I have a number of templates.  For example, templates for different types
> of reports, memoranda, letters etc.
>
> I did create a default template initially.  I thought it would be
> something like the "normal" in MS Word.  It contained all the styles.  Then
> I created one a template for a report based on the default.  Unfortunately
> neither the default or the report template kept the list styles or
> paragraph styles created in either.  The only thing that stuck was the
> fonts but those are set as default in the User Preferences and not in the
> template.
>
> I'm not sure how making one of these templates the default will fix the
> missing styles within each of the templates as it hasn't worked so far.
>
> B.
>
> On Fri, 24 Nov 2023 at 14:39, Eric Beversluis <
> ebe...@researchintegration.org> wrote:
>
>> Have you made your template your default template?
>>
>> On Linux: Files/Templates/Manage Templates. Probably similar on Windows.
>>
>> On 11/24/23 14:22, bunk3m wrote:
>> > Hello,
>> >
>> > I'm using LO 7.6.2.1 on Win11 and Mac.
>> >
>> > I can't get the styles to work and stick in templates.  I've used styles
>> > and templates in MS Word for 30 years before switching to LO in the
>> past 5
>> > years.  I've read the help, Writer User Guide and Designing with LO 2nd
>> Ed.
>> > and apparently have missed something conceptual as I can't get the
>> styles
>> > to stick within the templates.
>> >
>> > I've created the styles in blank documents and then saved the document
>> as a
>> > template.I expected that the paragraph, font, list formats & styles
>> that I
>> > created would be saved in the template and reusable in subsequent
>> documents
>> > created from the templates.
>> >
>> > But when I use the templates to create a new document, none of the
>> > previously created styles are there.  I find I have to recreate all the
>> > styles again as they aren't anywhere within the template.  So far it's
>> been
>> > a colossal waste of time.
>> >
>> > I've found that all the "Youtube University" and User Guides are
>> > superficial when it comes to styles.  My goal is to set up a set of
>> > corporate styles that can be used by numerous people in our
>> organization to
>> > ensure consistency.
>> >
>> > Can someone direct me to some more detailed documentation on how the
>> styles
>> > are supposed to work?  Perhaps with some more detailed documentation I
>> can
>> > figure out what or how these are supposed to work ... or file a bug
>> reports.
>> >
>> > Thank you in advance.
>> > B.
>> >
>> --
>> Eric Beversluis www.ericbeversluis.com
>>
>

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Customizing styles and keeping them in templates in Writer?

[bunk3m]

 Thank you Eric.

I have a number of templates.  For example, templates for different types
of reports, memoranda, letters etc.

I did create a default template initially.  I thought it would be something
like the "normal" in MS Word.  It contained all the styles.  Then I created
one a template for a report based on the default.  Unfortunately neither
the default or the report template kept the list styles or paragraph styles
created in either.  The only thing that stuck was the fonts but those are
set as default in the User Preferences and not in the template.

I'm not sure how making one of these templates the default will fix the
missing styles within each of the templates as it hasn't worked so far.

B.

On Fri, 24 Nov 2023 at 14:39, Eric Beversluis <
ebe...@researchintegration.org> wrote:

> Have you made your template your default template?
>
> On Linux: Files/Templates/Manage Templates. Probably similar on Windows.
>
> On 11/24/23 14:22, bunk3m wrote:
> > Hello,
> >
> > I'm using LO 7.6.2.1 on Win11 and Mac.
> >
> > I can't get the styles to work and stick in templates.  I've used styles
> > and templates in MS Word for 30 years before switching to LO in the past
> 5
> > years.  I've read the help, Writer User Guide and Designing with LO 2nd
> Ed.
> > and apparently have missed something conceptual as I can't get the styles
> > to stick within the templates.
> >
> > I've created the styles in blank documents and then saved the document
> as a
> > template.I expected that the paragraph, font, list formats & styles that
> I
> > created would be saved in the template and reusable in subsequent
> documents
> > created from the templates.
> >
> > But when I use the templates to create a new document, none of the
> > previously created styles are there.  I find I have to recreate all the
> > styles again as they aren't anywhere within the template.  So far it's
> been
> > a colossal waste of time.
> >
> > I've found that all the "Youtube University" and User Guides are
> > superficial when it comes to styles.  My goal is to set up a set of
> > corporate styles that can be used by numerous people in our organization
> to
> > ensure consistency.
> >
> > Can someone direct me to some more detailed documentation on how the
> styles
> > are supposed to work?  Perhaps with some more detailed documentation I
> can
> > figure out what or how these are supposed to work ... or file a bug
> reports.
> >
> > Thank you in advance.
> > B.
> >
> --
> Eric Beversluis www.ericbeversluis.com
>

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Customizing styles and keeping them in templates in Writer?

[bunk3m]

Hello,

I'm using LO 7.6.2.1 on Win11 and Mac.

I can't get the styles to work and stick in templates.  I've used styles
and templates in MS Word for 30 years before switching to LO in the past 5
years.  I've read the help, Writer User Guide and Designing with LO 2nd Ed.
and apparently have missed something conceptual as I can't get the styles
to stick within the templates.

I've created the styles in blank documents and then saved the document as a
template.I expected that the paragraph, font, list formats & styles that I
created would be saved in the template and reusable in subsequent documents
created from the templates.

But when I use the templates to create a new document, none of the
previously created styles are there.  I find I have to recreate all the
styles again as they aren't anywhere within the template.  So far it's been
a colossal waste of time.

I've found that all the "Youtube University" and User Guides are
superficial when it comes to styles.  My goal is to set up a set of
corporate styles that can be used by numerous people in our organization to
ensure consistency.

Can someone direct me to some more detailed documentation on how the styles
are supposed to work?  Perhaps with some more detailed documentation I can
figure out what or how these are supposed to work ... or file a bug reports.

Thank you in advance.
B.

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Bump -> Rotated text on Line object?

[bunk3m]

Hello all,

As my message appears to have become lost, I am asking again.

I need some help figuring out how to format text on a line.

Is it possible to have text horizontal while the line drawn is at an 
angle?  If yes, how?


More details below.

Using LO 7.6 Draw on Mac.

Background:
I have a chart with many text boxes that have text centred inside. The 
boxes have an outline.


To show "flow" from one box to the next I have joined the boxes with 
lines with arrows.


When you double click the arrow line you can add text to the arrow line 
object.  This is great however the text for the line object ends up 
aligned ALONG the line.  So if the line is at 45 deg, the text is at 45 deg.


To make the text easier to read the text, I'd like the text to be at 
aligned in the reading direction ie. horizontal Something like my line 
art diagram below


 /
/
 text
  /
 /
/

Is this is even possible?  If yes, where is the formatting command?  If 
no, I'll add an enhancement request.


Thanks in advance.

PS I'm on digest mode. Please reply to list and cc me directly
:-)

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Rotated text on Line object?

[bunk3m]

Hello all,

I need some help figuring out how to format text on a line.

I'm using LO 7.6 Draw on Mac.

Background:
I have a chart with many text boxes that have text centred inside. The 
boxes have an outline.


To show "flow" from one box to the next I have joined the boxes with 
lines with arrows.


When you double click the arrow line you can add text to the arrow line 
object.  This is great however the text for the line object ends up 
aligned along the line.  So if the line is at 45 deg, the text is at 45 deg.


Goal:
To make it easier to read the text, I'd like the text to be at aligned 
in the reading direction ( line like this "/" and text like this "---").


i.e.

 /
/
 text
  /
 /
/

Is this is possible?  If yes, where is the formatting command?

Thanks in advance.

PS I'm on digest mode. Please reply to list and cc me directly
:-)

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc airithmetic snafu

[bunk3m]

Or perhaps leave the actual number in the first column and just use a 
cell format for the "km".


i.e.

1) Leave 2.4 in the cell
2) ctrl+1 (cmd+1 mac) to open format cell
3) then in the Format Code type " km" behind the number format.

And now your 2.4 will show "2.4 km" in the cell.

And you can do your arithmetical calculations on the cell as you've only 
changed the visual number format.


:-)

B.

On 28.11.2021 14:09, Remy Gauthier wrote:

Greetings,

If you do not like adding columns, you could do the following:

1) Select everything (CTRL-A)
2) Do a search & replace to remove all the "km" indications. This
should also convert the entry in the cells to numbers at the same time.
3) Keeping what is still selected, go to Cell > Format (CTRL-1), and
set the number format to User defined with the format as # ##0.0" km".
This will have your numbers displayed with the proper units.

I hope this helps.
Rémy.

Le dimanche 28 novembre 2021 à 08:37 -0600, Michael H a écrit :

Re: Units out of the data.

1. The formula =Value(Left(C1,Find(" ",C1))) will be insensitive to
longer--129.4 km-- or less specific--7 km-- distances.

2. When I remove units from a list, usually I'm working a large
amount of
data and find that the whole spreadsheet works better when source
data like
this isn't the result of formula. That is, it doesn't take so long to
refresh when I'm only waiting on 10,000 calculations, and not
10,000,000
calculations.

So to avoid those annoying long refresh times, instead of creating
the
source data with formula I copy the column to a new one, ensure there
are
adequate new columns behind it, then convert the column to data with
"Data
-> Text to Columns" and choose to break on space only (in your case,
sometimes I have to list out the first letter of units, but then I
lose the
units, so instead I find/replace the new column to introduce tab
characters
before doing the text to column action. (And if you trust yourself to
recognize mistakes in the text to columns steps before "undo" is
gone,
copying the column to another one isn't required.)

3.

On Fri, Nov 26, 2021 at 11:12 AM Hylton Conacher (ZR1HPC) <
hyl...@conacher.co.za> wrote:


HI ANDREW,

On 2021/11/26 16:38, Andrew Pitonyak wrote:

Left will return a string so convert to a number using value...
Something like this

=Value(left())



THANK YOU Works as expected,now on to the next formula Challenge


Get BlueMail for Android 
On Nov 26, 2021, at 9:12 AM, "Hylton Conacher (ZR1HPC)"
mailto:hyl...@conacher.co.za>> wrote:

     Hi,

     Using LO7.2.2.2    Calc on iMac 11.6.1(Big
Sur).

     I have a data column that ends in alphabetic letters i.e.

     C  |  D
     2| 2.4 km|    2.4
     3| 4.8 km|    4.8

     As the ' km' can't be added in column C, I used the LEFT
formula to

only

     extract the first 3 digits, namely =LEFT(C2,3). This works

wonderfully

     in column D, BUT whilst not shown on the spreadsheet, the
numbers are
     shown in-between double quotes if one looks at the formula,
in

column D,

     with the Function Wizard, which again does not enable the
number to

be

     added, averaged etc.

     Both C, D columns are formatted as Number with a single
decimal point
     and there will be no -ve number.

     What am I missing, and where to rectify it?

     Regards
     Hylton




--
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/
Privacy Policy: https://www.documentfoundation.org/privacy








--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: Re: [libreoffice-users] [Calc] Keyboard shortcut to delete current row when focus on one of its cells?

[bunk3m]

Sorry for the late response, I'm on digest mode.

While this isn't a one keyboard shortcut, you can do the following:

I use the following to achieve the delete current row when in a cell.

When in the cell,
press shift+spacebar (highlight row)
and then the ctrl+- (to delete row)

B.

On 22.09.2020 18:41, Dave Howorth wrote:

On Tue, 22 Sep 2020 15:18:18 +0100
DaveB  wrote:


On 22/09/2020 14:17, Philip Jackson wrote:

On 21/09/2020 22:48, Dave Howorth wrote:

Well the diagram in the book also has the buttons at the bottom in
a different order. Either they used a different version of the
software, or maybe a different desktop environment. The joy of
linux:)

But no, there are no underlines on the selections in [my] real
life.


Nor mine -  on 6.4.5.2

Philip


That suggests you are running Linux.

The image Dave is referring to was taken from a Windows 7 install of
the Calc Guide 6.2. We (The Documentation Team) always take captures
of the guide we are writing about. As much as we would like to, we
cannot cover every possible visual difference between each operating
system.

The conclusion to this thread is that Ctrl+- opens the dialog in both
Linux and Windows (cannot speak for macOS), but the D key only
functions as described by Brian under Windows, which is why Linux
users don't see the underline. Although less convenient, Linux users
can use the up and down arrow keys can be used to select the required
option.


Since I believe such underlines were implemented on Unix/Linux before
Windows, it's disappointing to me that the functionality isn't there in
the Linux implementation.

And in this case where there's a functional difference rather than a
visual difference, it would be nice to see that documented.

But thanks for explaining the situation. PS I think you mean R key
rather than D key.


Dave




--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] From Draw to Impress?

[bunk3m]

Thank you Regina.

That list is so long, I never looked much below the second section so 
never got there.


Once open in "ODF Drawing (Impress) (*.odg)", I see I can save the 
document as Presentation odp.


Cool!

Thanks!

B.

On 12.09.2020 17:24, Regina Henschel wrote:

Hi "bunk3m",

it is easier as you think:
Start with File Open.
Select your Draw document.
Then -still in the file open dialog- open the drop-down list to select 
the file type. Chose item "ODF Drawing (Impress) (*.odg)".


Notice the "(Impress)" in the item. It is the item directly after "ODF 
Presentation Template (*.otp)"


Kind regards
Regina

bunk3m schrieb am 12-Sep-20 um 22:21:

Hello all.

I am really pleased with the PDF open & edit in Draw but was wondering 
how to get content from Draw into Impress without having to copy and 
paste.


I couldn't find the my original presentation but had a pdf version of 
the presentation.


So I opened it in Draw.  That allowed me to make some small changes 
and yes, I can save again to PDF.


But what I wanted was to use Impress to present the reworked 
presentation.


There is no "Save as" to go to odp but I was hoping I could somehow 
get the Draw document into a presentation again.


Is there a way to do this?

Thanks in advance.

B.

PS on digest mode.  Please cc me directly.  Thanks!





--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] From Draw to Impress?

[bunk3m]

Hello all.

I am really pleased with the PDF open & edit in Draw but was wondering 
how to get content from Draw into Impress without having to copy and paste.


I couldn't find the my original presentation but had a pdf version of 
the presentation.


So I opened it in Draw.  That allowed me to make some small changes and 
yes, I can save again to PDF.


But what I wanted was to use Impress to present the reworked presentation.

There is no "Save as" to go to odp but I was hoping I could somehow get 
the Draw document into a presentation again.


Is there a way to do this?

Thanks in advance.

B.

PS on digest mode.  Please cc me directly.  Thanks!

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

[bunk3m]

Thank you Alex, Paulo and Drew.
I didn't realize there were so many "bugs" still to work out.
I'll stick with HSQLDB for now.
I trust there will eventually be a way to migrate to the new DB in the
future?

On Thu, 19 Mar 2020 at 10:10, Alexander Thurgood 
wrote:

> Le 19/03/2020 à 13:32, bunk3m a écrit :
>
> I would only recommend using embedded Firebird if you're comfortable
> with all of its still numerous bugs, and are happy to get your hands
> dirty correcting data types, lengths, etc and possibly corrupted data.
>
> Also, it is my understanding that there is currently still a limitation
> of 64Kb for the total insert length of any transaction, meaning that you
> have to be especially wary of the number, and length of any VARCHAR data
> that you have in your spreadsheet.
>
> If you have Unicode characters in any cell, you might also get an import
> failure because these are coded over 4 bits per character, which can
> rapidly cause the automatically created insert statement to exceed the
> 64KB limit, and again, fail.
>
>
> My advice would be to stick to embedded HSQLDB until, or unless, you are
> comfortable with such limitations.
>
>
> Alex
>
>
>
> > Thank you Alex and Drew.
> > I'll try your suggestions today.
> > I appreciate your help!
> >
> > One more question if I might.
> > If I understand correctly, HSQLDB is being replace by Firebird.  So I'd
> > like the engine to be Firebird so I don't end up with an issue in the
> > future.
> > How does one know that Firebird is being used?
> >
> > On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood <
> alex.thurg...@gmail.com>
> > wrote:
> >
> >> Le 19/03/2020 à 01:57, bunk3m a écrit :
> >>
> >> As Drew has said, you can use your existing flat file in several ways :
> >>
> >> 1) Go via the empty ODB file method to drag the linked XLSX sheet from
> >> your first ODB file to the second, empty ODB file and then follow the
> >> import wizard.
> >>
> >> 2) Create an empty ODB file and keep it open. Open your XLSX sheet
> >> directly in LO Calc. Select all of the data including column headers,
> >> that you want to import.
> >> Drag and drop this selected data onto your open ODB.
> >> Use the import wizard options to configure the way you want the data to
> >> be imported into a new table that will be created as a result of the
> >> drag and drop maneuver.
> >>
> >> Be aware that the import wizard isn't perfect, depending on the version
> >> of LO you are using, it might cause you a bit of grief, so double-check
> >> afterwards that it has done what you wanted (within the confines of what
> >> it can actually do, of course). You might find that some post-import
> >> database alteration statements might be necessary.
> >>
> >>
> >> Alex
> >>
> >
>
>

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

[bunk3m]

Thank you Alex and Drew.
I'll try your suggestions today.
I appreciate your help!

One more question if I might.
If I understand correctly, HSQLDB is being replace by Firebird.  So I'd
like the engine to be Firebird so I don't end up with an issue in the
future.
How does one know that Firebird is being used?

On Thu, 19 Mar 2020 at 05:52, Alexander Thurgood 
wrote:

> Le 19/03/2020 à 01:57, bunk3m a écrit :
>
> As Drew has said, you can use your existing flat file in several ways :
>
> 1) Go via the empty ODB file method to drag the linked XLSX sheet from
> your first ODB file to the second, empty ODB file and then follow the
> import wizard.
>
> 2) Create an empty ODB file and keep it open. Open your XLSX sheet
> directly in LO Calc. Select all of the data including column headers,
> that you want to import.
> Drag and drop this selected data onto your open ODB.
> Use the import wizard options to configure the way you want the data to
> be imported into a new table that will be created as a result of the
> drag and drop maneuver.
>
> Be aware that the import wizard isn't perfect, depending on the version
> of LO you are using, it might cause you a bit of grief, so double-check
> afterwards that it has done what you wanted (within the confines of what
> it can actually do, of course). You might find that some post-import
> database alteration statements might be necessary.
>
>
> Alex
>

-- 
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: Base created from xlsx file - move to proper DB

[bunk3m]

On 18.03.2020 20:57, bunk3m wrote:

Hello all.

I thought I had gotten the data from a flat file (xlsx) into Base.  I 
was trying to import and create a new database.


My work requires my data to be in the company OneDrive.  When I try to 
open the connected flat file, I get errors that the file location or 
parameters are not OK.  So all the work I did is lost.  This is likely a 
bug but I don't have time to report this at the moment.


Apparently I incorrectly used: "File:Connect to an existing database" as 
that just appears to connect to the flat file but won't actually create 
a proper table in Base.  While I can understand the use case for just 
accessing a flat table, I'd like to import not just connect.


There has to be an easy way to import the data without having to 
manually create a table and then import the csv file.  What am I missing?


I'm just trying to get data into Base easily.

LO v6.4.0.3 on Win10 64B.

Thanks in advance.


Sorry, I should have added that I'm on digest so please reply to the 
list but also to me directly.


Thanks.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Base created from xlsx file - move to proper DB

[bunk3m]

Hello all.

I thought I had gotten the data from a flat file (xlsx) into Base.  I 
was trying to import and create a new database.


My work requires my data to be in the company OneDrive.  When I try to 
open the connected flat file, I get errors that the file location or 
parameters are not OK.  So all the work I did is lost.  This is likely a 
bug but I don't have time to report this at the moment.


Apparently I incorrectly used: "File:Connect to an existing database" as 
that just appears to connect to the flat file but won't actually create 
a proper table in Base.  While I can understand the use case for just 
accessing a flat table, I'd like to import not just connect.


There has to be an easy way to import the data without having to 
manually create a table and then import the csv file.  What am I missing?


I'm just trying to get data into Base easily.

LO v6.4.0.3 on Win10 64B.

Thanks in advance.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Calc link problem on Mac

[bunk3m]

I'm looking for some help in debugging an issue that I've had since LO 
5.4 on Mac.  (I've been using LO since it forked.)  I'm now running LO 
6.3alpha


When I attempt to link a cell in one spreadsheet to another, the linking 
action using "=spreadsheet/cell location" transposes the link location 
to lowercase and I get ERR:501/ERR:507/ERR:509.


ie.
correct link:
'file:///Users/me/Documents/Time & Expense 
Forms/TIMEEX201703.ods']'Details of Expenses 3'!I54


link when made on the Mac or edited on the Mac it looks like this:
'file:///users/me/documents/time & expense 
forms/timeex201703.ods']'details of expenses 3' I54


I have tried the exactly same linking with exactly the same spreadsheets 
using LO on Win & Linux and there is no problem.  As soon as I try this 
on the Mac it breaks.


I've posted a bug and it's now nearly 2 years old.  It was temporarily 
fixed in one beta version but I can't find it anymore.


I've been testing alpha and beta builds with the hope that this issue 
would be resolved but no luck.


I'm frustrated that the bug is still open and want to help figure out 
why there is a problem but I don't know what to try.  I use the linking 
daily but am stuck on Excel because I can't get it to work on LO.


Any suggestions are appreciated.

Thanks.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Re: Does something like this exist for LO?

[bunk3m]

On 05.02.2019 14:05, Luuk wrote:


On 5-2-2019 02:55, bunk3m wrote:

On 04.02.2019 06:30, Luuk wrote:


On 2-2-2019 21:53, bunk3m wrote:
I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for 
each individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) 
that runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies. Thank you 
in advance.




I did forget to mention that this tool: 
https://github.com/nerik/google-timeline-to-csv


works with the: "Location History.json"

from: https://takeout.google.com/



Thank you Luuk.  After all my Googling, I never found this project.

I will see if I can figure out how to get this google-timeline-to-cvs 
to work.  I don't code so this will be a challenge.  I have no idea 
how to install dependencies after doing a download of this project.


Any suggestions appreciated.

Thanks again.
B.


Install nodejs (see https://nodejs.org/en/)

Download, and install 'google-timeline-to-csv' in a directory.

Now when you do this:

'node index.js'

You might get an error about missing library's.

To install those missing library's type:

'npm install fs path xmldoc json2csv moment'

(npm should be installed together with nodejs)



==

Thanks so far Luuk.

I have installed nodejs10 and npm6 using Macports as I didn't know any 
other way to get that installed.


It is throwing errors on processing the 'Location History.json' file.

'node index.js ../Takeout/Location\ History/ > ../Takeout/location.csv'

In the location.csv file I find this:


Error: params should include "fields" and/or non-empty "data" array of objects
    at checkParams 
(/Users/bunk3m/Downloads/google-timeline-to-csv-master/node_modules/json2csv/lib/json2csv.js:95:11)
at module.exports 
(/Users/bunk3m/Downloads/google-timeline-to-csv-master/node_modules/json2csv/lib/json2csv.js:48:5)
    at pointsToCsv 
(/Users/bunk3m/Downloads/google-timeline-to-csv-master/index.js:134:3)
at Object. 
(/Users/bunk3m/Downloads/google-timeline-to-csv-master/index.js:39:1)
at Module._compile (internal/modules/cjs/loader.js:689:30)
at Object.Module._extensions..js (internal/modules/cjs/loader.js:700:10)
at Module.load (internal/modules/cjs/loader.js:599:32)
at tryModuleLoad (internal/modules/cjs/loader.js:538:12)
at Function.Module._load (internal/modules/cjs/loader.js:530:3)
at Function.Module.runMain (internal/modules/cjs/loader.js:742:12)


I'm stuck as I don't understand what the error would refer to. But this 
is interesting!


Should I be referring to the github project?

Could you give me an idea how to search for such an error?

Thanks.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Does something like this exist for LO?

[bunk3m]

On 04.02.2019 06:30, Luuk wrote:


On 2-2-2019 21:53, bunk3m wrote:
I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for each 
individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) 
that runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies.  Thank you in 
advance.




I did forget to mention that this tool: 
https://github.com/nerik/google-timeline-to-csv


works with the: "Location History.json"

from: https://takeout.google.com/



Thank you Luuk.  After all my Googling, I never found this project.

I will see if I can figure out how to get this google-timeline-to-cvs to 
work.  I don't code so this will be a challenge.  I have no idea how to 
install dependencies after doing a download of this project.


Any suggestions appreciated.

Thanks again.
B.


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Does something like this exist for LO?

[bunk3m]

I have been wondering how to export my Google Map Timeline so I can 
capture my mileage driven without having to get the kml file for each 
individual day.


Today I found this add-in for Excel (Don't have Excel anymore :-( ) that 
runs a VBA script to do exactly what I'm looking for.


https://github.com/Excel-projects/Excel-Timesheet

Is there a way to run this in LO Calc?

PS On digest mode. Please cc me directly on any replies.  Thank you in 
advance.


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Scripting LO

[bunk3m]

Thank you Drew.

That is very helpful!

On 23.12.2018 11:37, Drew Jensen wrote:

Howdy,

Support for that is built in and is available from a command line or 
script as you prefer.


Here is a good overview of that:
https://ask.libreoffice.org/en/question/2641/convert-to-command-line-parameter/

Best wishes,

Drew

On Sun, Dec 23, 2018 at 11:29 AM bunk3m <mailto:bun...@gmail.com>> wrote:


Hello.

I see that there are a number of ways to script LO  within the program
itself, but is it possible to automate LO open file and save as odt,
ods, odp?  Something like Applescript used to be able to manipulate
programs?

For example,

I have many old files in various formats like .doc, .xls, .ppt,
Pagemaker, etc. etc. I have concerns about future compatibility and
access to those documents.

I would to run perhaps a bash script on a folder to open each file in
the folder and then save it in the appropriate ODF 2.0 format.

Is there a way to script LO like that?

Thank you in advance.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

<mailto:users%2bunsubscr...@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/
Privacy Policy: https://www.documentfoundation.org/privacy



--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Scripting LO

[bunk3m]

Hello.

I see that there are a number of ways to script LO  within the program 
itself, but is it possible to automate LO open file and save as odt, 
ods, odp?  Something like Applescript used to be able to manipulate 
programs?


For example,

I have many old files in various formats like .doc, .xls, .ppt, 
Pagemaker, etc. etc. I have concerns about future compatibility and 
access to those documents.


I would to run perhaps a bash script on a folder to open each file in 
the folder and then save it in the appropriate ODF 2.0 format.


Is there a way to script LO like that?

Thank you in advance.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: Re: [libreoffice-users] Writer paragraph numbered list issue

[bunk3m]

Thank you Robert.

Unfortunately neither of these two options work.

On 05.06.2018 01:57, Robert Großkopf wrote:

Hi bunk3m,


The document goes from paragraph 1 to 11 and then should have 11.1 to
11.9 but I end up with paragraph 1 to 20.


Go to paragraph, which shows '12'
Right Mouseclick > Demote One Level
... and so on for all following paragraphs ...


I don't have a "Demote One Level" but wish I did.


Could be you have to change the numbering:
Right Mouseclick > Bullets and Numbering > Customize
Goto Level '2', set 'Show sublevels' and set it to '2'.

Regards

Robert


When I go to Bullets and Numbering, Customize Goto Level 2 and show 
sublevels, LO Writer creates another set of bullets in front of the 
bullets imported from Word.


Aah.  This is driving me crazy.

B.

--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Writer paragraph numbered list issue

[bunk3m]

Hi!

Today I've had 2 frustrations with LO Writer (6.0.4 & 6.2a).  To keep 
this shorter and easier to follow, I'm posting two topics


This email has the second of those frustrations.

I have a legal document that was originally a MS Word doc.  I don't want 
to rebuild the complete document to fix page numbering and 
outline/paragraph numbering style.  I would appreciate any pointers on 
how to fix the following issue.


The legal document has numbering for paragraphs.  There is a section of 
paragraphs that has a second level of number in the Word document.  That 
second level of number hasn't translated over into LO properly. ie. top 
level is 1., second level is 1.1 This worked fine in MS Word.


I've tried to change the paragraph numbering in bullet & number style 
but that hasn't worked.  I can't get any of the numbering to change.


The document goes from paragraph 1 to 11 and then should have 11.1 to 
11.9 but I end up with paragraph 1 to 20.


How do I change the paragraph number style and get it to stick.

Thank you in advance.

PS I'm on digest mode so would appreciate if you can cc me directly on 
any suggestions.


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Writer page numbering issue + numbered list issue

[bunk3m]

Hi!

Today I've had 2 frustrations with LO Writer (6.0.4 & 6.2a).  To keep 
this shorter and easier to follow, I'm posting two topics


This email has one of those frustrations.

I have a legal document that was originally a MS Word doc.  I don't want 
to rebuild the complete document to fix page numbering and 
outline/paragraph numbering style.  I would appreciate any pointers on 
how to fix the following 2 issues.


I started using LO earlier this year and have found page numbers a 
challenge.


I have a legal document that was usually added into or appended to a 
proposal document that was printed to a pdf.


So I have changed the page number in the legal document to start with 
the page following the last page of the proposal. ie. proposal has five 
pages so the legal document would start on page 6.


I've been to a dozen websites and seen a few youtube videos but still 
can't get the page number to change from "4".  I'd like it to be "1" for 
the present document.


What I've tried.  a) Delete the footer; b) delete the footer, then reset 
the default footer; c) in the page style change the type flow option to 
set the page number.  Nothing works.


How do I manually change the starting page number for the legal 
document?  What's the secret to get this to work?


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Missing bullet points in Notes view on Impress 6.x - How do I get them back?

[bunk3m]

On 06.02.2018 00:48, Brian Barker wrote:

At 10:38 05/02/2018 -0500, Bonly Noname wrote:
I have a presentation in Impress on LO 6.0 on the Mac. I'd like to 
print the "Notes" as part of my report but I am at a loss as to how I 
get the bullets to show up in the Notes view image. I suspect 
something in my template may have caused this but I can't figure it 
out and can't find anything in any documents about formatting bullets 
in Notes view.


The Normal view has bullet points. The Outline View had bullet points. 
The Notes view has no bullet points. The Normal view is a black 
background with white text and white bullets. The Outline view has 
black text with black bullets and white background. The Notes view has 
the Normal view slide but no bullets. How do I enable the bullets to 
appear in the Notes view?


If you set the page background colour to black, the text colour on the 
display defaults to white, but this is still with the Font Colour set to 
Automatic, not White. I think that to achieve exactly what you describe 
so far you must have set your text Font Colour explicitly to White. So 
far, so good. It seems that to get the Notes to work properly, you need 
to set the bullet colour similarly to White, not Automatic. You will 
find this setting on the Customise tab of the Bullets and Numbering 
dialogue.


I trust this helps.

Brian Barker


Thank you for your help, Brian.

I've checked the master pages for the normal view and I have already set 
the text for bullet lists as white.  I don't think the Notes master can 
set the text of slide can it?  I should take the Normal view settings, 
right?


The Notes view is still missing the bullet points in white.

I've check also checked the Bullet style  which is white.

Any suggestions where else I should search?

Thanks again.

--
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] Missing bullet points in Notes view on Impress 6.x - How do I get them back?

[bunk3m]

Hi all.

I have a presentation in Impress on LO 6.0 on the Mac.

I'd like to print the "Notes" as part of my report but I am at a loss as 
to how I get the bullets to show up in the Notes view image.  I suspect 
something in my template may have caused this but I can't figure it out 
and can't find anything in any documents about formatting bullets in 
Notes view.


The Normal view has bullet points.  The Outline View had bullet points. 
The Notes view has no bullet points.


The Normal view is a black background with white text and white bullets.

The Outline view has black text with black bullets and white background.

The Notes view has the Normal view slide but no bullets.

How do I enable the bullets to appear in the Notes view?

Thanks.

PS I'm on digest mode so please cc me directly in the reply to the list. 
 Thank you.


--
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] Re: Changing key board shortcuts in Mac LO Calc

[bunk3m]

On 27.01.2018 05:39, Heiko Tietze wrote:

US users switch with cmd + ~ but other keyboard layouts doesn't provide easy 
access to the tilde and use different shortcuts by default [1]. So whatever we 
do some users will not be happy with the solution. Cannot say at the moment 
what exactly caused the change but you should definitely write a bug report. 
Also skim over the discussion at [2].

[1] 
https://apple.stackexchange.com/questions/193937/shortcut-for-toggling-between-different-windows-of-same-app
[2] https://bugs.documentfoundation.org/show_bug.cgi?id=115052


Thank you for this, Heiko.  I had no idea that it was so complicated.

I see from the stackexchange hint that the switch between windows of the 
same app is supposed to be CMD+'.  This is found in the System Keyboard 
shortcuts.


I've tested it and it doesn't work in any app that I use. :-( Each one 
tested uses CMD+~


In the end, I can learn something new but I really would like it to be 
consistent across LO.  Right now Impress & Writer use CMD+~ but with 
Calc I can only switch between open windows by using the menu.  That 
really screws up the workflow.


I have logged a bug.

B.



On 26.01.2018 19:31, bunk3m wrote:

On 25.01.2018 05:05, Alexander Thurgood wrote:

Le 24/01/2018 à 18:51, bunk3m a écrit :

Hi,


Can someone let me know where I can find this in the documents or give
me some help so I fix this?


My unedcuated guess is that it has been hardcoded by some "well
intentioned" UI-developer who failed to appreciate the requirements of
OSX yet again (and in particular, the different keyboards that Apple
produces and sells with its computers).

Difficult to lay the blame in such a case as most of the testers and
developers use Linux, and I imagine very few have an Apple Mac with a
full Apple keyboard à la Magic Keyboard with numerical keys. My own Mac
environment uses the small Magic Keyboard with my Macmini or else the
integrated keyboard on my MBPro and both are AZERTY.


Thank you for the clarifications Alex.

I've posted a bug report but I get the distinct feeling it isn't being seen as 
an issue. :-(

I understand that it is probably hard coded somewhere but is there any way to fix this 
using the Customize:Keyboard and override the incorrect View:Show Formula (~+CMD) with 
"switch between open documents" (or whatever the hell its called)?



The non-standard keyboard shortcut in one of the applications is driving
me crazy.


Snap. Fiddling with the UI to "make it better" (for whom, certainly not
those on macOS) is one of my major bugbears. I've given up.

Alex


This is frustrating enough to have me hound someone.  I've been trying to get 
to a point of removing the M$ applications but these stupid little non-standard 
UI things really frustrate me and keep the M$ stuff installed so I can work 
properly.

I never thought I'd say this but the Mac version of Office 2010 was very good 
and worked like Mac programs should (although a bit stripped of functionality 
compared to the Win version).  LO has been much better at keeping all 
functionality similar across platforms but these UI problems really slow down 
the workflow.  I only wish LO would get the UI shit in order!

B.





--
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] Re: Changing key board shortcuts in Mac LO Calc

[bunk3m]

On 25.01.2018 05:05, Alexander Thurgood wrote:

Le 24/01/2018 à 18:51, bunk3m a écrit :

Hi,


Can someone let me know where I can find this in the documents or give
me some help so I fix this?


My unedcuated guess is that it has been hardcoded by some "well
intentioned" UI-developer who failed to appreciate the requirements of
OSX yet again (and in particular, the different keyboards that Apple
produces and sells with its computers).

Difficult to lay the blame in such a case as most of the testers and
developers use Linux, and I imagine very few have an Apple Mac with a
full Apple keyboard à la Magic Keyboard with numerical keys. My own Mac
environment uses the small Magic Keyboard with my Macmini or else the
integrated keyboard on my MBPro and both are AZERTY.


Thank you for the clarifications Alex.

I've posted a bug report but I get the distinct feeling it isn't being 
seen as an issue. :-(


I understand that it is probably hard coded somewhere but is there any 
way to fix this using the Customize:Keyboard and override the incorrect 
View:Show Formula (~+CMD) with "switch between open documents" (or 
whatever the hell its called)?




The non-standard keyboard shortcut in one of the applications is driving
me crazy.


Snap. Fiddling with the UI to "make it better" (for whom, certainly not
those on macOS) is one of my major bugbears. I've given up.

Alex


This is frustrating enough to have me hound someone.  I've been trying 
to get to a point of removing the M$ applications but these stupid 
little non-standard UI things really frustrate me and keep the M$ stuff 
installed so I can work properly.


I never thought I'd say this but the Mac version of Office 2010 was very 
good and worked like Mac programs should (although a bit stripped of 
functionality compared to the Win version).  LO has been much better at 
keeping all functionality similar across platforms but these UI problems 
really slow down the workflow.  I only wish LO would get the UI shit in 
order!


B.

--
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] Changing key board shortcuts in Mac LO Calc

[bunk3m]

Hi.

In LO 5.x the Calc keyboard shortcut to change between open documents 
followed the Mac UI standards.  That means that when you use the 
keyboard shortcut [ ~ + CMD ] (tilde + command or Apple key) you switch 
between open documents.


In LO 6.x Calc the [~+CMD] shortcut now shows the cell formulas rather 
than switching between open docs.  This shortcut still works properly in 
Writer and Impress.


I has posted a bug but I want to manually change the ~+CMD in Calc back 
to the normal behaviour.


I can't figure out how to do this.
1) I can't find what ~+CMD is doing in the keyboard shortcuts in Calc.
2) I don't know what the command for switch between open documents is 
called in order to look it up in the list.


Can someone let me know where I can find this in the documents or give 
me some help so I fix this?


The non-standard keyboard shortcut in one of the applications is driving 
me crazy.


Thanks in advance.

--
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] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Steve,

I just tested your scenario (Tools:Automatic Spell Check -> off) and I 
had a similar transformation of text.  It didn't remove the "!" though. 
All the other changes happened.


B.

On 30.10.2017 18:40, Steve Edmonds wrote:

Hi.
This is not some sort of auto spell correct on the Mac where LO changes 
all the upper case letters to lower case, changes some of the characters 
ie. #, $ and ! are removed is it.

steve

On 31/10/17 11:36, bunk3m wrote:
OK I've had some time to test this with the same spreadsheets on 
various versions of LO on Mac, LO on VM running Win & LO on VM running 
Linux (Xubuntu).


I've tested LO 5.1, 5.3 & 5.4 on Mac, LO 5.1 Win, LO 3.5.7.2 Linux and 
OO 3.3 and OO 4.1


In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked 
cell and press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper 
case letters to lower case, changes some of the characters ie. #, $ 
and ! are removed and you get an error message.


If you try to manually change the text entry changes from (3), when 
you press the enter key it reverts to the incorrect text.


Using the same spreadsheets and following steps (1) & (2) and using 
Win LO 5.2 & Linux Xubuntu LO 3.5.7.2, the linking works without error.


Using the same spreadsheets and following steps (1) & (2) and using 
Mac OO 3.3 and 4.1, the links work without error.


So at this point I opened the spreadsheet in LO Mac and the links 
created by Win and Linux versions are still OK.


If I use Mac LO to copy and paste the entire cell created by Win & 
Linux versions of LO and OO,there is no transformation and the linking 
works.


If I use Mac LO and select in the cell, highlight and copy the link 
formula, and paste the formula into another cell, Mac LO transposes 
the formula and ERROR.


I think we've found a bug.

B.

On 30.10.2017 14:46, bunk3m wrote:

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 
3.3. I downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has 
the same issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files. 
So my file does link when using OO.  This is beginning to look like a 
bug in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried 
again to change the syntax "!" vs ".", "#" or not etc. but still 
getting ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac. If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will 
report back.


B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the 
formula, but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address 
"!",


First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and 
tried it again just now.  When I follow your instructions, I get 
an ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no 
"green check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This 
does work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as 
an Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

OK I've had some time to test this with the same spreadsheets on various 
versions of LO on Mac, LO on VM running Win & LO on VM running Linux 
(Xubuntu).


I've tested LO 5.1, 5.3 & 5.4 on Mac, LO 5.1 Win, LO 3.5.7.2 Linux and 
OO 3.3 and OO 4.1


In each case I followed these steps.
1) open two linked spreadsheets
2) place "=" in a cell, switch to other spreadsheet, select the linked 
cell and press enter key.
3) in each case on the Mac (LO 5.1/5.3/5.4); LO changes all the upper 
case letters to lower case, changes some of the characters ie. #, $ and 
! are removed and you get an error message.


If you try to manually change the text entry changes from (3), when you 
press the enter key it reverts to the incorrect text.


Using the same spreadsheets and following steps (1) & (2) and using Win 
LO 5.2 & Linux Xubuntu LO 3.5.7.2, the linking works without error.


Using the same spreadsheets and following steps (1) & (2) and using Mac 
OO 3.3 and 4.1, the links work without error.


So at this point I opened the spreadsheet in LO Mac and the links 
created by Win and Linux versions are still OK.


If I use Mac LO to copy and paste the entire cell created by Win & Linux 
versions of LO and OO,there is no transformation and the linking works.


If I use Mac LO and select in the cell, highlight and copy the link 
formula, and paste the formula into another cell, Mac LO transposes the 
formula and ERROR.


I think we've found a bug.

B.

On 30.10.2017 14:46, bunk3m wrote:

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 3.3. I 
downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has the same 
issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files.  So 
my file does link when using OO.  This is beginning to look like a bug 
in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again 
to change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report 
back.


B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and 
tried it again just now.  When I follow your instructions, I get an 
ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This 
does work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadshee

Re: [libreoffice-users] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

A quick update.

I wasn't able to find LO 5.1 but I did find LO 5.3 and OpenOffice 3.3. 
I downloaded and installed both LO 5.3 and OO 3.3.  LO 5.3 has the same 
issue and won't allow the link.


OO 3.3 has absolutely no problem with the linking to external files.  So 
my file does link when using OO.  This is beginning to look like a bug 
in LO 5.3 & 5.4.


I will try OO 4.x and see if there it work also.

And I will see if I have LO on a Linux VM image to see if the 
spreadsheet will work using Linux.


B.

On 30.10.2017 14:04, bunk3m wrote:

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again to 
change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report back.

B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and tried 
it again just now.  When I follow your instructions, I get an ERR:507.


I've tried following the instructions that Remy provided [The link 
was inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This does 
work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two 
spreadsheets on my Mac.


I've tried, single and double quotes for file location, "." or "!" 
for identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands 
but that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select 
the cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've 
been linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering 
to the list.










--
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] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Hi Steve,

Thanks for your continued help.

I checked my LO and it has Formula syntax -> Excel A1.  I tried again to 
change the syntax "!" vs ".", "#" or not etc. but still getting 
ERR:510|ERR:507 or ERR:501 and the occasional #NAME?.  :-p


Please let me know if you have a problem when you try LO 5.4 Mac.  If 
it's a bug, then I'll happily add it.


I will see if I can find LO 5.1 Mac and give that a try.  Will report back.

B.

On 29.10.2017 21:57, Steve Edmonds wrote:

Hi.
My Mac has LO 5.1..., My Linux 5.3...
When I add the connection on my Mac as in my earlier test I get a 
formula like

='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11

I don't get any error, it calculates fine on creation of the formula, 
but cannot get it to update if the source changes.


I will update my Mac to 5.4 and see if that changes anything, but I 
would assume if the file is an ods then adding a new formula should 
result in ods formatting.

BUT from a few years ago I found

"I think the issue is the separator between sheet name and address "!",

First option)
Change Menu/Tools/Options/LibreOffice/Formula/Formula options/Formula 
syntax -> Excel A1."


So may be check Menu/Tools/Options/LibreOffice/Formula/Formula 
options/Formula syntax


Steve

On 30/10/17 09:54, bunk3m wrote:

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and tried 
it again just now.  When I follow your instructions, I get an ERR:507.


I've tried following the instructions that Remy provided [The link was 
inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This does 
work.


To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't 
been my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two 
spreadsheets on my Mac.


I've tried, single and double quotes for file location, "." or "!" 
for identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands 
but that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select 
the cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've been 
linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering 
to the list.










--
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] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Thank you for testing this, Steve.

I tried what you suggested near the beginning of my testing and tried it 
again just now.  When I follow your instructions, I get an ERR:507.


I've tried following the instructions that Remy provided [The link was 
inserted as per the instructions in the help 
(https://help.libreoffice.org/Calc/Referencing_a_Cell_in_Another_Document)] 
but I get completely different looking formula.  There is no "green 
check mark" as per the help instructions either.


Within the same spreadsheet I get similar, ie. ='tab'!cell  This does work.

To reference a spreadsheet outside of the present spreadsheet,

where Remy gets:
='file:///mnt/public/Documents/Global/List of CDs.ods'#$Sheet1.C11
on Linux

I get:
=['file:///users/me/folder/spreadsheet.ods']'tab'!i54

This isn't what the help file shows either.

Could this be something due to the fact that this started out as an 
Excel file but was saved as an ods sometime over the past months?


I'm confused.
B.

On 29.10.2017 16:12, Steve Edmonds wrote:

Just tried on my mac.
Open the sheet I want to perform the calculation in.
Open the source sheet from which I want to fetch the data

Enter the formula in a cell in the first sheet, i.e =2*
then click in the source cell in the second sheet,
then click enter and it seems to work.
steve

On 30/10/17 07:42, bunk3m wrote:

Hello all,

I've been struggling with this one for a week now.  Google hasn't been 
my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two 
spreadsheets on my Mac.


I've tried, single and double quotes for file location, "." or "!" for 
identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands but 
that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select the 
cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've been 
linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering to 
the list.







--
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] Calc 5.x Mac - syntax to link cells in two spreadsheets?

[bunk3m]

Hello all,

I've been struggling with this one for a week now.  Google hasn't been 
my friend so far so thought I'd ask the user group.


LO 5.4.2.2 Mac 64 Bit.

I have a spreadsheet (originally in xls but now ods) where data is 
provided to a summary spreadsheet.


I am unable to get the syntax to link the cells in the two spreadsheets 
on my Mac.


I've tried, single and double quotes for file location, "." or "!" for 
identifying the source cell but nothing seems to work.  I get 
ERR:507/ERR:508/ERR:501/ERR:510 and occasionally #NAME?#


The file names have spaces as do the tab in the spreadsheet.

I've tried the =HYPERLINK(file:///... and ='file:///...' commands but 
that doesn't work.


I've also tried the Insert Hyperlink but that won't let me select the 
cell in target spreadsheet.


I'm loath to go back to Excel for this one spreadsheet but I've been 
linking spreadsheets in Excel for so long and it works.


I'd appreciate any Mac specific guidance.

Bunk3m.
PS on Digest mode.  Please cc me directly in addition to answering to 
the list.


--
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] Re: External Hard Drives - to save my LO and other content

[bunk3m]

Steve,

You may find following two articles interesting regarding drive 
failures.  I find the Backblaze info useful but to provide balance, a 
contrasting view in second link.


https://www.backblaze.com/blog/hard-drive-failure-rates-q1-2017/

https://www.theregister.co.uk/2014/02/17/backblaze_how_not_to_evaluate_disk_reliability/

YMMV.
B.

On 17.10.2017 04:44, zahra a wrote:

hello.
i suggest recovery softwares for now to rescue your lost data!
recuva from piriform has one free version, but i heard from one very
expert computer security engeneer that told me active undelete is very
strong and reliable for recovering data, but i forgot its price.
hope that help, God bless you all!

On 10/17/17, Steve Edmonds  wrote:

There are so many opinions on this topic that a decision is not easy.
I have some Seagate ironwolfs in my NAS (DS216). It's internal OS is
linux and it talks nice to linux, mac and windows. For my desktop data
(/home) I got a WD Gold, and am stunned just how much faster than a red
or black it is.
I think the important factor is being able to allow at least 1 drive
failure without data loss.
steve

On 17/10/17 13:19, Tim-L wrote:


If you cannot find a good article that you can trust, then you must
take opinions of others.

So, this is my opinion about best drives to buy.

Even 1 month old Military specs 2-TB USB Drive can go bad.  Mine did.
At least most of it was backed up on a different drive/system.  It
only cost me $100 plus shipping for the original drive - from Walmart
of all places.

I always buy the best extended warranty I can get, for all my
electronics.  At least this replaces the device that died.

First, I personally would not go larger than 2-TB for a drive as your
MOST needed data, unless you have drives that are designed for NAS or
file server equipment.  That is my opinion for the drives I can afford
to buy, for the money I had when I need them. I use a desktop, and its
drives as the backup for my laptop data. It will end up as a file
server - one day.  I believe in a many device backup system - as follows;

    I backup the laptop[s] data to my "Silicon Power 2TB Rugged Armor
    A30 Shockproof Standard 2.5" USB 3.0 Military-Grade Portable
    External Hard Drive".  Then take that drive and copy the files to my
    file "server" desktop's 3 different 2-TB internal drives. The are WD
    brand.  Then I use a syncing backup script to the 3 external drives
    - again WD drives - 6-TB internal and 6-TB external.  So, I have at
    least 2 different drives hold the "backups" of the data, if the
    laptop drive goes bad.  It could be easier if I had more money.

I looked at a few places and the "best" drive type I found so far may
be the WD Red Pro drives for NAS storage.  They cost more than the WS
"Black" type, or other brands of drives.  They are designed for long
life in demanding needs.  I have seen the "red" drives as large as
8-TB for $400 USD.  The 4-TB run about $150.  If I have the money, I
would replace my current drives with these drives.

I currently do not have a NAS storage device - due to the fact I could
not figure out how to get my Linux systems to work with the current
router/NAS device I have, or any NAS storage outside of a desktop
setup.  That is why I hope to get one of my desktops to be a true
Ubuntu file server.



On 10/16/2017 06:04 PM, Steve Edmonds wrote:

Hi Charles.
I have just had a new WD Black (supposed to be high(er) reliability)
die within a few weeks. Replaced under warranty.
The probability of that is low, but it does happen. If the backup is
only a copy of what is on your PC/laptop then you are not needing
such high reliability as you always have at least one copy on a failure.

I archive (backup and delete original from PC) so use a little DS216
NAS storage unit  with 2 drives configured raid. Less frequently I
backup that to a single 4TB HD for off site safety (house burns down).

I also bought a drive on Amazon recently and noticed that there was
an option for $10 extra to cover data recovery in a failure.

I think your best solution will depend upon how much data you need to
back up and how often, an on-line solution may even work for you.

Steve

On 17/10/17 07:53, charles meyer wrote:

Hi All,

I have a SONY external hard drive that just died one day within it's
warranty period.

SONY won't recover my drive contents so the next time I've got an extra
$500 I'll have to find a data recovery firm.

I need to back up my contents - music, videos, data but I can't seem to
find an objective, independent evaluation of which external hard
drives are
most reliable.

Have you found any such article?

Or have you found through experience certain brands more reliable than
others?

Thanks so much!

Charles.



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

Re: Re: [libreoffice-users] MacOS 64 bit 5.4.1 torrent issue

[bunk3m]

Thank you Steve.

I'm blind.  I didn't realize that the checksum was right there.

So the 5.4.1 torrent is contaminated.  Have to be more careful out 
there. :-)


Thanks.

B.

PS In digest mode.

On 31.08.2017 16:38, Steve Edmonds wrote:

Hi.
Next to the torrent link under download is Info with checksums. You can 
check the torrent (and direct download) against these for validity.

Steve

On 01/09/17 06:23, bunk3m wrote:

Hi all,

I downloaded the new release this morning via torrent.  When I started 
the LO, LittleSnitch indicated that it tried to connect to centrum.cz 
and bbx-fe-hp-pool.centrum.cz.


I checked out the sites and I can't figure out why LO would need to 
connect there.


I thought it strange so I downloaded 5.4.1 again directly.

I overwrote the torrent version with the direct download version and 
cleared all the LO rules in LittleSnitch.


In the direct download version there is no request to connect to these 
sites.


Why does one version want to connect to these websites?

Is the torrent OK?

Thanks
B.






--
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] MacOS 64 bit 5.4.1 torrent issue

[bunk3m]

Hi all,

I downloaded the new release this morning via torrent.  When I started 
the LO, LittleSnitch indicated that it tried to connect to centrum.cz 
and bbx-fe-hp-pool.centrum.cz.


I checked out the sites and I can't figure out why LO would need to 
connect there.


I thought it strange so I downloaded 5.4.1 again directly.

I overwrote the torrent version with the direct download version and 
cleared all the LO rules in LittleSnitch.


In the direct download version there is no request to connect to these 
sites.


Why does one version want to connect to these websites?

Is the torrent OK?

Thanks
B.

--
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: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)

[bunk3m]

OK, a quick update.

I continued to fiddle with the language settings.

I'm not sure what I changed but LO said that the changes required a 
restart.  So I did the restart and now it works!  I can't figure out 
what exactly changed to cause the restart but it looks like it's OK now. 
 1+1.5=2.5 again!  Hurrah!


If you know what changes cause LO to require a restart to affect the 
change, I would appreciate knowing.  Then if this happens again I'll 
know what to do.


Thank you Jorge, Regina and Brian!

Cheers!
B.

On 29.07.2017 15:57, bunk3m wrote:

Hello Regina and Jorge,

Thank you for your help and suggestions.  I apologize for the delay as I 
didn't get the emails until I received the daily digest this afternoon. 
I have quoted both your posts in order to keep them together but this 
post is getting rather long.


I have tried your suggestions and I'm still unable to get a basic 
decimal calculation to work.


But now I am getting "#NAME?" for the cell containing "=1+1.5".

Interestingly enough, if I put "=1+20" it does give me "21" as an answer.

What it doesn't like about the decimal place I don't understand.  This 
is very strange.


I tried using a comma "," instead as a decimal separator but that didn't 
work either.


Perhaps I should delete all the preferences and all the extensions in 
the Application Support folder??  Then I would have a "new" install?


Thanks again and regards,
B.



--
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: Subject: Digest of users@global.libreoffice.org issue 2704 (52154-52162)

[bunk3m]

Hello Regina and Jorge,

Thank you for your help and suggestions.  I apologize for the delay as I 
didn't get the emails until I received the daily digest this afternoon. 
I have quoted both your posts in order to keep them together but this 
post is getting rather long.


I have tried your suggestions and I'm still unable to get a basic 
decimal calculation to work.


But now I am getting "#NAME?" for the cell containing "=1+1.5".

Interestingly enough, if I put "=1+20" it does give me "21" as an answer.

What it doesn't like about the decimal place I don't understand.  This 
is very strange.


I tried using a comma "," instead as a decimal separator but that didn't 
work either.


Perhaps I should delete all the preferences and all the extensions in 
the Application Support folder??  Then I would have a "new" install?


Thanks again and regards,
B.

On 29.07.2017 06:00, rb.hensc...@t-online.de wrote:

Hi,

bunk3m schrieb:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel fine
and Apple Numbers.  Mac settings are to show decimal as "."

I have some LO Calc sheets that were created a few years ago that are
OK.  It seems to be some change in the last few versions??

Would you know if there are any override settings in the LO Preferences?
 I can't find it if it exists.


There exists the setting in Tools > Options > Language Settings > Languages, 
where you can determine the decimal separator key.

In addition there is a setting "Ignore system input language", but I don't 
know, what effect it has.

Another setting is in the cell properties in Format > Cells. On the tab "Numbers" you find top 
right a "Language" drop-down list. You can determine the language for numbers independent from UI. Do 
not use the "Default - xyz" but select the correct language explicitly.

That the places I know, which might influence it.

Kind regards
Regina




On 29.07.2017 06:00, jrodriguez1...@gmail.com wrote:

Hi again:

I suggest to do this in the Language-Language settings:

*User Interface: Select English US

*Locale Settings: English (Canada)

*Decimal Separator Key: uncheck

*Default Currency: Default CAD (English or French)

*Default Language for Documents: A English Canada or French

*Ignore system input language: check

I did this in my LO, and restart LO, and then LO accept " . " as 
decimal separator key

I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 18:14, jorge Rodríguez escribió:

Hi:

In LO Preference (Menu-Tools-Options-Language settings), you can find some 
ways to customize your settings.

I hope this help,

Jorge Rodríguez


El 28/07/2017 a las 16:11, bunk3m escribió:

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel fine and Apple 
Numbers.  Mac settings are to show decimal as "."

I have some LO Calc sheets that were created a few years ago that are OK.  It 
seems to be some change in the last few versions??

Would you know if there are any override settings in the LO Preferences?  I 
can't find it if it exists.

Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually that kind of issues are define with 
the Operative System. Try to find how is it define it in you Mac. Probably is as " , " 
and you have to change to " . " as you use it in Canada.

Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:

I'm having a struggle with Calc.  I trying to migrate over from Excel but have 
a problem.

When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I save the file as an 
xlsx and open in Excel it calculates OK and give 2.5.  If I then open the xlsx in LO, it still says 
"Invalid Name".

If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada and we use 
"." to separate decimals.

If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC spreadsheet has 
this problem.

I'm not sure how to figure out why I get this error and why LO won't calculate 
such a basic equation.

What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.










--
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 - Invalid name error - help request

[bunk3m]

Thank you Jorge.

I have checked this.  The Mac settings are OK.  It works with Excel fine 
and Apple Numbers.  Mac settings are to show decimal as "."


I have some LO Calc sheets that were created a few years ago that are 
OK.  It seems to be some change in the last few versions??


Would you know if there are any override settings in the LO Preferences? 
 I can't find it if it exists.


Thanks again.
B.

On 28.07.2017 17:46, jorge Rodríguez wrote:

Hi :

 I don't have a Mac, I use GNU / Linux Ubuntu...but usually that 
kind of issues are define with the Operative System. Try to find how is 
it define it in you Mac. Probably is as " , " and you have to change to 
" . " as you use it in Canada.


Regards,


Jorge Rodríguez



El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc.  I trying to migrate over from Excel 
but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error.  If I 
save the file as an xlsx and open in Excel it calculates OK and give 
2.5.  If I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in 
Canada and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.






--
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 - Invalid name error - help request

[bunk3m]

I'm having a struggle with Calc.  I trying to migrate over from Excel 
but have a problem.


When I type [=1+1.5] into a cell, I get "Invalid Name" error.  If I save 
the file as an xlsx and open in Excel it calculates OK and give 2.5.  If 
I then open the xlsx in LO, it still says "Invalid Name".


If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in Canada 
and we use "." to separate decimals.


If I put [=1+1] LO correctly calculates "2" with no error.

I have older LO spreadsheets that calculate OK.  Every new CALC 
spreadsheet has this problem.


I'm not sure how to figure out why I get this error and why LO won't 
calculate such a basic equation.


What should I be looking at?

Mac OSX 10.10.5
LO 5.3.4 & 5.4

I'm on daily digest mode so please cc me when you reply to the list.

Thank you in advance.
B.

--
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: Letter page format size prints portrait pages as landscape on OS X

[bunk3m]

Alex,

Apologies if this has already been answered as I only get the daily digest.

In Canada our standard is letter (8.5" x 11"), legal (8.5" x 14"), 
tabloid (11" x 17").  Because we use the metric system, PCs usually 
default to cm.  This is totally useless since our paper standards are in 
inches.


I haven't had the problem with HP printers but I print to PDF more than 
direct to the printer. PDF production is good.  Perhaps the people with 
this issue should print to pdf first and then open in Preview and print 
the PDF.  I've done this in the past when Acrobat did silly things.


Until today I was using LO 5.3.4. Today I upgraded to 5.4 so we'll see 
if this changes.


B.

On 28.07.2017 05:14, Alexander Thurgood wrote:

Le 27/07/2017 à 22:09, amaloney a écrit :

Hi Al,



I have reported this as a recurrent bug - Bug 86838
When attempting to print a Writer portrait document, it prints rotated 90
degrees (= landscape).

This occurs with 5.3.5.X and 5.4.0.x

Does anyone have a similar problem?


For those users who don't care to read through the whole shebang of
comments on that bug report :

- it appears to affect only Mac OSX;

- it appears to affect only those users for whom the locale-based
default page setting is Letter - in other words, mainly US and Canadian
(not sure what the default page size is in Canada?) based users;

- it mainly seems to show up with Brother and HP printers.


Reports from users corresponding to the above much appreciated.


Alex






--
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] Formula calculation differences between LO 5.3 and Excel

[bunk3m]

When I open most Excel documents I get a message (as per attached
screenshot) that says

"This document was last saved by Excel. Some formula cells may produce
different results when recalculated.  Do you want to recalculate all
formula cells now?"

Where do I find out what these calculation difference might be?

Is there a document that outlines what incompatibilities exist between the
calculation engines?

If not, can someone summarize what potential issues I need to take into
account when using LO?

I am on digest mode so please cc me directly in any responses.

Thank you in advance for your help.

B.

-- 
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 multiplication & division formulas acting strangely (Mac 5.2.3)

[bunk3m]

Thanks again Brian.  Appreciate that you take time to comment and help!

Some additional comments inline below.

On 7 November 2016 at 23:53, Brian Barker  wrote:

> At 14:20 07/11/2016 -0500, Bonly Noname wrote:
>
>> On 2016-11-06 8:43 PM, "Brian Barker"  wrote:
>>
>>> At 20:06 06/11/2016 -0500, Bonly Noname wrote:
>>>
 Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do
 a multiplication with a decimal, Calc gives me a #NAME?. In cell A1R1
 =4*1.5 gives #NAME? In each spreadsheet that I've opened I get the same
 problem. When I do 4*150%, Calc changes the formula to =4*1.5 and gives 6.
 Then I try =4/1.5 and I get #NAME?
 [...]
 What's going on here? What should I be looking into?

>>>
>>> This is exactly what you will see if your settings are for a locale
>>> which uses the comma instead of the point as the fractional separator (as
>>> many do). You can confirm this easily by entering (to modify your first
>>> example):
>>> =4*1,5
>>> - which should work.
>>>
>>> You need to tell Calc to expect the point as the fractional separator.
>>> Before installing any application software, select appropriate locale
>>> settings in your operating system. Only if necessary, modify the settings
>>> in the application. In LibreOffice, go to Tools | Options... | Language
>>> Settings | Languages and make appropriate selections there. (Oh, on the
>>> Mac, for "Tools | Options..." read "LibreOffice | Preferences".)
>>>
>>
>> Thank you Brian. I thought that was the issue, but I've tried =4*1, 5 and
>> it gives me Err:509.
>>
>
> Well, it will - since you've inserted that unhelpful space! We need the
> number one-and-a-half, not the two separate numbers one and five. The test
> is =4*1,5 - as I suggested. I'm sticking with my suggestion that this will
> work!
>

This was just an additional space typo due to autocorrect or thumb typing
on my tablet.


> I can open old Calc spreadsheets with decimal inputs and have no problem
>> until I try to enter new numbers.
>>
>
> That's also consistent with my suggestion. Formulae in existing documents
> are reinterpreted in the light of your new settings.
>
> I've noticed that if the formula is multiply by less than 1.0, the
>> calculation works.  As soon as I try any decimal greater than 1.0, I get
>> the #NAME?. =0.99 * 0.99 works =1.1*0.99 gives #NAME? =2*0.99 works =2.1*1
>> #NAME? Very weird.
>>
>
> I don't immediately see what is happening here, but it has to be said that
> there are very many places where locales and languages are set. It's
> difficult to test every possibility without messing up my system. Note, for
> example, that the cell formatting has its own language setting (at Format |
> Cells... | Numbers | Language), though that ought to affect only the
> display of results, not the interpretation of input.
>

It is confusing.  As a summary, any number entered that is a decimal less
than 1.0 (one) can be entered OK and calculates OK.  Any decimal number
greater than 1.0 gives the $NAME# error.

I didn't realize that there was another language setting in the cell
format.  I've checked and it is set to the default which is "Canada
English".  So it is consistent (exactly the same) between the Mac OSX
10.10.5 and the various places in LO.


>
> You might want to get someone to look at a sample document to see what is
> happening.
>
> Brian Barker
>

I'm happy to provide a sample document.  How would I go about finding
someone who would look at it?

Thanks again,
B.

-- 
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 multiplication & division formulas acting strangely (Mac 5.2.3)

[bunk3m]

On 2016-11-06 8:43 PM, "Brian Barker"  wrote:
At 20:06 06/11/2016 -0500, Bonly Noname wrote:
Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a
multiplication with a decimal, Calc gives me a #NAME?. In cell A1R1 =4*1.5
gives #NAME? In each spreadsheet that I've opened I get the same problem.
When I do 4*150%, Calc changes the formula to =4*1.5 and gives 6. Then I
try =4/1.5 and I get #NAME?
[...]
What's going on here? What should I be looking into?

This is exactly what you will see if your settings are for a locale which
uses the comma instead of the point as the fractional separator (as many
do). You can confirm this easily by entering (to modify your first example):
=4*1,5
- which should work.

You need to tell Calc to expect the point as the fractional separator.
Before installing any application software, select appropriate locale
settings in your operating system. Only if necessary, modify the settings
in the application. In LibreOffice, go to Tools | Options... | Language
Settings | Languages and make appropriate selections there. (Oh, on the
Mac, for "Tools | Options..." read "LibreOffice | Preferences".)

I trust this helps.
=
Thank you Brian.

I thought that was the issue, but I've tried =4*1, 5 and it gives me
Err:509.

I have used LO since it started as a fork from SO and never had this
problem before.

The decimal separator is the same as the locale English (Canada) which is (
. ).

I can open old Calc spreadsheets with decimal inputs and have no problem
until I try to enter new numbers.

I've noticed that if the formula is multiply by less than 1.0, the
calculation works.  As soon as I try any decimal greater than 1.0, I get
the #NAME?.

=0.99 * 0.99 works
=1.1*0.99 gives #NAME?
=2*0.99 works
=2.1*1 #NAME?

Very weird.

I'm using OSX 10.10.5 if that points to anything.

I also tried LO 5.1.6 with same result.

Thanks again for any suggestions and help.

-- 
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 multiplication & division formulas acting strangely (Mac 5.2.3)

[bunk3m]

Today I created a spreadsheet in 5.2.3 (Mac) and each time I try to do a 
multiplication with a decimal, Calc gives me a #NAME?.


In cell A1R1 =4*1.5 gives #NAME?

In each spreadsheet that I've opened I get the same problem.

When I do 4*150%, Calc changes the formula to =4*1.5 and gives 6.

Then I try =4/1.5 and I get #NAME?

The cell is formatted as Number:General so it should calculate.

I've opened spreadsheets created in Excel in LO Calc and they have the 
same problem.


Functions are OK as far as I can tell.

I've checked all formats, settings that make sense, Googled and checked 
the help if something has changed but I'm at a loss.


??What's going on here??

What should I be looking into?

B.

PS On digest mode so please CC me directly. Thank you!

--
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: Re: [libreoffice-users] Can't open LibreOffice on Mac

[bunk3m]

Larry,

Usually you can also "right-click" on the Libreoffice Application and 
select "Open" from the menu.  It will ask you if you really want to do 
that.  If you select "Yes", Libreoffice should open.


B.

On 06.11.2015 14:04, Italo Vignoli wrote:

On 06/11/15 19:41, Larry Gusaas wrote:

>Can't open LibreOffice 5.0.3002 on my Mac (OS X ver. 10.11.1 El Capitan)
>Get the following message:
>
>“LibreOffice.app” is damaged and can’t be opened. You should move it
>to the Trash.

Hi Larry, you should go to System Preferences > Security & Privacy and
in the General tab choose "Allow apps downloaded from Mac App Store and
identified developers" before launching LibreOffice for the first time
(in some cases you need to choose "Allow apps downloaded from anywhere":
the first option works fine on my MacBook, and does not work on my
MacBook Air). After you have launched LibreOffice, you can switch back
to the most secure option.

-- Italo Vignoli - Marketing & PR mobile +39.348.5653829 - email /
jabber it...@libreoffice.org hangout / jabber italo.vign...@gmail.com -
skype italovignoli GPG Key ID - 0xAAB8D5C0 DB75 1534 3FD0 EA5F 56B5 FDA6
DE82 934C AAB8 D5C0
-- 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: LO 4.4 is supposed to import Pagemaker files? How?

[bunk3m]

On 14.05.2015 13:37 , Andreas Säger wrote:

Am 14.05.2015 um 19:18 schrieb Brad Rogers:


Unless I've misunderstood what bunk3m wrote, that resulted in a General
I/O error.


Ooops. Then LibreOffice can not open that file because the file is not a
pagemaker file, a corrupted pagemaker file or an unsupported pagemaker file.

Try http://www.zamzar.com  or find some machine with pagemaker up and
running and let it export your files to whatever suitable.


Thank you everyone for suggestions.  I apologize for the delay in 
testing and replying.


I tried www.zamzar.com but Pagemaker 6.5 files can't be converted using 
this service.  I am pretty sure this was close to the last version 
available on the Mac platform.


Where do I find the documentation of which versions of Pagemaker should 
work with LO?  I don't remember reading which versions were designed to 
work in the docs but it quite likely that I didn't find the right URL.


Since these files are quite old, it is possible that the files are 
corrupted. I've had them inside a zip archive and tried new unarchived 
versions with the same result.


I did receive an email from someone regarding submitting the file for 
bug testing.  I seem to have misplaced that email so would you mind 
sending me the link again?  Thanks and apologies.


B.

PS On digest mode.

--
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] LO 4.4 is supposed to import Pagemaker files? How?

[bunk3m]

I was all excited by the recent announcement that LO can open a number 
of older Mac file formats and Pagemaker files.  I am running the Mac 64 
bit version of LO 4.4. (OSX 10.9.5)


So I wanted to finally convert a number of older Pagemaker 6.5 files to 
something useable.


I searched the docs and searched this list to find instructions of 
converting these files.  All I can find is that you should import the 
Pagemaker files.


There is no import command that I can find.  Where is this?

I tried to open the Pagemaker 6.5 files directly but get General Error. 
General Input / Output error.


So how are you supposed to open Pagemaker files?

Please not that I'm on digest.  If you wouldn't mind cc'ing me directly 
when / if you reply to the list.


Thanks in advance,
B.

--
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] Update Java and LO to 4.4.1002 and now LO won't start

[bunk3m]

Hello.I updated my Java to Java 8u40 and deleted the old Java 7 from
/Library/Java/and updated LO to the recent 4.4.1002 for Mac 64 bit.  I 
am using
OSX 10.9.5I tried to start LO and it won't complete the start saying that I
need to install Java 6 from Apple.  When I click on Not Now LO
quits.I understand from the Nabble posts that at one time 64 bit Java
didn't work with LO but those posts were a few years back and
besides, LO ran quite happily on another Mac we have that doesn't
have Java at all as far as I can tell.  We never use Base.How do I trick LO 
to start so I can tell it to use Java 8 in the
prefs?  Or how do I get LO to start without needing to install the
Old Java SE 6 from Apple?I have googled this and I have read the install 
docs and a few dozen
forum posts.  I haven't found something that addresses this so far
so if it exists please help me to find it.Thanks in advance for your 
help.PS I'm on digest mode so please cc me directly.  Thank you!
-- 
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] date acceptance patterns not sticking

[bunk3m]

Libreoffice is driving me nuts.

I am in Canada. UI is set to English US; Locale settings to English 
Canada and Default Currency is CAD.


I have my Mac set dates to dd.mm.. (OSX 10.9.x)

For some reason Libreoffice (4.3.1.2) will only accept dates in the 
-MM-DD format.


I'm happy that I can format the date to look DD.MM. but entering in 
the -MM-DD is totally unnatural for me.


Actually, I only usually type the DD.MM and expect the  to show up 
automatically in Excel.  I'd like the same behaviour in LO if possible.


The date acceptance patterns will not accept anything except what is 
loaded by default ... which is

D.M.;DD-MM-;D-M

I don't want to have to type the  each time for D.M..

I've tried to add D.M to the acceptance pattern but the text turns red 
and won't save.  The D.M is always gone after trying to save.


So if the date acceptance patterns are supposed to be customizable by 
the user ...


what do I have to do to get this to work?

Thanks in advance.
B.

PS I'm on digest mode.  Please CC me directly

--
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: LO 3.5.1 Java weirdness on OSX

[bunk3m]

Thank you, Alex.

On 26.03.2012 5:16 , Alexander Thurgood wrote:
 Le 22/03/12 15:48, bunk3m a écrit :

 Hi,

 
  LO doesn't find any Java version except for one.
 I don't think it can anymore automatically (but I'm prepared to be
 proven wrong ;-)), at least not on Mac, the handling of the Java path
 was changed during 3.4.x or 3.5.x development, I seem to recall, because
 LO was having problems recognising the write system Java path.


That is too bad.  I'd like to use an updated Java since Apple is a bit slow
to update.


  I want to run a more recent version and have more recent versions of
  Java installed.
 
  But I can't add the versions of Java RE installed in
  Library/Java/JavaVirtualMachines
 
  I have OpenJava 1.7.0u.jre installed in
Library/Java/JavaVirtualMachines
 
  Questions:
  Why doesn't LO use the 1.6.0_31 version installed?
 
  Why can't I select to run 1.7.0u.jre from
Library/Java/JavaVirtualMachines?
 
 Like I said, I think it has to do with the path changes introduced for
 Java recognition during 3.4/3.5 development (I don't exactly remember
 when this happened).

 The only thing I can think of is if you change your environment
 variables in your session bash profile or the corresponding session
 plist. You might then be able to force LO to take the Java version of
 your choice.

I checked my .profile and changed the Java_home to where the OpenJava
1.7.0u.jre is installed.
Now java -version shows the correct 1.7.0 version.

---quote---
java -version
openjdk version 1.7.0-u4-b13
OpenJDK Runtime Environment (build 1.7.0-u4-b13-20120224)
OpenJDK 64-Bit Server VM (build 23.0-b16, mixed mode)
---end quote---

LibreOffice 3.5.2 still shows the 1.6.0_29.   I can't get the Options:Java
to select the newer java 1.7.0 version.  I tried to Add and Class Path
but no luck.  Shouldn't this work?

While I understand that the automatic finding of java versions on the Mac
has been problematic and been discontinued, shouldn't I be able to use
Add or Class Path to add the OpenJava 1.7.0 version?

I think that since Apple has decided to stop providing Java and is leaving
it up to the vendor, then the default install place will change to
/Library/Java from /System/Library/Java/JavaVirtualMachines.   In that case
how will LO find a functioning recent version of java 




 Alex

Thanks again for your help, Alex.

Cheers!
B.

-- 
For unsubscribe instructions e-mail to: users+h...@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] LO 3.5.1 Java weirdness on OSX

[bunk3m]

Hi all.

I've noticed some strange behaviour with LO 3.5  LO 3.5.1.2 that I
installed this morning.  I was using Base and since I had some
difficulties and slow processing I followed a discussion on how to get
Java memory increased and also select different Java versions.  Before
this, I didn't worry about it.  I am running LO on OSX 10.6.8

I've googled but not found anything to help so far.

LO doesn't find any Java version except for one.

From LO Preferences:Java
I have:

Use Java Runtime environment selected.
Java vendor: Apple Inc.
Version: 1.6.0_29

But from the terminal I get:
---quote---
$ java -version
java version 1.6.0_31
Java(TM) SE Runtime Environment (build 1.6.0_31-b04-411-10M3616)
Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01-411, mixed mode)
---end quote---

I want to run a more recent version and have more recent versions of
Java installed.

But I can't add the versions of Java RE installed in
Library/Java/JavaVirtualMachines

I have OpenJava 1.7.0u.jre installed in Library/Java/JavaVirtualMachines

Questions:
Why doesn't LO use the 1.6.0_31 version installed?

Why can't I select to run 1.7.0u.jre from Library/Java/JavaVirtualMachines?

(I'm on Digest mode so could you also CC me on a reply)

Thank you in advance.
B

-- 
For unsubscribe instructions e-mail to: users+h...@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] LO 3.5.1 Java weirdness on OSX

[bunk3m]

This email didn't show up in the digest or in archive so I'm sending it
again.  If it did appear and I can't find it, I apologize in advance.
---
Hi all.

I've noticed some strange behaviour with LO 3.5  LO 3.5.1.2 that I
installed this morning.  I was using Base and since I had some
difficulties and slow processing I followed a discussion on how to get
Java memory increased and also select different Java versions.  Before
this, I didn't worry about it.  I am running LO on OSX 10.6.8

I've googled but not found anything to help so far.

LO doesn't find any Java version except for one.

From LO Preferences:Java
I have:

Use Java Runtime environment selected.
Java vendor: Apple Inc.
Version: 1.6.0_29

But from the terminal I get:
---quote---
$ java -version
java version 1.6.0_31
Java(TM) SE Runtime Environment (build 1.6.0_31-b04-411-10M3616)
Java HotSpot(TM) 64-Bit Server VM (build 20.6-b01-411, mixed mode)
---end quote---

I want to run a more recent version and have more recent versions of
Java installed.

But I can't add the versions of Java RE installed in
Library/Java/JavaVirtualMachines

I have OpenJava 1.7.0u.jre installed in Library/Java/JavaVirtualMachines

Questions:
Why doesn't LO use the 1.6.0_31 version installed?

Why can't I select to run 1.7.0u.jre from Library/Java/JavaVirtualMachines?

(I'm on Digest mode so could you also CC me on a reply)

Thank you in advance.
B

-- 
For unsubscribe instructions e-mail to: users+h...@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] LO 3.4.0 language pack for EN-US?

[bunk3m]

I was going to download v3.4.0 but the site shows null for the
language pack (en-us).  I checked the Other ways to download but
couldn't find it.

Where is it?

Thanks.
Bunkem

-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Positive result story to share

[bunk3m]

Normally the list is about problems and solutions.

So I wanted to share something with everyone that is positive.

My son has a school supplied laptop that only has MS Office (XP).  It is
locked down so tight that we can't install anything onto it. 

He prepared his Powerpoint presentation (in .ppt), put it on a USB key
and took it to school.  

But it wouldn't load on the PC at school running MS Office 2007.  :-(

It also wouldn't open on my Mac running Office 2011.  :-( 
I tried Office 2011 because I thought the MS formats would be
compatible.  Wrong.

I use Libreoffice more than Office so I thought we would try it.  (I
also test the betas)

The presentation opened without any problem.  We saved it to PDF so he
could take it to school.  The pdf worked OK. 

So all you developers, be pleased with your work!  It is getting better
and better.  In many cases, I now see it is better than MS Office! 
Congratulations!

A win for Libreoffice!!



-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Base stand alone

[bunk3m]

On Thu, 24 Mar 2011 13:10:39 +0100, Andreas Sägerville...@t-online.deam 
24.03.2011 12:44, Renato Pontefice wrote:Hi,I'm very very new to Libreoffice 
(about 5 minutes:-))I have to create a DB. Of course I will use Base, but:- I'm 
wondering if it could be published as a stand alone. I
  mean:I need to create the DB, but my client won't have Libre office
  (and it workswith MS Windows). So I'm intrested on a way to publish 
DB with
  run time. Isthere)TIARenatoSorry, Base is not a database program. It 
is hardly more than a
bridge between database backends (MySQL, Postgre and many
others) and office documents (serial letters, bibliographies,
calculation models,...).The single-document type of zipped HSQLDB can 
do a small
fraction of the stunts you may know from MS Access but at the
high cost of bad performance, single user security, bad safety
(data loss).Base is extremely useful in what it has been made for. No 
more,
no less.Greetings,Andreas
You could try using HSQLDB directly for your client.  Download 
athttp://hsqldb.org/ The version in OpenOffice (and I assume also 
LibreOffice??) is
v1.8. B
-- 
Unsubscribe instructions: E-mail to users+h...@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***