Re: Open Office Calc Infinite Anchors Issue

[Martin Groenescheij]

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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Calc Infinite Anchors Issue

[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 
<vidu_s...@yahoo.com> 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 <b.m.bar...@btinternet.com> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: users@openoffice.apache.org
 Cc: "Vidu Sebastian" <vidu_s...@yahoo.com>
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +, 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: users-unsubscr...@openoffice.apache.org
 For additional commands, e-mail: users-h...@openoffice.apache.org
 
 
  

Re: Open Office Calc Infinite Anchors Issue

[Brian Barker]

At 16:43 24/02/2018 +, 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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Calc Infinite Anchors Issue

[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 <b.m.bar...@btinternet.com> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: users@openoffice.apache.org
 Cc: "Vidu Sebastian" <vidu_s...@yahoo.com>
 Date: Saturday, February 24, 2018, 5:46 PM
 
 At 09:51 24/02/2018 +, 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: users-unsubscr...@openoffice.apache.org
 For additional commands, e-mail: users-h...@openoffice.apache.org
 
 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Calc Infinite Anchors Issue

[Brian Barker]

At 09:51 24/02/2018 +, 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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Open Office Calc Infinite Anchors Issue

[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 <nore...@tasit.net> wrote:

 Subject: Re: Open Office Calc Infinite Anchors Issue
 To: "Apache OpenOffice Users" <users@openoffice.apache.org>
 Cc: "Vidu Sebastian" <vidu_s...@yahoo.com>
 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: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

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 
To: Apache OpenOffice Users 
Date: Sat, 24 Feb 2018 13:17:23 +

> 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: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org

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




After_Calc_Save.ods
Description: application/vnd.oasis.opendocument.spreadsheet

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org