Re: [libreoffice-users] question hyperlinks in Calc.

[Wiebe van der Worp]

On 31-08-2024 00:52, Martin /Nightowl/ Byttebier wrote:

Yes I was hoping the setting in tools/options/calc/general/update
references when sorting would solved the problem but alas ... with
this option set LO crashes big time. In no time the memory used goes
from 3,1 GB to 13 GB and more (16 GB available) with almost 100 %
cpu-usage.
The log says something like this "out of memory".

For your information. I'm running LO 24.8.0.3 under openSUSE Tumbleweed
20240828 x86_64, KDE Plasma 6.1.4 (X11) with 16 GB RAM but without swap.

The same happens with LO 7.6.7.2
Xubuntu here, both 22 and 24, LO 7* and 24*. I just did a little test, 
sorting, inserting and checking the resulting links. Works fine but with 
the suggested setting. The RAM memory is ‘small’, I can't get it above 
several hundred MBs


Is it possible that there are contaminants in the sheet? Large embedded 
data blocks? OLE stuff?


If I were in your shoes, I would paste the contents to a new sheet in a 
controlled, metered way to find out where and when it goes wrong. 
Extracting the ods file and examining it globally is, of course, also an 
option.



--
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] question hyperlinks in Calc.

[Wiebe van der Worp]

On 29-08-2024 23:53, Martin /Nightowl/ Byttebier wrote:


Probably I am doing something wrong, but what?


No idea, sounds complex. In menu Tools > Options > LO Calc > General, 
there is an option Update references...


That was a problem I had recently resulting in #REF problems.

Just a wild guess, suggestion...

Hope you're able to solve it.


--
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] Resizing Document

[Wiebe van der Worp]

In addition...

On 14-07-2024 09:48, Keith Bates wrote:

That works perfectly, especially as I already had to produce a pdf!

On 12/7/24 21:50, Brian Barker wrote:
Portable Document File documents are scalable, so one easy workaround 
would be to export a copy of the original document as PDF, open this 
in your favourite PDF viewer, and print it from there scaled up to 
fit (at 141%). Any editing you needed to make could be made to the 
original version, before the export. 


... and print it to PDF directly,

or you can open the PDF in Inkscape, choose the right paper size 
(ctrl-shift-r), resize content and save it as PDF.



--
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] Master document and styles.

[Wiebe van der Worp]

On 14-01-2024 17:02, Michael Tiernan wrote:

I have a master document which has a number of styles in it.

I have a "Page/Section" template that I distribute to others to create 
sections for inclusion into the master.


Is working with .ott templates an option? I've written some things here, 
hope it helps:


https://vanderworp.org/libreoffice-template-bugs/
and
https://vanderworp.org/libreoffice-writer-template-changing/


--
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] stripping crlf

[Wiebe van der Worp]

On 03-01-2024 20:18, Brian Barker wrote:

At 11:08 03/01/2024 -0500, Bill Drescher wrote:

What can I use to replace the line break with a space?


Just "$" (no quotes), it seems.

Another thought: consider using Paste Special (instead of ordinary 
Paste) and "Unformatted text" when inserting text from elsewhere. This 
avoids some problems.


In addition, "$" is a regex, use regular expressions check box. In case 
of a normal paste operation, because you want to preserve hyperlinks for 
example, you may want to remove formatting, i.e. select and ctrl-m.



--
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] Assembling a Master Document.

[Wiebe van der Worp]

Now write something in that blank doc that is text. Then you should 
modify that text style to correspond with what you're using in your 
sub-docs so that when they're imported, they automatically use the 
correct style.


It is still odd we can't change templates from the interface. Template 
usage is one of the LibreOffice blessings.


To overcome this, I created a script. It may be of use in cases with 
master documents and large amounts of slave documents.


For more see: https://vanderworp.org/libreoffice-writer-template-changing/


--
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] In Calc, Window sizing impairment

[Wiebe van der Worp]

On 08-05-2022 15:52, Rogier F. van Vlissingen wrote:

1. When it is on full screen and I click on the resize button (middle
button), it is minimized.
2. At this point, when I click on the calc icon, I only have the option
to maximize it, there is no "restore" option.


In Linux it is a handy habit to drag windows combined with the alt-key. 
So you might want to try the following in a maximized window state:


* Move your mouse very roughly to somewhere around a corner.
* Press and hold Alt-key
* Start dragging with your right mouse button to a preferred position
* Release your fingers from keyboard and mouse

PS Alt + Left Mouse Button is "moving the window".

--
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] Links in documents

[Wiebe van der Worp]

On 30-09-2020 20:52, Dave Howorth wrote:

On Wed, 30 Sep 2020 19:33:13 +0200
Wiebe van der Worp  wrote:



The lack of response is probably a confirmation that there is no
mechanism to keep links to various external sources up to date.


Which suggests that this is probably the wrong forum to discuss it.
Either a bug report or another mailing list would seem appropriate,
though I don't know which of
https://www.libreoffice.org/get-help/mailing-lists/ is appropriate. :(


I see what you mean. The project is served by paying the deserved 
attention to this subject. The question is more or less answered and the 
(q&d( solution is available, I solved it with a script for Linux (lives 
here: https://vanderworp.org/en/libreoffice-writer-template-changing/) 
but I see there is an extension available again at 
https://extensions.libreoffice.org/en/extensions/show/template-changer/.


--
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] Links in documents

[Wiebe van der Worp]

On 27-09-2020 17:42, Wiebe van der Worp wrote:

Thing is that links break when mailing or moving and that is a serious 
flaw.


For example, I would expect a template name without path in a document 
xml, result in a search for that template in:


  * the designated template folder
  * the home folder
  * the folder where the document lives

Apparently this does not work, not even one folder is consulted.

Is there some sort of a search path available? A policy? It would 
really be helpful if this subject is discussed and I would love to see 
a contribution.


The lack of response is probably a confirmation that there is no 
mechanism to keep links to various external sources up to date.


It is probably save to state that if you want to repair a link lacking 
an interface element, then unzipping, editng xml and zipping is the only 
way.


Odd but okay.

--
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] Links in documents

[Wiebe van der Worp]

Nobody?

On 23-09-2020 10:45, Wiebe van der Worp wrote:

On 20-09-2020 09:01, Philip Jackson wrote:
But as Robert says, too, the path is indicated in the absolute form in 
the Document Path field. Right clicking on the link and selecting Edit 
Hyperlink also shows an absolute path. But inspection of content.xml 
confirms that the path is relative.


If the file with the hyperlink is moved to a different directory, the 
link updates showing again an absolute path as though the linked file 
has also been moved. But, of course, the link no longer works because 
it was relative and all the files concerned are no longer in the same 
directory.


Is there someone able to shine a light on this subject?

Thing is that links break when mailing or moving and that is a serious 
flaw.


For example, I would expect a template name without path in a document 
xml, result in a search for that template in:


  * the designated template folder
  * the home folder
  * the folder where the document lives

Apparently this does not work, not even one folder is consulted.

Is there some sort of a search path available? A policy? It would really 
be helpful if this subject is discussed and I would love to see a 
contribution.




--
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] Links in documents (was: Create a relative hyperlink to file?)

[Wiebe van der Worp]

On 20-09-2020 09:01, Philip Jackson wrote:
But as Robert says, too, the path is indicated in the absolute form in 
the Document Path field. Right clicking on the link and selecting Edit 
Hyperlink also shows an absolute path. But inspection of content.xml 
confirms that the path is relative.


If the file with the hyperlink is moved to a different directory, the 
link updates showing again an absolute path as though the linked file 
has also been moved. But, of course, the link no longer works because it 
was relative and all the files concerned are no longer in the same 
directory.


Is there someone able to shine a light on this subject?

