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: [email protected] 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
