Re: [libreoffice-users] Wrongly placed caption
On 4/25/19 11:20 AM, Stephen Harding wrote: > Has anyone else come across this? Is it a bug or am I doing something > wrong? (Note: I've been using LO for many years without any problems. The default was changed from below the image, to above the image. When you write the caption, go to the bottom of the box, and change "above" to "below". If you're feeling very brave, and don't mind destroying your LibO configuration files, you can go into the expert menu, and configure "below" to be the default. (I don't recommend exploring the exert menu, unless you are willing to destroy your entire LibO configuration setup.) jonathon -- 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] percent to whole fraction
YES, LCM() that's the function i was looking for...
I did not know it that function exists, probably because it's name in my
Dutch version of EXCEL is KGV(). :-[
(see:
https://www.excel-function-translation.com/index.php?page=english-dutch.html
)
On 26-4-2019 22:54, Johnny Rosenberg wrote:
Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg
:
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
Let me rephrase the question ;)
In the 'example' line we see:
56 30228/151
The actual cell contents are:
56 302 0,18543046357615894039735099337748
Is it possible to get the values '28' and '151' as show by the
fraction-formatter?
Are we allowed to use the first two numbers (56 and 302 in this case) or
only the fraction (0,185…)?
Are we allowed to create our own cell functions?
Is the maximum values 999/999 or are higher numbers allowed?
Do you want one number (28) in one cell and the other number (151) in
another cell or what?
If you can use the original numbers (56 and 302 in the example above),
here's a short example:
A1=56
B1=302
C1=LCM(A1;B1)/B1 ⇨ 28
D1=LCM(A1;B1)/A1 ⇨ 151
Kind regards
Johnny Rosenberg
Kind regards
Johnny Rosenberg
On 26-4-2019 19:01, Luuk wrote:
Is there an option to convert a cell with format 'Fraction' to text?
example:
a b 'a/b
52297 52/297
56302 28/151
66311 66/311
in this third line, i want to get '28' and '151'
i tried TEXT(C2;""), and FIND("/";C2;1),
On 26-4-2019 00:45, Remy Gauthier wrote:
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"
--
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: [libreoffice-users] percent to whole fraction
reply inserted in your post.
On 26-4-2019 22:42, Johnny Rosenberg wrote:
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
Let me rephrase the question ;)
In the 'example' line we see:
56 30228/151
The actual cell contents are:
56 302 0,18543046357615894039735099337748
Is it possible to get the values '28' and '151' as show by the
fraction-formatter?
Are we allowed to use the first two numbers (56 and 302 in this case) or
only the fraction (0,185…)?
As long as the result is 28 and 151 (the numbers shown in the fraction),
of course you can use 56 and 302, because the vale 0.185 is the same as
56/302
Are we allowed to create our own cell functions?
I hope they are not needed, but if they are
Is the maximum values 999/999 or are higher numbers allowed?
I do not see a need to specify a maximum value right now...
Do you want one number (28) in one cell and the other number (151) in
another cell or what?
Yes, as said, i want two numbers
Kind regards
Johnny Rosenberg
On 26-4-2019 19:01, Luuk wrote:
Is there an option to convert a cell with format 'Fraction' to text?
example:
a b 'a/b
52297 52/297
56302 28/151
66311 66/311
in this third line, i want to get '28' and '151'
i tried TEXT(C2;""), and FIND("/";C2;1),
On 26-4-2019 00:45, Remy Gauthier wrote:
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"
--
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: [libreoffice-users] percent to whole fraction
Den fre 26 apr. 2019 kl 22:42 skrev Johnny Rosenberg :
> Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
>
>> Let me rephrase the question ;)
>>
>> In the 'example' line we see:
>>
>> 56 30228/151
>>
>> The actual cell contents are:
>>
>> 56 302 0,18543046357615894039735099337748
>>
>> Is it possible to get the values '28' and '151' as show by the
>> fraction-formatter?
>>
>
> Are we allowed to use the first two numbers (56 and 302 in this case) or
> only the fraction (0,185…)?
> Are we allowed to create our own cell functions?
> Is the maximum values 999/999 or are higher numbers allowed?
> Do you want one number (28) in one cell and the other number (151) in
> another cell or what?
>
If you can use the original numbers (56 and 302 in the example above),
here's a short example:
A1=56
B1=302
C1=LCM(A1;B1)/B1 ⇨ 28
D1=LCM(A1;B1)/A1 ⇨ 151
Kind regards
Johnny Rosenberg
>
> Kind regards
>
> Johnny Rosenberg
>
>
>
>>
>>
>>
>> On 26-4-2019 19:01, Luuk wrote:
>> >
>> > Is there an option to convert a cell with format 'Fraction' to text?
>> >
>> > example:
>> >
>> > a b 'a/b
>> >
>> > 52297 52/297
>> > 56302 28/151
>> > 66311 66/311
>> >
>> > in this third line, i want to get '28' and '151'
>> >
>> > i tried TEXT(C2;""), and FIND("/";C2;1),
>> >
>> >
>> > On 26-4-2019 00:45, Remy Gauthier wrote:
>> >> Hi,
>> >>
>> >> I am assuming you are using Calc. There is no formula to do this: it is
>> >> a cell formatting accessible via Format -> Cells... -> Numbers Tab,
>> >> then go to the "Fraction" category. There you can select the # ???/???
>> >> format which will do what you are looking for.
>> >>
>> >> I hope this helps.
>> >>
>> >> R??my.
>> >> Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
>> >>> I need a formula that takes as input a percent and outputs a fraction
>> >>> that only has whole numbers.
>> >>> Eg.
>> >>> 1% -> "1/100"
>> >>> 0.5% -> "1/200"
>> >>> 1.5% -> "3/200"
>> >>>
>> >>>
>>
>> --
>> 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: [libreoffice-users] percent to whole fraction
Den fre 26 apr. 2019 kl 20:37 skrev Luuk :
> Let me rephrase the question ;)
>
> In the 'example' line we see:
>
> 56 30228/151
>
> The actual cell contents are:
>
> 56 302 0,18543046357615894039735099337748
>
> Is it possible to get the values '28' and '151' as show by the
> fraction-formatter?
>
Are we allowed to use the first two numbers (56 and 302 in this case) or
only the fraction (0,185…)?
Are we allowed to create our own cell functions?
Is the maximum values 999/999 or are higher numbers allowed?
Do you want one number (28) in one cell and the other number (151) in
another cell or what?
Kind regards
Johnny Rosenberg
>
>
>
> On 26-4-2019 19:01, Luuk wrote:
> >
> > Is there an option to convert a cell with format 'Fraction' to text?
> >
> > example:
> >
> > a b 'a/b
> >
> > 52297 52/297
> > 56302 28/151
> > 66311 66/311
> >
> > in this third line, i want to get '28' and '151'
> >
> > i tried TEXT(C2;""), and FIND("/";C2;1),
> >
> >
> > On 26-4-2019 00:45, Remy Gauthier wrote:
> >> Hi,
> >>
> >> I am assuming you are using Calc. There is no formula to do this: it is
> >> a cell formatting accessible via Format -> Cells... -> Numbers Tab,
> >> then go to the "Fraction" category. There you can select the # ???/???
> >> format which will do what you are looking for.
> >>
> >> I hope this helps.
> >>
> >> R??my.
> >> Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
> >>> I need a formula that takes as input a percent and outputs a fraction
> >>> that only has whole numbers.
> >>> Eg.
> >>> 1% -> "1/100"
> >>> 0.5% -> "1/200"
> >>> 1.5% -> "3/200"
> >>>
> >>>
>
> --
> 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: [libreoffice-users] percent to whole fraction
Let me rephrase the question ;)
In the 'example' line we see:
56 302 28/151
The actual cell contents are:
56 302 0,18543046357615894039735099337748
Is it possible to get the values '28' and '151' as show by the
fraction-formatter?
On 26-4-2019 19:01, Luuk wrote:
Is there an option to convert a cell with format 'Fraction' to text?
example:
a b 'a/b
52 297 52/297
56 302 28/151
66 311 66/311
in this third line, i want to get '28' and '151'
i tried TEXT(C2;""), and FIND("/";C2;1),
On 26-4-2019 00:45, Remy Gauthier wrote:
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"
--
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] percent to whole fraction
Calc can format cells as a fraction. For instance in an empty cell input "=pi()" without the quotes. The cell will display 3.141592654. Then format the cell as FORMAT -> FRACTION -> FORMAT CODE -> and enter ???/??? which will change the display to 355/113. Is this what you need? On 4/25/19 3:42 PM, James wrote: I need a formula that takes as input a percent and outputs a fraction that only has whole numbers. Eg. 1% -> "1/100" 0.5% -> "1/200" 1.5% -> "3/200" -- A smile - is a sign of joy. A hug - is a sign of love. A laugh - is a sign of happiness. May your troubles be less... May your blessings be more... May nothing but happiness come through your door!! Blessings, Joe Conner Joshua 24:15 "...as for me and my house, we will serve the LORD." -- 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] percent to whole fraction
Is there an option to convert a cell with format 'Fraction' to text?
example:
a b 'a/b
52 297 52/297
56 302 28/151
66 311 66/311
in this third line, i want to get '28' and '151'
i tried TEXT(C2;""), and FIND("/";C2;1),
On 26-4-2019 00:45, Remy Gauthier wrote:
Hi,
I am assuming you are using Calc. There is no formula to do this: it is
a cell formatting accessible via Format -> Cells... -> Numbers Tab,
then go to the "Fraction" category. There you can select the # ???/???
format which will do what you are looking for.
I hope this helps.
R??my.
Le jeudi 25 avril 2019 ?? 21:42 +, James a ??crit :
I need a formula that takes as input a percent and outputs a fraction
that only has whole numbers.
Eg.
1% -> "1/100"
0.5% -> "1/200"
1.5% -> "3/200"
--
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: FODT Write Error. The file could not be written.
Hi Regina, Wade and Mike,
thanks for your time.
The problem is common to multiple workstations (various Ubuntu LTS), on
my system the version is 6.0.7.3 (Build ID: 1:6.0.7-0ubuntu0.18.04.5).
As a side note the document was working till an unspecified update, so
I think it has to do with the XML itself and it's not a permission
error ("strace -ff -e open,openat,fstat,read" does not show anything
related to that).
It does succeed to save in DOCX format but fails in ODT and FODT (that
are the formats we prefer).
When saving in ODT:
Error saving the document report_233:
Write Error.
Error in writing sub-document styles.xml.
When saving in FODT:
Error saving the document report_233:
Write Error.
The file could not be written.
Other times I get a generic I/O error.
The smallest file that gives that error is:
http://paste.arn-fai.net/?2873952
By removing the whole 'FooterTable_Row' it successfully saves an FODT.
By removing 'style:family="table-cell"' it successfully saves an FODT.
How can I debug such issues in the future without going trial and error?
Thanks and have a great day,
Francesco
On 26/04/19 12:36, Regina Henschel wrote:
> Hi Francesco,
>
> Can it be saved to any of the other formats, eg odt or docx?
>
> Can you provide such generated fodt-file?
>
> Do you have compared, that a version without content is the same if
> saved from LibreOffice as if generated by your application?
>
> Which OS? Correct rights?
>
> Kind regards
> Regina
>
> Francesco Ongaro schrieb am 26-Apr-19 um 12:02:
>> Dear LibreOffice Community,
>>
>> sorry to bother, do you think there is a better place to ask such
>> question?
>>
>> I'm available to rebuild Libreoffice with symbols and debug it with
>> a little guidance (c++ sources are huge!).
>>
>> Thanks,
>> Francesco
>>
>> On 12/04/19 21:05, Francesco Ongaro wrote:
>>> Dear LibreOffice Community,
>>>
>>> I programmatically generate a FODT that opens without any problem and
>>> can be edited.
>>>
>>> When saving such FODT document I get "Write Error. The file could not be
>>> written.".
>>>
>>> BTW the document is valid XML, is there a method to debug such issue?
>>>
>>> I tried -DXSLTransformer.statsfile=/tmp/xslt_debug.txt as a Java startup
>>> parameter but the file is not created and I'm not sure that Java's XSLT
>>> is called when saving a document.
>>>
>>> Thanks a lot,
>>> ascii
>>>
>>> https://ask.libreoffice.org/en/question/190226/fodt-write-error-the-file-could-not-be-written/
>>>
>>>
>>
>>
>
>
--
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: FODT Write Error. The file could not be written.
On 26/04/2019 11:02, Francesco Ongaro wrote: Dear LibreOffice Community, sorry to bother, do you think there is a better place to ask such question? I'm available to rebuild Libreoffice with symbols and debug it with a little guidance (c++ sources are huge!). You really do /not/ want to go there :-} :-} Thanks, Francesco On 12/04/19 21:05, Francesco Ongaro wrote: Dear LibreOffice Community, I programmatically generate a FODT that opens without any problem and can be edited. When saving such FODT document I get "Write Error. The file could not be written.". You might get more help if you included information such as your OS and the LO version. There are a couple of very obvious things to check meanwhile - are the file and directory permissions set to allow you to do the save? As it's flat xml, try opening it in your choice of ordinary text editor and seeing if you can do the equivalent save operation from there (you don't say why you think it's an LO issue). -- Mike Scott (unet2 [deletethis] scottsonline.org.uk) Harlow Essex England "The only way is Brexit" -- anon. -- 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] FODT Write Error. The file could not be written.
With the info provided - sounds like a permission problem. Which folder are you writing too? Right click and see what the permissions are. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Apr 12, 2019 at 2:07 PM Francesco Ongaro wrote: > > Dear LibreOffice Community, > > I programmatically generate a FODT that opens without any problem and > can be edited. > > When saving such FODT document I get "Write Error. The file could not be > written.". > > BTW the document is valid XML, is there a method to debug such issue? > > I tried -DXSLTransformer.statsfile=/tmp/xslt_debug.txt as a Java startup > parameter but the file is not created and I'm not sure that Java's XSLT > is called when saving a document. > > Thanks a lot, > ascii > > https://ask.libreoffice.org/en/question/190226/fodt-write-error-the-file-could-not-be-written/ > > -- > 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: [libreoffice-users] Re: FODT Write Error. The file could not be written.
Hi Francesco, Can it be saved to any of the other formats, eg odt or docx? Can you provide such generated fodt-file? Do you have compared, that a version without content is the same if saved from LibreOffice as if generated by your application? Which OS? Correct rights? Kind regards Regina Francesco Ongaro schrieb am 26-Apr-19 um 12:02: Dear LibreOffice Community, sorry to bother, do you think there is a better place to ask such question? I'm available to rebuild Libreoffice with symbols and debug it with a little guidance (c++ sources are huge!). Thanks, Francesco On 12/04/19 21:05, Francesco Ongaro wrote: Dear LibreOffice Community, I programmatically generate a FODT that opens without any problem and can be edited. When saving such FODT document I get "Write Error. The file could not be written.". BTW the document is valid XML, is there a method to debug such issue? I tried -DXSLTransformer.statsfile=/tmp/xslt_debug.txt as a Java startup parameter but the file is not created and I'm not sure that Java's XSLT is called when saving a document. Thanks a lot, ascii https://ask.libreoffice.org/en/question/190226/fodt-write-error-the-file-could-not-be-written/ -- 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: FODT Write Error. The file could not be written.
Dear LibreOffice Community, sorry to bother, do you think there is a better place to ask such question? I'm available to rebuild Libreoffice with symbols and debug it with a little guidance (c++ sources are huge!). Thanks, Francesco On 12/04/19 21:05, Francesco Ongaro wrote: > Dear LibreOffice Community, > > I programmatically generate a FODT that opens without any problem and > can be edited. > > When saving such FODT document I get "Write Error. The file could not be > written.". > > BTW the document is valid XML, is there a method to debug such issue? > > I tried -DXSLTransformer.statsfile=/tmp/xslt_debug.txt as a Java startup > parameter but the file is not created and I'm not sure that Java's XSLT > is called when saving a document. > > Thanks a lot, > ascii > > https://ask.libreoffice.org/en/question/190226/fodt-write-error-the-file-could-not-be-written/ > -- 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