Thing is that links break when mailing or moving and that is a serious flaw.

For example, I would expect a template name without path in a document 
xml, result in a search for that template in:


 * the designated template folder
 * the home folder
 * the folder where the document lives

Apparently this does not work, not even one folder is consulted.

Is there some sort of a search path available? A policy? It would really 
be helpful if this subject is discussed and I would love to see a 
contribution.


--
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] Re: [6.4.2.2] How to set same font + size for all Text Body paragraphs?

[Wiebe van der Worp]

On 14-07-2020 08:56, Gilles wrote:

Lessons learned:

...

3. To remove local changes, select the text, and hit CTRL+M ("Clear Direct
Formatting").


Like a pasted HTML table in calc and then > ctrl-a > ctrl-m.

I am still confused why ctrl-m is removed. A bit off topic, but was that 
a bug? Is there a very good reason to do this? Or was it an action I 
better not label?



--
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] What happened to templates... part 2

[Wiebe van der Worp]

Let's say we take care of the following:

In Options -> LibreOffice -> Paths -> Templates add path to template.ott

In File -> Templates -> Manage Templates -> template.ott is available.

A new document is created: File -> New -> Templates -> template.ott

All goes well, document document.odt is saved. Template updates are
reflected in the document too.

File document.odt is moved to another directory. This means template
location in meta.xml is not pointing to template.ott. Link is broken.

Document.odt is opened. Location of template.ott is not corrected in
meta.xml. Link stays broken while template.ott is at the right spot in
the designated template folder.

The only solution known to me is unzipping document.odt, repairing
meta.xml and zipping back to document.odt.*

I find it hard to believe that moving a document, or mailing a document,
is enough to break the connection with the template permanently.

Is there anyone able to shed some light here?

Beste regards,

Wiebe van der Worp

* Repairing meta.xml: a shell script lives now here:
https://vanderworp.org/en/libreoffice-writer-template-changing/

-- 
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] Font with visible spaces

[Wiebe van der Worp]

This time not a question, but an answer...

I needed a style, a font, with spaces made visible, couldn't find it,
modified a font.

If you need it some day, it lives at http://media.nedcad.nl/support/

A few thing were interesting to learn:

Copying from PDF-readers: Trailing space character(s) of a selection are
skipped.

In Writer, formatting marks (Ctrl-F10) itself also contain spaces that
are made visible with this font.

Best regards, Wiebe

(background information:
https://nedcad.nl/en/paste-on-the-command-line/)

-- 
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] Change Templates in Writer

[Wiebe van der Worp]

My previous posts did not seem to arive...

After some additional studying, it seems to be working now: assigning a
template to a document.

I've published it here:
https://nedcad.nl/en/libreoffice-writer-for-technical-documentation/

The link to the script is on that page too, hope it may help someone,
some day.

-- 
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] Templates not linked in Writer after update to Xubuntu 18.04

[Wiebe van der Worp]

On 10-11-18 21:52, Regina Henschel wrote:
> Hi,
> 
> Wiebe van der Worp schrieb am 10-Nov-18 um 20:10:
>> After updating to Xubuntu 18.04 I was quite surprised to find out that
>> ott templates are not linked to documents any more.
> 
> It might be, that now the templates are not where the document expects
> it. The information about the template is in a node meta:template in the
> file meta.xml in the document package. [You know, that a document is
> actually a zip-container?]
> 
> Now compare, whether the path, which is listed in the file, would go to
> the template in your LibreOffice installation.
> 
> Kind regards
> Regina
> 
> 

@regina, thanks. node meta:template in file meta.xml was not found. I
assume this is what is also shown in File > Properties > Tab General >
Template (?)

No Template Changer AND no linked templates is a show stopper, so back
from 6.n to 5.n and since this did not help much:

Package latest and greatest 5.4.7.2 from
https://downloadarchive.documentfoundation.org/libreoffice/old/

unzipped in ~/Downloads
delete all from ~/.config/libreoffice

sudo su
apt-get remove --purge libreoffice*
apt-get clean
apt-get autoremove
cd ~/Downloads/LibreOffice_5.4.7.2_Linux_x86-64_deb/DEBS/
dpkg -i *.deb

In LO: Tools > Options > Paths > Templates > Added location of custom .ott

When I create a document based on a standard template, template
information is included
Ditto when custom template is used.
When I paste from a source, template information is blanked

Time for Template Changer from
https://www.odfauthors.org/libreoffice/english/resources-for-contributers/template-changer-extension/at_download/file
(1.2.7d)
Installed it
Restarted Writer
Assign Template to new document > select template > Ok and...
Crash of LO

Looping what is before in order to try 5.3.7.2
Same story, except first hanging and then crashing.

So I installed the distro version 6.0.6.2 again without Template Changer.

What I did now, is very carefully paste information from documentation.
Added a field with template information for controlling the link. Part
by part pasted, creating new TOC's, it works without breaking the
template link.

Considering the large amount of documents I maintain, it is all in all
quite frustrating, but with a little progress fortunately.

If I do grep on an unzipped and empty document with template
"template-name", like
grep -r -i "template-name" *
I get only one result in meta.xml

Maybe a stupid question, but does changing template information directly
in meta.xml help in cases where I loose template links? In that case,
BASH doing unzip sed and zip might be a hackish solution.

All suggestions appreciated very much!

-- 
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] Templates not linked in Writer after update to Xubuntu 18.04

[Wiebe van der Worp]

After updating to Xubuntu 18.04 I was quite surprised to find out that
ott templates are not linked to documents any more.

Trying to solve this, I found out "Template Changer" is broken.

Now I am trying to downgrade LibreOffice, but that fails because
template changer (1.2.7d) / LO crashes during the assign process.

This is what I installed after removing 6.n:
http://downloadarchive.documentfoundation.org/libreoffice/old/5.4.7.2/deb/x86_64/
(dpkg -i *.deb)

Anybody familiar with this? And having suggestions how to solve this?
All my documentation is based on linked templates so for me this is a
huge problem.


-- 
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] Simple way to draw graphs ?

[Wiebe van der Worp]

On 15-08-17 12:43, Brian Barker wrote:
> At 12:14 15/08/2017 +0200, Wiebe van der Worp wrote:
>> Please also be aware of the fact that data itself is not copyrighted.
>> In other words, copying data to Calc and use it to create a graph and
>> an accompanying table should never be a problem - if my memory serves
>> me well.
> 
> This may be true in the USA (is it?), but a few seconds of web searching
> shows this certainly not to be so in all jurisdictions. (The text on the
> original chart was in French and the original enquirer wrote from a
> French e-mail address.)

You're right about complexity and everyone should make a well thought
decision. I've asked a lawyer and translated his Dutch answer to English:


It's complicated. There are jurisdictions with a sweat-of-the-brow
copyright protection. Then there is the EU with its data bank protection
(in itself a wrong instrument) that has caused all kinds of weird sui
generis protection of data (such as the Dutch "geschriftenbescherming")
to be invalid.

I would not categorically dare to say that data by definition falls
outside the scope of copyright (within the EU it does, because of data
bank protection, which is something else (and complicated in its own way)).


Maybe this makes it a bit more clear:
https://en.wikipedia.org/wiki/Sweat_of_the_brow


-- 
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] Simple way to draw graphs ?

[Wiebe van der Worp]

On 15-08-17 09:34, Mike Scott wrote:
>> Gilles schrieb:

>>> I'd like to use LO to redraw graphs scanned from a book, such at this
>>> one:
>>>
>>> 

> Can I also point out that LO isn't necessarily the correct tool? I've
> lately discovered the joys of gnuplot -- more flexible than LO, and an
> image created by it could of course be imported into an LO document.
And since it supports SVG, it can be post edited by Inkscape before
inserting it as razor sharp image (set term svg, set output
"yourfile.svg, before plot")

