incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 30470] Calc needs ability to specify fixed decimal.
Date Mon, 18 Jun 2012 11:08:43 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=30470

Shirley <shcothran@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |shcothran@yahoo.com

--- Comment #11 from Shirley <shcothran@yahoo.com> ---
I was reading through the oldests bugs because my particular favorite is next
to the oldest.  In doing so, I ran across this bug -er- enhancement - that is
also rated trivial.  I think the powers that decide on what to work on are
using the votes of the current user base (and probably only the more technical
and vocal among them) and not the potential customers who are out there.  

But about this problem in particular.  This isn't a pretty solution but it
works.  It would be nicer if it were in a macro but every time I try to develop
a macro in OO, I fail miserably (in spite of having programmed for years and
years.  Once upon a time, I even wrote a HR budgeting system using only Lotus
macros).

So here is my suggestion.

1. Enter the series of numbers with and without decimal points:

        123 
          1 
       4567 
     1.2358

2. HIGHLIGHT the values you just entered.
3. Open FIND and REPLACE
4. Click on MORE OPTIONS
5. Put checkmarks in 
      CURRENT SELECTION ONLY
 and 
      REGULAR EXPRESSIONS

6. In the SEARCH FOR box copy and paste this: 
      ^[:digit:]*[^\.-\.][:digit:]*$
7. In the REPLACE WITH box enter 
      =&*.01
8. Click on FIND ALL to see which cells with be changed.  
9. Click on REPLACE ALL.

In the example, the results will appear as:
  1.23
   .01
 45.67
1.2358

Again, this isn't an elegant solution.  You have to remember to run the FIND
and REPLACE.  If you change one of the numbers after you did the FIND and
REPLACE, you have to enter the decimal point in the correct position. 

If you use a comma to separate whole numbers from the fractional part, this
isn't going to work but could be adapted.

-- 
You are receiving this mail because:
You are on the CC list for the bug.

Mime
View raw message