Re: [libreoffice-users] Re: Change cell border sizes- quickly?

On 12/14/2011 03:15 PM, NoOp wrote:
> On 12/14/2011 04:26 AM, . wrote:
> > On 12/14/2011 05:45 AM, MiguelAngel wrote:
> ...
> > > With F11, select Default format, and change there the border.
> > > If there is another style non vinculated with default, change it also.
> > >
> > > Miguel Ángel
> > Miguel, I tried it with one of the sheets but it had no effect.  I tried
> > it with a new sheet but no effect either.
> >
> > Here's what I did;
> >
> > - opened the ods file I want to work on which has about 90 sheets within it.
> > - hit F11
> > - right clicked on Default in Styles and Formatting
> > - change the Cell Borders to 1 pt. and selected Default under Line
> > Arrangement
> >
> > At that point in the process the there's a lot of activity (so to speak)
> > in the bottom of the Calc window...some progress bar flashing (so
> > whatever it's called)  giving the impression that what I wanted to
> > change is occurring.  However, a check of the cell formatting indicates
> > that the cell border size wasn't changed.
> >
> > Any other ideas?
> Works for me:
>
> LibreOffice 3.3.4
> OOO330m19 (Build:401)
> tag libreoffice-3.3.4.1
>
> and
>
> LibreOffice 3.4.4
> OOO340m1 (Build:402)
What "worked for you" and what did it accomplish?


Here's a rather lengthy and complex cell border fix-

- open the ods file you want to correct all of the cell border sizes in.

- Click---->File--->Save As---> OpenDocument Sheet Flat XML file (.fods)

- Exit Calc

- Open the .fods file you just saved with a simple text editor

- Search for the following line-  <style:table-cell-properties
fo:border-bottom="0.0071in solid #000000" fo:background-color="#ffff00"

NOTE- what you're looking for, primarily, is the word "border" which
will have a number near it.  In my case the border size was "0.0071in 
FORGET that .0071 is essentially 7 thousandths of an inch.  In my first
attempt to fix the border I simply replaced the "0.0071in with "1ptin
and it fixed it to just what I wanted.  When I opened the .fods file
again, just to look at it, the former "1ptin had been changed to "0.0071in

- Save the edited .fods file

- Open the edited .fods file in Calc

- See if all the cell borders are what you wanted

- If all is well save the .fods as an .ods file


Conclusion-  I sure would like to hear of an easy solution to this
problem of easily changing all existing cell borders to a certain size. 
The sheets I was working on had so many cells with borders, which were
all the same, that it would've taken at least a week to fix it.





>


-- 
For unsubscribe instructions e-mail to: users+help@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