> As others have pointed out, beware copyright of the data.

Please also be aware of the fact that data itself is not copyrighted. In
other words, copying data to Calc and use it to create a graph and an
accompanying table should never be a problem - if my memory serves me well.

-- 
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] Pasting data from LO Calc to BricsCAD

[Wiebe van der Worp]

Thanks for your reply Brian and Bruce...

On 11-07-17 03:02, Brian Barker wrote:
> At 23:52 10/07/2017 +0200, Wiebe van der Worp wrote:
>> I was watching this video:
>> https://blog.bricsys.com/tutorials/bricscad-spreadsheet-import/ It
>> describes two methods to get data from a spreadsheet to a CAD table
>> entity. The first method uses csv from Calc, imported to CAD. The
>> second method is a paste special procedure with Excel (viewer) with
>> preservation of (a limited set of) formulas. The question concerns the
>> second method: Is there an easy way to achieve this with Calc without
>> an Excel viewer?

> You can copy a range of a
> spreadsheet sheet from Calc just as you could from Microsoft Excel or
> the Excel Viewer. The question then is what your other product makes of
> that in pasting it in. Try Paste and try Paste Special, and try whatever
> options that offers. The copy from Calc will carry formulae; the only
> question is whether your other product can use this properly. I'd guess
> it probably would, but I don't have it to try.

BricsCAD runs on Linux too, making it, combined with Calc, a nice and
powerful combo. First thing I did after watching was trying all paste
options without success. But it is good to know that clipboard data
contains formulas.

As a second approach I unzipped a Calc file and tried to import
content.xml and got an error in BricsCAD: "Failed to find
'Workbook/Worksheet/Table' node in XML data." I guess it only expects
Excel. I will leave a comment at the blog entry...

Bruce, I tried your suggestions without success.

On the other hand: There is nothing wrong with importing cvs, it is a
working solution. And it was nice to see someone use Calc.

-- 
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] Pasting data from LO Calc to BricsCAD

[Wiebe van der Worp]

Hello everyone, I was watching this video:
https://blog.bricsys.com/tutorials/bricscad-spreadsheet-import/

It describes two methods to get data from a spreadsheet to a CAD table
entity. The first method uses csv from Calc, imported to CAD. The second
method is a paste special procedure with Excel (viewer) with
preservation of (a limited set of) formulas.

The question concerns the second method: Is there an easy way to achieve
this with Calc without an Excel viewer?

-- 
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] Titles not centered in Master Document

[Wiebe van der Worp]

On 25-12-16 09:26, David Burleigh wrote:


The page margins are the same for all styles on the page, so I don't
see how those would independently affect the centering of the Title
relative to the other text on the page.


Is it an option to save the proper looking document as a template and 
attach that template to both the master and subdocument?


--
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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Wiebe van der Worp]

On 28-09-16 21:18, Girvin Herr wrote:

I normally use the load styles option, but now and then, when I open a
document, I get a popup saying the template has changed and it allows me
to cancel or update the document template.  If I chose cancel, it sets a
bit in the document to never allow this popup again for this document.
The Template Changer was the only option to restore this popup option.
I made the mistake years ago, thinking "Cancel" was the safe option and
not knowing the consequences, to choose Cancel for some documents.  I no
longer know which ones, since I didn't keep records of what I had opted
for each document.  And so, I could still run into documents that have
no way to restore this update feature or update the template without the
Template Changer.


Insightful! Learning every day.


This is a strange and unintuitive place to find a working extension.
Any plans to put it in the usual place for extensions under the LO home
page to make it easier for users to find?


You're right about this. Yesterday I added this here 
https://bugs.documentfoundation.org/show_bug.cgi?id=60592:



@Patrick, @André

People are still pointed to 
http://extensions.libreoffice.org/extension-center/template-changer and 
that version does not work.


http://bugs.documentfoundation.org/attachment.cgi?id=103039 works fine, 
is it possible to publish it at extension-center?




--
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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Wiebe van der Worp]

On 26-09-16 19:09, Philip Jackson wrote:

On 25/09/16 16:30, Wiebe van der Worp wrote:
 But you may want to use

Template Changer for that, extension:
http://bugs.documentfoundation.org/attachment.cgi?id=103039


Although I have the TemplateChanger extension, it is worth noting that
in LibreOffice Writer 5.1.4.2 (as delivered and updated with
UbuntuStudio 16.04.1) the Help information is not presently correct.

...

In fact in LO 5.1.4.2, what I find is :

...

2. 'All styles ...' do NOT replace current styles of the current
document. It is true that additional styles in the new template which
were not in the original template are now listed in Styles and
Formatting > all styles but not shown under 'applied styles'.

How would Writer know which new style was equivalent to which old style?

3. the info under File > Properties continues to show the original
template name.


Interesting, at my system:

2: All styles are replaced and

3: File > Properties shows the right template.

LO: Version: 5.2.1.2 Build ID: 1:5.2.1~rc2-0ubuntu1~xenial0, but as far 
as I know it worked fine too in LO 5.1.


Philip, are you using the TemplateChanger from the link mentioned at the 
top? The file is template-changer-1.2.7c.oxt, so version 1.2.7c.


--
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: Paragraph Style: Heading. Master Doc Inserting Unwanted Page Break Between Title on Two Lines

[Wiebe van der Worp]

On 25-09-16 15:19, Brooks wrote:

I guess part of the problem is that I do want to have an automatic page
break before each chapter, so yes, page break is on in the text flow tab in
the master document.


Assuming you are working with styles and that you defined your heading 
as starting on a new page, you probably want the same style-sheet for 
the sub-documents and the master.


That is hard to achieve in LO out off the box. But you may want to use 
Template Changer for that, extension: 
http://bugs.documentfoundation.org/attachment.cgi?id=103039


Having exactly the same templates for the master and the sub-documents 
makes life much easier ;-)


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

Re: [libreoffice-users] Page formatting in writer goes nuts

[Wiebe van der Worp]

On 09-09-16 21:40, Bo Siltberg wrote:

May it is time to file a bug report in the hope that this can be corrected.
I hope I am free to attach your example as well?


Feel free to do so. I really hope it helps stressing the subject.

I've added the text below to the bug report of Bruce and reopened it - 
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=79234


=

I really do pity that that this described bug is not solved after so 
many years. By writing this, I hope it helps getting the attention it needs.


This text describes a bug in LibreOffice Writer (and OpenOffice), 
concerning stopping re-paginating before a proper - intended - layout is 
generated.


This bug concerns all users. More specific, it concerns all users that 
write longer documents with objects like images where text flow is not 
set to "no wrap".


As suggested, a general accepted work around is to omit text flowing 
around objects. This can be achieved by anchoring objects "as character" 
while setting wrapping to "no wrap". This way very large documents can 
be generated, such as the official LibreOffice documentation.


This solution has three major drawbacks: First, it is impossible to 
optimize layouts, create richer and more reader friendly layouts. 
Second, because of the introduced white spaces left and or right from 
the object, it costs a lot more paper when printing documents with this 
work around. Third, settings like anchoring as character and no wrapping 
are not default settings, making users run into problems unexpected, 
without them having a clue why their document is screwed up.


When normal documents with objects grow in time, there is a point where 
the background re-paginating process stops unexpected without finishing 
rearranging the layout. At this point, Tools > Update... doesn't work, 
while the menu pull down item remains visible, suggesting an unfinished 
re-paginating process. When the document is saved, closed and opened, 
the layout is properly restored in most cases. However, when the 
document grows further, there is a point in time where the layout of the 
document is permanently broken. Without the knowledge of the workarounds 
- and even with this knowledge - it chases power users away from 
LibreOffice.


