Re: [libreoffice-users] Calc - adding up score numbers

[charles meyer]

I have Excel 365 which operates differently but it finally worked with
Paste Special.

Thank you for your help.

Charles.

On Fri, Oct 21, 2022 at 3:31 PM Hastham S  wrote:

> Hi
>
> Which version of MS XL are you using ?
> Which operating system - MAC or Windows ?
>
> *Did you check the help URL that I had posted*
>
> for example in EXCEL 2003, this is what you do
>
>-
>- *Select the cell(s) whose values should be copied.*
>- *From the Edit menu, select Copy. ... *
>- *Select the first cell where the results should be pasted.*
>- *From the Edit menu, select Paste Special... ... *
>- *Under Paste, select Values.*
>- *Click OK*
>
>
>
> do you see a box like this when you click on paste special ? or what do
> you see?
> [image: Inline image]
>
>
>
> regards
>
>
>
> On Friday, October 21, 2022 at 10:24:14 PM GMT+4, charles meyer <
> reachmepl...@gmail.com> wrote:
>
>
> Hi,
>
> Thanks for the well wishes.
>
> I highlighted the last column with all the total numbers of that judge's
> scoring for that judge.
>
> I then drag the highlighted numbers in each cell in each frew for that
> column down from the first to the last story.
>
> I right clicked and chose Copy.
>
> I then opened a blank worksheet and there are 2 (two) Paste Specials.
>
> I chose the 1st and it doesn't paste in the numbers so I then chose the 2nd
> Paste Special but that didn't paste in the  numbers either.
>
> I'm not sure what's going wrong?
>
> Thanks.
>
> On Fri, Oct 21, 2022 at 1:44 PM Hastham S  wrote:
>
> > Hi Charles
> >
> > Great to know you are safe.
> >
> > Regarding the copy paste, I think you are just doing normal Control + C
> > and Control + V *which will copy the formulae*
> >
> > Please try paste special - paste values, when you paste on to the summary
> > sheet
> >
> > Paste values In MS Excel :
> > Copy and paste specific cell contents
> > <
> https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71
> >
> >
> > Copy and paste specific cell contents
> >
> >
> > <
> https://support.microsoft.com/en-us/office/copy-and-paste-specific-cell-contents-a956b1c3-cd5a-4245-852c-42e8f83ffe71
> >
> >
> > Paste values In Libre Office calc :
> > Paste Special
> > 
> >
> > Paste Special
> >
> > 
> >
> > Hope this helps
> >
> > regards
> > Hastham / Subu
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer <
> > reachmepl...@gmail.com> wrote:
> >
> >
> > Hi All,
> >
> >
> >
> > So grateful to have survived Hurricane Ian and to be able to help others
> in
> > the community.
> >
> >
> >
> > It seems Excel isn’t as straight forward as I’d like.
> >
> >
> >
> > Perhaps this is easier to do in Calc?
> >
> >
> >
> > I opened a blank worksheet and thought I’d create the first column of
> rows
> > with each cell populated with the name each a story. I then created
> columns
> > with the heading of the name of each judge.
> >
> >
> >
> > So, 50 rows (each story) and 4 columns comprised of each judge name and
> > then the last column named Total for total of points summed from each of
> > the judge’s scores.
> >
> >
> >
> > When I copy by highlighting all the score numbers from a judge’s total
> > score column and the paste those scores into the 1st cell under the
> column
> > for that judge I get #REF! in each cell.
> >
> >
> >
> > Is there a way to copy all those judge’s scores from each judge’s scoring
> > worksheet and pates them into a column for that judge in a new worksheet
> so
> > I have all the scores from all the judges and in the 4th column I can
> just
> > Click that Z Sum tab to add all 3 scores for each story (and then
> hopefully
> > sort them by highest score to lowest?
> >
> >
> >
> > I’ve never taken any Excel nor Calc class which taught this.
> >
> >
> >
> > Thank you so much.
> >
> >
> >
> > Best,
> >
> >
> >
> > Charles.
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > Posting guidelines + more:
> https://wiki.documentfoundation.org/Netiquette
> > List archive: https://listarchives.libreoffice.org/global/users/
> > Privacy Policy: https://www.documentfoundation.org/privacy
>
> >
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: 

Re: [libreoffice-users] Calc - adding up score numbers

[Hastham S]

 Hi
Which version of MS XL are you using ?Which operating system - MAC or Windows ?
Did you check the help URL that I had posted
for example in EXCEL 2003, this is what you do 
   
   -

   - Select the cell(s) whose values should be copied.
   - From the Edit menu, select Copy. ... 
   - Select the first cell where the results should be pasted.
   - From the Edit menu, select Paste Special... ... 
   - Under Paste, select Values.
   - Click OK


do you see a box like this when you click on paste special ? or what do you 
see? 




regards


On Friday, October 21, 2022 at 10:24:14 PM GMT+4, charles meyer 
 wrote:  
 
 Hi,

Thanks for the well wishes.

I highlighted the last column with all the total numbers of that judge's
scoring for that judge.

I then drag the highlighted numbers in each cell in each frew for that
column down from the first to the last story.

I right clicked and chose Copy.

I then opened a blank worksheet and there are 2 (two) Paste Specials.

I chose the 1st and it doesn't paste in the numbers so I then chose the 2nd
Paste Special but that didn't paste in the  numbers either.

I'm not sure what's going wrong?

Thanks.

On Fri, Oct 21, 2022 at 1:44 PM Hastham S  wrote:

> Hi Charles
>
> Great to know you are safe.
>
> Regarding the copy paste, I think you are just doing normal Control + C
> and Control + V *which will copy the formulae*
>
> Please try paste special - paste values, when you paste on to the summary
> sheet
>
> Paste values In MS Excel :
> Copy and paste specific cell contents
> 
>
> Copy and paste specific cell contents
>
>
> 
>
> Paste values In Libre Office calc :
> Paste Special
> 
>
> Paste Special
>
> 
>
> Hope this helps
>
> regards
> Hastham / Subu
>
>
>
>
>
>
>
>
>
>
> On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer <
> reachmepl...@gmail.com> wrote:
>
>
> Hi All,
>
>
>
> So grateful to have survived Hurricane Ian and to be able to help others in
> the community.
>
>
>
> It seems Excel isn’t as straight forward as I’d like.
>
>
>
> Perhaps this is easier to do in Calc?
>
>
>
> I opened a blank worksheet and thought I’d create the first column of rows
> with each cell populated with the name each a story. I then created columns
> with the heading of the name of each judge.
>
>
>
> So, 50 rows (each story) and 4 columns comprised of each judge name and
> then the last column named Total for total of points summed from each of
> the judge’s scores.
>
>
>
> When I copy by highlighting all the score numbers from a judge’s total
> score column and the paste those scores into the 1st cell under the column
> for that judge I get #REF! in each cell.
>
>
>
> Is there a way to copy all those judge’s scores from each judge’s scoring
> worksheet and pates them into a column for that judge in a new worksheet so
> I have all the scores from all the judges and in the 4th column I can just
> Click that Z Sum tab to add all 3 scores for each story (and then hopefully
> sort them by highest score to lowest?
>
>
>
> I’ve never taken any Excel nor Calc class which taught this.
>
>
>
> Thank you so much.
>
>
>
> Best,
>
>
>
> Charles.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

R: Re: AW: [libreoffice-users] State of docx support.

[Paolo Debortoli]

I had more problems with .docx files. I guess main problem Is that Microsoft 
uses a proprietari xml format pretending It Is standard xml, while It Is not.  
Format changes continuosly, making It difficult to manage. So It depends on the 
versione of ms .docx. I guess this Will be an issue still in the future. 
https://community.ccleaner.com/topic/23560-judge-orders-microsoft-to-stop-selling-word/

I still don't understand why governments don't make open standards (and open 
source) mandatory.
Paolo  
 
  Il ven, 21 ott, 2022 alle 20:38, Steve Edmonds ha 
scritto:   Hi Susanne.
This is an enrolment document for services from a local doctor.
To me it seems a crazy way to create the document, but seems valid for docx.
Sending direct as attachments are stripped by the list server.

Cheers, Steve

On 22/10/2022 01:07, susanne.mohn...@kiel-pries.de wrote:
> Hi Steve,
>
> normally docx opened in a few seconds in LO.
>
> Try LO7.4. - there the support for DOCX is much better than in LO 7.3
>
> Can you share the docx?
>
> Greetings
> Susanne
>
> -Ursprüngliche Nachricht-
> Von: Steve Edmonds 
> Gesendet: Freitag, 21. Oktober 2022 00:03
> An: LibreOffice User's Help Forum 
> Betreff: [libreoffice-users] State of docx support.
>
> Hi.
> I have received a 2 page document (.docx) that takes about a minute to open 
> in LO 7.3.6 and has some of the items somewhat misplaced (problems with 
> anchoring).
> It opens and prints fine in an online viewer which also produces a PDF which 
> thankfully I can edit in Draw. Is this still quite common opening docx in 
> Writer?
> Steve
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
  

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: AW: [libreoffice-users] State of docx support.

[Steve Edmonds]

Hi Susanne.
This is an enrolment document for services from a local doctor.
To me it seems a crazy way to create the document, but seems valid for docx.
Sending direct as attachments are stripped by the list server.

Cheers, Steve

On 22/10/2022 01:07, susanne.mohn...@kiel-pries.de wrote:

Hi Steve,

normally docx opened in a few seconds in LO.

Try LO7.4. - there the support for DOCX is much better than in LO 7.3

Can you share the docx?

Greetings
Susanne

-Ursprüngliche Nachricht-
Von: Steve Edmonds 
Gesendet: Freitag, 21. Oktober 2022 00:03
An: LibreOffice User's Help Forum 
Betreff: [libreoffice-users] State of docx support.

Hi.
I have received a 2 page document (.docx) that takes about a minute to open in 
LO 7.3.6 and has some of the items somewhat misplaced (problems with anchoring).
It opens and prints fine in an online viewer which also produces a PDF which 
thankfully I can edit in Draw. Is this still quite common opening docx in 
Writer?
Steve


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc - adding up score numbers

[charles meyer]

Hi,

Thanks for the well wishes.

I highlighted the last column with all the total numbers of that judge's
scoring for that judge.

I then drag the highlighted numbers in each cell in each frew for that
column down from the first to the last story.

I right clicked and chose Copy.

I then opened a blank worksheet and there are 2 (two) Paste Specials.

I chose the 1st and it doesn't paste in the numbers so I then chose the 2nd
Paste Special but that didn't paste in the  numbers either.

I'm not sure what's going wrong?

Thanks.

On Fri, Oct 21, 2022 at 1:44 PM Hastham S  wrote:

> Hi Charles
>
> Great to know you are safe.
>
> Regarding the copy paste, I think you are just doing normal Control + C
> and Control + V *which will copy the formulae*
>
> Please try paste special - paste values, when you paste on to the summary
> sheet
>
> Paste values In MS Excel :
> Copy and paste specific cell contents
> 
>
> Copy and paste specific cell contents
>
>
> 
>
> Paste values In Libre Office calc :
> Paste Special
> 
>
> Paste Special
>
> 
>
> Hope this helps
>
> regards
> Hastham / Subu
>
>
>
>
>
>
>
>
>
>
> On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer <
> reachmepl...@gmail.com> wrote:
>
>
> Hi All,
>
>
>
> So grateful to have survived Hurricane Ian and to be able to help others in
> the community.
>
>
>
> It seems Excel isn’t as straight forward as I’d like.
>
>
>
> Perhaps this is easier to do in Calc?
>
>
>
> I opened a blank worksheet and thought I’d create the first column of rows
> with each cell populated with the name each a story. I then created columns
> with the heading of the name of each judge.
>
>
>
> So, 50 rows (each story) and 4 columns comprised of each judge name and
> then the last column named Total for total of points summed from each of
> the judge’s scores.
>
>
>
> When I copy by highlighting all the score numbers from a judge’s total
> score column and the paste those scores into the 1st cell under the column
> for that judge I get #REF! in each cell.
>
>
>
> Is there a way to copy all those judge’s scores from each judge’s scoring
> worksheet and pates them into a column for that judge in a new worksheet so
> I have all the scores from all the judges and in the 4th column I can just
> Click that Z Sum tab to add all 3 scores for each story (and then hopefully
> sort them by highest score to lowest?
>
>
>
> I’ve never taken any Excel nor Calc class which taught this.
>
>
>
> Thank you so much.
>
>
>
> Best,
>
>
>
> Charles.
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] Calc - adding up score numbers

[Hastham S]

 Hi Charles
Great to know you are safe. 

Regarding the copy paste, I think you are just doing normal Control + C and 
Control + V which will copy the formulae
Please try paste special - paste values, when you paste on to the summary sheet

Paste values In MS Excel : 
Copy and paste specific cell contents

| 
| 
|  | 
Copy and paste specific cell contents


 |

 |

 |


Paste values In Libre Office calc : 
Paste Special

| 
| 
|  | 
Paste Special


 |

 |

 |


Hope this helps
regardsHastham / Subu









On Friday, October 21, 2022 at 09:10:07 PM GMT+4, charles meyer 
 wrote:  
 
 Hi All,



So grateful to have survived Hurricane Ian and to be able to help others in
the community.



It seems Excel isn’t as straight forward as I’d like.



Perhaps this is easier to do in Calc?



I opened a blank worksheet and thought I’d create the first column of rows
with each cell populated with the name each a story. I then created columns
with the heading of the name of each judge.



So, 50 rows (each story) and 4 columns comprised of each judge name and
then the last column named Total for total of points summed from each of
the judge’s scores.



When I copy by highlighting all the score numbers from a judge’s total
score column and the paste those scores into the 1st cell under the column
for that judge I get #REF! in each cell.



Is there a way to copy all those judge’s scores from each judge’s scoring
worksheet and pates them into a column for that judge in a new worksheet so
I have all the scores from all the judges and in the 4th column I can just
Click that Z Sum tab to add all 3 scores for each story (and then hopefully
sort them by highest score to lowest?



I’ve never taken any Excel nor Calc class which taught this.



Thank you so much.



Best,



Charles.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
  
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] Calc - adding up score numbers

[charles meyer]

Hi All,



So grateful to have survived Hurricane Ian and to be able to help others in
the community.



It seems Excel isn’t as straight forward as I’d like.



Perhaps this is easier to do in Calc?



I opened a blank worksheet and thought I’d create the first column of rows
with each cell populated with the name each a story. I then created columns
with the heading of the name of each judge.



So, 50 rows (each story) and 4 columns comprised of each judge name and
then the last column named Total for total of points summed from each of
the judge’s scores.



When I copy by highlighting all the score numbers from a judge’s total
score column and the paste those scores into the 1st cell under the column
for that judge I get #REF! in each cell.



Is there a way to copy all those judge’s scores from each judge’s scoring
worksheet and pates them into a column for that judge in a new worksheet so
I have all the scores from all the judges and in the 4th column I can just
Click that Z Sum tab to add all 3 scores for each story (and then hopefully
sort them by highest score to lowest?



I’ve never taken any Excel nor Calc class which taught this.



Thank you so much.



Best,



Charles.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Re: [libreoffice-users] for a given odt, insert new text always in red (corrections)

[Robert Großkopf]

Hi Uwe,

I would do it this way:

Edit → Track Changes → Record
Edit → Track Changes → Show
Tools → Options → LibreOffice Writer → Changes → Insertions
here switch to
Attributes → [None]
Color  → Red

Regards

Robert
--
Homepage: https://www.familiegrosskopf.de/robert


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

[libreoffice-users] for a given odt, insert new text always in red (corrections)

[Uwe Brauer]

Hi

In an already existing odt document I would like to add some text,
however that text should always appear in red (say for corrections).

When I switch to a red font, and set the cursor to a new line, I again
have to activate red.

How can I configure libreoffice so that only new texts appears in red?

Thanks and regards

Uwe Brauer 
-- 
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine. 


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

AW: [libreoffice-users] State of docx support.

[susanne.mohn-lo]

Hi Steve, 

normally docx opened in a few seconds in LO.

Try LO7.4. - there the support for DOCX is much better than in LO 7.3

Can you share the docx?

Greetings
Susanne

-Ursprüngliche Nachricht-
Von: Steve Edmonds  
Gesendet: Freitag, 21. Oktober 2022 00:03
An: LibreOffice User's Help Forum 
Betreff: [libreoffice-users] State of docx support.

Hi.
I have received a 2 page document (.docx) that takes about a minute to open in 
LO 7.3.6 and has some of the items somewhat misplaced (problems with anchoring).
It opens and prints fine in an online viewer which also produces a PDF which 
thankfully I can edit in Draw. Is this still quite common opening docx in 
Writer?
Steve


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy