Open Office Calc Infinite Anchors Issue

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Open Office Calc Infinite Anchors Issue

Vidu Sebastian
Hey everyone. I have an XLS file and when i modify it with Open Office Calc and save it i can see a lot of blank anchors covering my spreadsheet. I attached to this mail the before and after file .



---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Before.xlsx (78K) Download Attachment
After.ods (72K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

DaveB
On 24.02.2018 09:51, Vidu Sebastian wrote:
Hey everyone. I have an XLS file and when i modify it with Open Office Calc and save it i can see a lot of blank anchors covering my spreadsheet. I attached to this mail the before and after file .

Hi Vidu,

You attached 2 files Before.xlsx and After.ods but you have not said how you converted Before.xlsx to After.ods I suspect that you or someone else has used MS Excel to open Before.xlsx and then saved the opened file as After.ods If this is the case, the process is doomed to failure, because MS Office does not always correctly format ODF files. Using this method I can perfectly and repeatedly replicate your issue of badly anchored empty comment boxes when saved by MS Excel in ods format.

Why not simply open Before.xlsx in Calc, then use Calc's "File -> Save As.." option to save the file in ods format by selecting the ods "File type" in the "Save As" dialog?
Attached is my conversion using this method.

Regards
Dave




---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

After_Calc_Save.ods (71K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

DaveB
OK before everyone starts jumping up and down, the ods file attached to
my previous post shows the same error Vidu is reporting. Strange thing
is that after saving there is no sign of the bad anchors, they only
appear when the file is reopened in AOO Calc. Also puzzling is that the
ods file saved from AOO Calc opens and displays correctly in LO Calc.

Looks like it is a bug in AOO Calc. Apologies for creating useless list
noise.

Dave

-------- Original Message --------
From: DaveB <[hidden email]>
To: Apache OpenOffice Users <[hidden email]>
Date: Sat, 24 Feb 2018 13:17:23 +0000

> On 24.02.2018 09:51, Vidu Sebastian wrote:
>> Hey everyone. I have an XLS file and when i modify it with Open
>> Office Calc and save it i can see a lot of blank anchors covering my
>> spreadsheet. I attached to this mail the before and after file .
>
> Hi Vidu,
>
> You attached 2 files Before.xlsx and After.ods but you have not said
> how you converted Before.xlsx to After.ods I suspect that you or
> someone else has used MS Excel to open Before.xlsx and then saved the
> opened file as After.ods If this is the case, the process is doomed to
> failure, because MS Office does not always correctly format ODF files.
> Using this method I can perfectly and repeatedly replicate your issue
> of badly anchored empty comment boxes when saved by MS Excel in ods
> format.
>
> Why not simply open Before.xlsx in Calc, then use Calc's "File -> Save
> As.." option to save the file in ods format by selecting the ods "File
> type" in the "Save As" dialog?
> Attached is my conversion using this method.
>
> Regards
> Dave
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Vidu Sebastian
In reply to this post by Vidu Sebastian
Thats exactly what  i did.. Amd when you open it agsin in ods format the issue appear. Even the file you atrached is with empty anchors in  it when i open it
--------------------------------------------
On Sat, 2/24/18, DaveB <[hidden email]> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: "Apache OpenOffice Users" <[hidden email]>
 Cc: "Vidu Sebastian" <[hidden email]>
 Date: Saturday, February 24, 2018, 3:17 PM
 
 
     On 24.02.2018 09:51,
 Vidu Sebastian
       wrote:
 
     
     
       
         Hey everyone. I have an XLS file and when i
 modify it with
           Open Office Calc and save it i can see a lot of
 blank anchors
           covering my spreadsheet. I attached to this mail
 the before
           and after file .
       
     
     
 
     Hi Vidu,
 
     
 
     You attached 2 files Before.xlsx and After.ods but you
 have not said
     how you converted Before.xlsx to After.ods I suspect
 that you or
     someone else has used MS Excel to open Before.xlsx and
 then saved
     the opened file as After.ods If this is the case, the
 process is
     doomed to failure, because MS Office does not always
 correctly
     format ODF files. Using this method I can perfectly and
 repeatedly
     replicate your issue of badly anchored empty comment
 boxes when
     saved by MS Excel in ods format.
 
     
 
     Why not simply open Before.xlsx in Calc, then use
 Calc's "File ->
     Save As.." option to save the file in ods format by
 selecting the
     ods "File type" in the "Save As"
 dialog?
 
     Attached is my conversion using this method.
 
     
 
     Regards
 
     Dave
 
     
 
     
 
   

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Brian Barker
In reply to this post by Vidu Sebastian
At 09:51 24/02/2018 +0000, Vidu Sebastian wrote:
>I have an XLS file and when i modify it with Open Office Calc and
>save it i can see a lot of blank anchors covering my spreadsheet. I
>attached to this mail the before and after file.

Open your .xls file in OpenOffice. Go to View | Navigator (or press
F5) to open the Navigator. Click the plus sign against "Drawing
objects" to open the list. You will see that you have 103 objects
called "CustomShape 1". I don't know what these do for you. Do you?
Do you need them? If not, go to each sheet in turn, move to the top,
and repeatedly click to select the object and press Delete to delete
it. I don't see any way to delete them en masse.

But there may be an easy workaround. Go to Tools | Options... |
OpenOffice Calc | View | Objects, and toggle "Drawing objects" from
Show to Hide. This won't remove them, of course, but may be enough
for your needs.

The web site zamzar.com converts documents between formats free of
charge. It will convert .xlsx files to .xls and also to .ods.
Interestingly, converting your .xlsx file into each format and
opening the result in OpenOffice creates exactly the same effect as
opening the .xlsx file directly, so the problem may not be simply a
problem with OpenOffice's conversion of the original .xlsx file.

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Vidu Sebastian
In reply to this post by Vidu Sebastian
Those Custom Shapes are exactly the cells with the text that is in them. If i delete them it will delete the whole data ... I will try the other workaround also
--------------------------------------------
On Sat, 2/24/18, Brian Barker <[hidden email]> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: [hidden email]
 Cc: "Vidu Sebastian" <[hidden email]>
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +0000, Vidu
 Sebastian wrote:
 >I have an XLS file and
 when i modify it with Open Office Calc and
 >save it i can see a lot of blank anchors
 covering my spreadsheet. I
 >attached to
 this mail the before and after file.
 
 Open your .xls file in OpenOffice. Go to View |
 Navigator (or press
 F5) to open the
 Navigator. Click the plus sign against "Drawing
 objects" to open the list. You will see
 that you have 103 objects
 called
 "CustomShape 1". I don't know what these do
 for you. Do you?
 Do you need them? If not,
 go to each sheet in turn, move to the top,
 and repeatedly click to select the object and
 press Delete to delete
 it. I don't see
 any way to delete them en masse.
 
 But there may be an easy workaround. Go to
 Tools | Options... |
 OpenOffice Calc | View
 | Objects, and toggle "Drawing objects" from
 Show to Hide. This won't remove them, of
 course, but may be enough
 for your
 needs.
 
 The web site
 zamzar.com converts documents between formats free of
 charge. It will convert .xlsx files to .xls and
 also to .ods.
 Interestingly, converting
 your .xlsx file into each format and
 opening the result in OpenOffice creates
 exactly the same effect as
 opening the
 .xlsx file directly, so the problem may not be simply a
 problem with OpenOffice's conversion of the
 original .xlsx file.
 
 I
 trust this helps.
 
 Brian
 Barker
 
 
 ---------------------------------------------------------------------
 To unsubscribe, e-mail: [hidden email]
 For additional commands, e-mail: [hidden email]
 
 

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Brian Barker
At 16:43 24/02/2018 +0000, Vidu Sebastian wrote:
>Those Custom Shapes are exactly the cells with the text that is in them.

What is your evidence for this, please? There is certainly no text
displayed in the drawing objects as displayed when the problem
appears, though you can enter text into them. Why do you think there
is text in them?

>If i delete them it will delete the whole data ...

Certainly not "the whole data": you can see this easily by trying it
out. Do you think that it would delete some data?

If you believe this, please identify for list readers just one single
cell which shows text in the original .xlsx file but fails to show it
(or all of it) when the drawing objects have been deleted. Then
people will be able to investigate the problem further for you.

>I will try the other workaround also

If you mean hiding the drawing objects, that surely will be no better
- if what you say above is true. If relevant text would be deleted by
deleting the drawing objects, hiding them (and that text) would
surely be just (almost?) as unhelpful?

Brian Barker  


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Vidu Sebastian
In reply to this post by Vidu Sebastian
Hey i tryed the hide options also but it doesnt help. I cant select my text from the cells. Please help me .
 

    On Saturday, February 24, 2018, 6:43:09 PM GMT+2, Vidu Sebastian <[hidden email]> wrote:  
 
 Those Custom Shapes are exactly the cells with the text that is in them. If i delete them it will delete the whole data ... I will try the other workaround also
--------------------------------------------
On Sat, 2/24/18, Brian Barker <[hidden email]> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: [hidden email]
 Cc: "Vidu Sebastian" <[hidden email]>
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +0000, Vidu
 Sebastian wrote:
 >I have an XLS file and
 when i modify it with Open Office Calc and
 >save it i can see a lot of blank anchors
 covering my spreadsheet. I
 >attached to
 this mail the before and after file.
 
 Open your .xls file in OpenOffice. Go to View |
 Navigator (or press
 F5) to open the
 Navigator. Click the plus sign against "Drawing
 objects" to open the list. You will see
 that you have 103 objects
 called
 "CustomShape 1". I don't know what these do
 for you. Do you?
 Do you need them? If not,
 go to each sheet in turn, move to the top,
 and repeatedly click to select the object and
 press Delete to delete
 it. I don't see
 any way to delete them en masse.
 
 But there may be an easy workaround. Go to
 Tools | Options... |
 OpenOffice Calc | View
 | Objects, and toggle "Drawing objects" from
 Show to Hide. This won't remove them, of
 course, but may be enough
 for your
 needs.
 
 The web site
 zamzar.com converts documents between formats free of
 charge. It will convert .xlsx files to .xls and
 also to .ods.
 Interestingly, converting
 your .xlsx file into each format and
 opening the result in OpenOffice creates
 exactly the same effect as
 opening the
 .xlsx file directly, so the problem may not be simply a
 problem with OpenOffice's conversion of the
 original .xlsx file.
 
 I
 trust this helps.
 
 Brian
 Barker
 
 
 ---------------------------------------------------------------------
 To unsubscribe, e-mail: [hidden email]
 For additional commands, e-mail: [hidden email]
 
 
 
Reply | Threaded
Open this post in threaded view
|

Re: Open Office Calc Infinite Anchors Issue

Martin Groenescheij
In reply to this post by Vidu Sebastian


On 24/02/18 8:51 PM, Vidu Sebastian wrote:
> Hey everyone. I have an XLS file and when i modify it with Open Office
> Calc and save it i can see a lot of blank anchors covering my
> spreadsheet. I attached to this mail the before and after file .
>
The problem is you don't have a XLS file but rather an XLSX file.
Just save the XSLX file as XLS (Excel 97 - 2003) and your problem is gone.

> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]