Typical symptoms of this bug are initial well re-paginated pages, 
followed by blanc pages and or blanc parts of pages.


This bug is easy to reproduce, simply by adding text and objects in a 
default way to a default document.


There seem to be much noise around this subject. One of them is the use 
of too large bitmap objects. Another one that may be, or not, is this 
one: media.vanderworp.org/.dot/.lo/test_s03e24.odt. This may be related, 
I don't know. Main thing is that the focus should be on re-paginating of 
larger documents. A small twenty page text-document with objects in the 
form of complete empty frames is enough to illustrate the problem. For 
example, if a TOC is added at page 1 and two heading levels are used, 
then editing and updating the TOC, toggling between 1 and 2 levels will 
let re-paginating go south.


In large documents, such as instruction manuals or educational works, 
like the official LibreOffice manuals , it is highly desirable that 
objects, such as pictures and quotes, are an integrated part of the text 
components. This bug makes that integration impossible.


I have some test documents that illustrate the problems. 
media.vanderworp.org/.dot/.lo/test_s02e15.odt is an example for creating 
re-paginating errors. If I can be of further assistance, let me know. On 
the global users mailing list there are multiple threads about the subject.




--
Met vriendelijke groet,

Wiebe van der Worp


--
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] Page formatting in writer goes nuts

[Wiebe van der Worp]

On 07-09-16 20:57, Bo Siltberg wrote:


I was able to delete all other text in this document and still reproduce
the error. That's good. (The screen shots were taken before that.) I have
uploaded this mini version of the LO Users Guide
 where this
error can be reproduced, at least by me. I would appreciate if someone else
could confirm the behaviour that I see. Just place the cursor above the
large picture, hit enter / backspace back and forth, which sometimes will
make the large picture disappear. This is LO 5.1.5.2 but I do see the
problem in 5.2 as well.


I could reproduce the behaviour as you described. It is odd that the big 
frame plus picture cover the margins, but that doesn't seem to be the 
problem.


The picture below is anchored as paragraph and that "explains" the 
behaviour, magical disappearance, after giving an enter.


Anchoring the second picture as character makes it stable again. And 
making a bit more space between the picture by putting an empty 
paragraph before the anchor of the second picture works as well.


It made me a bit curious, maybe the document is a bit contaminated, 
maybe something else. So what I did is saving the bitmaps, saved text as 
ascii, created a brand new document, inserted everything and, surprise, 
exact the same problem. So a one page document with two pictures is 
enough to get into trouble. Even worse, if the pictures are removed from 
the frame, same result.


If you would like to give it a try: 
http://media.vanderworp.org/.dot/.lo/test_s03e24.odt


--
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: Page formatting in writer goes nuts

[Wiebe van der Worp]

On 09-09-16 09:21, Denis Navas Vega wrote:

LibreOffice by
default anchor the images to the paragraph, which is good, but the
figure frames allows text flowing around the image. But if you insert
the image and not instruct LibreOffice to add a frame, will add it
anchored to a character.


Can you clarify how you do "not instruct LO to add a frame" to get it 
anchored as character?


If one adds an image in an out of the box new document (insert > image), 
the frame style is "graphics". Changing this style to "no wrap" is a 
logical step, but that is not what you mean, right?


--
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] Writing large or complex documents

[Wiebe van der Worp]

On 07-09-16 22:16, Tim---Kracked_P_P---webmaster wrote:

I see the postings about the complexity of the documents, but I have not
seen any info about the size of the documents that are part of the
"writing large" statement.

Everyone should agree that the odt version of the "get starting guide"
or "using Writer", etc., would be a large and complex document.  But how
many pages in the document would be considered as the low end for "large
document"?


It is probably a bit of a grey zone. The "get started guide" does not 
use wrapping and apparently wrapping is causing errors during 
repagination. That considered, the guide is large but not that complex 
to recalculate. In "small" documents text wrapping around objects 
doesn't cause problems. But as the document grows "large", the blanc 
(parts of) pages creep in, amongst others depending on the amount of 
included objects.



On 09/06/2016 08:40 AM, wiebe wrote:



  * New document from default template
  * Change default style (a hate double enters)
  * Insert image, png, via menu, style left and right
  * Insert ASCII text, Lorem etc.
  * Make headings 1 and 2
  * Copy everything (dragging+ctrl) untill there are ~60 pages
  * Make page 1 with page break for title
  * Next page TOC



When I change evaluate levels of the TOC to 1, everything repagenates
fine.
Turning it back to a higher level, and everything becomes chaos. See
attached nabble file.


Tools > Update does not work. Work around: Close and open file. But
many of
my .odm files are not sensitive to this solution.


So I found out the hard way what Bruce Byfield wrote two years ago: 
http://www.linux-magazine.com/Online/Blogs/Off-the-Beat-Bruce-Byfield-s-Blog/The-mysteries-of-positioning-pictures-in-LibreOffice-OpenOffice


And I noticed this bug report: 
https://www.libreoffice.org/bugzilla/show_bug.cgi?id=79234


I find it sad that no action is taken because if you want to write a 
"larger" document with proper layout (with text wrapping), then Writer 
is not suitable.


How about filing a bug report again? It is reproducible, affects all 
users, and it is a very old problem in the core of Writer.


As for solutions: today I've converted a sub-document, changing all 
anchors to "as character" and problems were solved, the document is a 
lot more responsive too. Downside: layout is not very nice and due to 
lacking of wrapping text around object, the number of pages becomes 
considerable larger.


In this document most images have blanc spaces on the left and the 
right. The table solution mentioned by Bruce is used, two images on one 
line using left and right aligned tab stops is used and to emulate 
wrapping, an image followed or preceded by a frame is used - and all 
anchored as character. So far it works again.



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

Re: [libreoffice-users] Page formatting in writer goes nuts

[Wiebe van der Worp]

On 04-09-16 20:26, Bo Siltberg wrote:

I have a large document with lots of pictures currently using LO 5.1.5.2.
After doing some editing, the page formatting function kicks in
automatically but does a bad job, inserting page breaks randomly and lots
of empty pages in sequence.


I am not sure it finishes, it looks like the process times out, or 
worse, crashes.


You could try to use a master document (.odm) with smaller 
sub-documents. It does not solve the problem, formatting is still 
stopping, but reformatting every sub-document/satellite can be forced 
after opening the odm, before exporting to pdf and or printing. On the 
other hand, if your document just opens correctly, you are probably 
creating extra work with this procedure.


From http://listarchives.libreoffice.org/global/users/msg46555.html

===
* Open document
* Update index
* Update selection for every satellite (using navigator)
* Update index again
* Export to PDF for printing and distribution
===


I have got the impression that it is the pictures LO has
problem with since most of these extra page breaks are made where there are
pictures nearby.


I agree. And calculating columns goes wrong too in certain large documents.


I have tried anchored them to the paragraph or as a
character without any effect that I can see. Closing and reopen the
document clears the problem as the initial page formatting works fine.


I did some testing with the large LO-manuals from 
https://www.libreoffice.org/get-help/documentation/. They don't suffer 
from this problem, despite the large amount of pictures. This is 
described further in the link to the thread above. These pictures are in 
a frame, with the frame anchored as (not to) character, always followed 
by an enter.


Unfortunately this causes a lot of white space left and or right from 
the frame when small pictures or listings are involved.



--
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] challenge...

[Wiebe van der Worp]

On 22-08-16 20:16, Brian Barker wrote:


At 16:37 22/08/2016 +0200, Wiebe van der Worp wrote:

There is a group of ~100 people (n). In 5 time slots they visit 5
rooms in groups of ~20 people (n/5). The composition of the groups
should be as different as possible for each time slot. One person may
not visit a room more than once.



