Bugzilla – Attachment 89665 Details for
Bug 71897
FILESAVE: Format Cells (Numbers) for a whole column not retained in empty cells if saving as XLSX
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
attachment-17588-0.html
attachment-17588-0.html (text/html), 2.86 KB, created by
Shahrizal Kamal
on 2013-11-23 01:42:04 UTC
(
hide
)
Description:
attachment-17588-0.html
Filename:
MIME Type:
Creator:
Shahrizal Kamal
Created:
2013-11-23 01:42:04 UTC
Size:
2.86 KB
patch
obsolete
><div dir="ltr">Hi,<div><br></div><div>Thanks for your prompt response. My reply are as below:</div><div><br></div><div>1. I am unable to provide my files as those are confidential files however, I attached herewith a sample file for your attention. As you can see, the first three rows are the format which I have set-up according to my preference. The second three rows are new figures/data after I re-open the file. It seems that it goes back to default.</div> ><div><br></div><div>2. The settings I have chosen in the 'Tools' menu for language is Malay (Malaysian).</div><div><br></div><div>3. I always saved my files with 'xlsx' (Microsoft Office 2007/2010) settings as sometimes I do have to share some of my files with my colleagues who are mostly Windows users.</div> ><div><br></div><div>4. I do not understand fully the question but I guess I did the direct formatting. To describe it further, I just highlighted the entire column/row, right click at the highlighted column/row, chose 'Format Cell' and did the necessary changes in accordance with my preferences.</div> ><div><br></div><div>Hope my explanation above suffices.</div><div><br></div><div><br></div><div>Thank you.</div><div><br></div><div><br></div><div>regards,</div><div>Shahrizal Kamal</div></div><div class="gmail_extra"><br> ><br><div class="gmail_quote">On Fri, Nov 22, 2013 at 3:38 PM, <span dir="ltr"><<a href="mailto:bugzilla-daemon@freedesktop.org" target="_blank">bugzilla-daemon@freedesktop.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> > > > > > <div> > <p> > </p><div> > <b><a title="UNCONFIRMED --- - Format cell" href="https://bugs.freedesktop.org/show_bug.cgi?id=71897#c1" target="_blank">Comment # 1</a> > on <a title="UNCONFIRMED --- - Format cell" href="https://bugs.freedesktop.org/show_bug.cgi?id=71897" target="_blank">bug 71897</a> > from <span><a href="mailto:dominique.boutry3@laposte.net" title="Dominique Boutry <dominique.boutry3@laposte.net>" target="_blank"> <span>Dominique Boutry</span></a> ></span></b> > <pre>Hi, > >- are your Calc file sufficiently anonymous to be provided to us for analysis ? >- what settings do you have in Tools > Options > Language settings > Language ? >- what format (ODS ? XLS ? other ?) do you use for saving and reopening ? >- do you format cells explicitely (what we call "direct formating"), not with >the "Cell Style" feature ? > >Regards</pre> > </div> > <p></p> > <hr> > <span>You are receiving this mail because:</span> > > <ul> > <li>You reported the bug.</li> > </ul> > </div> > ></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">regards,<br>Shahrizal Kamal<br><i><br></i></div> ></div> >
<div dir="ltr">Hi,<div><br></div><div>Thanks for your prompt response. My reply are as below:</div><div><br></div><div>1. I am unable to provide my files as those are confidential files however, I attached herewith a sample file for your attention. As you can see, the first three rows are the format which I have set-up according to my preference. The second three rows are new figures/data after I re-open the file. It seems that it goes back to default.</div> <div><br></div><div>2. The settings I have chosen in the 'Tools' menu for language is Malay (Malaysian).</div><div><br></div><div>3. I always saved my files with 'xlsx' (Microsoft Office 2007/2010) settings as sometimes I do have to share some of my files with my colleagues who are mostly Windows users.</div> <div><br></div><div>4. I do not understand fully the question but I guess I did the direct formatting. To describe it further, I just highlighted the entire column/row, right click at the highlighted column/row, chose 'Format Cell' and did the necessary changes in accordance with my preferences.</div> <div><br></div><div>Hope my explanation above suffices.</div><div><br></div><div><br></div><div>Thank you.</div><div><br></div><div><br></div><div>regards,</div><div>Shahrizal Kamal</div></div><div class="gmail_extra"><br> <br><div class="gmail_quote">On Fri, Nov 22, 2013 at 3:38 PM, <span dir="ltr"><<a href="mailto:bugzilla-daemon@freedesktop.org" target="_blank">bugzilla-daemon@freedesktop.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"> <div> <p> </p><div> <b><a title="UNCONFIRMED --- - Format cell" href="https://bugs.freedesktop.org/show_bug.cgi?id=71897#c1" target="_blank">Comment # 1</a> on <a title="UNCONFIRMED --- - Format cell" href="https://bugs.freedesktop.org/show_bug.cgi?id=71897" target="_blank">bug 71897</a> from <span><a href="mailto:dominique.boutry3@laposte.net" title="Dominique Boutry <dominique.boutry3@laposte.net>" target="_blank"> <span>Dominique Boutry</span></a> </span></b> <pre>Hi, - are your Calc file sufficiently anonymous to be provided to us for analysis ? - what settings do you have in Tools > Options > Language settings > Language ? - what format (ODS ? XLS ? other ?) do you use for saving and reopening ? - do you format cells explicitely (what we call "direct formating"), not with the "Cell Style" feature ? Regards</pre> </div> <p></p> <hr> <span>You are receiving this mail because:</span> <ul> <li>You reported the bug.</li> </ul> </div> </blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr">regards,<br>Shahrizal Kamal<br><i><br></i></div> </div>
View Attachment As Raw
Actions:
View
Attachments on
bug 71897
: 89665 |
89666
|
89667
|
118677