Home
ExcelCalcs
multiplication formatting (1 viewing) (1) Guest
Please post any suggestions or ideas that you think the ExcelCalcs team should consider.
 Favoured: 1 Page: << Start < Prev 1 2 Next > End >>
TOPIC: multiplication formatting
#107
(Visitor)
Froglet (Expert Boarder)
Posts: 16

 multiplication formatting 11 Years, 6 Months ago Karma: 10 When creating equations using other tools such as equation editor I often find that the equation looks a little crowded (particularly when greek characters are used). The solution to this is to include the multiplication operator to help space the parameters. XLC allows the use of an x for this although this doesn't always help and could be confused for a parameter in some cases. Brackets can also be used to help break up the equation. However my preference is to use a combination of spaces, brackets and a dot operator (a full stop or period at mid height). So my suggestion is to add the option to use a dot for the multiplication operator and include the facility to add a space between characters (less important but sometimes helps for things such as Cos^2(theta)).

Logged
The administrator has disabled public write access.
#116
Mechanical Engineer.
Moderator
Posts: 1773

 Re:multiplication formatting 11 Years, 6 Months ago Karma: 494 Thanks for the suggestion I should be able to do this quite easily. I'll add this to my 'todo' list. Subscribe to this topic to be advised of developments.

Post edited by: JohnDoyle, at: 2007/04/08 17:03

Logged

The administrator has disabled public write access.
#170
(User)
Frog Prince (Platinum Boarder)
Posts: 35

 Re:multiplication formatting 11 Years, 5 Months ago Karma: 9 Regarding incorporating the multiplication sign, what do you guys think about using the * character as is used in EXCEL? This may help in back checking ( and/or synchronizing) the equation generated by XLC. I know the use of * character is not as in traditional equations, but this would almost simulate the use of the dot operator and will also be consistent with what is used in EXCEL.

Logged

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
http://www.energyefficientbuild.com
The administrator has disabled public write access.
#172
Mechanical Engineer.
Moderator
Posts: 1773

 Re:multiplication formatting 11 Years, 5 Months ago Karma: 494 I am planning allow users to set their own multiplication character as a program option. I hope this will keep everyone happy.

Logged

The administrator has disabled public write access.
#1595
(User)
Frog (Gold Boarder)
Posts: 25

 Re:multiplication formatting 9 Years, 5 Months ago Karma: 0 This is probably too nit-picky. See attached *.pdf file and look at last equation. It appears there are extra spaces added before and after the multiplication and division operator symbols, causing the XLC equation to be far wider than necessary. Is there a way to compact the equation? Thanks.

Logged
The administrator has disabled public write access.
#1596
(User)
Frog (Gold Boarder)
Posts: 25

 Re:multiplication formatting 9 Years, 5 Months ago Karma: 0 Wouldn't let me attach *.pdf, will try *.xls

Logged

Last Edit: 2009/05/01 01:18 By jpriley485. Reason: attach zip file
The administrator has disabled public write access.
 Page: << Start < Prev 1 2 Next > End >>
We have 9 guests and 40 members online