Here's an idea:


...


This will ensure that each person visits each room exactly once, but the
groups sizes will vary from exactly n/5. You could use COUNTIF() to list
the sizes of the twenty-five groups and determine the range of sizes
using MIN() and MAX(). Then you could use Recalculate Hard
(Ctrl+Shift+F9) repeatedly to regenerate the random numbers until you
were happy with the group sizes.


Your solution is way more elegant than mine and I will put these control 
measures at work, thanks. On the other hand, the deviation of number of 
people per room is quite unexpected, forcing a lot of Ctrl-Shift-F9 strokes.



This problem may be of the sort that would be much easier to solve
through programming that via a spreadsheet.


As Dave Liesse confirmed, driving in nails with the flat side of an axe. 
But it works for one time usage ;-)


Thanks to everyone for helping.


--
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] challenge...

[Wiebe van der Worp]

> On 22 August 2016 at 16:37, Wiebe van der Worp  wrote:
>> There is a group of ~100 people (n). In 5 time slots they visit 5 
rooms in

>> groups of ~20 people (n/5). The composition of the groups should be as
>> different as possible for each time slot. One person may not visit a 
room

>> more than once.

On 22-08-16 17:17, Dries Feys wrote:
> I wouldn't use random numbers, but work with primes below 20. So,
> always starting with 1, and then increasing with the prime number
> until you reach 100.

> It might be even more unique when you use even higher primes, but I
> guess this methodogy will be fair enough.

Dries, thank you very much. Unfortunately I don't understand your 
intentions, other than that you created a list of unique numbers, right?


I am still curious if there is a smart approach. The question looks like 
what is described here: 
https://productforums.google.com/forum/#!topic/docs/EMlF95NfI5o


For now I did some copy paste work with calculation of last values in 
order to get 120 unique combinations, should work.



1   2   3   4   5
1   2   3   5   4
1   2   4   3   5
1   2   4   5   3

...

5   4   2   1   3
5   4   2   3   1
5   4   3   1   2
5   4   3   2   1



--
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] challenge...

[Wiebe van der Worp]

Hi, I've got a challenge where I want Calc to do something for me. Here 
I go:


There is a group of ~100 people (n). In 5 time slots they visit 5 rooms 
in groups of ~20 people (n/5). The composition of the groups should be 
as different as possible for each time slot. One person may not visit a 
room more than once.


Suppose Column A contains id's, say 1..100

Col. B contains first time slot room numbers: =INT(RAND()*5+1)

C, D and E contain room numbers for time slot 2, 3 and 4

F contains time slot 5, for row 1: =15-SUM(B1:E1)

Does anyone have a suggestion for C1, D1 and E1?

--
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] Assigning templates to files

[Wiebe van der Worp]

On 07-06-16 22:21, Adam Tauno Williams wrote:


The **wonderful**, nor broken,
extension was to ASSIGN a template to AN EXISTING DOCUMENT.  This is a
method for normalizing styles and formatting.

It is really painful that this functionality is gone.



I hate to react in a "me too" form, but yes, not having this extension 
working would be a show stopper for me. So 
https://bugs.documentfoundation.org/attachment.cgi?id=103039 solves 
it For now.


This extension has to do something with both intuitive work flow and 
efficient work flow: You start writing in an empty document while using 
styles consequently. As your document gets bigger and more mature you 
want to assign an existing and proven template that fits fine.


I am a little surprised that this is not standard functionality in 
LibreOffice (why?) and I am even more surprised that so little people 
complain about the missing functionality in an environment where it is 
to be expected that people rely more on styles than direct formatting.


Having said this, I am very grateful to be able to use "Template 
Changer" by André Schnabel (cc). I wonder what long term plans there are 
concerning 
https://bugs.documentfoundation.org/attachment.cgi?id=103039&action=edit 
and the working link (to this more than highly appreciated extension).


B.t.w., the grass on the other side of the border is not greener per 
definition: 
http://answers.microsoft.com/en-us/office/forum/office_2010-word/word-2010-apply-template-to-a-current-document/96ba15e8-90d1-40ed-b672-585bff717168


Best regards, Wiebe van der Worp

--
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] HP Officejet Pro 8630 overprinting lines in LO on Win 10

[Wiebe van der Worp]

On 18-05-16 02:09, "Luca Daghino"@Libero wrote:

Il 18/05/2016 01:45, anne-ology ha scritto:

If you can switch back to WIN7, my suggestion would be to do so.



From: Rogier F. van Vlissingen 
Since switching to Windows 10, I've had to abandon LibreOffice, since my
printer inexplicably overprints lines in LO. This never happened in Win7.

Anybody have any suggestions?

At some point I am going to Linux Mint 17.3, but I will need to keep at
least one machine running Win10...


Go mint and virtualize win10 :)
Namasté _/\_


Agreed on virtualization, you may want to run Win 7 inside Linux to 
avoid your problems.


If you don't want Win 10, use the tricks documented on the net to keep 
win 10 outside.


VirtualBox is a good start for example but you need some extra RAM for 
Windows if you don't have it.



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

Re: [libreoffice-users] Cannot assign template to existing writer odt file

[Wiebe van der Worp]

On 03-04-16 18:13, Adam Tauno Williams wrote:

On Fri, 2016-03-25 at 08:09 -0400, Eric Beversluis wrote:

found: Document Info".  The document in question does have a
Properties window but it does not name the template selected, nor
is the selected template installed.

Same issue here - I can no longer assign a template to an existing
document.  This very much impinges on the functionality of Master
Documents when working with very large [book like] documents.
Version: 5.0.4.2
Has anyone figured anything else?  Is the support for features like
masters documents fading out of LibreOffice?

In my Fedora 22 Version 4, there is no "File->Templates->Assign
template (current document)" option.
What seems to work for me is to go to Styles and Formatting -> New
Style from Selection -> Load Styles. The "From File" option at "Load
Styles" works nicely if the style isn't a template.
Does this still work in LO Writer 5?


Yes, just tried it - Load Styles still works.  So at least I get styles
of the same name - so if the file is included in a master document I
should get consistency.


According to this:
https://bugs.documentfoundation.org/show_bug.cgi?id=60592&redirected_from=fdo#c11

... you need to use this link for a working Template Changer:
http://bugs.documentfoundation.org/attachment.cgi?id=103039

It creates the missing, not working, menu entries.

Works on 5.0.5.2 (Xubuntu 15.10), indeed a valuable tool when editing 
master and slave documents, but also for applying multiple corporate 
templates.


--
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] LO5.1 on Linux - Opening Writer document takes >1hr

[Wiebe van der Worp]

On 14-02-16 10:33, Patrick Dijkgraaf wrote:

While it is not a real solution to my problem, this might be something
for me to look into! I didn't know about this feature and it sounds
great!
I do have some concers about cross-references between subdocuments and
table calculations with values from tables in a different subdocument.


Really like to hear your feed back on this.

I am having trouble with master document constructions and no one on 
this list could help. An assumption: Not many on this list work with 
large and complex documents and experiences are probably appreciated.


http://listarchives.libreoffice.org/global/users/msg46555.html describes 
my problem.


Follow ups:
http://listarchives.libreoffice.org/global/users/msg46652.html
http://listarchives.libreoffice.org/global/users/msg46659.html
http://listarchives.libreoffice.org/global/users/msg4.html
http://listarchives.libreoffice.org/global/users/msg46671.html

Long story short: If you run into trouble, the first follow up contains 
a procedure to solve re-paginating:


* Open document
* Update index
* Update selection for every satellite/sub document (using navigator)
* Update index again

The last follow up is a suggestion not to wrap, i.e. select 
picture/object > RMB >  Wrap > No Wrap.


