Border thickness changes between LO Calc and MS Excel

[Wayne Twine]

Hi

I am running LO 3.5.7.2 and MS Office 2010 using Wine/Crossover in Ubuntu 12.04 .
I usually use LO Calc but have to use MS Excel when collaborating with colleagues because some formatting issues.

What I expect:
border thickness to be the same when opening a file in either Calc or Excel.

What happens instead:
1) If I set border in Calc spreadsheet to smooth line with thickness of 0.05 pt, save it in xlsx or xls format, and then open the file in Excel, the border appears as a fine dotted line in Excel.
2) If I set border in Excel spreadsheet to thinnest smooth line, save it in xlsx format, and then open the file in Calc, the line appears as a thick line (1.00 pt) in Calc.

Note: Line thickness does not change if I set it as fine line in Excel, save it in xls format, and then open in Calc.

Thanks

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: libreoffice (not installed)
ProcVersionSignature: Ubuntu 3.2.0-41.66-generic 3.2.42
Uname: Linux 3.2.0-41-generic x86_64
ApportVersion: 2.0.1-0ubuntu17.2
Architecture: amd64
Date: Wed May 15 08:31:24 2013
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
MarkForUpload: True
SourcePackage: libreoffice
UpgradeStatus: Upgraded to precise on 2012-06-15 (333 days ago)

[Wayne Twine (wayne-twine)]

Just to add to my posting above: The same happens when opening or saving files in Excel 2007 on a Windows machine, so it's not a Wine bug.

[penalvch (penalvch)]

Wayne Twine, thank you for reporting this and helping make Ubuntu better. Could you please attach a file made in Excel, before opening in LibreOffice, that demonstrates this problem?

[Wayne Twine (wayne-twine)]

Hi
Sure. Should I attach to this email or log onto Launchpad and paste it
there?

my new signature v3

Regards

Dr. Wayne Twine
Senior lecturer

School of Animal, Plant & Environmental Sciences
University of the Witwatersrand
c/o Wits Rural Facility
Private Bag X420
Acornhoek,1360
South Africa

Tel: [phone]
Fax: [phone]
<email address hidden>

/“//Two////men////look////out////the////same////prison////bars;////one////sees////mud////and////the////other////sees////stars.//”
/FrederickLangbridge(1849-1922)

On 15/05/13 12:48, Christopher M. Penalver wrote:
> Wayne Twine, thank you for reporting this and helping make Ubuntu
> better. Could you please attach a file made in Excel, before opening in
> LibreOffice, that demonstrates this problem?
>
> ** Changed in: libreoffice (Ubuntu)
> Status: New => Incomplete
>

[Wayne Twine (wayne-twine)]

Oh, ok, I am new to Launchpad, so I didn't realise that the email I received was also posted here. Chris, is it possible to remove my reply to your email from this bug report so that my email address is not broadcast to all and sundry?

Anyway, attached is an .xlsx file created in Excel, with fine border lines. If you open in Calc, you will see that they are thicker (1.00 pt).

If you uncheck "use antialiasing" in LO options, the lines look a bit better (a bit more in focus), but are still too thick.

I hope this helps.

Wayne

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Marcus Tomlinson (marcustomlinson)]

This release of Ubuntu is no longer receiving maintenance updates. If this is still an issue on a maintained version of Ubuntu please let us know.

[Launchpad Janitor (janitor)]

[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.]