Issue 5092

Summary: formula styles
Product: Writer Reporter: parrenin <parrenin.frederic>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: bluedzins, dah8, don.troodon, issues, masaya.k, purity89, rb.henschel, zmogas
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: PC   
OS: Linux, all   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description parrenin 2002-05-21 09:25:33 UTC
I you write texts that contain a lot of formulas, it would be helpful to have
formula styles, like frame styles, character styles, paragraph styles...

This would allow to modify all formulas in a text file in the same time.

For example, imagine you have written a text with a 12pt size with a lot of
formulas, also in 12pt fonts. Then, you want to modify your text in 10pt. It can
easily be made by changing the size of the font in the default style. But your
formulas are always in 12pt, and you have to modify them one by one !

We could find similar examples if you want to modify spacings, or alignment, or
font... in the formulas.

In all of these problems, formulas styles could help a lot.

I imagine it is not an easy task from the programmer point of vue, but I think
it would be a very good feature !

Thank you for your work.

     Frédéric
Comment 1 stefan.baltzer 2002-05-21 09:33:40 UTC
Reassigned to Michael.
Comment 2 michael.ruess 2002-05-23 09:52:08 UTC
Yes, it might be a helpful feature somehow. But I could imagine, that
this task would take a lot effort for developing.
MRU->CJ: Yours for decision...
Comment 3 christian.jansen 2003-03-24 08:01:49 UTC
Reassiged to Bettina.
Comment 4 Regina Henschel 2007-10-22 22:32:08 UTC
This issue seems to be connected to issue 42119 and should be solved together
with that. Issue 42119 has got some votes and should be kept therefore. Can we
close this issue?
Comment 5 Regina Henschel 2007-10-22 22:42:31 UTC
*** Issue 82854 has been marked as a duplicate of this issue. ***
Comment 6 ftack 2008-03-14 10:06:07 UTC
Issue 42119 should also be marked as a duplicate of this issue. More
importantly, this issue might deserve some attention in the mean time: it is
sitting here for six years (birthday within a few days together with spring
season in the nothern hemisphere). Many aspects in OOo are controlled through a
powerful style mechanism, which is one of the strengths of the suite. Formulas
should not be an exception.
Comment 7 michael.ruess 2008-03-26 14:49:36 UTC
*** Issue 87371 has been marked as a duplicate of this issue. ***
Comment 8 michael.ruess 2008-03-26 14:51:55 UTC
*** Issue 42119 has been marked as a duplicate of this issue. ***
Comment 9 dhollm 2009-02-18 10:00:18 UTC
With regards to the importance of this issue, many students use OO due to its
low cost and academics are probably more likely to use the formula editor.  So
this may impact a larger proportion of users than would first appear.

A suggestion for the styles themselves would be that they should ideally replace
all of the Format menu functions. Since a given formula has different formatting
(eg the for the existing items in the Format->Fonts dialog: variables,
functions, etc.) the simplest thing might be to create a new "formula style"
section in the Styles and Formatting window.  This would seem preferable to some
system where four different character styles applied to each formula.
Comment 10 jgehrcke 2009-07-10 12:42:04 UTC
Hello!

What's the status of this issue?

I really would appreciate this feature, too. As stated here: 
http://qa.openoffice.org/issues/show_bug.cgi?id=42119 , this feature is a
requirement and thats my opinion, too. Perhaps it should get priority P2? This
issue celebrated 7th birthday some time ago ;-)

After searching the web, I spontaneously found these two forum threads where
users asked for the feature:
http://www.oooforum.org/forum/viewtopic.phtml?t=4392
http://user.services.openoffice.org/en/forum/viewtopic.php?f=12&t=7771

As stated in one of the threads, the macro presented in the discussion for Issue
42119 is not a good solution.

Perhaps someone is able to temporarily give a good macro solution until this
features is realized with styles?

Thank you for your hard work,

Jan-Philip Gehrcke



Comment 11 bettina.haberer 2010-05-21 14:43:07 UTC
To grep the issues easier via "requirements" I put the issues currently lying on
my owner to the owner "requirements". 
Comment 12 agn01 2010-10-13 12:53:53 UTC
Hi,
I'am pleased to give a macro.
See here : <http://agnooo.free.fr/pluxml/?article6/nouvel-article>
You will find a file to test it and the extension.

It's certainely not a "good macro" but it's "a macro" that I use every day for
my work.
The macro does only what I need, it could do more if necessary.
However, there's still a problem, sometimes, with  refreshing the document.

The macro is in french, as you could suspect from my poor english, but I think
you could easily manage with it.
Comment 13 Filip Sund 2012-06-05 13:56:05 UTC
I couldn't get(In reply to comment #12)
> Hi,
> I'am pleased to give a macro.
> See here : <http://agnooo.free.fr/pluxml/?article6/nouvel-article>
> You will find a file to test it and the extension.
> 
> It's certainely not a "good macro" but it's "a macro" that I use every day
> for
> my work.
> The macro does only what I need, it could do more if necessary.
> However, there's still a problem, sometimes, with  refreshing the document.
> 
> The macro is in french, as you could suspect from my poor english, but I
> think
> you could easily manage with it.

I couldn't get your macro to work (I get an error message about halfway through my document), but here is a simpler, more manual macro that does the job:


Sub Main
    embeddedObjects = ThisComponent.getEmbeddedObjects()
    elementNames = embeddedObjects.getElementNames()
    for i=0 to UBOUND(elementNames)
        element = embeddedObjects.getByName(elementNames(i)).Model
        if (not isNull(element)) then
            if (element.supportsService("com.sun.star.formula.FormulaProperties")) then
                element.BaseFontHeight = 14
                element.FontNameVariables= "Arial"
                element.FontNameFunctions = "Arial"     
                element.FontNameNumbers= "Arial"       
                element.FontNameText= "Arial"       
            endif
        endif
    next i
    ThisComponent.reformat()
End Sub


Replace "Arial" with whatever font you want, and 14 with wanted font size. Thanks to Brecht Machiels at Superuser.com and the French OpenOffice Wiki.
 - <http://superuser.com/questions/290197/how-to-change-the-font-of-all-equations-in-libreoffice-writer>
 - <http://wiki.services.openoffice.org/wiki/Fr.openoffice.org/FAQ/Math/102>