Hoping memory is serving well, I tested a 500 page document without any 
errors and came to the conclusion that if you insert pictures/objects as 
character, LO renders it straight away.


But... If you don't like to spoil empty paper then RMB wrapping objects 
is a must, leaving one with the need to update selections manually as 
described above.


Why this long text? It sounds familiar (900+ pages boiling down to 400+ 
pages), so it might be a related problem and that makes curious.


If you search the net you will find a few more unsolved cases where 
large documents contain empty parts (like 900+ minus 400+ pages = ~500 
initial white space).


One last thing, you probably want to share one template for both the 
master and all satellite documents. You may like "Template Changer 
1.2.7" by André Schnabel, works fine on 5.0.2.2. See 
http://bugs.documentfoundation.org/attachment.cgi?id=103039, a pity it 
is not a standard functionality in LO.



--
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] Empty spaces in master documents...

[Wiebe van der Worp]

On 29-10-15 18:18, anne-ology wrote:

So sorry no one responded;
   but maybe no one knew what you were asking -
  I for one am not sure what you're asking, but will make an attempt
to answer,
what are these blanks you're seeing? - could these have been placed
there by the author for a set purpose?,


Nope, no page breaks and empty paragraphs, the blanks are inserted by LO 
and disappear after the master document is forced to recalculate the 
layout of the pages. On 
http://media.vanderworp.org/.dot/.lo/1_lo_after_open.png: r2c2, r4c4 
show these white spaces for example.



On 19-10-15 15:11, Wiebe van der Worp wrote:

For some manuals I use master documents with satellites in Writer.



[to what are you referring?]


One .odm master document containing several .odt satellite, linked 
documents.



What I do:
   * Open document
   * Update index
   * Update selection for every satellite (using navigator)
   * Update index again
   * Export to PDF for printing and distribution



is the index the document?


Indexes and tables, the table of contents, r1c2, the grey part. RMB > 
Update.



how many of these satellites are you using? -
   are you possibly referring to those in space which allow for
messages to be sent-received?


Hehe! No, just keeping feet on the ground, I'm referring to a .odm 
master with linked .odt files (as satellites). You can see them in the 
navigator part on the left side of the screen dump.



what is the reason for using PDFs?


Printer doesn't like filesize, some raster images are simply too big, 
not LO to blame, I sample images back to normal values during pdf export.



To get an idea I've temporary placed the following screen dumps on
http://media.vanderworp.org/.dot/.lo/ :

1_lo_after_open.png
2_lo_after_update_index.png
3_lo_after_update_selection.png

This solution is highly complex and unfriendly (some of these masters
contain a lot satellites), I consider not properly calculating the
layout a bug.



huh?


In the above example it means updating the TOC, RMB every attached .odt 
in navigator en choose update selection, then update the TOC again. 
These steps should not be needed imo.



The documents themselves have strict style rules and only contain
bitmaps and svg's.



huh?


I mean, there is nothing fancy that could be blamed for not calculating 
the lay out properly.


After opening it starts organizing the flow of content and at a certain 
point it simply stops. No idea if it is a time out, a crashing 
subprocess. The reason to think in that direction is because every time 
I open the same master document, the layout, the places where blanks 
occur, is different. It also looks like what is described at 
http://en.libreofficeforum.org/node/6144 .


I just made a master document and, as a test, inserted the Writer 4.2 
manual (https://www.libreoffice.org/get-help/documentation/) in it. 
Almost 500 pages, no problem.


However I noticed that pictures in this manual are set to no wrap. Maybe 
that makes things too complex for LO in my document.


Thanks for your time.



--
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] Empty spaces in master documents...

[Wiebe van der Worp]

A while ago I posted what is below and didn't see any replies. No 
problem because there is no real problem, with an ugly workaround. 
However, I am wondering if I am the only person struggling with master 
documents.


On 19-10-15 15:11, Wiebe van der Worp wrote:

Hi everyone

For some manuals I use master documents with satellites in Writer.

After opening such a file it always contains empty spaces and even empty
pages. It took a while to figure out how to get rid of these layout errors.

What I do:
  * Open document
  * Update index
  * Update selection for every satellite (using navigator)
  * Update index again
  * Export to PDF for printing and distribution

To get an idea I've temporary placed the following screen dumps on
http://media.vanderworp.org/.dot/.lo/ :

1_lo_after_open.png
2_lo_after_update_index.png
3_lo_after_update_selection.png

This solution is highly complex and unfriendly (some of these masters
contain a lot satellites), I consider not properly calculating the
layout a bug.

The documents themselves have strict style rules and only contain
bitmaps and svg's.

I can live with this solution but... Are there better solutions?




--
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] Empty spaces in master documents...

[Wiebe van der Worp]

Hi everyone

For some manuals I use master documents with satellites in Writer.

After opening such a file it always contains empty spaces and even empty 
pages. It took a while to figure out how to get rid of these layout errors.


What I do:
 * Open document
 * Update index
 * Update selection for every satellite (using navigator)
 * Update index again
 * Export to PDF for printing and distribution

To get an idea I've temporary placed the following screen dumps on 
http://media.vanderworp.org/.dot/.lo/:


1_lo_after_open.png
2_lo_after_update_index.png
3_lo_after_update_selection.png

This solution is highly complex and unfriendly (some of these masters 
contain a lot satellites), I consider not properly calculating the 
layout a bug.


The documents themselves have strict style rules and only contain 
bitmaps and svg's.


I can live with this solution but... Are there better solutions?

--
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] Incorrect PDF export of SVG in Calc headers

[Wiebe van der Worp]

On 04-10-15 08:43, Jean-Baptiste Faure wrote:

Le 02/10/2015 12:22, Laurent Larsonneur a écrit :



Anyone knowing the appropriate way to pass the information of this bug
to the developers?


It is a known problem, PDF export exports vector graphics (eps, svg) as
bitmap.
For example: https://bugs.freedesktop.org/show_bug.cgi?id=81497


You probably mean 
https://bugs.documentfoundation.org/show_bug.cgi?id=89623 , not 
involving eps but svg in particular.



--
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] Incorrect PDF export of SVG in Calc headers

[Wiebe van der Worp]

On 02-10-15 10:48, Laurent Larsonneur wrote:

I need to export invoices and quotations in PDF, including vector logos
in the headers.
However, when I try to export a PDF of a Calc file including an SVG
import as header background, it becomes pixels.


To my surprise I have been able to reproduce it and confirm it is a 
problem in version 4.4.2.2 too. There was a bug a while ago that 
rasterized every svg when exporting to pdf. That one was solved except 
for headers it turns out.



So it is rasterized and does not preserve the vector format of the logos.
Am I doing something wrong ?
Do I miss an option in the PDF export ?


Not aware of it. In your case I would anchor to cells which exports 
nicely to vector images.



--
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] PDF Export

[Wiebe van der Worp]

On 10-06-15 11:28, Daniel.Bauer wrote:

we are trying to generate a Pdf in Version 1.3 for business cards using the 
Libre Office Writer.
Is there an option or the posibillity to generate such an Pdf with the Writer?
Thanks for any Hint.


The current version exports version 1.4. Not an answer but an additional 
question: Why does it have to be 1.3? If you open the pdf in Inkscape 
you can save it again as 1.4 or 1.5 and not 1.3 unfortunately. 
Ghostscript should be able to convert it to your required version. If 
you search the net there are multiple examples of conversions.



--
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] invoicing systems using Calc (or something else)

[Wiebe van der Worp]

On 30-03-15 23:27, Eric wrote:

I'm looking for really simple invoicing system. I've seen a few out
there that work on top of Calc but they are typically oriented towards
product based invoices versus service invoices (what I need).


A while ago I came up with a similar question here. Not happy with my 
software I've tried several options and finally decided to be stubborn. 
So I made a construction in Calc and after three months working with it 
I can say that is was worth the effort and I am very happy with it. I am 
in full control now, instead of pushing buttons on a black box, I can 
import raw csv files from the bank and after a good talk with and help 
from my accountant the output is very compatible with his demands. For 
people not very familiar with Calc I would strongly advice not to do it 
this way.


One of the reasons to do this is that my invoice system is based on 
tables in Calc. In fact it started with Star Office and is now over 13 
years old. It is not a nice polished system, back then I had a database 
in mind so it contains a lot of sheets for relations, a sheet for 
customers, customer - project, project - invoice, invoice - sold items, ...


Flexibility is a main argument. For example, over the years I began 
exporting, inside and outside EU, to private persons and companies, all 
having different VAT laws. It is extended to serve well and I am even 
not aware of a system that is able to do this task better and is Freedom 
software.


Concluding, I am in full control, it took a lot of work but that is 
paying back, it is not polished, using it is hard to explain to 
colleagues, you always have to be careful not to mess things up, it is 
very easy to export data, search data and sort data. It takes discipline 
to work with it.


Perhaps most important... Over the years I've learned one thing, smart 
entrepreneurs are experts in bookkeeping. If not, work on it. Last 
resort: find a bookkeeper for a long term relation.



I'm not interested in a
full-fledged bookkeeping system. I've been through three in the past two
years and finally my accountant told me I was never to touch a
bookkeeping system or even do my own bookkeeping because it's gonna cost
me more for him to untangle my mistakes that it will be for him to do it
for me (yes, I'm that bad at it).


There is so much on the net, everybody can learn bookkeeping and working 
with your own data gives you the best impression of how your 
organization is doing.


--
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] Writer and EPS images.

[Wiebe van der Worp]

You mean 
http://wiki.inkscape.org/wiki/index.php/Inkscape_SVG_vs._plain_SVG ? And 
Adobe software also puts a lot of binary code in SVG, I've noticed that 
exploring SVG's from WikiPedia - perhaps bitmap previews. In Inkscape, 
the XML editor (Edit > XML Editor of Shift+Ctrl+x) shows all the extra 
entries.


But I assume LO simply ignores these namespaces and parses only true SVG 
code. No problems so far except for funny positioning in LO, caused by 
bad sized pages in SVG, Inkscape, File > Document Properties > Resize 
page... > Resize page to drawing. May it be that that causes problems in LO?


On 11-03-15 12:14, Tom Davies wrote:

Hi :)
Ahh, i have trouble with the Svg output from Inkscape sometimes.  I suspect
it is a user-error (a classic pebkac probably).  There are 2 versions of
Svg output, one more standard and the other easier to pull back in and
re-edit, and i think one of them goes a bit funny with any lettering.

I haven't explored this enough to really figure out what is going on yet
but i'm a total noob to Inkscape anyway.
Regards from
Tom :)





On 11 March 2015 at 11:02, Wiebe van der Worp  wrote:


On 11-03-15 01:36, Steve Edmonds wrote:


Most of my data sheets have EPS images (for the vector graphics) output
from our cad system. Up until LO4.1 went to 4.2.. these were printed
correctly.



Not sure what CAD software is used, if it is ACAD and the work flow is
PSOUT in ACAD and then import in LO, you may want to consider changing your
flow: Acad PSOUT > Inkscape save (SVG) > LO.

I understand it is an extra step but it will give you great post edit
possibilities in Inkscape if needed, SVG is a clean format and LO supports
it pretty good (except for fancy fonts and effects like drop shadows). Best
of all: Geometry is pretty well preserved.

Two examples from CAD:
http://media.vanderworp.org/metafiles/etc/cable_hook_equal.svg: Seamless
into LO.
http://media.vanderworp.org/metafiles/diagrams/banker1.svg: Shadow
becomes solid in LO, so be it.



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






--
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] Writer and EPS images.

[Wiebe van der Worp]

On 11-03-15 01:36, Steve Edmonds wrote:

Most of my data sheets have EPS images (for the vector graphics) output
from our cad system. Up until LO4.1 went to 4.2.. these were printed
correctly.


Not sure what CAD software is used, if it is ACAD and the work flow is 
PSOUT in ACAD and then import in LO, you may want to consider changing 
your flow: Acad PSOUT > Inkscape save (SVG) > LO.


I understand it is an extra step but it will give you great post edit 
possibilities in Inkscape if needed, SVG is a clean format and LO 
supports it pretty good (except for fancy fonts and effects like drop 
shadows). Best of all: Geometry is pretty well preserved.


Two examples from CAD:
http://media.vanderworp.org/metafiles/etc/cable_hook_equal.svg: Seamless 
into LO.
http://media.vanderworp.org/metafiles/diagrams/banker1.svg: Shadow 
becomes solid in LO, so be it.



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

Re: [libreoffice-users] compatibility with Microsoft Access

[Wiebe van der Worp]

On 01-02-15 18:33, Brian Barker wrote:


As you say, 64 gigabytes is a lot of memory - but it's quite small for a
disk drive. Limited memory will restrict the system's performance, but
stored files take up disk space, not memory. Moving saved files to
external devices can free up disk space but this doesn't affect
performance - unless the disk is almost full, that is. Even a larger
video file makes no demands on memory unless it is actually in use. The
only sense in which unneeded software can affect performance is if it is
secretly loaded at start-up or log-in. Disabling such default behaviour
can be wise - but there is no additional advantage in removing the
products.


You're right, and it is hard to pick the right words these days. I tried 
to keep it simple and avoid disks space but I meant to say the same. 
Model T100 is having 2 GB RAM and 32GB data storage (soldered on the 
board!). That, plus knowing Asus (et al) is putting a lot of crapware on 
board was the reason to give the advice to get rid of it. Running 
msconfig is always a nightmare with brands like Asus, Acer,...



--
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] compatibility with Microsoft Access

[Wiebe van der Worp]

Hi lalitadatta

What Tom writes below are very good points. I can understand that it may 
be a bit too much detail but it is valuable information for the school 
involved. It really puzzles me why schools teach concepts based on MS 
with a lock in policy while there is so much better software available 
for free as in freedom and price, running on almost every operating 
system and being implemented on large scale in a professional 
environment. In short: Software you want students to work with.


In my opinion you would do the school, the parents and not at least the 
students a favour by handing over this mail to the school/teacher involved.


Having said that, my daughter is using OpenOffice and LibreOffice for 9 
years now. She is starting with her master and never used MS Office - 
despite all efforts of the schools and universities to force her into MS 
Office - for example by mandating MS Word style sheets for a thesis.


The school/teacher is welcome on this list or personal if questions 
arise and I really hope you hand this over though it does not answer 
your question directly.


Concerning hardware in addition to what is said by others: Don't expect 
miracles from the T100 but it should be able to do the job. Lack of 
internal memory will force your daughter in time to move larger files to 
a usb-disk or stick - i.e. movies in paticular. There are also models 
with more memory, 64GB. You may want to (let someone) remove all 
unneeded pre-installed software you get for "free" since this will free 
memory and increases performance.


Best regards, Wiebe

On 29-01-15 16:18, Tom Davies wrote:

Hi :)
Sorry to say that Access is not compatible with almost any other
database program.  Even down to the sql language under the surface of
the Queries it is different from all the rest.

Access is also very restricted in what it can do and how it can be
used - for example it only supports single user input at a time rather
than being able to handle multiple users.  Some of it's restrictions
can be by-passed if you dig deep enough but it's probably better to
use something that is designed to be "the right tool for the job"
rather than to twist Access outside of it's comfort-zone.  If she
learns how to use Access that way then she will be amazed how easy it
is to use any of the others later in life.

However it is still good to learn.  There are key concepts and
generalities that are the same or very similar.  Those concepts are
often difficult for people to grasp.  It's possibly easier to
understand some of it if you have watched "The Matrix".


The main problem would be with trying to use any example files she is
given or that she builds on Access.

It might be possible for her to use Base to do some of her exercises
but most of it will take some initiative to adapt what they ask for in
order to fit.

For example Base is best when used with an external back-end but for
the exercises she will probably be better off using the internal
back-end.  Anything teaching about Access probably wont mention
back-end vs front-end at all - which is one reason why it might be
handy to have watched "The Matrix" (but only to get the rough idea of
what it's about rather than needing to watch t closely - mostly
the bit about the cat and the spoon).

Regards from
Tom :)


On 29 January 2015 at 13:45, lalitadatta  wrote:

Hi,
My daughter's in need of Microsoft access for her homework - she's studying
computer
technology at high school, and she needs Access for coding.  Anyone knows if
liber office should do the job?
Thanks in advance.



--
View this message in context: 
http://nabble.documentfoundation.org/compatibility-with-Microsoft-Access-tp4138053.html
Sent from the Users mailing list archive at Nabble.com.

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






--
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] styles in text boxes

[Wiebe van der Worp]

On 13-01-15 11:54, Mike Scott wrote:

Why are text styles not available to use within text boxes?

...

However, I'd like to use styles to ensure consistency, and this appears
simply impossible - only one style, the box style, is available (in
Draw, but not Writer!) and that affects all text(*) within the given
box.


You are right and it is a bit surprising. Talking about Writer, Insert > 
Frame does support styles properly, i.e. both paragraph and frame 
styles. That seems to me a great alternative for Writer.


About text boxes: it looks a bit Q&D, clearing formatting leaves text as 
Times New Roman - a font I banned many years ago and isn't even on my 
system.



--
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] Disappearing Page Reference

[Wiebe van der Worp]

On 06-01-15 18:51, Brian Barker wrote:

At 11:22 06/01/2015 -0600, Jay Ridgley wrote:

Original definition: =Summary.E28
Resulting entry: =E28

I am using Ubuntu 14.04.1 LTS with a Cinnamon desktop and LibreOffice
4.2.72 Build ID: 420m0(Build: 2)


See https://www.libreoffice.org/bugzilla/show_bug.cgi?id=86125 . Update
to 4.2.8 or 4.3?


The link says: "2014-12-01 14:20:51 UTC Adjusted in 4.3, 4.4 4.5 master, 
and now a final 4.2.8 releases."


I can confirm this bug is still in version 4.3.3.2 - the up to date 
version for Ubuntu 14.10. Dragging cells to another sheet tab gives 
strange errors and results. I'll wait for an update but if it is a 
showstopper for Jay he may want to use backports.



--
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] function key behavior

[Wiebe van der Worp]

Hi Thomas

On 05-01-15 10:37, Thomas Blasejewicz wrote:
> LibreOffice installed on linux machine (right now the particular
> distribution is xubuntu 14.04, rather high-spec machine).
> On my Windows computers F11 calls up the "style menu".
> Now, on this linux installation it HAS to be Shift+F11 (some other
> function keys act similar)

On Xubuntu 14.10 key F11 works just fine for "Styles and Formatting".
Just out of the box. LibreOffice Version: 4.3.3.2. So I guess an update
is an option.




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

Re: [libreoffice-users] calc and bookkeeping

[Wiebe van der Worp]

On 08-12-14 10:16, Wiebe van der Worp wrote:

Found it, Cell A3 contains:

=DSUM($B5:$C12;"Amount";A1:A2)


Apparently my screen dump vaporized, the data:

   A  B   C
1  Code   CodeCode
2  1  2   3
3  10165  22
4
5  Descr  Amount  Code
6  booking 1  EUR 100,00  1
7  booking 2  EUR 50,00   2
8  booking 3  EUR 20,00   3
9  booking 4  EUR 10,00   2
10 booking 5  EUR 5,002
11 booking 6  EUR 2,003
12 booking 7  EUR 1,001


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

[Wiebe van der Worp]

On 07-12-14 17:20, Wiebe van der Worp wrote:

Still missing an answer in a sense
of straight formulas in Calc for a relative simple problem if we skip
the amount of lines that could make it complex.


Found it, Cell A3 contains:

=DSUM($B5:$C12;"Amount";A1:A2)

Sleeping better now, itch is gone, hope screen dump arrives too. And 
again, thanks for all suggestions and great alternatives.



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

[Wiebe van der Worp]

On 07-12-14 15:03, Dan Lewis wrote:

On 12/07/2014 08:12 AM, Wiebe van der Worp wrote:



Input: In order to keep things simple: three columns with Description,
Amount and a LedgerCode.

Output: Sums per LedgerCode

The question: What is the most efficient approach in order to keep the
sheet alive after adding record 2384?

Example:
LedgerCode: 1, 2, 3
---
1€ 100,00
2€ 65,00
3€ 22,00
---
DescriptionAmountLedgerCode
booking 1€ 100,001
booking 2€ 50,002
booking 3€ 20,003
booking 4€ 10,002
booking 5€ 5,002
booking 6€ 2,003



  Rather than use Calc, I recommend using Base with a simple database.
You will need one table (table1) containing four fields: Description,
Amount, LedgerCode, and PK (primary key)
  Then you will need a query to obtain your results. the SQL for the
query is

Select SUM("Amount"), "LedgerCode" FROM table1 GROUP BY "LedgerCode"
ORDER BY "LedgerCode"


Together with Stefan's solution - could even be combined - I am 
grateful. So for now GnuCash. Thanks, I am going to experiment with both 
suggestions for educational purposes. Still missing an answer in a sense 
of straight formulas in Calc for a relative simple problem if we skip 
the amount of lines that could make it complex.



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

[Wiebe van der Worp]

On 07-12-14 14:36, Tom Davies wrote:

Spreadsheets are not really made to be good at accounting and
bookkeeping.  GnuCash or other dedicated programs might be better.
Spreadsheets are designed to do a lot of calculations.


GnuCash... haven't used it for so long that I forgot it did exist. Nice 
suggestion, already installed it for experimenting.


I am a Calc abuser. For example, I made a tailored invoice system 
because there was nothing on the market for my specific needs. It runs 
for 10 years now, contains many thousands of records in text tables and 
never disappointed me. I know it shouldn't be done in Calc, it is grown 
over the years with the intention to make it a database after testing - 
it never happened.



It sounds like you are trying to set-up 2 new systems to cross-check
against each other.  This sounds like a complete nightmare and likely to
create tons of trouble.


You're probably right. The current solution offers me in time or cloud 
accounting or getting a SQL server. None is an option. So GnuCash for 
2015 or a year later.


Thanks for your comprehensive answer.

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

[Wiebe van der Worp]

First post, not sure it is the right place, hi there!

For 2015 I would like to keep a shadow bookkeeping in Calc in order to 
check our bookkeeping program for a while.


Input: In order to keep things simple: three columns with Description, 
Amount and a LedgerCode.


Output: Sums per LedgerCode

Several solutions are thinkable of, such as conditional testing and 
lookups. However, if the list grows and contains thousands of lines it 
will influence performance.


The question: What is the most efficient approach in order to keep the 
sheet alive after adding record 2384?


Example:
LedgerCode: 1, 2, 3
---
1   € 100,00
2   € 65,00
3   € 22,00
---
Description Amount  LedgerCode
booking 1   € 100,001
booking 2   € 50,00 2
booking 3   € 20,00 3
booking 4   € 10,00 2
booking 5   € 5,00  2
booking 6   € 2,00  3



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